Standard Deviation Lines based on options expiration

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors – all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you don’t need to worry about fake reviews.

We are fundamentally different than most other trading sites:

We are here to help. Just let us know what you need.

We work extremely hard to keep things positive in our community.

We do not tolerate rude behavior, trolling, or vendors advertising in posts.

We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.

We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple.

Checking the math thinkorswim wasn't calculating all of the closes in the length due to diferent timeframes. Can't find a way to specify a date and add a length to that. Specifying the Opt Exp date the length keeps defaulting to that period instead of days. Was only able to do it manually.

So manually one has to count the length of the period, last opt exp is 23 days, and how many days from today to the last day in that opt exp, from today it is 9 days ago. Enter that info on the study, then hit ok and it will calculate the SD and show the result in the label in the top left corner. After that reopen the study and enter that info in deviation and it will add it to the close line.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

This is so similar to Pivot Points that I checked out a few and saw that these levels are very close to the CamarillaPoints pivot study R3 and S3. I only checked the past 2 months. The lines from the SD indicator are overlaid and are pretty close. In the Month before that drew a rectangle the size of the SD 7.428 and the CamarillaPoints S3 & R3 again are very close. Didn't keep checking past months. The default thinkorswim CamarillaPoints didn't have the Opt Exp option so added that, hid all the other levels and changed the linestyle. Attached is the modified indicator.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Also, all three of my lines are bunched together using the new study - also, is there not a was to use the monthly IV and projected move numbers on monthly contracts on the monthly options expiration date? So for PCLN on 2.21.14 the stock closed at 1315.65 and the Mar14 Contracts had an IV of 24.73 percent and Projected move (stdDev) of 72.416 - is there a way to grab those three numbers and use them? Again, thanks for the help!

Thanks for looking into this. Going through your steps I can see that I can get the right lines but then I have to do that for each symbol individually and its a bit tedious if I'm going to go through a whole watchlist.

So the big kickers we need are:
1. A way of defining the days from Options ex to today and subtracting those so the calculation starts calculating from the close of the last options expiration.
2. A way of calculating the length of days in the calculation. So days from today to Opt_exp[1] - days from today to Opt_exp[2]?

Once we have those dynamically plotted the standard deviation will plot automatically.

Maybe someone out there in the community can help figure these pieces out.

So here is what I'm trying to get at - using an old indicator I had in Tradestation - I a having trouble with the IF statement to calculate my own IV based on the conditions below... Thoughts?

AlexanderKors - it might be showing historical IV but that's not what I'm going for. After talking with TOS, they say their calculation of IV is proprietary and they don't release the code - so my question is how can i get that number as close to an actual as I can? Looking for the projected stock move (stock price + (price * IV * std Dev)) and the same for the lower level based on a set time period. Man, what seems to be an easy formula sure is tough to get coded :-)

This is exactly what I'm looking for too. Essentially on the second Thursday of the month, after the close, I grab the current expected move, and closing price to calculate the 1, 1.5, and 2 std deviation moves for the upcoming monthly. I then manually draw those lines on the chart. I do this for approximately 25 stocks I'm tracking. Doing it manually is accurate, but takes time and is tedious work. I end up with six lines, giving three sets of unique colors. I want to make sure that the study only looks at the price and std dev at that specific moment, not dynamically as the month progresses.

Unfortunately, I hve zero programming experience, and don't even know if this is possible.

I assume its not possible to grab the expected move from the options chain where it shows imp vol (std dev) (to the upper right of the cal/put box that appears when you expand that month?

If so, is it possible to make these two values user define, and then it draws the lines for you?

(Don't bite my head off, I just want to raise a point). I think I understand what you're aiming for, but I'm not sure the calculations you're using are the correct ones for a time series of prices. As a general rule, prices follow a lognormal distribution and their returns (daily price changes) follow a normal distribution. It gets more complicated than that when you try to incorporate skew and kurtosis into the returns distribution, but the generally accepted method is to use the natural log (LN in Excel) of daily returns before calculating a standard deviation and then a monthly or annual volatility.

Note also that with a lognormal distribution, you can't just add and subtract a 'fixed' standard deviation owing to the fact that a lognormal price series cannot go below zero, so I think you're mixing apples and oranges by calculating 1 SD at roughly 30 S&P points and adding that number to, and subtracting from, the most recent close to get a price range for the next 30 days (or about 21 trading days).

I'm not a TOS customer so I don't know how to get what you're looking for in their program. It can be done in Excel and certainly in a dedicated stats package, but if you're not already familiar with the concepts or it's been a long time since you sat through a stats class (both true in my case), it can be a challenge.

TOS may have a ready made tool similar to some of the online ones that help an option trader with probability of expiring worthless and probability of touch (touching the strike at any time during the otpion's life). Ivolatility licenses their calculator to TradeKing, OptionsHouse and probably others and the nice thing about it is that you can plug in a custom date and volatility and it will calculate plus and minus one, two and three SDs using the lognormal math. If you can get your hands on a calculator like this, all you need is the range derived from the SDs and you can simply slap a couple of horizontal lines on your price chart and update it as often as you wish. No coding required.

The probability cones, which I'm almost certain TOS has, perform a similar function. The key variable is volatility - you can use 21 trading day HV if you believe the coming month will be about the same as the month just passed. Or you can use the market's implied volatility for a 30 day (21 trading day) option, or some blend of the two.

Last edited by CafeGrande; April 20th, 2014 at 08:08 PM.