# Googlefinance **URL:** \ **Category:** Ask for Help\ **Created:** [August 5, 2020, 8:00pm UTC](https://community.glideapps.com/t/googlefinance/13620 "2020-08-05T20:00:50Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [August 5, 2020, 8:00pm UTC](https://community.glideapps.com/t/googlefinance/13620/1 "2020-08-05T20:00:50Z")
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 ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [August 5, 2020, 8:27pm UTC](https://community.glideapps.com/t/googlefinance/13620/2 "2020-08-05T20:27:38Z")
Add a column for a Switch and simply toggle it when you need updates. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [August 5, 2020, 8:44pm UTC](https://community.glideapps.com/t/googlefinance/13620/3 "2020-08-05T20:44:51Z")
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 ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [August 5, 2020, 8:47pm UTC](https://community.glideapps.com/t/googlefinance/13620/4 "2020-08-05T20:47:01Z")
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. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [August 5, 2020, 8:51pm UTC](https://community.glideapps.com/t/googlefinance/13620/5 "2020-08-05T20:51:04Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 5, 2020, 9:01pm UTC](https://community.glideapps.com/t/googlefinance/13620/6 "2020-08-05T21:01:44Z")
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](https://docs.glideapps.com/all/guides/quick-starts/getting-started/background-refresh#refresh-pro) ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [August 5, 2020, 9:06pm UTC](https://community.glideapps.com/t/googlefinance/13620/7 "2020-08-05T21:06:38Z")
Ok ---
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [June 29, 2021, 4:20pm UTC](https://community.glideapps.com/t/googlefinance/13620/8 "2021-06-29T16:20:47Z")
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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 29, 2021, 4:33pm UTC](https://community.glideapps.com/t/googlefinance/13620/9 "2021-06-29T16:33:09Z")
The following works for me: ```auto =GOOGLEFINANCE("CURRENCY:GBPEUR", "price", DATE(K4,1,1), DATE(K4,12,31), "WEEKLY") ``` ![Screen Shot 2021-06-30 at 12.32.39 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b731f6ebc1acef4cd9ec15a24b575135ef7ef8c.png) ---
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [June 29, 2021, 6:35pm UTC](https://community.glideapps.com/t/googlefinance/13620/10 "2021-06-29T18:35:36Z")
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 ---
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [June 30, 2021, 6:25am UTC](https://community.glideapps.com/t/googlefinance/13620/11 "2021-06-30T06:25:37Z")
All sorted - I engaged my brain! Loving Glide ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 30, 2021, 6:57am UTC](https://community.glideapps.com/t/googlefinance/13620/12 "2021-06-30T06:57:11Z")
oh, sorry I missed your follow up question. Glad you got it sorted 👍