Options payoff charts for strategies -Excel

SwamiNathan

Well-Known Member
#1
I have attached a file I have done in excel for calculation Options payoff for a portfolio of Options Contracts in a same security. This may be useful in creating option strategies like stradles, strangles etc.

Option traders may find it useful.
Worksheet - notes

The Notes how to use is given in a worksheet named notes.

Worksheet - Calculator
You shud enter your contract decriptions in calculator worksheet. You shud enter in green color cells. Brokarage shud be given in percentage only. Action is nothing but you are buying or selling a call or put. For Buying a call enter BC, Selling a call SC, Buying a put PC, Selling a put SP. Premium is the price of the option when u have entered.


In this sheet itself you will get the p and l for individual contracts plus nett portfolio for various spot market prices.

In the Chart you will get the Pay off chart for individual positions as well as the net portfolio of options.

If find useful reply, I will tell hot to include futures contract in this portfolio payoff.

Since we cannot upload a file more than 100kb, I ave reduced a part of this file. So if u find any mistake pls inform, I will zip the whole file and upload.
 

VJAY

Well-Known Member
#2
Dear swainathan,
You can upload any file into 4shared dot com and give link to it here.
 

AW10

Well-Known Member
#3
SwamiNathan,
Thanks for sharing such a useful sheet for analyse the Options portfolio.
It has certainly given me more ideas to know the option portfolio.

If I could suggest 1 at this stage then it would be to enhace this to track EOD status of P&L. It can be done by following
1) To a seperate worksheet, get the strike price + CALL/PUT for all contracts as rows
2) Ask user to update the latest /EOD price of those striks
3) Also ask them to enter current value of NIFTY
4) Based on the date given in 2) and 3), calculate the current P&L for each contract in row at the end (say row# 30)
5) plot the data in 4) as one DOT on the line reflecting particular contract, in the graph.

Not sure, if I have been clear enough.. but hope you would have atleast got the direction in which I am thinking.

As suggested, you can upload this file in rapidshare / 4shared sites and post the link here. (preferably in first post)..
As you create advance versions of it, u can keep updateing the link to new version.

Thanks Again and happy trading
 

VJAY

Well-Known Member
#4
Dear swaminathan,

Apart from AW i think it is possible to autoupdate of options to linking it to nse site.long time ago i saw an excell file of same here on TJ(though missed the link & sheet).If you develop the file as suggestion by AW then please update it on first post.
Thanks for the excell sheet.
 
#5
This is great. Loved the way the whole thing worked. Do you have any suggestions as to how one accounts for long/short position on underlying asset/equity/asset. would love to hear from you. Best wishes
 
#6
This is great. Loved the way the whole thing worked. Do you have any suggestions as to how one accounts for long/short position on the underlying asset/equity/asset. would love to hear from you. Best wishes
 

darshanshukla

Well-Known Member
#7
I have attached a file I have done in excel for calculation Options payoff for a portfolio of Options Contracts in a same security. This may be useful in creating option strategies like stradles, strangles etc.

Option traders may find it useful.
Worksheet - notes

The Notes how to use is given in a worksheet named notes.

Worksheet - Calculator
You shud enter your contract decriptions in calculator worksheet. You shud enter in green color cells. Brokarage shud be given in percentage only. Action is nothing but you are buying or selling a call or put. For Buying a call enter BC, Selling a call SC, Buying a put PC, Selling a put SP. Premium is the price of the option when u have entered.


In this sheet itself you will get the p and l for individual contracts plus nett portfolio for various spot market prices.

In the Chart you will get the Pay off chart for individual positions as well as the net portfolio of options.

If find useful reply, I will tell hot to include futures contract in this portfolio payoff.

Since we cannot upload a file more than 100kb, I ave reduced a part of this file. So if u find any mistake pls inform, I will zip the whole file and upload.
Thanks Swami its really awesome work by you... keep it up for option traderkind. Great job