gann analysis through excel
gann analysis and trading software
top_corner

 

Documentation

Brochures

Examples

Disclaimer

Privacy

WD Gann

NEWSLETTER

Join our mailing list and stay in touch with the latest GATE news and research

GATE Brochures

Download Brochure

 

home products products client area contact us useful links

Frequently Asked Questions and Questions Raised during GATE Foundations Webinar's

Web001: GATE Setup and Insert/update Markets

Q: When will recordings be available?

Recording will be available as soon as possible after the second webinar has been completed. The target is to have them available within 24 hours – but that may not always be possible. An email will be sent to all Registered participants when they are available.
You will be able to access the Recordings from the Client Area on the www.gatesystem.com.au web site.


Q: Does GATE remember the Historical Data – or Do we need to import it each time?

Yes. You only need to enter the Data once. GATE will save this Data and merge it with any additional data that you supply.
When there is duplicate data – (that is if you supply Historical Data and then also supple End of Day Data for some of those same dates), then GATE will use the following method to remove duplicate data:

Manual Corrections get 1st priority
Then EOD Data
Then Historical Data

This will ensure that the Latest corrections or OED Data is used


Q: Am I allowed to Run GATE on my Laptop as well  as my desktop simultaneously?

Yes. GATE registration allows you to GATE on a Desktop as well as a Laptop


Q: How do I change the Date Format from Profit Source to GATE and visa-versa

You should not have to change Dates. GATE uses the date format that you have set in your Regional Settings in your computer. If the EOD data you are trying to use to update GATE has a different Date format – then please use the Import method to update your Data. In the Import method you can specify the Date format of your EOD data if it is different to your Regional settings


Q: Please show what is stored in the Market Folder

You can see the Workbooks that are saved in the Market folder by looking at the Folder contents on your computer.
The workbooks saved are mainly GATE internal files and much of the data is protected so as to prevent accidental changing of the data.


Q: When I start GATE I get an error. What do I do

Please contact me if you have any problems with GATE.
Start up problems are normally due to:

Excel not being up  to date – Run Microsoft Program Update
The Addin has not been set up properly
You are using the wrong GATE version for your version of Excel. GATE has a separate version for Excel 97/2003 and Excel 2007 and later. Please contact me if you need a different version of GATE


Q: Can we use 4 hour intra day data

No. GATE only works on EOD data at this stage.


Q: Microsoft Updates required.

It is important to keep Microsoft Office updated. For Office 2007 – please ensure that Office SP2 has been installed.


Web002: Risk Reward Calculator and Price Fluctuation Cards

Q: Please explain letters in 4th Col

The 4th Col referred to is the Swing information that is displayed in the Swing Selections list.

In the codes: Q-U, M-ST, W-SB, W-D, etc.
The 1st character is the Swing set being referred to:

Q=Major (Quarterly) swings
M=Intermediate (Monthly) swings
W=Minor (Weekly) swings

The second character refers to whether this is a Swing Step or a Turning Point (Swing Top or Bottom). They are all Swings – however, I am differentiating between the Swing Steps leading into a Turn in the Market and Swing Tops and Bottoms that turn the market.

ST (Swing Top) is a Turning Point that occurs when the previous swing step bottom has been taken out.
SB (Swing Bottom) is a Turning Point that occurs when the previous swing step top has been taken out.


U=Market is Trending Up and this is a Swing Step within that process
D=Market is Trending Down and this is a Swing Step within that process
U-ST=Market was Trending Up – This is the Swing Top before the market steps Down.
U-SB=Market was Trending Up – This is the Swing Top before the market steps Down.




Q: How often do you update your data while using GATE

GATE uses EOD (End of Day) Data. EOD of Day data normally consists of Date, Open, High, Low, Close, Volume and Open Interest.
Occasionally some data suppliers include some additional data such as Time, Market Code, indicator vales, etc.
GATE can accommodate any DATA format – you can tell GATE in which columns your data can be found. The minimum information that GATE requires is:
Date, Open, High, Low, Close, (Volume and Open Interest are recommend –but optional at this stage)
You can do a daily update but the is NOT required. Weekly or even bi-weekly should be sufficient.


Q: When using the Risk Reward Calculator – Can I look at my chart as well

It is strongly recommend that you always use a chart in conjunction with GATE. GATE does not replace a charting package. GATE is a toolkit to assist you with your analysis.


Web003: GANN Fan, Trend line, Price Clusters using Retracements and Projections

Q: Can you analyze Zero angles as well

In Module 5 we look at Zero degree date analysis


Q: Can GATE do GANN Fan in Trading Days

GATE does a number of functions in both Calendar days and  Trading Days. At this point GATE does not do the GANN Fan in Trading Days – but I will include it in the near future – most probably at the conclusion of the Webinars


Q: Can we customize the Projection Percentages

I have included (and added a few more) the standard 1/8th increments for the GANN angles and the standard set of Fibonacci angles.
At this point I do not allow the percentages to be further customized – but will consider it if there is enough interest in it.


Web004: Seasonal Date Calendar, Day Count Calendar

Q: Can GATE handle Public Holidays

