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

  • #281
  • Dec 10, 2009 10:30am Dec 10, 2009 10:30am
soce

Thank you for that. In the mean I find the sheet (theline) to be very useful
which is telling us in what trade we should be in as the market progress

Third sheet in the excel file
  • #282
  • Dec 10, 2009 10:40am Dec 10, 2009 10:40am
Quoting harigp
soce

Thank you for that. In the mean I find the sheet (theline) to be very useful
which is telling us in what trade we should be in as the market progress

Third sheet in the excel file
I am confused, what sheet is that? Is it telling you something different from what I posted which gives you the data for every minute?
  • #283
  • Dec 10, 2009 10:40am Dec 10, 2009 10:40am
Thanks. Your work is greatly appreciated.

Quoting soce
I am eastern standard time. you should be able to change the hours in the top left cell to match what your chart shows. This is why I add 5 hours as the charts from my broker are 5 hours ahead of me.
  • #284
  • Dec 10, 2009 10:45am Dec 10, 2009 10:45am
Siuol

It is not at all related to what you are developing. I was just mentioning in the same post for the hard work you put in and I thought of writing a note about the sheet if any one has missed looking at

not to worry
  • #285
  • Dec 10, 2009 10:49am Dec 10, 2009 10:49am
I think you meant Soce! I will not take credit for the incredible work that Soce put in on this spreadsheet!

Quoting harigp
Siuol

It is not at all related to what you are developing. I was just mentioning in the same post for the hard work you put in and I thought of writing a note about the sheet if any one has missed looking at

not to worry
  • #286
  • Dec 10, 2009 10:52am Dec 10, 2009 10:52am
Got confused

The post is for soce
  • #287
  • Dec 10, 2009 12:56pm Dec 10, 2009 12:56pm
It's always good to see the wheel being re-invented once again.
  • #288
  • Dec 10, 2009 1:01pm Dec 10, 2009 1:01pm
Well scooby, unfortunately the threads that covered similar approaches have become "mature" to the point where you can't figure out what the approach really is any more.

Sometimes trading approach threads need a fresh start.
You are in a maze of twisty little passages, all alike.
  • #289
  • Dec 10, 2009 1:12pm Dec 10, 2009 1:12pm
Quoting stevegee58
Well scooby, unfortunately the threads that covered similar approaches have become "mature" to the point where you can't figure out what the approach really is any more.

Sometimes trading approach threads need a fresh start.
The threads which you are referring too have become useless as they only provide short term gains based on strength/weakness of pairs.

People have created indicators, excel sheets and numerous external analysis systems.

A pair could be strong in M15 and weak in H1 or H4. Yes you can take an average formula but averages do not always give an accurate picture of the market unless you are analysing all TF's with a weighting system.

What all these methods give you is strong being OB or weak being OS. A pair or pairs can remain in these areas or thresholds for long time periods and can increase or reverse suddenly due to economic or unannounced CB interventions.

By all means carry on but this thread will end up like all the others.

Yes, you will have short term lucky gains but that is all.

Scoobs.
  • #290
  • Dec 10, 2009 1:16pm Dec 10, 2009 1:16pm
Updated... made a change that seems to have made it record easier and use less CPU. If you notice times missing it is because I lost internet a few times.
Attached File(s)
File Type: xls soce-forexgrail.xls   394 KB | 568 downloads
  • #291
  • Dec 10, 2009 3:52pm Dec 10, 2009 3:52pm
Updated history for anyone who wants to study this tonight.
Anyone who might be wondering what timezone I am in... simply line up the last time recorded on here with the time of this post.
Attached File(s)
File Type: xls soce-forexgrail.xls   440 KB | 641 downloads
  • #292
  • Dec 10, 2009 4:04pm Dec 10, 2009 4:04pm
Quoting soce
Updated history for anyone who wants to study this tonight.
Anyone who might be wondering what timezone I am in... simply line up the last time recorded on here with the time of this post.
Nice work. Are you going to distribute the sheet that collects so others can test as well?
  • #293
  • Dec 10, 2009 10:35pm Dec 10, 2009 10:35pm
Looking at the overall view GBP AND AUD stand high whether they will continue the journey or not
  • #294
  • Dec 10, 2009 11:55pm Dec 10, 2009 11:55pm
Euro and GBP strong across the board today. JPY the weakest.
Pivot Boss in the making~
  • #295
  • Dec 11, 2009 2:52am Dec 11, 2009 2:52am
Quoting jurn_e
Euro and GBP strong across the board today. JPY the weakest.
JPY is outside of its trading session and its Friday so it will be week as their traders wont get another bite of the cherry until Sunday/Monday depending on your Timezone.

See attachment and you will learn allot about interventions and why, when all the indicators tell you that currencies are strong/weak that you suddenly still end up with a loss.

Scoobs.
Attached File(s)
File Type: pdf BOJ Intervention Policy.pdf   331 KB | 679 downloads
  • #296
  • Dec 11, 2009 4:05am Dec 11, 2009 4:05am
Yup Scooby Doo, we should be wary of intervention of JPY.
Well for me the strength meter is just a guide of which currency is strong and weak thats all. I also look at DAX, Gold and Oil when trading. And of course SR levels in the charts. I don't know about others but today i Long GJ and Euro and made some pips based on the currency meter, rising Gold prices, rising DAX and feel good news from good Chinese data this morning. That sums my trade decision today.
Pivot Boss in the making~
  • #297
  • Dec 11, 2009 6:08am Dec 11, 2009 6:08am
here is data through this morning. everyone take a look at the 7pm time. that is when my charts roll over which you can see in column "A" chart time. At this point the high/lows get reset so the data is meaningless for a couple of hours.
Attached File(s)
File Type: xls soce-forexgrail.xls   688 KB | 524 downloads
  • #298
  • Dec 11, 2009 9:08pm Dec 11, 2009 9:08pm
soce

I was looking at the latest excel sheet send by Soce and my favourite pair
GJ had consistent signal on buy throught out the day except for some sell signals due to retracement

Good work on this soce and hope you will clear all the bugs
  • #299
  • Dec 12, 2009 4:25am Dec 12, 2009 4:25am
HI @All



yea thnx to soce for his nice work . iam using those excel sheets to backtest the strategy idea i posted here

http://www.forexfactory.com/showthread.php?t=211166


also thnx to andy who came up with a new fxgrail version


iam still backtesting all signals lets see if we can build a nice trading plan along with an MM on this strategy.

cheers
  • #300
  • Dec 12, 2009 1:26pm Dec 12, 2009 1:26pm
be sure to check both tabs as I have moved data over. hope to have this up and running most of this week starting tomorrow evening.

**** remember, at 7pm eastern time the charts roll over. so you will see tons of meaningless signals at that time because the highs and lows are all reset and the pip range is also reset to 0.
Attached File(s)
File Type: xls soce-forexgrail.xls   1.6 MB | 5,505 downloads
0 traders viewing now