this is pretty impressive I was just blown away when you sent me this spreadsheet I had no [Music] idea hi everyone I want to introduce you to Alan hiard Allan was my research uh assistant chart Guru and spreadsheet Master for about four years while I was writing the book Alan how are you I'm great Mike thanks for having me how are you good so uh tell everybody a little bit about your history and your qualifications yeah uh basically I've been studying business and finance ever since college and I've had a real


passion for Excel and everything you can do in Excel so I've been crunching numbers and making charts and spreadsheets for everything in my entire life uh for gosh probably close to 20 years uh and uh I spent a few years as a portfolio manager managing over a billion dollars actually um all over the world in different forms of Investments so yeah I've uh really developed a passion for all different investment types and uh it's been a pleasure working on your book with you you used to teaches Excel also right yes I taught


an advanced Excel workshop at the University of Buffalo um and did a little Consulting outside of the University so yeah okay now um before we get going I just want to mention you know like in my last video there was a guy that said um I I watch every one of Mike Malone's videos until he mentions the book and I just want to tell that guy right now you should just unsubscribe alen's going to be doing a lot of videos with me and for four years he worked on that book with me now you contacted me


uh about working with me right yeah like like you said it was over four years ago almost five now actually and in one of your videos you presented a chart and you apologized to the audience you said I'm sorry guys I didn't have time to update this chart before presenting it and I was sitting there in the audience thinking you know it it shouldn't have been that hard to update the chart it's a couple clicks for someone who knows Excel maybe I'll reach out to Mike and and offer to help him so that's what I


did and the rest is history yeah and when we started uh you were traveling through Mexico that's right yeah my in California you left and you went down and so uh and you just got back from India right that's correct yes so the Mexico trip ended up being eight months on the road so I worked remotely there and uh then I was in the states for a few years and then I just took a trip to India for 10 days that was my first time there and it's kind of amazing seeing that part of the world wow okay so one of the things that we're


going to do in this video is revisit uh an amazing chart you put together that you automate you you made it very very automated with some buttons that you click and this was about Echoes of the past uh I had noticed that the um the Elliot waves you know I'm not a technical uh analyst and so every once in a while I make mistakes and I call them A B and C waves it's actually one two and three waves on the way up and uh if you take the beginning of wave one and line it up uh and then the where it


Peaks and turns into wave two uh you line those two up from the 70s bull market to today something amazing happens but there's been a little lag lately I just believe it's the market storing energy so yes show us uh this amazing chart sure my pleasure um so basically what we're looking at here is the price of gold since 197 so this is really when you think about it the entire price history of gold where it was freely traded because before this it was like a flatline fixed at $35 an ounce or $20 an ounce um different


prices throughout history so this yeah and then 1934 it went from 20 to 35 right exactly exactly so actually for over 150 years the price of gold was pegged to the dollar so it was for the most part a flatline so this is is the history of the gold price as it's been freely traded and what we see is basically two bull markets the yellow is one single bull market and it's pretty impressive that's the bull market of the 70s you know I need to uh just pause you there because so many people break that


into two uh separate bull markets and I consider it one bull market with a a consolidation uh in the middle there's there's always you know you've got a secular Bull and there will be a cyclical bear inside of it but it's it's just a correction a pullback from an overbought condition and another thing happened that uh people don't consider when they're looking at that dip from the that's that Peak is the last day of 1974 and then from 75 to I believe August of 76 it fell from uh just under


$200 down to 103 I believe it was like 197 was the peak down to 103 over uh that 16 months or whatever that is uh and but one one of the things people don't realize when uh Roosevelt made private ownership of gold illegal in 1933 and uh they requested all US citizens to turn in their gold coins and bars unless it was a collectible and a collectible then would have meant meant an ancient Roman coin they were call in in all of the uh Gold Eagles uh the the US coinage in circulation the stuff that


that unscrupulous uh gold dealers will tell you is non-conf discc gold uh that was exactly the gold that they were trying to uh get you to turn over it wasn't a confiscation it was a nationalization but uh I believe it was 76 or 78 it was a huge percentage the vast vast majority remained illegally in private hands they it was not turned over to the government now they nobody that had that gold could sell it because you're not so it was illegal and so you couldn't sell it so people were passing


this down from generation to generation from 1933 until the first day of 1975 when it became legal to sell it and so that bare Market uh a lot of it is caused by this uh pent up the these stockpiles of Gold Eagles that and bars that had been uh privately hoarded IL illegally and uh you know passed down and uh you know somebody that inherited this uh just saw it go from $35 to $200 in this short period of time and they're going wow you know we've had this since grandfather died and uh and they they saw it as this huge


