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.