Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

dbntina

VWAP Indicator with 1SD and 2SD bands

Recommended Posts

Guys I am not a TS coding guru by any means...still new at it but wanted to share this code if anyone else was interested. Just wrote this code for myself to keep up with JPERL's threads on Market Statistics. It plots the VWAP, and 1st and 2nd Standard Deviation bands. It lines up with his numbers within a tick or two so I think it is working correctly.

 

Any other TS coders out there please take a look because it can probably be improved upon.

 

This is my first post of a file so if I screwed something up...be gentle!

 

Hope this helps,

 

dbntina

boxmeister :)

DBVWAP_SD.ELD

Share this post


Link to post
Share on other sites

Good post mate. I've been wanting to do this since reading Jpearls threads. I am however using ninja trader, so (if you dont mind) Im going to try and convert your code to ninja script.

 

I dont think there are too many ninja users out there - everybody seems to use esignal or tradestation!

 

Cheers, Jay.

Share this post


Link to post
Share on other sites

Hi DbnTina,

I am not sure if the calculation for vi is correct.

In your EL you have used

variance_i = ((UpTicks[Value1]+DownTicks[Value1])/ShareW) * (Square(AvgPrice-VolWAPValue));

 

where (UpTicks+DownTicks) represents volume of the bar ... I think in a probability calculation one should use total volume at price i, not just volume of the bar i. Lets ask Jerry for clarification.

Share this post


Link to post
Share on other sites

Hi DbnTina,

I am not sure if the calculation for vi is correct.

In your EL you have used

variance_i = ((UpTicks[Value1]+DownTicks[Value1])/ShareW) * (Square(AvgPrice-VolWAPValue));

 

where (UpTicks+DownTicks) represents volume of the bar ... I think in a probability calculation one should use total volume at price i, not just volume of the bar i. Lets ask Jerry for clarification.

 

 

 

 

NickM001,

 

You are correct. In the code, ShareW is always the total share volume up to the current time from your start. You divide the volume of the current bar by the total volume and use this "normalized volume" to multiply with according to Jerry. This should be correct if I am understanding the formula correctly. It also seems to line up with Jerry's bands so I think it is correct.

 

Let me know...I can correct if I am not suppossed to normalize this way...

 

Thanks for taking a look at the code if it is incorrect we want to find out now.

 

dbntina :)

Share this post


Link to post
Share on other sites

Hi dbntina,

 

Thank you for your contribution. If you happen to need any updating on the code, threads here can be edited at anytime so please feel free to do so. Also, would it be possible to add a screenshot of the indicator in action? It would help traders give a visual clue on what the indicator is all about. Thanks.

Share this post


Link to post
Share on other sites

OK let me try to explain again my understanding of the formula. Let quote what Jerry wrote in his explanation:

QUOTE#######################################

While we won't address all these questions in one thread their answers can be obtained by analysis of the volume distribution function. To do so requires that we introduce a third property of the volume distribution function called the Standard Deviation of the VWAP, SD for short. SD is computed from the following equations:

 

NOTE : Formula did not copy ... see http://www.traderslaboratory.com/forums/f6/trading-with-market-statistics-iv-standard-2101.html

 

where the summation subscript i, runs over all prices in the volume distribution

pi = ith price in the volume distribution

Pi = vi/V is the probability of occurrence of price pi

vi = the volume traded at price pi from the volume distribution

V = total volume for the entire distribution

#################################

 

Note that factor vi is volume traded at price pi. If I understand your code, you have used volume of the bar, or volume at time , not as described in the formula.

 

To get proper value for vi, you would have to keep track of all the volume distribution at EACH price level of the range in the array and use the value of volume array element that corresponds to price pi. It can be done, but it would take more then few lines of code, unfortunately.

 

For some odd reason, it does not seem to make much difference even if you set vi/V = 1, for the few sample charts I looked at. So for all practical purposes, SD value is usable...

Share this post


Link to post
Share on other sites

I think it's considered an 'acceptable' trade of computational complexity/speed against accuracy.

 

You can control the accuracy by putting a second series of lower timeframe bars and applying the indicator to that perhaps? (hide the second series). A 1 tick series should be completely accurate?

 

Just a thought.

 

