VWAP calculation template

Volume Weighted Average Price

This is a super easy to use VWAP template calculator.

With a simple export of volume and prices you can tell the historic trading bands of a company.

For M&A bankers this is useful to understand trading bounds to set a price to acquire a company.

VWAP calculation template (Volume Weighted Average Price)

What is Volume Weighted Adjusted Price (VWAP)?

VWAP is the average price of a stock weighted by the total trading volume and is used to calculate the average price of a stock over a period of time.

What is the use of VWAP calculation?

VWAP has multiple uses. It’s most commonly found in its natural habitat of trading. But there are a number of other uses too.

Traders, including retail ones can use this as a trading signal of when to purchase
Institutional investors sometimes use the volume weighted average price to determine if a particular trade was at a favorable or unfavorable price
ECM teams will use this as they communicate with clients during general coverage, but also during issuances
In M&A, the VWAP is often used to determine the premiums paid during an acquisition.

There are also some financial regulations such as around ‘stakebuilding‘ which require the use of this number in determining the prices they are obliged to pay

Generally, the offeror is obliged to offer a price that equals at least to the price paid for securities of the target company between the announcement of the offer and the date that is six months from the expiration of the additional acceptance period (best price rule). In mandatory offers, the offer price must be at least equal to the 60 days VWAP (if the stock is liquid) or the highest price paid for securities of the target company by the offeror in the last 12 months preceding the offer, whichever is higher (minimum price rule). Consequently, in case the bidder pays a higher price before or outside the offer, it is required to equally offer such a higher price in its public tender offer.)

For my personal use, I’ve only once had to calculate VWAP which was when evaluating potential targets and getting a feeling what the general trading price and therefore market cap is to calculate a baseline enterprise value, before digging deeper.

Significance in Investment Banking

Execution Benchmark: VWAP serves as a neutral benchmark for assessing trade execution quality. It’s particularly crucial when executing large orders for clients, where beating or matching VWAP can demonstrate value-add.
Block Trading: When facilitating large block trades, VWAP helps in determining fair pricing and in executing trades with minimal market impact.
Algorithmic Trading: VWAP-based algorithms are fundamental in executing large orders over time, aiming to match or beat the VWAP benchmark.
M&A Transactions: In merger and acquisition deals, VWAP over extended periods (e.g., 30-day VWAP) is often used as a reference price for determining acquisition premiums or in earn-out clauses.
Risk Management: VWAP aids in assessing the quality of trades executed by traders or algorithms, serving as a key component in transaction cost analysis (TCA).
Market Microstructure Analysis: VWAP provides insights into intraday liquidity patterns and can inform optimal trade timing and order routing decisions.

Advanced Applications

Multi-Day VWAP: For extended trading programs, calculating VWAP across multiple days can provide a more stable benchmark for longer-term execution strategies.
Volume Prediction: Accurate VWAP trading often relies on predicting intraday volume profiles. Sophisticated models incorporating historical patterns, market events, and even alternative data can enhance these predictions.
Cross-Asset VWAP: For complex products like ETFs or in pairs trading strategies, considering VWAP across multiple correlated assets simultaneously can provide a more holistic view of execution quality.
Dark Pool Strategies: VWAP can inform intelligent order routing between lit and dark venues, balancing the trade-off between price improvement and certainty of execution.

Regulatory Considerations

Post-financial crisis regulations have increased the importance of VWAP:

Best Execution: MiFID II and similar regulations globally often reference VWAP as a benchmark for demonstrating best execution.
Trade Surveillance: Significant deviations from VWAP can trigger alerts in trade surveillance systems, helping to identify potential market manipulation.

Limitations

As sophisticated market participants, it’s crucial to understand VWAP’s limitations:

Backward-Looking: VWAP is inherently a backward-looking metric and doesn’t predict future price movements.
Market Impact: For very large orders, trading to VWAP can itself impact the VWAP, potentially creating a feedback loop.
Applicability: In illiquid markets or for thinly traded securities, VWAP may not be a reliable benchmark.