This script will pull stock data from the Yahoo Finance API and inserts it into an existing Google Sheets workbook.
Script can be automated to run on a specific cadence on a local machine with task scheduler or cron.
Workbook contains master Worksheet (with cell references) which compares performance side-by-side between tickers.
Example of raw data pushed by python
Example of individual company sheet