Oh and thanks Dbntina!

Share this post


Link to post
Share on other sites

Nick,

 

You are exactly correct...I know what you are getting at for sure. Blowfish is exactly right...the code I wrote on a 10M bar will do what you are getting at but only at 10M increments. A 5M bar will be more accurate...then a 3M bar will be even more accurate...then a 2M bar will be even more accurate...etc. Jerry is content using a 2M bar. Technically you would have to run it how you are describing to get it exact but I am not sure that it is necessary according Jerry he thinks running it on a 2M bar is close enough.

 

I understand though what you are saying because if I remember my match classes correctly it is a continuous function not a discrete function? I am approximating (so is Jerry I believe) using calculations at every 2 minutes (discrete) when the true value would be evaluated constantly like a continuous function.

 

We will get more and more accurate as will decrease our bar interval. But knowing that the bands are truly at .38 on the S&P as oppossed to having our numbers 1 to 2 ticks off (I don't know if this is the case but I am just giving an example) I think it is close enough on a 2M according to Jerry.

 

Let me know if I am misunderstanding what you are getting at...the important thing is that the code is doing the same thing as Jerry's code on a 2 minute chart...that was all I was trying to accomplish so I could follow Jerry's logic and trade management.

 

dbntina :)

Share this post


Link to post
Share on other sites

I don't want to beat this to death, since the code is performing close enough to what Jerry has. However, it is only important if you decide to expand the code to include volume distribution. At that point you will realize that assumptions made in this code are not valid in all cases. It is accurate observation that the smaller the time frame is, the more accurate calculation becomes, simply because there is an underlying assumption that the volume was constant within the bar interval ( we know the total volume of the bar, and range of the bar). Calculation will be accurate as long as the price does not hit the same level more then once. Now suppose that we have a consolidation day when the price moves back and forth several times thru the range. Every time it comes to the price pi, you will have to add volume of that instance to previous volume at the same price and build volume histogram bar for the price pi. Now when you do calculation for the SD, you would take sum of the volume at price pi and divide it with total volume for the session . I hope that this explanation is better then previous attempts.

Share this post


Link to post
Share on other sites

Nick,

 

I hope I didn't mislead anyone. I should have been more clear. The indicator I posted does not give the exact VWAP or SD bands. It most definitely is an approximation. I am only trying to create the identical indicator Jerry uses on his 2min charts for TS users.

 

It should be the exact way that Jerry told us to caculate it. That is all I am trying to accomplish. He said to take the open/hi/low/close and divide by 4, for the price bar...that in itself already throws some level of accuracy out the window. However I am normalizing the volume according to the way he said to do it I think.

 

I would like people to check the code for accuracy according to the way Jerry does it...not for exact accuracy of VWAP and SD bands...I already know it is not to that level of accuracy.

 

Hopefully everyone is clear on what the indicator is doing now. But I agree with you it is not accurate the way you are talking about...that was not my intention. My intention was to create Jerry's indicator for TS users.

 

Hope that clears it up,

 

Thanks,

 

dbntina :)

Share this post


Link to post
Share on other sites
Soultrader,

 

I have the screenshot. Can you point me to the instructions on how to add the image to the eld?

 

Thanks,

 

dbntina

 

Hi dbntina,

 

You should be able to edit your first post and then edit the attachment manager. Pm me if you are still having problems.

Share this post


Link to post
Share on other sites

Soultrader, I still can't find how to edit my original post...having said that...

 

I have coded the VWAP, SD bands and PVP on a tick by tick basis on a 1 Tick chart. I was thinking I could simply hide the 1 tick chart and plot the indicators on a 2 minute chart and everything would be cool...problem is that it gives me an error "Tick and Volume intervals cannot be used in a mult-symbol chart".

 

Does anyone know of a way around this to plot the data gathered from the 1Tick to plot on a minute chart? There has to be a way around this. Maybe creating a function and access...I don't know just thinking out loud...like I said I am new to the functionality of TS and need help.

 

I will post for all TS users for free if we can get this thing figured out.

 

Any help is appreciated. This should be the fix that NICK was pointing out for accuracy in the indicator thread.

 

dbntina ;)

Share this post


Link to post
Share on other sites

