{"id":36872,"date":"2023-01-13T14:04:18","date_gmt":"2023-01-13T19:04:18","guid":{"rendered":"http:\/\/aky.pbv.mybluehost.me\/?p=36872"},"modified":"2023-08-15T05:41:04","modified_gmt":"2023-08-15T09:41:04","slug":"what-is-a-trading-journal","status":"publish","type":"post","link":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/","title":{"rendered":"What Is a Trading Journal? Keeping a Trading Journal With Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Active traders can\u2019t juggle the sheer statistics and data that make up a day\u2019s trading activity. It isn\u2019t practical and, in many situations, impossible, even for the most mathematically inclined among us. A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.<\/p>\n\n\n\n\n\n<div class=\"earn2-ads_pt1_desktop\" id=\"earn2-3280375457\"><div id=\"earn2-2260679871\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><a href=\"https:\/\/www.earn2trade.com\/trader-career-path?a_pid=E2TLLC&#038;chan=code330&#038;utm_source=Affiliate_track&#038;utm_medium=Top_Banner&#038;utm_campaign=Affiliate_blog&#038;utm_id=TCP_English\" target=\"_blank\" aria-label=\"910x300_earn2trade_ad\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN.png\" alt=\"910x300_earn2trade_ad\"  srcset=\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN.png 910w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN-300x99.png 300w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN-150x49.png 150w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN-768x253.png 768w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2020\/04\/910x300-Dark-II_EN-770x254.png 770w\" sizes=\"(max-width: 910px) 100vw, 910px\" class=\"no-lazyload\" width=\"910\" height=\"300\"  style=\"display: inline-block;\" \/><\/a><\/div><\/div><h2 class=\"wp-block-heading\" id=\"h-what-is-a-trading-journal\">What Is a Trading Journal?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A trading journal can take many forms, but the fundamental similarity is that they basically gather records of your trades over time that can be analyzed later. These journals are critical in developing and improving trading styles, assessing different techniques, and seeing your progress as you move forward in your trading journey.&nbsp;<\/p>\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"lyte-wrapper\" title=\"What Is a Trading Journal? Keeping a Trading Journal With Excel\" style=\"width:853px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_kiW_WYOxnJ8\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/i.ytimg.com\/vi\/kiW_WYOxnJ8\/hqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/kiW_WYOxnJ8\" \/><meta itemprop=\"duration\" content=\"PT11M8S\" \/><meta itemprop=\"uploadDate\" content=\"2023-07-12T21:41:06Z\" \/><\/div><meta itemprop=\"accessibilityFeature\" content=\"captions\" \/><div id=\"lyte_kiW_WYOxnJ8\" data-src=\"https:\/\/i.ytimg.com\/vi\/kiW_WYOxnJ8\/hqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">What Is a Trading Journal? Keeping a Trading Journal With Excel<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/kiW_WYOxnJ8\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi\/kiW_WYOxnJ8\/0.jpg\" alt=\"What Is a Trading Journal? Keeping a Trading Journal With Excel\" width=\"853\" height=\"460\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"Active traders can\u2019t juggle the sheer statistics and data that make up a day\u2019s trading activity. It isn\u2019t practical, and in many situations \u2013 possible, even for the most mathematically inclined among us. A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey. A trading journal can take many forms, but the fundamental similarity is that they basically gather records of your trades over time that can be analyzed later. These journals are critical in developing and improving trading styles, assessing different techniques, and seeing your progress as you move forward in your trading journey. 00:12 Intro 00:59 Disclaimer 1:13 Trading Journal 1:30 What and Why 3:27 Making The Journal 10:12 Summary GUARANTEED FUNDING FOR YOU TO START AS A PROFESSIONAL TRADER - \ud83d\udcaa Earn Guaranteed Funding With Earn2Trade By Passing The Test! \ud83d\udcb0 Get Ready for The Gauntlet Mini\u2122 challenge, our intraday futures trading exam, and receive a guaranteed job to work at our prop firm partner! Do you accept the challenge? https:\/\/e2t.to\/yt-mini-en Read more about it on our blog YOUR CAREER AS A PROFESSIONAL TRADER STARTS HERE \ud83d\udc47 EDUCATION \u27a1Beginner Crash Course: https:\/\/www.earn2trade.com\/beginner-cc \u27a1Bootcamp: https:\/\/www.earn2trade.com\/bootcamp GET FUNDED \u27a1Gauntlet Mini: https:\/\/e2t.to\/yt-mini-en Follow us on our social media accounts and be part of a great community of traders \ud83d\ude00\ud83d\udcaa Instagram: https:\/\/instagram.com\/earn2trade Facebook: https:\/\/www.facebook.com\/earn2trade\/ Twitter: https:\/\/twitter.com\/earn2trade\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:853px;margin:5px auto;\"><\/div><figcaption><\/figcaption><\/figure>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-why-use-a-trading-journal\">Why Use a Trading Journal?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Inexperienced or novice traders often deem trading journals unnecessary \u2013 after all, nearly every brokerage or trading platform collects records of your trading history. Because of this, some assume that the time required for reentering trades in a journal could be better spent researching, planning for the next day\u2019s trade, or enjoying the fruits of your trading labor.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, ask any professional, and they would say that the importance of trading journals can\u2019t be overstated. Keeping a trading journal helps in two main aspects, including:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-strategic-management\"><em>Strategic Management<\/em><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Getting a long-term perspective of your portfolio, trades, and P&amp;L is critical in assessing the viability of your strategy.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Trading journals also help plan your trades. You can automate many functions, like stop-loss and order size calculations, and use the trading journal as a real-time planner to set the structure of a trade without pecking away at a calculator or guesstimating and missing the mark.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you have an exhaustive journal, you can also nail down variables that impact your strategy to manage those inputs better and constantly adapt and improve your technique. For example, in-depth journaling could yield insight into whether your system is more successful on days when a particular benchmark is up or down, specific days or times that are better, or whether your stop loss orders are too broad or tight. Since trading fundamentally shifts statistics in your favor, finding the data that can improve your strategy by even 1% can make a huge difference.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-emotions-management\"><em>Emotions Management<\/em><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Frankly, 90% of trading is mental modeling, while strategic management and actual trades make up the rest. The best strategy in the world won\u2019t mean much if you don\u2019t follow it. By putting a plan down on paper (metaphorically) and keeping yourself accountable through journaling, you can short-circuit the <a href=\"http:\/\/aky.pbv.mybluehost.me\/trading-psychology\/\" target=\"_blank\" rel=\"noreferrer noopener\">lizard part of your brain<\/a> that might panic and blow a potentially successful trade or lose you money.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the other hand, journaling can help break the sunk cost mentality or gambler\u2019s fallacy. If you spend a ton of time developing what you think is a winning strategy, you might have trouble admitting defeat if it isn\u2019t working out. By journaling, you can pinpoint whether it&#8217;s working and where it succeeds or fails. By serving as an objective, indisputable assessment of your strategy, journaling helps control your emotions. Trading is stressful enough, so journaling is critical to offload some of the emotional debt you\u2019re accruing.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-make-a-trading-journal-using-excel\">How to Make a Trading Journal Using Excel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">While there are various browser-based and downloadable trading journal software options, Excel is a great tool that new and experienced traders can take advantage of. With basic program literacy, you can comprehensively log and chart your trade history and draw deep analytical insight from that data. And all that is essentially for free if you have the Microsoft Office Suite. Using Excel will save you costs from paying for SaaS solutions or save the hassle of scrawling trades in a notebook.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because of the high degree of variability, there isn\u2019t often a one-size-fits-all solution for traders developing an Excel trading journal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Below, we\u2019ll look at some core tenets you might want to include in a journal. We\u2019ll examine a basic Excel-based trading journal for a pre-market gap strategy that is also stock-centric. Still, the core fundamentals apply to most asset classes, including crypto, futures, and similar equities.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, remember that your variables and inputs are ultimately dictated by your Excel understanding, trading methodology, and strategy. If you don&#8217;t use Excel, you can also consider <a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets<\/a> or <a href=\"https:\/\/www.openoffice.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">OpenOffice<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-basic-layout\">Basic Layout<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Structurally, you\u2019ll likely want at least two sheets in the workbook: one for actual data logging and one for trade analysis. Some traders like using a third sheet with screenshots of charts, but this tends to create a massive file that can be critically damaging if you\u2019re running a resource-intensive trading platform.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first sheet consists of historical trades, listed (by default) by date. You\u2019ll want to make each column sortable so you can quickly rack and stack your specific strategy variables. The second sheet will build upon the first and draw data from that log to create graphs and analytics to help assess your strategy. Here\u2019s what those two sheets could look like:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Sheet 1<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"table-design-1\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Date<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Ticker<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>ATR<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Prev. Close<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>PM High<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>AH Change<\/strong> <\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Type<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Entry<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Entry Time<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>SL<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Exit<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>R<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Oct.28.21<\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">LCID<\/td><td class=\"has-text-align-right\" data-align=\"right\">$1.63<\/td><td class=\"has-text-align-right\" data-align=\"right\">$27.01<\/td><td class=\"has-text-align-right\" data-align=\"right\">$28.60<\/td><td class=\"has-text-align-right\" data-align=\"right\">6%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$28.923<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:37<\/td><td class=\"has-text-align-right\" data-align=\"right\">$28.60<\/td><td class=\"has-text-align-right\" data-align=\"right\">$29.561<\/td><td class=\"has-text-align-right\" data-align=\"right\">1.98<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">F<\/td><td class=\"has-text-align-right\" data-align=\"right\">$0.48<\/td><td class=\"has-text-align-right\" data-align=\"right\">$15.53<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.24<\/td><td class=\"has-text-align-right\" data-align=\"right\">11%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.549<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.24<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.230<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.03<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">BUD<\/td><td class=\"has-text-align-right\" data-align=\"right\">$0.91<\/td><td class=\"has-text-align-right\" data-align=\"right\">$57.21<\/td><td class=\"has-text-align-right\" data-align=\"right\">$63.80<\/td><td class=\"has-text-align-right\" data-align=\"right\">12%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$64.068<\/td><td class=\"has-text-align-right\" data-align=\"right\">10:23<\/td><td class=\"has-text-align-right\" data-align=\"right\">$63.82<\/td><td class=\"has-text-align-right\" data-align=\"right\">$63.740<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.32<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Oct.29.21<\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">LCID<\/td><td class=\"has-text-align-right\" data-align=\"right\">$2.43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$35.44<\/td><td class=\"has-text-align-right\" data-align=\"right\">$38.78<\/td><td class=\"has-text-align-right\" data-align=\"right\">9%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$39.680<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:37<\/td><td class=\"has-text-align-right\" data-align=\"right\">$38.79<\/td><td class=\"has-text-align-right\" data-align=\"right\">$40.430<\/td><td class=\"has-text-align-right\" data-align=\"right\">0.84<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">LCID<\/td><td class=\"has-text-align-right\" data-align=\"right\">$2.43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$35.44<\/td><td class=\"has-text-align-right\" data-align=\"right\">$38.78<\/td><td class=\"has-text-align-right\" data-align=\"right\">9%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$40.363<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:38<\/td><td class=\"has-text-align-right\" data-align=\"right\">$39.52<\/td><td class=\"has-text-align-right\" data-align=\"right\">$39.500<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.02<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">X<\/td><td class=\"has-text-align-right\" data-align=\"right\">$1.11<\/td><td class=\"has-text-align-right\" data-align=\"right\">$23.43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.19<\/td><td class=\"has-text-align-right\" data-align=\"right\">12%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.728<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:37<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.21<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.220<\/td><td class=\"has-text-align-right\" data-align=\"right\">-0.98<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">LCID<\/td><td class=\"has-text-align-right\" data-align=\"right\">$2.43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$35.44<\/td><td class=\"has-text-align-right\" data-align=\"right\">$38.78<\/td><td class=\"has-text-align-right\" data-align=\"right\">9%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$37.739<\/td><td class=\"has-text-align-right\" data-align=\"right\">10:33<\/td><td class=\"has-text-align-right\" data-align=\"right\">$36.96<\/td><td class=\"has-text-align-right\" data-align=\"right\">$36.910<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.06<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">X<\/td><td class=\"has-text-align-right\" data-align=\"right\">$1.11<\/td><td class=\"has-text-align-right\" data-align=\"right\">$23.43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.19<\/td><td class=\"has-text-align-right\" data-align=\"right\">12%<\/td><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.508<\/td><td class=\"has-text-align-right\" data-align=\"right\">10:42<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.26<\/td><td class=\"has-text-align-right\" data-align=\"right\">$26.760<\/td><td class=\"has-text-align-right\" data-align=\"right\">1.02<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Sheet 2<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"table-design-1\"><tbody><tr><td>Metric<\/td><td class=\"has-text-align-right\" data-align=\"right\">Value<\/td><\/tr><tr><td>Total Trades<\/td><td class=\"has-text-align-right\" data-align=\"right\">184<\/td><\/tr><tr><td>Average Trade\/Day<\/td><td class=\"has-text-align-right\" data-align=\"right\">8.761904762<\/td><\/tr><tr><td>Average Trade\/Week<\/td><td class=\"has-text-align-right\" data-align=\"right\">43.80952381<\/td><\/tr><tr><td><\/td><td class=\"has-text-align-right\" data-align=\"right\"><\/td><\/tr><tr><td>Weekly Expected $<\/td><td class=\"has-text-align-right\" data-align=\"right\">$1599.04762<\/td><\/tr><tr><td>EV<\/td><td class=\"has-text-align-right\" data-align=\"right\">0.730<\/td><\/tr><tr><td>Trades\/Week<\/td><td class=\"has-text-align-right\" data-align=\"right\">43.8095238<\/td><\/tr><tr><td>Risk\/Trade<\/td><td class=\"has-text-align-right\" data-align=\"right\">50<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-data-to-include-nbsp\">Data to Include&nbsp;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s break the first sheet down. The trader&#8217;s strategy in the example is driven by pre-market gaps (a momentum-style system), which is why there are some specific variables (e.g., the ATR). However, many of the data points you will see below are standard across all Excel-based trading journals.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of these data points are self-explanatory, but still, let\u2019s go through each column:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"\"><strong>Date:<\/strong> Lets the trader track progression over time or break it down by a specific period.&nbsp;<\/li>\n\n\n\n<li class=\"\"><strong>Ticker:<\/strong> The trader must know what he\u2019s trading, so having the ticker or asset name is critical.<\/li>\n\n\n\n<li class=\"\"><strong>ATR:<\/strong> Part of this user\u2019s screening criteria is the <a href=\"http:\/\/aky.pbv.mybluehost.me\/atr-average-true-range\/\" target=\"_blank\" rel=\"noreferrer noopener\">average true range<\/a>, which they use to determine the best range for their strategy over time.<\/li>\n\n\n\n<li class=\"\"><strong>Previous close, pre-market high, and after-hours change percentage:<\/strong> Because the gap strategy relies on big moves outside market hours, these variables help the trader see the best minimum or range of percentage changes. He can also track what stock price range works best, e.g., whether small caps like IONQ outperform blue chips like AAPL or MSFT.<\/li>\n\n\n\n<li class=\"\"><strong>Long\/short:<\/strong> The trader\u2019s signals include whether to go long or short the stock.<\/li>\n\n\n\n<li class=\"\"><strong>Entry, time, stop-loss, and exit:<\/strong> These are essentially mandatory in a journal, regardless of the strategy or asset class.&nbsp;<\/li>\n\n\n\n<li class=\"\"><strong>R:<\/strong> This trader, rather than assessing trades based on strict P&amp;L, determines success as a function of units of risk <em>R. <\/em>The mechanics of using risk units to evaluate performance are beyond the scope of this article, but units of risk are usually more objective and scale better than using currency value as a benchmark.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-using-formulas\">Using Formulas<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The data we used is fine on its own, but its use is limited without basic analytics. For this, we need to automate our journal with formulas. This is where the second sheet comes into play, although a few formulas can also be found on the first:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"\">Automatic <em>R<\/em> calculations that divide the difference between exit price and entry by the difference in entry and stop loss.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"table-design-1\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Type<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Entry<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Entry Time<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>SL<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>Exit<\/strong><\/td><td class=\"has-text-align-right\" data-align=\"right\"><strong>R<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$28.923<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:37<\/td><td class=\"has-text-align-right\" data-align=\"right\">$28.60<\/td><td class=\"has-text-align-right\" data-align=\"right\">$29.561<\/td><td class=\"has-text-align-right\" data-align=\"right\">=(L3-H3)\/(H3-K3)<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.549<\/td><td class=\"has-text-align-right\" data-align=\"right\">9:43<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.24<\/td><td class=\"has-text-align-right\" data-align=\"right\">$17.230<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.03<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Long<\/td><td class=\"has-text-align-right\" data-align=\"right\">$64.068<\/td><td class=\"has-text-align-right\" data-align=\"right\">10:23<\/td><td class=\"has-text-align-right\" data-align=\"right\">$63.82<\/td><td class=\"has-text-align-right\" data-align=\"right\">$63.740<\/td><td class=\"has-text-align-right\" data-align=\"right\">-1.32<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"\">Basic addition of trades per day and <em>R<\/em> per week to serve as a quick reference point.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"\">On sheet two, we take advantage of Excel\u2019s automation and analytic tools with formulas.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This section of the trader\u2019s journal is his equivalent to P\/L and helps predict future profits. The expected value, calculated by averaging success probabilities through R, shows the success rate of the strategy. With the expected value, one is equivalent to a successful strategy that hits 100% of the time<em>.&nbsp;<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Since we\u2019re working with probability, anything over 0.51 means that the strategy will be profitable over time, although the higher, the better. After the expected value, the trader\u2019s journal shows the total trades, which are averaged per day by dividing total trades by total days traded, then averaged per week by multiplying by five (trading days).&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then, our weekly expected income calculator helps predict total cash flow based on the strategy\u2019s averages:<\/p>\n\n\n\n<figure class=\"is-style-regular wp-block-table\"><table class=\"table-design-1\"><tbody><tr><td>Metric<\/td><td>Value<\/td><td>Formula<\/td><\/tr><tr><td>WK Expected $:<\/td><td>1599.04762<\/td><td>=C12*C13*C14<\/td><\/tr><tr><td>EV<\/td><td>0.730<\/td><td>=B2<\/td><\/tr><tr><td>Trades\/WK<\/td><td>43.8095238<\/td><td>=B9<\/td><\/tr><tr><td>Risk\/Trade<\/td><td>50<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The expected value and weekly trades are pulled from the previous cells. The risk per trade is a dollar value representing how much cash is on the line if the stop loss is activated. This, multiplied by EV and trades per week, gives a rough indicator of how much money might come in weekly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This trader is visually oriented, so he also uses various Excel-generated graphs and charts. We won\u2019t dive into the details of building charts, but rest assured that it is a simple and easy analytics tool if you\u2019re willing to play around with the variables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-1024x598.png\" alt=\"A chart generated in Excel showing R values by entry time.\" class=\"wp-image-51596\" srcset=\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-1024x598.png 1024w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-300x175.png 300w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-150x88.png 150w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-768x449.png 768w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN-770x450.png 770w, https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/02\/3EN.png 1320w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-keep-a-trading-journal\">How to Keep a Trading Journal<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Starting and keeping a trading journal can be a long process at first, especially if you aren\u2019t Excel-savvy. If you decide to give it a go, however, don\u2019t forget that to be efficient, your trading journal should be a living document that you adapt, tweak, and adjust over time.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It takes time, but ensure you spend the hours after you\u2019re done trading to plug in the day\u2019s data. It\u2019s best to analyze in detail after a while, which is why many traders do end-of-week, end-of-month, quarterly, and annual deep dives into their journals and strategies.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Remember \u2013 the law of large numbers dictates that an accurate average is only derived from many trades, so make sure to add data to your trading journal consistently. Only that way can you accurately determine how efficient your trading strategy is.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Trading journals are a mandatory tool in your arsenal, regardless of your experience level, strategy, or preferred asset class. It can give you invaluable insights you can\u2019t get otherwise while also helping you become a more disciplined trader.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Active traders can\u2019t juggle the sheer statistics and data that make up a day\u2019s trading activity. It isn\u2019t practical and, in many situations, impossible, even for the most mathematically inclined among us. A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey. What Is [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":52129,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[117],"tags":[],"class_list":["post-36872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-economy-finance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6.1 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>What Is a Trading Journal? Keeping a Trading Journal With Excel<\/title>\n<meta name=\"description\" content=\"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Is a Trading Journal? Keeping a Trading Journal With Excel\" \/>\n<meta property=\"og:description\" content=\"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\" \/>\n<meta property=\"og:site_name\" content=\"Earn2Trade Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/earn2trade\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-13T19:04:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-15T09:41:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"620\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Viktor Tachev\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@earn2trade\" \/>\n<meta name=\"twitter:site\" content=\"@earn2trade\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Viktor Tachev\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\"},\"author\":{\"name\":\"Viktor Tachev\",\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/person\/3daed0eebe7c9e6d02906f0af21c8cba\"},\"headline\":\"What Is a Trading Journal? Keeping a Trading Journal With Excel\",\"datePublished\":\"2023-01-13T19:04:18+00:00\",\"dateModified\":\"2023-08-15T09:41:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\"},\"wordCount\":1751,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png\",\"articleSection\":[\"Economy &amp; Finance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\",\"url\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\",\"name\":\"What Is a Trading Journal? Keeping a Trading Journal With Excel\",\"isPartOf\":{\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png\",\"datePublished\":\"2023-01-13T19:04:18+00:00\",\"dateModified\":\"2023-08-15T09:41:04+00:00\",\"description\":\"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.\",\"breadcrumb\":{\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage\",\"url\":\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png\",\"contentUrl\":\"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png\",\"width\":1400,\"height\":620,\"caption\":\"Trading Journal\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/aky.pbv.mybluehost.me\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Is a Trading Journal? Keeping a Trading Journal With Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#website\",\"url\":\"https:\/\/earn2trade.com\/blog\/es\/\",\"name\":\"Earn2Trade Blog\",\"description\":\"Official Blog of Earn2Trade\",\"publisher\":{\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/earn2trade.com\/blog\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#organization\",\"name\":\"Earn2Trade\",\"url\":\"https:\/\/earn2trade.com\/blog\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2018\/02\/logo.png\",\"contentUrl\":\"http:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2018\/02\/logo.png\",\"width\":611,\"height\":126,\"caption\":\"Earn2Trade\"},\"image\":{\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/earn2trade\/\",\"https:\/\/x.com\/earn2trade\",\"https:\/\/www.instagram.com\/earn2trade\/\",\"https:\/\/www.linkedin.com\/company\/earn2trade\/\",\"https:\/\/www.youtube.com\/channel\/UCjC2G_Aa125YZHZTkN_vZYw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/person\/3daed0eebe7c9e6d02906f0af21c8cba\",\"name\":\"Viktor Tachev\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g\",\"caption\":\"Viktor Tachev\"},\"description\":\"Viktor has an MSc in Financial Markets and years of investing experience. His preferred instruments are ETFs but also maintains a portfolio of cryptocurrencies. Viktor loves to experiment with building data analysis and backtesting models in R. His expertise covers all corners of the financial industry, having worked as a consultant to big financial institutions, FinTech companies, and rising blockchain startups.\",\"sameAs\":[\"Mark\"],\"url\":\"https:\/\/aky.pbv.mybluehost.me\/author\/viktor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What Is a Trading Journal? Keeping a Trading Journal With Excel","description":"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/","og_locale":"en_US","og_type":"article","og_title":"What Is a Trading Journal? Keeping a Trading Journal With Excel","og_description":"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.","og_url":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/","og_site_name":"Earn2Trade Blog","article_publisher":"https:\/\/www.facebook.com\/earn2trade\/","article_published_time":"2023-01-13T19:04:18+00:00","article_modified_time":"2023-08-15T09:41:04+00:00","og_image":[{"width":1400,"height":620,"url":"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png","type":"image\/png"}],"author":"Viktor Tachev","twitter_card":"summary_large_image","twitter_creator":"@earn2trade","twitter_site":"@earn2trade","twitter_misc":{"Written by":"Viktor Tachev","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#article","isPartOf":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/"},"author":{"name":"Viktor Tachev","@id":"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/person\/3daed0eebe7c9e6d02906f0af21c8cba"},"headline":"What Is a Trading Journal? Keeping a Trading Journal With Excel","datePublished":"2023-01-13T19:04:18+00:00","dateModified":"2023-08-15T09:41:04+00:00","mainEntityOfPage":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/"},"wordCount":1751,"commentCount":0,"publisher":{"@id":"https:\/\/earn2trade.com\/blog\/es\/#organization"},"image":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage"},"thumbnailUrl":"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png","articleSection":["Economy &amp; Finance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/","url":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/","name":"What Is a Trading Journal? Keeping a Trading Journal With Excel","isPartOf":{"@id":"https:\/\/earn2trade.com\/blog\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage"},"image":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage"},"thumbnailUrl":"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png","datePublished":"2023-01-13T19:04:18+00:00","dateModified":"2023-08-15T09:41:04+00:00","description":"A trading journal fills the gap between trading and analyzing and serves as a critical part of any serious trader\u2019s journey.","breadcrumb":{"@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#primaryimage","url":"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png","contentUrl":"https:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2023\/01\/Blog-65.png","width":1400,"height":620,"caption":"Trading Journal"},{"@type":"BreadcrumbList","@id":"https:\/\/aky.pbv.mybluehost.me\/what-is-a-trading-journal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aky.pbv.mybluehost.me\/"},{"@type":"ListItem","position":2,"name":"What Is a Trading Journal? Keeping a Trading Journal With Excel"}]},{"@type":"WebSite","@id":"https:\/\/earn2trade.com\/blog\/es\/#website","url":"https:\/\/earn2trade.com\/blog\/es\/","name":"Earn2Trade Blog","description":"Official Blog of Earn2Trade","publisher":{"@id":"https:\/\/earn2trade.com\/blog\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/earn2trade.com\/blog\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/earn2trade.com\/blog\/es\/#organization","name":"Earn2Trade","url":"https:\/\/earn2trade.com\/blog\/es\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/logo\/image\/","url":"http:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2018\/02\/logo.png","contentUrl":"http:\/\/aky.pbv.mybluehost.me\/wp-content\/uploads\/2018\/02\/logo.png","width":611,"height":126,"caption":"Earn2Trade"},"image":{"@id":"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/earn2trade\/","https:\/\/x.com\/earn2trade","https:\/\/www.instagram.com\/earn2trade\/","https:\/\/www.linkedin.com\/company\/earn2trade\/","https:\/\/www.youtube.com\/channel\/UCjC2G_Aa125YZHZTkN_vZYw"]},{"@type":"Person","@id":"https:\/\/earn2trade.com\/blog\/es\/#\/schema\/person\/3daed0eebe7c9e6d02906f0af21c8cba","name":"Viktor Tachev","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d35c8a5870c6c42d0a63acdd8f5fee7a18d1f731caa83736d5232ad7d5a3e83a?s=96&d=mm&r=g","caption":"Viktor Tachev"},"description":"Viktor has an MSc in Financial Markets and years of investing experience. His preferred instruments are ETFs but also maintains a portfolio of cryptocurrencies. Viktor loves to experiment with building data analysis and backtesting models in R. His expertise covers all corners of the financial industry, having worked as a consultant to big financial institutions, FinTech companies, and rising blockchain startups.","sameAs":["Mark"],"url":"https:\/\/aky.pbv.mybluehost.me\/author\/viktor\/"}]}},"_links":{"self":[{"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/posts\/36872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/comments?post=36872"}],"version-history":[{"count":9,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/posts\/36872\/revisions"}],"predecessor-version":[{"id":51769,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/posts\/36872\/revisions\/51769"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/media\/52129"}],"wp:attachment":[{"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/media?parent=36872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/categories?post=36872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aky.pbv.mybluehost.me\/wp-json\/wp\/v2\/tags?post=36872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}