Day-wise position → accounts workbook

Position Splitter Version 1.1.1

Drop in the terminal's DAY WISE POSITION file and your accounts workbook. Every new put sale and call purchase is added as one line per lot to the Cur.Month sheet, and puts bought back or calls sold close the oldest open lines first (FIFO). Only stock and index options go into the sheet; commodity and cash trades are shown below but not added.

Today's day-wise file (.xls) No file loaded Accounts workbook (.xlsx) Optional. Add it to update it directly.

Account

Trade date Current series

Open line Premium (put sold) or price paid (call bought) Section title

0

lines to add

New trades that become lines

Underlying fills column U and is optional. Approx Margin and Current Margin (Q and R) are left empty for you to fill; until you do, the % return columns show #DIV/0!, as in your sheet.

Square-offs

All trades by category