Trading Journal Spreadsheet

This Excel spreadsheet provides a trading journal for active stock traders. It’s designed for traders who want to track, manage and maximize their performance in an easy-to-use spreadsheet.

This spreadsheet will help you track every single buy and sell in a customizable journal. New trades are easily added, and the spreadsheet suggests a stop-loss (based on the average true range, which every serious trader should know) and buy quantity (based on the initial risk, or 1R). Trades are saved in a historical ledger, and the spreadsheet summarizes all important trading parameters.

Trading Journal Spreadsheet

The spreadsheet has several sections. The Portfolio Summary section offers a summary of your trading position, and allows you to specify your Average True Range(ATR) multiple to set your stop-loss.

Trading Journal Portfolio Summary

The New Trade section lets you specify a trade, including the buy date, ticker symbol, ATR, buy price, and quantity purchased. If you’ve entered the last trading price, the spreadsheet will also suggest a quantity to purchase

Trading Journal New Trade

When you click the SAVE TRADE button, the trade is entered into the Ledger section. When they’re known, you can enter the sell price, sell commission and close date. The spreadsheet then calculates the realized profit (or loss!), the R-multiple, and several other parameters.

Download Excel Trading Journal Spreadsheet

34 thoughts on “Trading Journal Spreadsheet

  1. Dear Samir,

    Thank you very much for preparing and publishing the above trade journal which I use for my – however only limited number of – trades. I really appreaciate it.

    Actually it is a lot better than what I have seen on other web sites!

    In this regard, I have two questions, more precise one question and one request.

    a) In the spreadsheet there is a bx called “last trade”? What do you mean by this? What am I supposed to fill in it?
    b) Could you kindly send me or publish a version of the excel program which works with Excel 2003? I tried to simply save it with teh “xls.” ending, but then the makro does not work.

    Thank you very much for your response and best regards,

      1. Dear Samir,

        Thank you very much for publishing a revised version of your trading journal. I downloaded the v2 spreadsheet and started to fill in my trades.

        The spreadsheet works fine with Excel 2010 but when I use the excel file under Excel 2003 (which is the version I normally use) it says:

        “Runtime error 438 (Object does not support this property or method).”

        Can you help me? (I have no idea how macros work or how vba works). I googled a bit to find out that this happened before (although I cannot solve it).

        Thanks a lot for your help!

  2. Hi, When i click the “save trade” button it puts the new trade on the top of the ledger, shifting all my other trades down. I was wondering if there was anyway to edit this function to keep the older trades at the top, and put newer trades on the bottom as it allows me to add some more things i would like to keep track of in my diary!

  3. Thanks for posting Samir. I look forward to the options spreadsheet as well. Are you thinking it will be a separate spreadsheet or fields added to the existing spreadsheet? Also a field for trade notes would be nice. Great work.



  4. Excellent sheet!!! I am trading in different currencies. Is it possible to make a version, which takes this into account. Or it is possible to change the macro myself…

    But very nice work.

  5. Thanks for developing the worksheet and making it available. Any chance of this being made available in another format other than .xlsm? I’m guessing that the macro is for the ‘save trade’ button, but for those of us who don’t use MS Office this makes the sheet unusable. I’ve managed to get it showing in Google Drive (.xls and .xlsx files will convert) but the post function from trade to ledger isn’t available (no save trade button), and possibly some other issues. Formulas seem to have converted though.

  6. Samir, Thank you for publishing this spreadsheet. I have made some changes to better suit my needs; including R multiple calculations and tax set-asides. The only part of the spreadsheet that I cannot access is the macro that is connected to the Save Trade button. I would like to be able to play with adding additional elements to each record for saving. Any advice? Open the spreadsheet for me? Thanks again…I’m donating 10.00 to the cause.

  7. Thank you for posting, Samir.

    I got a question regarding the calculation of the realised P&L.

    The formula that you have in the spreadsheet is:

    Realised P&L = [(Sell Price x Quantity) – Buy Commission] – [(Buy Price x Quantity) + Sell Commision]

    Why do we deduct the buy commision in the sell portion and add sell commision in the buy portion?

    or, in formula, why don’t we do this instead?

    Realised P&L = [(Sell Price x Quantity) – Sell Commission] – [(Buy Price x Quantity) + Buy Commision]

    The results is the same, however, I’m afraid I may miss the concept. Appreciate your help.


  8. Any chance you would expand on this for longer term investors. Specifically pref shares and dividends on common stock and to handle drip?

  9. Hi Simar

    How do I contact you for information on receiving an unlocked version of this file.
    I would like to know if I can get it modified for multiple ledgers and some other changes for the Australian ASX.

    Thank you

  10. com what-are-one-of-the-best-antivirus-software-package-systems-for-2012 ”Could It Be Worthy Of Receiving Avast Antivirus Professional More Than The Totally Free Edition? a can present you with maximum info for a href=” These capsules are available everywhere. If it did not, you’ll be able to direct it to aim to clear out them once again. To find the site, input your state and ‘state bar association’ in to the search bar.html”Go With Very Best Rated Antivirus Safety to Remain Safe on The Internet a. If the direct sun light is setting completely over the stream or maybe you capture a furry critter doing something image-worthy, you need to be well prepared to get the photo swiftly. Toward do this transform upon your Computer, drive the f8 button various occasions in advance of home windows begins, and then emphasize safe and sound manner with networking and strike the return primary upon your keyboard.marketsresearchreports. Visit my website for an MLM opportunity now and discover the techniques to generating unlimited leads, abundance, and no cost traffic. [url=]Wholesale Jerseys From China[/url].[url=]Wholesale Jerseys China[/url].The author has written a number of articles on golf technique and is an occasional contributor to sports and PE websites. Due to this fact, the objective behind any net improvement or website promotion undertaking is to create an unique promoting proposition by way of your website that can set you aside from your competition so your clients should only think of doing enterprise with you,[url=][/url], no matter price. However, this has to be developed together with IOC members and the Executive Board,” he added. Each one of you have specific disorders and are needed to be treated specifically in order to receive correct prescription.

  11. I see there is a section buy spreadsheets but I don’t see a trading journal for option and stock trading. A journal for someone who trades both would be good. I use think or swim and keeping track of trades is a horror. I would like to see my percentage of wins. Running account balance to make sure it matches the broker also. A few other features would be nice.

  12. Could you please share the password with me for “Trading Journal Spreadsheet” then it will help me out in great way…

  13. Is there a version update that will allow the macros to function in the recently released MSFT Office iPad apps? The spreadsheets will download, but none of the macros will work if you are using Excel on an iPad. Is there a fix in the works?

    Thank you for your great work!

  14. I’m trying to find the definitions AND reasons for the following cells on the Trading Journal Spreadsheet:

    Initial Stop
    Initial Risk

    How would one use these two indicators to evaluate risk?

    Thank you

  15. Hey Samir,

    Great spreadsheet. Is there a way I can enter in more than one trade at a time? I am willing to pay for this added functionality.


  16. Hello,

    I downloaded you spreadsheet, which I would like to use as a journal. When I try to save a trade it cannot find the macro. I am on a Macbook, running the latex Mavericks, and using Excell 2011. Am I missing something.



  17. They have trusted Sale – Hoo because it provides more than 8000 of wholesale supplijers and drop shippers and each company has reviews of its buyers.
    vinyl aprons over superior coverage in a messy the kitchen environment but they are slightly heavy to wear.
    Therefore, good quality dropshippers are reputable and with nno bad business history.

  18. Hi Samir,

    A very good spreadsheet. More suited for Equities and not so much for Options. I am sure this can be linked with Google Finance function to obtain the latest prices. Also, this does not provide analytics on past performance and historical data from within this spreadsheet.

    I have created one with Pivots and multiple tabs so I can review my past performance and learnings from WINS.

    Is there one for Options specifically.


  19. Thanks for making this available! Like many others, I would be very interested in a version that is suited to options trading. Please email me if this becomes available!


Leave a Reply

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

What is 5 + 4 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)