skip to Main Content

Trading Journal Template

4.77 (13 reviews)

No new software, all in Excel. User-friendly Trading Journal Template developed for casual traders and professionals. Works on Windows / Mac.

$149.95

Learn more about License Types

BUY NOW BUY NOW
Someka 30 days refund icon

30-Days
Return

Someka one time payment Icon

One-Time
Payment

Someka direct download icon

Instant
Download

Payments are processed by our partner company Paddle.com

PRODUCT DESCRIPTION

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.

We have developed this template with the help of Ayers Capital Pty. Ltd., an international trading firm from Australia.
Bryce Edwards, owner of Ayers Capital, explains how he uses this Trading Journal in his daily processes.

Trading Journal Template Sections:

Trading-Journal-Excel-Template-Flow-S01-2

Raw Data:

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).

Trading-Journal-Excel-Template-Flow-S02

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)

Trading-Journal-Excel-Template-S03

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.

Trade Log:

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.

Trading-Journal-Excel-Template-S04

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.

Trading-Journal-Excel-Template-S05-1

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.

Trading-Journal-Excel-Template-S06-1

Metadata Analytics:

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.

Trading-Journal-Excel-Template-S07

Settings:

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.

Trading-Journal-Excel-Template-S08

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
  • White Label
  • Daily / Weekly / Monthly Views
  • On Sheet Instructions
  • Compatible with Excel 2010 and later versions

This Excel template ready-to-use and don’t include any customization. If you want it to be modified according to your own needs, please refer to our Custom Services.

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.

Example 1:

trade-journal-faq-position-closed-example-1

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.

Example 2:

trade-journal-faq-example-2-open-position

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.

Example 3:

trade-journal-faq-position-closed-example-3

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:

trade-journal-cents-dollars

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:

someka-trade-journal-faq-2-rows-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?

Most of the times, the reason is very simple: just don’t forget to unzip the package you’ve downloaded 🙂

If that is not the case, you can check our faq pages for further information.

And as always, if you can’t solve it by yourself, feel free to get in touch with us.

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.

USER REVIEWS

13 reviews for Trading Journal Template

  1. Jon

    I found that the macros stopped working when the filename was changed. Not sure if it’s to do with being on a Mac, or design off trading journal?

    • Someka

      Hello Jon,

      Our development team has just contacted you regarding this issue. We’ll do our best to solve the problem ASAP!

  2. Allison Laube

    This template is really useful for me so far! Thank you guys.I am just wondering which other brokers or platforms this supports other than IRESS or Viewpoint?

    • Someka

      Hi Allison,
      Our Trading Journal template is created for the IRESS and Wiewpoint but it depends on the data that you taken from other brokers. If you are able to take it in the same as the data order, it will work properly. You can even enter the data manually, it is easy enough to do.
      If you have a further questions please do not hesitate to ask!

  3. Greg

    Very good, love it! An essential item for trading with the IRESS platform.

  4. michael agnello

    This is an invaluable tool for the active intra-day trader. Thankyou so much, Someka and Ayers for producing a brilliant tool to us retail punters.

  5. Erwan

    Invaluable product for any intraday trader – this Excel form has been of tremendous help in improving my trading.

  6. Sam

    If you are serious about trading, this is One thing you can’t afford to not have in your arsenal. Great product and helpful team. They customized the product a little also to suit my needs as well.

  7. Craig

    Thank you for this trading journal. It is fantastic and at a great price. It really fills a gap in the market for tracking your trading in a disciplined and quantifiable manner. 5 stars!

    • Someka

      Thank you Craig for taking your time to write your feedback! Glad it was useful for you.

  8. Mike W

    Great results – wd. The trade journal is a fantastic tool – bought it 2wks ago. Still got work to do, to get my consistency up to scratch – but this helps the journey..

  9. Issac

    I do really like this journal. Thank you and please thank Bryce Edwards for all of the work he has put into it.

    • Someka

      Hi Issac. Glad you liked the template and we will forward your thanks to Bryce for sure! 🙂

  10. Rosa Phonangi

    It lets you to have a good discipline on losses. But it gets a bit slower after 15k transactions. Still good though.

  11. xyen.g

    that looks great!! thank you been looking at making my own. Just don’t have that skill.

  12. singh23b

    Wow, I wish this was available a few months back. After spending countless hours building a trading journal template similar to this myself I can say this is very reasonably priced!

  13. Marie McCrea

    Unreal!! Thank you so much


Leave a customer review

Your email address will not be published. Required fields are marked *

Microsoft Excel® is registered trademark of Microsoft Corporation. Someka Excel Solutions is an active member of Microsoft Partner Network (MPN).

Someka SSL Certificate Icon
someka-microsoft-partner-badge-image

Someka Excel Solutions Ltd. Co.
© 2015-2019 All rights reserved.

Someka Bilişim Teknolojileri Ltd. Şti.   |   Address: Mansuroğlu Mah. 286/3 Sk. No:14B Bayraklı Tower 35030 BAYRAKLI / İZMİR   |   Tel: +90 (0232) 700 1883   |   info@someka.net