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

  • #181
  • Dec 5, 2009 7:45am Dec 5, 2009 7:45am
Hi doshur

Post 104 has answer for this. The market has to go for some sessions
to see thorugh the spread sheet the strength and weakness of the currencies
  • #182
  • Dec 5, 2009 8:26am Dec 5, 2009 8:26am
Quoting harigp
Hi doshur

Post 104 has answer for this. The market has to go for some sessions
to see thorugh the spread sheet the strength and weakness of the currencies
so my improvement by using the last 24 one hour bars should resolve this problem?

can excel file get hourly high and low values?
  • #183
  • Dec 5, 2009 8:34am Dec 5, 2009 8:34am
The file is getting the data feed from the MT4 live basis so you have to keep open both the spread sheet and MT 4 for the live action. There is no waiting perid in the spread sheet for the data to come
  • #184
  • Dec 5, 2009 8:43am Dec 5, 2009 8:43am
Quoting harigp
The file is getting the data feed from the MT4 live basis so you have to keep open both the spread sheet and MT 4 for the live action. There is no waiting perid in the spread sheet for the data to come
i think that is a con in this system.
  • #185
  • Dec 5, 2009 11:20am Dec 5, 2009 11:20am
Hi
How we know we got an entry signal ?
Do we need to look at the excel ALL the time ?
Is there any alarm ? can be programed ?
Under what conditions we get an entry signal ?
Tks
david4u
  • #186
  • Dec 5, 2009 12:08pm Dec 5, 2009 12:08pm
Quoting Chris_B
Why do we need to create something different?? EAs?? Other indicators?? Other magical stuff?? Other astronomic stuff??
Because doing this with an excel sheet is the most complicated and intransparent and unmaintainable method one could think of.

Therefore the need (following your own KISS principle) to have the same formula, the same calculations in a simple MT4 indicator (simple to read and understand the code and simple to use) without the unneccesary complications, intransparency, unmaintainability and bloat of excel.
  • #187
  • Dec 5, 2009 12:34pm Dec 5, 2009 12:34pm
Care to share your FX4CASTER program? Looks like the 4XPILOT I commented on earlier on page 3.

Quoting jurn_e
Hi, i am using something similar.
My entry is when H4 price candle crosses the 55 ema (magenta colored MA in the chart). Then i will refer to the Strength Meter if there is very obivous difference between the strength of the currencies, i will enter. If not, i will stay out. If all the currencies strength all quite the same, i will not enter.

For example, if Euro strength is 3.41 and USD strength is 3.71. I would not short Euro, the difference is too small, no clear winner.
In the chart provided, we can see that USD is very strong 8.86 compared...
  • #188
  • Dec 5, 2009 12:58pm Dec 5, 2009 12:58pm
i made my own indicator with the same excel calculation
bad point is IT CONSUME 200MB MEMORY for this indicator alone!
Attached Image (click to enlarge)
Click to Enlarge Name: demo.gif Size: 22 KB
  • #189
  • Dec 5, 2009 10:55pm Dec 5, 2009 10:55pm
Quoting harigp
The file is getting the data feed from the MT4 live basis so you have to keep open both the spread sheet and MT 4 for the live action. There is no waiting perid in the spread sheet for the data to come
Do you save the spreadsheet after every session of usage?
  • #190
  • Dec 5, 2009 11:23pm Dec 5, 2009 11:23pm
harry 123

No need to save if you close and reopen the spread sheet the data in MT4
get updated within seconds

if you want to keep the histrocal record of event you can save it and keep for further reasearch
  • #191
  • Dec 6, 2009 12:05am Dec 6, 2009 12:05am
Quoting harigp
harry 123

No need to save if you close and reopen the spread sheet the data in MT4
get updated within seconds

if you want to keep the histrocal record of event you can save it and keep for further reasearch
Thanks
  • #192
  • Dec 6, 2009 12:52am Dec 6, 2009 12:52am
