+ Reply to Thread
Results 1 to 1 of 1

Calculating Unrealised P&L

  1. #1
    Registered User
    Join Date

    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.

    Please help

    N.B Unrealised P&L is the Net Average Price of positions minus the market price.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1