Using Google Sheets script to check a cache sheet for each key-CodePudding

Home > Software design > Using Google Sheets script to check a cache sheet for each key

Using Google Sheets script to check a cache sheet for each key

Time：05-31

I am pulling stock market data from Yahoo! Finance. For data that does not change often, I do not want to contact Yahoo! each time, but source data from a db sheet that acts as a cache:

yahoofinance() is called per ticker from 'Dashboard' sheet
yahoofinance() calls db_data to see if data for ticker is available in db

I have an example sheet

Page link：https//www.codepudding.com/Softwaredesign/424851.html

Prev:Deleting empty rows on if the row in Column D is empy

Next:I need to remove the header rows(?) from my filtered and copied data in Google Sheets

Tags：

javascript

google-apps-script

google-sheets

Links：
CodePudding