So the topic for today is a little bit about Microsoft 365 and it's using the combination of two of the apps. They're part of the ecosystem of Microsoft 365, which is Microsoft Forms and Microsoft Power BI. And I find that when I'm working with this platform, with this ecosystem, that without realizing it, I'm using probably a handful of apps, not just the two specific that we're mentioning right here. It's just the extraordinary opportunity to let everybody know that earlier this morning, I'm on the east coast here in, I know we might have someone from Canada, Jamaica, Southbury, Washington State, Florida. I had a meeting with someone in Lombattar, Mongolia. And I'm pretty sure yeah, we're, it's easy for us to figure things out because it's a half day difference. So it was about nine o'clock, a 39 o'clock for me in the morning. And it was a 39 into the PM for Lombattar. And a good chance they might be joining us for in the next month or two for one of these meetings, because I got them started with looking into TechSoup Connect and they are registered. So that's fantastic. And I recommended to this individual who works with Children's Hope Mongolia to make sure they take advantage of Microsoft 365. All right, so let's just spend a minute or two on that. And you can locate these materials on a share area that is, let's see, Valerie, I'm going to try to type it in and ask if you would test it. It's https.com slash tinyurl, and I'm typing it in, tinyurl.com slash tsc4tbo. All right, and if you wish to click on that, it will take you to, let me slide this over here, and then if you click on the last modified by, you'll see this is my East Coast time, I put four files there, there's the PowerPoint, there's a Power BI file, and of course you may need to have that installed from the Microsoft Store. So if people have questions about that, please ask. And there's two PDF files there with, they're all small, just a couple of pages or so. The slides are in the PowerPoint or the PDF, it's the same thing. And the KBIX file that I'm going to walk through with you, maybe that you never heard of it before, we're going to talk a little bit about what a PBIX file is. The pages from that were exported to a PDF file that I'm calling screened for DI, and you'll realize why I decided to give it that name as we go through with this. So anybody interested, those are the things, the files, the information that we're working with. So now let's let me get that out of the way. All right. Okay, so Microsoft 365 from TechSoot, why is that a spectacularly attractive offer to any nonprofit? It's because there is no cost, it's from the Microsoft philanthropy made available either directly through the Microsoft philanthropy, or if you're registered with TechSoot, if you're a community nonprofit organization, and just about any part of the world, there is through TechSoot Global, there is a site that you can work through. And I verified that with the person I was speaking with this morning, the director of development with Children's Hope Mongolia. And we went to TechSoot Global, we looked at Mongolia, and we went into the Microsoft opportunities, and you can register to receive that, and you'll receive 10, I think it's nine or 10 free Microsoft 365 business premium accounts, which are, that's here, it's described down here, so if you could see that. So I'm going to recommend that if you do not already have that, and you think you might like it, that's, that's the place to go to. Okay. All right, any questions on that? All right, everybody's good with that? Yeah, thank you for telling us about Mongolia and TechSoot, Val. Does everybody have a TechSoot account? I assume we've got a small group here, please participate in the chat if that's convenient, and let us know, okay, fantastic. And then so you most likely know about Microsoft 365, fantastic. All right, so let's see what's going on here with forms. Okay, so I'm going to make this, no, I'm on a monitor here that Val, is this easy to see? Is it the proportions coming through? Okay, and looks all right. They are looking at this from an iPad with a split screen. No, even with a split screen, it's coming through clearly. You're good. Okay, super duper. Thank you so much. All right. And all right, so I want to make this like really straightforward. There's not a lot of stuff to memorize or think through. As I already pointed out, the small set of slides or files is available at this location. All right, so let's look at a form.  Here's the link to a form that we're going to use for this session. Okay, and I'm using tiny URL to make the short URL for this longer one up here. So it's tinyurl.com demo 329. If you click on that, I think I have to press my control. Is that right? I think I'm just going to copy it. I know sometimes that doesn't work when I press I'm on a external keyboard, but it should work. I think I'm just going to type it in. Let's see, let's bring it over here. And I'm going to type in, I like to put that in the chat for everybody. tinyurl.com slash what is it called demo 329. Let's see, did I remember that the right way? Yep. So this is it. This is what will happen. Okay, so here's what I suggest or at least this is how I work with getting started with the form. And I realize some of you may be using this already your experts with it, I'm going to just take you back to the basics. One of the things that I found handy, and I know that the features are always changing and there's new stuff coming in and old ways of doing things, you don't have to do it anymore. And sometimes they change their names. But what what I do is in the wherever you are on Microsoft 365, you're familiar, perhaps with this waffle icon, that's the waffle, that's the hamburger, somebody's having breakfast, I'll be having lunch. Okay, so we click on the app launcher. And you can you may locate forms right in there, or you can go to all apps. Since it's in there, I click on, so I assume it's called an ellipsis, whether it's vertical or horizontal, but the three dots, the ellipsis, and I'm going to open in a new tab. Now, here's what I found made life just a little bit easier, is that you can start a form right here, seems logical to start a form. But what I found seemed to work a little bit better in terms of connecting with Microsoft Power BI is if I started the form in a group in a Microsoft 365 group. So I've got a lot of groups in here. All right. And I chose this group that's for my organization. And I created a file in there. Or I'm sorry, I created a form in there. And so you can see the form that we're using in the in the session today, I created this form as an, it's both an example. And we had a session last fall about digital inclusion. And that I used the ideas from digital inclusion to create a form. And so if you'd like to enter responses in the form, as we're going through this session, you can do that by clicking on the link in the chat, which is the tinyurl.com forward slash demo 329. You can put your name, your dog's name, your favorite ice cream, just whatever you like. And you can put crazy answers or rational logical answers or whatever you think is good to do. So I created it in here, and that made it a little bit easier to locate or rather for Power BI to connect to it. Okay, so we'll just look in the form here. It's a relatively relatively simple form. And I have a question or an item for you to put your name or initials. And I use this option, if you wanted to create another one, let me refresh my memory of what's that called, might be called a Likert, I guess it's a Likert scale type of question item. So Microsoft Forms is a basic form tool. And of course, there are other more advanced and analytical types of forms. But Microsoft Forms is pretty useful for doing some routine and basic things that for which you might like to collect. Okay, so the question came in is what is digital inclusion? Thank you for asking that question. That gives me an opportunity to put in there is a digital inclusion website for the night. I think this is US based, so I'm going to put that in the chat area. So some nonprofits, my own included, have a concern and interest for youth and community members to be digitally included. So I'm just going to give you the basic parameters of what constitutes digital inclusion so that any individual in the community can participate in the digital world. And so the, I'm not sure if this is globally used, but certainly in the United States that these five areas be addressed. And so that an individual has access to the internet, that they have a device that they can use to connect to the internet. On that device, whether it's a tablet, smartphone, computer, laptop, they have apps that are useful for them, maybe that as they're learning and coming up to speed with using the device or learning digital literacy, that they have training available to them. A lot of times that's available through a public library. And of course we realize that not every individual has access to a public library. Maybe there's other ways of course there's neighbors, friends online and that there's an opportunity for finding support if you need to make a repair or correction or get something working that's no longer working. And so for everyone to participate in be included that all of those things would be available to them to some degree or another, whether they have to pay for it or whether there's free Wi-Fi available or public library. I hope that was a useful way of describing it. And of course for lots more information about what's going on and there's legislation going on for digital broadband and you can find that you can get on a mailing list and I participate a little bit with the Digital Inclusion Project in New Jersey and that was a wonderful experience for me. So we're over here and let's just say we're going to put something in. So I'm going to put in the name Denny and in case anybody's wondering who Denny is, Denny's us and it's a Beagle that was rescued from Pennsylvania and brought back into the neighborhood where I live and my family has Beagles and the Beagles have a new friend now. So I'm just going to put in some silly answers. I'm going to say Denny's so new he doesn't have his own device yet so how could he have an app? He definitely wants some help with training and he needs lots of support so we're going to help him out, show him the ropes and I'm going to submit that. Okay so if you'd like to play along you can also submit something in there. Okay so what happens when that's submitted? It goes somewhere. So one of the things I like about using the forms in a group and in this instance I'm using this group on my organization's Microsoft 365 site. It goes to the shared documents library and it lands right here. So let's see if it's in there. Hopefully it's in there and I know it was submitted by Denny so I should see Denny's name somewhere. We've got a couple of Denny's because I was practicing before and putting in and assuming this is is refreshing that that one that I just put in and we can check by the time here. Good chance it might be this one here because that's about the time or it's just a minute later or no it's Shannon put that one in thank you for and then here Denny that's right here's Denny's. Okay so looks like Shannon like you're you've got good digital inclusion so that's fantastic. Okay so that goes in there now when you're working with the forms let's just look at the form itself again. You get some ways of looking at the responses and certainly take advantage of whatever it shows that Denny is a popular survey completer with us and you can see what each individual did so this is certainly very useful in my work I find that using Power BI brings some things like a step closer and so what I did was I connected Microsoft Power BI so this is where the form was I showed you where the spreadsheet was that we looked at okay and now I want to make a connection and what this is showing here is this is the web address to where the file is that allows me to make a web connection into Microsoft Power BI. Now when you do this a lot it might seem surprising but you can actually remember that may sound crazy if you're looking at this the first time and say that's crazy I can't remember that but what your your platform is and you go to sites and then you know what your site is and then you got shared documents and then you had the name but no worries you don't have to remember it you can locate it let's see back over here by opening the file all right so just gonna open it in the app and which is Excel okay so there you go we're using another one of the apps on Microsoft 365 and every once in a while I have to do this and it's just if you've never approached it this way it's useful to be mindful and aware of how this works so we just opened it and we had it open before and you click on file and you go to info and you click on copy path okay and then I'll just to show you what you get when you do that I'm just gonna paste it in there and that's it and then what you do at this point is you remove the rightmost six characters so one two three four five six and then you're left with this nice clean web path to your data and that's fantastic so now what are we gonna do with it now that we have it well I'm just gonna copy this case I want to apply it again and we go into Microsoft Power BI so I've created this report from the data but just to show you that it actually works I'm gonna connect to the data again all right and whoops wrong wrong link I want to get data of course okay and there's a lot of different places where you can connect the data and the point here is that we're keeping the work in the cloud in the Microsoft cloud we're and so we're going to make a web connection and you can certainly connect to an excel workbook that you have access to maybe on a share drive or a local drive but for this scenario I like to connect to the data with a web connection and a lot of times I'll be connecting into SharePoint which is also on the Microsoft platform or to if it is spreadsheet data that's collected with a form I'm using a web connector okay so I'm just gonna paste it in there and click okay and if I've got a pretty good web connection hopefully it'll bring in the table in the form it may not matter which one we select they seem to be identical if anyone has a more refined understanding on the distinction between tables and forms in this use case of Power BI please write something in the chat or put in a link or come off from you happy to understand that a little better typically I work with tables I'm gonna click the the form here Shannon is recommending a table so let's see if I muck up the waters here with with selecting form and then I'm going to click transform data you can load it or transform it and I'm going to pull that over into the share screen so I'm just going to pause here for a second okay thank you Val for your comment in there about the about the table and form does it's everybody who's on our session have you worked with Microsoft Power BI or is it a new okay Shannon has I know Valerie's a bit familiar with it I know that Richard has seen it before okay okay Rosanna thank you so happy to I love sharing ideas and introducing people to Power BI I've been working with it were I don't know four or five years or something and I find it really super valuable and feel like I can't leave home without it and Jeff thanks for for your comment so let me just point out that I'm using a desktop application called Microsoft Power BI desktop or Power BI desktop and some of the things I'm going to be showing you are in the Power BI service or Power BI some people might just say and this is Power BI desktop you can connect to data directly through the service and that's certainly and maybe we could check that out as well that might be work very nicely with the form so we'll try that momentarily if you do want to use Power BI desktop you can click on the search area and go into the micro saw my grow soft store and click in there let me pull that over and do a field go to apps and search for Power BI and there's you're going to get a couple of results here so Power BI desktop is the one that I'm using there's a report builder so I don't know a little more specialized tool for Power BI I have not worked I'm familiar with that I haven't worked with it and then there's also another one that's a Power BI it's like a viewer and I yeah so I guess that's the one that's here this is the Power BI viewer that's the one that you would get if you were working with your smartphone or tablet it's for viewing Power BI reports but not for creating them to create them you need to work in a browser in or I'm sorry either work with Power BI desktop or the Power BI service in a browser okay so we're here I'm going to come back here maybe and talk a little bit more if there's interest about working with Power BI I mean that maybe we'll have a session just on that so up here I'm going to put TechSoup connect and today's date is April 20th I think so just so we know that we did that and but basically what I did is the same thing when I created this report so I'm going to go back to the report and let that process and we're back here now I'm going to refresh the data since we've been on the session we've had a few more forms completed so let's see what happened so I'm going to do a refresh here and I think we're going to see a few more responses so there's 21 responses from 14 different people because the Beagles have been playing around with the form and they've been submitting several responses okay so I'm going to go through one layer I'm going to loop back and maybe go through a few more details so we created this these are visuals this is a table visual this is a card visual typically a it's a measure is placed in here or a number like a count of something and so I'm counting the number of responses here I'm counting the number of people these are clustered column charts and I just decided to create a column chart for each of the items in the form or the survey and I hopefully use this color coding to just as a way to communicate it in a way that's hopefully seems logical the green is good the red is what we want to pay attention to and we're seeing here that where do we need the most attention in training and support okay so again these are all practice sample example fictitious entries but if we're taking it literally that would this is how we might find the report useful okay and then we want to publish it so that typically with some things that we create using the forms and some visualization tool we want to share it with other people so I'm going to publish it into the power bi service and let's see there we go I'm I could in power bi I have the option of setting up different workspaces for this demonstration I'm going to use my workspace which is free to anyone so if you work at a nonprofit if you have Microsoft 365 you do have the ability and option to connect to Microsoft power bi account assume it's approved or made available by your it administration there's no cost for this you can work with my workspace cost is incurred if you set up other workspaces or share outside of your own workspace that's a common thing to do for a nonprofit the cost is relatively low in the United States I believe the US dollar is three dollars and fifty cents per user per month okay so I click select it's going to replace what's there and now once you actually have your visual setup you don't have to do what I'm showing you here we're going to because that can be accomplished in the cloud without you having to manually do anything which is nice okay and the way that would work is in the power bi service I go down to the data sets associated with the data set is the collection of data sources that are used in the report we have relatively simple report we're only using one data source so the data source and the data set are kind of you know the same thing but we could very well be relating different data sources in using them in various ways in the report in which case they would be collected into a data set okay so this is my screen for di should be able to that's right there the ubiquitous ellipsis is that might be a good name for rock band maybe 20 years ago I don't know now so much but okay so I'm going to go into settings all right so here we are gonna make generally this will be okay if your credentials weren't okay you'd get a warning in here and I'd go into scheduled refresh and so you can see with the power bi pro account that I have it allows me to schedule eight time periods for refresh so if I want to if I think people are using this during daytime hours in my time zone I could put it from a nine to five or if I want to stagger it out across a broader area or broader time range if I think people are going to be completing this if I'm doing some work in the community and people are completing it in evening hours I could do that so once you do that when then it's set it and forget it so let's go back to the report then whenever the time period occurs for the scheduled refresh refresh it will occur and if you wished you can check here now I did a manual refresh but that's it shows 1236 it will show the time of the refresh sometimes it might show 10 or 15 minutes after the hour you scheduled it for 3 p.m by the time it actually is triggered and finishes it might be 309 so it might say 309 p.m it's not going to happen maybe instantaneously but it will happen depending on internet traffic and time of day things like that so that's really wonderful now what else can you do when you're here because let's consider that this is a really valuable report and I want to share it with the community so what you can do is you can create an external shareable link so I'm going to put that in here and I think if you someone would click on it again tinyurl.com slash green board di gonna put it in there so if you like and this should work on a mobile device on your computer so I can click on that and let's okay no typos it looks like I got it right and you can send this to WhatsApp you could send it in a text message you could send it in email you could share it out to your community friends or your organization and they can see what's happening and that will update according to the scheduled refresh times that you selected if you could have refresh once a day yes that's right Sharon you can like if I wanted to sort here I could sort by any of these columns and so it's dynamic I can click here who said they had great internet it's those people who said they had great internet okay who is saying that they would like to have training it's those Danny okay yeah we know Danny he's got a reputation already he just showed up and he's already got a reputation all right and who wants some technical support or something for digital inclusion okay so Danny has no need for support he simply wants to sign up for the training all right so you can use it and you with Power BI there are many different visuals that you can create waffle charts custom visuals pie charts line charts area charts and so on okay now suppose it is sensitive information and you do not want to share it out to the community you want to use it within your organization then you can have a okay so I'm I'm in here and I can share it in here with my organization I can copy that link okay and of course this is only going to work I'll put it in the share area there's nothing dangerous here but I'm pretty confident that you're if you click on it you're not going to see anything so Val if depending on who's logged in I can see it because I'm logged into the platform so can someone please tell me that it like a license okay it requires a license or something okay so that's simply an example of if it was sensitive information if it was protected health information that you might choose to do that if you use various areas in the Microsoft 365 platform you can connect the you can embed it the report into SharePoint online you can put it in a website or portal that you could publish to the web which I did the website or portal would require a login in the password the SharePoint online would be your SharePoint which would be mostly for organizational use yeah so you can export the report to a PDF see how that works you could do only sometimes people say I don't like hearing this but they say I want a paper copy okay you could either you can have multiple pages you could say only export the current page I'm going to do that take a few seconds no it's going to take more than a few seconds yeah so we'll give it a little bit longer it should pop up when it's done you can share it into teams there's also this incredible I think this is artificial intelligence let's see okay so I'm going to open that in and of course you could download the PDF file save it as a PDF if you look at it in here you could send this if someone wanted the the PDF there it is okay it's not dynamic or interactive you can't click on things in here to and actually it might have been a more desirable choice if I sent this this is probably the interesting one but if you clicked on it the PDF file is does not have the dynamic interactive capability that you have when you share the link to this page and view it on your phone or tablet okay yeah so let's see the so you can export it you can download the pbi x file let's try something here though that I didn't test this this dangerous territory here I want to see if something works that I have not tested so let's see what happens and hopefully it's a forgiving friendly group that we have here suppose I wanted to see can I create this report without using power bi desktop so I think so so how would you do that all right so I'm going to go down here into the lower left corner and say I want to get my data okay so I want to discover where the data is and I'm going to go and the answer is yes you can do this with excel okay so for example if I click here and I say get the file and now I think we've got some nice options here the file could be local absolutely can get it if it's local files if I click local let's see if I go into my tech soup connect area did I I'm not sure if I put it in here though if I had the excel file it would be in here and I could just connect it you could put it on one drive for business one drive personal I like to use the SharePoint team sites so let's see if we could find our data okay now it is ytb is a rocket right Valerie sharepoint.com slash sites slash ytbrn because I know that's my group that's my SharePoint actually it's the SharePoint that's assigned to the group now this is like a trick question almost unanswerable unless you're the SharePoint Maven how do you form a SharePoint group there's like over 20 different ways to do it and they're formed probably without me even knowing it but you can create them through email through Microsoft planner through teams you could just create a SharePoint platform you can create it through Power BI workspaces so that's not hard so this looks familiar share documents that's where I think I put it okay oh my goodness it looks like we're close to a success story maybe all right so I'm going to click connect now so you can either import or connect all right let's think about that I don't like to think about that too much I always like to select import it into Power BI now if you do a lot of power query power map power visualization stuff in excel which I do not you might prefer to make this or selection but I never do that because I always want to work in the cloud I never want to work inside excel but I'm just saying that in some people are super good with that so of course they might choose that all right this looks like what we're talking about right let's see what happens okay and now it doesn't look like anything so I want to do something with it and here's where I can do something let's say I want to I want to usually a lot of times I just want to get familiar with the data I'm working with so I might put it in a table before I start doing something more graphically visual and here you see I have my data and this is the the question whoops not that one it was the support and training did you have internet what were my did you have a device what was the other question it was like four oh and apps that's right you have apps to use okay so there you could see this coming together and then who is putting in where's because we're looking for denny he is our suspect here and so you see I can create the report that we were looking at before without using power bi desktop so that's nice to know when you're working with relatively simple data sources typically one if you have related data tables unless they're in the database because you could certainly connect that way but if you have a series of different spreadsheets or different tabs not sure if all of them will come in here but try it out and see and then I could make a copy of this okay and then come over here and I could change maybe the visual I was working with and let's see and I just want to let's see I'm going to put in because I want something to do account so there you go I'm putting in the information let's say I'll just let's keep it simple who wants training okay all right so this is telling me how the results are coming in for the respond the respondees who want training so let me point out something else though so that you can see there there are some things you can many things actually that you can do on the desktop that you can't do here now suppose I want to know what the there's a little more information if I turn on the data labels tells me so let me do the math that's 21 if I add those up but what if I want a measure to tell me how many people responded I can do it I can go in here I can put that in there and it's telling me how many so I could do what I had before and I want I want to know how many people how many different people participated in the survey so I could take the names and initials and I could select tell me the distinct count and that should give me the what was it 14 okay so I can do that but I can't do anything more advanced than that that would involve a formula but if this is all I want I'm in pretty good shape okay so then I would save this and let's give it a name this is tech soup connect April 20th I'm gonna name so I'm gonna put it in my workspace I could put it in a different workspace you could save it and there it is and if I look in here I should see it in my there it is right there and if I want this one to refresh itself can I find it in here let me see I'm looking in my data sets I don't see it in here so that might be a limitation of I typically work in the desktop it's not giving me an option to do the refresh oh no or is that it wait a second yep there's too much going on in here I've got my data sets and oh this oh it's this one okay like I said on this I'm a little rusty on this it actually is here and did I so it's this one here that's the name of the data set so if I go in here since this is the first time I'm working with it it's going to do it'll refresh hourly so that's pretty good that if I could take that literally that means it would refresh 24 times a day didn't realize that so I'm glad I attended our session today I learned something here so that's that might be really valuable really nice and that's so that's a pretty nice option to have and you can like why turn it off keep it on and you can do quite a there's you could spend a career with power bi we're just you know scratching the surface here but we've only had a few more minutes left so I just want to summarize some of the things that I hope you found you found useful let me go back here we created if we didn't already have one we chose to work with an office 365 group and that's where we if I was let's say if I was in here I went to forms okay and I opened forms and I decided I wanted to create a form I chose to go into one of my groups you don't absolutely have to that's that's what I do I might want to create a new one you can copy one that you have and modify it or you can create a new one and you have about a half dozen this is my new form April 20th and you put a description in there and you can add your questions you could be a choice question ice cream or choice one or two but you can add options you can allow for multiple answers you can make it required you can make it a drop down rather than the radio button you can add branching so there's some nice capabilities you could add another question text that would be for name you can add rating five star rating like that you could put in a date so I'm just say that obviously the date you can make it required or not you can shift the position you can put it up higher it will collect the date of submittal may not need it and then you can work with ranking and upvoting I haven't used that a lot you can do that okay and then you can you can preview it you can preview how it's going to look on mobile okay you have some themes that you can choose from or you can upload a theme if you want a different color or a picture or the logo of your organization you can collect responses you can use a shorter URL here you can allow anyone only the organization or specific people in the organization okay so I'm usually doing that you could send it on email you could get the QR code very cool or you can embed it in your website so that's pretty nice stuff and you can go back to your settings you could print it duplicate collaborate so on and so forth and then you can connect we are at our time we and then of course we went back to just the final points of we showed where to locate the spreadsheet for the form power bi the connection one last thing if you like to work this way if you like to work from within the SharePoint you you can do something like a form by you could also work with survey monkey but you can go to forms for excel and you can initiate it there or your choice it's a slightly different appearance I think April 20th test and I like the interface now it's pretty much the same it seemed like it when we started from the forms it gives you a little bit more like a description definition but you can also initiate it that way and then that's where you put it okay we are at the top of the hour and this report is should be on its way to refresh it's probably going to take we're not going to watch it and wait for it we could watch grass grow we could go to the airport and watch planes come in and but that will update here a little bit after one was this useful to at least one person and how did people do today's did did we do okay was I'm going to go back to we're going to have another session heaven might have guest topics I'm not sure exactly what we're going to do it's probably going to be on May 18th that you can register you'll see it if you're a member of TechSoup Connect for time banking and community organizations if you click on that it will appear on here so that we have an upcoming event so you'll see that on the next day or two or three or four we'll have something thank you for participating in TechSoup Connect for time banking and community organizations thank you for your comments and questions if anyone has an afterthought and you want to send in a message you could send it to info at ytbr.org and it was a pleasure having this time with you thank you Valerie for your help on the chat and for being my YTB partner in Connecticut thank you to Jamaica, Uganda, Washington State, Canada and anywhere else Florida that people were joining us from and please continue to participate with TechSoup Connect and hope to see you at another fun session with beagles and people in the in the near future have a good breakfast lunch dinner mid-afternoon snack early evening cup of tea or a good night wherever you are okay take care everyone thank you thank you for sharing the time with us stop being the share and Valerie help me do a quick 10 nine eight seven six five four three two one bye


