logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
tman  
#1 Posted : Wednesday, May 24, 2006 1:03:53 PM(UTC)
tman

Rank: Newbie

Groups: Registered, Registered Users
Joined: 5/23/2006(UTC)
Posts: 3

Hello, I am trying to explore for high intraday volatility vs "daily volatility" for the last 20 days. This is what I've been using. Std(Log(H/L),19) / Std(Log(C/Ref(C,-1)),19) How does this look?? Thanks, The board is great!! tman
wabbit  
#2 Posted : Wednesday, May 24, 2006 2:01:22 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
tman, I have only had a quick look over your indicator, and offer: First, you don't need to take the Log() of the numerator and the divisor. Its redundant in the big scheme of things. Second, to allow users more flexibility in the application of this indicator I would add an Input() variable to be able to easily change the period length. Third, I would include some error handling for Divide by Zero errors whenever you have any division operation taking place in your code. All in all, its good clean code. How do you intend trading this indicator? Do you smooth the output with a MA? Two MA crossover? Anyway, this is more like I would use: --8<------------------------------------------ {tman Volatility Indicator} prd:=Input("Periods",2,100,20); Std(H/L,prd)/Max(Std(C/Ref(C,-1),prd),0.0001); --8<------------------------------------------ Hope this helps. wabbit :D
tman  
#3 Posted : Wednesday, May 24, 2006 2:30:00 PM(UTC)
tman

Rank: Newbie

Groups: Registered, Registered Users
Joined: 5/23/2006(UTC)
Posts: 3

Thanks Wabbit, I am a gamma scalper. I am looking for a tool to find underpriced options. My broad assumption is that option volatility and therefore market prices primarily incorporate close to close volatility. Gamma scalpers want high, relative intraday volatility. If this screen doesn't provide an edge, it will at least, level the field. I will be happy to share my results if there is any interest. Thank you again!! tman
sportrider  
#4 Posted : Thursday, May 25, 2006 12:09:39 AM(UTC)
sportrider

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/12/2005(UTC)
Posts: 141
Location: Brooklyn,NY

Hi tman, I've been using volatilyty but to help me with the markets.Your comments raises a question and please forgive me if I'm not thinking right-I'm not feeling that bright right this moment.I always thought that wether you looked at a 5 min,or a daily the high for that day is the same #.Yes it does adjust intraday depending if the price spikes to a new low or a new high but the high for that day is the same.
Justin  
#5 Posted : Thursday, May 25, 2006 12:53:17 AM(UTC)
Justin

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT

I am not an experienced formula writer, but if you are using this indicator on an intraday chart in MetaStock and wanting to look back 20 "days" and not 20 "periods" you would need to use some form of Rate of Change on one of the Day functions to extract the "Daily" values. If you just mean 20 periods then please disregard #-o
tman  
#6 Posted : Saturday, June 10, 2006 4:47:15 PM(UTC)
tman

Rank: Newbie

Groups: Registered, Registered Users
Joined: 5/23/2006(UTC)
Posts: 3

Sportrider, Sorry for the tardy reply. I am looking for differentials in the close-close volatilty vs the high-low volatility. In other words, a stock may have a many large intraday swings, yet close almost unchanged on the day. Options on a stock like this may not reflect the large intraday volatility. I use this as a screening tool and then narrow the list further by looking at the 30 day implied vol vs the 52 week range of implied vol-----looking to purchase "cheap" straddles. Again, I apologize the the delay in responding. tman
sportrider  
#7 Posted : Monday, June 12, 2006 2:14:57 AM(UTC)
sportrider

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/12/2005(UTC)
Posts: 141
Location: Brooklyn,NY

tman, No problem .Thank you for the reply.
bryanmccormick  
#8 Posted : Saturday, August 26, 2006 9:16:22 AM(UTC)
bryanmccormick

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/2/2006(UTC)
Posts: 10

Actually one does need to take the Log if one is going to follow the standard method for calculating volatility. However I think you would also need to calculate the volatility on an annualized basis (252 days) and then look back to the period you are interested in exploring.

This is from CRB

HISTORICAL VOLATILITY (20-day):

STEP 1
For the past 20 days, calculate: today's close / previous close (requires 21 days of data)

STEP 2
Calculate the natural log of the results calculated in STEP 1.

STEP 3
Calculate the sum of the natural logs over the past 20 days.
Calculate the sum of the squares of the natural logs over the past 20 days.

STEP 4
Divide the sum of the natural logs by 20.......................#1
Divide the sum of the squares of the natural logs by 20........#2
Calculate: RESULT 2 - the square of RESULT 1...................#3
Calculate the (square root of RESULT 3) x (sq. root of 252) x 100
This is the 20-day historic volatility for today.

I would highly recommend that the user have a look at both QC volatility fields for a given instrument and also at a site such as iVolatility where you can find graphs of volatility to compare to your results.

By the way, it should be noted what the user is looking at calculating here is historical volatility using the standard method. There is also Parkinson's method which uses ratios. You will get a similar looking volatility shape but very different numeric values.

Bottom line? If you are trying to use the industry standard measure of historical volatility you need to use this sort of formula:

pds:=Input("Volatility Period",0,252,5);
volatility:=Stdev(Log(C/Ref(C,-1)),pds)*Sqrt(252)*100;
volatility;

There are many ways to skin the Volatility cat. This is just the basic approach to historical vol. But this will give you the base line result that is the industry norm. Remember there are four types of Volatility -- historical, future, expected, implied. You will have to do completely different calculations for the other three forms.


Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.