---
title: "Querying Exchange Rates"
description: "You can use a LUCANET formula to query exchange rates in Lucanet and read them in to MS Excel."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-exchange-rates
language: en
last_updated: 2023-08-16
---
# Querying Exchange Rates

## Overview

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

## 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 |