Multiply each transaction price by the corresponding number of shares. Volume Weighted Average Price VWAP Calculation. In words this means that you multiply each price you paid by the number of shares you bought at that.
This spreadsheet lists the different computer prices in cells A2-A4 and the corresponding numbers of computers purchased in cells B2-B4.
To do this add the high low. Calculate the number of shares traded. The formula for calculating VWAP is as following. Like moving averages VWAP lags price because it is an average based on past data.