MT4-Excel Price Alert Tool By Binyamin | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

COT Excel Tool - desegregated data 70 replies

favorite journal tool: app, web, excel, google? 1 reply

Is there a tool for transferring MT4 trade history into excel? 13 replies

Spread tool in excel 0 replies

Attachments: MT4-Excel Price Alert Tool By Binyamin
Exit Attachments

MT4-Excel Price Alert Tool By Binyamin

  • #1
  • First Post: Jan 18, 2012 10:03pm Jan 18, 2012 10:03pm
For more info about this tool pls visit here

http://www.forexfactory.com/showthre...71#post5282271

This thread was started to aid Choros traders with their technical issues with this Alert program, however all others that are or will be experiencing problems with this tool can share it here.
Riding the order flow
  • #2
  • Jan 18, 2012 10:11pm Jan 18, 2012 10:11pm
Quote
No, I did not change the spreadsheet name. I was saying that I had another spreadsheet open before I opened the Alerts spreadsheet, and when I clicked on it the error appeared.

Ok starting over. No Excel opened. First, I open MT4. I do have DDE server enabled. Then, I open the Alert.xlsm file (unchanged, same as original download). Excel give the hourglass, and hourglass stays there. Looks locked up.

Thanks for your help Bin. Sorry it's such a lot of trouble.

The program should be able to run whether or not there are other spreadsheets.

Alien, can you go to settings sheet and make sure price in is updating from MT4? let me know.

The other issue with hourglass looking locked up. An hourglass should appear and disappear every 1 second because the program does a timed loop. It doesn't seem to cause me any problem. I wrote the program in office 2010. If the problem persist I will try on office 2007 and see if I can recreate your problem.
Attached Image (click to enlarge)
Click to Enlarge Name: Alert.jpg Size: 76 KB
Riding the order flow
  • #3
  • Jan 18, 2012 10:34pm Jan 18, 2012 10:34pm
Quoting Binyamin
The program should be able to run whether or not there are other spreadsheets.
... go to settings sheet and make sure price in is updating from MT4? let me know.
Hi Bin, I am using Excel 2007 and my Setting Sheet prices are not updating. I believe I followed your instructions correctly. I looked at the code and came to the conclusion that the price column values should be updating on the Setting sheet, but they do not. Thanks, this looks like a very useful tool hope to get it working....
  • #4
  • Jan 19, 2012 12:37am Jan 19, 2012 12:37am
Quoting funwithbux
Hi Bin, I am using Excel 2007 and my Setting Sheet prices are not updating. I believe I followed your instructions correctly. I looked at the code and came to the conclusion that the price column values should be updating on the Setting sheet, but they do not. Thanks, this looks like a very useful tool hope to get it working....
Hi see if this post here can help, it is office 2007 specific.

http://www.forexfactory.com/showthre...39#post1860539
Riding the order flow
  • #5
  • Jan 19, 2012 7:58am Jan 19, 2012 7:58am
Quoting Binyamin
Hi see if this post here can help, it is office 2007 specific...
Followed those instructions, but still not working. I then looked at the code in the Settings Price Column....and, I changed the pair names from EURUSD to EURUSDm. My broker, IBFX, assigns an 'm' to the pair name to indicate a "mini" account. When I did that it started working. Thanks for the help.
  • #6
  • Jan 21, 2012 6:34pm Jan 21, 2012 6:34pm
Quoting Binyamin
The program should be able to run whether or not there are other spreadsheets.

Alien, can you go to settings sheet and make sure price in is updating from MT4? let me know.

The other issue with hourglass looking locked up. An hourglass should appear and disappear every 1 second because the program does a timed loop. It doesn't seem to cause me any problem. I wrote the program in office 2010. If the problem persist I will try on office 2007 and see if I can recreate your problem.
Bin, the problem is with my computer. I tried it on another computer and it works fine. I appreciate your help and I'm sorry to take so much of your time.

I updated to the latest version of MT4 and that did not fix it. I will try reinstalling MT4 but if that doesn't work I don't know where to look for the problem. Event logs just show that Excel is hanging.

If anyone has a suggestion please let me know. Thanks!
-AF
Luck occurs when preparation meets with opportunity.
  • #7
  • Jan 21, 2012 8:22pm Jan 21, 2012 8:22pm
