Daily Position Recon

Terminal day positions checked against our accounts sheet, contract by contract.

Trade date

Matches rows whose Date Bought or Date Sold equals this date.

Choice terminal Voyager · OF00659 Needed

Drop the Choice day-position file or click to choose (.xls)

Principia terminal OF010889 Needed

Drop the Principia day-position file or click to choose (.xls)

Our accounts Cur.Month sheets Needed

Drop our accounts workbook or click to choose (.xlsx). One workbook or one per account.

Show only rows that need a look Skip MCX / commodity rows

How matching works

Tally filled = sell contract. Counted on the day in Date Sold, at Price Booked.
Tally blank = squared off (buy). Counted on the day in Date Bought, at Buy Price.
Futures (OPT = F) with a positive Tally are long buys, counted on Date Bought.
A date in Date Bought on a sell row is read as the expiry month. No date means the nearest expiry on the terminal.
Lot rows are added up per contract and compared with the terminal's quantity and average price.
Weekly expiries in the same month are matched to the earliest one first.
A terminal workbook with a sheet for each account (voyager, principia) can go in both terminal slots. Each slot uses its own account's sheet.