You can access the daily FX rate for a given currency pair with this formula. You can also access the rate as of a historical date and the average of a historical date range.
=TEGUS.FX(Base Currency, Quote Currency, [End Date])
Base Currency
This argument defines the currency of the data you would like to convert. Enter the 3 letter currency code here to complete this argument. See available currency codes below.
Currency | Code |
Argentina Pesos | ARS |
Australia Dollars | AUD |
Bermuda Dollars | BMD |
Brazilian Real | BRL |
Bulgaria Leva | BGN |
Canada Dollars | CAD |
China Yuan Renminbi | CNY |
Colombia Pesos | COP |
Croatia Kuna | HRK |
Czech Republic Koruny | CZK |
Denmark Kroner | DKK |
EU Euro | EUR |
Hong Kong Dollars | HKD |
Hungary Forint | HUF |
India Rupees | INR |
Indonesia Rupiahs | IDR |
Israel New Shekels | ILS |
Japan Yen | JPY |
Kuwait Dinars | KWD |
Malaysia Ringgits | MYR |
Mexico Pesos | MXN |
New Zealand Dollars | NZD |
Norway Krone | NOK |
Peru Nuevos Soles | PEN |
Poland Zlotych | PLN |
Romanian Leu | RON |
Russian Ruble | RUB |
Saudi Arabia Riyals | SAR |
Singapore Dollars | SGD |
South Africa Rand | ZAR |
S. Korea Won | KRW |
Sweden Kronor | SEK |
Switzerland Francs | CHF |
Thailand Baht | THB |
UAE Dirhams | AED |
US Dollar | USD |
UK Pounds | GBP |
Viet Nam Dong | VND |
Quote Currency
This argument defines the currency that you would like to convert financial data to. Enter the 3 letter currency code here to complete this argument. See available currency codes in the Base Currency section.
Optional Arguments
The following are not required to build an FX formula but may be included to refine the output. If you do not define these arguments, the formula can still be created and will point to the most recent daily FX rate.
Date (Historical FX Rate)
When this argument is used in an FX formula it will return the daily FX from that date. It can also be used in conjunction with the 4th argument to pull an average FX rate.
This argument accepts most date formats. We do not recommend using time based Excel functions like TODAY() or NOW() for this argument because these will cause Tegus Formulas to constantly recalculate. This will clear undo history for all workbooks you’re working on and can make Excel run slower.
End Date (Average FX Rate)
The 4th argument can be used in conjunction with the 3rd argument to define an average FX rate from a historical date range. You must also define the 3rd augment (Date) to pull an average FX rate.
This argument accepts most date formats. We do not recommend using time based Excel functions like TODAY() or NOW() for this argument because these will cause Tegus Formulas to constantly recalculate. This will clear undo history for all workbooks you’re working on and can make Excel run slower.