Good afternoon. Hi everyone, how are you doing today? Thanks for joining the session. If you can hear me okay, put it into the chat, let me know. Thanks, Tuxa. Fantastic, thank you all. Welcome to the session today here with Tick Meil on the Ultimate for Extrading Masterclass. How is everyone doing today? And I think I see a couple of regulars here. If you, you know, as you're joining, let me know where are you joining me from? Let me know, I love to find out where you're joining us from. You'll give it a couple of minutes before we get started in the meantime. Put it into the chat, say hi and let me know where you're joining me from. Very nice. Thank you all, Philippines, Malaysia, Zambia, India, good stuff, good stuff. What about everyone else? Today we are going through a bit of a trading clique. So I'll be sharing with you some, my own trading strategy and if you have any questions, any trading related questions at any point in time, you know, we're gonna share your strategy. Let's see whether I can help you with that as well. Just a preemptive comment is that I seem to be losing my voice. So just let's see how it goes. Hope I don't lose it during the session. Hey, John, how are you doing? Very good. Thank you all for attending nights and early. We still see a couple of people streaming in. Hope you're all well. Trading well, survived last week's volatility heading towards the end of the year. It's Christmas is coming soon. Christmas and the new year coming soon. Looking forward to that. Alrighty, let's get started again. Welcome, everyone. Thank you all for attending the session. Today we are here with Tick Mill on the Ultimate Forex Trading Masterclass. I'm here to share with you today is the trading strategy sessions, trading clinic sessions. So what we tend to do at this session is that if you have, or if you want to share your trading strategy, if you have any questions regarding your trading strategy, you know, you can share it into the chat. Let me know if you need help with that. Let's see if I can provide, you know, my couple of sense and views with your strategy. Hopefully tweak it to help you make it a little bit more profitable, make it a little bit more consistent with your trading strategy, all right? If you have any questions about any particular trade that you recently got into as well, put it in chat, let me know. If not as well, then I'll be sharing with you how I approach the markets. I'll be sharing with you some thoughts, ideas, possible trade setups might be very few and far between as we head into the end of the year, right? Liquidity and price action might be a bit slower, but I'll be sharing with you some possible setups into the markets. So as I share with you some possible setups and ideas into the markets, here comes a quick disclaimer. Material provided is for information purpose and should not be considered as investment advice. The views, opinion, information expressed in the session belong solely to the author and not to the author's employer, organization, committee or other group or individual or company, okay? So what it means basically is that as I share with you some possible thoughts and ideas about possible target levels, please remember that if you do jump into any trades, make sure, make sure, make sure you check it that it fits with your own trading strategy, right? It has to be aligned with your own trading strategy. Check that you're not over leveraging, you're not over trading, because in my experience, and I've been teaching a lot of people how to trade in my experience, it's not so much the strategy or the one or two bad trades that gets traders into a lot of trouble. It's the over trading and the over leveraging that gets the traders into all kinds of troubles with their account, right? So make sure you get that checked, leverage, margin, not over trading, make sure that anything I share with you, if you do jump into a trade, fits with your own trading strategy as well, okay? So a quick introduction, my name is Jindal. I think most of you know me as Jin. I've been trading for, I would say 10 to 15 years now already, predominantly in the FX market. The way I approach the markets is a little bit different. The way I approach the markets, I know a lot of traders will focus mostly on the charts, on the price action, on levels. What I do first off is before I get into any trade, or in fact, when I start my trading day, I have my news upfront, right? So I'll look at the economics first. I look at the fundamental analysis. I tend to look for the fundamental analysis, develop a directional bias first, right? So I look at the news, I look at the economics, develop a directional bias. So say for example, I expect the euro dollar to go up with the recent news, right? So if I expect the euro dollar to go up, but on the charts is heading towards the downside, then I'll wait it out. I'll wait for it to bounce back, reject the support level, or break through a resistance level before I look to buy. So my fundamental view, my technical view will have to align. Then I'll look to get into a trade as it aligns, breaking a support or resistance level as a breakout or a momentum trade, right? So my kind of trades are all, I tend to prefer trend following trades. I don't like, I don't really take on counter-trend trades. I do trend following trades. My view is that trends happen 70% of the time, well, 70% of the time. Counter-trend trades can work, do work and can work, but you know that it's higher risk. We're looking for tight stop loss, big risk to reward ratio is there. There is a statistic that it works 30% of the time. So I rather focus on that 70% of trend following scenarios as we look at the longer-term economics together with the technical view, all right? So let's take that away, close it out. Let's connect that, okay. So again, if you have any questions at any point in time, please feel free to put it into the chat. Let me know straight away. I'm checking the chat as well, so I'll be happy to answer your questions as it comes up. Voice is going, okay. Before I look into what is coming up because we know that there's not a lot of news coming up. There is a big one tomorrow with the Bank of Japan, but after that, we pretty much just have the CAD and then it's all the way into Christmas already. So not a lot of things happening in terms of the news, but we have just gone through a big week last week, right? What happened last week, I'll show you. So let's do a quick review of what happened last week. On Monday, we had the pound GDP number was a good strong number. Didn't move prices a little bit, but not too much. We have the claimant count numbers. This is employment numbers from the UK. Bit of a surprise, it was minus 6.4K. Expected only 3.5 came out at 30.5, so very big unemployment numbers. Claimant count change is the number of people claiming for unemployment benefits. So the bigger the number, the worse it gets because it's more people claiming for unemployment benefits, which means that less people working. But that also didn't move prices too much. The big price mover came when we saw the US CPI data. On Tuesday last week, US CPI year-on-year was 7.7%. Expected 7.3 got released at 7.1. Got released at 7.1%, and I'll show you here on the dollar index on the H1 timeframe. I know there's a lot of things here. You can see there on Tuesday, as the news got released, we saw the dollar index drop pretty much from that 104 or 105 level straight down towards this 103.80 level, okay? Drop straight down because as the CPI, this is inflationary data shows a slowdown in inflation growth, right? It was 7.7, slowed down to 7.1. A slowdown in inflationary growth was supposed to indicate to the Federal Reserve or to give the Federal Reserve, the US Fed Reserve more confidence to progress with their slowdown in interest rates hikes, right? To progress with their slowdown in interest rates hikes. And if you're expecting the US to slow down on the interest rate hike, that's why we saw the dollar index drop from 105 to 103.80. So that was the first big news that we had last week, which we saw significant price movements right across the board as that dollar index drop. Onto Wednesday, we had the pound as well with the CPI number. This time, the UK at 11.1% dropping to a 10.7% didn't move, right? It still moved a little bit, but not as much as what happened to the dollar index because what we had coming up, not on Wednesday, but on Thursday was a whole sleuth of central bank news.  The first of it at 3 a.m. GMT plus eight from the US interest rate decision from the Federal Reserve, right? Took interest rates from a four to a 4.5%, right? 50 basis point rate hike from the US. And I'll show you what happened here. You can see that, let's take all of this away. We did a bit of a projection. We said it was gonna come down, hit this level and bounce up, did that, okay? So what happened, this was at 3 a.m. GMT plus eight. So on Thursday at 3 a.m., where was it? Right there. Okay, at Thursday at 3 a move that line just right across and zoom it in a bit. So you can see here at that point, the news got released at 3 a.m. We saw the dollar strengthen significantly towards the 104 level before turning back down. And then after that, pushing higher again, okay? So why did it push towards upside and come back down to test this 103.50 level again? First off, interest rate hike strong for the dollar. We saw that push towards upside. Secondly, it's also the Federal Reserve talking about terminal rates being higher for longer. What I mean by terminal rates is what they consider as the final rate where interest rates could peak at, right? So if they're talking about interest rates peaking at higher level for longer, means that hey, they could be looking at further rate increases, more consistent, but possibly not as big, right? So maybe no more 75 basis points, no more 50 basis points, but looking at 25 basis points, but over several meetings. So that's why we saw big push. And then during the press conference and after that, we saw the dollar index continue to climb towards the upside, okay? But during Thursday, we also saw a lot of volatility in the dollar because not just at 3 a.m. did we have the Federal Reserve with the interest rate decision. For 30 p.m., GMT Plus 8 again, we saw the Swiss National Bank, the SMB with a 50 basis point rate hike, right? So 0.5 to a 1%. What happened here, and this is actually quite interesting, is that if I show you on the 15th of December and also the last time they did it was on the 22nd of September where we did a 75 basis point rate hike. Okay, so I'll jump to the US-Swiss Frank here and we'll show you the 22nd of September 1st. I know I had it marked out before, there we go. All right, so this is the 22nd of September. When we look at it, a 75 basis point rate hike from the Swiss National Bank typically should strengthen the Swiss Frank. It should strengthen the Swiss Frank and in the case of the USD-CHF, it should actually be pointing, should be pushing towards the downside. What actually happened during that news release was that a 75 basis point rate hike we actually saw the Swiss Frank push towards upside by close to, where is it? 100 and almost 140 pips towards upside, all right? So a bit of an inverse move because what happens from the Swiss National Bank is that they increase rates, but they don't really give very clear guidance on further rate increases, right? They do talk about further rate increases, but they don't say like, what the Fed reserve or what the ECB has been going on about highlighting a target level or highlighting further schedule for further rate increases. So that's why we saw this push towards upside. What happened here was that at the news on Thursday as well, we actually saw, so you can see the timing, this was at 4.30, right? At the news release here, this is at 5, I was expecting it to push, break above that point, okay? So at 4, we actually saw some price volatility, right? Actually rose up by 30-something pips but in the overall scheme, it moved by about 50-something pips, almost 60 pips towards upside. So what happened here was that it got resisted by this key level of 0.9298 or 0.930, got hit that round number resistance level and then after that, turned back down again. Again, not the biggest news for that night. We had the Fed reserve, we had the Swiss franc, we had the Bank of England with a 50 basis point rate hike as well on Thursday. So it was a big, big news on Thursday, US, Swiss franc, pound, euro, all with the big central bank news. In this case, the UK saw interest rate going up from 3% to a 3.5. What happened was we saw a big drop in the pound dollar, okay, a big drop in the pound dollar, despite a 50 basis point rate hike, okay? I'll show you here. No, not that one, that one, okay? On the Thursday at 8 p.m., okay? Thursday at 8 p.m., that, where was it? That point there, okay? The news got released, we saw a drop and then a set there and then after that it dropped all the way down, right? So the first reaction I expected to see was, hey, if the increasing rates at 50 basis points, we should see the pound dollar move towards upside. I was looking for it to test that 1.2450 resistance level. I was looking for that to push up towards that point, but it actually fell, it dropped and I had a key level here at 1.23 and also 1.20, 1.22, okay? So once it broke that 1.23 level, I was looking to sell down. Why was it driven towards the downside is because, coming back to the news, I know I'm switching between screens, I hope you are following so far, was the bank rates votes, right? The number of votes. The first number previously was nine. That means nine members in the bank of England voting to increase rates. The second number is to cut. How many members voting to cut rates? And then the third number is for them to hold rates, right? So you can see here, as you click into that for more detail, you can see that the first number is how many members voting to increase. Second is to decrease rates or to cut rates. And then the third is how many to hold rates. If we saw that it was 9-0-0 by with a 50 basis point rate hike, then we're most likely have seen the pound dollar shoot up towards the key resistance levels. But this shows a bit of a descent, right? It shows a bit of non-cohesiveness where we saw seven members voting for a rate hike, no members voting for a cut, but two members actually voting to hold interest rates at 3%, right? To hold interest rate at 3%. So it shows that, you know, the Bank of England is not fully, not everyone in the Bank of England or all members in the Bank of England is fully convinced that there should be increasing rates by another 50 basis points. And because of that, so it's really because of this voting number, despite the rate increase, that's why we saw the pound dollar trade significantly lower, right? We saw it trade significantly lower down from at eight o'clock, that 1.2330 level all the way down within the next couple of hours, all the way down to that 1.2150 level, okay? So that's a big reason why we saw the pound dollar dropping. Another key level, another key news was at 915, where we saw the Eurozone, the ECB increasing rates, again, 50 basis points from a 2% to a 2.5%, okay? From a 2 to a 2.5, and what you can see here on the Euro dollar is that on the news release, this was on Thursday, and we saw the Eurozone, that on the news release, this was on Thursday at 915, let's put a line there, about nine o'clock, right? I put one before just so you can see the candles. We saw the Euro dollar push strongly towards the upside. It basically went, I'll take away all this for now, right? And then the clock, the 1.0623 level straight up within two hours to hit that 1.0735 level, right? So it's not just because of that 50 basis point rate hike from the ECB during the press conference, okay? You can see here that at 945, there was an ECB press conference. So during the press conference, President Lagarde was actually commenting that, you know, the ECB would be looking at further rate hikes of 50 basis points of at least 50 basis points more consistently for longer, okay? If I can bring that up, I'll see if it comes up. Just a couple of headlines. Anyone thinking that the ECB pivoting is wrong? So they're saying we're not looking to slow down or to cut interest rates anytime soon. It's wrong. They're looking at continuing on with their current path. It's obvious that we should expect 50 basis point hikes for the period of time, for a period of time. So further rate hikes expected. They already know that growth will be subdued next year because of the rate hikes, right? So it came out as a very hawkish approach from the ECB, right? And that's why we saw the Euro dollar shoot straight up to hit that 107.35 level. Unfortunately, once the press conference was over, we saw the Euro dollar come straight back down into the range again. And then it traded within the range before now at that 106.35 level. Okay, so it's still within that range now. What I'm still looking for at this point is if I zoom out a little bit, you can see that it's testing this area. I'll highlight the area there. It's testing this whole area. And if it can hold, if this level holds above this 105.80 level, if it holds above 105.80, we could actually see the Euro dollar push higher again. Okay, and there is a lot more volatility, a lot more choppy price action at this point because we are heading towards the end of the year. Liquidity might be a bit lower, a bit slower as well. All right, and then following on from that, oh wait, on Thursday, we had a few more other news, didn't move prices too much. It was more focused on the central bank news. Then on Friday, we had some PMI numbers, not just in the Eurozone, but also in the UK and the US. And this was a bit surprising where we saw the flash services PMI for the US dropping more than expected was a 46.2 expected a 46.5 came out at a 44.4, which shows a further contraction in the services industry. All right, and that's where we are right now. Any questions at this point? Have I got all you guys clear on everything so far? Let me know, let me know. Good stuff, thanks for the Tushar. Fantastic, Sumit, good stuff. All right, so from that point, from this point onwards, not at that point, from this point onwards today, not a lot of news, right? I can tell you that I've been scalping the Aussie up a little bit, scalping it up and down a little bit, but hasn't moved too much, not super keen on any big trades at this point. Tomorrow though, tomorrow, Tuesday, 20th December, tentatively between 10 to 12 o'clock GMT plus eight, we do have the Bank of Japan with the policy rate, most likely or most definitely going to stay at minus 0.1%, but you do want to pay attention to the monetary policy statement to get a hint of whether there's going to be any changes with the approach, right? Typically, up until today, I was going to say that I wasn't going to expect any surprise for Tuesday's news, but early this morning, we saw, this was 11 hours ago, we saw that the, bring it up, we saw that Prime Minister Kishira was actually looking to revise the current monetary policy. It is not up to the government to revise the monetary policy, it's more up to the central bank to revise the policy, but it could be pressures from the government towards the central bank to revise the policy, okay? So because of that, that news, we might see some increased volatility here on the Yen pairs early tomorrow morning, right? Or late tomorrow morning, actually. Okay, so just watch out for that. From there on to Wednesday, we do have the Canadians, Canadian CPI data, looking to go to climb slightly, right? Medium CPI from 4.8 to 4.9, trimmed CPI staying at 5.3%. So we're looking at inflation in Canada, possibly still climbing a little bit, right? It's still climbing a little bit, which might actually give some breakout potential on the US CAD. I will share with you what I mean later on to the US CAD chart, all right? So that's on Wednesday with the inflationary data for the Canadians, and then we'll follow up with that on Friday GDP number from the Canadians staying at 0.1%. So I don't think this is gonna move prices too much, but I think that inflationary data on Wednesday could move prices, all right? So looking at the US CAD here, oops, let's clear all that out. Okay, so I'll show you to your age four time frame first. You can see that the US CAD has been on a good strong climb towards the upside, right? Stayed within the channel, pushing towards upside, supported at those key levels, right? It's found the bottom of the channel bounced off, not once, twice, three, four, five times bouncing off that level, hitting a resistance level before turning back down again. You can see also that there was a key resistance level at about that 1.37 level. Okay, if I drag it right across, you can see that 1.37 was reacted back in November, reacted early December, and then also most recently last week on Friday, hit that level and turn back down again. If I zoomed out, you can see that the previous trend on the US CAD was towards the downside, it hit that key support level of 1.32 before bouncing strongly towards the upside. What I'm looking for here is that if the CPI data from the Canadians shows still some growth, right? It shows inflation still climbing towards the upside. This is going to signal potential for further rate increases to come from the Bank of Canada, not soon, right? Because at the end of the year, we have the inflation data first, but into next year, which could actually mean some weakness to the Canadian dollar. So with that, we do have a key level at about 1.39 level. Okay, you can see that it bounced off 1.39 over a couple of times before turning back down. We do have an interim level at about 1.38 as well. So what I'll be looking for in this case, now either on the H4 timeframe, look for it too, I'll be looking for it to either come down, bounce off, break above that 1.37 level. Then I'll be looking for a buying opportunity towards upside, say about at 1.3720 level. Stop loss can be relatively tight in this case, because you have a good support level there, resistance turn support level there. Take profit will be towards 1.39, but I would be considering a close at about at 1.38. So I'll give it a chance to see whether price could shoot straight up towards 1.39, but if not, I'll be ready to close out at 1.38, also because it coincides with the upward channel, the resistance of the upward channel as well. All right, so horizontal level, a diagonal resistance level as well. I'm looking to see whether it can get to that level. If it breaks above, great. If not, I'll close out at 1.38, all right? So this week, you can see based on the news, based on what we've just been talking about, it's mostly focused on the Canadian dollar, right? Not a lot of news on the other currency pairs. So it's back down to the Canadian with that move potentially, that upward move as the biggest potential. Makes sense to everyone on the US cat so far, please remember that if you are looking to jump in any trades, do your own due diligence as well. But does that make sense to you all? All good, all good, fantastic, okay. So with that, let's look at some pairs right across the board. The dollar index looks like it might, I mean, with the current price action with the way prices are moving. Let me just check, okay. All right, with the way prices are moving at this point, I like that it has rejected that area of 1.05, it came towards 1.0485, and then it's turned back down, it looks like it's pushing towards the downside. I'm not fully convinced that the dollar is gonna weaken yet, unless it breaks below this level, right? This level here, which had a swing, I'll show you here, bit of a swing low here back in early December, and you can see that it tested these levels here in mid-December. So I'm looking for this, I'm still sitting out, no clear directional trade yet, unless the dollar index breaks this support level. If it breaks that support level, then we could see a quick move down towards this 103.55 level, very similar to what happened here last week. Being the end of the year, being the end of the month and the year, I don't think we're gonna see big significant moves, but I think if it does come down to this level, I think we're gonna see a range within this two key levels of 1.05 and 1.0355. All right, so looking for that to drop, we could see this apply right across the board to the other currency pairs. So with that said, expecting the dollar index to fall towards that one point, 104.16 level possibly break and go down towards 103.55, looking at the Aussie dollar, right? I really like that it has found a good strong support at that 0.6677 level, all right? Last time it hit this level and rejected, we saw it bounce strongly towards that 6.850 level. Right now testing bouncing off, we could see this climb back up again. Again, similar to what we saw on the dollar index, dollar index likely to remain within the range. So we could see this continue within the range as well, the range of 6.677 and 6.850. So we could see that just continue trading within that range for this end of the year period, okay? Kiwi dollar, wait, hang on. Yeah, okay, kiwi dollar, same thing. It's kiwi dollar correlation with the Aussie dollar is very strong. So you can see is that the last time the kiwi dollar tested this level and bounced towards upside, right? So hang on, too messy there. Let's take away a couple of these lines. I see a question there on the pound and gold. I'll get to that shortly, right? So as the kiwi dollar bounces up towards that 6440 resistance level, you can see that most recently it's tested this level and looks like it's climbing towards the upside as well. Okay, so I'm still looking for the kiwi dollar to climb up. It could break that 6440 level to climb higher, but I think that that kiwi resistance level there could be possible, but possibly a bit unlikely. I think we might see it test this level here, right? So still remain within that range of just staying below 0.65, okay? So might see it climb up, consolidate below 0.65 and then turn back down again, but fluctuate within that range, all right? I will do that to share and also Sumit, all right? So like Sumit's asking for the pound dollar, okay? So pound dollar, earlier today, I was anticipating a big move towards upside. I was thinking that, you know, we could see as the pound dollar found a support level there at 1.2128 pushing towards upside, but I think that what we're likely to see the pound dollar do as a quick revision is that instead of pushing towards upside, I think we're likely to see the pound dollar trade within this range, right? 1.22 and 1.2128 or 1.2130, I think we'll see it trade within the range with no clear directional bias in the interim, all right? With that looking at gold, all right? So I was looking to sell gold down, I did fluctuate around this range. You can see that it pushed up and came straight back down. Let me just clear this chart out a little bit. Gold should be seeing, right? If we see, if we anticipate that the dollar index should weaken at least for the interim and gold finding support at 1775 or 1776 pushing towards upside, I think that we should see gold climb towards that 1810 level. Currently at 1796, quite a bit of work required to push it up towards 1810, but still possible, right? So I'm looking for this to climb up towards 1810 and then possibly turn back down again all based on that dollar index trading within that range. Right, as we anticipate, where was it? The dollar index within this range, it seems like across the currency pairs we could see price gain against the dollar and then after that lose ground back again unless we see a break below this 103.55 level. For that to break, we'll have to see some big news again. All right? So far, so good. Sumit on the pound, dollar and gold. Any questions, let me know. With that, let's look at NASDAQ. I was anticipating that big push up, okay? We saw this push up once, it tested that level but it failed to bounce off that support. So it broke through, okay? It broke through and we have a next level here at about support level at about this point here. Okay, so this whole area will be my support area between 11,058 to 11,134. And that's also why we saw price hit this level and bounce up slightly. What I think is that we could see as the dollar possibly could, oops, as the dollar possibly could weaken, we could see this climb towards that 11,435 level. It would be very similar to the Dow and also the US 30, right? I think that we could see this climb up if we do see the dollar index continue to weaken for the short term, short to medium term. All right? US 30, similar pattern, similar move. Clear it out a little bit. We could do a good level here at 33,427. We've got a good strong swing low here at 32,541, right? And then it's tested this point and also highlight this level here at about 32,980, right? So it's at that critical point, you can see that the last time it got to those levels, it rejected and pushed towards the downside. When it does clear above this point, we're likely to see a big push towards upside. Yeah, it has been falling drastically since the first day why it has been doing that is because there's seen some strength in the dollar. There is a bit of an inverse relationship between the equity index and the dollar index as well. All right? So there is a bit of a inverse relationship anticipating now again, anticipating that dollar to weaken, we could see this push back up towards that 33,427 level. I don't think, you know, there's always that talk about a Christmas rally, Christmas rally, could that happen?  I'm not going to discount the possibility of that, but it feels like it's a possibly quite big, significant rally that might not happen, right? But you know, the more you say it won't happen, the more it's gonna happen. So I'm looking for this to see a price action at about this 33,000 level, looking for it to break higher towards that 33,427 or 33,500 level. Alrighty, then Kiwi Yen, here we go. Let me zoom out, you can see Kiwi Yen again. Main thing to focus on here. You're most welcome there, Stephie. Right, not a great upward channel because we are ignoring a couple of points, but you can see that it's found that bottom of the channel and bounce quite strongly. So same thing, if this pushes towards upside, two things, either of two things need to happen or both of the two things need to happen is for this to push up, right? As it finds the support, we're looking at this similar patterns over here. For this to push towards the upside here, what we need is for the NZD to strengthen, right? Which could happen if we do see the dollar weaken, we could see the NZD strengthen, or we're looking for the JPY to weaken, right? And that's going to push, to lead that push towards the upside on the Kiwi Yen. Right, so it needs that to happen. I think we're likely to see the NZD push up. We'll have to wait for tomorrow to see what happens to the Yen, okay? So yes, could it go up? Yep, for sure. Next level to pay attention to, very near is at 87.45. I would prefer to wait it out, right? Wait it out, let it break above 87.45 or more specifically at about 87.25. If it can break above that point, then I'll be looking for that upward potential to just towards the recent swing high, right? About a 30-pip stop loss, 70-pip, 60-70-pip take profit, one is to two risk-to-eval ratio towards upside there on the Kiwi Yen. Could it go higher? Maybe the momentum carries, but watch it. You know, if I zoomed out all the way the last time we got to beyond this level is back in 2015. So we're way up in historic high levels. I'm going to expect a lot of price, choppy price action and movements from there, right? So I'd rather play to the most recent swing high, look and see what is going to retrace back down again and then after that, possibly push back up again, right? This term tax loss harvesting during choppy December month in Forex to have any idea regarding this phenomenon by big players. I don't consider the tax loss harvesting too much in terms of FX, but what we do see is that towards the end of the year, very close, you know, like after, between Christmas and New Year period, we normally see very choppy price action as funds or companies close off their books for the year. So they close off not books, close off their positions for the year. So, you know, typically we do see very choppy price action in the last one week of the year, right? And so that's also why, you know, once I come to December, I do trade all the way till now, till the 20th, and then I'm off. I'm actually off, not even looking at charts and screens for the next two weeks, taking a break, resetting, re-resting, and then back to it, beginning of the year for, you know, brand new year, 2023. Let's hope it gives us better price action, better price movements to try and take advantage of. All right, so it's not worth trying to catch the choppy price action and movements during that period. I think that it's gonna have no real directional bias, but a lot of price movement, but no clear directional bias could be wrong again, if any of the big players or central banks release a news about interest rates or inflation. But I think that at this point, no big price mover anticipated. All right, Tushar? Anyone else with a question? Oops, anyone else with a question? If not, we've done Aussie already. Let's look at the Euro dollar. Same thing, I think I said that already just then. I like how the Euro dollar tried in the last four hours, candle, tried to push up, looks like it's still trying again. I'm looking for the Euro dollar to climb up towards that 1.06 or 1.07 round number resistance level, looking for this to push higher. Okay. US with Frank, I think we talked about that, looking for this now. If that dollar does weaken further, looking for it to break below this 93 level, 0.93 level for that potential downside move. So I like how when price breaks a support or resistance level, because only at those levels do we get a chance to have a relatively tight stop loss for a good take profit, then you get a very good risk-to-work ratio there. Marash, I'm pretty sure this is recorded. I'm sure you can reach out to the guys, take me when they should be able to get you a recording of this session. US Yen, we spoke about this big news happening tomorrow. A big news happening tomorrow. I'm not, if we don't see any surprises from the Bank of Japan, then it's still going to be driven by the dollar index, which could see the Yen trade down towards that 1.34 or .92 level, but like we were looking at the Kiwi Yen, if the Prime Minister does influence the Bank of Japan to comment about some flexibility monetary policies, we could see this push back up again towards that 1.38 level. I would say that at this point, stay flat, stay neutral, wait for the news tomorrow before looking to jump into a trade. US CAD, we've done trading lower, nicely looking for it to test or to break towards that level of about 1.3575, bounce off this level towards upside. What you could also be looking for is that, is for a buying opportunity from 1.3575, take profit about 100 pips. Stop loss can be tied about 40, a one is to 2.4 to 2.5 ratio ratio. Zai, do you think it will affect the dollar? Which one? Which one, the Yen? If the Bank of Japan does come out with a significant news, yeah, it could affect the dollar because looking at the way the US Yen could move, I think it's most likely gonna be a non-event. I actually do think it's gonna be a non-event, but if we do see the Yen weakened significantly towards the upside, then we could see as that weakened that could lead to a relative, in terms of relative strength to the dollar. So that's why we could see back again to the dollar index is that we could weaken now, but we could see this push back up again. Hope I say a question there, Zai. Anyone else with a question? I would say that just bear in mind, as we head towards the end of this period, this year, right, to Christmas and towards the end of the year, shouldn't you most likely not gonna have a lot of trades if you are having a lot of trades if then, you know, review the method, review the strategy, choppy price action, look for clear directional bias before entering a trade. I think we're gonna see price, we're still gonna see price movements, we're still gonna see price moving, but it's possibly gonna struggle in terms of a clear directional bias. All right, makes sense so far, all good. And hey, if you found this session interesting, useful, you found the information good and useful, helps with your, could help with your trading, please put it into the chat, let me know. I'm looking for any comments or feedback that you could share. Mostly appreciate that a lot. Thanks to it, no worries to share. Okay, so if they've gone over the questions, what I would more certainly do will call an end to the session here. Please remember, shouldn't be looking to enter heaps of trades at this point, but if you do trade well, trade safe, have a great holiday, Merry Christmas and a happy new year and we'll catch you all again. Take care now, bye-bye.


