Querying Exchange Rates
Last updated on 2025-04-29
Overview
You can use a LUCANET formula to query exchange rates in Lucanet and read them in to MS Excel.
Dieser Artikel enthält folgende Abschnitte:
Structure of the LUCANET Formulas
To read in exchange rates from Lucanet to MS Excel, the LUCANET formula must be set up as follows:
=LN.FORMULA NAME("Name of the exchange rate table","Data level","Date")
Formula Name
The formula name specifies the exchange rate to be read into MS Excel. The following formula names can be entered:
Formula name
Description
RATE.CLOSING
Returns the closing exchange rate for a month
RATE.AVERAGE
Returns the average exchange rate for a month
RATE.YTD
Returns the YTD rate of a month
1/LN.RATE.CLOSING
Returns the reciprocal value of the closing exchange rate for a month
1/LN.RATE.AVERAGE
Returns the reciprocal value of the average exchange rate for a month
1/LN.RATE.YTD
Returns the reciprocal value of the YTD exchange rate for a month