W D Gann Indicators and others - page 6

 
dustovshio:
There are a couple ways to do it. With this new tool (attached) y The xls code isn't working at this time, but can download Open Office for free.

Hi there, are you saying that when we try to use the xls file, it doesn't work properly but if we run it in open office the calculations will be correct?

Also, let me clarify the inputs. Must we input 13 times of previous turning points and 26 prices of high and low bars for each turning time?

Your spreadsheets are very interesting btw!

Meza

 
RickW00716:
I am a little confused about getting the intraday price and time levels.

If I am interested in a potential top, I go from the low and use the 180*angle?

How can I use this to predict the time that this reversal may occur?

Thank you.

There are a couple ways to do it. With this new tool (attached) you can find the angle of price on the wheel of 9. Just type in your 3,4,or 5 digit price without decimal, and all the angles for that particular level are displayed along with their respective prices. Then you add the angle of that price to the angle of time, using either the last hi/low time, 0:00 gmt, or both. See attached chart for examples of both methods.

The other way is to take the difference between the square root of the current price and the square root of the last range between high-low. Use that as an angle and convert to time. See the gbp/jpy chart in the previous post.

When you are getting to the times in question look for price clusters and angles using the price-time calc attached or use the first method taking the square root of the last hi-low adding increments of 1 (180*) and re-squaring. For example if you're coming up on a 180* angle in your price and one of the 3 times based on 3,4, or 5 number calculations is within a few minutes you probably want to exit or take profit.

The xls code isn't working at this time, but can download Open Office for free.

 

12 day formula

I haven't seen this exact formulas on this forum, nor have I seen them published on the web.

If you want to use a 12 day chart you simply draw a circle place the day you want to use as the last high/low at 0* divide that by 360* and use the following angles 45,60,90,120,135, 180, 225, 240, 270, 315, 330, 360. One whole day is equal to 30* moves. If you use a 24 hr chart each minute is .25*, 5 minutes = 1.25*, 1hr 15*.

In forex you can use either 3,4, or 5 digits in your calculations. For daily, long term go with 5, for intraday use 3. I've attached 3 charts the one with the smaller levels used 3, the other two show 4. Of course it is probably best to use both together to see where they coincide. Use the following formula and chart to calculate price:

1. Decide whether to use 3, 4, or 5 numbers for your price.

2. Take the square root of the last high or low.

!3. Add the equivalent decimal for the angle you want.

4. Square the new number.

45* .25

60* .333

90* .50

120* .666

135* .75

180* 1

225* 1.25

240* 1.333

270* 1.5

300* 1.666

315* 1.75

360* 2

Example (see attached chart) gbp/jpy low 241.97

1. use 4197

2. 64.78

3. 65.78 = 1 + 64.78 or 180*

4. 4327 = 1.4327

On the third chart we used the 4299 low as 0* and find the high of 4431 using 4 number calculation, which was 2 pips from the actual high. The time elapsed was 2hr 50m or 42.5* you can now use 42.5* for the next price calculation as follows:

1. Take the square root of actual high of 4433 = 66.58

2. Subtract the square root of the degrees of time you're interested in. In our case the square root of 42.5 is 6.519 so 66.58 - 6.519 = 60.062.

3. subtract your angles - use 1 for 180* 2 for 360* if you're working with low's add your angles.

4. The first level would be 59.062 * 59.062 (60* this translates to 4 hours time.)

5. New target price is 1.4388 see chart "price-time.

 

I found these on another forum...do they work?

Files:
sq9_time.mq4  41 kb
sq9_price.mq4  4 kb
sq9_price.ex4  5 kb
sq9_time.ex4  35 kb
 

The price calculator is correct. It uses 22.5 degree angles on a 5 number price, so you probably want to use it on hourly charts. The calendar looks pretty good, except I'm not sure how it works yet.

Sincerely,

Dustin

 

There should be 2 versions, one for excel and open office. Sorry about the confusion, 12467 was actually the high- see revised chart. Use the high and low prices only. Please download this current revision (attached)- the last version may have had a bug . The xls may actually work; I don't have excel to test it. Do not use the decimal point, just enter 3,4, or 5 numbers like this:

17:15 12467

17:15 2467

17:15 467

Additionally can project the angle of the price from the next 0:00 gmt like this:

0:00 12306 0:00 2306 etc

Notice how close together the times were - all 3 between 21:19 - 22:11, and the last 2 were 5 min apart. Try using the next high of 12464, 2464, and 464 at 23:55 6.14.07 usd/chf and you will be surprised at the results :-) Feel free to post your results and charts.

There are 13 fields so you can compare multiple prices. You don't need to use them all. Sometimes I just use one to determine the angle of a certain price. You can also use functions like geometric mean to compare your 3 numbers and return the mean time, or angle.

Regarding the tables of angles and prices: they don't use the same formula as the square root(price) + angle method. Instead it uses the current price as 0* and the angles 45,60,90 etc added thereafter. Anything over 360* carries over to 0* for example price 49 is 315* so you would get something like 360* 15* 45* etc this way a gap over 360* Note: this doesn't mean the price will jump from like 2411 to 2100 as the angle goes from 350 to 5. What it does mean is that the price may reverse. As you move around the square of 9 you start at the to of a pyramid and work to the base, where it takes more numbers to make a full circle. The interesting thing is that a given level of prices around the square of 9 form a family distinguished by the increment it takes to equal one degree. When you move down the number suddenly jumps, as opposed to increasing in a curvilinear fashion. Using this theory I believe we can identify levels of support and resistance. For example if you see a level change at 180* this is a strong indicator, or if your 3,4,5 rows have similar angles.

-D

Sincerely,

Dustin

 
RickW00716:
I found these on another forum...do they work?

I am curious if anyone else has tried these indicators...I am stil figuring out how the time SQ9 ind. works.

I got these on a forum named "beginnertrader.com"

 
RickW00716:
I am curious if anyone else has tried these indicators...I am stil figuring out how the time SQ9 ind. works. I got these on a forum named "beginnertrader.com"

Hi Rick,

Yes, I am also interested in this method and tried the indicators as well. I tried them on EURUSD, H1 time frame and took June 13, 2007 11:00 (GMT) @1.3271 as starting point, please see the images attached. (The colour horizontal lines are support and resistance lines made by LNX_Pivots_v3.1 indicator)

Well, I see some coincidences on the chart but cannot explain them clearly.

Regards,

Chrisstoff

 
Files:
 

nice charts

The hourly charts look really great. Are you guys using the dotted lines to place entry orders at the price levels? Sincerely, Dustin

p.s. if anyone can help coding an ema please pm me.

Reason: