Treasury Commodity Rates Import
The Treasury Commodity Rates loader uses only a single set of header columns.
Overview
The Treasury Commodity Rates Import process reads files from ./Incoming/CommodityRates in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/CommodityRates before being processed in alphanumeric order.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Rate Date | Date for which the commodity rate is valid | TRUE | FALSE | date | |
| Commodity | Commodity Iso Code | TRUE | FALSE | string | commodity iso codes |
| Period | Tenors/Maturity of the curve in period | TRUE | FALSE | integer | |
| Mid | Reference rate used within the system that typically represents the average of the bid and ask rates | TRUE | FALSE | decimal | |
| Bid | Bid refers to the commodity rate at which a market participant is willing to buy a particular commodity | FALSE | FALSE | decimal | |
| Ask | Ask refers to the exchange rate at which a market participant is willing to sell a particular commodity | FALSE | FALSE | decimal |