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.
the etrade link i provided was redirecting to a log in page.
you can see it by doing this:
go here https://us.etrade.com/e/t/home
middle of page on the left is box for quotes, enter a ticker there - it gives a really long link
but then if you enter another quote, the link shortens to this:
If the above is too cumbersome, I am ok, with using Fidelity.com
there links are straight forward:
stock info: http://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=AGNC
earnings date: http://eresearch.fidelity.com/eresearch/evaluate/fundamentals/earnings.jhtml?stockspage=earnings&symbols=agnc
I have attached a mock up spreadsheet with the req'd 10 fields
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