Forexgrail excel indicator | Page 6 | 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

  • #101
  • Dec 4, 2009 6:05am Dec 4, 2009 6:05am
Any thing can be done to add volume also in the spread sheet
  • #102
  • Dec 4, 2009 6:15am Dec 4, 2009 6:15am
This spread sheet was developed in 2007

LOL GJ and AJ is flying

So far no signal on GU but when you look at the chart it is moving up
  • #103
  • Dec 4, 2009 6:15am Dec 4, 2009 6:15am
Just made 2 little scalps on my DEMO account on GBPJPY after 2 new buy signals...
Just to test the waters...
Attached Image (click to enlarge)
Click to Enlarge Name: gbpjpy.gif Size: 23 KB
Market is like a puzzle, YOU have to fit the pieces!!
  • #104
  • Dec 4, 2009 6:29am Dec 4, 2009 6:29am
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,
sat there and watched it last night at 24 hour roll over and everything goes to zero. the pip ranges reset, etc.... I think that you would want to give this thing several hours minimum and probably at least a couple of news events before touching it.
  • #105
  • Dec 4, 2009 7:03am Dec 4, 2009 7:03am
http://clip2net.com/clip/m0/12599317....png?nocache=1

why my excel donīt work???just cad and jpy work..i need help..thanks!
  • #106
  • Dec 4, 2009 7:04am Dec 4, 2009 7:04am
Hi All,

on demo this morning before NFP i took 3 trades and have just closed them with a total of 100 + pips, this system looks good and will be trailing it for a bit yet
working on 1 hour charts it seems good but first impressions, on 3 trades mind you, that it seems to give a buy signal once price closes above DP

Keep it going

Paul B
  • #107
  • Dec 4, 2009 7:06am Dec 4, 2009 7:06am