Welcome to Toffy TV, it is the Star in Eleven show Everton vs Manchester City quarterfinal of the FA Cup at Goulderson Park, huge game, but sadly we are decimated by injury problems. Obviously starting in goal and goal will be Jal Virginia with Jordan Pickford out injured and Robin Olson out injured as well. Big chance for the young Portuguese goalkeeper to make an impression, obviously he came off the bench last week against Burnley.  Let's see how he gets on. Right back I'm going to go for Ben Godfrey, I just think Mason Holgate recently hasn't looked quite up to it. I put Ben in there personally because I think he's got the athleticism to get up and down the pitch as well. Got that pace which will be needed massively so I'm going to go for him. Left back I'm going to go for Luca Dean cos he's the best isn't he let's be honest. Center backs Michael Keane and Yeri Mina for me, I think Yeri Mina is 100% fit now and I think he's still our best centre back and I think his defensive nose for danger will become really important in this game alongside Michael Keane who very unlucky to miss out on a colour for England will have a point to prove in this game. In midfield, slightly strange make-up in the midfield, I'm going to go for holding two of Tom Davis and Allen. Obviously Allen loves to get about and I think Tom sitting in front of that back four would be that added protection so they would be my two in the centre midfield. On the right hand side I would have Seamus Coleman to do a similar job that he did against Liverpool. It's a man mark almost to pick up players to follow them round wherever they need to go to just be that extra bit of defence that we need in there. The job he did against Liverpool was absolutely amazing and I think he could do something similar in this game. On the other side it would be Richard Charleston not doing a similar job but Richard Charleston just because of his work rate so good and he obviously wants to get forward but will also get back and do a job for the team in this game. A head of not really a head but within the midfield as well Guilfee Sigarton, back and fit. On the golems for me it's just too negative, probably defensively a lot better than Guilfee Sigarton but I'd like to see someone in there who could just try and link the play a little bit and with no hammers or digas I'm going to go for Guilfee Sigarton. You can also stray on to the left as well and allow Richard Charleston to maybe go into more central areas as well but that would make it a bit more compact I think as a midfield and then a head of them Domino Carvent Living and all you're asking for Dom to chase everything, try and win a few balls in the air. Try and get Richard Charleston off him, try and get Guilfee off him as well because we're going to have to be compact, we're going to have to be tight. Could have gone for someone like Mason Hallgate in midfield or Ben Goffing midfield, I don't really think the manager is going to go for that so this is my 11. We haven't got too many options and I don't really, I think it's about the midfield, I think it's about cutting off the passing lanes, I think it's about following your runners, I think it's about being disciplined. I hope that you can try and grab a goal from somewhere, set peace or try and get Dom free or whatever so that's the 11 I'm going to go for, I'm sure there'll be a lot of variations on that and a lot of people maybe want Ben Goffing or Mason Hallgate in midfield. Just let me know, let me know, there's no wrong answers, the only right answer really will be Carlos team tomorrow and even that isn't always right is it so let me know your thoughts in the comments, don't forget to give this video a like. Ahead of the game make sure to check out our new game Toffy Picks, it's 12 questions predict the game, you can win a chance to win £500 pot of money so get involved, go and check that out toffypicks.com, give this video a like, subscribe if you haven't already and join us on Patreon if you want daily live videos. Thanks for watching, see you later.


