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

Description

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. 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.