Forexgrail excel indicator | Page 5 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Indicator to draw lines from excel csv into MT4 1 reply

Pip change indicator on Excel for timing entries near pivots 0 replies

Converting an Excel equation into an MT4 indicator 0 replies

Output Indicator from MT4 to Excel 0 replies

Attachments: Forexgrail excel indicator
Exit Attachments

Forexgrail excel indicator

  • #81
  • Dec 4, 2009 4:05am Dec 4, 2009 4:05am
Hi andy 9775

Wonderful

by the way my GU LONG hit with profit but the DD was 50 pip
  • #82
  • Dec 4, 2009 4:05am Dec 4, 2009 4:05am
i still cant get this working properly.i tryed everything you guys recommended and tryed all the sheets posted in the thread and still isnt showing me values for all pairs.any ideas guys?
  • #83
  • Dec 4, 2009 4:12am Dec 4, 2009 4:12am
It doesn't work for me either. I think it has something to do with the currency symbols. My forex broker which is ibfx uses letter m following the symbols for mini acct. I hope that Andy and anyone out there could fix it.

Thanks alot guys.
  • #84
  • Dec 4, 2009 4:14am Dec 4, 2009 4:14am
Quoting Maklla
i still cant get this working properly.i tryed everything you guys recommended and tryed all the sheets posted in the thread and still isnt showing me values for all pairs.any ideas guys?
Its been mentioned but the only thing I can think of is that I belive that fxdd uses different mt4 currency pair codes. try this, with mt4 running enter
='mt4'|bid!eurusd
if it still doesnt work its in the way fxdd sends there currency codes are different.
  • #85
  • Dec 4, 2009 4:15am Dec 4, 2009 4:15am
Quoting Maklla
i still cant get this working properly.i tryed everything you guys recommended and tryed all the sheets posted in the thread and still isnt showing me values for all pairs.any ideas guys?
I had the same problem...try this...for me solved the problem:

go in Windows Control Panel
Go in International Options
Chose Customize
And make sure you have "." in the first row and "," in the third row...

Hope it helps
Market is like a puzzle, YOU have to fit the pieces!!
  • #86
  • Dec 4, 2009 5:00am Dec 4, 2009 5:00am
Hi HARIGP,

Thank you for posting the grail! Quick question: Does the system reset itself or do we reset it manual?

Stands to reason that the given strength of the pairs does not go on for ever. For example if a pair closes at it's daily high this establishes that it open at the a neutral strength the next trading day. It has not yet made a high or a low for the day. Does the system account for this?

Thank you again,
  • #87
  • Dec 4, 2009 5:06am Dec 4, 2009 5:06am
Hi Pulsar

Needs to check this

Any one gone long in GJ BASED on buy signal would have got 40 pip now
  • #88
  • Dec 4, 2009 5:07am Dec 4, 2009 5:07am
Quoting Pulsar1
Hi HARIGP,

Thank you for posting the grail! Quick question: Does the system reset itself or do we reset it manual?

Stands to reason that the given strength of the pairs does not go on for ever. For example if a pair closes at it's daily high this establishes that it open at the a neutral strength the next trading day. It has not yet made a high or a low for the day. Does the system account for this?

Thank you again,
From looking at it I see that it grabs the daily high/low based on the mt4 server so it resets at midnight.
  • #89
  • Dec 4, 2009 5:22am Dec 4, 2009 5:22am
Quoting Chris_B
I had the same problem...try this...for me solved the problem:

go in Windows Control Panel
Go in International Options
Chose Customize
And make sure you have "." in the first row and "," in the third row...

Hope it helps
working now thank you
  • #90
  • Dec 4, 2009 5:33am Dec 4, 2009 5:33am
Quoting andy9775
From looking at it I see that it grabs the daily high/low based on the mt4 server so it resets at midnight.
Ok, makes sense. Will try it today and report results back to you. So far it looks promising.
  • #91
  • Dec 4, 2009 5:35am Dec 4, 2009 5:35am