Hi and welcome to the session. My name is Shashi and I am going to help you with the following question. Question says, discuss the continuity of the function f, where f is defined by fx is equal to minus 2. If fx is less than equal to minus 1, fx is equal to 2x. If x is greater than minus 1 and less than equal to 1, fx is equal to 2 if x is greater than 1. First of all let us understand that function f is continuous at point x is equal to a if f a exists or we can say the function is defined at x is equal to a. Second condition for the function to be continuous is value of the function is equal to right hand side limit of the function at x is equal to a that is f a is equal to limit of x tending to a plus fx is equal to limit of x tending to a minus fx. This is the key idea to solve the keyword question. Let us now start the solution. We are given fx is equal to minus 2 if x is less than equal to minus 1, fx is equal to 2x if x is greater than minus 1 and less than equal to 1, fx is equal to 2 if x is greater than 1. First of all let us consider the function fx is equal to minus 2. Clearly we can say this is a constant function. We know constant function is continuous at every real number so this implies function f is continuous at every real number less than minus 1. Another function fx is equal to 2x this is a polynomial function and we know polynomial function is continuous at every real number. So this implies function f is continuous at every real number between minus 1 and 1. Let us consider fx is equal to 2 again this is a constant function and we know constant function is continuous at every real number. This implies function f is continuous at every real number greater than 1. Let us take the continuity of the function at x is equal to minus 1. Clearly we can see the function is defined at x is equal to minus 1. We can write that x is equal to minus 1, function f is defined and right inside limit of the function at x is equal to minus 1. So we can write limit of x tending to minus 1 plus fx is equal to limit of x tending to minus 1 plus 2x this is equal to 2 multiplied by minus 1 which is further equal to minus 2. So right inside limit of the function at x is equal to minus 1 is equal to minus 2. Let us now find out left inside limit of the function at x is equal to minus 1. So we can write limit of x tending to minus 1 minus fx is equal to limit of x tending to minus 1 minus minus 2 which is further equal to minus 2. Clearly we can see the two limits coincide each other. Now let us find out value of the function at x is equal to minus 1. We know f minus 1 is equal to minus 2. So we can write value of the function is equal to left inside limit of the function is equal to right inside limit of the function. This implies function f is continuous at x is equal to minus 1. Let us now check the continuity of the function at x is equal to 1. Clearly we can see function is defined at x is equal to 1. So we can write fx is equal to 1. Option f is defined. Let us now find out right inside limit of the function at x is equal to 1. So we can write limit of x tending to 1 plus fx is equal to limit of x tending to 1 plus which is equal to 2. Let us now find out left inside limit of the function at x is equal to 1. That is limit of x tending to 1 minus fx is equal to limit of x tending to 1 minus 2x which is equal to 2 multiplied by 1 equal to 2. So we get left inside limit of the function at x is equal to 1 as 2. Now clearly we can see the two limits coincide each other. Now let us find out the value of the function at x is equal to 1. You know f1 is equal to 2, fx is equal to 2x or x is equal to 1. So we get the function is equal to value of the function at x is equal to 1. Or we can say right inside limit of the function is equal to left inside limit of the function is equal to value of the function at x is equal to 1. All of them are equal to 2. Now this implies function f is continuous at x is equal to 1. This means function f is continuous at every point in its domain and hence function f is a continuous function. This is our required answer. This completes the session. Hope you understood the session. Goodbye.


