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 |