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