Options Calculator

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

Hourly Job

Details

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

Australia
Sutherland 08:59 PM

2 Jobs Posted
100% Hire Rate, 1 Open Job

$422 Total Spent
2 Hires, 0 Active

Member Since Apr 30, 2013