I have a set of Google Sheets that use GoogleFinance, the sheets can take 10 seconds to fully load the data and update. Most update fine and I can access via the https://opensheet.elk.sh urls.
But sometimes the cache is empty and will not update despite opening the sheet manually and waiting for it to fully load, entering a value in a cell and still nothing. Is there anyway to force the cache to update? Perhaps changing a cell, or doing something with the API or perhaps having a certain function in the cells that keeps the cache updated.
I have a set of Google Sheets that use GoogleFinance, the sheets can take 10 seconds to fully load the data and update. Most update fine and I can access via the https://opensheet.elk.sh urls.
But sometimes the cache is empty and will not update despite opening the sheet manually and waiting for it to fully load, entering a value in a cell and still nothing. Is there anyway to force the cache to update? Perhaps changing a cell, or doing something with the API or perhaps having a certain function in the cells that keeps the cache updated.