Currency

 

Syntax: CURRENCY(FromCurrency, ToCurrency, Fields, FromDate, ToDate, AutoFormat)

 

Equivalent Function Names: Ccy

 

Purpose: The function displays the market data history for a currency pair.

 

Parameters: 
 

1.FromCurrency, ToCurrency are ISO Currency Codes, e.g. "USD"
 

2.Field(s) may be optional for a given operation.

For current exchange rates:

 

Field Primary Name

Field Synonyms

Field Definition

"DATE"

"DT","D"

 

"LAST_TRADE_PRICE"

"PRICE", "P"

 

 

          For historical exchange rates:

Field Primary Name

Field Synonyms

Field Definition

"DATE"

"DT", "D"

Date of the record

"LAST_TRADE_PRICE"

"PRICE", "P"

Exchange rate stored last for the particular day, defined as a UTC day

"CLOSE"

"C"

Exchange rate defined as the rate of about 1700 GMT.

"HIGH"

"H"

Max value for a UTC day, measured at 5 minute intervals

"LOW"

"L"

Min value for a UTC day, measured at 5 minute intervals

 

          Close, High, and Low are provided only for the USD, EUR, JPY, GBP, AUD, CHF, CAD, HKD, SEK, NZD.

 

3.Parameter ReferenceFromDate and ReferenceToDate may be optional for a given operation. If provided, it can be specified either as an Excel date or in the text format "yyyy-MM-dd", e.g. "2013-02-25".

The time range can be entered using relative time periods, see here.
 

4.AutoFormat - an optional flag signifying if the result should be automatically converted to a range and if the result should be automatically formatted as Excel Data Types
 

Examples:

1. Display the Current Exchange Rate between two currencies

=CCY("USD","EUR")

 

 

 

2. Display Historical Exchange Rate between two currencies with the date

=CCY("USD","EUR",,"2013-12-20","2013-12-20")

 

 

3. Display Historical Exchange Rate between two currencies without the date

=CCY("USD","EUR","p","2013-12-20","2013-12-20")

 

4. Display Historical Exchange Rate between two currencies between two dates

=CCY("USD","EUR",,"2013-01-20","2013-12-20")

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017