Imagine you could take your trading to the next level with as little as 1 minute per trade. Wouldn’t that be awesome?
If you answered yes to this question, I have good news for you. I will present to you a method to cut out all your bad trades so that you can fully focus on the best, winning trades. This method only takes about a minute per trade.
Tracking your trading performance is essential to your success as a trader. But finding a good way to actually track trades can be hard. In my opinion, Excel is the best way to track trades. The problem with Excel is that you need to create a good Excel trading journal template that tracks multiple dimensions of your trading performance. Creating such a spreadsheet is time-consuming, tedious and generally not an easy task.
Lucky for you, I allocated a week of my time to creating the best possible Excel trading journal template so that you don’t have to. Currently, you can gain full access to this Excel trading journal template for only $50 $29.
Watch the following video to find out how the spreadsheet works:
Features
Here is a list of all the features of my Excel trading journal template:
- It allows you to track up to 6 different strategies simultaneously.
- It works with stocks, penny stocks, futures, options, forex, CFDs, cryptocurrencies, spread betting etc.
- It works with all time-frames (day trading, swing trading, and investing strategies can be tracked).
- Both long (buying) and short sale trades can be tracked.
- Separate Total P&L, Win percentages, Average percentage gains, Average dollar gains, Average time in a trade, P&L charts, and P&L distribution charts for all six strategies.
- Total P&L, Win percentage, Average percentage gain, Average dollar gain, Average time in a trade, P&L chart, Total number of trades, Total commission costs, and Daily/Weekly/Monthly/Yearly P&L for the overall portfolio.
- Ability to enter notes and lessons learned for every trade so that you can learn from your trades and actually improve.
- Strategy rankings (by total profit, win percentage, average percent gain, and average dollar gain)
- Biggest percent win, biggest percent loss, biggest dollar win, and biggest dollar loss
- Average percent win, average percent loss, average dollar win, and average dollar loss
- P&L vs holding time analysis chart (for ‘longer-term’ trades)
- P&L vs holding time analysis chart (for intraday trades)
- P&L vs stock price analysis chart
- P&L vs time of entry analysis chart
- P&L vs weekday of
entry analysis chart
- Notes with explanations of the most important things
- Lots of customizability
- Works on all devices that support Excel (so including IOS and Android)
Limited Time Offer: Right now, you can gain instant lifetime access to all of this for only $29 instead of $50! Save Over 40%!
FAQs
Why do I have to pay $50 $29 to gain access to this template?
Let me walk you through the thought process that I had while coming up with the $50 $29 price tag.
Reason #1
First and foremost, I spent hours upon hours creating this template and I am fully confident that this template can help traders of all kind reach the next level. I too will be using this Excel trading spreadsheet to track all my future trades.
Reason #2
One thing that I looked at when coming up with this price tag is other similar products. Most other trading journal software that I found either cost $150+ or about $29 per month. In addition to that, most of these programs actually have fewer features than my Excel trading journal template.
In other words, my template is both much cheaper and has more features than many other trading journal programs. You literally can get lifetime access to this Excel template for the same price as a one-month membership to other software costs.
Reason #3
If you use this excel trading journal template and actually take the time to analyze your performance, you will become a better trader! Your trading performance will become better. Now ask yourself the following two questions:
- Is
$50$29 worth a substantial improvement in your trading performance? - How much is
$50$29 when it comes to potential trading profits?
Obviously, these are personal questions, so I can’t answer these questions for you. But just compare this Excel trading spreadsheet to other trading-related products. A lot of people pay thousands of dollars for trading courses and other programs just to become a better trader. So $50 $29 to achieve the same (or an even better) result is definitely not bad.
$50 $29 and much more can easily be made back in a single trade.
That’s why $29 isn’t the final price. This is a Limited Time Offer!
Why do I need this?
This Excel trading journal spreadsheet will help you track your trades and analyze your performance. Thereby, you will be able to identify what you are doing right and what aspects of your trading could be improved. With this information, you will be able to cut out all the things that you aren’t that good at and focus on your strengths. This will dramatically improve your trading performance.
In other words, this Excel trading spreadsheet will help you develop a systematic approach to the markets.
It doesn’t matter if you already are massively profitable or still struggling. This will make you a better trader!
Besides using this template to track your own trades, you can also use it to track theoretical trades. This is a great way to explore alternative trading styles without risking any money. This is very common among highly successful traders as they are constantly looking for new and more profitable strategies.
It is important to understand that one huge part of trading is finding a niche that works for you. Not every trading style is ideal for everyone. Trading is about finding the right style for yourself. Just because someone else is able to be profitable with a certain trading style, doesn’t mean that it is the right fit for you. This Excel trading journal template will allow you to find the right trading style for you!
“Let your results guide you!”
Why don’t I just create an Excel trading journal template myself?
You certainly could create your own Excel trading journal and there would be nothing wrong with that. However, from personal experience, I can tell you that this is a very time-consuming and tedious job. Creating a good and actually useful template certainly isn’t an easy task!
If you set it up in the wrong way, your template might be useless…
Furthermore, it comes down to how you value your time. If you think days of work is worth less than $50 $29, then go ahead and create your own. But if you think your time is worth more than that, then get my Excel trading spreadsheet.
I have no experience with Excel, can I still profit from this template?
Yes, even though this template is an Excel spreadsheet, you don’t need any special experience with the program to make use of my template. You simply have to enter a few numbers into the spreadsheet. Everything else will be calculated automatically. So you literally don’t have to do more than fill out a few simple fields (such as entry date, exit date, entry price…)
The following animation shows what you have to do to make use of this Excel trading journal template. Simply fill out these fields. It truly doesn’t take any longer than a few seconds.
Conclusion
The importance of tracking trades can’t be emphasized often enough! Tracking trades simply is a proven way to become a better trader. If you choose to ignore this advice, you have the wrong mindset to begin with…
My Excel trading spreadsheet allows you to substantially better your trading performance with as little as 1 minute per trade. If this is too much for you, you might want to reconsider your pursuit of becoming a successful trader.
I hope you can see the value in my Excel trading journal template. Remember, this is a Limited Time Offer! Right now, you can save over 40%!
If you are ready to do what it takes to bring your trading to the next level:
If you have a tastyworks brokerage account with at least $2000 deposited, you can receive a FREE copy of my Excel Trading Journal Template!
All you have to do is go to the following page and log in to your tastyworks account: https://manage.tastyworks.com/index.html
There you have to scroll down until you see the ‘Refer Your Friends’ section. In that section, you will see a field in which you can submit a referral code. If you submit the following code and send me proof of it, I will send you a free copy of my premium Excel Trading Journal Template:
Referral Code: KKVTVYQE8N
You can send me proof by sending a screenshot of the referral field after submitting my code to Louis@TradeOptionsWithMe.com
If you have any question, comments, feature requests or anything else, let me know in the comment section below!
If you are experiencing any payment problems, please contact me!
Hi Louis, awesome post on explaining the features of your trading journal excel spreadsheet. I totally agree that tracking of trades can really help one to improve and clarify one’s trading executions. It helps me look back and see what were the mistakes made and what to avoid so as not to repeat the same mistake again. Just one question, the P/L calculation at the bottom is the total of all the long/short/option trades and the different strategies? One suggestion would be to allow the user to click on the tabs to track different strategies instead of scrolling to the left and right to make changes.
Thanks for your comment Adrian!
The spreadsheet has separate P&L calculations and P&L charts for all the different strategies and a P&L calculation/P&L chart for all trades summarized.
Also, thanks for the recommendation to add everything to multiple tabs so that you don’t have to scroll back and forth. I might add this in a future update of the Excel trading journal template.
What a great idea. I know it can be very tedious to create any type of excel sheet from scratch as I have tried and could only come up with the simplest of sheets. Or maybe I just suck at excel.
$50 is not at all a lot to pay to have something useful like this. I am going to see if my brother who trades full time will be interested in something like this.
Thanks for your comment Michel. I hope your brother will find this useful.
Hi Louis,
Can i use this for futures Trading?
Please let me know i would like to know before i make the purchase.
Thanks,
Ligia
Thanks for the comment. Yes, it also works with futures. We even have a slightly custom version of it with 4 sections for futures trading, and 2 for options. Just send me a mail after the purchase and I’ll send you the futures trading version.
I’m interested in the futures trading version too.
Hi you have done a great job explaining your sites content to even newbie traders and I think that if valuable lessons can be shared and learned it is of great value. I hope you will be sharing more of your own experiences trading and helping others to understand the risks as well as the potential rewards of online trading. Thanks, Kenny
I certainly will!
Sounds great the idea of impoving trading using excel sheets, personally I haven’t started doing this as I wasn’t sure on how to make excel sheets or even how to work that software, so I might have to learn more about excel and then come back to this post.
I mean $50 isn’t that high a investment so it might be worth a crack for me, just wondering how effective in your opinion is using excel sheets? And also for someone who doesn’t have $50 is there any alternatives
Thank you for the comment Joshua. To be honest, you really don’t need a lot of Excel experience to use this template. All you have to do is fill out a few fields, just like I showed in the animation. Everything else is done for you.
Besides that I can tell you that Excel isn’t very hard to learn. Many people somehow are scared of it. But it really doesn’t take more than max a few hours to get familiar with the program. Of course that won’t be enough to use all the very-advanced features of it. But it really isn’t necessary to use them.
There are multiple alternatives to this template, if you don’t have $29. One would be to create your own Excel trading journal template. However, as you don’t have a lot of Excel knowledge, it could be quite hard for you to create a good one. I actually have another article about the best trading journal software solutions in which I outline other alternatives. So make sure to check that out.
(hahaha)!! Yes, If You Don’t Have $50 To Your Name The Alternative Is To Forget About The Trading Markets Period !!
That’s a nice offer you have their as I believe one of the biggest obstacles for beginners is getting a good system and that requires good and precise tracking.
For me I already have my own excelsheet, which took me a lot of time to tweak to perfection. So I think you’re absolutely correct in asking a small fee for your work. I’ve checked the features and from what I can see you’ll get your money’s worth.
Keep up the good work buddy!
Thanks for sharing your insights!
Being an option trader involves being good with numbers. Options involves even more risk. You have the greeks, the DTE, and the probabilty of profit, etc.
Anything that you can do to help you keep track of all those numbers is going to make you a successful trader, and allow you to stay focused on what you need to – money.
29 bucks seems like a great deal to me, I’m sure I will make that money back 10 fold.
I couldn’t agree more.
Hey there!
Thanks for this awesome guide on what I should be doing every trade. I like how it is flexible and can be used for multiple types of trading options and time frames. I see you created it for tracking 6 different strategies but my question is, is there any room or way to expand it if I need more than that?
Thanks,
Marlinda
If you have more than 6 different strategies, you could just download the spreadsheet multiple times. Each spreadsheet would allow you to track 6 different strategies. If that isn’t enough, contact me personally and I will see what I can do for you.
Hi and thanks for sharing your helpful post. I think the software could be very helpful to many new or experienced traders. I am sure there will be many who will find that if you can see and track your previous trades, you can better prepare for your future trades. Thanks for the share. Kenny
Very interesting post. Although I don’t trade a lot, I find trading an interesting topic. But I have a hard time understanding somethings in trading. If I traded more, this spreadsheet that I actually understand would be my go to thing and for $29 it’s a no brainer.
Having a easy way to track my trades is certainly the way to go or I wouldn’t have a clue
My younger brother recently started investing in some stock. I know he is pretty much a total beginner. I don’t think he has really thought of tracking his trades. Is this spreadsheet template useful for total beginners? Does the template come with some instructions that tell you what to enter and where? Is it easy to figure out?
If so I think I will send a link to your article to my brother and see if he wants to check out your spreadsheet!
Hi Mariah,
Thank you for your comment. I believe that tracking trades (with or without my spreadsheet) is a very useful practice for all traders, even for total beginners. In fact, I would say that it is especially useful to track trades in the beginning of your trading career because that is when you want to find out what you are good/bad at and what works and what doesn’t work.
Nevertheless, it is still important to educate yourself. This spreadsheet won’t make someone with absolutely no clue of what he/she is doing a profitable trader. You still need to have some kind of knowledge foundation. With that being said, I wouldn’t necessarily recommend someone who has absolutely no idea about what he/she is doing to risk real money in the markets.
To make the usage of my Excel trading spreadsheet as easy as possible, I added notes with explanations of all the different segments to it. So in my opinion, it is pretty easy to use. However, I will publish an additional in depth guide on everything soon. Otherwise, it is always possible to contact me if there is something you don’t understand.
This is an awesome post on explaining the features of your trading journal excel spreadsheet. I totally agree that making an good Excel spreadsheet is a very time consuming business. I have tried to create some Excel spreadsheets before, but I have never spent enough time to create such an advanced spreadsheet. I think this is well worth the 50$ for it as it saves me some hours work.
what a fantastic Idea for anyone who is trading, from beginner to advanced, if you do not have something that allows you to track your trading then this would be a great start, a very reasonable price as well. I do not know of many who do track there progress but I think for anyone wanting to be successful with trading needs to have this programme.
Does anyone know if this spreadsheet will work in Libre Office? I’m thinking it could be a crap shoot.
Hi Gary,
I have no experience with Libre Office. However, I just downloaded it and tested if the Excel spreadsheet works in Libre Office. Most of the features seemed to work just fine. However, not every chart looked the same as it did in Excel. So some features might not work completely. But most of the things should work. But I didn’t test everything very extensively, so I can’t give you a 100% definite answer.
Hello Louis! I found this article to be very interesting because I like to trade options. Unfortunately, I was scammed many times by some promising programs online that say that it is possible to earn millions in minutes. I will try this because $50 is not expensive at all and I hope to earn at least $500 a month.
I am sorry to hear about your losses. As a rule of thumb, always ask yourself if something sounds too good to be true. If it does, it probably is! Earning millions in minutes definitely is too good to be true!
I hope you will enjoy the spreadsheet.
I am so glad I found this. I have been trading more lately and had created a spreadsheet to keep track of things, but this is so much better. With the market fluctuating so much the last few weeks, to me it’s a must to have something to really keep track of things. The price for this is very reasonable I’ll be purchasing it for sure. Thanks for this.
Awesome!
How do you see your excel sheet being used for various options strategies like Iron Condor, Strangle, Straddle etc…
Rather than entering the different legs separately, what may be the best way to customize your xl sheet to have the various legs next to each other?
Thanks for the question. I don’t recommend tracking each leg separately. Instead, I recommend treating all legs of a given option strategy as one position. So you track the entry and exit price of the entire strategy.
Let me give you an example:
You sell an iron condor for $1,50 and buy it back for $0,55 three weeks later. In this case, I would simply enter $1,50 as the entry price and $0,55 as the exit price under the short premium options trading section of the Excel template.
I hope this helps. Please let me know if you have any follow-up questions.
Hello. I’m curious if this Excel sheet calculates profit ratio?
Sorry for the delayed response. Besides the P&L in dollars, the template also shows the profit percentage of every single trade. In addition to that, it also shows the percentage of winning trades for each strategy and for all trades combined. The same goes for the profit percentage and other metrics. The average percentage profit and average percentage loss are also shown. I believe from this, you could calculate the average profit ratio and display it on the template.
Hopefully, this helps. Let me know if you have any other questions or comments.
I’m trying to buy your premium package spreadsheet and strategy but then trying to pay by PalPay it is denied. Any idea why?
Hi Inge,
Thanks for your comment. I recommend contacting PayPal support as they can look directly into the issue.
Hi mate, I’m interested in this spreadsheet, however for the sake of a little more ease of use, I was wondering how easy would it be to break up the first sheet into 3 or 4 sheets? Ie, one sheet for long positions, one for short, and another 1 or 2 sheets for the charts/graphs/tables?
It would make it easier to flick through and read the collected data than it is currently with scrolling up down and around.
Hi Marko,
Thanks for the feedback. It is possible to do this. However, it would definitely require a lot of restructuring and in my opinion, it isn’t really worth that. The way the spreadsheet is laid out right now is so that each section has its corresponding charts directly under it. Furthermore, there are certain features that are important for all sections which would lead to a lot of flicking back and forth.
Let me know if you have any other comments or questions.
Thanks. Does unlimited customisability mean the spreadsheet comes unlocked/no password protection?
Yes, that’s correct. As soon as you purchase a copy, you will be able to download an Excel file with the template. This Excel file can be customized as much as you want to. Just note that you have to be careful to not change the references of certain cells. Otherwise, the functionality of the template might be impaired.
Hey, thanks for this offer.
I have been wanting to track my trades for a while now. However, I didn’t know how to get started because there are so many things to track.
This excel template seems to take care of everything except for the entering of the trades. I am very happy that I found it and am looking forward to tracking my trading progress from now on.
Thanks again,
Michelle
Hi Michelle,
Thank you for commenting. I am very happy to hear that you like this excel trading template. If you ever have any questions or comments about the template, make sure to let me know asap.
Have fun tracking and analyzing your trades.
Hi! I know that you said that this works for cryptocurrency, which is awesome because that is what I would use it for. But most people who use cryptocurrency do so because of the privacy it gives. Is what you teach safe from any kind of privacy issues? If that makes sense. I’m having trouble phrasing the question I think. Basically I want to know if my information and trades are going to be safe through your method? Is there any security concerns?
Hi,
The excel trading journal template is just an excel file. So it is a file that you can download and store locally on your device. As long as you don’t share it and keep it on your private device, no one should have access to it.
I hope this answers your question.
Lou:
As I am not that familiar with the workings of Excel I was wondering how you would input more information in the Trade Journal regarding a trade setup.For example Iron Condor STO 20 Dec 19
3155\3160\3940\3935 C/P. I don’t see any fields for this type of info in the journals option section.
Thank you,
Hi Ted,
Correct me if I’m wrong, but as far as I understand, you are asking how to enter multi-leg options trades into the journal. I recommend treating all options trades, regardless of number of legs as one big position. So just enter the net entry and exit price of your position. In my opinion, it isn’t necessary to track each leg individually as you are trading it as one big position anyway. You could, however, enter the strike prices into the notes section of your trades.
Louis, I tried to purchase the combo several times via Paypal (both with my account and with a cr card) – not working. Is something wrong at your end with paypal?
Steve
Hi Steve,
Thanks for your comment. I am sorry for the inconvenience. I just checked and everything seems fine on my end, so I recommend contacting PayPal support as they can better look into the issue.
Louis, does this spreadsheet track the overall p&l on positions after multiple rolls?
Hi George,
Thanks for your question. It is possible to use the spreadsheet to track rolled trades. I recommend checking out my Excel Trading Journal Guide in which I cover a few ways to do this.
I hope this helps.
Hi Louis, can you download trade journal into Google sheets? Sorry if this has already been asked.
Hi Greg,
Sadly, this doesn’t really work as of right now. Currently, the spreadsheet only fully works in Excel.
Definitely let me know if you have any other questions or comments.
Hello Greg. Please advise, most of my trades are in options. Does your spreadsheet helps me to analyze options strategies such as calendar, vertical or diagonal trades. How does it work on rollover trades.
Thank you
Hi Michael,
Thanks for the question. Yes, the spreadsheet also allows you to track options trades. To track options trades, you simply have to treat the entire position as one big trade. You have to enter the net entry and exit price into the entry/exit price cells.
As for rolling trades, you have two options. The first would be to simply treat the first and the rolled trade as two separate trades and enter them into two rows. If you do this, I recommend marking these rows to signal that they belong together (e.g. with colors).
Alternatively, you can keep track of the rolling costs and then enter the net entry and next exit price (accounting for all the rolling costs) into one row.
I hope this helps. Let me know if you have any other questions or comments.
Hi Louis
I am a great fan of all your content. I particularly want to use your trading journal, however, I notice that you don’t mention Spread Betting from the UK. I am new to spread betting as well but was wondering if I can use (under size) eg. GBP£- 1 – per point or GBP£- 0.5 – per point etc 2,3,4,5,- 100-1000, not that I’ll be using this high, I have a small account. It’s called stake size eg. gbp1 per pip?
I trade with IG, one of the biggest spread betting brokers in the UK. Entry price, exist price will be ok, I was just wondering if the calculation into P&L would be done automatically as well?
Many thanks
Regards
Glenn
Hi Glenn,
I just created a slightly custom version of the spreadsheet for spread betting. Everything works like you described with one alteration. I also added a column called “Margin Factor” in which you have to enter the margin requirement for each trade. This is needed to correctly calculate the percentage profit/loss.
Just send me a quick mail after you have purchased the spreadsheet, and I’ll send you the spread betting version as soon as possible.
Hi Louis
I just purchased your journal/spreadsheet. You mentioned that you could send me your custom spread betting version. That would be very kind of you, much appreciated.
Regards
Glenn
Just sent you an email.
How can I add funds in my Journal without affecting my trade percentage or other stats?
Hi Charles,
The spreadsheet does not track your overall account balance. Instead, it tracks the total profit & loss. I chose not to include the total account balance since this would require additional inputs and since your broker platform should display this anyways, I didn’t find this to be a very useful feature.
Let me know if you have any other questions or comments.
Will your tracking spreadsheet work with Mac Excel 2019 version 16.46?
Hi Ron, yes it should.
Maybe a stupid question. In all your images & videos of your spreadsheet you utilize the European style of date entry DD/MM/YYYY. Will the spreadsheet formulas work using American date style MM/DD/YYY or will we need to manipulate the formulas to make them work?
Hi Tom,
You can just use one of Excel’s formatting options to change the format to your desired date format and everything should work fine.
Hi, Louis, thanks for the work.
Would your spreadsheet be fully compatible with Numbers.
Understand this, I need the right answer. I’m at a point where I am getting a new computer and have no problem going back to PC. The choice will depend on your answer, because I will get your journal eitherways.
For my purposes of downloading open close data after hours, Numbers is sufficient. But would the fact that Pivot tables are not accessible dynamically through graphs or the fact that the VBA generally is of limited potential impact YOUR program????
Thanks for all your work really, I learnt a lot.
Sincerely,
Vik.
Hi Vik,
I can’t guarantee that it will be fully compatible with Numbers, but you should be able to use Excel for Mac.
One final question before I buy… In the long area can you enter Calls (not spreads), conversely can you put Puts in the short columns (again, no spreads)?
Hi Tom,
That depends on how you open the position. If you buy to open a call or put position (e.g. go long), you should enter the trades into the long section. If, however, you sell to open (e.g. short), you should enter them into the shorts section.
I hope this clears it up. Otherwise, let me know.
That does the trick. Just making sure that I could place the puts & calls in the appropriate stock columns rather than having to put them in the options. Thank you.
You can also send me an email after purchasing and I will send you a custom spreadsheet with only options sections.
Hello Louis. Recently bought your Journal and it has definitely added perspective to my trading. It works great after a few adjustments with your help and I am very happy with it. It is very easy to learn and use and I even made some additions to include exit indicators.
Without any doubts I can recommend it. Much easier and cheaper than to create one.
Thanks a lot
Julio