What's up everybody Jason for jazzy's case breaks calm last break of the night jazzy's big hit Express multi-sport series five six box case break random teams number 11 So again guys big hits graded cards sick patches bat knobs and bat barrels and don't miss out guys remember the disclaimer guys This is a big hit break high risk high reward type of break So just know that you there's a good chance of you going hitless guys We created 33 cases So some spots may have a few hits possible, but we try to make the combos As many as as even as possible for every spot, but some cards may get pulled early in the print run So just keep in mind when buying and again 32 total spots everybody gets a random team combo and Just let I fly guys There is no Milwaukee Brewers if we do hit a brewer. It's randomized to the group I forgot to put it on the list and then if a Tom Brady leaf card comes out Don't know if it's an auto one-on-one whatever the case may be just know that we established it. It's gonna go to the Patriots But everything else should be good to go dice roll it here. Let's customer name Zachary down to Logan And we got Mavz Orioles down to the White Sox Steelers Warriors and these are the box our cases still remaining So I'll choose that from the same dice for the list So let's roll the dice and we got a four and a two six times. So good luck six times one two three four five six James down to Daniel. All right six times here one two three four five and six Chargers Nets combo down to the nationals um Dolphins and Clippers All right. So James, you have the Chargers Nets Gerald with the Dodgers Brown Sons Arturo You have the Seahawks Carnal Celtics Brett with the Rays pelicans Arturo the Mazoros Nick with the Rangers Texas Rangers Titans and Yankees deal with the Bangles 76ers round with the Carnals Tewos DJ with the Pirates Lions Bucks Curtis with the Bill's Jax Padres as well as the Braves Eagles Roger with the A's Broncos Curtis with the Mets Ranscaz Gabe with the Twins Ravens Nicks Matthew with the Bears Bucks Grizzlies Curtis with the Angels Texans Tyler with the 49ers Tigers Pistons and knock with the White Sox dealers Warriors John C with the Phillies Falcons Blazers Logan last ball module Astros Jets Kyle Hoover with the Giants Raiders Bulls Curtis with the Cowboys Jazz Zachary G with the Indians Giants Nuggets Gabe with the Red Sox Sacramento Kings Walter with the Blue Jays Colts Charlotte Horneth Taylor With the Mariners Raptors Vikings John C with the Royal Patrists Hawks James with the Reds Washington football team Andrew the Rockies Packers Wizards John C with the Chiefs Thunder Eric with the Marlins Panthers Lakers and Daniel the Nationals Dolphins Clippers So I'll give you guys a quick trade window. I know there might not be too many people watching right now that are actually part of this break, but quick trade window and then of course Let me go choose the case or not choose the case. Let's randomize the case. So six one two three four five six two Or sorry case two is what I'm getting So let me quickly look at this Is that right Eric? Well, hey man, there's multiple hits for most teams Let's try one of the close guys So again, this is last break of the night guys. So if anything feels we'll break it tomorrow Or later today, I should say Joe will be back in like legit 10 hours so You guys will be waiting too long Appreciate it guys though. We had a very very busy day today even phoenix football surprise But it's a surprise we sold out pretty quick. I think a lot of people did like it And we have a One out of five. Nolan Ryan. Look at that patch from definitive. That's Houston astros edition That's Logan last bomb mojo. There you go, man And that's a little train whistle here All aboard for you Logan All aboard the big hit express And a green prism retail nine five Donovan Mitchell for the Utah Jazz Utah Jazz Curtis Erickson with that one There you go, man Next one and a one of one white whale triple relic and auto. It looks all for the Mets Darryl strawberry david ride and pita lanza. Very nice Who has the Mets?  This is a one-on-one hot case Worn moon Houston Oilers, which should be going to the Tennessee Titans That's nick coba with the rangers Titans Yankees combo There you go, man. All aboard as well all aboard the big hit express And the last one folks. Good luck Another one-on-one. Oh, man national treasures demarians thomas shield Denver Broncos Roger with the a's broncos combo And there you go, man. All aboard all aboard the big hit express So many one-on-ones in this case Well, there you go folks high-risk high reward, of course if you do hit but do not worry You'll be parts of an endless a hitless promo one-on-one One-on-one one of one one of one donovan Mitchell and out of five So there you go guys This was the big hit express series five six box case break random teams number 11 and just to show you guys on the screen Six customers one two three four five and six down here that hit But let's put your guys's name into the hitless promo list Right over here. We started right here Roger out Logan you're out Curtis. You're out our doodle Curtis And Nick And there you go guys, so it'll be part of the promo So appreciate it guys jazby's case breaks.com