Quoting AlienFrog
Bin, the problem is with my computer. I tried it on another computer and it works fine. I appreciate your help and I'm sorry to take so much of your time.

I updated to the latest version of MT4 and that did not fix it. I will try reinstalling MT4 but if that doesn't work I don't know where to look for the problem. Event logs just show that Excel is hanging.

If anyone has a suggestion please let me know. Thanks!
-AF
No problem, I will be away for a week and when I am back I will look into your issue again.
Riding the order flow
  • #8
  • Jan 26, 2012 7:41pm Jan 26, 2012 7:41pm
Quoting Binyamin
No problem, I will be away for a week and when I am back I will look into your issue again.
I fixed it! I found a Microsoft Technet article saying the Internet Explorer, or some other program, can send a DDE registration broadcast and break DDE for another program, i.e., MT4. Windows Update patch fixed it.

Now I can try it out! Hope you're having a nice vacation.
AF
Luck occurs when preparation meets with opportunity.
  • #9
  • Jan 30, 2012 5:59am Jan 30, 2012 5:59am
Quoting AlienFrog
I fixed it! I found a Microsoft Technet article saying the Internet Explorer, or some other program, can send a DDE registration broadcast and break DDE for another program, i.e., MT4. Windows Update patch fixed it.

Now I can try it out! Hope you're having a nice vacation.
AF
HURRRAYYYYY!!!!!
Riding the order flow
  • #10
  • Feb 9, 2012 4:31am Feb 9, 2012 4:31am
Hey, Bin. I really like this little tool! I'm watching a bunch of pairs now so it's really useful. But I can't get it to beep. My speakers work ok and not muted. Any hints?
Luck occurs when preparation meets with opportunity.
  • #11
  • Edited 10:23am Feb 9, 2012 8:20am | Edited 10:23am
Quoting AlienFrog
Hey, Bin. I really like this little tool! I'm watching a bunch of pairs now so it's really useful. But I can't get it to beep. My speakers work ok and not muted. Any hints?
What MT4 broker are you using?

Another question. When it is suppose to beep is the status "Calling"??? And the colour red?
Riding the order flow
  • #12
  • Feb 9, 2012 8:36am Feb 9, 2012 8:36am
Oanda
Luck occurs when preparation meets with opportunity.
  • #13
  • Edited 5:08am Feb 13, 2012 4:47am | Edited 5:08am
Hi, Bin.

I have the Calling feature appearing/disappearing ok again. I switched back to the originally downloaded version of Alerts and it worked ok. I had saved changes a few times before I fixed DDE so maybe I saved some bad changes. So the only problem now is that it won't beep. Here is what happens.

I open alerts, click Options button in the Security Warning, and enable Macros and Links (pic2 below).

Prices update nicely from MT4 at that point.

If I open any other Excel file, a Run-time error '9' appears: Subscript out of range. If I click Debug button, I get the debugger error (pic1). At that point the macro seems to stop running, too - prices continue to update on the Settings tab, but nothing changes on the Input tab anymore.

This is in Excel 2007 on XP Pro. Broker is Oanda.

Playing a .wav file might be pretty cool. You could customize it to talk to you, e.g., "Cable is approaching H4 10." If you had a different wav file for each alert you could customize each one.

Thanks!
AF
Attached Image (click to enlarge)
Click to Enlarge Name: pic2.jpg Size: 149 KB
Attached Image
Luck occurs when preparation meets with opportunity.
  • #14
  • Mar 5, 2012 1:15am Mar 5, 2012 1:15am
Quoting AlienFrog
Hi, Bin.

I have the Calling feature appearing/disappearing ok again. I switched back to the originally downloaded version of Alerts and it worked ok. I had saved changes a few times before I fixed DDE so maybe I saved some bad changes. So the only problem now is that it won't beep. Here is what happens.

I open alerts, click Options button in the Security Warning, and enable Macros and Links (pic2 below).

Prices update nicely from MT4 at that point.

If I open any other Excel file, a Run-time error '9' appears: Subscript out of range. If...
I suppose there is some criteria for the calling to appear. Different sounds for different currency pair is good idea.
  • #15
  • Mar 5, 2012 3:36am Mar 5, 2012 3:36am
Quoting AlienFrog
Hi, Bin.

