How to Import Trades

If you have a number of trades that you need to manually book in the system, Molecule has an easy way for you to do so using the trade import template. To start, download a template file by clicking on the download icon on the top right of your Trades screen and selecting "Download Template":

An Excel file titled "trade_import_upload_template" will be downloaded. You'll notice that a few of the fields have already been filled out as an example:

Column Breakdown

Name Description Format (Example) Required?
trade_date The date of the trade. 04-Apr-18 Yes
quantity The quantity of the trade.  if the trade is a sell, you will need to add a negative sign in front of the number. -200 Yes
quantity_type Specifies how the quantity of the trade should be determined. Quantity types are 'unit', 'contract', 'month', or 'day' unit Yes
mark If you would like your trade to mark with a different product's curve price, you can do that here by filling out the product's ticker symbol. You can specify a contract month as well, although it is not required. JAN 2019 NG No
primary_product_code The ticker symbol of the trade. NG Yes
price The price of the trade. Can be static or formula. 3.25 (static example)
38.3%(JAN 2020 NG + 0.0) + 0.035 (formula example)
Yes
strike The strike price of the trade (for options only). 1.5 Yes (for options)
right Specifies whether the trade is a 'call' or a 'put' (for options only). call Yes (for options)
counterparty The counterparty of the trade, using their 'short name'. NYMEX No
tenor_start The beginning of the first contract period of the trade. 01-Apr-18 Yes
tenor_end The end of the last contract period of the trade. As trades can have multiple legs and frequencies, this may not simply be the end of the tenor_start month. 30-Apr-18 Yes
origin Filled out only if there are multiple trade origins set for the account. Most accounts do not have this. Experimental Energy Yes (for accounts with multiple origins)
tags Specifies which book the trade will be assigned to. You may also include secondary tags (beginning with @). All tags will need to be separated by a 'space'. Note: tag names may not have 'spaces' in their names. #demo @strategy_1 Yes (book only)
fcm The FCM of the trade, using their 'short name'. NYMEX No
settlement_date_override If you would like to specify your own settlement date for the trade, you can do that here. Populated as a date, if this field is specified the imported trade's legs will be given this value as its realization date. 30-Apr-18 No
notes Any notes you would like to include with the trade will be filled out here. This is a test trade. No
po/so A field for purchase order/sales order. 1A2B3C No
custom_field_values For accounts with "custom fields" set up. Custom fields for trades are done in JSON format. {"Account": "first", "Priority": "moderate"} No (unless the field is created as "required")


* Note: Each row in your spreadsheet represents an individual trade that will be uploaded.

Here is a filled out test import template for reference:

  • Once you have filled out the spreadsheet, you can upload it to Molecule by clicking on the upload icon on the top right corner of your trades screen:
  • After clicking on the icon, a window will appear where you can select your file. After selecting, click on "Open".
  • You will then receive a message in your notifications window when the upload starts, and when it finishes as well:
  •  If there are any issues with your upload file, Molecule will send an error message. For example:

   

Hope this helps! Feel free to send any questions our way at support@molecule.io.

Still need help? Contact Us Contact Us