Template Excel Trading Journal

​

Gain unparalleled insights into your market performance, identify winning strategies, and optimize your trading decisions. Stop guessing and start dominating with data-driven precision.

High-frequency trading is fast-paced and demanding. Every millisecond counts. Track your trades, specify a time period, analyze market patterns, and make data-driven adjustments with ease. Overcome the complexities of HFT and achieve your trading goals.

Fully functional and customizable monthly calendar. See your P&L through time, choose the starting day of the week. Automatic color coding based on performance.

Analyze your strategies and sentiment through the various panels the journal offers. Review the average income per strategy and the profitability they imply.

Free version content

• All Trades Panel

o Gross P/L

o # of trades

o # of contracts

o % Profitable trades

o % Losing trades

o Fees and Commissions

o Net P/L

o Avg. Trade Time (min)

• Trade P&L History Panel

• Winning VS Losing Trades Panel

• Performance by Day of Week Panel

• Performance by Hour Panel

Additional with full version

• Monthly Calendar (Performance)

• Equity Curve Panel

• Trades Stats Panel

o No. Trades long

o No. Trades short

o Number of trades

o Average winning trade

o Average losing trade

• Strategy Profitability Panel

• Average Income Per Strategy Panel

• Time Chart (P&L)

• Sentiment Chart (P&L)

• Entries Chart (P&L)

• Exits Chart (P&L)

 

Template  G7fx Chartbook

[Mark]

this is trade Jour I can not update to 2026 and IDK where to gp to update it

need to check formulas.

 

[Angelperez]

Here is it

 

[Angelperez]

If you can make it change automaticly

 

[Angelperez]

If you can make it change automaticly

Or let me know what to do so I cam changebit next time. Thank for your help I appreciate it

 

[Mark]

Or let me know what to do so I cam changebit next time. Thank for your help I appreciate it

where is the date element in this? it just works,just have seperate files for year wise. thats all!

 

[Angelperez]

where is the date element in this? it just works,just have seperate files for year wise. thats all!

I tried to update it into curent year I could not do it. Do mind sending over a short clip how did you do so I can it on google dive. Please.

 

[Angelperez]

I tried to update it into curent year I could not do it. Do mind sending over a short clip how did you do so I can it on google dive. Please.

It works but days on does not match with curent days per month that my issue

 

[Angelperez]

I tried to update it into curent year I could not do it. Do mind sending over a short clip how did you do so I can do it on google dive. Please.

 

[Mark]

I tried to update it into curent year I could not do it. Do mind sending over a short clip how did you do so I can it on google dive. Please.

Enable editing on top

 

[Angelperez]

Enable editing on top

Enable editing on top okay and then ?

 

[Mark]

Enable editing on top okay and then ?

start using

 

[Angelperez]

For some reason I can not do it. Thank you for your help.

 

[Angelperez]

start using

Enabling edit has to be in excel right not google drive ?

 

[Mark]

Enabling edit has to be in excel right not google drive ?

yes

 

[Angelperez]

yes

You sending over a short clip just to make sure I do the right thing. If you have time of course

 

[Mark]

You sending over a short clip just to make sure I do the right thing. If you have time of course

Nope Sorry, i have given enough time to this topic.

 

[Angelperez]

Nope Sorry, i have given enough time to this topic.

No worries