Transaction wise / trade wise profit and loss

General
1

I would like to know where can I see / generate transaction wise / trade wise profit and loss in the back office. When I generate a P/L report and click on a individual trade details, it takes me to trade book where I can’t find out whcih “buy” trade squared off which “Sell” trade and vice versa. There are no P/L position on the trade book

Right now I am doing it in excel which is troublesome daily routine.

Regards

1 Like
2

There is no report in the backoffice which shows you trade-wise profits/losses.

In the Equity PNL report, you have trades divided into Intraday, Short-term(<1yr) and Long-term(>1yr). In the F&O PNL report, 1 row is assigned to 1 scrip. If you trade Stock A futures both in intraday and carry-forward, then all the quantities and average prices get added to the same row, finally giving you the realized profit/loss which is what is necessary for taxation purposes.

If you require trade-wise profit/loss then I’m afraid you’ll have to continue calculating it manually. Just curious, why are you doing this calculation?

3

For easier reconciliation, to look back and to analyse. F&O obligation entry on ledger is combination of MTM margin and charges. I would like to have something(a report or linking reference number) between trade report, ledger and P/L report on transaction basis. Now a single entry in both trade book and ledger is combination of several transactions. and ofcourse there are no transactionwise PL report

Regards

1 Like
4

this is a very good option to see full details of a trade, this option is in ICICI Direct, it would be great if this feature is given in Zerodha

5

I very much felt the need for such report without which it is very difficult to validate the F&O obligation amount on day to day basis. I wrote to Zerodha Support and still awaiting proper reply. In the first response they simply forwarded the P&L report which does not answer my question.

I have been calculating F&O obligation by the following formula.
F&O obligation amount = Realized profit of current day minus charges for current day plus unrealized profit of current day minus unrealized profit of previous day.
I am taking these numbers from the Absolute P&L reports of current day and previous day. The F&O obligation tallied with the above calculation for most of the days. However for some days F&O obligation in ledger is not tallying with the amount calculated with the above formula. I think the reason could be that the unrealized profit in P&L report may not be correct.

This is causing challenges in reconciliation and there are unexplained differences in profits. Zerodha should provide trade wise report showing previous day price and current day price and obligation for each of the positions and sum of the obligations for each position should tally with the total obligation for the day.