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

  • #221
  • Dec 7, 2009 12:52pm Dec 7, 2009 12:52pm
Quoting hollandpippin
if yall till have problems with excell or input of data or , or . maybe these indicators can help you....
compaired them to the ecxell sheet and its the same values...

enjoy
thanks but why make it so its unreadable?
  • #222
  • Dec 7, 2009 1:06pm Dec 7, 2009 1:06pm
soce maybe you need some glasses....:nerd:
btw not my indicators...
  • #223
  • Dec 7, 2009 1:13pm Dec 7, 2009 1:13pm
Quoting hollandpippin
soce maybe you need some glasses....:nerd:
btw not my indicators...
they are super tiny on my screen and the currency names are in a light blue.... is there a way to make them larger?
  • #224
  • Dec 8, 2009 2:19am Dec 8, 2009 2:19am
Quoting Chris_B
Sell signal in action on GBPCAD...let's see how it progresses..
ChrisB

How do you get your spreadsheet to look like that? Mine looks a little different then yours.

Also, I am wondering if anyone knows how to change the tf on it.

Cheers
Ezzy
What you do is a reflection of you....what I do is a reflection of me.
  • #225
  • Dec 8, 2009 3:00am Dec 8, 2009 3:00am
Yesterday evening I jumped on to a short in GJ as soon as the signal is received and landed up 60 pip DD but closed with good profit today

The best way to do when you receive the signal is to wait for the
retracement or to place the short when the bid ratio improves

Say for eg you are receving the signal when G overall strenth is say less than 2 and J is 8 and the bid ratio on GJ is say 3 to 4 %. let the
bid ratio improves say may be to 25 % and place the short in a situation
where the volumes are low
  • #226
  • Dec 8, 2009 6:38am Dec 8, 2009 6:38am
Quoting harigp
Yesterday evening I jumped on to a short in GJ as soon as the signal is received and landed up 60 pip DD but closed with good profit today

The best way to do when you receive the signal is to wait for the
retracement or to place the short when the bid ratio improves

Say for eg you are receving the signal when G overall strenth is say less than 2 and J is 8 and the bid ratio on GJ is say 3 to 4 %. let the
bid ratio improves say may be to 25 % and place the short in a situation
where the volumes are low
I'm trying to find the best parameters for SL and TP...

I'm trying with 20 SL and 40 TP but I'm noticing that I'm stopped out frequently...
Sometimes when a signal appears...there is a retrace...and sometimes there is not...I think I have to try a 30 SL and 60 TP... I'm pointing to a 1:2 risk/reward...
Market is like a puzzle, YOU have to fit the pieces!!
  • #227
  • Dec 8, 2009 8:35am Dec 8, 2009 8:35am
Quoting soce
they are super tiny on my screen and the currency names are in a light blue.... is there a way to make them larger?
like i ssaid soce they are not my indicators just with these you dont need that excell file.....
  • #228
  • Dec 8, 2009 12:02pm Dec 8, 2009 12:02pm
I think I fixed my excel file to record the times when we get a different signal. I had all kinds of problems with it because if my feed was temporarily cut off I it would blow up. However, I think I have the proper error handler in there now to keep that from happening and ruining the data collection. If it works, I should have some data moving forward to share with everyone.

Again, the purpose of this data collection is so I can allow it to run all day and tell me when the BUY and SELL signals come up, then go back to the charts and plot a vertical line when they occurred and look at what happened. I simply do not have time to watch all this live during the day and night.
  • #229
  • Dec 8, 2009 12:06pm Dec 8, 2009 12:06pm
For what its worth, I believe this is how I will use this tool. This is my opinion BEFORE having a week of data to look through:

I believe this tool will point me at the pairs that I want to be trading. Since I am a big fan of trading with the trend, this tool will help point out which pairs are not only trending, but which pairs are trending the best across the board average wise.

So my guess is that this will simply tell me which charts to keep an eye on for entries.
  • #230
  • Dec 8, 2009 1:39pm Dec 8, 2009 1:39pm
Hi,

I hope everyone is making profits using the FX Grail excel file. I have downloaded the excel file but when i open the file and enable updates, my excel 2007 program will not respond or hang. Therefore i can't use this. Maybe i have to uninstall my excel.

I am using the FX4caster but it doesn't have the Buy or Sell signal like the excel file posted. However, i still use it to trade the strongest currency against the weakest. Yesterday, i made some nice pips in selling GBP/JPY, selling CAD/JPY and CHF/JPY. I hope u guys make profits too.
Pivot Boss in the making~
  • #231
  • Dec 8, 2009 1:56pm Dec 8, 2009 1:56pm
jurn_e

Nice t0 hear that your making some pips without the excel file. Hope you enabled the excel file under security warning to receive the data and also the dd derver. If you have already done that may be you may have to reinstall the excel

Good luck
  • #232
  • Dec 8, 2009 4:51pm Dec 8, 2009 4:51pm
Quoting andy9775
I have made some changes to the file

