| Calmar Ratio | x | x | |
| Treynor Ratio | x | x | |
| How to Calculate Beta | x | x | |
| Sharpe Ratio | x | x | |
| Sortino Ratio | x | x | |
| Jensen's Alpha | x | x | |
| Information Ratio | x | x | |
| Historical Volatility | x | x | Calculation steps and spreadsheet that calcualtes historical volatility from Yahoo stock quotes |
| Kappa | x | x | |
| Stutzer Index | x | x | |
| Maximum Drawdown | x | x | VBA function |
| Stock Screener for Excel with Automatic Data Download | | x | Downloads financial data for over 6800 ticker symbols (over 60 items per ticker). Customizable filtering. |
| Average True Range | x | x | |
| Stock Comparison Spreadsheet | | x | Retrieves data from web. Compare finance info for 10 stocks |
| Trading Journal Spreadsheet | | x | Record historical stock trades, suggests stop-loss, summarizes portfolio position, P&L |
| Relative Strength Index | x | x | |
| Compound Annual Growth Rate | x | x | Learn how to calculate CAGR in Excel, and discover its limitations |
| Ulcer Index | x | x | A tool for measuring the stress of holding an investment |
| How to Calculate MACD in Excel | x | x | |
| Generate trading signals with MACD | | x | |
| How to Annualize Volatility | x | | |
| How to Calculate EMA in Excel | x | x | Tutorial and free web-connected spreadsheet with full open VBA |
| Zephyr Pain Index | x | x | |
| Williams %R | x | x | Trading guide and spreadsheet with Internet connectivity |
| Measure the strength of a treend with Aroon | x | | |
| Calculate Aroon with Excel and VBA | x | x | |
| Stochastic Oscillator | x | x | Calculation guide, and spreadsheet |
| Stock Returns Histogram | | x | A spreadsheet that downloads historical prices for any ticker and plots a returns distribution |
| Upside Potential Ratio | x | x | VBA and Excel worksheet formula |
| RSI Trading Strategy Game | x | x | Backtest a simple RSI-based trading strategy. Adapt the VBA for more sophisticated strategies |
| Accumulation Distribution Line | x | x | |
| Chaikin Oscillator – Spreadsheet with VBA | x | x | |
| Calculate On-Balance Volume in Excel | x | x | |
| Force Index for Technical Traders | x | x | |
Wonderful work.
Are you able to build a spreadsheet for relative strength against the overall market for aprox. 1000
shares.
Regards
James Ker