What's up? How are you guys today? Another Monday down at Frankie's free-range meet.   On the brighter side, it is a beautiful sunny day. So I'm gonna try to film this vlog really quick. Get out of here, relax, and lay in the sun. And I spoke to the landlord last week, aka the management company, and they said, hey, you know, come down to our office. Let's have a meeting. Let's talk about what's going on. No less than three days later, I was served with a termination notice on my lease, which isn't like an official document. It's not like an eviction.  Leave. They're claiming I violated in terms of the lease, which is completely factually incorrect. And I said, okay, I texted my lawyer. I said, look, let's let's do something because I know this guy's really scummy. He's gonna try to do whatever he can to get me out of here.  The landlord clearly doesn't want me here. So, you know, we know this is gonna end to get ugly. First thing today, Monday morning, 8 a.m. I'm usually not down here yet. Fire department comes, FDNY, the inspector convinces one of my guys to let him in. He lied to him. He said, you know, because no one's allowed to come in your building without a warrant. And I've told my guys over and over again. FDNY inspector lied to my guys, came into pictures of everything, and we're not doing anything here. That's a problem. My concern is this guy is so connected, just them coming in the building and taking pictures. Who knows what kind of stuff they're gonna make up or say just to attempt to shut down my business. I know that's not out of the realm of possibility. So, you know, I didn't think that would happen before I could do something in the court or get my lawyer to do something. But, you know, this guy's acting fast and he really doesn't want me here. He's doing some really scummy stuff. So, we'll see what happens over the next few weeks. I'm just really, really over this. This guy's a complete dirtbag.    And this happened so many times with my last lawyer. I'd call him up on the phone. He said he would do this or that or file this or that. Never did it. Never did it. Never did it. Never did it. Happened multiple occasions and I just assumed what the guy was saying was the opposite of the truth. Same thing with this landlord. Every time I've talked to him, they've said they're gonna do something. They do the opposite. They got a knife behind their back. Three days later, they put something ridiculous in like email or writing. But whatever. Let's show you guys what's going on today. I think we have some new products, some restocks. My guys are eating lunchdowns there, so it's nice and quiet up here. They got about three pallets of orders done already. I didn't have time to do it today, but we actually have all of the spices and seasonings that are going to be used for the new hotdog. So I got to make these myself, ship them over to the butcher shop and he's going to use these. And these are actually cloth bags. So guys, I put a lot of time and effort and I guess you could say love into everything I do. So you know, no one else is going to use all organic spices, shipping them in cloth bags, land salt to really do the highest quality product possible. So hopefully I can do that tomorrow. For the most part, everything is in stock on Frankie's for range foods. Guys, we got plenty of Pemicin, which you guys have been buying a lot of. We just restocked to the flavored jerky and we're going to try to get some plain jerky back in this week. So water kefir grains is back, which a lot of you guys have been asking me for, but we should have the water kefir grains consistently now at an affordable price. And also I'll show you guys later the orange kefir, which is new, but let's jump in the freezer real quick to see what's going on. So you guys know we have the Wagyu strip and the Wagyu rib eye steaks, but we did get a deal on some smaller portioned Wagyu strip steaks. So if you guys want to try these out, these are a bit smaller. As I said, more affordable. We have all the broths in stock guys, both the collagen broth and the chicken stock are available now on frankiesforrangemeat.com. The beef cheeks are back in stock too.  All of the chicken is restocked.  More importantly, we have a new product guys. This is the Iberico strip steak. So normally we've been selling these as like the whole loin, which is pretty expensive because it's a heavy piece of meat. But these are nice six ounce portions strip as well as the rib chop. The rib chops are a little more expensive than the strip obviously, but both really, really nicely portioned. Small steak, perfect for kids, have a few for an adult. These are under the Iberico pork section. I don't know if I showed you guys, we have these five pound bulk bags of sirloin stew meat, which I got a deal on. So you guys get a nice discount of price on that. It's a lot, but I guess if you want stew for a family for a day or two, that's what you'd use it for. I did want to apologize. We ran out of beef liver this week guys. So there are some orders that are delayed. I've emailed everyone to let you guys know if you'd like to just cancel the order or you can just wait a few days and we'll try to send it out. And hopefully in addition to the beef liver, we'll also be restocking some other products this week. So that's kind of it on the meat end. Still trying to find the source of the marrow bones. Still trying to find some tendons. But you know, since we have the collagen broth, it's not as big of a deal. In the fridge we have our freshly sliced roast beef, which I will gladly take some home for lunch. And all the cheeses guys, most of them are in stock. So Wi-Fi shielding in Frankie's Nationals. We don't really have anything new going on. I've been trying to tell you guys for the past I guess month or so that I'm trying to get some new stuff and restock something. So hopefully in another month, month and a half, we do have that stuff. Mainly restocking the t-shirts, the underwear and the hair pomade on the Frankie's Nationals. I mentioned this last week, but we are doing kind of like a liquidation on the organ supplements, the bovine powders and everything. So guys check the website, let me know how the price point is. I might lower it a little more, even though I really don't think I should. So everything guys, the heart, the liver, beef testicles, full spectrum organs, pancreas. And you guys have also been buying a lot of the different minerals, vitamin K2, vitamin D3. We have the master's gum available, of course, and the magnesium oil, magnesium spray. I told you guys last week as well, the restaurant supplier did not have any organic pineapples. So we're going to have the orange water kefir, which is now available. So Frankie'sFoods.com guys, we still have some pineapple kefir left in stock. We have the apple lemon. We have the orange and we have the regular. So quite a few flavors, but I don't really have anything else to go over today. And as I said, guys, I'd like to get out here and lay in the sun a little bit, hopefully I feel better. So I know a lot of you guys are dependent on me for, you know, your food every week and are probably wondering what's going to happen with the business. Realistically, I think we're just going to kind of have to stay down here for another two or three years, even if it's a little bit ugly with the landlord. Because as I've stated many times, I'm broke and I cannot afford to relocate by any means. And there's too many logistical issues with that. Me having my current employees, I don't know if I could really hire and train new trustworthy people, it's just too much involved. But if you guys do want to support me, you can check out all the businesses on frank-to-paw.com guys. A lot of interesting products on there, go on there, check it out. But if you guys can please drop a like on the video, leave a comment down below, subscribe so that YouTube can unsubscribe you next week. And be sure to check that notification bell so they don't notify you of my videos. I'll see how I feel tomorrow guys. Maybe I'm not going to do an educational video, just we'll see.


