How to Calculate VWAP in Excel
The volume-weighted average price (VWAP) is one of the best measurements you can utilize for your day trading endeavors. So, what's the formula and calculation?


Published November 30, 2021.
You are a day or swing trader. You want to know more than just moving averages and the Relative Strength Index (RSI). You have come across the volume-weighted average price (VWAP). You want to know the various applications of VWAP.
Well, you come to the right place, whether you want to know the VWAP calculation or the VWAP formula on Excel. Let's explore.
VWAP Calculation Formula
Here is a step-by-step breakdown of how to calculate the volume-weighted average price:
- Select your time frame (one minute, five minutes, 15 minutes, etc.)
- Calculate the typical price by adding the high, low, and close, and dividing by three.
- Multiple the typical by the volume for that time frame, known as the TPV.
- Keep track of the running total TPV values and cumulative volume.
- Calculate the VWAP.
Put simply, you add up the dollars traded for each transaction, multiply the price by the number of shares traded, and then divide the total shares traded.
Here is a VWAP calculation example:
- Price: (H+L+C)/3
- VWAP: (Volume * Price) / Volume
How to Make a VWAP Trading Strategy Excel Spreadsheet
Here is a step-by-step breakdown of how to calculate VWAP on a Microsoft Excel spreadsheet:
- A: Date / Time
- B: High
- C: Low
- D: Closed
- E: Typical Price (TP)
- F: Volume (V)
- G: TP *V
- H: Cumulative TP * V
- I: Cumulative Volume
- J: VWAP Value
Here is a screenshot of what your spreadsheet should look like using a five-minute time frame:
The VWAP Is Your New Best Friend
Whether you are a novice or seasoned investor, you will realize that the volume-weighted average price technical indicator is your new best friend. This is one of the best complements you can make for your overall investment strategy. Be it a VWAP chart or an Excel spreadsheet, you can exploit the benefits of VWAP to maximize your profits.
Related Articles

How to Identify a Good Investment Company
Sofia Thai
April 23, 2021

How to Identify Legitimate Trading Platforms
Filip Dimkovski
December 22, 2024

How to Determine When to Buy and Sell Dogecoin
Filip Dimkovski
May 25, 2021

Comparing VFV ETF vs ZSP, VOO, SPY, VUN, XUU, XUS and More
Filip Dimkovski
October 7, 2021

eToro vs. AvaTrade: Compare Products, Features, Fees, & More
Filip Dimkovski
October 25, 2021
Related Posts
Andrew Moran
How to Use the VWAP for Day Trading
Andrew Moran
What Is the VWAP Indicator?
Andrew Moran
How to Trade Using the VWAP
Andrew Moran
What Happens When Stock Crosses the VWAP?
Andrew Moran
How to Calculate the VWAP
Andrew Moran