[CTMAN]

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.

[CTMAN]

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.

[CTMAN]

A written explanation for each one would be fine.

[CTMAN]

Can anyone explain to me how these are done?

[CTMAN]

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?

[sevensa]

Originally Posted by CTMAN »

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?

No one replied because your question is either ridiculously simple, or not clear. It appears that you ask how to calculate your profit/loss when you close a position. Do you really not know how to calculate that? This is just basic math. If you buy/short something for x and sell/cover it for y, your gross profit/loss is the difference between x and y. Your net is your gross minus whatever trading costs you have incurred, commissions for example.

[CTMAN]

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.

[sevensa]

Sorry, I don't open Excel or Word documents from unkown sources on the internet. Sounds however that you already know the definitions which you asked about, but need some help to calculate that in Excel. You might be better off asking for help on that in an Excel forum.

However, I don't see the difference between using the settlement price or any other random price you pull out of thin air. The formula to calculate your P/L is the difference between your opening and closing price, regardless of where the closing price comes from.