David Lavie is a writer and editor with two decades' experience in marketing communications, equity research and publishing. He is a founding partner in Quartet Communications, where, as Head of ...

Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252. Remember, standard ...

To calculate a price-weighted average, sum the stock prices and divide by the number of stocks. This average reflects changes in higher-priced stocks more than lower-priced ones. Use price-weighted ...