Treasury FX Rates Import
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 |
Yes |
date |
||
|
Currency |
Currency of the exchange rate |
Yes |
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 |
|
decimal |
||
|
Mid |
Reference rate used within the system that typically represents the average of the bid and ask rates |
Yes |
decimal |
||
|
Ask |
Ask refers to the exchange rate at which a market participant is willing to sell a particular currency pair |
decimal |
|||
|
Provider |
Market data provider |
string |