Calculating Unrealised P&L
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.
N.B Unrealised P&L is the Net Average Price of positions minus the market price.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1