Treasury Commodity Rates Import
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 |
Yes |
date |
||
Commodity |
Commodity Iso Code |
Yes |
string |
commodity iso codes |
|
Period |
Tenors/Maturity of the curve in period |
Yes |
integer |
||
Mid |
Reference rate used within the system that typically represents the average of the bid and ask rates |
Yes |
decimal |
||
Bid |
Bid refers to the commodity rate at which a market participant is willing to buy a particular commodity |
decimal |
|||
Ask |
Ask refers to the exchange rate at which a market participant is willing to sell a particular commodity |
decimal |