CURRENCY
The CURRENCY function returns data from the previous market dayβs close about the exchange rate between two currencies, retrieved remotely via the Internet.
CURRENCY(currency-1, currency-2, price)
currency-1: The currency code for the currency from which youβre converting. currencyβ1 is a string enclosed in quotation marks.
currency-2: The currency code for the currency to which youβre converting. currencyβ2 is a string enclosed in quotation marks.
price: An optional modal value specifying the exchange rate attribute to be returned.
"price" (0 or omitted): The exchange rate of currencyβ1 to currencyβ2 at the previous business dayβs market close, expressed as an amount in currencyβ2.
"name" (1): The currency codes of the specified currencies, shown in the formula for calculating the exchange rate.
"change" (2): The difference in the exchange rate at the close of trading on the two most recent business days.
βper cent change" (3): The per cent of change in the exchange rate between the market close on the previous business day and the market close on the business day prior to that.
"open" (4): The exchange rate at the opening of trading on the previous business day.
"high" (5): The highest exchange rate on the previous business day.
"low" (6): The lowest exchange rate on the previous business day.
"52-week high" (7): The highest exchange rate in the last 52 weeks.
"52-week low" (8): The lowest exchange rate in the last 52 weeks.
βask price" (9): The price in currency-2 that sellers are asking for currency-1. Note: Ask price data is currently unavailable.
"bid price" (10): The price in currency-2 that buyers are willing to pay for currency-1. Note: Bid price data is currently unavailable.
Notes
Currency codes are defined by ISO 4217, a standard published by the International Organization for Standardization. You can find the ISO currency codes on the web.
If you enter a formula that includes the CURRENCY function when the Internet is unavailable, CURRENCY returns no value. However, when the Internet becomes available, the formula updates with a value returned by CURRENCY.
To return precious metal futures, use STOCK.
Examples |
|---|
=CURRENCY("USD", "GBP", "price") returns the value of a United States dollar in Pounds sterlingβthe exchange rate between the two currencies, expressed in Pounds sterling, at market close on the previous business day. =CURRENCY("EUR", "DKK", 2) returns the change ("change" or 2) in the exchange rate from the European euro to the Danish krone between the market close of the previous business day and the market close of the business day prior to that. =CURRENCY("eur", "chf", "52-week high") returns the highest rate of exchange from the European euro to the Swiss franc in the past 52 weeks. |
The CURRENCY function is powered by 