NexusFi: Find Your Edge


Home Menu

 





multiple day vwap?


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Big Mike with 22 posts (15 thanks)
    2. looks_two Fat Tails with 17 posts (75 thanks)
    3. looks_3 Neo1 with 16 posts (7 thanks)
    4. looks_4 aslan with 5 posts (3 thanks)
      Best Posters
    1. looks_one Fat Tails with 4.4 thanks per post
    2. looks_two josh with 1.3 thanks per post
    3. looks_3 Big Mike with 0.7 thanks per post
    4. looks_4 Neo1 with 0.4 thanks per post
    1. trending_up 35,884 views
    2. thumb_up 116 thanks given
    3. group 24 followers
    1. forum 91 posts
    2. attach_file 27 attachments




 
Search this Thread

multiple day vwap?

  #31 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103

Same comment here. No problem with the VWAP itself. But the standard deviation bands are too narrow for a trending day. I suppose that the chart created with SierraChart shows 2 SD bands.






Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
How to apply profiles
Traders Hideout
NexusFi Journal Challenge - May 2024
Feedback and Announcements
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
What is Markets Chat (markets.chat) real-time trading ro …
76 thanks
Spoo-nalysis ES e-mini futures S&P 500
55 thanks
Just another trading journal: PA, Wyckoff & Trends
37 thanks
Bigger Wins or Fewer Losses?
24 thanks
The Program
17 thanks
  #32 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103

For the 5-day rolling VWAP neither VWAP nor standard deviation bands are anywhere near their correct levels. I cannot even make any comments.







Reply With Quote
  #33 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,461 since Jun 2009
Thanks Given: 33,235
Thanks Received: 101,657



Fat Tails View Post
For the 5-day rolling VWAP neither VWAP nor standard deviation bands are anywhere near their correct levels. I cannot even make any comments.

Thanks for helping me confirm. I am sure that @SierraChart will take another look at it when they can.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #34 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103


Big Mike View Post
Same as above, but 100K volume chart.

1-week standard VWAP



1-day standard VWAP



2-day rolling VWAP



5-day rolling VWAP



Mike


If the VWAP and the SD bands are correctly calculated, they should have exactly the same value on any type of chart. After all, a VWAP is the volume weighted average price of all trades over a specified lookback period. The standard deviation is also calculated from all trades over the lookback period.

Therefore neither VWAP nor standard deviation bands depend on the chart type and should always be identical, whether displayed on a minute chart, a volume chart or a fancy Renko chart. This is not the case for the Sierra Chart indicator and clearly shows that the calculations are false.

Reply With Quote
Thanked by:
  #35 (permalink)
 
josh's Avatar
 josh 
Georgia, US
Legendary Market Wizard
 
Experience: None
Platform: SC
Broker: Denali+Rithmic
Trading: ES, NQ, YM
Posts: 6,245 since Jan 2011
Thanks Given: 6,782
Thanks Received: 18,253

Mike, just a sanity check that you do indeed have the "std dev distance multiplier" set to 1 ..yes?

Reply With Quote
Thanked by:
  #36 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,461 since Jun 2009
Thanks Given: 33,235
Thanks Received: 101,657


josh View Post
Mike, just a sanity check that you do indeed have the "std dev distance multiplier" set to 1 ..yes?

Good call. I had the multiplier at 2 but was displaying the first band only.

Either way it doesn't alter the VWAP which is still inaccurate in the rolling side

Sent from my phone

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #37 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,461 since Jun 2009
Thanks Given: 33,235
Thanks Received: 101,657


Big Mike View Post
Good call. I had the multiplier at 2 but was displaying the first band only.

Either way it doesn't alter the VWAP which is still inaccurate in the rolling side

Sent from my phone

I changed it from multipler 2 -> band 1, to multiplier 1 -> band 2 (to get the 2 SD). There is no change in the output so that wasn't the issue.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #38 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103

Let us go one step ahead and explain why Bollinger Bands to do not work correctly, and why most of the charting packages use a slow formula to compute them.


(1) The first flaw of Bollinger Bands is that they only use the bar close as an input. Other data which is available, such as the open, high & low is neglected. The important point here is that each price bar stands for a price volume distribution, which is unknown. The market profile theory has the price bar divided into time price opportunities (TPOs). Basically this is the same as assuming a linear intra-bar distribution of volume. The next refinement was to take into account the total volume of the bars, which resulted in volume-weighted time price opportunities. However, the linear price volume distribution neglects the fact that the aggregate volume per price level is typically higher within the body of the bar when compared to the upper and lower shadows. This problem can be solved by calculating the standard deviation from high, low, open, close, midline and midline of the body.

(2) The second flaw of Bollinger Bands is that neither the moving average nor the standard deviation take into account volume. Replace the SMA with the volume-weighted moving average and replace the simple standard deviation with a volume-weighted standard deviation, and everything is good.

(3) The formula used for computing the standard deviation typically calculates the difference between contract price and the mean, then adds up all the squares of the differences and divides by the number of contracts to find the variance. The standard deviation is finally obtained by extracting the root from the variance. The problem is that this formula can be painful slow for larger samples. A simple updating formula can be used, but is widely unknown.


To fix the three problems, I have written a simple indicator - called standard deviation bands - that deals with the problems.

Daily chart: The upper chart shows the correct standard deviation bands. Statistically, about 95% of all prices should lie within the bands. The bands should also act as support and resistance. If you look at the original Bollinger Bands, you will notice that they do not open up as quickly as they should during a strong trend, and that they open up too much on the wrong side. There are clearly more than 5% of all prices outside the bands. Support and resistance do not match.




Intraday chart: The disparity in volume, for example between regular session and pre-session is much higher for intraday bars compared to daily chart. For that reason the behaviour of Bollinger Bands is even worse, when applied to intraday charts.




Why I have posted this here? The standard deviation bands calculated for the VWAPs are suffering from the same three problems:

-> only the close is used, although information on open, high, low and close is available
-> volume is not taken into account
-> instead of a fast updating formula, mostly the traditional formula is used to calculate the standard deviation

Reply With Quote
  #39 (permalink)
 steve2222 
Auckland, New Zealand
 
Experience: Beginner
Platform: Sierra Chart
Broker: AMP/CQG
Trading: Whatever moves in my timezone
Posts: 1,896 since Sep 2009
Thanks Given: 3,379
Thanks Received: 1,540


Fat Tails View Post
Let us go one step ahead and explain why Bollinger Bands to do not work correctly, and why most of the charting packages use a slow formula to compute them.

Do your comments/views pertain to just Ninja Trader or have you run some BB on Sierra Charts and verified that they suffer from the same limitations/weaknesses?

Reply With Quote
  #40 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103



steve2222 View Post
Do your comments/views pertain to just Ninja Trader or have you run some BB on Sierra Charts and verified that they suffer from the same limitations/weaknesses?

The Bollinger Bands use a well-known formula. By definition they all implementations of the Bollinger Bands indicator suffer from these weaknesses. I have basically suggested to replace SMA / StdDev in the Bollinger Bands indicator with a VWMA / volume-weighted standard deviation and to use all data available from price bars, not just the close.

I do not know which formula for the standard deviation is used by the different charting packages (see point 3 above). NinjaTrader uses a slow formula, and my suggestion was to use an updating formula instead, which would reduce CPU load for longer lookback periods. The updating formula can be used for both the classic standard deviation and the volume-weighted standard deviation indicator.

Reply With Quote
Thanked by:




Last Updated on December 28, 2023


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts