Trading Journal Template
Powerful and easy-to-use Trading Journal Excel Template built for day traders. Supports IRESS Trader and Viewpoint. Works in Mac & Windows.
Keeping a trading journal is one of the most important tasks for serious traders. It helps to track the development and makes it easy to decide on the next move. However, this task becomes quite time-consuming after a while, especially for high volume daily traders. For this reason, we have built an easy-to-use yet strong Trading Journal Spreadsheet Template.
The best part is, all in Excel! So, you don’t need to spend time learning complex software or web services for this job.
Bryce Edwards, the owner of Ayers Capital, also uses this Trading Journal in his daily processes.
We also believe that learning market dynamics and getting the freshest news from the market is vital to traders. If you haven’t come across yet, there’s a community of traders using our template. We recommend you to join the below Discord channel called ASX Trading Chat with the invitation link: https://discord.gg/rqMj5rcsgq
How to use Trading Journal Template?
Let’s have a look at the sections of this template one by one:
This is where you input your raw data (which you can export from your broker or agency software). We have prepared three different versions for easier raw data management (the trading journal package contains special versions for IRESS Trader and Viewpoint).
You will simply input your data into the white cells. We have put some dummy data, please don’t forget to replace them with your own. You can control commission rates from the top section.
In addition, if you want to define different rates per broker, you can do this in the Settings section of the trade journal template. You can also write different commissions for each row manually. (Manual inputs have priority in calculations)
When you are done with putting your data, press “REFRESH” button to reflect changes to Trade Log section. Some rows can be ignored if data is missing, there is an open position or date format is wrong. So check the Data Control Messages. Finally “Reset Table” button clears all existing data.
This is where your raw data is calculated, filtered, and displayed per transaction. Because as we mentioned before, this section is being fed from Raw Data. So, if you need to edit something please work on the Raw Data section of the Trading Journal.
If you think your transactions look good and correct according to your data, you can proceed to analysis dashboards to check your development and trends.
On the right side of this section, you will notice the Metadata selections, which feed the Metadata Analysis we mentioned below.
Trading Journal Template – Weekly & Monthly Dashboard:
Here you can see the weekly/monthly performance of your transactions. You can make the selection from the top section (multiple selections allowed). New days and filters will appear as you add new data to the Raw Data section.
All Trades Dashboard:
Here is the dashboard of the trading journal where you see the overall performance of your logs. The Cumulative Net Profit / Loss chart will give you a good idea about your decisions in the long term.
This section is fed from the data you input on the right side of the Trade Log. (You can edit these metadata drop-downs in the Settings section)
Broker Call Tracker:
This is an independent section in which you can input some specific data for your trading log. Similar to the metadata analytics, these drop-downs can be edited in the Settings section.
In this section, you can input your source data for the drop-downs used throughout the trading journal. This will affect the metadata analytics and broker call tracker sections as mentioned above.
You can also manage Entry Time calculation here. Furthermore, you can define intervals for different categories. What you input is the start time for that category. So if your Date field in the Raw Data section also consists of Time data, the tool will automatically calculate and reflect it to the Metadata Analytics report.
Trading Journal Spreadsheet Template Features:
- Easy to use trading journal for traders
- Works in Excel, no need for complex software
- Compatible with both Mac and Windows
- No installation needed, ready to use
- Professionally designed dashboards
- Full Print Ready stock journal
- White Label
- Daily / Weekly / Monthly Views
- On Sheet Instructions
- Compatible with Excel 2013 and later versions
- Includes VBA code and macros
FREQUENTLY ASKED QUESTIONS
Trading Journal Product FAQ
Why am I getting open position alerts? All my positions are closed.
Probably they are not closed.
This is one of the most asked questions we receive. So, let’s explain this in detail.
First of all, the logic is very simple for a trade to be closed: your bought and sold amounts should be the same for a ticker.
Here we buy and sell same amounts in two parts. Pretty simple.
Important thing to note here is: contract date of a trade is the date when position gets closed (regardless of when it started). In this example, position gets closed at 31st. So, this is the contract date.
Here we sell 250 volumes but buy 150. If you leave it like this, trade journal will ignore these transactions due to open position.
You can still update the dashboards. Just know that this trade will be excluded while calculating profits and other metrics.
Note that, you can continue buying and selling the same ticker. Position will get closed once balance reaches zero. See the third example below.
In this example, we start with buying then switch the action twice during the course. It doesn’t matter as long as balance reaches zero.
This is a perfectly valid example of a closed position.
My data is in dollars but raw data section asks for cents. Can I change that?
Yes, it is quite easy. You can change it here:
Just choose the correct unit for your prices (e.g. if your raw data prices are in dollars then choose dollars) Actually this doesn’t change any calculation logic but saves you multiplying/diving your data by 100 every time you import new data.
I am an existing customer and don’t see this feature on my trade journal??
This is a long-awaited feature and we have implemented this from Version 11 onwards. We’ve sent the new version to existing customers but in case you haven’t received the emails, just get in touch with us.
I deleted the data and refreshed but getting this warning that I should put 2 rows!
We are talking about this message:
Trade journal needs at least one transaction (2 rows) to be able to update Dashboards, Log and Analytics sections. Otherwise, it wouldn’t make sense to show blank reports and charts, right?
I did input 2 rows but I still can’t refresh 🙁
You’ve probably input dummy data which is not valid. Hence, trade journal still can’t update the dashboards.
Just input some valid transactions and make sure the position is closed (see the faq item above for open position explanation).
Does it work with Mac?
Yes. It works with both Mac and Windows.
Please note that this is an Excel Template and you will need Microsoft Excel (min. 2010)
It doesn’t work with Mac Numbers software.
Can I use this template for Tradingview / AMP Futures / Forex etc.?
This Trade Journal template has been developed for stock markets. Other markets or financial instruments may have different variables and data types which may not be suitable with our template structure.
I am from USA / Canada / UK / Germany / Japan etc. Can I use this template for my country's stock exchange?
Even though this Trade Journal template has been developed especially for Australia (ASX), we had some customers in the past who successfully used the template for their own markets. However, this may need some customization for your specific needs. Take a look at our custom development service in case you need.
I downloaded the template, tried to open and it doesn't work. What can be the problem?
Why do the results differ when the data entry order changes?
You can enter the data by following two different orders;
‘date’, or ‘buy & sell’.
To understand the difference between each case, let’s have a look at them in detail.
- Case 1: Entering the data according to the “Buy and Sell” order
This is what usually happens in trading:
See below the mathematical calculation for this case.
- Case 2: Entering the data according to the “Date” order
This case is not so common but can happen from time to time.
For example, in this case, the first switch from Buy to Sell sets the trade volume at 84.948. From now on, wave height does not matter, and this will continue until position balance reaches zero.
See below the mathematical calculations for this case (the exit volumes and prices).