Knockout that shed job like what the 30 at every knockout and my am I getting cheated right like I thought he knocks out everything like what is going on YouTube, what's up man much season? We are one month out from Madden We've been still grinding Madden gotta get those rookie premieres gotta get ready for Madden 24 Gotta get our content grind going if you guys are liking the summertime Madden Please hit the like button and subscribe you can watch them live right here Hop into chat with all these sickos every single night We've been grinding Madden getting ready for Madden 24. It's pretty much NFL season It's pretty much Madden season right here now. I've been trying to get all my rookie premieres now I'll tell you they're probably gonna be trash, but in the wild case that they're good. I hope I have all of them I've got about 10 now Let me know how many RP's you guys got if you guys are grinding them. I'll show you my team I'm using right now for the last four months or so we have been playing with the Eagles team team But getting ready for Madden 24. I've been adding a lot more rookie premieres and honestly these rookie cards are actually insane with their abilities I'll show you what I got right here. Let's take a look at my team. This is the offense. We still got the Eagles offense I just added B. John Robinson, but I still use buyers a little Shawn McCoy I'm gonna use golden tickle Mike Michael Vic to the end of the year because he's golden ticket Michael Vic like what like What are we doing here Devonte Smith AJ Brown Harrow Carmichael Eagles wide receivers We got Darnell Washington an absolute horse probably one of the players that we're gonna look for early in the year next year Offensive line is rookie premieres. They got great abilities. Why not defense? We kind of trying to get the sweatiest defense we can like the best players We got DJ Turner J Ward all the rookie premieres out here We're gonna use Chad Johnson as well. This is probably one of the best cards in the game with that universal coverage He's two AP, but he's worth it. I can kind of put him wherever I want him You'll see in this game that I use them correctly in the right play make some huge plays for me Jair Brown all the rookie premieres most of them I have deep man knockout deep zone knockout I've been pretty much running three three five wide getting ready for a new defense get my reps in three three five wide I don't even know if it's in the beta, but I've been using it I think it's one of the most versatile defenses is easy to adjust to easy to play man easy to do anything You want in three three five wide plus. It's immune to the threat detector. They don't really know if you're blitzing They don't really know if you're playing coverage. It's really a more of a guessing game harder to play often sometimes But it's what I got. We got Lucas van neck Van Ness. The one guy that's a dog is this guy right here Tula Loppo He's one of the best rookie premieres that I got guys say I got Brian Dawkins Grant Delpit Nothing too crazy a little bit of mix of man a little bit of mix his own mix it up But I'm trying to play mad and that's all boys So I've been running through three five wide to get some reps in that in case that is the meta again for like The sixth year in a row with Madden 24 trying to mix it up a little still running tight though Then all the bone a little more get that down. It is the summertime Madden grind once again Let me know how many rps you got like and comment the video boys We are closing on 50k subscribers this year for Madden 24 This is a big year for me got a lot of anxiety a lot of pressure But at the end of the day we're playing video games. We're having fun I want to make this a special year for me and all the boys that like the video So I appreciate y'all go ahead comment and watch this hell game on mutt champs I've just been playing much chance because it's more XP and we do it all for the XP boys J Gray popular stranger is my man. All right I met him at the Eagles tailgate for the NFC championship game really cool And he's got a cool wife too short guy though short can lie didn't expect him to be that short But you know still a good fella are we clones because we're white with beards. We're our clones nice Nice I'm about a foot taller than popular stranger probably got a hundred pounds on him too.   I just got a gut. I'm not like Maddie Like I guess I'm kind of lucky that like my weight goes all the gut All all gut weight all gut weight. I look slimming the waist.  Maddie, you're right. We're just built different. Okay, but I have a job I Mean I have done a lot of like lifting not like lifting but like physical shit in my life So where I don't have tits like that, you know Dude your parents your parents will like anything that makes you happy. They don't they're kind of scummy Not even lying, but how we missed it. Let's go AJ. Oh my god. There's no way he undercut that.  I should put McCoy in No way. That was the perfect blocking dude. Oh my god. He threw it. Let's go Brents.  You're kind of acid corner for safety or I think this is I've been known to be wrong before though. Oh my god.  Well, like there's just no way dude Just throw a drag complete. Thank you dog. Oh my god.   Just like let it happen. That was like the one dude I was probably covered the most and he do it on So trash man, I just want to know hit me then got that fumble I think it was a safety. Is there another hiding avalanche? I need more passive avalanches Enforcer, I just it was just an enforcer that hit me.  Can't lie So here I probably go to like Eagles games only went to the championship game. I live in Cleveland now So Browns games. I went to like eight Browns games I probably watched about five total quarters of football from the Browns, but you know, I went to a couple games So it's not open.  It's annoying defense g would be the best defense if it had like a blitz threat like a really good blitz threat It would be it would be so good So that's what I mean, dude. Oh my god, like where did that dude come from? I need to put McCoy in for that when I want to throw the ball to him because McCoy has backfield master He would never get back like that. He's still this is where he just runs counter I wish I could tell you like I knew what to do, but Whom my dog this counter is just actually Poggers right now, dude And dammit, bro short knockout Just snapped the out of Dog like this is unreal how this is not a I need to put my I gotta I gotta put my cloud my purples on something To be a little bit. Oh, they're on 30. No wonder. I sold right there. That's my fault Oh, come on Turner spinners, not the best the best defense is Any dollar basing line or or this defense?  It's hard. You can't trust anything This is touch. There's two men under if he doesn't put a deep blue in the middle of the touchdown Oh, he did Well boys if you're new here Three deep is kind of my I'm actually on call timeout. That's what we're gonna do here. You ready? We're gonna put buyers in if he gives me that look again. I'm gonna one-on-one with buyers We just need to block See if he uses that guy We're gonna try to get a one-on-one with buyers and it looks like Eric. Oh sammy knight. Let's see what he goes for here Nobody's on buyers Tell you Just not enough time. Oh, I'm gonna still pick six Damn, see what I mean. I got a one-on-one. I always take a one-on-one right there, but Oh, I fumbled. That's how we can stop the fumble I mean, you always got to have a plan against three deep in case you need it I mean, it's it's hard to score against three deep with one play from the 60 60 yard play, but So that's why I was like, yeah, I'll always take a one-on-one with a six four guy in those situations really That's a pick dog like I like let me stand stand as a first down Oh my god, it's so bad, dude. Man. Let me just stand still right there short not This dude is cycled through four plays. He's gonna run counter again at some point here. This is disgusting gun empty trace that Short knockout. Thank you Get him down 10 points right now. What's going on? This will be an epic game here Um, I put my user in a curl flat because against that stack I when he snaps the ball I want to jump to that quick pass on the left And if you put yourself in a curl flat the computer will automatically like take one step that direction If you put yourself in a blitzer automatically that fraction of a second is going to be straight down So my plan on that when he goes empty and I'm blitzing everybody one person's going to be free So I put myself in a curl flat. So he takes that direct snap to the left side there instantly I shouldn't have told you guys that for free. Honestly This guy has a plethora of defenses. Let me rush in one person.  It's putting McCoy here. I've been getting stopped down here because of that Let's put McCoy right here. Let me dog.  He's probably 90 speed or something Good work boys All right, let's go back to a set of plays. Do I have zone drops on no What place are you going to call now empty stack? I want to put all right I want to put I want to put shat at this other safety. So chat it on this formation only Knock out that shed job like what the 30 at every knock out Am I getting cheated? I literally put him there for that. I might leave him there for this game trips. Why flex? It's just verticals here There's nothing to throw to here Somehow he just gets busy with fontana like bro. This is so nasty. Here we go What's our plays now? Come on his reggie 99 speed. Let me get no one smith in the god No, it's gonna be verticals again here unless she runs Hmm. Oh, that's a hitch stick from the avalanche. No, that'll count Chad, I need you right now. Chad. I need you talk like Am I am I getting cheated right like I thought he knocks out everything like what is going on I put him there for that is something am I just getting cheated? Does he supposed to knock that out with universal or what is going on like am I Short knockout. Thank you. No for real like is there something wrong like normally he's been he's been knocking out everything All right, we know this play Thank you. Holy On tuesdays And we're going by ha come on brance Talk to me nicely kids What am I by four let's go by five Oh, I thought he's just got kick return. All right tight double same thing It's just got to be knocked out. Come on Dawkins, bro I wish I had safeties with short knockout for zero. Do they make those guys anywhere? All right, Chad. There we go. That's what I want to see. There it is. There it is. That's literally why I have them there literally Literally why I have them there. Good Chad Oh my god, dude, like is that just not him? I just don't have a medium knock out there like this is Just disgusting man. All right. Who is that turner? That's on that guy. Who's my other dog firing jones? Oh, he's in a different this is a different play Let's go brents go brents. You're having a huge one. You're having a huge one brents Let's go man. Come on.  Oh my god.  We can win off this chad chad. We can win off this. We can win off this I will always tell you Just give him enough time. Okay Okay, I mean let's go Always will always They will always Always let's give him a little time boys. That's all it'll happen. Oh How does it feel? How does it feel? To down your leg when your team needs you the most. How does it feel?


