Hi everybody it's Sam at Mixed Up Craft thank you for watching today so I've got a few things to show you so I have got some bits from Craft Stashed. I've been looking at this one all the time it's been in my basket and then it kind of goes out of the basket because they do take stuff out I think after like maybe a day or something your kind of basket gets emptied then I put it back in there again and I thought I've just got to get it and it's just it's one it's an old style of Daisy Mae stamps and I just adore it I absolutely love the Dash Hand Dog and I just think it's super cute and it's got a pair of pants in its mouth and it's got the laundry basket it's just very very sweet and you know I'm a big fan of Daisy Mae stamps so I just needed it in my collection so I picked up that one then I got some more of the Dot and Dab these are the 20 mil hook and loop I use these a lot on my bigger gift bags I really like these ones and they're super sticky so they you know you've got no worries of these coming off of your project so I always like to kind of keep stock of those. Then I also picked up some of the Daisy Mae papers because I have never brought the Daisy Mae papers and I was looking at them and I thought they're really nice and they're perfect background papers so this is the six by six and this one Sunshine Flowers and they're really nice bright colors which works really well because I love to color you know in all the brights bright pen colors that I have so and the alcohol markers and stuff so you can just see I love that one there really really nice and that's gorgeous so I thought I've got all these stamps absolutely love the collection I should have the papers and you get there three of each three of each eight designs 180 gsm so perfect for your maths and layers and then also they had this one which is the eight by eight and this is four of each and there are six designs and that's 180 gsm so that's the same as well and this one's got a bit more of a it's almost like it's it's not but it's got the effect that it's been printed onto craft card so it's got a very slight distress look to it so I don't know how well it's picking up on camera but can you see just like that distressed effect and it's on everything even on these stripes you can see there's kind of like patches there and it's just again just really nice I really liked it love that one there the polka dots but again it does have a grainy look to it that's really pretty so I just thought these are going to work you know I when you enjoy a collection obviously the designer you know they do their samples and they use a lot of their papers so I thought well that's what inspires me and that's what I like to look at so I yeah I should get the papers as well so really like those two and then I got this here which is the stamp cleaner so it's very similar to the stamping up one which my mum has so basically what you do is you will there's these two mats so I'll just pull that one out just so you can see it a bit better it's almost like carpet but it's not this is microfiber and this is lymph free so you can just see it's just a thick foam and then these bristles and it's like that on both sides and the idea is is that you will spritz it with your water or your stamp cleaners and then your dirty stamp you will rub onto here and then you can have this wet as well and then you just kind of rub it again here and it will just make sure it's completely clean so this takes off like the initial dirt and this one will stay a little bit lighter and not have as much but you can clean them you know you just take them off you can just put them in some warm soapy water and clean them up but it's just having that it's perfect for you know traveling and stuff my microfiber cloths like I say this is them here I keep them hung these are clean they're just heavily stained I use them all the time there is no problems with these and they're great for when I'm using my stamping platform but when I've just got my stamps on my stamping blocks so the acrylic blocks so things like this you imagine there's a stamp on there you just rub and then rub it or dry you know that you can keep this one dry as well if you want or dry and it will dry off and then you just peel them off and put them straight back on there um in the packaging and put them away so you know each each to their own really like I say if you've got the stamping platform and then I would use this to then you know clean off the stamp and then put it away that way I did at the beginning I used to have one that was just going to be a bit like this one that would get very dirty and then one that would stay cleaner but over time you can see that they uh they're both like I say they're just heavily stained there's nothing wrong with these and they are all lint-free and I swear by these microfiber cloths so yeah I just thought it'd be quite nice for when I'm you know traveling and it just keeps everything compact so that's the idea for that anyway but yeah it's by cross two five by seven stamp cleaning mat and you can see there where they've got that side where it's you know it's got all the ink and then this side she's kind of rubbing it off so they're just really handy and it works on clear rubber cling and foam stamps so you can use everything washable and refillable inserts I didn't realize that so that's always good to know as well so I've got that one and then I'm I do use my white kind of I well I call them highlighter pens because that's what I use them for and these this time I've gone for the Secura the actual jelly roll brand and I'll show you because I always use my Posca pen I've got a few different um you know uh sized tips for those but also trying to find where it is I did have the I'm sure I still yeah here it is so these are the Ranger ones and as much as I love them and there is loads of pigment in them it just doesn't always work it clocks up all the time and it's really infuriating because they are nice but it's and it is very opaque they're perfect for you know just adding that highlight maybe you've got a stamped image that you've colored also for adding flow stitching on some colored cardstock you know it's all that kind of thing but these are obviously finer than the Posca which is your paint pens but I just really struggle and both of them do it all the time I don't know whether it's to do with the temperature in my room but just yeah I just ended up getting really frustrated so I was watching a few of my favorite art tutorial um YouTubers who do you know like more more illustrations and things like that I find them very relaxing to watch and they all use the jelly rolls for when they're adding highlights so this here is the you get your 0.3 mil 0.4 mil and 0.5 which is 5 8 and 10 on the sides there and you can see they're made in Japan they're very very good quality really nice and these I didn't think were too bad for the price I'm I'm pretty sure I haven't got my where's my invoice these are $4.99 and I thought that was really good because they are like like I said they're recommended by a lot of people so I've thought I'd give them a go but what I didn't realize is I still left this one in my basket because I this was on its own and this is the Suful again that like I'm sure it is still yeah is Sakura because it's the same lids and everything but there is no it's about the same amount in there but it doesn't have a number on this one and I'm pretty sure it's probably the same but yeah so you know if that's kind of thing you like and maybe you've got some other ones that you really enjoy as well or maybe you have the same problem as I have with these because it's a shame because these weren't cheap and um yeah anyway so I've got those in fact I'm just going to pop them all with that now as well I'll do that in a moment so that's what I picked up from craft stash and then I scored again in the charity shop so the same one that me and mum always go in she's picked up some more like embellishment kind of things impacts and things like that but I've grabbed these so I've got two of these crafters companion and these are the foil love the colors electric blue and royal blue so yeah two meter rolls and I have some of these I have some of the um what do they call them the foil transfers but you can also use them with your double sided tape you can use them with your tacky glues you can get really nice effects 50p each I haven't looked online to see how much these are but I know they will be a lot more than 50p so that was a bargain and then I've got all these bits now I use a lot of texture pastes and sprays and things like that when I do my scrapbook layouts so you don't tend to really see me use these things in my normal tutorials apart from maybe on a Sunday now I'm back to sharing my scrapbook layouts again and that's when I use these kind of things however this one here I'm a bit interested with some of you might already have it but I've picked up this one here which is which was 75p it's my imagination crafts it's a great company and it is well it's wax it's just a um it's like a gilding wax I've got some gilding waxes but mine are very small kind of little it's like long kind of like trays so this one is much much bigger I've got one like this in like a pinky color but when I saw that it was gold I just thought that's going to be great and it's perfect for distressing and adding just a little bit of shine to like the ends of like the petals on a flower or on the leaves and things like that especially when you've embossed them these are all brand new every single one of these has never been used and if I just take that off there it's just a really rich gold paste and it is it's perfect for just adding if I just find a little die cut now I've got one of these poppies I've got a box full of like bits that I have left over from projects but this is a poppy that I had and let me just take the lid off that and I'll use just a little bit there this looks like it's going to be very very strong I'm going to do it on the back just because I don't know how well you know this spreads but look so you just and it will show up all the grain look at that lovely detail that you get they are honestly gilding waxes are just so nice and I love using them I I edge like the edges I edge the edges I go around the edges of my scrapbook layouts with my gilding waxes and some you just sometimes you just have to do just such a you know a small amount just to kind of just highlight like the edges but if you've already distressed your cardstock and you've got all those kind of like creases in them you see how it picks it all up so just look how that's changed that cardstock just such a small amount and they go a long way which is why if you ever see little things like this don't think well there's nothing in you know there's hardly anything in there for the price they last you for ever even the very very small let me grab it these here I've had these for ages and you can see the one that I go to a lot but there's still loads in there because you know a small amount goes a long way but these are what I've got so it's nice to have you know and that's actually you can see in terms of what I've already got this is a real more yellowy gold these are quite browner more earthy gold so yeah that's going to be a nice addition so I'm just going to pop that one back on there I've got lovely gold fingertips there but that will just wash off so then I picked up this one here so this was a pound this is again by imagination crafts and this is a they call it a relief paste but when I read what you do with it just to me just seems like another paste to use with your stencils and to create dimension it says here it's a water-based matte acrylic paste ideal for creating dimensional effects on all hard surfaces can be used with a stencil or freehand and works best when applied with a spatula well I love doing my stenciling on my scrapbook layouts and this colour is actually really nice especially because I like to do my vintage kind of backgrounds it's a really nice say oh yeah it says it say each there on the side again never been used so I'm just going to take this off and there's there's absolute numbers in there that's going to last such a long time but yeah again you will see these things pop up in my scrapbook layout videos so yeah really like that one and then I've got these so these are by a company that is based in Poland so it says made in Poland there and it's called 13 arts so this is chalk woodbine this is pastel cobalt and this is pastel lime love that lime colour I've given them a shake they need to be I think they've been probably sat down for a long long time again they don't really look like they've been used because they are full but they're just your sprays so again I love using these on my scrapbooks creates really nice backgrounds you get great effects and also one like shadow boxes and things like that but I love that lime colour and you can also spray it on your flowers so if you've died cut any of your 3d flowers and things like that it will look really nice so those three were a pound and then I got these here so this is something I've never seen before it's by pin flare they were a pound each so I thought I'd get both they're both in black yeah black stamping paste and basically it's it's it's ink in a paste form and you use a from what I was reading these were both unopened but I had a look at this earlier it's a very thick paste but it's it's heavily you know doused in ink and basically it said that you use a sponge and you dab it onto the sponge you you load up the sponge so it's all evenly distributed onto the sponge and then you use the sponge and ink up your stamp and then you stamp with it and it will create dimension it says it takes up to five minutes to dry but it will mean your sentiments and things like that will have dimension and I'm thinking for I guess more when I go into like autumnal projects and Halloween and maybe some Christmas things as well but when I tend to use more darker colours I think this is going to look quite good I don't know how well it works with heavily detailed stamps so it was just something a bit different and when it's that price you don't mind getting it and trying it and then if I don't like it I'll pass it on to one of my crafty friends and then there was this one here I don't know whether it's really old or again I'm not sure yeah 2013 so it's not massively you know it's not too old but I guess in crafting stuff you know develops so quickly with you know it's probably maybe not that good anymore I don't know but it's by colour box surface surface surface surface is oh you meant to pronounce the Z on the end anyway it's a multi-surface ink so to me this sounds like a stazon and you know it's got that same kind of plastic on the top that stazon has and it says here it's in black and on the top it just says for multi-surface plastic metal glossy cardstock and more always test materials first fast drying permanent ink that's exactly what stazon says let me just um yeah it doesn't smell like stazon stazon's got that distinctive smell but um yeah again I use black inks all the time and if this means it will stamp well onto my acetate window sheets and stuff like that then it's always good to have another one and again for 50p you don't mind so I thought that was quite a good stash you know to find at the charity shop and then lastly I went on to every crafts a pound so maybe every three months or so me and mum will go in together because then we can you know the postage isn't so bad because the postage can be quite I think it's quite high for them um so I try to wait you know quite some time and then have a little bit of a splurge because it's very very cheap although saying that well when I first started shopping with every crafts a pound every craft was a pound now they still have lots of stuff that's a pound and lots of stuff that's even you know like 25p but they have a lot more stuff that's over a pound so um you know if you first have gone on there and you think well it's not really a pound do have a look because they do have you know you've got to kind of search for some things but um yeah so I picked up these and I've got another little bit there to show you as well so I got some of the fine applicator bottles here and I've already filled this up so I wanted to see if it's going to work with the kalal glue and it does it works absolutely perfectly so I was really really chuffed so I've just filled this one up here also I think this was two pound two might be two ninety nine for the three but just for these nibs alone is I think worth it especially to have the stainless steel pins because they can be quite you know some companies are selling these for quite a lot of money for what they are but you can see now you've got even thinner distribution of that kalal which is brilliant so yeah I'd like it if the bottles were a bit bigger but that's just me being picky because of what I I'm a heavy user of it but they've got there you can see I don't know whether it looks like it's exactly the same size so it would be a good replacement for that but it might even go on the end of this one because this is a bigger bottle and I've got the kalal in this so I'm wondering whether one of these ends here because I just find because I use it a lot I'm having to fill this one up a lot you'll probably hear me in my videos sometimes where I'm having to fill it up but I wonder whether because I know some of you this is an old tonic studios kind of like white pva blue bottle and I just cleaned it out completely and I've still got some kalal in there felt quite light let's see if it works on this one as well let's just fold that one over because the thinner you can get the kalal out the even quicker it dries because obviously you know if it's very thick it just does take a while but let's just oh yeah no it's working oh I'm so happy I'm such a happy girl so now I can fill that right up and go back to using that one again because that one doesn't run down as quickly as these are so I'll just probably empty those two into there but it's always these are great for traveling as well you know if you are on the go and you go over your friends you can just fill up one of these you know it's yeah perfect so that one can now go in there so I've got that one with that pin in I've got a little one there with the pin in and I've even got still got a little bit left of the dorm baby one and I lost the pins for that I was really annoyed with myself but I'm also wondering whether I can pop a pin in here because this clogs up a lot which annoys me because it's a lovely glue I really do like it as well and I've got the the bigger one here so um I wonder again let's have a little look screw them and then pop the pin in yeah it's going in let's have a little look again and these aren't just from every class of powders by woodware so you can probably get them they might even have them on craft stash yeah it works look at that oh I'm really happy isn't it funny these little things that just but it just makes life so much easier so now I have my favorite kind of I guess white glue my favorite all-purpose clear blue is clear blue clear glue is in here and then also the art glitter glue but I find those two identical so I guess for us in the UK this is you know the one to go for because I think this one has to be shipped from America and it has to be shipped during certain times of the year because of the temperature and all that kind of stuff so that's what I've heard anyway but no I'm really pleased with that so yeah if you were wondering whether these kind of you know tips would fit on other bottles yes they do especially that one that's good and then that was a tonic one and um I'm sure there's lots of others as well that you would be able to you know play around with so that was those so I'm actually really pleased with that I don't need that lid anymore it's just pop all that over there because I need to rearrange and sort all my glues out now and then I just all these things are a mix of 50p 25p and a pound so I picked up the maker wish and I also got these because I brought the 12 by 12 a while back and I've got the cake wooden toppers and now I've got the sundae wooden toppers and then all the puffy stickers I love you I mean I'm on the design team for Trimcraft and I've enjoyed their product for many many years so I but I missed getting this one when it was in the shops so when I saw it you know start popping up on some of the discount stores and things like that I brought it and now I'm you know using it and you've seen it feature but I just love all these things they just finish everything off and yeah I've got those toppers so again these were very inexpensive no more than a pound these here I always use little bows they're just very handy to have and to kind of do this size yourself even if you've got a bow maker it can just be quite fiddly so when you've got simply creative always do them dovecraft here as well there's just a variety of colors pastels which are going to go great with like the paper posies at the moment and then the brights I love those colors you know the shocking pink they're in the cobalt blue so and then these ones here as well so picked up those these I just think are really really cute they're part of the folklore collection again I didn't it wasn't one that I was really drawn to I'm going to be completely honest I you know I don't like everything out there although it looks like I do get a lot of things I you know there's a lot that I don't go for I don't know what it was there was something about it but I did love these I thought they were gorgeous so I picked those up and yeah I'd find somewhere for them I think they're going to be nice for some more feminine Christmas cards you can you know certainly make her look Christmassy but I just thought they were really sweet then I picked up these I go through card bases so much so these are the berry blush back to basics six by six and in here so you've got your envelopes but you get yeah that I guess that's the berry color actually that's like a lavender purple and then you've got that kind of peachy kind of color but they're nice again for when I do my commission work magazine work things like that is these things that I go to a lot so that's those and then some of you might laugh but I had these for the Christmas just gone and I used so many of them and they're just something that never dates you know they're going to be used year after year but I used them all and they were back on there for 50p each they may have even been 25p so I've just stocked up so this will go straight into my Christmas tub but it's great for when you're doing bulk kind of crafting and they're great for putting on gift tags and gift boxes and things like that but I got the gold and the silver happy Christmas and merry Christmas and I just yeah I really really like those so I picked them up and then I also got these which were the advent Christmas chunky stickers so you've got the silver and the gold I will be doing an advent calendar I know I've got my one that is for me forever but I have been asked to make advent calendars for other people this year so these are going to come in very handy for those and then I picked up some more of these I do have a few left I've got about half left on the other one and they're your Christmas chunky stickers and these are Christmas hats but they are great to add on to all kinds of things even a stamped image of a you know a little critter you could put a little Christmas hat on him so I just thought I'll get them so those will just go straight away into my Christmas kind of box now and be forgotten about then I also picked up some of their MDS they have a lot of MDF on there and these are the coasters and you've got four for four for a pound 450p it was really good so I have obviously plenty now because again I do start kind of making Christmas gifts early because you make them so it does take a little bit longer these smell amazing I love the smell of cut wood really really like it it's just like a a bonfire oh I just love it it's like I hate the smell of petrol but some people absolutely love that but it just makes me feel actually quite sick but this oh I just love it and as soon as I open the box I was hit with this smell so I'm also doing my resin art I'm really getting into the resin art and I've been making some really nice gifts I'll be doing normal coasters with them but I'm also going to be doing some Christmas decorations with them and some resin art with them as well so I've got a few ideas and I just thought for the price you know there's plenty there you know to give out as gifts for people so that was those and then I did get some paper pads so printed blooms I had the 12 by 12 of this and I used every single sheet on the mini album that I made for my mum for her 60th birthday I never shared that one on the channel I kept that one just for private just for us and the family but I used the printed blooms for it and it was beautiful felt for the price I will get that one then I also got beach life it's just a big big favourite of mine I brought another I've finished one of the 12 by 12s and I brought another 12 by 12 and I've already been using that a lot and it's actually been used on Easter this year so you're going to see quite a few Easter projects using not the buckets and spades and that but these the polka dots the stripes the other polka dots there the bunting the green kind of decking they're really nice bright I think happy Easter colours as well so that's nearly gone so I thought actually I'm gonna grab this one it's so nice I do have some of the embellishments I've got the little wooden beach huts so it's something I can start using again in my summer crafting it's just a really lovely collection as is this one sweet moments I've already gone through the 12 by 12 and the 8 by 8 so I've got this one again and again I love all these there's a little bit of a daisy may feel for me with some of her papers with in terms of the background ones you've got your gingham print you've got these stripes they're just really nice and they've done an amazing top a pad for this collection I did share it all when I got that one months and months back but yeah so I thought I grabbed that and then I got this one so this is Hey Baby again I do get a lot of my friends and just people asking me to do you know some baby related projects so I've picked up this one here and it's absolutely gorgeous it's the Deku Page Pack which I love and I just think they're really really fun they just love the Hey Baby star there just right at the back let me just open it up just so I can give you a better look there and the colours are really nice as well it's not you know completely unisex you know you can use this for the girl and the boy whereas sometimes you get a lot that are just for you know baby girl baby boy but look at that it's not lovely with a hot air balloon so you get three of each this one here really really nice quick cards with these you've got balloons again you can actually use that for a birthday card the flowers that doesn't just screen baby to me you could use that for anything you've got the rocking horse the bear the elephants really like that one but my favourite is that look at that isn't it gorgeous love the star the bunting hey baby I think that is a really really nice very modern and just that little bit different so yeah looking forward to using those then I grabbed these and again I go through paper I use it I am not one of these I don't hoard this stuff I use it so that's why when I can get it very cheap then it's even better for me because the background pieces like this it doesn't matter you know whether this was last year you know or five years ago you're going to see pink backgrounds in loads of paper pads so this was I thought just a really really nice one again I kind of missed this one I must have been really involved with another collection at the time but they're all double-sided it's festive edition so you know you're getting really really nice quality and again let me just take off stickers on the side I know why they've got to do them but I hate them I'm not going to go through every one but just you can see you get you can see where your double-sided ones start so halfway through the pad you get your double-sided but they're perfect background absolutely perfect love them bright colours right up my street I'll be pulling this one out a lot and then you go into your textures it's all glitter on the stars on the stripes and then you've got that print that's like a shiny and you've got the pink there that'd be good for a handbag that looks like almost looks a bit like snake skin it's cool I like that one love that one and then that one there I think that's like spot UV love this one the foiling look so that's the pick and mix really really good and then I got the back to basics so it's the same collection as the six by six envelopes and the bows as well okay so all matches together but this is just again it's more for when I make envelopes as well these because this is paper so this is where are we yeah 150 gsm perfect for making envelopes where you do need to make those bigger custom envelopes these paper pads the dovecraft ones are brilliant for that it's really nice prints I'm not going to take this all out the packaging with a little bit of glare let me just let go you can see what you get there but it's just all those purple tones really so yeah I've got that one as well okay so that's everything so I just need to get that all stored away get these things kind of I need this at hand's reach and sort my glues out and bits and pieces like that I can link pretty much everything apart from the charity shop stuff although saying that it is branded things so if it is something that you're interested in I'm sure I could find pin flare so I'll link what I can I need to sort my glues out and I will link to every cross a pound but they sell out extremely quick so what I would say for anybody that's never shopped and they are only available in the UK I don't believe they've got international shipping but just register because you get an email sent so they are really good so whenever I see an every cross a pound email sent to me you know that they they're usually they've just had a kind of a new delivery of stock or they have just updated their clearance section or something like that so it's worth checking it out and yeah that's it for now I need to go dig out my Christmas box as well and put some stuff away in there so as always thank you for watching and I'll be back very soon with another tutorial bye


