Excel Spreadsheets.
Below are spreadsheet files that should be compatible with Excel 97 and higher versions.
Setting stops the Bayesian way, June 2013.
Spreadsheet used to demonstrate how stop levels work and how much risk various decision rules let you take as referenced in the June 2013 story by Burton Rothberg.
The put and call comfort zone, May 2009.
These spreadsheets include the LLP Pricing models referenced in the May 2009 Trading Techniques story by Paul Cretien.
Building a better strangle, March 2009.
These spreadsheets include the models referenced in the March 2009 Trading Techniques story by Paul Cretien. They should also be used in place of work sheets previously associated with Cretien's Trading Techniques stories.
Calibrating profit and loss strategies, February 2009.
This spreadsheet include the models referenced in the February 2009 Trading Techniques story by Michael Gutmann.
Comparing option pricing models.
These spreadsheets include the models referenced in the June 2008 Trading Techniques story by Paul Cretien. They should also be used in place of work sheets previously associated with Cretien's September 2006 Trading Techniques story.
Comparing option pricing models.
These spreadsheets include the models referenced in the September 2006 Trading Techniques story by Paul Cretien.
Pattern performance stats.
These spreadsheets include more of the performance statistics referenced in this article on pattern-based systematic trading. Reference article: "Trading patterns in the sand," November 2004.
Performance summary I.
First spreadsheet showing full performance summary of system discussed in article. Reference article: "Reversions of profits in stocks and bonds," February 2004.
Performance summary II.
Second spreadsheet showing full performance summary of system discussed in article. Reference article: "Reversions of profits in stocks and bonds," February 2004.
Option pricing spreadsheet.
This spreadsheet included calculation sheets for each of the naked options and the covered call. Reference article: "Covering up with options," March 2003.
Option pricing spreadsheet.
This spreadsheet uses the Black-Scholes model to provide theoretical prices for put and call options. Reference article: "New options in increasing your equity," October 2002.
Correlation table.
The entire correlation matrix depicting the relationships of returns among same - and cross-sector equities. Reference article: "Two can be better than one," September 2002.
Mathematical advantage calculator.
Spreadsheet for calculating the expected results, mathematical advantage and annual return for an options trade, given the input assumptions. Reference article: "Determining expected results of an option trade," August 2002.
Market state calculator.
Spreadsheet for determining the "state" of the market, as defined in "Listening to the markets, note by note," July 2002.
Streaks calculator.
Spreadsheet for analyzing price "streaks," as explained in "Streaking prices can be revealing," April 2002.
Fibonacci calculator.
A tool for applying Fibonacci analysis to both futures and equities. Reference article: "Trading with Fibonacci retracements," February 2002.
Retracement tool.
This spreadsheet automatically performs the retracement calculations described in "The Elliott-Fibonacci connection," October 2001.
Money management application.
This spreadsheet implements the money managment technique discussed in "3x1=More than you think," December 1999.
Software ranking table.
A spreadsheet that lets users create customized rankings of the trading software reviewed in "Day-trading software shootout," Special Issue 1999.
Market strength calculator.
Spreadsheet showing techniques for playing both long-term and short-term market strength. Reference article: "Skimming the trend," February 1999.
Repeated measures tool.
Spreadsheet applying repeated measures analysis detailed in "Out of sample, out of touch," January 1999.
Ratio-adjusted data, charts.
These spreadsheets include the charts and data used for this article on evaluating systems using ratio-adjusted data. Reference article: "Truth be told," January 1999.
Datamining example.
This spreadsheet includes the charts and data used for "Working in a coal mine," January 1999, as well as additional out-of-sample data not shown in the article.
Trading size calculators.
Calculations for the z-score, correlation and optimal f methods of money management, as described in "Scoring high and low," April 1998.
Bollinger band spreadsheet.
Spreadsheet that calculates Bollinger bands. Reference article: "Bollinger bands are more than meets the eye," November 1997.
MACD crossover forecaster.
Spreadsheet that calculates the price for tomorrow that would cause the MACD to cross tomorrow. Reference article: "Sign of the crossover," October 1997.
EMA crossover forecaster.
Spreadsheet that calculates the price for tomorrow that would cause a nine-period exponential moving average and an 18-period EMA to cross tomorrow. Reference article: "Smooth operator," September 1997.
RSI calculator.
Spreadsheet that calculates the relative strength oscillator. Reference article: "Building a better speed trap," May 1997.
Stochastics calculator.
Spreadsheet that calculates the stochastics oscillator. Reference article: "Building a better speed trap," May 1997.
Williams %R calculator.
Spreadsheet that calculates the Williams %R oscillator. Reference article: "Building a better speed trap," May 1997.
Momentum calculator.
Spreadsheet that calculates the momentum oscillator. Reference article: "A radar gun on price," April 1997.
Rate-of-change calculator.
Spreadsheet that calculates the rate-of-change oscillator. Reference article: "A radar gun on price," April 1997.
MACD calculator.
Spreadsheet that calculates the moving average convergence-divergence oscillator. Reference article: "A radar gun on price," April 1997.