-Added a buy/sell section in the strength form
-changed strong weak colors, strong is now green weak is red.

The zip contains two files the forexgrail2007 is a excel 2007 workbook, it may or may not open with other versions forexgrail 2 is a 2003 excel file but not all features may work as I made the edits in 2007. If I made any mistakes let me know as I haven't really tested it yet, just changed values in the total strength to make sure.

Made some updates, download forexgrail2.2 also includes the original...
Very good indicator! Thank you very much!

It would be interesting to add the time when the signal appears or disappears.
What do you think?
  • #233
  • Dec 8, 2009 5:56pm Dec 8, 2009 5:56pm
Quoting balouf
Very good indicator! Thank you very much!

It would be interesting to add the time when the signal appears or disappears.
What do you think?
Thanks I only edited it though, didn't create it. Someone in here is already forward testing it and recording the time vs. signal. Its hard to show a timeline as the data is analyzed live rather then through history/leaving a history. I believe the person testing it said that its already eating up his CPU. There is a mt4 indicator in here that charts the strength which you could use to determine time, but I havent compared it to the excel file.
  • #234
  • Dec 8, 2009 7:47pm Dec 8, 2009 7:47pm
The Xmeter Indy is giving me the exact same values of the xls file...

I'm using the indy at the moment...is less invasive...it has not the buy/sell signals...but is simple to find the signals visually...when a currency goes to the top of the strenght range...and another goes to the bottom of the range..

Today was a good day..

I've been stopped out on CADJPY at my 20 pips stoploss, but made 2 good trades, on AUDJPY +45 pips and GBPJPY + 24 pips.... also CADJPY could be a win of 50/100 pips...if my stoploss was 30 pips...
So starting from today I will try a SL of 30 pips and TP of 60 pips...
Market is like a puzzle, YOU have to fit the pieces!!
  • #235
  • Dec 9, 2009 12:27am Dec 9, 2009 12:27am
Quoting Chris_B
The Xmeter Indy is giving me the exact same values of the xls file...

I'm using the indy at the moment...is less invasive...it has not the buy/sell signals...but is simple to find the signals visually...when a currency goes to the top of the strenght range...and another goes to the bottom of the range..

Today was a good day..

I've been stopped out on CADJPY at my 20 pips stoploss, but made 2 good trades, on AUDJPY +45 pips and GBPJPY + 24 pips.... also CADJPY could be a win of 50/100 pips...if my stoploss was 30 pips...
So starting...
I mean the one that shows history as well, relstrength. It has multiple lines, one for each currency. I just wasnt sure how it got those values (if it followed the excel sheet or not). It would be nice to see the formulas from the excel sheet adapted to a mt4 indicator that could show overall strength rather then spot strength.
  • #236
  • Dec 9, 2009 1:00am Dec 9, 2009 1:00am
I have been experimenting FX trading on demo for 12 months and must have tried at least 100 different trading systems, some with small success but non with long term prospects.
I was lucky to discover this thread before it was moved from Trading Systems, as this is the only section I visit it on a daily basis.
Although its early days I am happy to report that after 2 1/2 days trading with this system I have accumulated 550 pips on 22 positions with no losses and if I had been braver or had a better exit strategy I would have gained even better results.
I would commend this system to others as it is simple and illustrates the basic fundamentals of why markets should move in a certain direction.
Thank you HARIGP for starting this thread it’s a great system which after trying it to the end of the year will enable me, if still performing at this level, to go live in January.
  • #237
  • Dec 9, 2009 2:33am Dec 9, 2009 2:33am
Sell signal on USDJPY some minutes ago...I'm in and up 10 pips for now..

Sl 30 pips

TP 60 pips

I will move my stop to breakeven at 30 pips gain
Attached Image (click to enlarge)
Click to Enlarge Name: meter.gif Size: 12 KB
Market is like a puzzle, YOU have to fit the pieces!!
  • #238
  • Dec 9, 2009 4:36am Dec 9, 2009 4:36am
Quoting Chris_B
Sell signal on USDJPY some minutes ago...I'm in and up 10 pips for now..

Sl 30 pips

TP 60 pips

I will move my stop to breakeven at 30 pips gain
Unlucky trade....

Price went to + 33 pips but i was not at the monitor...
Then retraced and hit the 30pips Stoploss....

I'm now long AUDUSD after the buy signal...


I've found on another forum an EA that works with xMeter...so it does exactly what we are doing here...I will test it..
Market is like a puzzle, YOU have to fit the pieces!!
  • #239
  • Dec 9, 2009 5:26am Dec 9, 2009 5:26am
J was struggling to move above 7 from yesterday onwards

GO LONG IN GJ when the bid raio comes down
  • #240
  • Dec 9, 2009 5:38am Dec 9, 2009 5:38am
Quoting harigp
J was struggling to move above 7 from yesterday onwards

GO LONG IN GJ when the bid raio comes down
What TP and SL are you using??

I'm trying to find the best...
Market is like a puzzle, YOU have to fit the pieces!!
1 trader viewing now