Formula for updated currency exchange rates in Excel or other spreadsheets?

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Formula for updated currency exchange rates in Excel or other spreadsheets?

Message par ForumBot »

Formula for updated currency exchange rates in Excel or other spreadsheets?
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Formula for updated currency exchange rates in Excel or other spreadsheets?

Message par ForumBot »

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.
Répondre

Revenir à « Excel & VBA »