# Live Currency Conversion Rates **URL:** \ **Category:** Ask for Help\ **Created:** [January 6, 2025, 7:34pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014 "2025-01-06T19:34:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Ja\_ke](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ja_ke/32/83176_2.png) [@Ja\_ke](https://community.glideapps.com/u/Ja_ke)\ **Post date:** [January 6, 2025, 7:34pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/1 "2025-01-06T19:34:07Z")
Is there a way to get live (or updated daily, or even weekly) currency conversion rates into the app? With the rate the math would be easy to do, but how to get them in there in the first place? I tried using a google sheet with the googlefinance function but it doesnt recognize the formulas unfortunately. I have to assume there is some native way to do this, but havent found anything written anywhere. I found a video that Jeff had linked in another forum post, but that person was using a glide table with a value written in that i imagine he was manually updating? Any tips? ---
**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:** [January 6, 2025, 8:37pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/2 "2025-01-06T20:37:33Z")
> [@Ja\_ke](#): > > I tried using a google sheet with the googlefinance function but it doesnt recognize the formulas unfortunately. Can you explain how you tried to do this? The formula would need to be entered in the google sheet. Not the through glide. > [@Ja\_ke](#): > > video that Jeff had linked in another forum Can you provide a link to that post? > [@Ja\_ke](#): > > I have to assume there is some native way to do this, but havent found anything written anywhere The native way would be to call an API to retrieve current rates from some kind of public API. ---
**Author:** ![Ja\_ke](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ja_ke/32/83176_2.png) [@Ja\_ke](https://community.glideapps.com/u/Ja_ke)\ **Post date:** [January 6, 2025, 8:44pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/3 "2025-01-06T20:44:08Z")
> [@Jeff\_Hager](#): > > Can you explain how you tried to do this? The formula would need to be entered in the google sheet. Not the through glide. Yes i created a google sheet, put the googlefinance function in (and it showed correctly in the sheet), but when i linked the sheet to glide it only showed column headers and where the rate should have been it showed a blank cell. > [@Jeff\_Hager](#): > > Can you provide a link to that post? > [@Currency conversion](https://community.glideapps.com/t/currency-conversion/59263): > > Dear Comumunity: I need help whit this: I have in my table a list of products which have a price for each row. How I can automatically convert the price to a specific currency without having to write that value in each row each time it is updated. Here is the post. It was actually not you who linked the video, but responded to it. My Apologies. > [@Jeff\_Hager](#): > > The native way would be to call an API to retrieve current rates from some kind of public API. Ok, I will learn to use API calls then it seems. 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:** [January 7, 2025, 1:31am UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/4 "2025-01-07T01:31:05Z")
The nature of the “currency conversion” might consume a lot of updates if you want up-to-the-minute rates. > **[Free Currency Conversion and Forex Exchange Rate API](https://currencyfreaks.com/)** > > Free Currency Conversion API and Forex Exchange Rates data through REST API in JSON and XML format. Something like this claims to offer 1000 API calls/month for free, maybe you can start experimenting with it. ---
**Author:** ![Ja\_ke](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ja_ke/32/83176_2.png) [@Ja\_ke](https://community.glideapps.com/u/Ja_ke)\ **Post date:** [January 9, 2025, 9:07pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/5 "2025-01-09T21:07:39Z")
> [@ThinhDinh](#): > > The nature of the “currency conversion” might consume a lot of updates if you want up-to-the-minute rates. Yes this was one of my main concerns, and the google sheet syntax includes a refresh rate that you can specify as Daily which was perfect for me. I am looking at the possibility of triggering an API call to update currency rates when a button is pressed in the app, or on a scheduled time via workflow. I have not used API calls before though so not sure what is or is not possible yet. ---
**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:** [January 9, 2025, 11:49pm UTC](https://community.glideapps.com/t/live-currency-conversion-rates/79014/6 "2025-01-09T23:49:48Z")
![CleanShot 2025-01-10 at 06.48.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e741ba849a943329cd4a851d84ba63547164a8f5.png) I’m not sure how well it works, but the Call API column offers a “refresh after” param that you might be able to use. Button that calls a workflow should work too, and if you have access to scheduled workflows, that might work better for your use case since you know exactly how many updates you would consume.