Forexgrail excel indicator

You mean in INDY? Rel Strength

Here is the code, anybody see the problem with divide there?

=================================================
//+------------------------------------------------------------------+
//| RelStrength.mq4 |
//| by Matsu |
//+------------------------------------------------------------------+

#property indicator_separate_window
#property indicator_buffers 7
#property indicator_color1 Aqua
#property indicator_color2 Silver
#property indicator_color3 Yellow
#property indicator_color4 DodgerBlue
#property indicator_color5 Red
#property indicator_color6 HotPink
#property indicator_color7 MediumOrchid

#property indicator_level1 0

extern int CountBars=50;
extern bool Reverse=false;
extern int Line_Thickness = 3;

//---- buffers
double val1[];
double val2[];
double val3[];
double val4[];
double val5[];
double val6[];
double val7[];


int deinit()
{

return(0);
}

//+------------------------------------------------------------------+
//| Custom indicator initialization function |
//+------------------------------------------------------------------+
int init()
{

//---- indicator line
IndicatorBuffers(7);

int width = 0;
if(0 > StringFind(Symbol(), "EUR", 0))
width = 1;
else
width = Line_Thickness;

SetIndexStyle(0,DRAW_LINE,0,width);

if(0 > StringFind(Symbol(), "GBP", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(1,DRAW_LINE,0,width);
if(0 > StringFind(Symbol(), "JPY", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(2,DRAW_LINE,0,width);
if(0 > StringFind(Symbol(), "AUD", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(3,DRAW_LINE,0,width);
if(0 > StringFind(Symbol(), "CAD", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(4,DRAW_LINE,0,width);
if(0 > StringFind(Symbol(), "CHF", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(5,DRAW_LINE,0,width);
if(0 > StringFind(Symbol(), "NZD", 0))
width = 1;
else
width = Line_Thickness;
SetIndexStyle(6,DRAW_LINE,0,width);
SetIndexBuffer(0,val1);
SetIndexBuffer(1,val2);
SetIndexBuffer(2,val3);
SetIndexBuffer(3,val4);
SetIndexBuffer(4,val5);
SetIndexBuffer(5,val6);
SetIndexBuffer(6,val7);

SetIndexLabel(0,"EUR");
SetIndexLabel(1,"GBP");
SetIndexLabel(2,"JPY");
SetIndexLabel(3,"AUD");
SetIndexLabel(4,"CAD");
SetIndexLabel(5,"CHF");
SetIndexLabel(6,"NZD");

IndicatorShortName("RS(EUR,GBP,JPY,AUD,CAD,CHF,NZD vs USD)");
IndicatorDigits(2);



//----
return(0);
}
//+------------------------------------------------------------------+

//+------------------------------------------------------------------+
int start()
{
if (CountBars>=Bars) CountBars=Bars;
int i,shift,counted_bars=IndicatorCounted();
double price1,price2,price3,price4,price5,price6,price7;
//----
if(Bars<=1) return(0);


price1=iMA("EURUSD",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price2=iMA("GBPUSD",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price3=iMA("USDJPY",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price4=iMA("AUDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price5=iMA("USDCAD",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price6=iMA("USDCHF",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);
price7=iMA("NZDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,CountBars);

if (Reverse)
{

for (shift = CountBars; shift>=0; shift--)
{
val1[shift]= (1-iMA("EURUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price1) *100;
val2[shift]= (1-iMA("GBPUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price2) *100;
val3[shift]= (iMA("USDJPY",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price3 -1) *100;
val4[shift]= (1-iMA("AUDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price4) *100;
val5[shift]= (iMA("USDCAD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price5 -1) *100;
val6[shift]= (iMA("USDCHF",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price6 -1) *100;
val7[shift]= (1-iMA("NZDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price7) *100;
}




}
else
{

for (shift = CountBars; shift>=0; shift--)
{
val1[shift]= (iMA("EURUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price1 -1) *100;
val2[shift]= (iMA("GBPUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price2 -1) *100;
val3[shift]= (1-iMA("USDJPY",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price3) *100;
val4[shift]= (iMA("AUDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price4 -1) *100;
val5[shift]= (1-iMA("USDCAD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price5) *100;
val6[shift]= (1-iMA("USDCHF",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price6) *100;
val7[shift]= (iMA("NZDUSD",0,1,0,MODE_SMA,PRICE_CLOSE,shift)/price7 -1) *100;
}

}
return(0);
}
//+------------------------------------------------------------------+

======================================

And about XLS file not sure, something is wrong with DDE itself, cause even

included with MT4 file "DDE-Sample.xls" in MT4 main directory don't work as well

Nice Indicator

Opened it, it read USD 6.3 and Rising , GBP 1.5 and weak, placed short trade in demo £70 up already .....only going 5 mins....could be luck though !

Anyway anyone thats got problems with it working I noticed that it depends what broker your using. It works in my FXCM account but not in my FXcbs account.....both 5 digit ?

Anyway just thought Id let you know...


cheers


ab1

Anyone know how to fix it??? Thanks

EU was riding high with a bid ratio of 99%. i went for a short in EU looking at the bid ratio and runing at 32 pip profit

I am looking at US$/jpy and going strong with a bid ratio of 76% any possibilty of short later

I figure out WHY that forexgrail.xls not working

Click Ctrl- M and you will see how exactly your currency named

like in FOREX.com for example it is

EURUSDFXF

and so on

In

IBFX it's

EURUSDm

In order to get data you need to query data exactly as it

appears in your Market Watch window!

Those differences are screwing everything up!!!

I just change that in Sample DDE file and it's working now..

But how can I edit Forexgrail, that's the problem...

Every single value in that xls file must be change for example from:

=MT4|BID!EURUSD

to work in IBFX mini account that need to be changed to

=MT4|BID!EURUSDm

And that's a lot of work. Don't know why they don't have setup file when you can specify each

currency pair exactly as they appear in your Broker Market window?

I hope this helps and safe few hours of time

Thanks.

Bang ON!! works fine now

Ok, I get it working on my Forex.com Demo

Not much work actually 2 min

Change those Ticker names in Strength Form to right tickers

usually it's just a few extra letters at the end.

Look in your Market window Ctrl-M for right Name

All I change I add

to the end of each quote FXF

And that's it all other forms are updating from that data

Mine works but it stops updating after a few minutes.

I have one long GU when the bid ratio was at 9% and one more long in GU when the bid ratio was at 2%

Let us see how it works

Ok, I am going to demo this for a week and report back. I am currently up in both trades I placed earlier this morning.

GBP/CHF Sold and up 16 pips
GBP/USD Sold up 10 pips

What is wrong with my excel???
Could someone help?

Are you sure, this Excel-File is helpfull ??? Almost all the trades i was doing with this was losing...

will largely depend on when you enter the trade as all this is telling you is where each currency is relative to its daily high/low. I am going to input all of 30 minute data for the year and back test this and get back at you guys.

hi wrb 30

Can you tell us what are the pair you traded and are you looking at the bid ratio before placing the trade

MY GU IS picking the momentum

I like the rubber band chart...

Hmmm Hair...how are you interpreting the bid ratio?

This is what I understood about bid ratio and I think everything revolves around the bid ratio

Bid Ratio as per the spreadsheet is Bid price(purhcase price of the base currrency) Minus day low of the base currency divide by the pip range
pip range is day high minus day low

If the bid ratio is 99.99% I look that us the currecny overbought and bid ratio less than 1% currency oversold

When the currency at bid ratio 99.99% and if you look at the chart of that particular currency by using the pivot indicator you can see the candles are at R1 or R2

This tell us that the short can be possible and reverse for long

having said that this spreadsheet is in the testing stage

So...I see that few min ago GU was @ 1.8%...so totally oversold...

and I threw on daily pivots on a 15 min chart and what do you know... GU is sitting at R1.

So should we take a long here?

That would be going opposite of what this spreadsheet suggests. Basically this method will ROCK on trending days, be a flip of the coin on trading days and get destroyed on head fake days.

Hi pilouti

In M 15 the candles are in S 1