Gann's Excel tools (updated link)

This is the updated link for the Gann's tool in Excel.

I wish I could remember where I got this Excel file. I have had it for long, just to note that I am not the original author of this file.

All the best.

https://www.mediafire.com/file/7p1i9iaerl32rgf/file

Gann Angles series: Vaastu Shastra and it's cardinal points.

Every enitity even objects like land and buildings are affected by the flows of energy within them. 

Since ancient times civilizations have known this and have tried to utlise this. There are many theories of this. India has vaastu shastra (literally, scieicne of objects) and China has Feng Shui.

The interesting overlap between these sciences, espcially Vaastu Shastra, and Gann's methods is the importance of cardinality i.e. the directions, the varying strength directly proportional to the angles to the centre, and a sine wave of the strenght as the angles traverses aka vibration.

Not going indepth into these sciences, theories and its applications, but just a superficial skim of these concepts and how they apply to markets' vibrations.

So here's a brifiest introduction on Vaastu Shastra. Wikipedia page.

Vaastu shastra, in its essence (in my understanding), is studying the flow/movement, strength and ... of energy in an place. The place here can be building, city, temple or similar. The attempt here is to understand the underlying *significane* of these energies and their impact of people and their welfare. The attempt is to, therefore, manipulate these energies to manifest beneficial aspects. Such a manipulation is usually attempted by creating a flow, opening a channel, building barriers, protecting the energies etc.

From the perspective of Gann's methods, the important point is the the energies of various kinds are maximum at the cardinal points of directions - east, west, north and south. The secondary cardinals are equally important as they form the cusp of the primary directions. The layout of these points and the areas and channels are very similar to the methods of Gann Square of Nine. Below is a Vaastu Shastra and its usual depiction of the energies in form of Sri Vaastu Purusha (God of Vaastu).

Pic source: here

Below is an other image which Gann enthusiasts would find more familiar.

Pic source: here

Almost all efforts in this science is to ensure that the maximum benefit from the Sun can be obtained in terms of light, heat, radiation and thier healing properties, becuase guess what, Sun is the greatest and uncomparable energy source we have. Any structure has to ensure that it is properly aligned and utilizes the Sun's energy to the maximum. That, in succint is the purpose, and the science of Vaastu Shastra.


Now, we will go a little deeper into how the Celtics and Vasstu Shastra can be used in understanding and deploying Gann.

Gann Angles series: Sacred Geometry 1

Couple more detours before we hit the charts.

Gann used astrology and that's beyond dispute. The manner in which he used it could be arguable. Since, not an expert astrologer, my approach is more passive.

Given Gann's assertion of 'vibrations', 'patterns' and 'time', it may be possible to intersect the astrology, pattern and time.

It is said that Gann's Square of Nine was inspired by 'rangoli' in India. I would assume he saw a simple 9-dot rangoli which is widespread in India. The complexity of these patterns increase with more 'dots.'

Rangoli is something like these

 

source: here @ youtube

If it looks similar to the Square of Nine, or a Mandala, it is so becuase they represent the same.

A brief introduction on the rangoli. These are drawn at the doors, corridors, courtyards and other scared places, to 'protect' the area. The patterns drawn are usually the simple patterns of planetary orbits, in essence invoking the protection of the planets and other elements. It has to be said this is one of the most typical behavior of Indian households, businesses and temples. An extremely common occurence.

For instance if you see the relationship of Venus' and Earth's orbits, and the 'dance' in the skies. You see this:

source: Here (check it out)

If the end result looks something like this, its not a coincidence. It is desgined to be so.

Source: Here

There are several sites which have similar, what's called as 'sacred geometry.' Here are bunch of images.

Every planetary orbit differs, and over a single rotation of the outer-planet, makes complex but stable pattern. Below is the orbit of Mercury and Earth. Source. Check out other planetary patterns.

Important: Check out the above source links for more.

To conclude here: It is good to know that these devices of Gann were based on such observations and its attempt to apply to financial markets. You do not have to delve too much into this but remember couple of points.

1. Fibnacci works at all dimensions

2. Almost all (?) these patterns are fractals

3. These patterns are stable

4. In all patterns there are sharp-edges (vortexes), and these points are 'power' points

5. In almost all the cases, these 'cardinal' points are the most stable points

6. Lower the 'sides' to these patterns, stabler the cardinal points

Somethings you can check out. Resources:

Fibonacci and the solar system

Fancy pics!

Orbital Resonance and Solar System

Orbital Patterns

Rangoli examples

Addendum: Remember this pattern?

5-dot Rangoli

Source: Here

Gann Angles series: Gann & Celtic knots - 2

The way to use these imploding and exploding energies depicted by the Celtic patterns is to stack them up. Or in our case with the Gann Angles - Stack them sideways.


1. Point no. 1

So basically, you will have angles going like below:

Angles, going one after the other. In one in-conclusive loop.

2. Point no. 2

However, when you expand the horizon, the 'flow' is not restricted entirely horizontally (for lack of a better word) but also flows vertically (again, for the lack of vocabulary). What it means, is that energy from the 'starting' point in our chart expands to include the next 'section' of the 'angle-set' (vocabulary-issue) but also goes higher.

Like the one shown below:

Here the span of the angles expands as the time flows by.

Why is this important? In most of our charts, this will not come into play. Very rarely does this even matter but when you see this on charts, you are granted a special advantage in knowing where the lines of supports and resistances are.

As it is known, the past has a big impact on future events, even though the memory regarding that fades away. Dates, prices, and angles matter. Market remembers. And, if I may so say, once it happens, the possibility is sort of embedded in the price.

Going along, we will apply these principles to prices. But first, another detour is needed.