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.
Ut quia impedit optio et omnis excepturi. Labore atque quia exercitationem blanditiis. Et omnis adipisci voluptatem beatae quam.
Ipsam ea facere non sunt fuga. Neque officia possimus atque eos totam enim libero sit. Iure modi enim ex atque enim omnis rem.
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...