BardParticipant
Master
Hi there, I was wondering if someone could explain to me why when I set an option chart with the Y axis set to Option Price and the X set to Asset Price, I can’t get a 34,400 Short Put (priced 172/212) to show that price. Instead it shows the option priced at 653? Pls see image:
Thanks for any insights,
JSParticipant
Senior
When calculating the initial option price, you have assumed an underlying price of 35,677.2 (Dow Jones price), at this price your short put has a value of 178.
In the chart (left side) you have lowered the underlying price to 34,396.7 (difference of 1280 points).
At this position (34,396.7) your short put has a value of 653.9 (scenario at maturity).
BardParticipant
Master
Cheers @JS, I was confusing the Strike with the Underlying.
Ps// The latest version of the probability calculator is looking good now — I even think the current version has only one error (the third quotes date cell is missing a formula) which is pretty good judging from how erratic Excel has been at saving my latest modifications 😄.
BardParticipant
Master
Hi @JS,
I wondered if you could take a look at this image below. According to a PRT Options chart that Dec 17th 34,400 Short Put needs to go about 4,000 points higher (Dow 38,473) for the option price to reach zero? That can’t be right? I don’t believe I’ve mixed up the Strike with underlying as I did above.
Cheers
Bard.
JSParticipant
Senior
Hi @Bard
I see a graph of a Long Put not a Short Put 🙂
JSParticipant
Senior
The graph of a Short Put must look something like the image below…
BardParticipant
Master
Hi @JS,
My picture shows it set to short though?
JSParticipant
Senior
Hi @Bard,
It seems so…but the graph shows a long put.