Quote:
Originally Posted by jkruer01
If this is more reliable than the web queries, does anyone know why it stopped getting used?
|
Several reasons:
1. It used AdvFN to get more years of data, which is slower.
2. It required the use of the add-in, while the original is a stand-alone workbook.
3. The "WatchList" version is based on the other design.
I've always intended to go back and create a stand-alone version using extracted versions of the add-in functions, but there are so many other things I have on my "to do" list.
Plus, I have a number of changes I'd want to make to the model -- you may have noticed I've harped on the forum about GIGO ("Garbage In, Garbage Out") a number of times. I think a "Growth Estimate" based on some form of regression (and utilizing it correlation for validity) would be much better than simply using end points to compute the growth rate (and ignoring all of the intermediate data, which may show vast inconsistencies).