Successful investing requires the ability to distinguish long-term trends from the short-term noise that moves stock prices on a minute-to-minute basis. One way to tune out the random oscillations and ...

Correlation coefficients are indicators of the strength of the linear relationship between two different variables, x and y. A linear correlation coefficient that is greater than zero indicates a ...

The forward price-to-earnings ratio (P/E) is a valuation metric that measures and compares a company's earnings using ...

Calculating returns from your stock portfolio can be a tricky matter, especially if some of your holdings pay dividends, or you make frequent deposits and withdrawals from your account. With Excel and ...

You can figure the slope of the Security Market Line with a simple formula in Excel. The SML is the slope defined by the Capital Asset Pricing Model that shows the relative riskiness of stocks ...

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 ...