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.
18 freelancers are bidding on average ₹6941 for this job
Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.
hi, i have good knowlege on microsoft tools and have good experience the various projects on data and database management. i will complete any project in desirable time.
hlo if u are interested for doing work with me..i will assure you that i will give you 100%accurate result..nd i will never be disappointed you. thank you