Build a Free Forex Trading Journal Using Excel Spreadsheet

Build a Free Forex Trading Journal Using Excel Spreadsheet

There is no doubt about the importance of having a Trading Journal for your Forex Trading career, but how to get one? There are people who prefer to have an online one, using websites like myfxbook. When it comes to my money and my main account, I prefer not to have it linked to any third party website. Also, I prefer to have my Forex Trading Journal offline, so I can review my trades even when I don't have any internet connection.
So how to do that? Should we go back to pen and paper and record any single trade in a notebook? Should we buy expensive Trading Journal Software? In this video, I propose you a simple solution. You can create a Forex Trading Journal simply using Excel.
We will see how to transform a new spreadsheet into a simple but effective Trading Journal.

Please refer to that video if you want very detailed information on the formulas and how to build them in Excel.

In this video, I'm going quite fast through all the formulas, because I want to focus on a great feature that I have introduced in my Excel Trading Journal.
The new feature explanation starts at 13:05

Enjoy the video and please support the channel hitting the like and subscribe buttons :)

Enjoy the video!

Legal Disclaimer: Any material or information in this article is general educational material and you will not hold anybody responsible for loss or damages that may result from the content provided here.
Trading has large potential rewards but also large potential risk. You must be aware of the risks and be willing to accept them in order to invest in any Financial market. This article is neither a solicitation nor an offer to buy/sell any financial instrument.
Trading carries a high level of risk, and may not be suitable for all investors. Before deciding to invest, you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading, and seek advice from an independent financial advisor if you have any doubts.
Past performance is not indicative of future results.

#Forex #TradingJournal #Excel

[itstradingtime]

Thanks for the likes to the video and your feedback :)
Some of you wanted to know the formula for the MAX Balance.
The formula is: =max(select the cells in the column of the balance)

[mondrany]

Besides being an excellent forex mentor, you are a star at excel. So lucky to have you Federico!

[phaniophrero]

For anyone having troubles with the Risk Reward function in latest versions of Excel, this is the new way of writting it : . You just have to replace the comas with semi-colons.

[jonesavendano]

That last bit about taking screenshots and linking to it in your trading journal was very clever. It was very very nice of you to share this important addition to your trading journal. You are simply the best Federico!

[mustafamatamin]

Hi guys, terima kasih, selepas saya mengulangi video beberapa kali saya akhirnya dapat melakukan perdagangan jurnal seperti yang anda lakukan, sekali lagi terima kasih dan saya akan sentiasa mengikuti saluran YouTube anda, TQ Sir.

[WiPri]

I took what you have and added a Slippage column, simply to make the math come out correctly (among other things). I used your template to create my own spreadsheet in the first place. I'm learning to write formulas, but started with what you used here. Now, I'm working on coding to get the last balance entry for a current balance.

[RealFOREXLive]

Loved the idea of inserting a preview of the trade using the "insert comment" feature. What a great idea!

[amirrahmanzadeh]

Hi, the movement was a fantastic one, thanks for your patience in preparing this good tutorial. Hope we can have more 😊 🙏🙏

[KoKo-kfnt]

Trading journals now require a monthly subscribtion. However this is exactly what i am looking for. Simple but effective.

[jayfutures]

I AM SHOCKED THAT SUCH A VIDEO WAS ON YOUTUBE. THANK YOU SOOOO MUCH SIR!!

I am so excited about the video, hence my all caps comment lol. HAPPY NEW YEAR!!

SUBSCRIBED!!

[majidvafayi]

Putting trade shot in excell was very smart idea. Thank you for sharing it.

[lalitheakalanka]

Wow ... I really like even its 2024. Thank you mate. Simple but great.

[jev]

That was amazing! I've been trying to make a real trade journal that is more user-friendly but I lack the skills that you have. I could theorize it, but not execute it, UNTIL NOW. This video was tremendously helpful! Thank You so much! I liked and subscribed but really can't thank you enough. I will definitely watch more of your channel. Gratitude! Grazie!

[owenphiri]

Bro I appreciate your work. Today I have learnt something new and extraordinary. Thumbs Up!

[ElliottForex]

How would you add in a partials column which can calculate the RR factoring in any partials taken and the price partials were taken. Also how could you add in a Breakeven column for if you get taken out at BE and lose a tiny amount or have a tiny win.

Thanks lovely journal watched it at 0.75 speed easy to build it as it plays

[raynoldhughes]

Great I learn some extra tips and tricks in excel. Thanks and will make used of this journal in the future..

[hristiyanminchev]

awesome video mate, the best trading journal tutorial on the web

[MuzhdaDiaries]

THANK YOU SOOOO MUCH I LEARNRD ALOT LOOKING FORWORAD MORE AND MORE FROM YOU HAVE A GOOD DAY

[WeTubeInc]

how about the statistic part? any tutorial?
can't find it on your channel
Thanks for this vid btw, super great help!

[benjaminpoli]

super video i had no clue on how to use excel but you made it seem so easy and simple!!