Options payoff charts for strategies -Excel

#21
Hello Mr. Swaminathan,

From where can I download this Excel file, I do not find the attachment to your post. I am looking for this kind of file. Please let me know how and where can I get this file. I am new to this forum.

Thank you very much Advance for kind help

yusuf
 

Cubt

Algo Trader
#23
Could anyone who downloaded the file please assist how do we download this excel?

am unable to locate it here.
 
#25
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.


Hello Swaminathan,

Would u pls attach the file again. i didnt find any file in any post by u.

Thanx you
 
#29
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.
Hi all,
Im unable to find the sheet here, can any one please provide me a sheet of calculation Options payoff