I have the Calling feature appearing/disappearing ok again. I switched back to the originally downloaded version of Alerts and it worked ok. I had saved changes a few times before I fixed DDE so maybe I saved some bad changes. So the only problem now is that it won't beep. Here is what happens.

I open alerts, click Options button in the Security Warning, and enable Macros and Links (pic2 below).

Prices update nicely from MT4 at that point.

If I open any other Excel file, a Run-time error '9' appears: Subscript out of range. If...
The calling flashes even if the the pip dist is far away. Eg. I entered AUDUSD 1.6 and then I put pip dist 10, the price was 1.6881 but the status shows calling. Then I closed and open the spreadsheet and this time seems ok

How do we refresh the items. I see that the target price in the spreadsheet for EURUSD is 1.2805 pip dist 30, i changed it and there is no reaction even if within price range. Then I entered EURUSD at 1.28 in a new row and pip dist 10, the price was 1.311 and yet it beeped. How to fix this? What is the Restart button in the excel for? If I click on Refresh all under the data menu in excel, the whole thing hangs.
  • #16
  • Mar 5, 2012 4:36am Mar 5, 2012 4:36am
Quoting makefortune
The calling flashes even if the the pip dist is far away. Eg. I entered AUDUSD 1.6 and then I put pip dist 10, the price was 1.6881 but the status shows calling. Then I closed and open the spreadsheet and this time seems ok

How do we refresh the items. I see that the target price in the spreadsheet for EURUSD is 1.2805 pip dist 30, i changed it and there is no reaction even if within price range. Then I entered EURUSD at 1.28 in a new row and pip dist 10, the price was 1.311 and yet it beeped. How to fix this? What is the Restart button in the...
This version here fixes the problem where you say that the red and calling sign still shows despite not meeting the criteria.

The program is in a continuous loop, the restart button is just in case the loop is stopped somehow. It is not necessary to press the restart button at all. I just put it there just in case. I just realize that if I keep pressing the button for no reason there will be more and more of the loop running at the same time.

If your problem persist, let me know:
1) What is your MT4 broker
2) what is your M. office version
Attached File(s)
File Type: rar Alert.rar   23 KB | 566 downloads
Riding the order flow
  • #17
  • Mar 5, 2012 8:54am Mar 5, 2012 8:54am
Quoting Binyamin
This version here fixes the problem where you say that the red and calling sign still shows despite not meeting the criteria.

The program is in a continuous loop, the restart button is just in case the loop is stopped somehow. It is not necessary to press the restart button at all. I just put it there just in case. I just realize that if I keep pressing the button for no reason there will be more and more of the loop running at the same time.

If your problem persist, let me know:
1) What is your MT4 broker
2) what is your M. office version

Broker is oanda. I tested this on my XP computer and seems ok. I notice your price is the ask price but my chart is showing the ask price.

I ran the same file on my Windows 7 and it hangs, had to terminate through the taskmanager.
  • #18
  • Mar 5, 2012 11:00pm Mar 5, 2012 11:00pm
Quoting makefortune
Broker is oanda. I tested this on my XP computer and seems ok. I notice your price is the ask price but my chart is showing the ask price.

I ran the same file on my Windows 7 and it hangs, had to terminate through the taskmanager.
I notice that calling appears as black eg. when Target price is 1.06 pip distance is 10 and the market price is 1.0611 (ask price in chart). When I change the target price to 1.061, the price and calling turns red.

When does calling come up? and why does it turn red or black?

I would like to have further distinction if the price is on the upper end of the range eg. red if price is within the pip dist on the upper side and Green if price is within pip dist on the lower side. Thanks
  • #19
  • Last Post: Mar 7, 2012 9:08am Mar 7, 2012 9:08am
Quoting makefortune
I notice that calling appears as black eg. when Target price is 1.06 pip distance is 10 and the market price is 1.0611 (ask price in chart). When I change the target price to 1.061, the price and calling turns red.

When does calling come up? and why does it turn red or black?

I would like to have further distinction if the price is on the upper end of the range eg. red if price is within the pip dist on the upper side and Green if price is within pip dist on the lower side. Thanks
The calling comes up when the market price is within the target price plus/minus target pips.

Ok I will post the modified alert when I am done with it.
Riding the order flow
1 trader viewing now