Treasury Commodity Rates Import
The Treasury Commodity Rates loader uses only a single set of header columns.
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|