Forex Trading Journal Spreadsheet

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

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

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.

Hy Michael,
thank you, I made some little fine-tuning for my personal use, very nice, thanks

, Dietmar

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.

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

So, I can execute the trades from this Excel file?

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.