| Store Field | Key | CanBeNull | Type | Description |
|---|---|---|---|---|
| BaseCcy | Y | String | The left side of the currency pair | |
| CounterCcy | Y | String | The right side of the currency pair | |
| FxRate | Double | Forex rate between the two currencies | ||
| AsOfDate | Y | LOCALDATE[yyyy-mm-dd] | Timestamp (at close of business) for the data |
FXRates
The FXRates store contains all the FX Rates. It is an isolated store and not part of any cube facts.
The store is index by BaseCcy, CounterCcy, and AsOfDate. FX Rates are looked up via the IFXRates API by these three fields.