opportunity to unload this stuff suddenly so there was a large flood of gold into the markets I've never seen anybody uh write about this uh this was just something that I realized years years ago why was it that that bull that first leg of the bull market ended on the last day of 74 the bare Market started the first day of trading day of 75 so anyway uh so go ahead uh We've we've covered the waves but tell us about that uh first bull market again you were in the middle of that yeah absolutely so I


agree with you that it wouldn't really make sense to split this the 1970s into two separate bull markets it makes more sense to treat it as one for the reasons you just mentioned and the other gold bull market is the one we're in right now and it's really been going on since 1999 2000 so 20 three years uh and and at first glance it might not look like they're very similar but they are because the price of gold moves in a predictable way over and over most assets also have a predictable way that


they move over and over and I want to show that right now let me take the first bull market and just move it over here and then take the second bull market and move it over here and again it probably still doesn't look like they're very similar however they're moving in the same way just over a different period of time and with a different amplitude so very quickly very simply I can just lower the amplitude here and then I can shrink the time that it takes and you'll find that they line


up very shockingly so this this is basically uh the similarity between the two bull markets with a little bit of a Divergence recently which we'll zoom in on in just a second but let me show this to you with numbers attached because I think it'll be pretty impressive so here is the exact same information now let me just interject something um you you made this for me a long time ago and we first presented this in April of 2020 and then again in October of 2020 and uh so anybody that wants to go back and take a


look at all those old videos uh we'll probably put some links in the uh description below uh but uh this is pretty impressive I was just blown away when you sent me this spreadsheet I had no idea you could do stuff like this in Excel now go ahead and show us yes absolutely my pleasure well I have a lot of fun with this as I as I said earlier in the video so anyways um yeah so here is the same information uh we're just going to zoom in a little bit so we can see things more clearly and put some


numbers to it that way we can get an expectation of how big the magnitude will be and when the price might move um much higher so first I'm going to get rid of this blue line because it's part of a bare Market that we're not that interested in then I'm going to take this yellow bull market and expand it so it fills our whole chart okay so I'm just going to stretch it to the right um basically by a factor of two okay so it looks like the 70s bull market yeah the 70s bull market and the yellow line the


70s bull market corresponds with the yellow axes so that's the time across the bottom 10 years and it's also the the price along the left side of the chart so people might not be familiar with that you're probably used to seeing the price on the right but here it is on the left that's the yellow yeah it's very important for everybody to realize that there's two different there's two different data sets here so there's two different scales both time and price yes exactly and another thing that's very


important is that this chart is not linear uh linear charts are like generally more intuitive however logarithmic charts can sometimes show better information so so if you see here along the left side the yellow is starting at $35 an ounce and it's actually multiplying by five to get to 175 and multiplying by five again to get to 875 so so each each uh measurement on the chart whether it was an inch or whatever is the same percentage change as the next inch and the next inch correct yes exactly so with a linear


chart we're used to a fixed distance being an an added amount so you might add five each time in a logarithmic chart it's multiplied by the same amount each time so yeah it's uh the numbers grow a lot faster let's put it that way so okay and it's and it's logarithmic for the yellow and for the green so the green is the bull market we're in now which started in August of 1999 uh and let's let's line up those waves like I just showed a minute ago um so just little bit by little bit I'm


just trying to line up that first wave whether it's the a wve or the one wave whichever one we call it uh might look something like that and then we can move it vertically a little bit and I should point out that this isn't a precise science where we can you know round or we can say like to a specific dollar number or specific date it's it's approximate it's approximate I think people know that but I'll say it just in case so I think right there looks about good um and you can see that these


lineup really well with a Divergence and this Divergence actually happened about two or three years ago which happens to be the last time we presented this chart so let me pause there Mike what do what do you think is causing this price Divergence did anything happen in the last two or three years uh well yeah we had lock downs we had a pandemic some pretty pretty big stuff has happened since we uh first presented this chart yes yeah absolutely absolutely so um maybe maybe the first starting point is if this had continued


what would have happened well maybe around February of 2024 maybe gold would have been around $1,000 an ounce if it continued remember this is logarithmic so it grows very quickly and it could be about five times or in this case six times with my my Axis here on the right um from where it is now so that could have happened but it didn't um and so do you think Mike that I mean is all hope lost or are we going down from here or are we going up from here maybe we should do some technical analysis what


do you think well I think that uh you know you have to take a look at a whole bunch of other balancing factors when you're looking at gold and trying to decide well which way would it move from here up or down have we resolved yet the gold Dow gold ratio the value of gold compared to the stock markets and the answer is no gold has not risen enough or stocks have not Fallen enough for that to uh once again go back into balance uh have we resolved the gold real estate ratio the gold oil ratio the


gold M2 currency Supply ratio the gold base base currency ratio uh there's just there I can't think of any other way of measuring gold as a balance to the economy considering the peak that it went into in 1980 or the mean the the or the median um it hasn't reached any of these yet and uh and so uh another thing you have to think about is you know we've slammed up interest rates so fast we already had the first leg of the B banking crisis but I believe it is far from over and that there is uh more yet to unfold when


