How to calculate rolling VWAP
Hi guys,
excuse my noobness but could someone please explain how to calculate rolling VWAP, i.e. 30/60/90 day, and its significance? I understand the point of VWAP but the rolling day calculation escapes me. I would have thought that we would just use the daily VWAP across a period.
Please help.
Thank you.
What is VWAP?
VWAP stands for Volume Weighted Average Price. It is calculated as the total dollar amount of trades in a particular security during a particular period divided by the total number of shares traded for that period. Typically, it is calculated for one day, but some traders will use different time periods. VWAP smooths out any “noise” – or big spikes or drops – in a share price throughout the measurement period. Some traders use rolling or moving VWAP (ex: 30/60/90 days) to provide additional indication on the trend of the prices, momentum, etc. Rolling or moving VWAP is a moving average trend line, an average of the averages. It’s easy to get this data in Bloomberg: TICKER -> VWAP -> GO.
How is VWAP Used?
- Helps traders determine good price to buy and sell the stock
- Helps traders determine where momentum is with a stock
- Used by mutual funds to determine when to buy/sell stock so that they don’t disrupt the market with a large order
- Used in algorithmic trading strategies
- Used to determine if a stock was bought or sold at a good price
- Used by institutional investors as a benchmark to evaluate to determine the total cost of a trade
Recommended Reading
- Order Splitting with VWAP Benchmarks
- CME Group: Settlement Price Fact Sheet
- Sales & Trading Analyst Interview
- VWAP Flawed in Measuring Total Cost of Trade
Want to break into Sales & Trading?
With a network of more than 200 mentors, WSO’s Mentor Service can help increase your chance of landing a job by over 12x. Our mentors are top employees at the most selective firms. Find your mentor today.
VWAP is just what it sounds like: volume weighted average price. I suppose you could try to do this to an intraday trading level of detail but I've always seen it done by shares traded in a day x closing price, for each trading day in the period.
bloomberg will do this for you. Intraday is very important when executing a large block over a time period.
Non voluptatem vero ut rerum neque corrupti. Quia laudantium quia accusantium minus. Voluptate consequuntur quos repellat rerum eum autem rerum. Aut aut sed odit voluptatem perspiciatis accusamus similique reprehenderit.
Sed eveniet vel eos id dolor. Vel repudiandae ut possimus commodi enim facilis perspiciatis. Asperiores amet asperiores rerum voluptatibus laborum libero.
Alias autem ut et. Cupiditate rerum odio nisi aperiam id. Facilis consectetur dolor enim fugit velit. Quaerat distinctio sit provident debitis rerum ipsum possimus ea. Fuga quas saepe voluptate. Velit aliquam exercitationem quia consequuntur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...