Description

Trading Journal Spreadsheet & Analysis Spreadsheet – Reveal Market Insights NOW!

*Analysis Spreadsheet designed for use with ThinkorSwim Desktop Application*

System Requirements

Windows – Requires Microsoft Excel with macros enabled and Thinkorswim desktop application.

Mac – Requires Windows be run virtually or via dual-boot. More information about each can be found at the respective links below. Each option listed here is FREE at the time of this writing.

1. VMware Fusion – Retrieve a free personal use license.
2. Dual Boot – Information regarding this method from Apple.

Additionally, to retrieve a free copy of Windows for use with Dual boot and possibly VMware Fusion please have a look here, Windows Insider Program. It’s FREE, LEGAL, LEGITIMATE and fully supported by Microsoft.

Release Notes (Updated 2/13/22)

Release V1.2
Corrected Live Options Calculation
Added Dynamic Lifetime Equity Graph for all accounts
Added dynamic Equity Graphy by Month
Applied buttons for quick access to trade logs & Start/Stop Calculations
Black-Scholes calculator tool added – linked with OptionsAnalysis data for easy extraction – Just Analyze data via OptionsAnalysis and Black-Scholes page will populate

Release V1.3
Corrected graph calculation errors
Graph displays start in 2020, data entered before 1/1/20 will still calculate across the workbook but not on the dashboard graphs. This was necessary to maintain dynamic functionality of the graphs.

Release V1.4
Corrected multiple calculations to options analysis tab
Revised top 10 holdings to display top 27 holdings by value

Release V1.5
Minor revision to LiveOptions tab for easier data entry
Added options expectancy tool
Minor fixes & Buillishness incicator

Release V1.61
Added bullishness indicator to OptionsAnalysis page
Updated and corrected options expectancy calculator

You and I have a lot in common! In brief, we like to trade! Similarly, we’re willing to spend our hard earned money on the right Trading Journal Spreadsheet to gain an edge in the market. Although, you’re likely here because profits have been sporadic, mediocre, or down right non-existent! You’ve tried everything, read all the articles, watched all the videos, re-read that encyclopedia of a so called “trading manual”, but still the result is little changed. Possibly, just like me, you’ve tried creating a dynamic trading plan, maybe even took the next step and laser focused your money management principles. However, the outcome feels like it was all for nothing. I know, I’ve been there!

What I’ve come to realize as I navigate this minefield we call the “Markets” is that most of the time I spend is just that, time I spend.

Why? Because no matter which direction I seem to look the reports are always mixed. Some good. Some bad. Each of which create the type of confusion that I equate to insanity! It’s not good for us as humans and it’s certainly not good for our profitability. Of course, we push onward to the next piece of information that “has to be” the answer to this insane riddle. We want to solve it but we haven’t yet figured out how.

Fortunately, I’m right there with you and I just couldn’t do it that way anymore. After some time away from the markets I started asking myself some questions about the viability of trading as a source of income or as a wealth generation medium, long term. I knew the answer and it wasn’t what I wanted. Therefore, I started looking elsewhere for opportunities to invest my savings. Ultimately, it turns out most all investment opportunities capable of producing the kind of returns the stock market can require even more of my precious time and energy.

The Turn Around

That wasn’t going to work for me either, so I went back to the drawing board and the Trading Journal Spreadsheet & Analysis Spreadsheet was born. Armed with the knowledge of what clearly didn’t work I focused my time on creating the Trading Analysis Spreadsheet first. Furthermore, I wanted to cut out all the back and forth from the analysis portion of my trading and find a clear, buy, sell, or run away signals based on the information. Equally important, without the time consuming task of doing the work for each and every trade. From there, the next step was clear. Comprehensively track my options and investments. Thus, creating the ability to track and analyze the trade data for potential biases or weaknesses. It was the perfect combination of Identify, trade, review, and correct.

The perfect combination of tools to Identify, review, and correct mistakes.

It was an empowering process to say the least and one that I’m eager to share. First, I finally knew what I could do and I saw vividly how much it could help anyone in a similar position. Second, I know this spreadsheet will provide value to even the most experienced trader but it was built simple enough the newest trader will use it without complication. Moreover, leveraging the sometimes mind-bending capabilities of Excel the spreadsheet is highly customizable.

I do hope you enjoy it, see the value in it, and most importantly profit from its use. Additionally, should you ever have any questions I’m readily available at Jeff@OptionBoxer.com.

With that, lets take a look at all that’s included…

Trading Journal Spreadsheet & Analysis Spreadsheet includes;

Options Analysis Spreadsheet

1. Dynamic directional analysis Indicator
2. Dynamic market skew Indicator
3. Long term trend
4. Dynamic market internals Indicator
5. Dynamic max pain Indicator
6. Put and Call options chains
7. Bid/Ask prices
8. Intrinsic/Extrinsic values
9. The greeks
10. Probability OTM
11. Current IV
12. Open interest
13. Volume
14. Beta
15. Put/Call ratio
16. Sizzle index
17. Put/Call Sizzle index
18. DTE
19. Expected moves
20. Much, much, More!!

Investment analysis spreadsheet

