# Help refreshing GOOGLEFINANCE data **URL:** \ **Category:** Ask for Help\ **Created:** [June 24, 2022, 1:57am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432 "2022-06-24T01:57:37Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\ **Post date:** [June 24, 2022, 1:57am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/1 "2022-06-24T01:57:38Z")
I have downgraded from PRO to BASIC as I simply did not need all the features of PRO. However, one feature I overlooked was the auto refresh. Now my GOOGLEFINANCE data no longer flows into the app automatically (i.e. GLIDE no longer refreshes periodically in the background). While that is not ideal, I can live with it if there was a “easy button” I could have in the app that would simply fetch the latest data. I hate to go to PRO as this app is purely for personal reasons. That is also why I could no longer justify the PRO cost, since it is just me using it, and downgraded to basic. But if I cannot refresh, basic is useless and GLIDE is likely no longer the answer for me sadly. Any ideas? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [June 24, 2022, 6:16am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/2 "2022-06-24T06:16:24Z")
Glide stops refreshing google since they change to new plans… so even if you pay, it will be hard to get… just add a button that writes the current date to some google sheet column, and that will force Glide to sync. ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [June 24, 2022, 7:19am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/3 "2022-06-24T07:19:15Z")
I use a switch in my Google finance app: > **[FAAMG](https://gangofbigfive.glideapp.io)** > > Gang of Big Five Stock Performance function onChange(e){ var sheet = SpreadsheetApp.getActive(); var range = sheet.getRange(“J2”); var check = range.getValue(); var time = sheet.getRange(“J3”); if (check == 1) { range.uncheck(); time.setValue(new Date()); } } ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 25, 2022, 3:12am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/4 "2022-06-25T03:12:01Z")
Hi Craig, If you don’t mind using Yahoo Finance instead of Google I think you can try this. - Have a list of symbols. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a0282c397436cd91cace8ba7be7d55f417d4bb3.png) - Create a template to construct the Yahoo link. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c81f1ad924b1a0f04d85218873bcef3fa53b69c.jpeg) ```auto https://cors.eu.org/https://query1.finance.yahoo.com/v8/finance/chart/{X} ``` with {X} being the symbol. The prefix `https://cors.eu.org/` is for overcoming the CORS issue to fetch the data. - Use a fetch column to get the price. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96974c31f5f1dbe1aa334b950e8cef4d2fa4e148.png) I’m not sure if this refreshes regularly. If it doesn’t, I would suggest adding a timestamp value to the URL (e.g ?t=[current time in numeral value]) so that it refreshes regularly. You might not want to do it every 10 seconds based on Glide’s update interval, maybe 10-15 minutes or an hour would do. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [June 25, 2022, 4:38pm UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/5 "2022-06-25T16:38:03Z")
> [@ThinhDinh](#): > > I would suggest adding a timestamp value to the URL (e.g ?t=[current time in numeral value]) so that it refreshes regularly. Thind, that _timestamp parameter_ to refresh info regularly is something native to Yahoo API or a trick? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [June 25, 2022, 4:45pm UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/6 "2022-06-25T16:45:27Z")
> [@Craig\_Greiner](#): > > However, one feature I overlooked was the auto refresh. Now my GOOGLEFINANCE data no longer flows into the app automatically (i.e. GLIDE no longer refreshes periodically in the background). Yes, an auto refresh tool we don’t have yet to refresh data in background. My best effort to have something like it is this: [Automatic Toggle Trigger 💡](https://community.glideapps.com/t/automatic-toggle-trigger/37324) but of course, your APP must be loaded and running! Saludos! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 25, 2022, 11:38pm UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/7 "2022-06-25T23:38:04Z")
That is a general trick I have done since my days of using IMPORT to get data into Google Sheets. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [June 26, 2022, 12:25am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/8 "2022-06-26T00:25:45Z")
😳 May you type a couple of examples to learn that trick? Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 26, 2022, 12:40am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/9 "2022-06-26T00:40:36Z")
Say I have a link to fetch that looks like this: ```auto https://example.com?query=abc ``` Next, in the Glide builder, I add a math column to derive the current time in numeral format. ```auto YEAR(N)*10000000000+MONTH(N)*100000000+DAY(N)*1000000+HOUR(N)*10000+MINUTE(N)*100+SECOND(N) ``` It will return a numeral value in the format of YYYYMMDDhhmmss. Let’s say my current time is 07:38:59 AM, 26th June 2022 then that value will be 20220626073859. Then, I add a “t” parameter to that link so that it will refresh every time Glide’s “current time” changes. ```auto https://example.com?query=abc?t={T} ``` with {T} being the math value I calculated above. That will change every 10 seconds or so, hence a new fetch is done by Glide since the link is changed. The “t” param can be whatever text you want, as long as it is considered “harmless” for the structure (the website doesn’t use it as a normal param) ---
**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 26, 2022, 2:09am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/10 "2022-06-26T02:09:13Z")
> [@gvalero](#): > > Thind, that _timestamp parameter_ to refresh info regularly is something native to Yahoo API or a trick? It’s a technique that’s commonly known as [cache-busting](https://www.curtiscode.dev/post/front-end-dev/what-is-cache-busting/) ---
**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 26, 2022, 2:17am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/11 "2022-06-26T02:17:28Z")
hah! @ThinhDinh - getting off topic here, but it just occurred to me that this would probably be an effective method to force an update of an app icon. ie. just load the app in a browser and add a random query string to the end of the URL 🙂 …although, I suppose that still counts as re-installing the app. But sometimes the old icon will persist even after a re-install, because it’s still cached in the device browser. So this would overcome that issue and avoid having to completely clear the browser cache. Edit: Scratch the above. I tested and it doesn’t work. 🤪 You can add random parameters and the app loads, but the extra parameters are stripped when you add to home screen, and so you wind up with the original URL. At least with Safari on IOS. Edit 2: duh, of course this won’t work, on any device or in any browser. The only way it would work is if you could append a random query string to the direct URL of the icon image file. ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [June 9, 2024, 7:09am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432/12 "2024-06-09T07:09:09Z")
Here is the new Glide Page version: [https://gangofbigfive.glide.page/](https://gangofbigfive.glide.page/)