Statistics and Excel. Histogram versus bar chart. Get ready taking a deep breath holding it in for 10 seconds and getting ready for a smooth soothing Excel. First a word from our sponsor. Well actually these are just items that we picked from the YouTube shopping affiliate program but that's actually good for you because these aren't things that were just given to us from some large corporation which we don't even use in exchange for us selling them to you these are things that we actually researched purchase and use ourselves. Here we have a western digital WD elements 20 terabyte usb 3.0 desktop external hard drive we use as part of our backup system noting that if you lower the number of terabytes of storage the price will lower dramatically as well when you're thinking about a backup system you're usually thinking about an online system or an external hard drive system like this or ideally some combination between the two given you some redundancy. You can also work directly from an external hard drive like this but there are some drawbacks to doing that one being if you use this as your primary drive you're working from it's no longer a backup drive and you're going to need a backup system possibly another external hard drive and or some kind of cloud backup system and if you're working on something that takes up a lot of short-term memory a lot of RAM as you're working on it such as video editing the external hard drive can slow up the system so you might want to come up with some kind of system where you download the project you're working on to your computer to your C drive or possibly to a solid state drive which is a much more expensive external hard drive as you do the work once the work is done then save the project to an external hard drive such as this. If you would like a commercial free experience consider subscribing to our website at accountinginstruction.com or accountinginstruction.thinkific.com where we have many different courses you can purchase one at a time or have a subscription model giving you access to all the courses courses which are well organized have other resources like excel files and pdf files to download and no commercials. Here we are in excel if you don't have access to this workbook that's okay because we'll basically build this from a blank worksheet and therefore you could start with a blank worksheet if you do have access to this workbook then there's three tabs down below example practice and blank example in essence answer key practice tab having pre-formatted cells so you can focus in on the heart of the practice problem the blank tab where we will be working we'll just have the data set so we can practice formatting in excel as we work through the practice problem let's go to the example tab to get an idea of what the end result will be we're going to take our data we're going to sort our data we'll calculate the average and the median but our major focus is looking at the differences between a histogram that we will create from the data and a bar chart that we will create from the data now these two things look very similar but there's differences in how they will work and we can actually create in essence a histogram from the bar chart so let me give you an idea of what i mean here if we go to the insert tab up top and we go to the charts group then most of the time the first thing that comes to people's mind when they think of charts is the classic bar charts up here but the histogram is here looks similar but it's different so we'll think about what are the differences between a histogram and a bar chart and we'll think about how we can basically use bar charts to create a histogram which can have its own uses from time to time and will also give us an idea of the similarities between the histogram and the bar chart so let's jump back on over to our blink tab now if you don't have your data set here then you could copy this data set if you just want to type it in or you can create your own data set using some of the methods we talked about in a prior presentation most of this data is kind of around we're imagining wages here so it's around like 65 000 to like 80 000 is the data set and it's got a shape that's that's somewhat you know bell curved or kind of shape to it that's the general concept so if you want to put together a data set something like that then you can practice with that or you can use this data set so i'm going to start by formatting the entire sheet like i do every time because all we have is data i haven't formatted the sheet so i'm going to put my cursor in the triangle up top right click on the selected area i'm going to format the sheet for my underlying formatting which i like to be at currency negative numbers bracketed and red no dollar sign i don't need the decimals right now because these are these are rounded numbers and the decimals are not going to be relevant to me so i'm going to remove the decimals and then okay so now i can format the cells they have a comma in it they look like a number format that will be my baseline formatting i'll also select the entire thing go to the home tab font group and i'm going to make it boldened because i think that stands out a little bit more for the presentations and you might just like that too although if you make everything bold then making an individual thing bold doesn't have the same kind of effect right but then we can i'm going to hold control down and scroll in so now i'm zooming into the data i'm currently at the 250 percent all right so the first thing i want to do is sort my data so i want to put a row above this so i can put a header on it and just call it wages i'm imagining this is data related to wages i could do that by selecting the entire row which is easier than selecting one cell and inserting above it due to the fact that there's nothing on the right hand side that's going to get messed up if i add an entire row and it saves a click right so if i click on the one here and then i select the entire row right click and insert i don't have to tell excel hey move uh the cell down if that's the only option it has is to move it down right it can't move it up because it would go right we're always moving down it's the entire row okay so we're going to say this is wages and so there we have that i'll center it our home tab alignment and center that not that center i want to this center and then i'm going to make it into a table which is what i typically do i feel more comfortable when the data's in a table format so i'm going to put my cursor anywhere in the data because there's no blank cells i could put it anywhere in the data and when i go to the insert tab up top the tables group and then to the table it will guess that i want the whole table and you can see it by the dancing ants around there that it's picking the tables that we want so there it is and so now we can sort the data and so i can hit the drop down up top and possibly sort it from z to a or a to z let's sort it from a to z so the lowest point is 55 that we talked we looked at this last time the biggest point is at 84 000 if i wanted to calculate the average and the median i'm going to make this column shorter notice every time i create a table if i want to calculate the the average in the media based on that data i'm not going to start typing next to the table because i don't want anything actually touching the table because excel might get mixed up that that's part of the table so traditionally what you want to do is put a skinny column so i'll make a skinny b so that i could tell excel hey these things are different keep them separate it's like the it's like the vegetables and the potatoes on the plate you don't want that i don't like them all mushed together and that's how excel is too so then i'm going to say this is going to be the mean uh and the av or let's say or the average so remember there's a couple different ways that we can calculate this right we can use the the function method function which is the average it uses an average calculation so equals average so we just double click on the function it has an equal sign the function and then the brackets and the argument down below and we just select the field now the easiest way to do that is to put your cursor here control shift down arrow and now i could just hit enter because that'll take me back up top but if i want to check the formula i can see it in the formula bar right there and i can hold control and backspace which takes me back to the top so now i can see the formula here now technically i should close it up control uh zero but i don't have to if i don't have that last bracket and i hit enter uh excel is nice enough not to get mad at me or anything usually so it's going to say enter there it is now i can also do that average if you if we recalculate the average we could say okay the average is going to be the the uh the let's say the manual manual method let's say we sum the whole data set the famous function equals sum shift nine i'm using the keystrokes now i'm going to use the keyboard now to do this because this is a familiar formula left left left up up up notice i'm not using the mouse at all because i'm trying to be super nerdy cool and then control shift down so that now i've summed it up now i could just hit enter i can see the formula up top but if i want to see it in the cell i can say control backspace there it is i don't really need to close this one up either so i'm just going to hit enter sums it up and then i want to count so i know that i can do it this way i can say well this is two and this goes down to to 51 so like so 52 so i would think like 51 would be the count but i can also use the count function which equals the count so there's our count function once again i'll i can put my cursor over here with the arrows control shift down arrow and then there it is in the formula bar i could just hit enter but i'm going to hit control backspace and enter and then divide so divide divide that's not spelled right i know it's eight equals up up so now i'm just using the keystrokes again so i want to take i want you i want excel to take what's in cell d five which is d five divided by slash up once notice i had to hit up not down it's not going to excel is not going to start from the last cell i was in it's going to go back to the formula so take what was in cell d five divided by what's in cell d six and enter and there's our average so let's say let's make this indented home tab alignment indent and i can indent these again indent and let's just call this the average i won't say divide i won't put the function in there i'll just say average and then the median is going to be we can use the function for the median equals most people just use the median you could use quartile too but you i'll just use the median function and so same thing i'm just going to go up here and say all right control shift down and then control backspace and enter so there it is on the manual method manual method i can just say it's it's the one in the middle right if i counted all of these and then i picked the one in the middle seventy thousand nine is in the middle right so right there so meaning if if i counted the ones you know below it and above it i get to 25 below it and 25 above it right so it's in the middle so that would be just picking pick the one in the middle just like rocky does when he's in a fight and he sees three of them out there then he then just like his mickey said he hits the one in the middle in any case i don't know rocky no one knows rocky anymore what are you talking about uh let let let's go ahead and make this blue uh let's go to the home tab font group i use this blue down here if you don't have that blue you can go to the more colors and use this blue and right there i use that excel it's fun guy used to use that home tab font group i'm going to put borders around it borders around it and then let's just make a little bit more well let's i'll keep it at that all right well now let's make a histogram from this data we'll make a histogram from it which is easy to do we can just select the entire uh dataset one way you could do that is selecting like where you have the down arrow that's just showing the data uh without without the headers uh on it and so i'll pick that up and i'll go uh let's go to the insert tab and then chart group and i'm not doing the bar chart but a histogram so i'll select the histogram there's our standard histogram so i'll put that in play i'm holding control scrolling down a bit so we can see the full histogram so there we have it okay so i'm going to delete this thing up top so let's delete that oh not the whole thing undo control z or undo i just want the title to go away all right and then i'll hit the plus button and then we want to see uh the the access data sets an easier way to do it possibly is just to double click on this item down here so i want to look at these buckets that it made so it made these buckets and then put the information that lands between these buckets now i want to go to the bend size over here and i'm going to put my own bend size which is 2000 say the buckets bend size uh is 2000 and we get something that looks like this so what is the histogram doing it's saying hey look everything that's in between 55 and 57,000 i'm going to count those how many there are and put that amount here one in this case and then everything in here from 67 to 69,000 they counted and put here looks like around seven right and i could put the numbers in here let's put the numbers in here and i think the easiest way to do that is to actually right click on the data itself right here we're going to select the data and it says here uh add data labels so i'm going to add the data labels and there's the data labels if i select the data labels we can go to the insert or home tab font and embolden them we can make them you know larger uh if we so choose so now we've got our data labels so here we had seven that fall into this bucket 19 that fall into this bucket 15 that fell into this bucket and and so on and so forth so obviously we can change the size of the buckets and we'll we'll look more about that in future presentations but right now we can say okay well what what would happen if i made a bar a bar uh chart now if i insert a bar chart and i just use this data like if i just say take this data and make a bar chart so now i'm going to go to the insert tab charts and make a bar chart of it just the standard one that's not that useful right because what it's doing is it's taking it's just making its own like number set down here and saying how many how many how many ones fall into that but the problem is that that we have a more nuanced data so that's why we need the buckets right that's why we need these buckets so what the the histogram is doing is nicely sorting the data into buckets but we could do that ourselves and there's a couple ways that we we could do this you could use like a a histogram or you can use uh you can use an array and the and the two uh so i'll try to show both methods the array thing is going to be an easier thing to do but i think it's easier to kind of see what's going on if we use kind of like the formula method first so uh let's let's let's say that we're going to we're going to say that i would like to put my buckets in place between 55 000 and 57 000 i'm arranging my buckets between uh between the the low and the high and i'm going to have all my buckets increase like we did up top by 2000 so this is going to be this plus 2000 and this is going to be this uh plus 2000 so we're kind of naming the bucket size now now that i have these two cells in here i can copy that down to get all of my buckets so i'm going to put my cursor here i'm going to select these two i'm going to put my cursor on the fill handle and we're going to drag that down until we get to like 77 we got to get to like 85 i think fill handle dragging it down 83 one more time to 85 so there's now i'm going to use a kind of fancy formula so i can put these two things together with a dash between them so that i can get a label for our bar chart that looks something like this now this is the type of thing that works quite well when you're working with text so for example i'm going to say this equals and then i'm going to point to this cell so what's in c 17 c 17 but i don't want to add it to something else or anything like that i'm going to hit a space and i'm going to hit control and so i'm going to say and and then i want to put text in it so when i want to put actual text in it i have to tell excel that it's a text item by putting quotes around the text so i'm going to say shift i'm going to put quotes and then i'm going to put a dash that's what the text that i want and then i'll close up the quotes so what will happen if i was just to leave it like this it would put the 55 000 and then it would add that dash as a text item for it and then i'm going to say space and another and and then i also want this here as well so now it's going to be putting together what's in cell c 17 and this text in quotes of a dash and then what's in cell 50 in cell d 17 so if i say enter there we have it now if you if you if that's too tedious to do and you don't want to do it that way then you could just type it in there you could say uh if you don't if you don't want to have a function you don't have you don't start with a function 57 000 dash 59 000 but then of course you have to type it in going down so what's nice about a function like this is that you can then grab that on the fill handle and drag it down right so now i've got my uh data labels and then again i'm going to use a somewhat uh fancy formula to count and try to say that i want to be picking up from this data set what is in between the the 55 000 and the 57 000 so to do that i'm going to use a pretty fancy formula here so before we start the formula note we have a bit of an issue if we have a number that falls right on the line so for example if we look at this first bucket we're including everything from 55 000 to 57 000 then everything from 57 000 to 59 000 59 000 to 61 000 but what if for example the number is exactly 59 000 do we include it in this bucket or do we include it in the bucket below now the general rule is that we would include it in the bucket above and then the bucket below would not have anything that's 59 000 exactly but everything that is greater than 59 000 up to and including the 61 000 now that also leads to a bit of a problem on this first line right here because that 55 000 we want uh in this first bucket to include what's in the 59 000 the 55 000 because we want that to fall in that first bucket and we have one that falls right there so i could make this a little bit lower i could make this 49 000 so that i can pick up everything you know from 49 000 uh and above which is a little bit different than our histogram over here but that's what i'll pick up so that we can have the same formula all the way through all right so now we'll do our calculation this is going to be equal to we're going to use our count if calculation but not the normal one that we looked at last time instead count ifs because we're going to have multiple criterias the criteria being that it has to be greater than the the first area 49 000 in this case and then less than or equal to the top criteria the 57 000 so i'm going to say count ifs and so here's our here's our formula here's the first argument in the formula and so i need the criteria range i'm going to scroll up i'm going to put my cursor on the little arrow so i can set the drop down dancing ants around just the data scrolling back down i can see the formula here i can see the formula up top to get to the second argument i select comma so now i'm on argument number two which is the actual criteria so if i was going to put a criteria which was just like one number then then i can refer to the cell but i need a more complex criteria because i need it to be greater than the 49 000 and so that means i'm entering text so i'm going to have to put brackets around the greater than so brackets around or quotes i mean around the greater than and then i've got to connect that to this number so i have to use an and in order to do that and then pick up the 49 000 and so that's going to be our first argument it's got to be greater than the 49 000 notice if i just hit enter right there if i stop my formula right there and enter i'm at 51 uh items which seems reasonable let's let's double click on it again and continue the argument so i'm going to go to the end of this argument again and add another criteria so i'm going to say comma the criteria range i have to select the range again scrolling up putting my cursor on the a where i have an arrow dancing and surround the data comma takes me to the next argument which is the criteria and i want this to be less than or equal to the 57 000 so i have to put the quotes because i'm going to put kind of text in here and i have to put the less than first and then the equals so less than and then the equals less than or equal to and then end the quotes and i need to tie that together with an and so we're going to say and and then i'm going to pick the second cell 57 000 and there's our second argument i'm going to close up the brackets shift zero closing it up so it's kind of a kind of a long formula but there we have it now it picks up one which makes sense right because we just have that 55 000 so then i can select that and i should be able to just copy it down let's copy it down one time fill handle copy it down and see if that picks up the second one in the same fashion notice there's a bit of a problem here hold on a second i'm going to i'm going to hit enter now i messed up my second range i'm going to start this one at 57 000 so now this this first one was at 49 the second one's at 57 and then we're 2000 apart so now it's picking up zero which ties into our numbers above let's copy it down i'm going to put my cursor on the fill handle and copy it down and so now we've got 19 in this bucket right which is 19 in this bucket 69 to 71 and the the seven in this bucket so that looks about right right so so now now i can use my bar chart so now i can select these items and i can say i'm going to just insert a bar chart which will basically build a histogram because i've created my own buckets so i'm going to go to the to the insert up top after i've selected those two rows or columns and then the charts and graphs and instead of the histogram this time we'll make just a normal bar chart so we'll make the bar chart i'm going to pull this to the to the side so we have it over here and let's put these like on top of each other so i'll bring this one over a bit so there's one on top of the other and then i'm going to delete the title and let's see if i can click on this right click and and say if i can add data labels add data labels so there we have it so there's our our general concept with it so now we've got the one seven nineteen fifteen seven one and one one seven nineteen fifteen seven one and one and so you could see you know the so hopefully that gives an idea of of basically how you can build your own kind of histogram from the bar chart now note that that could be actually useful to do because if you have a bar chart like this you can actually add a second set of data a little bit more easily than possibly the histogram so that you can compare two kind of shapes of the data on the same bar chart now also note that the bar chart has similar features on how do you how you deal with it so if i double click on these bars for example sometimes you might think the histogram has some wider uh uh bars right so you can double click on this i'm into this bars over here and i can say that if i want you know to make them skinnier or i want to close the width between them right so now i've got it you know almost touching each other right so you've got something so that might give you more of a a histogram like feel if you lessen the gap between some of these let's do it this way so i could see it gradually so there we go something like that all right and then so so that's the general so that's the general idea and and that can be a useful tool now before we wrap this up i just want to note that you can uh this is somewhat of of a tedious process if you if you use the the another function which which is like a newer kind of function it's a less intuitive to me but faster once you understand it then you can get to this data a little bit faster and you could build this format a little bit quicker which would be useful again if you wanted to kind of put two of these on top of each other for example so to do that we're just going to put our end points on uh that we want on the end point so fifth just this column so if i reconstruct that column down here just the end points we start at the 57 000 and then i'm going to do the same thing we did before by just saying equals the one above it plus 2000 and then i'll copy that down until we get to the 85 000 putting my cursor on that second one fill handle dragging down until we get to that 85 000 so there we have it and so now i'm going to use an an array so i'm going to say this equals and we're going to use a frequency double clicking on the frequency and then i'm going to select the data array which is going to be up top selecting the same data dancing ants around the data and then i'm going to say comma and then i'm going to put my cursor around the bins array so i'm selecting the bin array here and then i'm going to close this up and what what this will do is basically spill out the data right so i'm going to say enter and now it gives me that spill of the data so the fancy way to do this obviously a lot faster than this kind of long formula but i still think the long formula is kind of intuitive to look at it as well so in future presentations we'll kind of continue on with this because i know we're going a little bit long here and we'll do different kind of histograms based on this similar data to see what the shape of the histogram will how it will change as we change the data sizes


