How to calculate your weighted average price per shareWhen it comes to buying stock, a weighted average price can be used when shares of the same stock are acquired in multiple transactions over time.

A] Calculating Weighted Average when the weights add up to 100%. The above image shows the data set where the weights add up to 100%. To calculate the weighted average of this data set in Excel ...

Divide your sales generated during the accounting period by the number of days in the period to calculate your average daily sales. In the example, divide your annual sales of $40,000 by 365 to ...