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