Registered: Aug 2011
07-16-12 02:24 AM
this little read here from the book i was talking about explains alot
With the appropriate infrastructure of databases and related
software in place, it is possible to construct a library of calendar-
based price-change charts. Results can be tabulated by
day, week, month, quarter, or any other time frame that makes
sense. Securities can be grouped according to a variety of criteriaβ
industry group, price range, historical volatility, trading
volume, market capitalization, short interest, and so forth. The
most sophisticated designs will also include customized query
tools that can be used to answer a variety of historical questions.
It is also necessary to recalculate calendar-based information
on a regular basis because, as we just saw, the profiles
change. We will return to this discussion in various forms as we
explore different approaches to data mining and feature identification
in large datasets.
Just a few years ago this type of analysis would have
required advanced database skills and programming tools.
Much of that has changed with the dramatic increases in the
speed and capacity of todayβs spreadsheet programs. Excel 2010
worksheets can exceed 1,000,000 rows and 16,384 columns.
Just 3 years before this book was written, prior to the launch of
Excel 2007, the limits were 65,536 rows and 256 columns.