Data Upload Functionality

Trajour provides two primary methods for uploading your trading data: CSV Upload and Manual Form Entry. This guide explains both methods.

CSV Upload#

The CSV Upload feature allows you to bulk import your trades by uploading the order book or trade book exported directly from your broker.

Supported Brokers#

Currently, the following brokers and their respective CSV export formats are supported:

1. Zerodha#

The parser expects the standard trade book export with the following CSV columns: symbol,isin,trade_date,exchange,segment,series,trade_type,auction,quantity,price,trade_id,order_id,order_execution_time,expiry_date

Example Row:

BANKNIFTY22O0639000CE,,2022-10-04,NSE,FO,,buy,false,25.000000,316.750000,431747810,1500000023632188,2022-10-04T09:55:21,2022-10-06

While the parser expects this full structure, the essential columns extracted for processing are symbol, trade_type, quantity, price, order_id, and order_execution_time.

2. Kotak Neo#

The parser auto-detects and supports two different Kotak Neo CSV formats:

• Trades Format: The standard trade format. Essential columns include Security Name, Transaction Type, Quantity, Market Rate, Trade Date, and Order Time.
• Orders Format: The detailed order-level format. Essential columns include Name, Transaction Type, Filled Quantity, Average Price (or Order Price), Order Date and Time, and Order Number.

How it Works#

When you upload a CSV file from a supported broker, the system automatically parses the data, identifying positions and individual orders.

During this process, the system uses a symbol normalization engine to ensure that F&O (Futures & Options) instruments from different brokers are converted into a single, broker-agnostic canonical form. This ensures that deduplication and position tracking work seamlessly regardless of which broker you use.

For detailed technical information on how symbols are processed, please refer to the Symbol Normalization Document.

Manual Form Upload#

If you prefer to enter trades manually or if you are using an unsupported broker, you can use the Manual Form entry feature.

Features#

• Enter individual trade details such as symbol, date, buy/sell side, quantity, and price.
• Review and save positions manually to your trade journal.