Formula for updated currency exchange rates in Excel or other spreadsheets?
Formula for updated currency exchange rates in Excel or other spreadsheets?
Formula for updated currency exchange rates in Excel or other spreadsheets?
Re: 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:
```
=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/](https://www.ablebits.com/office-addins-blog/2017/11/30/currency-conversion-google-sheets/) for more examples.
```
=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/](https://www.ablebits.com/office-addins-blog/2017/11/30/currency-conversion-google-sheets/) for more examples.