Options Trading Spreadsheet Download.
The download link for the options trading spreadsheet is below. Right click on the file, and save the link to a location on your spreadsheet.
After you do your download, I suggest that you save a 2nd file using a different name. That way you will have a master file, in the event that you accidentally delete one of the spreadsheet formulas.
I am trying to make all of the input cells a different color than the formula cells.
The spreadsheet is a microsoft excel. xlsm file. If you have an earlier version of excel, then let me know and I will send you a different file to use.
Also, this is a macro enable spreadsheet.
Since the different worksheets are using macros, you may see a security warning that they have been disabled when you open the spreadsheet. If you want to use the spreadsheet, then you will need to click enable content.
Option Spreadsheet Download.
Latest spreadsheet: 12/9/2013.
Related Posts:
Risk Disclosure.
Futures and forex trading contains substantial risk and is not for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones’ financial security or life style. Only risk capital should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results.
Hypothetical Performance Disclosure.
Hypothetical performance results have many inherent limitations, some of which may described in the content on this site. No representation is being made that any account will or is likely to achieve profits or losses similar to those shown; in fact, there are frequently sharp differences between hypothetical performance results and the actual results subsequently achieved by any particular trading program. One of the limitations of hypothetical performance results is that they are generally prepared with the benefit of hindsight.

Option trader spreadsheet

Renko Chart Day Trading Strategies.
Options Profit Graph For Price Changes Before Expiration.
This worksheet for our options trading spreadsheet is an addition to the price to expiration profit graphs, where it will also give the profit curvature for the date of the options trade, along with any other date before expiration. This is very useful, considering that most single options are not held to expiration, especially when they are long option trades.
Options Pricing Spreadsheet For Theoretical Values And Greeks.
The GreeksChain worksheet for our options trading spreadsheet will give a calls and puts price chain for theoretical value and greeks, made from our user inputs for underlying price, volatility, and days to expiration. Additionally, there is a calls and puts profit section for doing whatif scenarios and position adjustments.
Stock Options Trade Position Comparison Spreadsheet.
The stock options position comparison spreadsheet will take 2 different positions and give the risk reward for both overlaid on the same profit graph. This worksheet is especially useful for doing whatif modeling for different options position types or entry prices.
Option Position Spreadsheet For Graphing Current Profits.
OptPos [option position] trading worksheet video showing how it is used for entering option trades and positions to get both a graph showing profit at expiration, as well as current profit at any given date, based on the change in theoretical value of the position.
Stock Option Position Profit Spreadsheet.
Options trading spreadsheet video that discusses the StkOpt worksheet that can plot the stock option position profit at expiration, along with also plotting a stock trade only position for comparison.
Options Price And Greeks Change In A 30 Day Period.
Options trading spreadsheet video that discusses the GreeksChg worksheet and how theoretical value and the option greeks change over a 30 day period, including the differences that occur from changes in the underlying and/or volatility.
Options Trading Pricing Formula Inputs And Outputs.
Options trading spreadsheet video that discusses the greeks worksheet inputs and outputs, especially with regards to the volatility input and what number to use. There is further discussion on ways that this worksheet can be used for projections and trading decisions.
Options Trading Spreadsheet Download.
Download link for microsoft excel options trading spreadsheet file.
Risk Disclosure.
Futures and forex trading contains substantial risk and is not for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones’ financial security or life style. Only risk capital should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results.
Hypothetical Performance Disclosure.
Hypothetical performance results have many inherent limitations, some of which may described in the content on this site. No representation is being made that any account will or is likely to achieve profits or losses similar to those shown; in fact, there are frequently sharp differences between hypothetical performance results and the actual results subsequently achieved by any particular trading program. One of the limitations of hypothetical performance results is that they are generally prepared with the benefit of hindsight.

Options.
Each Options Trading Journal has (8) modifiable Performance-tracking categories. Uniquely designed layout, yet simple to use, with a wealth of knowledge at your finger tips. Options ‘multiplier’ can be easily modified for different contract sizes (1, 100, 1,000, etc.) Tons of great features, functionality and analysis built in to each product version. “At-a-Glance” view of all performance statistics. View the Options Trading Log ◊ View the Options Analysis sheet Options Trade Input methods For more detailed product information, please visit the TJS Gallery and Info page.
Invest in your Options trading business.
Start analyzing your trades today!
Complete package, One time fee, One Low Price.
Free unlimited support!
Let's start Analyzing your trades, shall we?
Options Trading Journal Spreadsheet.
Trading Journal Spreadsheet, Corp.
Las Vegas, Nevada.
Trade Tracking and Analysis software, for all:
Stocks, Options, Futures, Forex, (UK) Spread Betting, and CFD traders.