It is possible to import commodities from a text or CSV file. This can be useful when implementing TS and many commodities from another system needs to be entered or internal commodities.
Open Autopilot / Integrations
1. Click new / Plugin
2. Select Deal import - Commodity deal import
3. Give the new integration a name
4. In Settings add all the column you have in the file you want to import
Note, The order of the COLUMN MAPPINGSs in the Settings tab is important if the imported file does not contain headings. If there are headings in the file, the order does not matter.
Import file WITH headers
Make sure the CONTAINS HEADERS checkbox is checked.
Add Column mappings and enter the header names in column File Header and map to relevant field from the drop down list in the System Field column.
Import file WITHOUT headers
Make sure the CONTAINS HEADERS checkbox is NOT checked.
Add Column mappings. Headers can be, but does not have to be, entered.
CULTURE determines how numbers are represented.
DELIMITER specifies the delimiter used in the CSV file. Most common is semicolon ;.
Mandatory fields
Legal entity
Counterparty
Commodity
Commodity type
Quantity (see note below)
Buy/Sell
Price
Contango/Backwardation
Deal date
Value date (Closing floating or average price will be selected from this date)
Maturity date (Closing floating or average price will be selected to this date)
Payment date
Note: Quantity has to be in ABS number (no "-" on Sell)
Optional
Market place: is only mandatory if more than one Market place is defined in Commodity definition
Price unit: if multiple price unit for same commodity are defined in Commodity definition then this needs to be included in the import file
Closing price: is optional
External identifier are optional but if included it will check so that no deals with same external iditifier are imported twice.
In TAB Mappings you MUST map different Legal entities and Counterparties that are included in the import file. If other TAGs are included in the file, they must also be mapped.
For example, in the view above, all Deals will have TAG VALUE "TreasurySystem" as a legal entity.
You need to map both Legal entity and Counterpart even if they have the same value in the import file.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article