Learn what information should be recorded in a trading journal + get a free copy of my trading journal. This can be used as a Forex trading journal.
In this video - 'How I Use My Excel Spreadsheet Trading Journal' I briefly talk about the different options available when it comes to choosing what to actually create your trading journal in - mainly Microsoft Excel or Evernote.
I then move on to what information you should record in your journal spreadsheet. I show you my personal trading journal spreadsheet and explain the reasons why I record what I record.
Lastly, I explain how you can get a copy of my Excel Spreadsheet trading journal if you want one.
To download the spreadsheet go to: https://www.disciplinedtrader.co.uk and sign up to the Academy. You can then go to the Trading Journal section and download the spreadsheet for free.
My Previous Video - https://youtu.be/--V9bEEO4Dw
Subscribe to the YouTube Channel for more videos: https://www.youtube.com/c/DisciplinedTraderUK
Check out the Disciplined Trader blog: http://www.disciplinedtrader.co.uk
Follow me on Twitter: https://twitter.com/disciplinedtrad
Follow me on Instagram: https://www.instagram.com/disciplined_trader/
Follow me on Facebook: https://www.facebook.com/disciplinedtrader/
Issue with Journal. I downloaded the Journal and I'm not able to delete the blue boxed with text on them. The boxes that say "Delete this after reading". How do I remove them? I can't even click on them. I'm using Open Office to open the file. I can do everything else, just not able to get rid of the blue boxes.
@Disciplined Trader hi thanks for responding. I got through with this part. The difficulty that I am encountering now is with the different entries. I've realized a new field was added to the spreadsheet called trade costs. What exactly goes in that section?
$ per point is your position size when spread betting. If you don't spread bet, you can convert your position size to a per point value using this calculator - https://www.fxpro.co.uk/trading/calculators/pip
Hope that helps :)
The position size takes care of this for you. It calculates how much of your account your risking by using the position size and the stop loss size. Therefore you don't need to record the leverage. Hope that makes sense
Hi Jurij, if you plan on having multiple targets for one position then you can just split them over different entries on the spreadsheet. So have one line for one target and another line for another target etc
Hi Bobby, just enter the price so the decimal place is directly to the right of the digit that represents a 1 point/pop change. So for example, if you entered at 1.23456 then enter this in the spreadsheet as 12345.6 and it will work perfectly. I've done it this way so it works for all markets
I think I figured out how to change the format of the cells to display and work off decimal places but it requires a Password? Is this something you are willing to provide or do you want it to be read-only?
Disciplined Trader Quick one while I have you there. Im trying to input Eur/USD prices to decimal places but keeps rounding to 1.2 for my entry and exit and limits and stops because there are only 150 points?
thank you very much for your awesome trading journal.
Not sure if you received my email so I'll repeat my question here.
I want to ask for a password to unprotect the cells. (or any other assistance)
1. I trade crypto and most of the time I trade altcoins against BTC, not dollar. So I’d like to change this in the file.
2. Another thing, I prefer Google Sheets instead of Excel, so I want to create the similar journal in Google Sheets.
Thank you in advance, and have a great day, Luke!
1. download the spreadsheet
2. email the download to your yourself gmail
3. open the email
4. click open in google sheets
5. when opened in google sheets go to file and click make copy
6. now you have the spreadsheet ready to edit in google sheets
My question is how do I get this to integrate into crypto, it looks as if its meant for forex.
Quick question, the take profit and actual price how is that calculate. Ex) I purchased $196.26 at $9,280 (entry) and in return I got $213 at 12,400 (exit). How does this all get input in the spreadsheet. Btw you guys got great courses 👍🏽
I love the simplicity and design of your spreadsheet. I'm still confused. I trade in cryptocurrency. The chart is giving me negative numbers. I simply don't know how to input the numbers I have onto your chart.
This is my input
Entry Price: BTC $9,532.10
Account Balance: $837
$ per Point Value: $8.88
Stop Loss Price: $9046.10
Take Profit Price: ?
Actual Exit Price: $12,400
Note: BTC price of entry was $9532.10, I purchase 0.0198 which is $186.54. So I sold at the exit price of a total of $213 which is a profit of $27
How does this get imported?
So the take profit price will be the level at which you intend to exit the market for a profit. The spreadsheet then uses this to calculate an expected risk to reward ratio for the trade and a monetary value at risk. However, you may decide to exit the trade early for a smaller profit so this actual exit price. If this price is different from the take profit level, the spreadsheet will use this to recalculate an accurate risk to reward ratio and risk amount. Does that answer your question?
To work it out you need to know how much of your account you are going to risk and how many points your stop loss is. Lets say for example you were risking £100 and your stop loss is 20 points, all you do is divide the £100 by 20 to get a position size of £5 per point. That means if you lose £5 on each point and your stop is 20 points, you will lose 5 X 20 when your stop is hit. 5 X 20 = 100. Hope that makes sense
Hi Jason, the £ Per Point Value is the position size for the trade. It is made for people who are spread betting. So if you were trading at £5 per point for example, just put a '5' in that column.
I made a trading journal walk through video where I go through how everything works on the spreadsheet. That can be found here - https://youtu.be/J3Wv1Q13BqA
Hope that helps!
Thank you for your spirit which presents freely, to the public, the knowledge and instruction on trading wisely. About the download link on your site, I would suggest adding a download link as a menu item so there is no confusion (frustration) about where is the spreadsheet. I had thought, when I visited ,after registering, that the spreadsheet was a teaser which did not exist until I found it buried. I don't think that your visitor should be made to first enroll in a course in order to download the spreadsheet.
Your well structured presentations, great voice, teaching momentum, and the fact that you have created a spreadsheet - which is desirable, gives you the license which qualifies you as an instructor. So pushing or making it a prerequisite to enroll in a course in order to download the spreadsheet is really unnecessary.
All that said, I wonder how you sustain your teaching for free.
Facilities for business continuity may include alternate workspace equipped for continuation of business operations. Alternate facilities may be owned or contracted including office space, data center, manufacturing and distribution.
Systems for emergency response may include detection, alarm, warning, communications, suppression and pollution control systems. Protection of critical equipment within a data center may include sensors monitoring heat, humidity and attempts to penetrate computer firewalls.
Every building has exit routes so people can evacuate if there is a hazard within the building. These exit routes should be designed and maintained in accordance with applicable regulations.
Business continuity resources may include spare or redundant systems that serve as a backup in case primary systems fail. Systems for crisis communications may include existing voice and data technology for communicating with customers, employees and others.
Equipment includes the means for teams to communicate. Radios, smartphones, wired telephone and pagers may be required to alert team members to respond, to notify public agencies or contractors and to communicate with other team members to manage an incident.
Many tools may be required to prepare a facility for a forecast event such as a hurricane, flooding or severe winter storm.
Materials and Supplies.
Materials and supplies are needed to support members of emergency response, business continuity and crisis communications teams. Food and water are basic provisions.
Systems and equipment needed to support the preparedness program require fuel. Emergency generators and diesel engine driven fire pumps should have a fuel supply that meets national standards or local regulatory requirements. That means not allowing the fuel supply to run low because replenishment may not be possible during an emergency. Spare batteries for portable radios and chargers for smartphones and other communications devices should be available.