You would put the 1 tick series on the chart add the indicator on that series then, then hide the initial 1 tick series.

 

Simply add a second 2 5 10 15 minute data series of the same instrument (whatever you want to trade from) to the chart.

 

Cheers,

 

PS. have you posted the PvP yet I could not see it

PPS. Great work!! Thanks you (if I had not already thanked you).

Share this post


Link to post
Share on other sites
Guest cooter
You would put the 1 tick series on the chart add the indicator on that series then, then hide the initial 1 tick series.

 

Simply add a second 2 5 10 15 minute data series of the same instrument (whatever you want to trade from) to the chart.

 

Cheers,

 

PS. have you posted the PvP yet I could not see it

PPS. Great work!! Thanks you (if I had not already thanked you).

 

That doesn't work on Tradestation as you can't mix and match tick and minute data series on the same chart.

 

Try ADE (all data anywhere) as a workaround. You'll find more info about it in the Tradestation.com forums.

Share this post


Link to post
Share on other sites

Does anyone here use Amibroker for their charts? The programming language seems very flexible, I just wish I knew how to program! If someone could convert these for that program I would be eternally grateful. Specifically the standard deviations for the VWAP. Thanks!

Share this post


Link to post
Share on other sites

Thanks Cooter and Blowfish for your help...finally got ADE working and I can see the PVP on my minute charts with the VWAP and SD bands...appreciate the knowledge on this board!

 

Testing it out now for a few days.

 

dbntina

Share this post


Link to post
Share on other sites

Could someone tell me which of these SD bands look correct (yellow or blue). Actually I cant work out why they differ as the actual formula I use is the same in both, I just am summing the bars slightly differently.

 

Be really great full if someone could compare with ensigns finishing values. Note that the YM chart ends at 3.15pm central

 

Cheers.

Nick

SDBands.thumb.png.8098b835c0573511cf6875db1834124e.png

SDBands1.thumb.png.f879a537f3f61126099248dc3f015ef0.png

Share this post


Link to post
Share on other sites

OK figured out what was wrong with the last two indicators but have come up with something that I think is OK.

 

The reason for this is that there are some performance issues with the indicator here as it has to scan the series back to the days start when there is a new tick. Applying it to a tick chart (especially at the end of the day) it slows right down.

 

Anyway I figured there should be a way to do it using running statistics and indeed there is. There is a side benefit to doing it this way as you don't get cumulative rounding errors (according to the signal processing guys). This does not get rid of the sampling inaccuracy that Nick mentions earlier in the thread.

 

I'd welcome comments? I wonder if rounding errors would explain the 2 or 3 ticks difference?

SDBands2.thumb.png.de3c7b969a32149f625f725f3d8a61dc.png

Share this post


Link to post
Share on other sites

One last chart a 1 tick of the same period as the last post (yesterdays ER2). Looks good to me? It is much much quicker this way and its plausible to run it on 1 tick charts (meaning complete accuracy is attainable if desired). If it looks good enough I'll upload it.

 

Incidentally watching PvP for the last week or two and comparing tick precise with 1 & 2 minutes I think I might have changed my mind - tick precise would have kept you out of a couple of bad trades due to quicker 'flipping'

 

Cheers

