Excel Formulas for Calculating Stocks Outcome
An Excel tutorial by Peter Kalmstrom
possibility to tell Excel to calculate is a crucial feature
and the most important reason to use it. Peter Kalmstrom
has explains how to use Excel formulas in various demos
in this Tips section.
In the demo below he takes a different angle and shows some
simple formulas that are especially useful when you want
to calculate the result of your affairs on the stock market.
When you buy stocks you want their value to raise, so the
difference between the purchase price and the current value
is the most important.
This is how Peter calculates the profit or loss:
When this is done for one type of stocks, you can easily
copy the formulas to the other stock types. Peter shows
how you easily can drag relative formulas down and make
them valid for more cells.
- Calculate the purchase value by multiplying the
purchase price per stock with the number of stocks bought.
- Calculate the current value by multiplying the current
price per stock with the number of stocks bought.
- Calculate the difference between the purchase value
and the current value.
Peter uses Excel 2013 for his demo, but the formulas
he uses works for earlier versions of Excel too.