J
Jim
About a year ago when the stock market was falling, I wrote a worksheet to
show my gains or losses.
First I listed each of my stock and mutual funds holdings. For each security
I compare my cost basis against the current value of the security and place
that gain/loss in a column. The column to then totaled ($3230.07) with the
resultant value equal to my total gain or loss for the day.
Gain/Loss
-$814.83
$1,497.13
$2,892.72
-$153.67
-$191.27
$3,230.07
$3,230.07
Max/Gain/Loss
-$5,498.36
Mim Gain/Loss
I then wrote a little routine to keep track to the Max/Min gain or loss. In
the example shown above, the MAX Gain or Min Gain numbers will only change
if the gain is more then $3230.07 or the loss is greater then -$5498.36 What
controls this entire operation is MSN MonyCenteral Stocks Quotes.
This may sound rather stupid but I simply cannot recall how I wrote this
code more then a year ago. I can not find a micro or formula which does
this. It’s driving me nuts!!
Suggestions greatly appreciated
show my gains or losses.
First I listed each of my stock and mutual funds holdings. For each security
I compare my cost basis against the current value of the security and place
that gain/loss in a column. The column to then totaled ($3230.07) with the
resultant value equal to my total gain or loss for the day.
Gain/Loss
-$814.83
$1,497.13
$2,892.72
-$153.67
-$191.27
$3,230.07
$3,230.07
Max/Gain/Loss
-$5,498.36
Mim Gain/Loss
I then wrote a little routine to keep track to the Max/Min gain or loss. In
the example shown above, the MAX Gain or Min Gain numbers will only change
if the gain is more then $3230.07 or the loss is greater then -$5498.36 What
controls this entire operation is MSN MonyCenteral Stocks Quotes.
This may sound rather stupid but I simply cannot recall how I wrote this
code more then a year ago. I can not find a micro or formula which does
this. It’s driving me nuts!!
Suggestions greatly appreciated