# Excel Formula To Figure Out Number Of Months Between Dates If W. D. Gann Had a Secret

You are searching about Excel Formula To Figure Out Number Of Months Between Dates, today we will share with you article about Excel Formula To Figure Out Number Of Months Between Dates was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Formula To Figure Out Number Of Months Between Dates is useful to you.

Muc lục nội dung

## If W. D. Gann Had a Secret

…we don’t know. From all the released information I’ve had access to, it seems to me that Gan has probably taken his last secret to the grave. And what could that be? Perhaps the method to know with almost 100% certainty when the price will hit the next major top or bottom and what day it will fall.

So, why do I often talk so much about WD Gann, praising his methods? Because what I have learned from the information available to us today, secret or no secret, has opened the door to many fantastic and incredible discoveries of my own.

Credit should be given where credit is due. If legends like WD Gann hadn’t published what they did, whether their motives were purely profit or partially philanthropic, it would have been very difficult to come up with many current discoveries or understandings about market behavior.

When we read about the exploits of WD Gann, we are reminded of his remarkable wheat call before the author of The Ticker and Investment Digest in the early 20th century. We are reminded that he had the ability to turn small sums into very large ones in a short time.

“One of the most amazing calculations Mr. Gan made was during last summer [1909] When he predicted that September wheat would sell for \$1.20. This means it has to touch this mark before the end of the month of September. At twelve o’clock, Chicago time, on September 30 (the last day) the option was trading below \$1.08, and it seemed that his prediction would not be fulfilled.

Mr Gan said, ‘If it doesn’t touch \$1.20 at the market close, it will prove that there is something wrong with my whole calculation method. I don’t care what the price is now, I have to go there.’ It is common history that September wheat surprised the entire country by selling at \$1.20 and closing at that figure in the final hours of trading.

“During the month of October, 1909, during twenty-five market days, Mr. Gann, in the presence of our representative, made two hundred and eighty-six transactions in various stocks, both on the long and short sides of the market. One hundred and sixty-four of these transactions resulted in profits, twenty-two losses.”

The fact that WD Gann is a legend is without dispute. His popularity is increasing year by year. And with such exposure, both myth and fact are intertwined, debates rage whether he got rich from business or from selling books and courses. Indeed, debate continues as to whether he died rich.

I’m convinced that WD Gann actually had many secrets to predicting market tops and bottoms, and he didn’t reveal his most powerful. And I’m also convinced that he shared enough information, albeit spread over metaphors, that anyone serious enough about the undertaking could glean enough to improve his or her market timing skills many times over.

My conviction was the first argument. You see, whether WD Gann got rich from business or selling books and courses doesn’t take away from his genius. It’s a fact that WD Gunn sold courses and seminars that cost the price of a single family home at the time. Only a person with recognized talent can pull it off. Who today, admired in the business industry, can put together a seminar or course for home value? Nobody is.

Now that this argument helped convince me of WD Gann’s legitimacy, it helped me consider his printed works seriously enough to at least get something out of it. And boy was that the right move!

Over the past 6 years I have researched as much as I could get my hands on about WD Gann and his teachings. I’ve read his inexpensive books as well as his extensive (and more expensive) trading course. I have searched the web from top to bottom looking for any bits and pieces I can find. Bottom line: This man was actually a genius.

I’m sure what I’ve gathered from my research is only a fraction of what the man has to offer. Maybe someone out there has the last whisper of a dying genius under lock and key. Who really knows? But what I gathered, in its apparent limited scope, was enough to open so many wonderful doors for me in the field of market analysis and forecasting that I will forever be indebted to Mr. Gann and others like him.

The Gan Wheel, also known as the Square of Nine, is a wonderful tool. It has been sold and oversold for years. Many treat it as nothing more than a useless product to put money in the pockets of those who sell it. Oh, how foolish! Although I have long gone beyond using this tool for forecasting, it opens your mind to the wonderful mysteries of the universe. It is as if everything around us can be explained by mathematics, as everything seems to be related to something else.

Oh, I could wax poetic on this for a long time. But I’m sure you’d rather stick to the point. With the Square of Nine, you can get to the point of making many predictions with incredible accuracy with good practice. Perhaps you do not know the exact price of wheat or live cattle for a particular day. But then, maybe you can. I have found a well appreciated tool for working with prices to reach a set of resistance or support prices for a day, instead of standing on a soapbox corn goes to 205 and isn’t sure. One more tick. That kind of information would be nice to know, but it’s not necessary to make a profit in trading.

There are several tools in my arsenal for market forecasting that are used to forecast timing and price. I have varying degrees of confidence in each. Over the years, I have learned to use all the tools at the right time based on the circumstances to make the most incredible market forecasts. Of course my goal is to achieve 100% accuracy with 100% consistency. Without such a goal I would simply sit on my hands and the search would be closed to me personally. Reaching such a goal would be considered impossible by almost everyone, and perhaps so, you should never convince yourself of it if you want to reach beyond the masses.

WD Gann had his secrets and he probably died with some pretty good people to his grave. And we know he wasn’t 100% accurate with 100% consistency because we read that he won x number of y trades. Amazing feat, not even 100% perfect. But I have no doubt that WD Gann ever thought he wouldn’t be able to achieve that lofty goal. To achieve any real success you need to believe that you can achieve the impossible. In fact, nothing is impossible to achieve. Only two things usually get in the way of achieving your end goal; you and time

If you believe, you can achieve. TIME only shortens the course. We just run out of time and pass away, and that’s what happened to WD Gann. If WD Gann were alive today, he would be very close to achieving the impossible. Anyone of us who believes that a goal is attainable and puts aside any negative thoughts of failure, which puts effort into supporting the idea, will achieve more but ultimately fall short by TIME. But there is no reason to give up.

Anytime we take on the great works of a legend like WD Gann, we help extend his time. What we gather from Gan and others like him, we carry forward towards the ultimate goal. When we study and research with integrity and honesty, we open new doors of discovery for future generations if those new discoveries, in whole or in part, are shared. This sharing can be distributed in pieces between several books and perhaps seminars. Whether the purpose of the partnership is for profit or some charitable cause, each piece of the puzzle will contribute to the overall puzzle that could one day be yours.

Perhaps WD Gunn didn’t die with his secret, because it may have been something he always encouraged…never to learn and believe.

## Question about Excel Formula To Figure Out Number Of Months Between Dates

If you have any questions about Excel Formula To Figure Out Number Of Months Between Dates, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Excel Formula To Figure Out Number Of Months Between Dates was compiled by me and my team from many sources. If you find the article Excel Formula To Figure Out Number Of Months Between Dates helpful to you, please support the team Like or Share!

Rate: 4-5 stars
Ratings: 5824
Views: 79484758

## Search keywords Excel Formula To Figure Out Number Of Months Between Dates

Excel Formula To Figure Out Number Of Months Between Dates
way Excel Formula To Figure Out Number Of Months Between Dates
tutorial Excel Formula To Figure Out Number Of Months Between Dates
Excel Formula To Figure Out Number Of Months Between Dates free
#Gann #Secret