Calculations on Contracts

[CTMAN 10]

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

[CTMAN 10]

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 10]

A written explanation for each one would be fine.

[CTMAN 10]

Can anyone explain to me how these are done?

[CTMAN 10]

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 10]

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 10]

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 10]

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.

[CTMAN 10]

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?