Options Calculator

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