I updated again, this time bid ratio is added.
Attached Image (click to enlarge)
Click to Enlarge Name: grail.jpg Size: 103 KB
Attached File(s)
File Type: zip Forex Grail2.3.zip   395 KB | 1,176 downloads
  • #92
  • Dec 4, 2009 5:43am Dec 4, 2009 5:43am
Quoting andy9775
I updated again, this time bid ratio is added.
Hi,

Just saw this thread... This is a work of art. I will watch it during news.

Kudos.
  • #93
  • Dec 4, 2009 5:49am Dec 4, 2009 5:49am
It looks like the buy/sell signals work quite well...

And it seems that the bid ratio has no much value...like others overbought/oversold indys..

For example GBPJPY is above 95% from about 1 hour...but has rised up 50 pips after the buy signal...
Market is like a puzzle, YOU have to fit the pieces!!
  • #94
  • Dec 4, 2009 5:53am Dec 4, 2009 5:53am
Quoting harigp
Hi Pulsar

Needs to check this

Any one gone long in GJ BASED on buy signal would have got 40 pip now
Sorry for the silly question: "the signal" is when one currency is "strong" and the other "weak"? If so, then there was a signal about an hour ago for GBPJPY and then about 30 minutes back CADJPY and AUDJPY. All of them went up.

But, aren't you afraid the bid ratio is nearly 99.99% - oversold? I watched it and they still went up, even if bid ratio was so high.

Just my first observations. Thanks!
  • #95
  • Dec 4, 2009 5:54am Dec 4, 2009 5:54am
Quoting andy9775
I updated again, this time bid ratio is added.
I was going to do the same thing today during NFP...very nice work.

Also like the color changes...what was the original author thinking that Blue=weak, Red= strong?


Thanks for your efforts!
  • #96
  • Dec 4, 2009 5:54am Dec 4, 2009 5:54am
Quoting Chris_B
It looks like the buy/sell signals work quite well...

And it seems that the bid ratio has no much value...like others overbought/oversell indys..

For example GBPJPY is above 95% from about 1 hour...but has rised up 50 pips after the buy signal...
You need to check and confirm OB or OS thresholds in at least 2 different TF's (3 is better). i.e. 15M, 1H and 4H.

Just checking in one single TF alone is not correct and will lead to false signals or entries.
  • #97
  • Dec 4, 2009 5:55am Dec 4, 2009 5:55am
Quoting hotstorm
Sorry for the silly question: "the signal" is when one currency is "strong" and the other "weak"? If so, then there was a signal about an hour ago for GBPJPY and then about 30 minutes back CADJPY and AUDJPY. All of them went up.

But, aren't you afraid the bid ratio is nearly 99.99% - oversold? I watched it and they still went up, even if bid ratio was so high.

Just my first observations. Thanks!
I agree...as I said in my previous post...I think that overbought/oversold indys are useless most of the times... when there is a strong trend with strenght...overbought or oversold means nothing...IMHO
Market is like a puzzle, YOU have to fit the pieces!!
  • #98
  • Dec 4, 2009 6:02am Dec 4, 2009 6:02am
does anyone have ibfx broker and is able to run the excel program? I still can't get it running. Thanks
  • #99
  • Dec 4, 2009 6:03am Dec 4, 2009 6:03am
Some minutes ago a buy signal on CADJPY has anticipated the news :-)

Anybody took this??
Attached Image (click to enlarge)
Click to Enlarge Name: cadjpy.gif Size: 11 KB
Market is like a puzzle, YOU have to fit the pieces!!
  • #100
  • Dec 4, 2009 6:03am Dec 4, 2009 6:03am
Quoting pilotui
I was going to do the same thing today during NFP...very nice work.

Also like the color changes...what was the original author thinking that Blue=weak, Red= strong?


Thanks for your efforts!
No worries. Yes the blue, red was confusing me aswell. I was also looking at the bid ratio right now and all it seems to do is tell you the retracement, as of now eur/usd is at 50 and drawing a fib shows it right at 50, Im gonna have to change the colors and make it say 50 or 61.8 and then it can be used for ab-cd. If at 61.8 and green then enter long sort of thing.
1 trader viewing now