|
Get Daily Rate |
Returns the daily exchange rate for the entered criteria.
| Parameter | Description |
| FromCurrency | The “From” currency code as configured in Oracle all in upper case e.g. “USD”. |
| ToCurrency | The “To” currency code as configured in Oracle all in upper case e.g. “USD”. |
| ConversionType | The conversion type as configured in Oracle. Spelling and case must be identical to the Oracle configuration. |
| ConversionDate | The conversion date. This must be in Excel date format. Either refer to a cell which contains a date or use one of the Excel date functions to return a date in the parameter. |
Example =Get_Daily_Rate("USD","GBP","Reporting",DATE(2009,1,1))