Trade Journal

Get started

A futures trading journal for MES, MNQ, MGC and XAUUSD. Log each trade with what you felt and what you did wrong, then see where the money goes. Live and Prop accounts are tracked separately.

Free, and no new password. Your trades go to a private sheet in your own Google Drive. The journal can only open files it made. Privacy

or

Try the demo About 120 sample trades over five months. Nothing is saved. Connect a Google Sheet Trades go to your own sheet and follow you to any device. About five minutes.

Connect a Google Sheet

Do this once per device. The journal only talks to your sheet, through a small script you own. Keep the web app URL private: anyone who has it can read and change your trades.

1

Create a Google Sheet

Go to sheets.new and name it anything (e.g. "Trade Journal"). The journal sets everything else up for you.

2

Add the Apps Script

In the sheet: Extensions → Apps Script, delete the existing code and paste this:


          
        

      

    


    

      
3

      

        
Deploy as a Web App

        
    
          
  1. Press Ctrl+S to save
    2. 
          
  2. Click Deploy (top right) → New deployment
    3. 
          
  3. Click the gear icon next to "Select type" → Web app
    4. 
          
  4. Execute as: Me
    5. 
          
  5. Who has access: Anyone
    6. 
          
  6. Click Deploy → Authorize access → sign in → allow
    7. 
          
  7. Copy the Web app URL. It looks like https://script.google.com/macros/s/ABC.../exec
    8. 
        

        
Every time you edit the script, create a New deployment (not "Manage deployments"), or the changes won't take effect.

      

    


    

      
4

      

        
        
Saved on this device only. Everyone sets up their own sheet.

        

        
Enter the Apps Script Web App URL (it starts with https://script.google.com/).

      

    


    

      
5

      

        
        
Sign up free at imgbb.com, then copy your key from api.imgbb.com. You can add it later in Settings.

        

      

    


    

      
      

    

    

  







  

    

      
Trade Journal

      
Personal · Futures

      

        
        
        
      

    

    

      
      
      
      
      
      
    

    

      
"You don't have to catch every trade, you just need to be consistent."

      
      
Not connected

    

  


  

    

      

        
Demo data. Made-up trades. You can log and edit, but changes only last until you close this tab.Edits stay in this tab.

        
      

      

        
Signed out of Google. Sign in to load and save your trades.

        
      

      
      

        

          
          
          
        

        
      

    


    
    

      

        
Log trade

        
Futures trade documentation

        
Editing a saved trade. Press Update to save.

      


      

        

          
Trade setup

          

            

              

              

              

                
              

              

                
              

            

            

              

                
              

              

                
              

              

                
              

              

            


            

              

                Entry legs (price × contracts each)
                
              

              

              

            


            

              

              

              

            

            

              

              

              

            


            

              Strategy / setup (select all that apply)
              

              
            

            

              Copy trader (leave blank if it's your own trade)
              

              
Manage copy traders in 

            

            

              
              
            

            

              

                Confidence at entry (1 low · 5 high)
                

              

              

            

          

        


        

          
Result

          

            

              

                Exit legs (price × contracts each)
                
              

              

              

            


            

              

              

              

            

            

              

                
$

              

              

                
$

              

              

              

                Outcome
                

              

            

            

            

              

              

            

            

              Mistake type
              

            

            

              Screenshot
              

                
                
Click, drag & drop, or Ctrl+V to paste a screenshot

                
Uploading

                

                  

                

              

              
            

            

            

              
              
              
            

          

        

      

    


    
    

      

        
Trade log

        
— trades

        

          Today
          —
          —
          —
        

      

      

        
        
        
        
        
        
        
        
      

      

        

          

            DateTimeInstrumentAcctDir
            SetupNet P&LROutcomeSessionMistake
          

          
        

      

      
No trades yet.

      
Loading trades

    


    
    

      

        
Stats

        All accounts
        Loading
      

      

        
—
Total trades

        
—
Win rate

        
—
Total net P&L

        
—
Avg P&L / trade

      

      
Log some trades to see your stats.

      

        

          
—
Avg win

          
—
Avg loss

          
—
Expectancy

          
—
Profit factor

        

        

          
—
Current streak

          
—
Best win streak

          
—
Worst loss streak

          
—
Max drawdown

        

        

          
—
Avg R per trade

          
—
Total R

          
—
Payoff ratio

          

        


        

          
Copy trader leaderboard

          
Instruments

          
Win rate by strategy

          
Win rate by session

          
Win rate by weekday

          
Long vs short

          
What mistakes cost

          
Win rate by confidence

        


        

          
Hold time

          

            

              
—
Avg hold

              
—
Avg win hold

              
—
Avg loss hold

            

            

          

        


        

          
Best & worst trades

          

            
Top 3 winners

            
Top 3 losers

          

        

      

    


    
    

      

        
Charts

        All accounts
        Loading
      

      

        
Cumulative P&L

        
Win rate by strategy

        
P&L by strategy

        
Copy traders: win rate & net P&L

        
Win rate by session

        
Instruments

        
Long vs short

        
By weekday

        
Mistake frequency

      

      
Log some trades to see charts.

    


    
    

      

        
Review

        
Weekly & monthly summaries

        

          
          Loading
        

      

      

      
Log some trades to see your review.

    


    
    

      

        
Heatmap

        
Daily P&L calendar. Tap a day to see its trades.

        

          
          
          
        

      

      

         Profit
         Loss
         Breakeven
         No trades
        Stronger colour = bigger day
      

      

      

      
Log some trades to see the heatmap.

    

  









  

    

    

      
      
    

  

  










  

    

      

        
Settings

        
      


      

        
Where trades are kept

        

        
Open the sheet in Google Sheets

        

          
Your web app endpoint

          
        

      


      

        
Screenshot uploads

        
Screenshots on imgbb can be opened by anyone who has the link. For private screenshots, use Sign in with Google.

        

          
Get a free key

          
        

      


      

        
Copy traders

        
People you copy trade. They appear as tags on the Log Trade form.

        

        

          
          
        

      


      

        
Display

        

          
For times in the log and review

          
        

      


      

        
Danger zone

        

          
Reset connection
Clears the settings on this device. Your trades in Google Sheets are safe.

          
        

        

          
Delete trades on this device
Removes every trade saved in this browser. Export a CSV first if you want a copy.