> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FX Rate

Download sample file: [fx-rate.tsv](../tsv/fx-rate.tsv)

This file provides FX spot rates used for currency conversion.

| Field          | Key                                            | Nullable | Type   | Description                            | Example |
| -------------- | ---------------------------------------------- | -------- | ------ | -------------------------------------- | ------- |
| **AsOfDate**   | Y                                              | N        | Date   |                                        |         |
| 'YYYY-MM-DD'   | Timestamp (at close of business) for the data. |          |        |                                        |         |
| **BaseCcy**    | Y                                              | N        | String | The left side of the currency pair.    |         |
| **CounterCcy** | Y                                              | N        | String | The right side of the currency pair    |         |
| FXRate         | N                                              | N        | Double | Forex rate between the two currencies. |         |