Find out how to use the GOOGLEFINANCE function to get the current currency exchange rates or the rates over some period of time in Google Sheets. You'll get to know what arguments the function has and how to manage them easily. Continue reading
Comments on: How to calculate currency exchange rates in Google Sheets with GoogleFinance
by Alexander Trifuntov, updated on
Table of contents
Comments page 2. Total comments: 57
Awesome Post
Many thanks for the insigth!
This is a great article thank you.
Is it possible to have the exchange rate update only values entered today?
Hence any historical calculations using the exchange rate wouldn't be changed by the new exchange rate?
Thank you for your feedback, William.
The result changes depending on the attributes you select. You can find the full list here.
If you use attributes for realtime data, depending on your choice, the result will be updated every now and then.
If you use attributes for historical data and specify exact dates, the result will be returned once and won't change in the future.
Amazing. This sorted my problem out in ten seconds. Perfect solution, thank you.
Houston, we have a problem or two!
This doesn't seem to work in my Google Sheets.
In addition: it is unfortunate to include fixed currency names as parameters. What I mean?
I have the base currency in a specific cell and the currency to convert to in other cell. So I need googlefinance("CURRENCY:$cellx$celly") or something like this.
Sorry to hear the formula doesn't work. Please make sure you enter all parts correctly, i.e. ("CURRENCY:"&$A$2&A6, ...)
You can check this function help page for lots of examples.
I want to try this soon. But, I don't think if I can do it! Thanks for sharing this idea! I will follow these instructions, also will share it with my friends!
Hi,
This is an incredibly useful article, especially for those of us new to Google Finance. Thank you.
I am trying to match the dates on historical USD/GBP rates with those of historical stock prices. Unfortunately there is a currency entry 7 days a week, whilst stock prices are only given when the market is open, so typically 5 entries per week. The dates in the two columns get quickly out of sync. Is there a way around this please?
Many thanks
David
I am looking to use a currency code that is not listed in the GOOGLEFINANCE exchange list. The currency is kwacha to USD. Is there a way to insert the exchange rate in google sheets?
Hi, Joe,
Zambian kwacha code is ZMW.
Just put it into your formula along with USD and you'll get the conversion rate.
How to do to have in a cell in google sheet with today USD currency ?
Thank you for your help
Hi,
Thank you for sharing this useful formula.
I have some trouble to use it, and I would like to know if there is a solution to my problem.
On my google sheet, I have a column for our delivery dates. It's not daily nor monthly, it depends on our customers.
I would like to have the currency exchange rate on a 2nd column, using dates from the first one, and extend the function so when we put a new date, the currency exchange rate appear automatically.
For the moment I have two problems:
- When I use the formula to refer to a specific date (using the cell instead of the date), the result takes 4 cells because it creates the table date/close that we can see on your examples. So I can't extend the formula to have a column of rates corresponding to the column of dates.
- If I use the formula by indicating the column of dates, it creates a table date/close with daily results from the oldest date to the newest (dates are not in order in our column, depending on when we bill the customer), it means that if I have two order separated by 10 days, I will have a date/close table with 10 lines.
I spent two hours trying to "play" with the formula, but perhaps you can avoid me a headache!
Best regards,
Eric