We:
- Pick a stock that we're interested in
- Pick six prospective “cousins” (In cells M1 to M6)
- Move a slider to pick a range of days over which we identify Maximum and Minimum (Example: we're look at Max & Min over 20 days)
What does that mean … looking at Max & Min over 20 days?
We run through all the days and identify those days that have the Maximum price over a 40-day range, from -20 days to +20 days.
Then we stick the date on the charts.
Finally, we:
We run through all the days and identify those days that have the Maximum price over a 40-day range, from -20 days to +20 days.
Then we stick the date on the charts.
Finally, we:
- Move another slider to pick one of the six stocks
Each time we move that stock-picker slider, a year's worth of prices are downloaded for the “stock of interest” and the prospective cousin … and the charts updated.
That's it?