Hello, everyone. Welcome to Options 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. The focus of my presentation and the focus of the Options-Doug chat channel in 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 the directional bias. Questions and comments are welcome, and I won't be watching the chat, Options-Doug chat in Discord and the chat in YouTube for your questions and comments. My agenda for today, I'm going to go over, briefly go over news items, economic data that came out this morning, and then I'll go through my positional analysis, my planning and preparation, and then I'll review a few setups from this morning, and then we'll take a look at the live market. All right, let's get started. So this morning, the only data released was the jobless claims, which typically is not much of an event, but it turned out to be somewhat of an event for the NASDAQ. Let's just take a look at that. So jobless claims at 8.30 a.m. Eastern time, let me zoom in, and the jobless claims were higher than expected, and NASDAQ traders apparently interpreted that data as bullish. So quite a reaction from the jobless claims in the NASDAQ. All right, so that was the data this morning. Again, it's been a pretty light week for economic data and news. All right, I'll go through my positional analysis now. I'm going to start with the S&B 500, and before I take a closer look at this chart, I'm going to take a look at a larger time frame. This is SPX in a 30-day one-hour chart. Let me point out the levels that I'm showing on this chart. First of all, the lower and upper edge of the expected move for the week. This is based on the options market. That's the dash purple lines. The dash blue lines are showing the lower and upper edge of the expected move for the day. And note that SPX is created right up to that level, and now appears to be finding resistance at that level. And let me point out some spot gamma levels here. So these levels are provided to spot gamma subscribers for a variety of platforms. They're shown by the red horizontal lines. The first is the put wall at 4,000. That's the strike with the largest net negative gamma that can be expected to act as support. And the volatility trigger is at 4245. And that is spot gamma's proprietary gamma flip level. Below that level, market makers position on the gamma curve is negative. In a negative gamma environment, market makers have to trade with price to hedge their delta exposure, and that tends to enhance or increase volatility. Then on the other hand, like SPX is trading now above that level, market makers position on the gamma curve is positive. In a positive gamma environment, they have to trade against price to hedge their delta exposure, and that tends to subdue volatility. And note that level did increase pretty substantially from yesterday. Yesterday, the SPX volatility trigger was at 4195. And again, today it's at 4245. And the next level of interest is the 4300.  And the call wall is the strike with the largest net positive gamma. And that can be expected to act as resistance. And note that SPX has been trading in this 4250 to 4300 range since last Friday. There's this range right here. And finding resistance at the 4300 level a couple of times. All right, so those are the levels, the primary daily levels. The put wall volatility trigger, absolute gamma strike, and call wall for the S&P 500 SPX. And now let's take a look at a shorter time frame to get an idea of the levels that are in play for today. And I'm showing the same levels on this chart, just a zoomed in view. Here's the volatility trigger and the lower daily expected move, the upper daily expected move, and then the call wall and absolute gamma strike. So the upper daily expected move is acting as resistance so far today. And the next level up above is obviously the 4300 call wall absolute gamma strike. All right, let's take a look at book map now. And in book map I have two columns of notes here. First the SPOT gamma cloud notes, then I have my own column of notes here. And I include everything that's included and the SPOT gamma cloud notes plus some additional information. First of all, here's the upper daily expected move for ES. And note that that acted as resistance, I think, almost to the tick. So I had 4298 as the upper daily expected move. And then I also have SPI levels here. There's the 429, the SPI 428, large gamma one level. And this has been a somewhat of a magnet for price for about an hour between 11 a.m. and noon Eastern time. Here's the SPI 427 volatility trigger. And that did act as support this morning and kind of a launching pad for continuation of the move higher up to the upper daily expected move. And then finally, the SPI 426 level. That is not a gamma level, but it did act as support. So those are the levels that are in play for the SAP 500. And we'll take a look at setups in a few minutes. I'll review the setups from this morning. All right, let's take a look at the NASDAQ now. Oh, shifts in levels. Again, I mentioned the SPX volatility trigger did shift higher by about 50 points from 4195 to 4245. And then the SPI put wall shifted lower slightly from 427 to 425. So SPI put wall again at 425 joins the absolute gamma strike at 425. Excuse me. All right, so that is the SAP 500 SPX SPI key levels. Now let's take a look at NASDAQ. And for NASDAQ, the levels are in play. Again, there's the sharp move up after the jobless claims. And then after the market opened, this is the QQQ 349 level. And that is the volatility trigger. And that did shift lower from yesterday. It was 354 yesterday, shifted down to 349. And around that level did act as support this morning. And also launching pad for the move higher. And then here's the QQQ 350 level. And that is also the lower daily, lower weekly expected move for NQ. So NQ has recovered its lower weekly expected move. And that is, again, the QQQ 350 strike, which is the absolute gamma strike that did move down lower from 355 yesterday to 350 today. That's the strike right here. And note that NQ did trade above its upper daily expected move, just the opposite of yesterday, where it traded below the lower daily expected move. And now it has dropped down below that level again. All right, so that is the NASDAQ. These levels are the QQQ 349, 350 levels, and also the upper daily expected move. And again, we'll talk about setups in a few minutes. All right, we talked about shifts in levels for QQQ, both negative with the volatility trigger dropping lower and the absolute gamma strike dropping lower. And then for NDX, several levels drop lower. The volatility trigger, call wall and absolute gamma strike all drop lower. So somewhat of a bearish shift in levels for the NASDAQ, but the, I guess kind of as to be expected, with such a sharp move down yesterday that shifts in levels are to be expected, but the dip buyers were certainly at play this morning, which is also to be expected with such a large move down and many large cap tech stocks. Traders see that as a buying opportunity. So dip buyers were in the market today. All right, so that's the NASDAQ. Just take a look also at the levels here on a QQQ chart, just to isolate QQQ price and levels. So again, here's the volatility trigger at 349 acted as support this morning and then the 350 absolute gamma strike and the call wall is still well up above at 360. All right, the next thing I want to take a look at is the Vana model. And if anybody wants to see the source of those levels, the absolute gamma levels that are a source for those levels, I'll be glad to show that otherwise we'll just move on to the Vana model. All right, so this is for SPX and we'll look at spy and QQQ also. And I think this is very important to look at it. It shows how market makers are positioned and how they can be expected to react as price and implied volatility changes. So this chart is showing market makers delta notional or delta exposure in the vertical axis and how it changes with price on the horizontal axis. There are two curves on this chart. The first, this light gray curve shows how market makers delta notional will change with changes in price only. So what this is showing as price increases, market makers delta notional will increase. And remember they want to remain delta neutral. So they will have to sell futures to hedge their delta exposure. And what the purple curve is showing, it adds implied volatility to the equation. So it's showing how market makers delta notional will change with changes in price and implied volatility. And that's the one that we want to look at. And that change in delta with the change in applied volatility is the Vana effect. So this is showing as price increases, market makers will have slightly less delta notional to hedge, not much as price increases as predicted by the delta only curve. On the other hand, as price decreases, they will have substantially more delta notional to hedge as price decreases and implied volatility increases, and they will have to sell futures to hedge their delta exposure. Let's take a look and see where SPX is trading now. Give me just a moment and bring up a watch list. So I've got SPX at around 4280. So somewhere around here, hard to get the exact point. So this is really at the bottom of this Vana model curve. So there's not, with slight movements, there's not much of a tailwind or a headwind. But as price increases, this is showing that market makers delta notional again will increase and they'll have to sell futures. And then the same as price decreases. So much movement either way, and market makers will have to start selling futures to hedge their delta exposure for SPX. Let's take a look at SPI also. So just to note, we'll take a look at the data in just a minute, but market makers position on the gamma curve for SPX is positive. Gamma notional is positive for SPX. Let's go back and take a look at SPI. And note the shape of the curve is different for SPI. SPI gamma notional is slightly negative, or it was at the beginning of the day. And let's see where SPI is trading at around 428. So there's 428. And remember SPI moved up from 426 this morning. So there was a slight Vanna tailwind. Note the drop this morning, indicating that market makers could buy back short futures as price increased and implied volatility decreases. But that tailwind really has leveled off now and around 430, shown right here, that will become a headwind. And then on the other hand, if price drops lower and implied volatility increases, market makers will have to sell futures to hedge their delta exposure. And then finally, let's take a look at QQQ. So gamma notional for SPX is positive, was at the beginning of the day and for SPI, slightly negative. We'll take a look at those numbers in just a minute. And then for QQQ, it was even more negative. That's really due to the sharp drop yesterday where gamma notional shifted from positive to negative for QQQ. So right now QQQ is trading at around 351, right about here. So give me just a moment. Remember this morning, the volatility trigger 349 was support for QQQ. So that is shown right here, where I'm holding my cursor now. So that's 349. So remember, QQQ in a negative gamma environment as price increases, implied volatility drops, market makers can buy back short futures. And that was a tailwind for price today helping to boost that price higher. So that's why I think it's important to look at this every day to understand how market makers are expected to react and support or resist price. And in the case for QQQ, they were definitely boosting price, but now that boost has ended QQQ again trading between 351 and 352. All right, let's take a look at the data. And as I mentioned, gamma notional for SPX was positive. So here's SPX, SPI, NDX, and QQQ. So for SPX, quite positive, 824 million. Slightly negative for SPI and then negative for QQQ. All right, so that is my positional analysis for the day. And based on this, I was really, for the S&P 500, looking for more of a range day based on the large gamma notional, positive gamma notional for the S&P 500 and looking for more movement one way or another for the NASDAQ. All right, let's take a look at some setups now. I'm going to start with the S&P 500. And this is the spot gamma hero chart, hedging impact real-time options. What this chart is showing is price with the white line and that is an SPX price. And then market maker hedging flow, hedging pressure. So this is showing options trades and how market makers are reacting hedging. And this is a combined signal for SPX, SPI, XSP, and ES futures. All into one combined signal. This is typically what you want to use when you're trading the S&P 500. And I'll zoom into this chart in just a moment. I do want to take a look at the individual components. So let's start with SPX. And we'll note here this notional value is positive. 861 now, 830 million SPX. Positive, very strong correlation between options trades in SPX and price action for the S&P 500. SPI not as much, but still positive. And then ES futures have, options trades in ES futures have dropped pretty sharply in the last around 115, something like that. And then again, here's the total signal. So let's zoom in on this. And I'm going to review the setup for the morning. Obviously long and this is about from the cash open here. So this is showing there was a bit of a lag, which is a little bit unusual for options trades. Note that price starts moving higher first and options traders come in a few minutes later when you look at the total signal. Let's take a look at separate outputs and calls. And this makes it a little bit more clear. Traders were buying calls and buying puts. And the call buyers were winning, are winning. So note the positive number here for the orange line showing call buyers and the negative number for the put line, the blue line, 1.4 billion positive versus minus 826 million negative. So that gives a little bit more insight as to the reversal this morning. But again, a little bit total signal, a little bit of a lagging indicator. Let's go take a look at the... So this is the current price. All right, so that is the SAP 500. Let's take a look at book map now. Go to the ES. I'm going to zoom in on just on the morning here and remember options traders came in a little bit later. So this was not necessarily an easy read. This first reversal, kind of a double bottom at the 426 level and it really became more apparent that price was going to increase after 10 a.m. in a move above VWAP, also with this larger trader supporting the move higher with iceberg orders. Iceberg orders are what larger traders use to hide their size. And then there were, of course, secondary entries at this SPY 427 volatility trigger, multiple tests of that level, tests of that level before price moves higher. Eventually, as we saw on the entire chart, the upper daily expected move. And note that starting around 10.15, the cumulative volume delta really started to shift higher as well as buy stop orders, shown with the yellow line there, started to fuel the move higher. So the pink to dark blue line is cumulative volume delta and the yellow line is stop orders, buy stop orders, starting or helping to fuel the move higher. Also shown by these green dots here. All right, so that is the long setup this morning in the S&P 500. We'll go back to the bigger view. So the first really easier read entry for me was as this order flow shifts to clearly bullish, a lot of market buy orders coming in and then entry at above VWAP or with this multiple test of the 427 level and then also at this 4280 level that was noted as support in the SPOT Gamma AM Founders Note. All right, let me check for questions. All right, so take profit ask, hi Doug, as always thanks for sharing all your knowledge with the community. You're welcome. My question, what is your trigger to take a trade after analyzing all the data and levels? First of all, I look at the general trend of hero. That does not provide a signal or a trigger. I'm looking for, once I know, let's say hero is trending higher, I know that options traders are taking positive delta positions and market makers taking positive delta positions. Market makers are buying futures to hedge their delta exposures. So I know I have that going for me and then I'm looking for reactions at key levels, especially for the S&P 500 watching, let's go. So I'm just watching order flow at key levels. So for me, trading the S&P 500 takes a lot of patience. So I've got these levels on my chart and I sometimes get kicked when I don't do this. So it's very important, for example, to wait for price to come to you, come to your level. So this is something that I'm working on as well. But for example, right here again, I'm looking for price, looking for long set up at the 427 level. So I know that order flow is bullish and I'm just waiting for pullbacks. And so there's the pullback to this 427 level that provided multiple long entries. This last test, really the third kind of major test was the one that took price higher. Let me just point out one other thing on this chart and let's, I'm going to zoom in. Let's say from about 11.15 to 1 o'clock. What I want to point out is this, let me darken this up just a little bit. This is something that Bruce looks at. So Bruce is the director of education at Bookmap. He is an order flow expert. He watches ES every day. He does a webinar at 10 a.m. eastern time on Monday, Tuesday, and Friday watching the ES live. This is the kind of thing that he looks at. So notice the liquidity here at this 429 level that acted as resistance. If we draw a line from that level over here, so this level acted as resistance. Price broke above. So this is the kind of thing that he looks at and it provided a great entry right here. So it acted as resistance. Price came back and checked that level and note there was a little bit of liquidity that came in and again a good entry for a long right there at that 429 level. So there's another pullback to a known level, not a spy level but a liquidity level and where traders reacted before. All right, so that is the S&P 500 set up this morning. Let's take a look at NASDAQ. I'm going to go to the hero for NASDAQ. So just like the S&P 500, this is a combined signal for NDX and QQQ. Very strong correlation between options, trades, hedging flow and price action in the NASDAQ. Let's zoom in on this. And for NASDAQ, I'm going to zoom in a little bit more and it took a while, just like the SPX, took a little while for the confirmation in the options trades hero signal for NASDAQ, just around 9.55, 10 a.m. Price moves higher, options trades get on board, option traders get on board. Let's separate outputs and calls. So it took a while for call buyers to join the party as well. All right, let's go take a look at book map. I'm going to zoom in. All right, so pretty similar to book map. I'm looking at order flow here and reactions at levels. So just at the open, I know 349, QQQ349 is key level that acted as support. And then also for NQ, the large round numbers. This is 350, 14, 350, acted as support. I'm watching these shifts in order flow. Note the pink dots, aggressive sellers on the way down, and then aggressive buyers come in, shown by the green volume dots. I can see that larger traders are buying with iceberg orders, cumulative volume delta rising, and buy-stop orders helping to fuel the move higher. And also, I'm watching tech stocks as well, and I could see that there were dip buyers coming in, and we'll take a look at that in just a minute. So there's the setup in NASDAQ this morning. Really confirm more by order flow and options trades somewhat secondary, but the levels, the QQQ levels were key, just like the spy levels were key for ES. All right, let's take a look at a couple stocks, and then we'll go take a look at the live market. So the first stock that I want to take a look at is Amazon. And I'm just picking a few examples this morning from this morning. So there's Amazon. And note that 125 is the call wall, and that was the target for this move up this morning. 125, the call wall. Let's take a look at Hero. See what options traders were doing. So here's Amazon, and it took a while for options traders to get going in Amazon as well. This confirmed the move higher to the 125 call wall, and that's also the key gamma strike. The next is Meta, and that was really the best setup of the day. Very strong price action, strong correlation with options trades, and hedging activity and price action. Zoom in on the morning. So note the 260 level, key gamma strike, and then the put wall at 262. Let's just separate outputs and calls and see what traders were doing. So they're buying calls, and that is really driving price action higher. That's shown by the rising orange line. Note the notional value here, positive 35 million versus minus 1 million. So they are buying calls and buying puts. They were this morning, but call buyers are winning. Let's go take a look at book map. So remember 260 was the key gamma strike, 262 the put wall. So price was trading below the put wall at the open, now trading higher. So great long setup in Meta, helping to drive the NASDAQ higher. Let me just check and see where the call wall is for Meta. So for Meta the call wall is at 275, back to book map. So Meta has some room to run, the call wall at 275. And the last one was NVIDIA. Really sharp move higher this morning for the first two and a half hours. Let's take a look at HERO. So here's HERO, and we'll see that call buyers are driving price higher. Very steady uptrend of call buyers until about 1230. Then they stop buying calls and price starts to move a little bit lower. So there's hardly any activity in puts. Calls almost 247 million versus puts minus 4 million. So a call buyer is definitely driving price higher. In a stock when traders buy calls, market makers sell the calls and they have to buy stock to hedge their delta exposure. And that can really help to drive a price higher. So if you're looking for a setup in a stock, this is definitely what you want to look for, is steady call buying, driving that price higher and higher. As market makers have to continue to buy stock. All right, so those are the stocks that I wanted to highlight. If anybody else, if anybody has any other stocks that you want me to take a look at, let me know. Otherwise we'll go to the live market. So we'll see what options traders are doing now. I'm going to go to a, notice how, so we've zoomed in for the last couple of hours here and we're on a one day look back period. So this is a cumulative value for the entire day. Let's just see if there's any additional insight from looking at a shorter rolling window period and there definitely is. So here we can actually see a little bit of a lead effect in hero. Hero moving up around 140 and price starts to move higher about 10 minutes later and now continues higher. Let's go take a look at book map. Yes. And note that hero started to move higher about 140 and SAP 500 reverses higher just a few minutes later at this 4280 level. So there's your entry point. Options traders taking positive delta positions. Market makers start buying futures and price reverses at a key level that you expect to act as support. That's this 4280 level. And then also note the multiple test of the spy 428 level and now price is moving higher back up toward 429 and the upper daily expected move. So if you were patiently waiting for a long setup, here's your first entry point at the 4280 level SPX 4280 in another entry point at 428 spy 428. So take profit. This is what I'm looking for pullbacks to these key levels with some sort of indication of price moving higher order flow and or hedging flow. Right. So nothing to do here in the SAP 500. We obviously were late for these entries. Let's go take a look at NASDAQ now. So NASDAQ moving higher as well again above the upper daily expected move above the QQQ 352 level and the NQ 450 level. Let's see what options traders are doing and again providing a good indication of the move higher. And this is the 30 minute rolling window period. So we're only looking at the last 30 minutes of data and the last entry point was about 211. Let's go take a look at book map. So right about here looks like low point of 36.25. Notice price gets going. Cumulative volume delta increases. Cumulative volume delta increases. And buy stop orders shown with the rising yellow line help the field to move higher. Let's see where price could be going. Let's see what options traders are doing. Looks like a potential pullback. And I usually mention this but I have multiple screens. I'm only presenting on once so I have to jump back and forth between this hero chart and book map. When I'm actually trading I'm looking at both on different screens at the same time. So I don't have to jump back and forth like I'm doing in this presentation. The overall trend of hero is higher. It looks like it is ticking higher now. So the way I think the way Bruce looks at things is this was somewhat of a level of interest there. Acted as resistance and now a support. We know that hedging flow is moving higher again. Water flow continues higher. Note the shift in volume dots. Pink to green. Maybe coming back to retest that level. Maybe breaking lower now. Let's see what options traders are doing. Leveling off a bit. And we may need to need a deeper pullback. If we looking for a long maybe to the 352 level. And prices trading above the upper daily expected move. Just from a probability point of view you would look for price to move lower. Let's take a look at the S&P 500. Larger traders are selling with iceberg orders but cumulative volume delta and stop orders. And order flow all look bullish to me. And again the last good entry was at 428. Let's go take a look at hero for the S&P 500. Overall twin trend somewhat negative now. Again we're on a 30 minute rolling window period. So for NASDAQ it just took a little bit deeper pullback. Alright before I wrap it up. Does anybody have anything that they want me to take a look at? Go back to the ES. Stick with the NASDAQ. Take a look at a stock. I've got just a couple of minutes left. And uncle asked do you have a hero for any of the Chinese tech names. Yeah we'll check. I don't follow any of those. Let's go to Tesla. Take a quick look at Tesla. Overall very bullish day. Bullish order flow. Alright let's go take a look at hero. I'm going to go back to the one day look back period. So first of all let's go to Tesla. So there's Tesla. Traders buying calls and selling puts. But definitely call buyers more aggressive. Alright there was a request for Chinese tech stocks. Let's see what is in the overall list of stocks. So I'm looking at my watch list here. And let's go to the entire list of stocks. So here's Baba. So there you go. Uncle there's Baba. Traders were buying calls in the morning helping to drive price higher. And the last GameStop. Here it is. So I believe GameStop reported earnings yesterday or had some announcement. And options trades hedging flow were definitely bearish in the morning. So in the morning traders were buying puts and selling calls. And then when they started buying calls price turned around. This rising orange line and price started to move higher. So there's GameStop. Alright the S&P 500 continues higher. Oh Abu says GameStop new CEO. That's right. So I guess the old CEO is out immediately in the new CEO for GameStop. And Google plus Allen 13 you're welcome. And thanks for the update Abu. Let's just wrap it up here. So today really appears to be driven by debt buyers in large cap tech stocks. And that is shown here in this heat map for the S&P 500. Yesterday they were weak and the Russell 2000 was strong. And just the opposite today. So debt buyers come in large cap tech stocks. The usual suspects magnificent 7 driving price higher today. And good reads in order flow and hedging flow today for the NASDAQ S&P 500. Oh there's no new CEO yet. Ryan is the executive chairman. Okay thank you. Yeah I just don't follow GameStop. I mainly follow the NASDAQ S&P 500 and large cap tech stocks. So thanks for the update. Hope that helped. I want to thank everyone for watching. Thanks for your questions and comments. And I will see you tomorrow. Thanks again. Bye.


