Forex Trading Journal Spreadsheet | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Forex Trading Journal spreadsheet 16 replies

Firehorse's trading spreadsheet 45 replies

Excel Forex Spreadsheet help needed 6 replies

Help with spreadsheet trading journal 2 replies

Forex data spreadsheet 11 replies

Attachments: Forex Trading Journal Spreadsheet
Exit Attachments

Forex Trading Journal Spreadsheet

  • #1
  • First Post: Oct 18, 2006 6:53am Oct 18, 2006 6:53am
I have created an Excel based spreadsheet which I use to plan, execute, and track my forex trading. The attached zip file contains the spreadsheet and a (very) brief manual on its use. In a nutshell, you choose your currency pair, enter % Risk and stop loss for the trade, and the spreadsheet calculates position size based upon your account value. It also allows you to log up to three take profit(or loss) levels for each trade, and then calculates net gain/loss in $. As I point out in the manual, I am not an Excel expert or programmer, so if you find any ways in which the journal can be improved, fixed, upgraded, or made basically all around better, please let me know.

Good trading to all,

Michael
Attached File(s)
File Type: zip Forex Journal v1.0.zip   35 KB | 37,048 downloads
Michael fxgorilla
  • #2
  • Apr 22, 2007 11:47am Apr 22, 2007 11:47am
It looks like its been awhile since you posted this. Have you updated it? Has it been useful for you?

Thank you for sharing,
Matt
  • #3
  • Apr 28, 2007 7:16pm Apr 28, 2007 7:16pm
Greetings,

I am wondering if anyone could help me by developing a very simple Excel spreadsheet to help me keep track of my trades and account balance. Here is what I need:

Place to input my original deposit amount:

Spreadsheet calculates 5% and gives that figure, and let's me enter the date next to when that 5% was reached:

Forecasts the future (account balance and date) based upon the previous 5 dates of when the 5% was reached.

Can anyone help with this?

Thank you in advance for any replies.
  • #4
  • Aug 21, 2010 11:51am Aug 21, 2010 11:51am
Quoting fxgorilla
I have created an Excel based spreadsheet which I use to plan, execute, and track my forex trading....
Hy Michael,
thank you, I made some little fine-tuning for my personal use, very nice, thanks

, Dietmar
  • #5
  • Aug 21, 2010 4:01pm Aug 21, 2010 4:01pm
Thanks fxgorilla..

Per me, a trader must also track information such as the currency pair traded, the time the trade was opened, when was it closed, the reason it was closed. Also, the trader should capture info like any mistakes made etc.

If the trader can also store a snapshot of the exact trade it will be of immense help since he can review his trades after few weeks to see how much improvement has come in his trading.
  • #6
  • Aug 23, 2010 9:17pm Aug 23, 2010 9:17pm
Hi All

Hope everyone is having a nice time here. Anyone have a excel solution which analyses the report generated by GFT or FXCM, and give us more precise details out of it.

There are 1 soft I know which do similar things and they are myforexdashboard.com I would like to know if there is a FREE excel solution available?

I am so mean and want to ask before buying jejeje

It could allow us to see graphs and performance by individual pairs, most profitable pairs etc.

Hope to see some input very soon
  • #7
  • Nov 16, 2010 2:55pm Nov 16, 2010 2:55pm
Quoting fxgorilla
I have created an Excel based spreadsheet which I use to plan, execute, and track my forex trading....

So, I can execute the trades from this Excel file?
  • #8
  • Aug 9, 2020 4:43am Aug 9, 2020 4:43am
Hello guys, Is there anyone please who can help me on this spreadsheet ?
Its a great journal for trading. But unfortunately it is for binary trading.
Please if anyone can modify this spreadsheet for Forex format, it would be great and useful for everyone!
I think it only need minor modifications.
Thank you very much in advance.
Attached File(s)
File Type: xlsx Forex_Journal.xlsx   231 KB | 5,652 downloads
  • #9
  • Jan 12, 2025 1:21pm Jan 12, 2025 1:21pm
Hi everyboy
Foun this old tread when searchng the internet fore a good journal eceel sheet,
so i found this.
If anybody still is interested i have convertd this excel sheet to forex

Let me know o i can post it here

Jimmy
  • #10
  • Feb 3, 2025 7:40am Feb 3, 2025 7:40am
Hi Jimmy,

If you could please share, that would be great.

Many thanks!
  • #11
  • Feb 19, 2025 12:01am Feb 19, 2025 12:01am
Hello Jimmy,

Yes, please share your converted journal excel sheet for FX.
Appreciate it.

Thanks a lot!
  • #12
  • Mar 15, 2025 8:12am Mar 15, 2025 8:12am
Hi timeftie

I have only converted 1 page out of 5 but give me a week to finnish it.
since im from sweden language is not my native language
so if someone could help me to check the sheet for gramatik and spelling errors when its done , that would be super great.
because its very powerfull sheets

Jimmy
Attached Image (click to enlarge)
Click to Enlarge Name: week_page.jpg Size: 212 KB
  • #13
  • Mar 20, 2025 8:09pm Mar 20, 2025 8:09pm
Hi all,
I’ve been using the original Forex Journal and it’s been very helpful in tracking my trades. If anyone has a more updated or converted version for Forex, I’d love to try it out. Looking forward to seeing the final version, Jimmy!
Thanks,
  • #14
  • Mar 21, 2025 4:12am Mar 21, 2025 4:12am
Quoting fxgorilla
I have created an Excel based spreadsheet which I use to plan, execute, and track my forex trading. The attached zip file contains the spreadsheet and a (very) brief manual on its use. In a nutshell, you choose your currency pair, enter % Risk and stop loss for the trade, and the spreadsheet calculates position size based upon your account value. It also allows you to log up to three take profit(or loss) levels for each trade, and then calculates net gain/loss in $. As I point out in the manual, I am not an Excel expert or programmer, so if you...
Your Excel-based forex trading journal sounds like a great tool! I’d be happy to review it and suggest improvements. Feel free to upload the ZIP file, and I’ll take a look at ways to enhance its functionality and usability.
  • #15
  • Last Post: May 26, 2025 6:03am May 26, 2025 6:03am
The file appears to be well-crafted and straightforward. Sharing the update would be greatly appreciated.
You've truly done an outstanding job—congratulations.
0 traders viewing now