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]

+1

 

[Angelperez]

Anyone else has problem open this Journal in google drive ?

It does open on me.

 

[Mark]

Anyone else has problem open this Journal in google drive ?

It does open on me.

its designed for offline excel.

 

[Angelperez]

its designed for offline excel.

It should open exel drive or its a no ?

 

[Mark]

It should open exel drive or its a no ?

no

 

[Angelperez]

Do you recomend a free excel for desktop pc ?

 

[Mark]

@Angelperez

Microsoft office

 

[Angelperez]

I will try to donload it later on. Thank you so much

 

[Angelperez]

Could anyone help me to update this journal to 2026 since I have no idea how to do it I dont want messe it up. I will help from experts would very helpfull. Thank you.

 

[Mark]

Could anyone help me to update this journal to 2026 since I have no idea how to do it I dont want messe it up. I will help from experts would very helpfull. Thank you.

what does this mean?

simply downlaod excel file and fill you trades , it will show in dashboard.

 

[Angelperez]

Do i delete the sample trades taken or no

 

[Angelperez]

I have a trade journal that some shared with buy need to update the dates since it show last years month and days any idea how to make it to curent year and daites ?

 

[Mark]

I have a trade journal that some shared with buy need to update the dates since it show last years month and days any idea how to make it to curent year and daites ?

Share, ill check

 

[Angelperez]

what does this mean?

simply downlaod excel file and fill you trades , it will show in dashboard.

Also i was checking you tutorial i dont see the january throught april on the canlendar I olny see may throught december

 

[Angelperez]

Also i was checking you tutorial i dont see the january throught april on the canlendar I olny see may throught december

Also i was checking you tutorial i dont see the january throught april on the canlendar I olny see may throught december

Am I doing somthing wrong and i when i change capital amount it sees off on the dasboard

 

[Angelperez]

I uploaded a picture of list of the month I that I get. In the tutorial I can see the list of months.

If I change the month manualy I get this on the first picture .

 

[Mark]

I uploaded a picture of list of the month I that I get. In the tutorial I can see the list of months.

If I change the month manualy I get this on the first picture .

see, you have scrollbar on left

 

[Angelperez]

 

[Angelperez]

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