{"product_id":"options-trading-journal","title":"Options Trading Journal Spreadsheet","description":"\u003cp\u003eThis options trading journal is for traders who want an honest record of how each strategy has gone. Log one row per trade, close it when it ends, and the file works out the P\/L, days held, return on premium and result, then compares your strategies side by side.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all strategies or any one of them, and the whole page follows. Every number comes from your entries.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eNet P\/L on your closed trades\u003c\/li\u003e\n\u003cli\u003eP\/L month by month, with the running total over the year\u003c\/li\u003e\n\u003cli\u003eWhich strategies made money and which lost it, and the win rate for each\u003c\/li\u003e\n\u003cli\u003eEvery open trade, nearest expiry first, with the days left and how many expire within your warning days\u003c\/li\u003e\n\u003cli\u003eHow trades ended: closed, expired, assigned or rolled\u003c\/li\u003e\n\u003cli\u003eWins and losses by how long the trade stayed open\u003c\/li\u003e\n\u003cli\u003eThe latest closed trades, with how they ended and their P\/L\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery trade worked out\u003c\/h2\u003e\u003cp\u003eEach row of the trade log holds the open date, ticker, strategy, call or put, sold or bought to open, strike, expiry, contracts and premium. It handles calls, puts and spreads. Close a trade and its P\/L after fees, days held, return on premium and result are filled in. An expired trade closes at zero.\u003c\/p\u003e\u003ch2\u003eEvery strategy side by side\u003c\/h2\u003e\u003cp\u003eThe Strategies tab shows trades, win rate, net P\/L, average win and loss, days held, best and worst for each strategy you trade, using your own strategy names, from covered calls to spreads.\u003c\/p\u003e\u003ch2\u003eOpen trades watched, month by month\u003c\/h2\u003e\u003cp\u003eEvery open trade shows its days to expiry and is marked once it is inside the number of days you set. The Months tab counts trades opened and closed, win rate, P\/L and running P\/L for the last twelve months. It is an options tracker and trading journal for your own records, not trading advice.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Trades, Strategies, Months and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (a year of option trades across seven strategies), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my broker?\u003c\/h3\u003e\u003cp\u003eNo. You type each trade and how it closed, and the file works out the results from your entries.\u003c\/p\u003e\u003ch3\u003eCan I use my own strategy names?\u003c\/h3\u003e\u003cp\u003eYes. Strategies are your own names, and each one gets its trades, win rate, net P\/L, average win and loss, days held, best and worst.\u003c\/p\u003e\u003ch3\u003eHow does it handle a trade that expires?\u003c\/h3\u003e\u003cp\u003eMark it expired and it closes at zero, with the P\/L and result worked out. Trades can also end closed, assigned or rolled.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876199518,"sku":"OPX-243","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/options-trading-journal-01.jpg?v=1790833316","url":"https:\/\/opxviashop.com\/products\/options-trading-journal","provider":"OPXVIA","version":"1.0","type":"link"}