Remember when we talked about comparing stock price behaviour over the current month to historical months?
>No.
Well, it's here.
The spreadsheet finds the "best" historical match to the current month and extrapolates to see what next month might be like.
Anyway, I ran across a website that mentioned this comparison spreadsheet.
He calls it the Ponzo Time Machine.
However, the author does one better: He identifies the five best historical matches and extrapolates from all five.
That is **SO** slick. Now why didn't I think of that!?
| DOW: extrapolated |
Anyway, I've modified the spreadsheet to allow you to go forward or backward to check out all the "best" matches.
Now that's great fun!!
Here's what I get for the DOW (where, by "best", I minimize the max |error|:
Best match: Max|error| =11.63 |
2nd-Best match: Max|error| =14.46 |
3rd-Best match: Max|error| =17.76 |
4th-Best match: Max|error| =19.23 |
|