You can actually use PNL statements, which many brokers allow you to be exported to excel. The contract notes are typically in PDF format. But yeah, it might be helpful if it was sent as an excel, let me find out from our team on if there is any regulatory challenge getting it done.
Not able to understand your question. Do you want the transactions costs like STT,Brokerage, Service Tax split on a per trade basis?
1 Like
Its very easy to make your daily excel file and you can use this file for multipurpose.
End of the day, Right click on order book( F3), click write to excel and save a file. Do the same Trade Book (F8) and Admin Position day wise and position wise. Combined all file in One daily file.
This file contains all details like order no , cancel order, completed order, trade no etc.
3 Likes
Hi Nitin, you got my question correctly. But even in contract notes, the transaction expenses (like brokerage, STT etc) are given on a consolidated basis. What I was wondering if that, like contract notes, if the transaction costs can also be added in the respective columns against the trade itself.
To go one step further, a similar summary for all the trades, just like the P&L, will help a customer understand and analyze each trade individually.
Thanks for your response.
Yes Venu, this is exactly what I am looking for, and not just in contract notes, buy as a separate option like P&N, trade summary etc.
At Zerodha, we charge brokerage on an order wise basis which means you can buy as many lots of Nifty Futures/Options by paying the execution fee of Rs.20/- and hence it wouldn’t be possible to split this brokerage amongst different trades. We do show the STT separately on the contract note and also the Service Tax.
With regards to the P&L, P&L is always viewed for a particular period. So you may generate the P&L for any date range and all the trades with common contracts will be clubbed and the charges too. To get the breakup, you’d have to refer to the contract note.