Trading Journal Template
No new software, all in Excel. User-friendly Trading Journal Template developed for casual traders and professionals. Works on Windows / Mac.
Keeping a trading journal is one of the most important tasks for serious traders. Due to 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 on learning complex software or web services for this job.
Bryce Edwards, owner of Ayers Capital, explains how he uses this Trading Journal in his daily processes.
Trading Journal Template Sections:
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 to 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 at Settings section. 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 being 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 Raw Data section of 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.
At the right side of this section you will notice the Metadata selections, which feed the Metadata Analysis we mentioned below.
Weekly & Monthly Dashboard:
Here you can see the weekly/monthly performance of your transactions. You can make the selection from top section (multiple selections allowed). New days and filters will appear as you add new data to Raw Data section.
All Trades Dashboard:
Here is the dashboard of trading journal where you see the overall performance of your logs. 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 at the right side of Trade Log. (You can edit these metadata drop-downs at Settings section)
Broker Call Tracker:
This is an independent section at which you can input some specific data for your trading log. Similar to the metadata analytics, these drop-downs can be edited at 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 at Raw Data section also consists of Time data, the tool will automatically calculate and reflect it to 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 2010 and later versions
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).
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?
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.
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).