J
Jim
I'm tracking the daily closing prices of several stocks & mutual funds in an
Excel spread sheet (a1:a10 for example). What I would like to do is save the
highest and lowest price for each stock in b1:b10 (max value) and c1:c10
(min value), over the period when I start the tracking process. For example,
if stock xyz is $50 one day, store the value in b1. Next day it falls to
$45, store value in c1. Only change the values in b1 or c1 if the stock goes
above $50 or below $45.
Greatly appreciate a solution.
Excel spread sheet (a1:a10 for example). What I would like to do is save the
highest and lowest price for each stock in b1:b10 (max value) and c1:c10
(min value), over the period when I start the tracking process. For example,
if stock xyz is $50 one day, store the value in b1. Next day it falls to
$45, store value in c1. Only change the values in b1 or c1 if the stock goes
above $50 or below $45.
Greatly appreciate a solution.