harigp
Can u pls take a look at my post #185
Tks
David
  • #193
  • Dec 6, 2009 1:00am Dec 6, 2009 1:00am
How we know we got an entry signal ? : you have to see the signal box
Do we need to look at the excel ALL the time ? depends on how you view themarket
Is there any alarm ? can be programed ? NO
Under what conditions we get an entry signal ? based on strength of currency and how the market is moving on a day
  • #194
  • Dec 6, 2009 2:28am Dec 6, 2009 2:28am
Hi harigp
Tks for your prompt answer .
Is it posible to add the time we got the signal , so if we are not glued
all the time to the PC will know when this signal was given ?
Tks again
David

Quoting harigp
How we know we got an entry signal ? : you have to see the signal box
  • #195
  • Dec 6, 2009 2:41am Dec 6, 2009 2:41am
david4u

coming back to Alarm and the time the signal was given May be the
programmers can do something about it.

Will be fun to see that excel sheet if the market is going to trend the coming week.
  • #196
  • Edited 7:18am Dec 6, 2009 7:06am | Edited 7:18am
Hi guys...

In excel we can put in a simple way a sound alarm when a buy/sell signals appears...

This is the procedure I've found on the web:

1. Go in Excel
2. Go in Instruments > Macro >Visual Basic Editor
3. Insert a new Module and copy this:

Private Declare Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, _
ByVal hModule As Long, ByVal dwFlags As Long) As Long

Const SND_SYNC = &H0
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000

Public Function Alarm()
WAVFile = "c:/windows/media/tada.wav"
Call PlaySound(WAVFile, 0&, SND_ASYNC Or SND_FILENAME)
End Function

Make sure the file you want is in the correct path.
Then in the cells with the buy/sell signals (those that become green/red) you vahe to modify the formula for example from:

=SE(E(I18>=7.1;D18<=2);1;10)

to:

=SE(E(I18>=7.1;D18<=2);(1+Alarm());10)

My formula is in italian language, but you need to change only the red part of the formula.
I don't know if it works with Windows Vista, with Xp works perfectly..

There is a way also to program all the conditions directly in the Visual Basic Module without changing the formula in the cells.

Maybe Andy9775 can program this in the new version of the spreadsheet...

EDIT: Searching in the web I've found that also a popup message can be displayed by Excel when a condition is met...and I think also an email message can be easily programmed...
Market is like a puzzle, YOU have to fit the pieces!!
  • #197
  • Dec 6, 2009 8:29am Dec 6, 2009 8:29am
http://www.j-walk.com/ss/excel/tips/tip87.htm

Here is the link I'm playing with it but not working correctly yet
  • #198
  • Dec 6, 2009 10:03am Dec 6, 2009 10:03am
Quoting 7bit
can't this thing be completely rewritten as an indicator for mt4 to get rid of all the limiting and cumbersome excel stuff for better usability and compatibility?
Yes it certainly can and it is no problem to have a rolling High Low range, so it never is inaccurate. also, you can have any time frame for the High Low range and any time frame for the history to be graphed. In the screen shot I chose a Daily for the Rolling High and Low and a hourly for the graphing.
Attached Image (click to enlarge)
Click to Enlarge Name: ScreenHunter_037.jpg Size: 287 KB
  • #199
  • Dec 6, 2009 11:18am Dec 6, 2009 11:18am
Quoting smjones
Yes it certainly can and it is no problem to have a rolling High Low range, so it never is inaccurate. also, you can have any time frame for the High Low range and any time frame for the history to be graphed. In the screen shot I chose a Daily for the Rolling High and Low and a hourly for the graphing.
Is it possible to get this indicator ?
  • #200
  • Dec 6, 2009 11:23am Dec 6, 2009 11:23am
Quoting scooby-doo
Is it possible to get this indicator ?
I sent you a PM. I have not decided what to do with it yet.
0 traders viewing now