We need to extract the historical price, volume and quarterly financial data from Yahoo!Finance for a given list of stocks.
The perfect solution would allow:
1) A tab where we can list up to 2000 securities to be included for request
2) A button-click option to initiate the request on demand
3) Have all the CSV files aggregated into one Excel Workbook with common name structures like "AAPL-HistoricalPrice" and "AAPL-QTRFinancials" etc.
4) If we include an ETF or something that does not have historical Financial Data (Balance Sheet, Income Statement, Cash Flows, etc.) then we still want the historical price and volume data requested)
We previously had this setup for historical price data, but after a few months the coding stopped working.
Attached are the sample files that would need to be requested.
7 freelancere byder i gennemsnit $3/timen for dette job
My typing speed is one of my great assest. I have been Playing with Microsoft office for more than 4 Years. I have researching in markert for 2 years. So It will benifits you to get on time the data and source.