Formula for updated currency exchange rates in Excel or other spreadsheets?
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Take control of your privacy with Proton's trusted, Swiss-based, secure services.
Choose what you need and safeguard your digital life:
Mail: https://go.getproton.me/SH1CU
VPN: https://go.getproton.me/SH1DI
Password Manager: https://go.getproton.me/SH1DJ
Drive: https://go.getproton.me/SH1CT
Music by Eric Matyas
https://www.soundimage.org
Track title: Riding Sky Waves v001
--
Chapters
00:00 Formula For Updated Currency Exchange Rates In Excel Or Other Spreadsheets?
00:34 Answer 1 Score 29
02:57 Accepted Answer Score 98
03:19 Answer 3 Score 3
03:45 Answer 4 Score 1
04:06 Thank you
--
Full question
https://superuser.com/questions/286192/f...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #googledocs #worksheetfunction
#avk47
ACCEPTED ANSWER
Score 98
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:
=GoogleFinance("CURRENCY:USDEUR")
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.
ANSWER 2
Score 29
Here are some options for you:
GOOGLE SPREADSHEETS
There's a Google Spreadsheet script that returns the exchange rate between EURO and a currency that you specify. Data is supposedly from the European Central Bank.
Setup:
Open a Google Docs Spreadsheet.
Click Insert > Script > Search for ECBExchangeRate
Install it.
Usage:
=ECBExchangeRate("mm.dd.yyyy", "USD")
** With quotes on the date
This will return the exchange rate between USD and EUR for the date mm/dd/yyyy. Unfortunately, the data source isn't updated.
Calculating between 2 Currencies:
For example, we want to get the USD/JPY rate for today. Get EUR/USD and EUR/JPY using the formula above. Divide the EUR/JPY rate by the EUR/USD rate. You get USD/JPY.
EXCEL
I don't believe such a function exists for Excel (at least by default). You can, however, set up a sheet that imports data from an online exchange rate table like the one on the Yahoo Finance page (finance.yahoo.com > Investing > Currencies > Currencies Investing > Cross Rates).
You can then setup a VLOOKUP or INDEX/MATCH formula to get the relevant exchange rates for you.
Setup:
Create a new sheet (recommended).
Click Data > From Web > Enter the following URL:
http://finance.yahoo.com/currency-investing#cross-rates
Click the yellow arrow beside the exchange rate table. The arrow should turn into a green check mark. Click Import.
Click Properties. Under Refresh Control, specify how often you want Excel to retrieve new data, or pick Refresh data when opening the file. Click OK then wait for Excel to load the data.
To refresh the data, just hit Ctrl-Alt-F5.
Here's a sample spreadsheet:
The data on the Yahoo Finance Page is pretty limited, but it covers the most popular currencies. You can use other sources, such as:
http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html
The website http://www.xe.com/ucc/ has historical rate tables which you can consolidate.
ANSWER 3
Score 3
This Excel spreadsheet connects to a web service (Oanda) to automatically download historical exchange rates.
http://investexcel.net/222/automatically-download-historical-forex-data-into-excel/
The VBA is exposed, so you can hack away at the code I wrote. You should be able to create a function like
=exchangeCurrency("USD"; "EUR"; 3000)
which uses an 30-day average exchange rate or something.
ANSWER 4
Score 1
I have been using the plugin below for quite some time. Works great for me. It uses Yahoo API and MSN money website to get live currency rates in Excel exposed as custom functions. i.e. =Fx_Convert(100,"USD","EUR")