Home. Options. Taxation. Services. Contact. The Options Tax Guy

Option Trading Template

Due Diligence
Overview
#Available_Demos

I use this template religiously for fundamental, technical and probability analysis, to set my primary and secondary exits, as well as simply a reality check, just to see if a trade will work.

I still have losses, sometimes more than I would like, but it provides a framework for more disciplined trading.  And when I have a larger than normal loss it is usually because I got greedy or tried to “get back” a smaller loss ... Which, experience teaches, usually compounds the problem!

I have several years of development, design and programming into the template and I add features or tweaks almost weekly.

I present it here so that you may get ideas on how to design your own template.  Also, it is available for purchase based on the features you want.  Send me an email with suggestions or purchase info.

It is separated into ten tabs:

•  Due Diligence

•  Option Pricing

•  Strategies - Directional, Spreads, Collars, Iron Condors

•  Trading - tracking the open/close, trade diary, tax export, returns

•  Earnings - Estimates vs Actual, stock movement before & after

•  Put-Call Ratio - sentiment indicator

•  Analysis - probabilities of success, trends, forecast

•  Screenshots - log a pictorial diary of why you did what you did

•  Tax - export area for tax reporting

Watch the demos and see what you think.  Hopefully it will help you be a better trader.

Thanks so much for visiting my site and good trading!

# #Available_Demos
Options Pricing
Trading
#Available_Demos #Available_Demos
Earnings
#Available_Demos

Click on one of the screenshots below to start a demo video of that topic which will open in a new window.

Put-Call Ratio
#Available_Demos
Strategies

Modeling a long put or long call directional trade using the Black-Scholes Option Pricing Model

#Available_Demos

Primarily Theoretical

•  Puts and calls can be used interchangeably in a delta-neutral strategy

•  Implied volatility of puts and calls are identical in a risk-free environment

#Available_Demos
Analysis
#Available_Demos #Available_Demos

Develop or purchase?

I developed the above templates to help me become a more disciplined trader.  They are packed with VBA (Visual Basic for Applications) code and it is difficult to split them up.
Feel free to use them as a model for your own spreadsheet development.
If you are interested in purchasing these, please email me.