Querying Exchange Rates

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

User Interface of Lucanet Consolidation & Financial Planning

General Functions

Basic Configuration

Dashboards

Reporting & Analyzing

Import and Journals

Planning

Consolidation

Dimensions

Excel-Integration

Lucanet.Excel-Reporting

CFP Add-in for Excel 365

Installing the CFP Add-In for Excel 365

Querying Data from Lucanet

LUCANET Formulas

Querying Values

Querying Exchange Rates

Querying Comments

Querying Attributes

Transferring Data from MS Excel to Lucanet

Troubleshooting Guide

Migrating From Integrated Excel.Add.-in to CFP Add-in for Excel 365

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

You can use a LUCANET formula to query exchange rates in Lucanet and read them in to MS Excel.

To read in exchange rates from Lucanet to MS Excel, the LUCANET formula must be set up as follows:

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