General Topics
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# Anyone know how to calculate SD of VWAP?

Discussion in 'Technical Analysis' started by IronFist, Jul 23, 2008.

1. ### IronFist

Normal SD calculations applied to a range of VWAP values yield results like .04 which are pointless.

I've seen pics posted where the VWAP has SDs graphed along with it and they are a meaningful distance away on both sides, like a few points or whatever. HOwever these charts never explained how they were doing it.

I've seen a lot of discussions on forums about calculating the standard deviation of the VWAP and it seems a lot of people are having this same issue.

So do any ETers know the secret? What am I doing wrong?

I'd have to see some data to try to apply it.

But from what I can see, it looks similar to how bollinger bands are calculated.

1st find the VWAP for all your price series points and put it in a separate column.
Then for each price, subtract the corresponding VWAP at that point.

Once you have all the differences (in a separate column), take the standard deviation of the difference set.

Once you do that, you can simply make six columns for price +/- 1-3*stdev of your vwap set by adding +/-3stdev to each price point.

http://ensign.editme.com/vwap

They show the vwap calc, but not the stdev calc. If it doesn't work, post a time series and I'll try to see if I can emulate it.

edit... hmmm.. there's quite a few discussions on this (vwap calcs aren't as simple as the other site showed), but you have to have access to look at the darn graphs.

hmm.. slightly different than my 1st thought.
Seems like they plot a volume distribution that is updated throughout the day (binned by prices) ,then multiply the corresponding price at any point in the day times it's binned volume weight. Looks like the stdev are caclulated relative to this volume distributions mean (or point of control). So you'd have to add +/- the price of corresponding to the volume bins at +/- 3stdev of the volume distribution. They also say to start out by using yesterday's distribution as a starting point.

here's a graph i found of what the volume vs price distribution should look like.

3. ### Xuanxue

It seems to me more efficient and reasonable to plot a standard deviation of closing prices or an ATR using mutipliers and an semi-interquartile range, along side VWAP.

A cumulative average for VWAP makes more sense, to me, anyway.

What do you guys think?

4. ### nkhoiModerator

ps. just need to chop off .zip

• ###### sd-.stdycollct.zip
File size:
21.4 KB
Views:
565

ok, took a crack at it. Didn't need distribution after all (if I'm interpreting correctly). Here's 20 period VWAP with +/-3sigma bands.

Look correct? If it does, you can just change the input data to intraday.

6. ### Xuanxue

Nice confirmed undervalued buy signal. lol

oops... forgot to pull the price back into alignment with the moving avg. (VWAP) data.

Updated.

8. ### Xuanxue

How did you align the average and deviation sets together to be plotted?

9. ### Xuanxue

BAH! That was the primary question of the entire thread!