I want to back test this thing. Here is what I am thinking but I am hoping someone can help me figure out an easier way.

 

  1. download all of the data from HISTORY on the MT4 platform. I am thinking 5 minute data and maybe 1 month of it for now.
  2. have to create the following values on the charts
  3. unique time identifier for each value
  4. daily high and low which calculates for every time (this one bogs me down big time with all this data because I end up with an If(max) type of deal
  5. ability to cycle through the day at 5 minutes at a time and watch the values
  6. record price when we get a strong buy or sell signal
  7. somehow record what prices does after

My biggest hurdle here is the daily high and low. I do NOT want to have to manually input those equations so I need to figure out a way to do that automatically pending on what day in history I am looking at.

Any thoughts, suggestions are much needed and welcomed.

  • #108
  • Dec 4, 2009 7:08am Dec 4, 2009 7:08am
Quoting pbalfe@tisca
Hi All,

on demo this morning before NFP i took 3 trades and have just closed them with a total of 100 + pips, this system looks good and will be trailing it for a bit yet
working on 1 hour charts it seems good but first impressions, on 3 trades mind you, that it seems to give a buy signal once price closes above DP

Keep it going

Paul B
this spreadsheet does nothing more then let you know if the price is TRENDING so therefore you will always be buying and selling into "over bought" and "over sold" areas because that is how something TRENDS versus consolidates. If you have any questions about this let me know.
  • #109
  • Dec 4, 2009 7:42am Dec 4, 2009 7:42am
Let's say that a trader today entered in GBPJPY at the first or second buy signal...
Trailed his stop....was in position....

Trade still open at the NFP news....

Here's the result...a very very good day...with the 130 pips move after the news plus the pips locked in trailing the stop...

Let's say 200 pips?? A very good day..

Unfortunately...i'm not that trader...
Attached Image (click to enlarge)
Click to Enlarge Name: gj.gif Size: 10 KB
Market is like a puzzle, YOU have to fit the pieces!!
  • #110
  • Dec 4, 2009 7:43am Dec 4, 2009 7:43am
amazing... so far every trade I have placed has been profitable. of course I am placing them with zero SL. I think rather then backtest I will change the spreadsheet to forward test and track entries. Then we can go back and look at every entry that would have been placed and discuss.
  • #111
  • Dec 4, 2009 7:52am Dec 4, 2009 7:52am
Quoting Chris_B
Let's say that a trader today entered in GBPJPY at the first or second buy signal...
Trailed his stop....was in position....

Trade still open at the NFP news....

Here's the result...a very very good day...with the 130 pips move after the news plus the pips locked in trailing the stop...

Let's say 200 pips?? A very good day..

Unfortunately...i'm not that trader...
Well It's a Russian roulette. And it could go Either way really.
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
  • #112
  • Dec 4, 2009 8:02am Dec 4, 2009 8:02am
Quoting SkyzerFX
Well It's a Russian roulette. And it could go Either way really.
Agree.... I think.... however, every trade I have entered is making cash. I am like 7 for 7 now.
  • #113
  • Dec 4, 2009 8:03am Dec 4, 2009 8:03am
Quoting SkyzerFX
Well It's a Russian roulette. And it could go Either way really.
Yes...but I'm talking about having a profit yet...with a stop loss setted..
Market is like a puzzle, YOU have to fit the pieces!!
  • #114
  • Dec 4, 2009 8:03am Dec 4, 2009 8:03am
Quoting SkyzerFX
Well It's a Russian roulette. And it could go Either way really.
leave it to the big boys to ride the NFP train, stay out and come back next week when they are all nursing hangovers

Paul B
  • #115
  • Dec 4, 2009 8:13am Dec 4, 2009 8:13am
Quoting pbalfe@tisca
Hi All,

on demo this morning before NFP i took 3 trades and have just closed them with a total of 100 + pips, this system looks good and will be trailing it for a bit yet
working on 1 hour charts it seems good but first impressions, on 3 trades mind you, that it seems to give a buy signal once price closes above DP

Keep it going

Paul B
It basically gives a buy/sell in relation to the Daily Pivot...if you can get a cross of DP on 1H then confirm it on 15M...you're good
  • #116
  • Dec 4, 2009 8:15am Dec 4, 2009 8:15am
Quoting pilotui
It basically gives a buy/sell in relation to the Daily Pivot...if you can get a cross of DP on 1H then confirm it on 15M...you're good
yep, totally agree

has anyone got a signal indicator that lets you know when the price has crossed the DP, would be a time saver

Paul B
  • #117
  • Dec 4, 2009 8:33am Dec 4, 2009 8:33am
Well hold up, its more then that because its taking an AVERAGE of all cross currencies. So its comparing the USD in 6 pairs and telling you where the average price level is across all 6. This is the "beauty" of this tool.
  • #118
  • Dec 4, 2009 8:39am Dec 4, 2009 8:39am
Quoting soce
Well hold up, its more then that because its taking an AVERAGE of all cross currencies. So its comparing the USD in 6 pairs and telling you where the average price level is across all 6. This is the "beauty" of this tool.
I agree...it's not a simple day pivot cross...

It reveals wich is the best pair to trade...watching at the strenght...and then gives buy/sell signals based on when 2 currencies become very strong or very weak...those are the moments where there is the highest probability for a move...

And then...in just a look it gives me an idea of wich pairs to wacth...without have all the charts open...but focusing only on the best charts..

It's not a grail (despite the name) but I find it useful..
Market is like a puzzle, YOU have to fit the pieces!!
  • #119
  • Dec 4, 2009 8:45am Dec 4, 2009 8:45am
Quoting Chris_B
I agree...it's not a simple day pivot cross...

It reveals wich is the best pair to trade...watching at the strenght...and then gives buy/sell signals based on when 2 currencies become very strong or very weak...those are the moments where there is the highest probability for a move...

And then...in just a look it gives me an idea of wich pairs to wacth...without have all the charts open...but focusing only on the best charts..

It's not a grail (despite the name) but I find it useful..
agree... however, thus far it is doing AMAZINGLY well for my demo account! LOL

I am going to figure out how to record all BUY and SELL signals moving forward so I can forward track this thing. Trying to back test it would be too difficult as the data becomes to huge in excel. However, I can forward test it and simply record the changes in events and then go back and study them at the day's end.
  • #120
  • Dec 4, 2009 9:03am Dec 4, 2009 9:03am
Quoting Maklla
why does my sheet not look right? it has written value over most pairs.the numbers are jumping up and down in the uper box but the lower boxes say value on most currency
any thoughts how to fix this
thanx

Look at your values for example in EUR/USD field

15141.0000

Excel formula cannot be calculated based on this BS! And that's because you have 5-digits broker

Open Demo Acc on 4-digit broker like Forex.com for example (I have file for it with already fixed values which is working)

Values in your Excel spread sheet should look normal like

1.5141 (then it will be calculated properly)
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
2 traders viewing now