Hello everyone, welcome to Autism with Doug, streaming live daily on Bookmap Discord and the Bookmap YouTube channel at 1.30 p.m. Eastern Time. Before I get started, I need to go through the disclosures. General disclosure, all Bookmap limited materials, information, and presentations are for educational purposes only and should not be considered specific investment advice nor recommendations. Risk disclosure, trading futures, equities, and options involves substantial risk of loss and is not suitable for all investors. Past performance is not necessarily indicative of future results. The focus of my presentation and the focus of the options-doug chat channel and Discord is options, order flow, the impact of options markets on stocks and futures, and the influence of market maker hedging flow on price action. I have a two-step process for trading, and the first is planning, and I use positional analysis. I look at how traders and market makers are positioned in the options market and how those positions change from day to day to develop a thesis regarding the expected trading range and volatility for the day, as well as a directional bias. And the second step of my process is execution. And I look at real-time order flow in Bookmap and real-time market maker hedging flow with SpotGammaHero to confirm my thesis and for setups. And just to be clear, I am using the options market as the basis for my analysis. And when I talk about a setup in a particular underline, for instance, the S&P 500, there are a number of ways to take in any trade that I talk about. Again, I'm talking about the underline. So for the S&P 500, you could buy or sell futures, ES futures, or spy shares, spy options, or SPX options. So again, I'm just going to talk about the underline. And again, you can take these trades any way you want to. If you like to trade options, that's great. If you like to trade futures, that's great. If you like to trade stock, shares, that's great as well. All right. And finally, on topic, questions and comments are welcome. And I will be watching the options-dog chat channel and Discord and chat and YouTube for your questions and comments. So again, questions and comments are welcome. All right. Let's get started. And what I want to talk about today, my agenda for today, is we'll quickly go over some news items, economic data, and events, go through our positional analysis for the S&P 500, and then talk about stocks and planning and positional analysis for stocks as well. And then finally, I'll talk about some setups. All right. So the news, economic data, it's been a pretty light week. Tomorrow GDP comes out at 8.30 a.m. Eastern Time. And then on Friday, the PCE inflation data that comes out on Friday at 8.30 a.m., and apparently that's what the FOMC looks at. So that could be important. And then on Friday, consumer sentiment at 10 a.m. Eastern Time. And also just a reminder, Friday is March 31st, the end of the month, end of the quarter. And that is also the day of the JPMorgan collar roll. And this is a collar that we keep track of, especially if price is close to one of the strikes. And right now, the potential strike in play is the 4065 level. And that is the short call strike of the JPMorgan collar. All right. So that's the upcoming news and economic data and events for the week, rest of the week. Let's talk about our positional analysis now. And this is the S&P 500 futures, ES futures and book map. And before I talk further about this chart, I want to take a look at a larger timeframe. And this is the SPX, the S&P 500 index, showing just price and spot gamma levels. These levels are provided to spot gamma subscribers for a variety of platforms. And here, this is showing the S&P 500 index, again, SPX. And the spot gamma levels, the key levels, first of all, there's the put wall at 3,800. That's a strike with a large net negative gamma that can be expected to act as support as it did on Monday the 13th. Well, let's see, when is that? Anyway, Monday a couple of weeks ago. All right. The next key level, here's the 3950. And that has acted as support yesterday. And then the 4,000 level, that is the key gamma strike. And that's the strike with the largest absolute gamma, or the absolute gamma strike. And also the volatility trigger. The volatility trigger is spot gamma's proprietary gamma flip level. And that is the strike, again, the gamma flip level. Spot gamma assumes that traders are long puts, market makers are short puts below that level, so they're in a negative gamma environment. And they have to trade in the direction of price to hedge their delta exposure. And above that level, they're in a positive gamma environment. Again, market makers position above that level is positive gamma. And in that case, they have to trade against price to hedge their delta exposure. And then up above is the call wall. And that's the strike with the largest net positive gamma. That's at 4065, again, the short call strike of the JP Morgan collar. And that strike can be expected to act as resistance. All right, so that is a 20-day one-hour chart for SPX. Now let's take a look at another thinkorswim chart. And this is just for today. This is showing a one-day, one-minute chart, and showing the levels that are in play. And this is the volatility trigger at 4,000, and then the zero gamma level at 4,008. And what I'm not showing here is a, there's also a resistance level at 4,010. I'll show that on the book map chart. And also the SPI 400 key gamma strike level has also been in play. All right, so let's take a look at book map now. And I'm showing the same levels on this chart. And I have two columns of notes here. These are the SPOT gamma cloud notes, again, provided to SPOT gamma subscribers for a variety of platforms for the book, for book map. These levels are provided in cloud notes, which are updated automatically. And then I also have my own column of notes here, this C levels, cloud notes. And SPOT gamma is showing the key SPX levels and combo levels. They're known in play here, and that would be a combination of SPX and SPI levels. And I'm showing, in my cloud notes, key SPI levels, that's the 400 key gamma strike for SPI. There's that 410 resistance level that was noted in the SPOT gamma AM bounders note. And then there's that 4,008 zero gamma level. And that's the level just like it sounds with the zero gamma. All right, let's take a closer look at what's been going on and how these levels have been in play. I'm going to zoom in, first of all, to the morning session here. And the thing to note is how these levels acted as support and resistance. And this morning, the SPI 400 key gamma strike was basically the upper end of the trade, the resistance level. Price broke below that level. And when we look at setups, we'll see that options traders were fading this move. They were actually buying puts and buying calls, but the put buyers were more aggressive. And that helped to push price lower. And then initially, this 4,010 level acted as support and then it acted as resistance as price moved lower. All right, let's scroll over here. And then when we look at HERO, the hedging impact of real-time options, we'll see that traders start fading the move higher. So the call buyers become more aggressive than the put buyers and price reverses higher above the SPX 4,000 level. In that, in this case, the 4,008 level did act as resistance until price finally broke through. And then finally, 4,010 level has acted as support. All right, so that is the S&P 500 showing how these levels are coming into play. And now let's talk about shifts and levels. And first of all, there were no shifts and levels in the SPX except for the zero gamma level dropped from 4014 yesterday to 4,008 today. That's something that I don't follow closely. I don't look at closely. For spy, the volatility trigger did drop from 400 to 398. And the call wall dropped from 410 yesterday to 402. And I interpret that as somewhat bearish. All right, and then for QQQ, the volatility trigger also dropped from 309 to 306. The put wall increased from 285 to 300. And then the call wall dropped from 320 to 310. All right, so that is the shifts and levels for the S&P 500 and QQQ. Now let's take a look at the absolute gamma charts and we'll see where those levels come from. And this is showing absolute gamma levels at different strikes. This is the zero level, this horizontal line. And above that line, this is positive gamma or call gamma shown with the black bars. And below the line, that's negative gamma or put gamma shown with the teal bars. And this is market makers position at these levels, at these strikes. And this is, again, SPX, we're looking at first. And you can see that is the 4,000 level. That is the strike with the largest absolute gamma. That's the absolute gamma strike. And that can be expected to act as support or resistance or magnet as price, a magnet for price. And then here's the put wall down at 3,800. The strike with the largest net, negative gamma can be expected to act as support. And then the call wall at 4065, the strike with the largest net, positive gamma. And again, that's the short call strike of the JP Morgan collar. And that can be expected to act as resistance. So that is the SPX. And to get a complete picture of the S&P 500, we need to look at SPY as well. And again, the same thing. These are the absolute gamma levels, positive gamma or call gamma above. And put gamma or negative gamma below the zero line. And this is the 400 key gamma strike or absolute gamma strike. And the put wall at 390. And that's pretty obvious. The strike with the largest net, negative gamma can be expected to act as support. And then finally, again, the call wall moved back down from 410 yesterday, back to 402, the strike with the largest net, positive gamma. And one thing, I don't have a screenshot of this yesterday. So I'm going from my recollection. But this does look somewhat like a reduction in call gamma above the 400 level. And I don't know if it's necessarily an increase in put gamma. But there is certainly a dominant, so put gamma below the 400 level. All right, while we're on this page, let's take a look at the combo strikes. And this is combining SPX and SPY gamma into one number converted to an equivalent SPX number. And again, the same thing, put gamma or negative gamma below the zero line, positive gamma or call gamma above the zero line. And then here is the, this is right around the 4,000 level. That's the volatility trigger for SPX. Again, the gamma flip level with positive gamma above and negative gamma below. And from this chart, you can see where that comes from. All right, let's take a look at NASDAQ now. And for NASDAQ, we just look at QQQ. The index, NDX, is not really significant. So for QQQ, the key gamma strike is at 300. And recall the call wall shifted down to 310. And then the put wall is also at 300. So that shifted up from 285 yesterday to 300 today. All right, so that's the NASDAQ. And let's take a look at some additional data now. And I always look at gamma notional. This is market maker's position on the gamma curve for all these indices. The SPX shown on the left column, SPY in the middle column, and QQQ on the far right column. And this is showing market maker's position on the gamma curve. And note for all of these indices, it is negative. So that indicates that traders are long puts. Market makers are short puts. And they have to sell futures as price decreases to hedge their delta exposure. And then if price increases and implied volatility drops, they can buy back their short futures. And in a negative gamma environment, again, market makers are trading with price to hedge their delta exposure. And that tends to increase volatility since market makers are trading with price. And these levels did shift from yesterday. And they became more negative. So yesterday, gamma notional for SPX was minus 171. And today, it's minus 264. And for SPY, yesterday, gamma notional was minus 1254. And today, it's minus 1601. And for QQQ, gamma notional yesterday was minus 219. And today, it's minus 232. So a shift lower in all these, gamma notional for all these indices yesterday. All right, the next thing that I want to take a look at is the Vana charts, which will illustrate what I was just talking about. And these look different than what I've seen for quite some time. And it's possible. I haven't checked that they changed the algorithm or somehow how this data is displayed. But it's still showing essentially the same thing. And we will take a look at the green line, which is the current expiration. And this is showing for SPX as price decreases. Market makers delta notional, which is shown on the vertical axis, and strike price on the horizontal axis. So as price drops down, their delta notional increases. And that means they want to remain delta neutral. So that means they have to sell futures to hedge their delta exposure. And just the opposite as price increases and implied volatility drops, they can buy back their short futures. And the green curve is also showing how their delta notional changes with the changes in implied volatility. And that's the Vana effect, the change in delta with a change in implied volatility. And then this black curve is showing the next expiration. And that's showing how market makers delta notional changes with changes in price and as time passes. And that's the charm effect, the change in delta as time passes. So that is SPX, your spy, same idea. Delta notional increases as price decreases. And the same for QQQ. And for all those charts, we can see how that has changed over time. So just minor changes for the last three days. All right, now let's talk about some stocks. And my starting point for stocks is my key gamma strike spreadsheet. And these are all the stocks in my watch list. And I track the key gamma strike from the previous day and compare that shown in the E column. So that's from yesterday. And in the D column, that's the current key gamma strike. And that's for today. And then I know whether these levels increase or decrease from the previous day. And I color code these just for a quick visual reference. So a red number indicates that that level decreased from the previous day. I interpret that as bearish. And that is a signal to do some further investigation in equity hub. And I'll talk about that. And then a green number indicates that level increase from the previous day. And that's bullish. So with a decrease in number, that indicates that traders are looking for lower prices. They're accepting lower prices. And they're positioning themselves in the options market for lower prices. And just the opposite for an increase. They're positioning themselves in the options market for higher prices. So the thing to note here, I really don't trade IWM. It's in my watch list just for information. But I trade most of these other stocks. So this is my starting point here. And I'll show how I did further investigation and came up with a bearish thesis for AMD and Microsoft. All right, so Truman asked, does the Vanna chart always assume market makers are short puts and not short calls? So first of all, let's talk about just basic assumptions. And for indices, spot gamma assumes that traders are long puts and short calls. And market makers take the other side of that position. So market makers are short puts and long calls. So in the region of the gamma curve, where they are short puts, that's the negative gamma region. And then above that volatility trigger, spot gamma assumes that market makers are long calls. And that's the positive gamma region. So the Vanna chart just shows how they're delta notional changes based on where they are on the gamma curve. So for most of this year, especially for spy, gamma notional has been negative. And recently, quite negative, anywhere from minus 1,000 to minus 2,500. So that's the assumption, always the assumption for indices, SPX, the SP500, the Russell, and the NASDAQ. So again, the Vanna chart, let's go back and take a look at the Vanna chart. So if the green curve was sloping up like that, that would be indicative of a positive gamma environment, indicating that market makers position on the gamma curve, their market makers delta notional will increase as price increases. And in that case, they have to sell futures. So they're selling futures in the direction of price to hedge their delta exposure in a positive gamma environment. And then if price decreases, they can buy back their futures. So again, in a positive gamma environment, which would be shown by a green curve in the opposite direction that's shown on this chart, that would be a positive gamma environment. This is for indices. All right, so that's the key gamma strike list. And with that, again, remember AMD and Microsoft. And yes, Truman, they are assuming that traders are long puts and market makers are short puts in the negative gamma zone. All right, so let's take a look at some setups now. And I'm going to start with AMD. And for those of you who may not be familiar with this chart, this is Spot Gamma Hero. And it's showing two lines here. There's a white line and a purple line. The white line is price, and it's just a line chart for price. And then the purple line is hero, the hedging impact of real-time options. And this is showing options trades and market maker hedging activity. And a falling purple line means that traders are taking negative delta positions, that they are buying puts and or selling calls. And the net of that activity is negative delta. So again, my assumption or thesis for AMD was bearish. And let's do some further investigation and this is how I approach my preparation. And I'm going to switch to my watch list, sort that in alphabetical order. And then let's take a look at AMD. And I look at this history. And this is a 10-day history of the key daily levels. And I look at shifts, like I said at the beginning. I look for positional analysis. I look at how traders and market makers position in the options market changes from day to day to develop a thesis. So my quick glance this morning in my spreadsheet showed a drop in the key gamma strike. I interpret that as bearish. So came over here to the spot gamma equity hub, see the key gamma strike dropped, and I see the hedge wall dropped also. So not significant changes, but AMD is not a high-price stock. So I interpret this as bearish. And I was looking for a short setup. So let's go back to hero. And here this was the setup. Note the short drop in hero. So initially, if you were trading in the morning, that would have supported along. I was looking for something in line with my thesis, which was a short setup. So I was looking for that drop in hero and then a continued move lower. All right, so let's go take a look at book map now. And we'll get to a setup for the S&P 500 in a couple of minutes. So here's AMD. And here was the setup in the morning. And the order flow, in this case, the order flow shown by AMD. And I'm especially talking about the cumulative volume delta shown here with this falling purple line in the subchart, and also all the pink dots for those of you who may not be familiar with book map. The dots that I have, I'm talking about the bigger dots here, the volume dots, are either green or pink. Green indicates that they're always buy minus sell, market orders, or aggressive buyers versus minus sellers. So the dots are always buy minus sell. And buy means they're more buyers than sellers. And peak means they're more sellers than buyers. And notice how the aggressive sellers come in here at the absorption just below the 97 level. There's a trend break and then a series of lower highs. And finally, a couple of tests of the 96 level and also just below VWAP with a target at the 95 key gamma strike. So even though a lot of the other semiconductor stocks were strong, given micron earnings report yesterday, I think maybe there were a lot of other semiconductor stocks were trading in sympathy, I stuck to the plan here with AMD and it worked out. Everything lined up, the plan, the hedging flow, as well as the water flow, all indicated a bearish set up here in AMD. Let's zoom out. So then after that, it looks like it has turned, rebounded back to the 96 level. But the best set up, the clear set up, was this move lower in the morning. Let's go back to book map now, zoom all the way out. And price action is pretty closely following options trades. Hero decreasing, price decreases for the short set up. And then options traders start fading the move and taking positive delta positions and price moves higher. All right, so that was AMD. And then the second was Microsoft. So let's zoom in on this. In here, a similar set up. Initially, hero was bullish if you wanted to trade, just following that in the morning, a long set up. I was looking for a short, watching for a hero to drop. And now let's go take a look at order flow and book map for Microsoft. Going to zoom in. And this is the move pre-market. Pretty sharp move higher. And the opening print was just above 279. I'm going to zoom in. And AMD was the better set up. But let's take a closer look at this. And there's a really nice trend break here. And again, remember, traders are taking negative delta positions starting somewhere between 1015 and 1030. Trend break. Aggressive sellers coming in. And then a test of VWAP. I move a little bit higher. Note the absorption here. So I'm by this small pink square. And also the number there. And then price moves lower. Let's go to Equity Hub and take a look at Microsoft. And Microsoft was more of a mixed picture. Let's go back to Equity Hub. And note that hero remains bearish here. Traders are continuing to take negative delta positions. The notional value minus 61.34 million. Let's go to Equity Hub. Take a look at Microsoft. There's the drop in the key gamma strike. Also note the strike and the key delta strike. And there was an increase in the put wall. So again, I interpreted that as somewhat bearish. And it was confirmed by that thesis was confirmed with hedging flow and order flow. All right, let's take a look at the S&P 500 now. And let's see if we can have to type it in. And this is a combined signal for the SPX, SPI, and SPX. And I use this signal if I'm trading any form of the S&P 500. ES futures, SPX options, or SPI options or shares, any form of the SPX. This is the combined signal giving the most complete signal for the S&P 500. Let's zoom in on this. And I'm going to zoom in. So I'm just looking at around the RTH open. So this is 930 right here, just to the right of the left edge of the chart. And this is showing, overall, this is net negative delta. And as usual, for the index, traders are buying calls and buying puts. But the put buyers were winning. They were buying more puts, more aggressively, than the call buyers. And we'll take a look at that in just a minute. So that's set up a short. And now let's go take a look at, actually, we'll take a look at this setup to the long. And note the leading effect of both of these setups, that the options trades, and this is what's great about looking at the S&P 500, is that the options trades often lead price, giving you some time to look at bookmap for level, for potential reversal, and also watch order flow. So let's go take a look at bookmap. Let's go back to the ES now. I'm going to zoom in on the morning session, up until about 12.30. So I've talked about the levels in play. And there was the spy 400 key gamma strike, acting as resistance.  Notice that, at the same time, large traders were selling this move up with iceberg orders, shown by that falling light blue line, not heavily, but they were fading the move. And iceberg orders are what large traders used to hide their size. So large traders fading that move. And notice it was driven up by buy stop orders, shown by this rising yellow line. Those are buy stop orders. Once that stops, price starts to fall. Notice the falling blue line, dark blue to pink line. That's cumulative volume delta. Aggressive sellers are starting to come in. And you can see by the shift to pink dots. So they're resistant at the 400 level, trend break, a retest of that break level, and then a move higher, lower, as options traders were taking negative delta positions. Again, the put buyers were overwhelming the call buyers. So that's the first move, that reversal off the 400 key gamma strike, spy 400 strike. And then notice that large traders, and they often do this, they buy weakness and sell strength. So they're selling strength here. Then they start buying weakness, shown by this rising light blue line. And you can see the iceberg orders coming in. That's showing that's the on-chart indicator. And notice this is quite large, 3287. So 3,287 contracts and eight different transactions. So price starts to move higher. Again, remember, options traders are already taking positive delta net, positive delta positions. So now the call buyers are starting to overwhelm the put buyers. Water flow shifts bullish. Note the shift from pink dots here just around 11 AM to green dots. And price moves back up to the 400 key gamma strike. All right, let's go back and take a look at hero. And just make sure I know what I'm talking about, or I'm correct about this. Yeah, I am. So this rising orange line shows call buyers. Traders are buying calls, positive delta positions. And the falling blue line indicates that traders are buying puts, taking negative delta positions. And so far, in this time frame that I'm showing, and this is actually the entire RTH session, that there are still more put buyers than call buyers. And let's just zoom in on this and take a look at the numbers up to this reversal point. So this is showing 1.84 billion minus 1.84 billion versus positive 630 million. So again, just like I said, the put buyers are overwhelming the call buyers. And then that shifts. Traders stop buying puts. And actually, it looks like they're selling puts a little bit here. Then they stop. They level off with the puts. They continue to buy calls. And price moves higher. And this is all supported by order flow as well. And I pointed out before, because I'm presenting on one screen, I have to jump from book map to hero and back and forth. And I actually have actually three screens, two computers, one screen on one, and the other computer, two screens. So I'm looking at these things simultaneously. I'm looking at book map and hero at the same time. So advocates ask, how can you tell if they are buying puts or selling puts? These lines are shown in terms of delta. So buying puts is a negative delta position. So that a falling line, blue line, that's negative delta. These lines are shown in terms of delta. And this is a notional value shown over here on the far right. That's a negative number, notional value in dollar terms, also in delta terms. So this is negative delta, indicating traders are buying puts. And if this line was rising, that would mean they are selling puts. So the blue line is always puts. Rising means they're selling puts. That's a positive delta position. And a falling line means they're buying puts. And the same goes for calls. A rising orange line indicates that traders are buying calls. And a falling orange line indicates that traders are selling calls. So orange is always calls. Blue is always puts. And the direction of the slope of the line, which way it's going, indicates the delta of the position. All right, so that's the S&P 500. And I'm going to change that back to total. Zoom in on this. And notice the sharp drop lower here. This is a big block trade showing some large institutional trade causing such a sharp drop in that line. Actually, let's go back and take a look and see if that's puts or calls. So it looks like some large institution bought a big block of puts. And just for interest, let's see if. So it looks like that's puts that expire today. This is shown by this next expiry. So I've shifted from all expirations. I've turned that off and turned on the zero DTE options. So this will not have any impact if this is all zero DTE, will not have any impact and open interest and levels for tomorrow. This is just for today that somebody is coming in and buying a large block of puts for today. So they're looking for price to move lower today. Let's go back to all expirations. All right, so that's the S&P 500. So if I were trading right now, I'd be looking for short. And let's go back to the S&P 500. Go back to the full chart now. So here is a, let's see what time that was. Let's go back to hero. This was that. So that hero started to drop lower right around 130, about right when I started. So let's go back to book map now. And there's that sharp drop lower. And now price is chopping around between the SPX 4,010 level and the SPI 400 level. And notice in the session range volume profile, that is also the area with the largest volume. That's where most of the trade has occurred today in that region between the SPX 4010 and SPI 400. All right, so that is the S&P 500. And let's take a look at the NASDAQ now. And recall also, so for today, I was bearish AMD especially, also Microsoft. And then modally bearish QQQ and SPI. So let's take a look at QQQ. So far it is rising. There was a good short set up this morning. Let's go take a look at hero. Go to QQQQ, QQQQ. Take a look at the morning session and definitely a divergent set up here in the morning. Notice this is from the RTH Open. A drop in the hero, even though price was rising. Price rising makes an equal high then starts to move lower. So it took a while for this to play out and it reversed just after 10 a.m. Eastern time. Let's go back and look at book map. Zoom in on the morning session. Here's a trend break. Order flow was not as easy to read as some of the other instruments that I looked at like the S&P 500. But a trend break and move lower with the 310 call wall as a first target. And I'm gonna zoom out a little bit. And then the 309 level. That's a C3 combo three level. And note all the liquidity at that level shown by this dark orange band there. That's liquidity resting in the order book. So that would have been a second target if price had continued lower. And one way to play this was to buy a zero DTE put. And those puts were trading the 311 put was trading for about a dollar or a little bit less. And down here it was trading for around 270, something like that. So a good profit on a long put. Anticipating the reversal just like the traders were doing here with shown in hero. All right, let's go back to hero. So nice divergent setup again in QQQ. All right, let me check for questions. Well, the hero line is Truman asked the hero line is from the buyer's perspective, not the market maker's perspective. And so what this line is showing, the falling purple line is showing the traders are taking negative delta positions. So let's just, whether they're selling calls or buying puts market makers are taking the other side of that position. So they have to sell QQQ or futures to hedge their delta exposure. And let's just see what they were actually doing. So they were mainly buying puts. So this falling blue line, so again it's showing both, is the hedging impact of options trades. So we know that traders are buying puts, market makers are selling puts, and they have to sell QQQ, sell NQ futures to hedge their delta exposure. So for SPX or SPI, I think the easy assumption is they are selling trading ES futures to hedge their delta exposure. And I assume the same thing for QQQ, NQ futures. And anyway, there's a direct relationship between QQQ and NQ. All right, so I hope that's clear that you can look at it anyway. Traders, here again, falling blue line, traders are buying puts. Market makers are selling puts, they're taking the other side of the trade, and they have to sell stocks, sell futures to hedge their delta exposure. All right, so there's a question, I go JED, next expiry, green line, always today, zero DTE options. So the thing that I showed before, yes, and let's go take a look at that again. And we're on QQQ, we'll just stick here, and I'm gonna show total line again, and now show next expiry, and we'll just show that. So when I showed this for SPX, SPY, or QQQ, it is today, there are expirations every day for SPX, SPY, and QQQ, for QQQ, this is for today. And for stocks, all the stocks in my watch list, and for most stocks, now there are weekly expirations. So the next expiry doesn't necessarily mean zero DTE, it does for SPX, SPY, or QQQ, for IWM, it means Monday, Wednesday, and Friday, and then for the rest of the stocks, it means Friday. So that's what next expiry means, is you have to know which instrument you're looking at, and when the next expiration is. Again, SPX, SPY, and QQQ have expirations every day. IWM has Monday, Wednesday, and Friday expirations, and then single stocks, most single stocks, have Friday expirations. All right, I'm looking for, waiting for any more questions. And meanwhile, we'll take a look at Tesla, and Tesla is always a stock that has a very strong correlation between options trades, hedging flow, and price action. And let's go take a look at book map, and we'll wrap it up there. So Tesla, short setup in the morning, the long setup, reversal around 10, 30, 11 o'clock, and a move higher. Liquidity levels, definitely in play, but no spot gamma levels. All right, I go, Jed, I'm waiting on you. I see you're typing, type past. I need to wrap it up. All right, so let's go, we'll take a look at hero for Tesla. So most likely for stock like Tesla, traders are trading weekly expirations. That's almost always the case for Tesla. So here, let's see what this, I'm gonna zoom in. So this is large block order here, shown on this purple line. So first of all, let's separate out, puts and calls, and we can see that's puts. So there's a large block order for puts. Somebody's buying puts, large institutional trader buying puts. So this is dropping the put line, not the call line. All right, now let's take a look at, we'll just take a look at the next expiry. And let's just compare. So this is mostly next expiry. I'm looking at the number on the right side of the screen here. This notional value, the green line minus 107 versus minus 39.8 for the all expires. And this is to be expected that traders are trading next expiration, Friday expiration for Tesla. I think that's pretty much always the case. So green line does not mean calls. In this case, green line means next expiration. And this is all, so we can actually look at next expiration, puts and calls. And there's a legend up here in the upper left corner. It's probably too hard to read as you're watching this. But if you're using a hero, you can see this. So this kind of purple blue line, that's puts. So we can see the large block order of puts. And this is Friday expiration. We know because I have the next expiry checked. And no, no big call sellers, big put buyers. Again, this blueish, purplish line, these are puts, put buyers right here. And put buyers are driving rather than call sellers. Look at this, you have to look at the legend. So green is, yeah, green is calls. And this purplish blue line is puts. And just compare these numbers here. Minus 123 million versus minus, are actually positive 15.85 million. So in this case, looking at this point in the chart, traders are buying Friday expiration calls, net their buyers, because that's a positive number, but they're buying more puts. So in this case, for next expiry, puts and calls, they're buying calls, but the put buyers are overwhelming the call buyers. And this large block order was definitely put buying. Falling line, falling purple line means puts. All right, let's clean this up. Let's go back to all trades total. All right, so Ike of Jed, I hope you got that straight. So remember the direction of line indicates a delta. And this is showing, this is normally what I look at. All trades, all expirations, solid line, unless I need some more clarity. All right, so there's the entire day for Tesla so far. Negative traders are taking negative delta positions. And we'll take one final look at book map and S&P 500 back up to the 400 level. All right, that's it. That's all I have for today. Thanks for watching. Thanks for your questions and comments. And I will see you tomorrow. Thanks again, bye.