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

  • #121
  • Dec 4, 2009 9:05am Dec 4, 2009 9:05am
Quoting andy9775
I updated again, this time bid ratio is added.
Your improved version looks good and simple to understand but do the changing colours on the pairs relate to the bid ratio and how do you interprite these figures and use them in placing positions?
Koyco
  • #122
  • Dec 4, 2009 9:05am Dec 4, 2009 9:05am
Quoting SkyzerFX
Look at your values for example in EUR/USD field

15141.0000

It cannot calculate 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)


5 digits is not the problem...I have 5 digits and it works perfectly...
The problem was in Windows International Options Settings...I think he has solved the problem now..
Market is like a puzzle, YOU have to fit the pieces!!
  • #123
  • Dec 4, 2009 9:28am Dec 4, 2009 9:28am
Quoting marcelomt
http://clip2net.com/clip/m0/12599317....png?nocache=1

why my excel donīt work???just cad and jpy work..i need help..thanks!
Maybe here is the solution?

http://www.forexfactory.com/showpost...3&postcount=85
  • #124
  • Dec 4, 2009 10:10am Dec 4, 2009 10:10am
Ok guys good to know that this spread sheet is useful and makes pip in trending market. I take my word back on Bid ratio it seems to have no relvence in the trending market.

I was complaining why the GU is not giving buy signal but noticed that US got strong with EU

Andy 9775 good work on the signal Tabel and we expect more from you
in terms of colour etc

We will see how it goes next week
  • #125
  • Dec 4, 2009 10:14am Dec 4, 2009 10:14am
how do I post pictures of things I have done with the sheet to this thread?
  • #126
  • Dec 4, 2009 10:20am Dec 4, 2009 10:20am
Quoting Chris_B
5 digits is not the problem...I have 5 digits and it works perfectly...
The problem was in Windows International Options Settings...I think he has solved the problem now..
fine for me as well, gives signals good on my odl platform

Paul B
  • #127
  • Dec 4, 2009 10:21am Dec 4, 2009 10:21am
soce

go to mangment attachemnt and click their and you will see the upload section and upload it from their

Managment attachment is down in the replay section
  • #128
  • Dec 4, 2009 10:21am Dec 4, 2009 10:21am
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.
Yep LOL

Your'e right, just trying to ultra lazy

Paul B
  • #129
  • Dec 4, 2009 10:26am Dec 4, 2009 10:26am
It's good tool to observe what is going on. But this is very
similar to the stock market. When everybody is Buying you actually
have to sell and vise versa. I'm waiting EURO at the trade line
1.4865. This Dollar rally will die in few hours..
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
  • #130
  • Dec 4, 2009 10:26am Dec 4, 2009 10:26am
Lets see if this works
Attached Image
  • #131
  • Dec 4, 2009 10:28am Dec 4, 2009 10:28am
blaaah, its all compressed and hard to see. first version told me it was too big. anyways, I will try to clean it up and get a tracker running so I can "catch" every buy and sell signal next week and then analyze this. In mean time I will continue to trade demo (up 5% on account in 2 days LOL) and see where that takes me.
  • #132
  • Dec 4, 2009 10:33am Dec 4, 2009 10:33am
Can we all agree that the "weights" at the top do nothing?
  • #133
  • Dec 4, 2009 10:33am Dec 4, 2009 10:33am
Soce, could you please explain what you actually doing with that data?

Are you Using that new form added and when it says sell you sell?

or what? Or Buy when Buy?
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
  • #134
  • Dec 4, 2009 10:39am Dec 4, 2009 10:39am
Quoting SkyzerFX
Soce, could you please explain what you actually doing with that data?

Are you Using that new form added and when it says sell you sell?

or what? Or Buy when Buy?
I made my own form (included picture here) and it simply tells me currency by currency what to do. (shocked that original doesn't just do that since it took almost no effort) However, what are the weights on top? They do not seem to get used anywhere. I don't even understand what they should represent.

Also, what do these directions mean: "match a stong base with a correlate strong?" does that somehow suggest using the weights from above?
  • #135
  • Dec 4, 2009 10:40am Dec 4, 2009 10:40am
Can someone explain cell C22 to me when you have a minute?
  • #136
  • Dec 4, 2009 10:42am Dec 4, 2009 10:42am
Quoting soce
I made my own form (included picture here) and it simply tells me currency by currency what to do.
Unfortunately that bmp file is too small to see details

Would you share your Excel file then? Or that's secret wepon?

Thanks.
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
  • #137
  • Dec 4, 2009 10:45am Dec 4, 2009 10:45am
Quoting SkyzerFX
Unfortunately that bmp file is too small to see details

Would you share your Excel file then? Or that's secret wepon?

Thanks.
There is no secret weapon. I simply brought the data above to down below and then have it tell me what specific combo to buy/sell. File is too big now to post here because I am attempting (not successfully yet) to record every time I get a new buy/sell so I can just let this thing run and study results later. i find it IMPOSSIBLE to trade and study at same time.

I really don't get the =CORREL(stuff)... from what I can tell it is NOT used. However, I would like someone else to confirm this with me in case I am missing something important. However, my demo account says that I am not missing anything but that could be pure luck.
  • #138
  • Dec 4, 2009 10:53am Dec 4, 2009 10:53am
Well as far as I can see when pair flashed BUY look at the chart -
it's ready to SELL and vise versa, cause if currency that weak or that
strong it's been already either overbought or oversold
And we all trying to catch it before pair gets to that level. IMHO
Viewer Discretion Advised: Shall we shag now or should we shag later? :-)
  • #139
  • Dec 4, 2009 11:11am Dec 4, 2009 11:11am
Quoting SkyzerFX
Well as far as I can see when pair flashed BUY look at the chart -
it's ready to SELL and vise versa, cause if currency that weak or that
strong it's been already either overbought or oversold
And we all trying to catch it before pair gets to that level. IMHO
well i made money on every trade i entered... again with no STOPs so not sure how to feel about that yet. Yes, this method is about buying INTO up trends and SELLING into down trends. If you want to do something more to try to "time" the market dips have at it. I am simply testing this thing out by periodically looking at the signals and clicking on my demo account when I have time and its working! LOL
  • #140
  • Dec 4, 2009 11:17am Dec 4, 2009 11:17am
Just made another little scalp on USDJPY...

this is the picture of my today's demo account...and i've made only a few scalps of few pips...without calibrating entries...

Obviously when a Buy signal appears we have to watch the chart and find the better entry...on a retrace perhaps..

The "magic" is not in the buy/sell signals...but in the fact that we can know wich is the best pair in a given moment.... so the PROBABILITIES are in our favor...
Attached Image (click to enlarge)
Click to Enlarge Name: grail.gif Size: 5 KB
Market is like a puzzle, YOU have to fit the pieces!!
0 traders viewing now