Hi
I am looking to calculate Net P&L from trading by using a function which looks up off the sheet attached. The number of trades varies every day so could be as large as 5000. I can calculate Realized P&L without an issue but need to work out what the average price of the net position is to calculate the Unrealised and the compare this against the market.
I have been banging my head against the wall for sometime now.
Please help
N.B Unrealised P&L is the Net Average Price of positions minus the market price.
Robin
Bookmarks