SDBands3.thumb.png.e2771bb7f91a4cf90df76e235f6580ac.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • Date : 7th April 2020. FX Update – April 7 – A wee bit more Risk. Trading Leveraged Products is risky AUDUSD & GBPUSD, H1 The commodity currencies outperformed some more, as did many developing-world currencies amid a backdrop of rising stock and commodity markets. Equity markets are amid day two of a rally pinned on tentative signs that the global coronavirus infection and mortality rates might be near to peaking. The Fed’s decision to finance new “payroll protection” loans has also bolstered the US economic response plans. AUDUSD has rallied 1.7% in printing a one-week high at 0.6192, while AUDJPY has rallied by 1.4% in making a high at 67.38. The Aussie dollar is now up 3% from last Friday’s closing levels. The Kiwi and Canadian dollars are also up. USDCAD has dropped to an eight-day low at 1.4011. The Dollar, Yen and, to a lesser degree, the Swiss Franc, have continued to underperform most other currencies. The narrow trade-weighted USDIndex has declined by 0.6% in pegging a five-day low at 100.79, while EURUSD concurrently lifted by 0.7% in making a five-day high, at 1.0876. The pair is up by just over 1% from its Monday lows. The combination of risk-on positioning in markets and the Fed’s aggressive dollar liquidity provisions, which forms part of a crisis-era level of monetary accommodation, have been bearish tonic for the Dollar. Dollar underperformance saw USDJPY dip back under 109.00, though the Yen itself trader softer against most other currencies as its safe-haven premium is whittled down. Sterling dipped on the news that PM Johnson was moved to ICU and had received oxygen, although Downing Street stated that he was still conscience and that Foreign Secretary Dominic Raab will lead the UK government as long as Johnson is incapacitated. From lows of 1.2162 earlier, a weaker USD, has Cable rally over 170 pips to 1.2335. Next resistance is R2 and the upper Bollinger band around 1.2375, 1.2400 and then R3 at 1.2420. Support sits at 1.2300 and the Daily Pivot Point, a 50.0 Fibonacci level and 200hr moving average at 1.2250. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HotForex Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Stuart Cowell Head Market Analyst HotForex Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • CloseOption Broker is currently trying in completing the project binary options (Financial Betting Platform) with a special platform and due to the simplicity Platform and having good performance they will attract and absorb soon many clients and partners. This Broker accepts CryptoCurrencies, Paypal, PerfectMoney & Credit Cards Deposits! Minimum Deposit: 5$ CloseOption - 2.400$ Weekly Tournament - 1st Place win 750$ (first 10 places win money) Read CloseOption Broker Review - https://1binaryoptions.eu/review/close-option/
    • PocketOption Broker Announces: Entering payments through stable cryptocurrency (stablecoin) PAX and Tether Add funds to your Pocket Option trading account, and withdraw from your account using two popular "stablecoins": PAX or Tether. The funds are automatically credited after receiving the required number of confirmations in the blockchain. Please note that we do not accept payments through Smart Contracts. About stable cryptocurrencies (stablecoins) Both Paxos Standard (PAX) and Tether (USDT) combine the stability of the US Dollar with the efficiency of blockchain technology. Like any other cryptocurrency, funds can be moved instantly, anywhere in the world, at any time of any day. Unlike other cryptocurrencies, PAX and Tether are stable and covered 1: 1 by the Dollar, which includes traditional currency and cash equivalents, etc. Thus, the funds are carefully protected, audited and regulated. Pocket Option Broker USA Customers Welcome | Binary Options No Deposit Bonus! - https://binaryoptionsfree.eu/review/pocket-option/
    • Date : 6th April 2020. Events to Look Out For Next WeekIt’s a holiday shortened week ahead as most markets will be closed on Friday for the Easter holidays, however the novel coronavirus remains the focal point. The rapid upswing in market volatility seen in March should continue in April as governments, central banks, households and businesses further adapt to the ongoing pandemic and uncertain outlook. Hence this will be another week of increased attention to the data which will incorporate more of the impacts of the global shutdowns and will help start to quantify the severity of the economic impacts amid still very uncertain times.Monday – 06 April 2020   OPEC Meeting (USOIL, GMT 19:00) – Azerbaijan’s energy ministry said that a meeting of the OPEC+ group of oil producers is planned for April 6 and will be held as a video conference. Tuesday – 07 April 2020 Interest Rate Decision and Monetary Policy Statement (AUD, GMT 04:30) – Positioning in 30-day interbank cash rate futures this week implied a 60% chance for the RBA to cut its benchmark interest rate to zero from 0.25% at the upcoming policy meeting, which is up from odds of 31% for such a move that were being discounted just over a week ago. However in the March RBA minutes, they provided colour around the 25bp rate cut and the adoption of QE but they made clear that there is no appetite for negative interest rates. JOLTS Job Openings (USD, GMT 14:00) – JOLTS define Job Openings as all positions that have not been filled on the last business day of the month. February’s JOLTS job openings is expected to fall slightly at 6.476M, following the 6.963M in January. Ivey PMI (CAD, GMT 15:00) – A survey of purchasing managers, the Index provides an overview of the state of business conditions in the country. API weekly Crude Oil Stocks (USOIL, GMT 20:30) Wednesday – 08 April 2020   EIA weekly Crude Oil Stocks Change (USOIL, GMT 14:30) FOMC Minutes (USD, GMT 18:00) – The FOMC Minutes report provides the FOMC Members’ opinions regarding the US economic outlook and any views regarding future rate hikes. In the last FOMC statement, on March 15, the FOMC slashed rates 100 bps to 0% – 0.25% in an emergency move, getting ahead of the curve. Thursday – 09 April 2020   ECB Monetary Policy Meeting Accounts (EUR, GMT 11:30) – The ECB Monetary Policy Meeting Accounts provide information with regards to the policymakers’ rationale behind their decisions. At the same time, in the last meeting, ECB announced a EUR 750 bln pandemic emergency program (PEPP) and introduced new QE measures worth EUR 120 bln and additional loan programs, while they left rates unchanged at the March policy meeting. Producer Price Index (USD, GMT 12:30) – The Headline PPI is expected to decline to a -0.2% March PPI headline with a 0.2% increase in the core index. The continued energy price pull-back through the month likely weighed on the headline. Employment Change (CAD, GMT 12:30) – Employment change is seen spiking to 10.0k in the number of employed people in March, compared to the spike at 30.3k in February. The unemployment rate is expected to remain at 5.6%. Michigan Consumer Sentiment Index (USD, GMT 14:00) – The preliminary April Michigan sentiment reading is forecast at 95, up from the 89.1 in March. Friday – 10 April 2020   Consumer Price Index (CNY, GMT 01:30) – The March’s Chinese CPI is expected to remain unchanged on a monthly and yearly basis. Consumer Price Index and Core (USD, GMT 12:30) – The headline CPI has been estimated to a -0.2% March headline CPI drop with a 0.2% core price increase, following respective February readings of 0.1% and 0.2%. As with PPI, the headline inflation figures will be depressed well into 2020 from the OPEC price war, though the core figures will face divergent pressures that are partly downward due to diminished demand with COVID-19, but upward due to supply shortages that may prompt some erratic swings. Always trade with strict risk management. Your capital is the single most important aspect of your trading business.Click HERE to access the full HotForex Economic calendar.Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE!Click HERE to READ more Market news. Andria Pichidi Market Analyst HotForex Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • Bitcoin (BTC) Drops To $6,828 After A Sudden Price Spike To $7,283 Key Resistance Zones: $10,000, $11,000, $12,000 Key Support Zones: $7, 000, $6, 000, $5,000 BTC/USD Long-term Trend: Bearish On March 2, there was a price spike as Bitcoin reached a high of $7,283.50. The bulls could not sustain the upward move as Bitcoin fell to $6,828. The bears are defending intensively the $7,000 overhead resistance. BTC is now fluctuating above $6,800. The bears will further sink BTC if the bulls fail to move up. Bitcoin may fall to the low of the breakout level of $6,400. However, if this level also cracks, the market will further fall to the next support. BTC/USD – Daily Chart Daily Chart Indicators Reading: Bitcoin is above 60% range of the daily stochastic. This is given the recent price spike which tested the resistance line of the descending channel. However, if price breaks and closes above the resistance line, there will be a change in the trend. BTC will resume an uptrend. BTC/USD Medium-term Trend: Bullish Yesterday, BTC was making an upward move to retest the $7,000 resistance. The price has earlier moved up to $6,800 before the commencement of price spike. The market moved above the resistance level but could not sustain above $7,000 because of the selling pressure. BTC/USD 4-hour Chart Indicators Reading The Relative Strength Index has risen to level 66. It indicates that BTC is in the uptrend zone and above the centerline 50. The 21-day and 50-day SMAs are sloping upward indicating the upward move. General Outlook for Bitcoin (BTC) Yesterday, Bitcoin rose to $7,283 in a price spike. The bulls could not sustain the upward move because of the presence of sellers at the price level. BTC dropped to a low of $6,800. The price has since been fluctuating above that level. Instrument: BTC/USD Order: Sell Entry price: $6,784.00 Stop: $6,850.00 Target: $6,584.00   Source: https://learn2.trade 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.