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.
Bu iş için 18 freelancer ortalamada ₹6941 teklif veriyor
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 there, I have read your project description and I am confident about your project I can do perfectly. Please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. regard , Us Daha Fazla
good morning ? Hi I done this type of project before and I can guarantee the the work will be done within a day and the without any mistakes and we can go through the sample also looking forward to work with you thank Daha Fazla
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