Refreshing Data
Google Sheets
Excel
Google Sheets does not allow plug-ins to automatically refresh data. The following methods can force Google Sheets to fetch new data.
1. Create a check-box in in
A1
. Do this by selecting Insert -> Checkbox2. Update all ART function calls to include an additional parameter referencing this cell
A1
For example,
=ART("BTC", "PRICE", "2022-01-01")
becomes=ART("BTC", "PRICE", "2022-01-01", $A$1)
For fetching live price data, use a
""
to make the parameter empty. For example, =ART("BTC", "PRICE")
becomes:=ART("BTC", "PRICE", "", $A$1)
3. Uncheck / recheck
A1
to refresh data
Any time cell A1 is checked or unchecked, the data in the =ART cells will refresh.
Create / Delete Rows (less recommended)
If you create a new row that moves the location of a cell containing an
ART
function, the ART
function will refresh. You can then immediately delete that row. 
Refreshing data in Excel - use the Ribbon menu