Hello, welcome to SSUnited, so see this side and this is continuation of SQL Server Performance Training. So today we are going to discuss about merge joins, which is also part of physical join. If you haven't watched last video of this video series, so I would strongly recommend to watch that video where you can understand about the physical joins and nested loop joins. So let's start with merge join. So what is merge join? And what is the condition to use the merge join in the physical joins? So it needs both the input should be sorted on the joining key or it should have the cluster index on that column. So this is the first condition. Second condition, it requires at least one equal join. Like in our on clause, we should have used at least one equals to condition. Which is both tables should be contained the last data. So if we have only one table has last data and second table has small data then that would be going to perform as nested loop join as we have discussed in the last video. So here both tables should have proper index on that joining column or sorted in the physical order. So how join will work go to on excel to understand about the logic then we will see in practical. So as we can see we have the first table and here we have the second table. So again it will going to compare one by one. So as we can see it has one and here we have one. If any duplicate values will be there then that value will be complete and create a work table and that duplicate value will be there. Then joining condition will be applicable not from the second table. It will be going to perform internally by the work table. So as we can see one, so one going to match with one. So in output it will be going to return as one. Then again one will be going to match with the one. So it will be going to return as one. Now here we have one and now here we don't have any duplicate values. So this work table will be dropped and moved over actual table. Not this time pointer will be going to point this two and it will be going to again move to two. Now we have two and two. So here we don't have any duplicate values. So two will be compared with two and in output it will be going to return as two. Now it's fine. Now pointer will move to three. So here we have pointer in three but in second table we have duplicate three. So that three will be copied in the work table. And now lookup will be performed with the work table instead of second table. So three is available over here and three will match with first three. Then pointer will move to second three. So it will be going to match. So it will return as three. Now it doesn't have any three as well. So it will be going to drop this and pointer will move to point next value. So here we don't have any value. Now pointer will move to on this. So we don't have any value. So output will be going to return as this value. So one, one, two, three and three. So this is all about the merge how merge will be going to work. So now go to on SQL Server to see in practical. So as I am using SQL 217 you may have another version of SQL Server. Again I am going to use AdventureWorks 2K16 database. So let me create this work order temporary table from this work order. So we can execute this query and we can say that 72,591 rows have been inserted in the work order tmp table. So as I told you we should have the proper index on the joining column. So now we need to execute this create cluster index on this work order temp table with work order id. Because in work order table we have cluster index with the work order id. So we can execute and now index is created successfully on this work order tmp table and in our work order table we need to check about the index. So we can check and go to down. And here in the index as we can see this is the work order cluster unique index. So that is fine. Both table has the index with the order id column and second one equation should be there. So we have the equation. Now we want to apply join between work order table and work order tmp table which is created at yet. Now we can execute and we just want to check the join. So let me enable the execution plan and execute the query. Go to on execution plan and here we can see merge join. So it will be going to written as merge join because both tables are last table and both tables are also having the cluster index on the joining column which is work order id column. So I hope you have understand about the nested loop joins and merge join in this video. In our next video we will discuss about the hash join. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.


Hi everyone in this tutorial I'm gonna show you how to join two lists in Python. Here we have two lists and we can join two lists by simply adding one list to another so I can use plus operator and add list two to list one and we can save them to a new list three and we can print the result of this joining of these two lists. The second way to join two lists is by using append method. I'm gonna use for rich and I'm gonna append all elements from list two to list one by using this append method. I'm gonna print our list and as you can see we get the same result two lists are joined. That's all in this tutorial don't forget to check other tutorials on our channel see you in the next tutorial bye bye