Googlefinance

I am using GOOGLEFINANCE to bring in FX rates. It works perfectly in my Google sheet, updates on a regular basis. The issue is that it is not updating in Glide data sheet unless I press reload sheet.
Should I expect a delay ?

Thanks

Add a column for a Switch and simply toggle it when you need updates.

That’s not an option - sorry .
My users need to see up to date FX rates on the app - I need to find a solution that will update the Glide data on a regular basis withoiut having to do it manualy

Even Google Sheets show a warning when you use Google Finance, saying that the rates will not be real-time. Reading that data in Glide is another layer of latency.

I Know that there is a delay to update the data in Google sheets but it is quick enough.
The delay into Glide seems to be very long - I’ve no idea how long - which is the problem

Upgrade to Pro and turn on background refresh to have it auto update the app.

https://docs.glideapps.com/all/guides/quick-starts/getting-started/background-refresh#refresh-pro

2 Likes

Ok

1 Like