.
| Click each corresponding icon to automatically start the download - please be patient as file size ranges from <1MB to 7MB | |
|---|---|
Advanced Models |
|
 |
AutoGraph® is an add-in that generates automatic popup graphs when data in Excel is highlighted. An immediate graphic representation of the data is shown in real-time to assist in data analysis. Whether doing stock, financial, budget, sales, or non-financial analysis, it is often helpful to see graphically and quickly if and where there are any trends, spikes, or cyclical occurrences. |
Option Analysis - click icon to launch download |
|
 |
Iron Condor Calculator - This model is designed specifically to help analyze the Iron Condor option trading strategy. It will show you how to import the most recent stock/index data and help you determine what strike prices are appropriate depending on your appropriate risk/reward situation. Some traders of this strategy like to choose their strike prices based on delta, others on std deviations, others on risk/reward - this model will calculate all of the above. It will then calculate the theoretical value of all options involved, breakeven points, greeks, and graphically show you the position's P&L. |
 |
Option Adjust - This model is designed to help users in adjusting option positions. Assume that you have entered a trade and, as expected, the underlying moved up, down, or sideways. You can obviously hold or liquidate your position; or you can proactively manage your position. Based on your initial position, what the underlying has done, and your future outlook, this model can recommend several ways for you to lock in profits, limit risk, or even generate additional income. |
 |
Correlation Analysis (for Pairs Trading) - This model will help you identify and graph the relationship between two securities. The theory of pairs trading suggests that highly correlated stocks will revert back to a particular ratio over time. When this price ratio exceeds two standard deviations from its mean, an opportunity is presented. Buy the stock that lags the historical average and short the one leading it. You're not betting on direction, only on the theory of mean reversion. |
Backtesting & Real-Time Stock Selection Tools - click icon to launch download |
|
 |
Trend5 - This model calculates a proprietary, yet customizable, indicator that determines first, whether a security is trending and second, the strength of the trend. With one click, the model calculates MACD, RSI, multiple moving averages, ADX, and an efficiency of movement measure. It then combines and weights these standalone measures to calculate one mega-trending indicator that is much more reliable. |
 |
Sector Analyzer - Choose up to 10 stocks, ETFs, and/or indexes and Sector Analyzer will do the rest. It will visually show you how the security is preforming relative to several of its moving day averages. It can help you identify strength in a particluar sector/industry and how that strength (weakness) has developed over the last several weeks. |
 |
Dynamic Graph - This model uses historical stock quotes to create dynamic candlestick charts. Dynamic graphs are perfect for quickly and visually analyzing stocks over different periods of time. |
 |
Historical Data Importer - With the push of a button, instantly download all historical data for any security. Merge this tool with your existing spreadsheet to more efficiently analyze, backtest, chart, etc. |
Research - click icon to launch download |
|
 |
List 1 - Comprehensive list of all S&P, NASDAQ, and DOW component stocks. Also a listing of all industries (with built-in hyperlinks to Yahoo) and the top five stocks in each sector based on market capitalization. |
TradeStation / MetaStock code (in development) |
|
  |
|
Guest Submissions |
|
 |
StrategicModeling.com is asking for your help. If you have any Excel models, VB code, MetaStock code,or any other quant models that you'd like to submit - please do. We'll give you as much or as little credit as you like and you will be personally helping us build this site into one of the only FREE resources for strategic modeling. |
Tutorials |
|
| 1. How to buy stock...Synthetically | |
| 2. Outright Options vs. Debit Spreads | |
| 3. Ratio Spreads | |