Hi, good morning and welcome to today's products and focus so most global equities markets are actually up a little bit High this morning as a latest round of Chinese data again disappointed Which kind of gets rise to the fact that there's gonna be more stimulus on the horizon for for China So bad news is good news at this stage and that's helped most other global markets including the Eurozone and the US take up a little bit higher as well You can just see the big turnaround that we've seen in yesterday's candle on the US 30 very strong Turn around from a low quite below 18,000 to close above 18,000 and 85 is still pretty decent In fact, we're trading above 18,000 123 right now near historic all-time highs on that market So moving on to the UK 100 Not quite sort of powerful candle right there trading below the 55 period SMA Potentially cat by that 69 64 potential resistance level in the short term Still trading above the zero line on the MACD with the other technical decayers flattening out ever so slightly, but we've still got The kind of tips these candles to contend with we've had a series of lower highs And the UK 100 can redo with getting his head above 69 64 with some conviction and certainly getting quite close to 7100 again before it's gonna get the opportunity to springboard that little bit higher But I think it's gonna depend very much what's happening over in the Eurozone with Greece and Economic data coming out of America So make it looking at Japan to do five again a bounce off the potential trend line and 55 period SMA But potentially cap the 21 period as you get closer to 20,087 with the short term potential resistance I'm still got this potential head and shoulders formation here to be wary off for the Japan to do five Dollar yen reversing course again back to iron towards you guessed it 119. So 119 80 odd is what we're at just now But we have seen some some yen buying and gold spiked up yesterday as well Hood spiked up a lot of commodity prices spiked up That's on the back of the stronger USD apparently But we're not really kind of seeing that in today in today's market but also just a little bit of turn to bond yields set sold off again last night as a Yields increased but bonds sold off so as new as new yields become higher. Obviously people get rid of the old ones So we have began to see a little bit of a right in the bond market again And all the yen is It's just really drifting down a little bit more people are buying a little more yen to defend against uncertainty So they're moving on to Cudobas, Texas. It ramped up last night On the back of an OPEC report that they expect global demand to actually increase More next year than what they had initially expected. That's caused a decent spike above 5950 but we're still not above the historical Recent high which we're in about 61 66 so we're not that far away from there just now So we'll see if things continue and it is Wednesday a huge amount of economic data today I'll come back to that in a second with that. It's inclusive of crude oil on the trees So gold broke above 1186 on the back of that bond sell off yesterday Tips these candles are indicative that probably around about 112 is going to be hard for it to break through It's not done it for a couple of sessions But if we do get some momentum it might might be able to push on through depends what happens with the bonds today And if we have a look at your dollar You're a dollar moving a little bit higher off the session highs from yesterday But grinding a little bit higher today. It really wants to break above 113 If it's gonna have a move to Re-challenge these heady heights here on way back to one sixteen forty two More negotiations Negotiations between Greece and its credit are still ongoing and that's probably going to be the way until June anyway Cables had a great run absolutely smashed it last couple of days We're at 157.43 after the general election cables gotten a lot more stable. It's pushing up higher 157.43 as potential resistance fall by one spot 59 and Technical indicators were RSI specifically showing it as being overbought They still stochastic is already broken through the percent level as number of sessions ago And the MacD's just going high and higher right now. So my day histograms actually accelerating So we're not giving any early warning signals for a pen potential reversal So just watch that because it looks like it could keep on going so economic data wise as I mentioned already China Disappointed across all of their retail sales and industrial production and activity indication Germany's come out with a whole bunch of data and slowed more than some people thought France actually didn't a lot better You got UK employment data due at 930 UK time your zone GDP your zone industrial production US retail sales And of course crude elementary so make sure that you've got all these announcements all set in your calendar Promises to be enough information here enough macro data to have some volatility in the market So should keep that quite interesting and Thursday there's a couple of bits of employment data and PPI But today is the day for most economic data releases So as ever keep your eye on the chart for them make insights part of your leg going forward and join me again tomorrow to find out What happened next?