Microsoft Excel for stock and option traders: build your own analytical tools for higher returns

The value of information — The struggle for a statistical edge — Fingerprinting the market — Graphical approaches to discovering price-change relationships — Focusing on a statistical anomaly — Capitalizing on rare events — Predicting corrections — Brief time frames — The basics — Spreadsheet versus database — Managing date formats — Aligning records by date — Decimal date conversion — Volatility calculations — Descriptive ratios — Creating summary tables — Discovering statistical correlations — Creating trendlines — Time frames — Building and testing a model — Sample results.
.