Treasury FX Rates Import
The Treasury FX Rates loader uses only a single set of header columns.
Overview
The Treasury FX Rates Import process reads files from ./Incoming/FxRates in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/FxRates before being processed in alphanumeric order.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Rate Date | Date for which the foreign exchange rate is valid | TRUE | FALSE | date | |
| Currency | Currency of the exchange rate | TRUE | FALSE | char - 3 | curreny iso codes |
| Bid | Bid refers to the exchange rate at which a market participant is willing to buy a particular currency pair | FALSE | FALSE | decimal | |
| Mid | Reference rate used within the system that typically represents the average of the bid and ask rates | TRUE | FALSE | decimal | |
| Ask | Ask refers to the exchange rate at which a market participant is willing to sell a particular currency pair | FALSE | FALSE | decimal | |
| Provider | Market data provider | FALSE | FALSE | string |