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

Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

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

Message par Clippy »

Formula for updated currency exchange rates in Excel or other spreadsheets?
Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

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

Message par Clippy »

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 »