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
I wish to use historic currency data in one of my apps - I have made the code work in the Googlesheet to give a list of weekly rates for any given year,
What I want to be able to do is to allow my users to input a year and let the data be imported for that year and then just work out the average for the year - simple
In order for that to happen, the date format formats have to be eg DATE(2017,1,1), DATE(2017,12,31),
so If they are asked to enter the year they have to enter 2017,1,1. What I want them to do is just enter the year (in my example in cell A1 and let the sheet add the 1,1 & 12,31 - I can do that easily =A1& “,1,1” and A1& “,12,31” but I cannot find a way to substitute it in the Googlefinance cell
=GOOGLEFINANCE(“CURRENCY:GBPEUR”, “price”, DATE(2017,1,1), DATE(2017,12,31), “WEEKLY”)
So my attempt - and I have tried other versions!
=GOOGLEFINANCE(“CURRENCY:GBPEUR”, “price”, DATE(A1), DATE(A2), “WEEKLY”)
Any ideas ???
Thanks
The following works for me:
=GOOGLEFINANCE("CURRENCY:GBPEUR", "price", DATE(K4,1,1), DATE(K4,12,31), "WEEKLY")
1 Like
Hi
Thanks for that - very neat…
Now is it possible for user to key in a year and a month to get just one result ?
I can use the formula that you have offered and display for the whole year and then get an average but would be amazing if I could just get the figure for a particular month
Thanks again
All sorted - I engaged my brain!
Loving Glide
oh, sorry I missed your follow up question. Glad you got it sorted 