Formula for updated currency exchange rates in Excel or other spreadsheets?
Problem
What kind of spreadsheets support a formula like the following: The result should be 3000 USD exchanged into Euros. Possibly a date could be provided for a historic exchange rate. Alternatively, the average for the last month or so. I would use such a feature all the time and it has to be relevant for so many other users. I prefer working in Excel, but online spreadsheets like Google or Zoho is also fine.
Error Output
=exchangeCurrency("USD"; "EUR"; 3000)Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Formula for updated currency exchange rates in Excel or other spreadsheets?
In Google Spreadsheets, getting current exchange rates is very easy with the built-in Google Finance querying function. E.g, to get the current rate for USD/EUR: This will work for all exchange rates Google Finance is tracking. See https://www.ablebits.com/office-addins-blog/2017/11/30/currency-conversion-google-sheets/ for more examples.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix