Options Calculator

Closed - This job posting has been filled and work has been completed.

Job Description

Dear Grant
please find attached exel file . What i need

1) calculate P& L formular to colums M, N - For the tables : Options, Forwards, Spot.

2) This formular is cpecific for every kind of otion it will use "if " operator.

3) In the table Options in colum E create Option to chose : Buy Call, Buy Put, Sell Call, Sell Put.

4) Calculation of P/L for colum M based on the colums : G , I, K, L, for N on the bases G, J, K, L


The same work for table Forwards, and Spots.

5) Colums M 72, N 72 - reflect total P& L including :Options, Forwards, Spots.

There are 2 tables one for forex transactions , another one for shares -- it is same a little bit different titles.


6) To make protection against changing formulas

7) I would like to have possibility to add sheets with the same tables.

There are a few more details but basicly this is all.

All beige coular where formulas are supposed to be.

Open Attachment