create an excel 2010 spreadsheet that does the following
has stock tickers in rows in column A - up to 300 rows needed
goes to: [url removed, login to view]
and grabs the following data, and places the data in columns, in one row per stock, for each ticker in col a:
last price, todays change, next earnings date, beta, dividend yield, dividend freq*, dividend amount, Ex-Dividend Date, Dividend Payable Date
* return M for monthly, Q for quarterly, Y for yearly
so that's 10 columns of data. ALL 10 are req'd. I picked etrade, b/c it has reliable data. Yahoo finance cannot be used.
it needs to auto refresh at open; & every 10 minutes.
that's it - should be pretty straight forward.
18 freelancers are bidding on average $48 for this job
Hi, I am expert for this job. So kindly see my review and contact me to get done it with in few hours. 100% satisfaction is my key... thank you. your satisfaction is my success. muthumuni
I have 5 experience years in Excel VBA, I did manything like this. I'm looking for 1st project in Freelancer, so I'll try my best to do it carefully. Thanks and best regards, Trung Tran
Dear Sir/Madame, I can create a desktop program runnable in Windows OS what will grab the web data each 10 minutes and produce a Excel spread sheet from it. Yours faithfully, Marian Morzol