 Hey everyone, I hope your trading is going great I just wanted to take a few minutes to introduce you to a new tool that we just created and it is now Available in your members area. So if you just log in, this is inside your members area And what it is is it's the navigation trade tracker. So if you simply click on it it is going to download a Spreadsheet I'm using a max so it appears down here on the bottom. So then I just open it up This is here to help you track Your adjusted trades. So after you've done some adjustments and rolls sometimes it can be a bit overwhelming because the Trade platforms like thinkorswim or tasty works. They don't track your trades You know after the Portion of them has been closed. So that's what this is here to help you do So I hope you guys like it and please once you get into it and start using it Please send me any feedback you have. This is kind of version 1.0 And I'm sure it will evolve over time as we get feedback and different comments from our members So please let us know what you think and basically what this is to start with you've got some notes up here First of all, please watch this video. This is the video you're viewing now It will be in our blog at blog.navigationtrading.com Slash trade tracker and then a couple other notes when you're inputting your values into this sheet if you sell Something that equals a credit You're gonna enter that as a positive number and when you buy something that is a debit And so you're gonna want to enter that as a negative number on the sheet and I'll show you exactly exactly what I mean And lastly, all you have to do is input your trade credits and debits in the yellow cells below and All the totals will automatically update based on the symbol values Okay, so we hopefully made this very simple for you took as much of the work out of it as possible all you have to do is enter your trade values and Voila, it should do the calculations for you. So At the bottom of the sheet, you'll notice there are a few different tabs one is stocks and ETFs One is options on futures and then one is closed trades, which is currently blank and I'll show you why So let's start with these stocks and ETFs I'm gonna do an example for you on a an open trade that we have on and we've made several adjustments on and So let me just put this sheet. Let me just narrow this down so that you can view it So it all fits on your screen. Okay, so what I'm gonna do is I'm gonna take this example of EWW so this is a trade that we've had on since June 21st of 2018 and So you can just simply put the symbol here EWW and this is just for your reference So you can put your symbol there and then you can put the date of each trade. So the first was 621 And that's just for your reference as well all you have to really do is enter your values in the yellow cells and so what I mean by that is the Opening trade when we first started this trade on 621 we sold a strangle we did this for three contracts and We took in a credit of $1.16. I've listed contracts here So if you're trading one contract two three four five, I jump up to 10 20 30 40 50 100 So depending on the number of contracts you're trading you can just use that column there So in this case, we're doing three So we took in a credit of $1.16 So you're gonna put in 1.16 and that's a positive number because it's a credit, okay? then a little while later on 7 6 and I'm not gonna put in all the dates here, but you can do that for your reference on 7 6 we did a Roll and so we took in another credit of 64 cents. So I just type in point six four Okay, and then the next trade and this was this is actually one trade We did three contracts and one it got filled in two separate Transactions, but it's actually just four contracts. We sold another strangle You can see that the time there is basically the same because just took a little bit to get the rest filled The first one we got filled at 109 the rest of them We got filled at 106 and by the way for reporting purposes on our Performance I use the lower credit because it's not fair to use a higher credit just cuz that but I got filled at one contract So I did use 106 so we'll just put that in here and this is at four contracts. So so we'll just put 1.06 okay Next we bought that Strangle back and we paid a debit because we bought it back for 47 cents and that was our strangle with four contracts So put minus because it's a debit. We're gonna put minus point four seven here and And then lastly we did a roll which again considered a double diagonal But all you have to understand is is it a debit or a credit in this case? It was a credit of a dollar eleven This was one with the three contracts so we could go back to our three contract column and put in 1.11 Okay, and then just click off that and you'll see at the bottom You'll see your total credit is 873 on the three contract piece and then on the four contract piece We're 236 and so the total P&L from a dollar standpoint is we're up eighty eight hundred seventy three dollars on the three contracts And we are up two hundred thirty six dollars on the four contracts now in this case We're still in this trade. Okay, so you also have to take that into consideration So if we just just go to our analyze tab and what you'll see is this is the piece that we still have on So just to get an idea of where we're at on this Remaining piece we can just highlight this and act like we're gonna close it right click create closing order And you can see if we were gonna close this out right now. We would close it out for about 389 so let's just go ahead and put that in the sheet just to get an idea of where we are So remember that would be a debit because we're buying it back. So you put minus three point eight nine And then click off that So now what you'll see is that on the three contract piece were down 294 dollars currently and on the four contract piece. That's already closed out and we made 236 so put those together. We're still down slightly on the trade, which is part of the reason that we're still in the trade So we're waiting for some more theta to decay some more time to pass Until we get into a profitable position So that's how it works and obviously all stocks and ETFs have a tick size of one penny Which translate into a tick value of a dollar? We've done the heavy lifting by giving you some different contract options You know if you're trading six contracts you can add another column in here with six contracts and Continue to monitor and manage now I've put ten different Things in here so that if you have you know ten different Trades on at a time you can just keep them separate and use this sheet as your tracking device The one other thing that I've added let me expand this here for you is over to the right I've added a section for trade notes, okay? So this is where you can use use this as kind of a trading journal to document what was happening. So you could say Let's say you you didn't you already got out of this trade. So maybe you say closed Trade early missed out on massive Profits Next time I will listen to navigation trading they are Awesome All right, so there's where you can document things and take your notes So then what you do after you've closed out of the trades if you want to keep track of this stuff What you can do is simply just copy the entire thing right-click copy go over to your closed trades and Just right-click and paste it and you can see the columns are kind of scrunched in So if that's the case just right-click do paste special and click on column widths And then hit okay, and it'll expand it out like it was on the other page Then you can just continue to paste these closed trades All down here and you can go back to reference them as far as what you did as far as the trades go Check out your notes and this will help you over time become a better trader Now I want to go over one more example. That's very important and that's on the options on futures Okay, so what I did here is you've got the same notes up here But then you've also got these different tick sizes and tick values Remember every futures contract when we're trading options on futures this priced a little bit differently So they're not all the same like they are for stocks and ETFs Okay, so what we did is we created this for each symbol So we have this one for ES so in this case on the futures These are specific to that symbol that we show so we've got all the futures that we trade ES NQ ZB for bonds notes oil nat gas gold 6e which is the euro soybeans wheat and corn Okay, so these are all priced and that formulas and the calculations to total these up for you are already built into the spreadsheet Okay, so you want to use these specifically for the symbol that is stated Let's go to oil because this is one that we currently have open and we've made several adjustments To so let's just go to CL and We can go to our monitor tab and this is going to be about 85 days back to capture all the trades that we've made and then let's just go ahead and put the sheet back up and Then we can go through and do the same thing and so we did all these with one contract But we opened with a strangle of a dollar fifty 1.5 there and Then we sold another strangle for a dollar thirty-one one point three one Then you can see we bought this back for nine cents. So it's a debit of minus point oh nine Okay, and then we had another credit where we You know, this was a close and an open so basically a roll Credit of one oh two so positive one point oh two Then we had a debit of point nine so minus point nine and Then we had a another credit of one point four so positive one point four a Debit of three point seven two so minus three point seven two and Let's move this down a little bit Then we had a credit of four point four nine so four point four nine And we had a debit of point seven eight so minus Point seven eight now look what's happened. We've run out of room All you have to do is go over here and add some more space So just click on here. So it highlights the entire row all the way across Right-click and put insert. Let's give ourselves a couple more actually And insert so that gives us more spaces and the calculations down at the bottom are still good because these are using formulas to make the calculations So our next one was a credit of a dollar thirty eight. So one point three eight And then we had a debit of three dollars so minus three And then lastly we had a credit of one seventeen so one point one seven Okay, so now we've got a total credit of three point seven eight translated into dollar amount is $3,780 now remember we are still in this trade and I'm gonna add a couple more Couple more lines here insert so we have more room because then if we go over to our analyze tab You can see exactly where we're at in this trade So we can look at one of our strangles here, which we just put on so that's gonna be pretty much it at break Even so I'm not gonna enter that one at this point, but we've got another one on here And so if I look to close that out Right click create closing order. We'd buy that back for about a dollar seventy nine Okay, so we can just put that in the spreadsheet just to give us an accurate reading So let's just say minus 1.79 Okay So if we closed out of the trade if we close out of our trade right now This would be our total P&L total credit of 1.99 which translates into almost $2,000 in profit on our oil trade That's the power of this tool makes it easy for you just to go in and enter your debits and credits The spreadsheet adds it all up for you if you have different pieces with different number of contracts You can do that and it'll all add up for you So I hope this is helpful This is a request that we've had from a lot of members for a long time of having some type of trade tracking tool and Hopefully we've taken a lot of the legwork out for you Specifically with the formulas that we've already put in for all the different future symbols because they have all these different tick sizes and tick values And then of course on the stocks and ETFs Still makes it easy for you even though they're all the same tick size and tick value With the trading multiple contracts and different pieces of the trades Hopefully this will help you become a better trader and be able to track those trades Well and along with the trade notes to use as your trading journal Journaling your trades and documenting your trades and being able to go back and look at all your trades is such a powerful thing And will help you become a better trader So I hope that was helpful if you have any questions let us know at info at navigation trading calm talk to you later