MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Tracking Stock


Posted by abe on June 18, 2001 12:04 PM

when the value of a stock reaches the original purchase price excel tells me that the total value is $.00 how what is the right formula? Thank you!


Posted by IML on June 18, 2001 12:49 PM


value = #share owned * current price assuming no splits.

It sounds like currently it is calculating gain or loss (which may or not contain dividends)

good luck