MR : Payoff calculator for Stock option strategies

[Deepak Mulajkar]

Dear All,

We are at the last exam of the SMP 09. 

I am attaching an excel sheet for calculating the probable profit/loss for options strategy. The attached excel is for Infosys as example.  You can try out payoffs for various options using a model similar to this for other stocks as well.

Here I am selling 1 lot of 3400 Call and 1 lot of 3300 Put. Current price of the stock is 3360. 

Col A : Strike Price

Col B : Number of lots to sell. (1 lot = 125 shares. Lotsize changes for each stock)

          Use -ve numbers in this column if you want to buy the options.

Col C : Approx price of the option from the below link:

http://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=180&symbol=INFY&symbol=INFY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17 

Row 1 contains stock price at expiry

Row 19 gives possible profit/loss at expiry.

Last worksheet contains the probablity of making money in a given range of prices. Implied Volatility for this has to be taken from the link shared above. 

Regards,

Deepak

[Nagendhran CR]

" Dear Participants,

 

Please note that the MR exam is scheduled on 24^th November at 10:45AM-11:45AM. Please make a note of the timings and reach your centers accordingly to avoid any inconvenience.

 

NIIT Imperia wishes you all the best for the exam!!

 

Team Imperia "

Rgds,

Nagendhran

On Fri, Nov 22, 2013 at 2:37 PM, Ravindra Prasad <ravindr...@yahoo.com> wrote:

Thank you Deepak. Is there any way, getting the prices into excel automatically?

 

Regards,

Ravi

 

My Blog: http://ravindraprasad.org/wp/

[Dinesh Srinivasan]

MeeRa,

The disease that you contracted is known as "Last Exam Phobia" and the symptoms for this disease is usually  "Missing-you-all-mails" or "I'll-never-get-friends-like-you-msgs".

Do not worry...this is a temporary illness and usually fades away with time...albeit "Once-in-a-bluemoon-get-togethers" and frequent "Howdoyoudo-WhatsApp-msgs" might be effective in treating this ailment.

Recently I too caught up with this disease but was able to regain my normalcy after injecting "Life-moves-on" and "No-one-cares" two doses. You too can try the same...

Finally,

"ALL IS WELL AND WILL ALWAYS BE WELL"

Dinesh. (in a lighter vein......:) just for laughs...)

On Sat, Nov 23, 2013 at 4:24 PM, Meera Nagaraj <meer_n...@yahoo.com> wrote:

Dear friends,

It has been a wonderful year as SMP09 batch student. I learnt a lot, the knowledge gained is very relevant for the life and career. I had not expected the course to be so enriching. The biggest gain has been the  network and friends....You all are very special.

Now I wonder what will I do over the weekends... After so many years, we once again experienced a college life. I am sure, this was the last. Even if we join any course in future, I am not sure we will get friends like this, I am not sure, we will enjoy the way we did. I remember the way we did our project, fun time at lunch and bowling,sessions taken to ramp all of us, knowledge we shared, Gyan sessions shared by all of us...etc.,

 

Keep learning is the attitude to maintain...

 

Regards
MeeRa

From: Ravindra Prasad <ravindr...@yahoo.com>
To: Nagendhran CR <nagend...@gmail.com>
Cc: Deepak Mulajkar <mula...@gmail.com>; Biplab Mallick <biplab....@gmail.com>; Kailash Jayaswal <jaya...@gmail.com>; "smp09ba...@googlegroups.com" <smp09ba...@googlegroups.com>; Srinivas Chetan <sriniva...@gmail.com>; Meera Nagaraju <Meera_N...@infosys.com>; Meera Nagaraj <meer_n...@yahoo.com>; parag mathur <par...@hotmail.com>; "chenn...@gmail.com" <chenn...@gmail.com>; "venug...@gmail.com" <venug...@gmail.com>; "prav...@outlook.com" <prav...@outlook.com>; "dinesh...@gmail.com" <dinesh...@gmail.com>; "svishwa...@gmail.com" <svishwa...@gmail.com>; "hegde...@gmail.com" <hegde...@gmail.com>; "cheta...@hotmail.com" <cheta...@hotmail.com>; "aditya....@gmail.com" <aditya....@gmail.com>; "indiramu...@gmail.com" <indiramu...@gmail.com>; "niki...@gmail.com" <niki...@gmail.com>; "mohana.m...@ge.com" <mohana.m...@ge.com>; "lakshmikant...@gmail.com" <lakshmikant...@gmail.com>; "murugan.kr...@gmail.com" <murugan.kr...@gmail.com>; "vgr...@yahoo.com" <vgr...@yahoo.com>; Manikandan A S <manikan...@gmail.com>
Sent: Saturday, November 23, 2013 2:56 PM
Subject: Re: MR : Payoff calculator for Stock option strategies

Next version is ready. Enjoy.

Regards,

Ravi

 

My Blog: http://ravindraprasad.org/wp/

On Saturday, 23 November 2013 10:37 AM, Ravindra Prasad <ravindr...@yahoo.com> wrote:

All PDFs combined. Enjoy your study :)

 

My Blog: http://ravindraprasad.org/wp/

[Venugopal R]

Guys,

Reached for the Final One with eye full of sleep.
Hope you guys also toiled to climb the mount MR. Let's win this!!

Venu.

Sent from BlackBerry®

---

From: Dinesh Srinivasan <dinesh...@gmail.com>

Date: Sat, 23 Nov 2013 19:25:11 +0530

To: Meera Nagaraj<meer_n...@yahoo.com>

