CTMAN

I know the definition but If you look at the excel file you will understand what I am asking... If I knew how to calculate it I could write the excel easily. Anyone who "opens" excel files have an idea?

I know how to calculate my P&L but if you looked at my spreadsheet and subsequent comments you can see that I am having an issue not just with my P&L but with my expected gross profit and net profit by assuming I close any open position at the provided settlement price (J3:J6 in the excel I provided.

The issue I am having is calculation assuming I close any open position at the provided settlement prices. No one knows how to calculate the above formulas?

Can anyone explain to me how these are done?

A written explanation for each one would be fine.

One more thing: I want to compute the expected gross profit and net profit by assuming I close any open position at the provided settlement price.

I have a few questions on some calculations I am using in an excel I am creating. How do I figure out the: Expected gross profit Expected net Profit Realized trade fees I have attached a spreadsheet with the data that I have. Could someone please take a look and provide me with how to calculate this data so that I can convert it to VBA and automate. I need the calculations per product not overall. Thanks. traderslab.xls