The first step in calculating ATR is to find a series of true range values for a security. The price range of an asset for a given trading day is its high minus its low. To find an asset's true range ...

This post explains how to calculate Weighted Average in Excel with percentages. In a standard arithmetic average where the sum of values is divided by the number of values, each data value is treated ...

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

Sales revenue represents the money a company generates from selling products and services, with which it must pay operating expenses and creditors. Rising sales can help a business achieve a ...

Stock buybacks have become all the rage, and many companies routinely return capital to investors by repurchasing their shares. Yet not all companies do a good job of timing their stock repurchases.

Average trade price helps track investment performance and calculate capital gains tax. It's calculated as a weighted average, considering share quantity and price. Example: Buying stock in phases ...

If you bought all of your stock in a single transaction, it's easy to determine how your investment is performing. Simply look at the current share price and compare it to the price you paid. However, ...

There are many situations in investing in which it makes sense to look at how two different numbers related to each other over time. Whether you're talking about two stocks in the same industry, the ...