Cc: Ravindra Prasad<ravindr...@yahoo.com>; Nagendhran CR<nagend...@gmail.com>; Biplab Mallick<biplab....@gmail.com>; Deepak Mulajkar<mula...@gmail.com>; svishwa...@gmail.com<svishwa...@gmail.com>; Manikandan A S<manikan...@gmail.com>; chenn...@gmail.com<chenn...@gmail.com>; mohana.m...@ge.com<mohana.m...@ge.com>; parag mathur<par...@hotmail.com>; murugan.kr...@gmail.com<murugan.kr...@gmail.com>; lakshmikant...@gmail.com<lakshmikant...@gmail.com>; vgr...@yahoo.com<vgr...@yahoo.com>; indiramu...@gmail.com<indiramu...@gmail.com>; cheta...@hotmail.com<cheta...@hotmail.com>; aditya....@gmail.com<aditya....@gmail.com>; hegde...@gmail.com<hegde...@gmail.com>; prav...@outlook.com<prav...@outlook.com>; Kailash Jayaswal<jaya...@gmail.com>; Meera Nagaraju<Meera_N...@infosys.com>; venug...@gmail.com<venug...@gmail.com>; Srinivas Chetan<sriniva...@gmail.com>; smp09ba...@googlegroups.com<smp09ba...@googlegroups.com>; niki...@gmail.com<niki...@gmail.com>

Subject: Re: IIMC SMP09 Jayanagar center | Moments to cherish

[Venugopal R]

Fellow climber Nagendran has arrived!

Sent from BlackBerry®

---

From: "Venugopal R" <venug...@gmail.com>

Date: Sun, 24 Nov 2013 03:43:45 +0000

To: Dinesh S SMP09 IIMC<dinesh...@gmail.com>; Meera Nagaraju SMP09 IIMC<meer_n...@yahoo.com>

ReplyTo: venug...@gmail.com

Cc: Ravindra Prasad<ravindr...@yahoo.com>; Nagendhran CR<nagend...@gmail.com>; Biplab Mallick<biplab....@gmail.com>; Deepak Mulajkar SMP09 IIMC<mula...@gmail.com>; Satish Vishwanathan SMP09 IIMC<svishwa...@gmail.com>; Manikandan A S SMP09 IIMC<manikan...@gmail.com>; chenn...@gmail.com<chenn...@gmail.com>; mohana.m...@ge.com<mohana.m...@ge.com>; parag mathur<par...@hotmail.com>; murugan.kr...@gmail.com<murugan.kr...@gmail.com>; lakshmikant...@gmail.com<lakshmikant...@gmail.com>; vgr...@yahoo.com<vgr...@yahoo.com>; Indira Muppanna SMP09 IIMC<indiramu...@gmail.com>; cheta...@hotmail.com<cheta...@hotmail.com>; aditya....@gmail.com<aditya....@gmail.com>; hegde...@gmail.com<hegde...@gmail.com>; Praveen R.K SMP09 IIMC<prav...@outlook.com>; Kailash Jayaswal SMP09 IIMC<jaya...@gmail.com>; Meera Nagaraju<Meera_N...@infosys.com>; Srinivas Chetan<sriniva...@gmail.com>; smp09ba...@googlegroups.com<smp09ba...@googlegroups.com>; niki...@gmail.com<niki...@gmail.com>

Subject: Re: IIMC SMP09 Jayanagar center | Moments to cherish

Guys,

Reached for the Final One with eye full of sleep.
Hope you guys also toiled to climb the mount MR. Let's win this!!

Venu.

Sent from BlackBerry®

---

From: Dinesh Srinivasan <dinesh...@gmail.com>

Date: Sat, 23 Nov 2013 19:25:11 +0530

To: Meera Nagaraj<meer_n...@yahoo.com>

Cc: Ravindra Prasad<ravindr...@yahoo.com>; Nagendhran CR<nagend...@gmail.com>; Biplab Mallick<biplab....@gmail.com>; Deepak Mulajkar<mula...@gmail.com>; svishwa...@gmail.com<svishwa...@gmail.com>; Manikandan A S<manikan...@gmail.com>; chenn...@gmail.com<chenn...@gmail.com>; mohana.m...@ge.com<mohana.m...@ge.com>; parag mathur<par...@hotmail.com>; murugan.kr...@gmail.com<murugan.kr...@gmail.com>; lakshmikant...@gmail.com<lakshmikant...@gmail.com>; vgr...@yahoo.com<vgr...@yahoo.com>; indiramu...@gmail.com<indiramu...@gmail.com>; cheta...@hotmail.com<cheta...@hotmail.com>; aditya....@gmail.com<aditya....@gmail.com>; hegde...@gmail.com<hegde...@gmail.com>; prav...@outlook.com<prav...@outlook.com>; Kailash Jayaswal<jaya...@gmail.com>; Meera Nagaraju<Meera_N...@infosys.com>; venug...@gmail.com<venug...@gmail.com>; Srinivas Chetan<sriniva...@gmail.com>; smp09ba...@googlegroups.com<smp09ba...@googlegroups.com>; niki...@gmail.com<niki...@gmail.com>

Subject: Re: IIMC SMP09 Jayanagar center | Moments to cherish

[Aditya Satyadev]

+ Prakash

--
You received this message because you are subscribed to the Google Groups "SMP09Bangalore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to smp09bangalor...@googlegroups.com.
To post to this group, send email to smp09ba...@googlegroups.com.
Visit this group at http://groups.google.com/group/smp09bangalore.
For more options, visit https://groups.google.com/groups/opt_out.

[Deepak Mulajkar]

Dear All,

Pics from my camera...

https://www.dropbox.com/sh/1fh79ghu0qkp7q0/82H6dzX7il

Regards,

Deepak