it comes to a a crisis and so is the Central Bank going to print more currency that's the big question as far as what direction is this going to pick up or down is is the bank ever going to print the Central Bank Federal Reserve are they going to print more currency someday to me the answer is yes they will yes I agree I agree right right uh that's my opinion on it so uh go ahead and continue with what you were uh showing us here hi I just wanted to take a moment and thank you for subscribing


and mention that if you'd like to help our Channel please consider my company goldsilver.com the next time you buy precious metals we're one of the most trusted names in the industry our prices are sharp delivery is fast and we have an insiders program where you find out exactly what I'm doing with my own investment thanks for making Golds silver.com your dealer and now back to the video yeah so really the last thing I want to show is sort of um basically how much energy is really being pent up here like I I can't


imagine that after this this pan and handle or cup and handle I can't imagine that the price would go lower not meaningfully there there may of course be a short-term pullback and um actually I'll show that in just a second um but let me do two quick um technical analyses here so uh let me let me just draw a squiggle uh let's get away from the numbers and keep it nice and simple and for anyone who hasn't seen a pan and handle we can draw it like this and it's maybe maybe a bit uh small so let's


let's thicken that up a little bit and so it would look like this pan and handle and this for for a tech Tech analyst is a bullish sign so after it goes after it goes like there a big dip and then sideways it tends to explode up so that's one that's the first sign let's let's keep an eye on that and then a second one is a inverse head and shoulders so a head and shoulders um you know what I should probably zoom in for this but let me just let me just draw it like this head and


shoulders people have seen this I think mhm and let me make that big so we can see it and then what I'm going to do is invert it and put it on the chart here but let's actually change change our axes that way we can we can zoom in I'm going to zoom in uh let's let's go from like 2009 okay so this is our big our big pan and handle can you um way over here whoops can you uh start the price at like 810 and and uh end it at 2500 or something 800 to 2500 oh of course of course yeah


that way we can zoom in and and really see that uh let's go 810 and now we can see our okay so you're saying uh 2430 absolutely I love doing this Excel is beautiful Excel is beautiful so this is our pan and handle um we can see that and so it may it may continue to go sideways a bit longer um you know we don't know but that tends to be a bullish indicator the longer it goes sideways though with emergencies uh printing of currency uh the bigger the move the more energy it stores basically


the more it lags behind other factors in the economy the stock market the uh uh the printing of currency whatever uh the bigger the I'm I'm expecting a slingshot move uh once it gets up past resistance so keep on going sorry yes and so just finishing with our head and shoulders uh we can actually see a inverse Head and Shoulders pattern forming right here sort of looks sort of looks like this and and this is actually what I alluded to a minute ago when I said we might get a short-term temporary pullback forming


the base of that last shoulder it's very possible but I can't imagine with all this energy pent up that gold goes meaningfully lower for a long time I I just can't see that happening it doesn't make sense on a technical level or a fundamental level and as and as you said right with all those things going on in the economy the basic question is are the central banks going to keep printing currency the answer is obviously yes so because of this pattern because of this other pattern because of all the


fundamentals I I see gold exploding higher and the last thing I'll add in case you want to go there I'll just I'll just put the seed out there um if we remember how the price of gold throughout history was fixed by law for so many years 150 years 170 years and has really only been freely traded 50 or 60 years uh it's quite possible that the United States or a world government creates a goldback currency we've seen the bricks you know moving in that direction we've seen the IMF um you know


whispering in that way if there comes a currency that is backed by gold and the dollar is somehow pegged to that currency we could see a increase by law that just goes straight vertical by a factor of two three five 10 who knows um right you know that that is a possibility to happen in the near future yep and and with that I think uh that we should uh wrap up this video so I want to thank you for all of this information uh the audience can look forward to you being in a lot more of these videos uh now I want to say


something regarding the book uh there was only about the book is just loaded full of charts but for every chart that exists in the book I probably had Allan do 30 50 maybe 80 charts so the number of chart in fact there was a whole chapter in the book The chapter ended up being close to a 100 pages long I decided Well that's got to be a separate book and it is it that one chapter I don't know it had at least 50 charts in in that chapter and those were the finished charts not the all all of the


ones I had to do over and over and present them in different formats I drove Allan nuts for four years so I want to thank you for all of your help and for creating that amazing chart and the great analysis that you just gave of it oh thank you Mike I appreciate the opportunity for the book and and to uh present here on YouTube and looking forward to a lot more so thank you okay we'll see you next time hi I just wanted to tell you about gold Silver's o Silver giveaway where you can win win win one one one 1 oz silver bar


one 10 oz silver bar and one 100 o silver bar so enter today and win