1. Proprietary Strong buy, buy, wait, or sell Indicator
2. Virtually all conceivable fundamental metrics;
   1. Book value
   2. BVPS
   3. FCF/Share
   4. Yield
   5. PE
   6. Sales Growth
   7. Price/Sales
   8. Price/Book
   9. Price/FCF
   10. Debt/Equity
   11. Buyback Yield
   12. Shareholder Yield
   13. Current Ratio
   14. Payout Ratio
   15. And so much more!!

Options Trading Journal Spreadsheet

1. Long & Short Position tracking
2. Cumulative unit tracking
3. Transaction costs
4. Commission costs
5. Realized or unrealized gains or losses
6. Position Values
7.  Total Options Costs
8. Total Current Value
9. Profitability by year
10. Top performing strategy
11. Lowest performing strategy
12. Statistics by strategy
13. And many more…

LIVEOptions Trading Spreadsheet

A one of a kind tool to keep track of LIVE options trades by position, right where it belongs, with the rest of your data. Furthermore, your information is compiled into one easy to use format, so you get back to doing what’s important. Trading. Additionally, this tool will track short or long positions for any 4-leg strategy you could dream up. Have more than 4-legs, no problem! Simply enter it as another trade and watch as the spreadsheet packs it all together neatly. Want to track legs individually, no trouble! To explain, simply append an identifier to the Ticker symbol and vwah-lah, you’re managing your data on a whole new level. All within excel, the most widely used business analysis tool on the planet!

Investment Trading Journal Spreadsheet

1. Long & Short Position tracking
2. Cumulative unit tracking
3. Transaction costs
4. Commission costs
5. Realized or unrealized gains or losses
6. Position Values
7.  Total Portfolio Costs
8. Total Current Value
9. Profitability by year
10. Top performing strategy
11. Lowest performing strategy
12. Statistics by Strategy
13. Statistics by Account
14. Dividends Received & Expected
15. Winning percentages
16. Loss percentages
17. And so much more…

Moreover, all of the above has been thoughtfully created from the central dashboard screen. No more searching for the proper tab at the bottom of excel. Everything is easily available from the button ribbon on the OptionBoxer Dashboard.

DashBoard Spreadsheet

1. Quick link to every spreadsheet
2. Investment Graph – Dynamic
3. Sector Allocation Graph – Dynamic
4. S&P Graph – Dynamic
5. VIX Graph – Dynamic
6. Market Internals Chart – Dynamic
7. Equity Growth by Year – Dynamic
8. Equity Growth by Month – Dynamic
9. And much more to come…

*Dynamic – Updated based on data entry and current market conditions

Bonus tools included;

No tool belt would be complete with out a few additional tools. Some tried and true, some new, but all designed for simplicity.

1. Cyclical Analysis Spreadsheet tool – Wondering why May is such a bad time to trade the SPY, or curious why your consumer staples stocks are underperforming? Just break out this tool to have a look at the absolute best time to be invested in a certain market.
2. Compound Interest Calculator – The flagship of analysis spreadsheet investment tools! Want to see how much you need to save and how often to reach a certain value at retirement? Don’t bother Googling for one, its right here.
3. Value Average Calculator – A unique tool designed to target a 10% growth portfolio.
4. Fibonacci Calculator – Enter the high and low of an uptrend or a downtrend and identify that next major support or resistance level effortlessly.
5. Black-Scholes Calculator – This tool will aid in finding that next overvalued or undervalued option.
6. More tools currently being built and scheduled to be released soon!

Everything you see here is packed into this spreadsheet workbook and I apologize if this post has become a cheesy sales letter. I just know it will help and I would love to make some extra income for the work I’ve put into it. If you ever have any questions don’t hesitate to reach out at Jeff@OptionBoxer.com.

For more information now, please view the complete walkthrough video above to better understand the tools that are included and how to use them.

Trading Journal Spreadsheet & Analysis Spreadsheet Cost & What You’ll Get When You Buy

Every purchase is a one time charge of $74.99 + Tax. No recurring charges here. However, given the nature of downloadable products, once you’ve used it there really isn’t a way to return it and as such no returns will be given unless first discussed at Jeff@OptionBoxer.com.

Every purchase will include a 3 download license. Simply fill in the criteria during purchase (name, email, zip, etc.) to create an account and you can return there to view invoices, download updates, and receive discounts for any future purchases.

Legal Stuff

Under no circumstances is the spreadsheet to be disseminated for any reason. In other words, you paid for something no one else has so its probably best not to give away our secrets. Your accounts and my own thank you very much for understanding.

This spreadsheet is NOT a replacement for a qualified tax or investment professional or their services. This spreadsheet is NOT a recommendation, nor will it provide a recommendation for you to buy or sell any security or place any trade. OptionBoxer.com or its affiliates make no claim to the accuracy of the spreadsheet and accept no liability for your use of the spreadsheet. The Optionboxer spreadsheet listed here is provided for educational purposes only and any reliance on the spreadsheet is strictly your own.

Still have a question? You know how to reach me… Jeff@OptionBoxer.com

P.S. If you don’t need the journal function, the analysis spreadsheet may be a good option. Check it out, OptionBoxer Analyze.

God bless,
Jeff