FRRATE
Syntax
FRRATE(functional currency, source currency, rate type, date, rate option)
Description
The FRRATE function returns the exchange rate for converting amounts from the source currency to the functional currency as a multiplier. (In other words, if the rate is defined as a divisor, ACCPAC provides its reciprocal.)
Arguments
functional currency
The functional currency code.
source currency
The source currency code.
rate type
The rate type code.
date
Optional. Financial Reporter uses the period-end date of the report fiscal period if not specified, or it uses the session date if the report is not generated from a specification (i.e. there is no period-end date). The date is specified as DATE(YYYY,MM,DD). Note that DATE() is a spreadsheet function that returns the serial number of the date.
The date formats in some versions of Excel are set to jj/mmm/aa instead of dd/mmm/yy if you choose Canada[English] for the country setting in the Windows Control Panel. If you have problems with dates in your statements, choose the International icon from the Control Panel, and select US or Other Country instead of Canada.
rate option
Optional. This parameter is only required for handling the exchange rates which involve euro-member currencies that use the Euro Conversion Rates table (such as francs or schillings). You do not have to use it to get exchange rates from the currency rates table.
The rate option lets you choose which portion of the euro-member-currency to non-euro-currency exchange rate you want to the function to provide.
RF returns the floating portion of the exchange rate — i.e. the portion not fixed between the euro and non-euro-member currencies. (RF returns a "1" if the currencies are euro-member, and the year is greater or equal to 1999.)
RC returns the composite exchange rate (the effective rate between a non-euro currency and a euro-member currency). This is the default if no parameter is specified.
Considerations:
-
For non-euro currencies, RC will look up the rate in the Currency Rate table.
-
If the source currency and functional currency are both euro-member currencies, RC will return the rate obtained from the Euro conversion table.
-
If the functional currency is the euro, and the source is not a euro-member currency, RC will return the effective exchange rate between the two currencies.
-
The last example, below, shows the floating exchange component between the Austrian schilling and the US dollar — which is rate between the euro and the dollar.
Results
FRRATE returns the exchange rate as a multiplier given the information you provide.
Examples
|
This statement |
Returns this |
|
FRRATE("USD","CAD","AV") |
.75 |
|
FRRATE("USD","CAD","SP", |
.75 |
|
FRRATE("USD","CAD","SP", |
.75 |
|
FRRATE("ATS","EUR","AV", DATEVALUE(FRFISCAL("Start")),"RC") |
13.760300 |
|
FRRATE("USD","ATS","AV", DATEVALUE(FRFISCAL("Start")),"RF") |
.88274 |
DATEVALUE is a spreadsheet function that converts a textual representation of the date to a serial number which FRRATE accepts. (FRFISCAL provides the date in text format.)
See also