 Hey traders, this is Tosh Bradley. I go by T Bradley 90 in the My Investing Club MIC community. Right now we have a very special holiday discount sale going on for MIC members or anybody wanting to join. We have two hundred dollars off our annual yearly package and we have an unprecedented thousand dollars off our lifetime package and we are raising prices going into the new year. So if you want to take advantage of these discounts, they are only good and only available right now until December 31st. Take advantage. We will definitely, definitely be raising prices soon. Hey everyone, I was sitting here in my office this morning and I thought it would be valuable to share this with you on how I actually go into kind of a theory and test it. And so what I want to catch you up to speed on here is that I am doing a study about the pivot points on large caps. So let me catch you up to speed here really quick. This is the data that I collected from Python and all I have done is sort this data out and what I have done is I have collected the first day data, the volume, the next day after this first day. So I am looking and studying continuation plays much like low hanging fruits and I am studying them for gaps up and gaps down long and short. So I have sorted them out in two categories and let's go back to gaps down here. This little study here is, let me just remove this formula. Okay, so I can go through this. So the data is all here. I have sorted it out. These are all my gaps down. This is the percentage of gaps down. I could average that stuff out if I wanted to. But now I have programmed in the actual pivot points for those stocks. So that formula I collected from Thinkorswim, the pivot point study that we gave everyone. This is that study. So these are the formulas right here. So pivot point R1, R2, R3, R4, S1, S2, and 3. I just followed this stuff right here. And you know, pH is prior high, PL, PLO, PC, prior close, and then so on and so forth. P is the pivot point itself, and so on and so forth. So what I have done now is I have programmed all of these. And what I am going to do is for the ones that open below the pivot point itself, I want to study what the odds are that the pivot point is broken and broken as in to the upside. But what I want to study is if it opens below the pivot point, what are the odds that it breaks that pivot point with meaning? So what I am going to do is I am going to reference this R1. So basically my initial risk, or high of day, new or the total high of day is going to be like, if I am referencing the pivot point, I am going to use the next resistance line at R1. If I am referencing R1, I am going to reference R2 and so on and so forth. So those formulas, all I have done is you start at the pivot point right here like this. And so I think the easiest way to do this is going to be kind of like color code these for you guys, so you can kind of see what I am doing here. So we can, for me, on pivot points I always use, I like a purple like this color like that. That is my pivot point. Resistances, I generally tend to go towards red on those. Or do I have red? Yeah, red. Red on those. So we will go, let us go in shades here. So let me try to get some colors here set up. Just bear with me. In this video I am going to kind of jump around. So a lot of the things I am going to kind of edit out if it is not very useful. So if it seems like the video has skipped forward a lot, don't worry about it. I am just skipping out my mindless jabbering as I go through this and work through it in my head. So I am just going to go ahead and select my colors here. And then S1, S2, S3, S4. Let us go pick a green color. We will go in that green. So these are our supports. These are our resistances. And this is our pivot point itself. And we are referencing the high here. So this is kind of like our reference point. And so let us kind of work through this here. And let me do something so everybody can kind of denote what I am doing here. So there is your columns. And then let me underline all these words so you can see some borders. I don't know, I don't really like the borders. All right, so now you can really see where we are going here. So now we have denoted whether it opens below the pivot or not. But if it opens below the pivot, we get a yes. Okay, so what I want to know is if it opens below the pivot, is that pivot point broken? Okay, so what we have to do is we have to do a logic test. So we have to do if this cell equals yes, then, and this is going to be some monotonous excel. So, but you know, this is valuable stuff if you want to do your own studies and kind of give yourself an idea on whether there is an edge here to pursue or not. That's not what we're, we're not trying to create an algo. We're just trying to define whether there's edge. And whether we should pursue this idea or not. So equals, yes, if that cell equals yes, then we're going to do if, if the high of the day right here, our reference cell is greater than R1, then put a yes. If not, put no. If that is false, do nothing. So we get a no. Next cell, obviously you see the opens below pivot point. And you just kind of have to look at these. Also, the pivot point, was it broken? The pivot point was 75.93. The high of the day on day two is 75.60. Okay, I really don't like how this has read. I just don't like that throws me off. Okay, so this is working. All right, now let's go to a pivot point below. Hey traders, this is Tosh. I go by T Bradley 90 in the my investing club chat. Just wanted to reach out and say if you have any questions about MIC, joining MIC, maybe you're a member already, you have three ways to contact myself personally and through MIC. You can hit our social media. You can hit me through PMs and chat or you can contact us through my email at Tosh at myinvestingclub.com. That's TOSH at myinvestingclub.com. I will get back to you in a timely manner and I'm saying this because I'm here to help and I don't want anybody to be afraid to reach out and ask any question that they have. We are here for you guys. All right, see you guys.