Options Calculator

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Financial Planning Posted 3 years ago


Start Date

April 30, 2013


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.

About the Client

(5.00) 2 reviews

Sutherland 06:59 AM

2 Jobs Posted
100% Hire Rate, 1 Open Job

$422 Total Spent
2 Hires, 0 Active

Member Since Apr 30, 2013