This is a straightforward data entry project, get data from different columns of [url removed, login to view] and enter in a spreadsheet.
1). Enter stock symbol in the box on top of page [url removed, login to view] and click on 'Quote'
2). Get the value for column 'Yield' on this home page
2). Click on 'Performance' Tab
3). Get data from 5 columns and enter in spreadsheet attached.
4). There are 2 columns at end - Column K and Column L - these are in the 'Ratings and Risk' tab, these are available only for rows 3 to 11 and 53 to 69
Name Ticker Sector Yield 2008 2009 2010 2011 YTD Total Return - 3 Yr Risk - 3YR
(Sector info is on performance page, see examples in spreadsheet. Total Return - 3 Yr is on the bottom on performance page).
Attached spreadsheet has 2 examples. Please use the same sheet, you can use any version of excel.
There are 60 rows in the spreadsheet and 12 columns. (40 rows have data for 10 columns and the other 20 rows has 12 columns).
Project should take around 1.5-2 hrs max. I need this in a couple of days.