Click icons for automatic download
Advanced Models
AutoGraph® is an Excel addin that generates automatic popup graphs when data in Excel is highlighted. An immediate graphic representation of the selected data pops up and disappears when the selection is released. 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
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 & EOD Stock Selection Tools
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 (basic) - 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
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.
Visual Basic
SummarizeUniqueToExistingFile.bas : This code will open ALL FILES WITHIN A DIRECTORY and copy a specific tab from each file to an existing file - after the tab from which it was ran.
TradeStation Strategies & Studies
Strategies
http://optionspot.blogspot.com/2009/02/shorting-strategy-for-skf.html
http://optionspot.blogspot.com/2009/02/skf-shorting-strategy-continues-to.html
Studies
Coming Soon!
StrategicModeling.com
