Anyone know how to calculate SD of VWAP?

Sadly, the only way we traders can possibly VWAP algorithm trade timed with the markets reliably without relying on brokers, or any two-bit coder that could, is to reverse engineer VWAP code offered by NASDAQ or Bloomberg, program a real-time subroutine in excel using Visual Basic.NET and transfering the data to charting software via a third-party program. Or, which is likely cost and time efficient, hire a programmer to do it for you.

http://www.excel-modeling.com/index_007.htm
http://msdn.microsoft.com/en-us/library/aa140061(office.10).aspx
https://data.nasdaq.com/VWAP.aspx
https://www.dnbnor.no/portalfront/nedlast/no/markets/aksjerapporter/Bloomberg_Algorithm_VWAP.pdf
http://www.willowsolutions.com/tips/tips_2001_01_2.shtml
http://www.tssupport.com/services/owndata/
 
Quote from dtrader98:

I would also like to see more of the full data period for a few full windows.

Plot out about three full days worth of data. I want to see how the VWAP responds over the full day for a few periods.
More...

Here. I'll attach a 15 min chart of a few days in this post, and a 1500 constant volume chart of a few days in the next post.
 

Attachments

Quote from IronFist:

Here. I'll attach a 15 min chart of a few days in this post, and a 1500 constant volume chart of a few days in the next post.
More...

Ok. Now that I am seeing the entire windows, I would agree that looks correct. Notice the VWAP remained relatively constant after regular trading hours as I expected. What caused the huge gap (between price and VWAP), however, was the huge gap in price after the closing periods. So your original argument about volume as well as the mathematical argument I made both fit in under this context. I just needed to see more of the picture to confirm that.

Can you plot the a similar output (several full windows) with the Stdev bands (say +/- 3) you have calculated that you said do not look right?

BTW. Can you also include some type of table with your first few (20 or so) avg prices (closing or whatever they use to calculate vwap per pt), corresponding VWAP values, and stdev calculation that you are applying with respect to these variables?
 
Quote from Xuanxue:

Sadly, the only way we traders can possibly VWAP algorithm trade timed with the markets reliably without relying on brokers, or any two-bit coder that could, is to reverse engineer VWAP code offered by NASDAQ or Bloomberg, program a real-time subroutine in excel using Visual Basic.NET and transfering the data to charting software via a third-party program. Or, which is likely cost and time efficient, hire a programmer to do it for you.

http://www.excel-modeling.com/index_007.htm
http://msdn.microsoft.com/en-us/library/aa140061(office.10).aspx
https://data.nasdaq.com/VWAP.aspx
https://www.dnbnor.no/portalfront/nedlast/no/markets/aksjerapporter/Bloomberg_Algorithm_VWAP.pdf
http://www.willowsolutions.com/tips/tips_2001_01_2.shtml
http://www.tssupport.com/services/owndata/
More...

wat?

Why can't I just use the VWAP indicator in my charting package?
 
Quote from dtrader98:

BTW. Can you also include some type of table with your first few (20 or so) avg prices (closing or whatever they use to calculate vwap per pt), corresponding VWAP values, and stdev calculation that you are applying with respect to these variables?
More...

I'm not entirely sure what they use. If I can find this info out I can plot it in a study. Otherwise you'll just get pics of that other stuff you asked for.
 
Quote from IronFist:

I'm not entirely sure what they use. If I can find this info out I can plot it in a study. Otherwise you'll just get pics of that other stuff you asked for.
More...

start with the pics (windows of VWAP and +/-3 stdev bands over several full periods). I'd prefer the actual data pts. and calculation they use to get stdev (you can't plot this). Although, if you can't look under the hood (at how they calculate stdev) and make some mods, it's going to be kind of hard to troubleshoot the problem and fix it, while relying on their platform. We can at least look at the visual plot and make some inferences about whether it looks to be calculated erroneously or not.
 
The STDEV calculation they use is the normal one.

I coded it myself and got the same values a I did when I used the built-in SD function.

I'll give you a huge chart using SDs of the VWAP but it won't really be noticable because they hug the VWAP so tightly.

Hang on. Hopefully ET will allow that large of an attachment.
 
Quote from IronFist:

The STDEV calculation they use is the normal one.

I coded it myself and got the same values a I did when I used the built-in SD function.

I'll give you a huge chart using SDs of the VWAP but it won't really be noticable because they hug the VWAP so tightly.

Hang on. Hopefully ET will allow that large of an attachment.
More...

I don't understand. If you were able to calculate/code stdev function, you should at least be able to describe how it is being applied to the data.:confused:

Did you just do stdev of VWAP data alone? That makes no sense. I think I might already know the problem, but let's see the plot.

As I mentioned earlier, if you only calculated stdev based on VWAP data, that would be incorrect, as the dispersion you measure would be how each VWAP pt. varied relative to the running absolute mean of the sample set of VWAP only.

You don't want that. You want to measure stdev as a function of two variables, VWAP and Price.
What you want to see is a measure of dispersion about how far price deviates from VWAP over time.

It also has to be updated at each step..
Meaning the stdev value will change at each step, along with cumulative vwap and vol changes.
 
Quote from dtrader98:

You don't want that. You want to measure stdev as a function of two variables, VWAP and Price.
What you want to see is a measure of dispersion about how far price deviates from VWAP over time.
More...

So it needs to calculate the difference between price and VWAP over x number of periods?
 
You must log in or register to reply here.
Back
Top