How Do You Calculate Weighted Average Shares?
The weighted average volume of stock is a simple calculation, but an important one for calculating profits per share or measuring the efficiency of large stock purchases. Use a spreadsheet for accumulating and calculating the necessary data. A popular version of the weighted moving average is the volume weighted average price. Collect the volume and price data for the beginning and ending period you wish to measure. For example, if you want the weighted average shares for 2000, you could collect the first through the last day of trading and average the results after adjusting for additional shares or stock splits or buybacks, or collect the data on a daily, weekly, quarterly or semiannual basis. The technique is the same; the level of specificity needed should be appropriate to your need. Compute a weighted average calculation for a stock. Accumulate specific historical prices using a stock subscription service or the free Yahoo! historical database (see Resources). Multiply and input
The weighted average volume of stock is a simple calculation, but an important one for calculating profits per share or measuring the efficiency of large stock purchases. Use a spreadsheet for accumulating and calculating the necessary data. A popular version of the weighted moving average is the volume weighted average price. Collect the volume and price data for the beginning and ending period you wish to measure. For example, if you want the weighted average shares for 2000, collect the first through the last day of trading and average the results after adjusting for additional shares or stock splits or buybacks, or collect the data on a daily, weekly, quarterly or semiannual basis. Compute a weighted average calculation for a stock. Accumulate specific historical prices using a stock subscription service or a free historical database (see Resources). Multiply and input the stock price into column 1 of the spreadsheet. In column 2, input the volume. Multiply column 1 by column 2 and
