I have worked with the Yahoo Finance API and can fix the issue you are facing. Alternatively, I can extract the required data from Alphavantage, Barchart or Quandl any other site you prefer.
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance
- Built a POS and inventory management system
- Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources
- Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites
- Buy and sell bitcoins on Coinfloor and GDAX using respective APIs
- Built a hotel price comparison that pulls data using the website's API
- Scrape various websites like tennisinsight, pubmed
You can see the reviews of the same in my profile
Thanks,
Archana