GATE does have a Public Holiday facility but I have not mentioned it in any  of the documentation.
This will now be fully implemented and documented within the near future


Q: There are different Public Holidays in different Countries

Yes. A Separate Public Holiday Calendar is kept for each market so that the Client can enter the Public Holiday information for that market.


Q: Are Trading Days NYSE or Australia

GATE calculates a Trading Day as any day for which it finds data, otherwise it is considered to be a Public Holiday or Weekend (or the market is closed). The Country in which the Market operates does not have any influence in the Trading Days.


Q: Do you have a Calendar for Public Holidays so that Trading Days forward work accurately

Yes – this will be fully implemented in future releases of GATE. See answer above.


Q: Some Data suppliers constantly ignore Public Holidays – they repeat the Data of the Day before into the Public Holiday. Can GATE Filter out these errors

GATE does not filter or do any data validation (except to check that the date format is correct). However, I can see that this would be worthwhile considering once I complete the Public Holiday implementation. I will include this as an option in the Data Management Function in the near future


Q: If working with forex data what do you suggest as the start date used for the first section where you explained "seasonal calendar section"

Either use the Birth date or if that is not known or does not exist – then use the Dare of the first Data Bar (GATE will do this automatically by default).


Q: Why is a Sunday considered a trading day

It is not – GATE will accept ANY data – it does NOT do any data validation.


Q: Can the Gann date column be color coded eg Green, Yellow, Red - this would make reading the calendars easier to read

Formatting spread sheets takes up an enormous amount of computer resources. It is easy enough to code, however, to my surprise, whenever I look at performance – it always seems to be in the formatting that takes a lot of computer time and resources..
With computer power increasing – I will have a look at doing some formatting under the control of an Option – so that the older computers are not slowed down too much.


Q: Any chance of being able have GATE use new moon full moon and eclipses

This answer is the same as with the Public Holidays. It is actually already in GATE – I will update the documentation and do final test.


Q: Can you please explain what this information is on the Selected Turning Points in the Day Count Calendar.

GANN teaches that you should maintain a Day Count for significant turns in the Market. This is normally done on a hand drawn chart and takes a lot of time and effort to keep this up to date. If you do maintain this count - then of course you can highlight future cycles on your chart.


GATE does this for you in the Day Count Calendar. You can select any number of Swings for which you want to maintain a Day Count and GATE keep track of the day count and highlight all cycles as they fall due. The data in GATE is displayed in such a manner that it then becomes very easy to see future Date Clusters (that is cycles that fall due on the same date in the future)


The information in the display above is in the information about one of the Swings (Turning Point) that has been included in the Day Count Calendar:
05/May/2005: Date when this Turning Point was made

3926: Price of the Turning Point
Q-Sw L = This Turning Point is a Quarterly Swing Low (a Major time frame so a significant Low) (other codes would be M for Monthly and W for weekly)
8115/5609: 8115 Calendar Days or 5609 Trading Days from the Birth of the Contract to when this Turning point was made. GATE makes it easy to calculate Time Ranges by showing the relative decimal number of a date
1160/268: 1160 Trading weeks or 268 Trading Months from the Birth of the Contract to when this Turning point was made.
37926:Is the degrees from 1900 to when this Turning point was made.


Q: Can you please tell me what these numbers are in the Detail of the Day Count Calendar.

.

Please read this answer in conjunction with the answer to the Question above


As mentioned above -GATE maintains a Day Count for the selected Turning Points. The (yellow) highlighted information is the count information maintained by GATE (Note: You can select to NOT show all the information). The count FROM when this Turning point was made to this Date in the Future (31/Jan/2011 - see the information under the F above) is:

CD:84: The Calendar Day Count - From when the Turning Point was made to this future Date (31Jan2011) is 84 Calendar days
TD:56: The Trading Day Count - From when the Turning Point was made to this future Date (31Jan2011) is 56 Trading days
W:12 M:2 Y:0.2: The Trading Week/Month/Year Count - From when the Turning Point was made to this future Date (31Jan2011) is 12 Trading weeks, 2 Trading Months, 0.2 Trading Years
CD (50%x168): GATE is Highlighting the fact that the Day Count on this day will be 50% of a Cycle that you have selected (168)
53 (6/13/34) 237: A few statistics on the Day COunt (84) - It has occurred 53 times in the past, 6 Included Major (Quarterly) Swings, 13 included Intermediate (Monthly) Swings and 34 included Minor (weekly) swings. It has been 237 Days since the last occurrence of this count.


Q: Why are some Turning Point painted Yellow on the Day Count Calendar?.

.

Please read this answer in conjunction with the answer to the Question above


As mentioned above - GATE maintains a Day Count for the selected Turning Points. The information in the above display refers to additional information about the Selected Turning Point.
In the above example - This is in fact the All TIme High of the SPI (Share Price Index in the Australian Market)
GATE will identify when a selected Turning point is made on the Square of a Time Range.
In this example - the Turning Point was made on 9025 Calendars from the birth of the contract - 9025 is in fact 95 squared.
It was also made on 6242 Trading Days from the birth of the contract - 6242 is in fact 79 squared (within a tolerance of 5).