Extract details from web page — 2
Project detail
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.