Excel and MT4 | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

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

Trading using Excel and MT4? 29 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Unusual Bug with DDE and Excel Scripts in MT4 8 replies

Integration between excel and MT4 prices 3 replies

Attachments: Excel and MT4
Exit Attachments

Excel and MT4

  • #1
  • First Post: Jan 6, 2009 11:01am Jan 6, 2009 11:01am
I am writing a calculator in excel and I would like to make the final product as user friendly as possible. I am looking for a way to read a cell and use it's contents to extract a bid or ask price. For instance,

A B
1 EURUSD


I would like for B1 to be the ask price of the currency listed in A1. Right now, I have to use MT4|ask!EURUSD.

Is there a way to actually read the string in A1 and use it? I have tried

MT4|ask!A17 but that doesn't work. I am missing something. Any help is greatly appreciated.

Thanks.
  • #2
  • Jan 6, 2009 11:44am Jan 6, 2009 11:44am
Did you try using vlookup()? Also if you can post your spreadsheet with a sample of what you are trying to do i will help you.
Stubbornly persistent
  • #3
  • Jan 6, 2009 12:01pm Jan 6, 2009 12:01pm
use MT4|Bid!A17 and have a look at the dde example in metatrader

good luck
  • #4
  • Jan 6, 2009 12:11pm Jan 6, 2009 12:11pm
Thanks. Here's a small spreadsheet. The problem is, I can't get the spreadsheet to calculation the second formula first. In other words, it won't find the value for A1 in

MT4|Ask!A1

It seems I have to type out EURUSD instead of pointing to it. If I could point to it, it will make the final product much more user friendly.

I have tried the following...

MT4|ASK!cell("address", A1)

and some I can't remember.

Thanks for the help.
Attached File(s)
File Type: xls test.xls   14 KB | 1,019 downloads
  • #5
  • Jan 6, 2009 12:13pm Jan 6, 2009 12:13pm
Quoting Kiwi06
use MT4|Bid!A17 and have a look at the dde example in metatrader

good luck
Tried that. Didn't work. But thanks for the suggestion. I checked out the DDE examples online. All of them had the actual value typed out. Is there one that comes with MT4? I'll have to go and look.

Thanks
  • #6
  • Jan 6, 2009 12:22pm Jan 6, 2009 12:22pm
here is one you can pick to bits
Attached File(s)
File Type: xls Bones MM DDE v11.xls   428 KB | 1,621 downloads
  • #7
  • Jan 6, 2009 12:36pm Jan 6, 2009 12:36pm
Thanks Kiwi. That gives me some ideas. It may even solve my issue in an indirect way but I need to look closer to see if it really does. You've spent some time on that spreadsheet.

Thanks again.
  • #8
  • Jan 6, 2009 3:44pm Jan 6, 2009 3:44pm
Thanks Kiwi. That helped me. I just put the data on one sheet, and then used the vlookup command. I appreciate the help.
  • #9
  • Jan 6, 2009 6:21pm Jan 6, 2009 6:21pm
The only I was able to do this (create a DDE link where part of the link comes from a variable/cell) only using VBA -- is there another way?
  • #10
  • Jan 6, 2009 7:24pm Jan 6, 2009 7:24pm
Quoting pippero
The only I was able to do this (create a DDE link where part of the link comes from a variable/cell) only using VBA -- is there another way?
You can check Kiwi's spreadsheet above. What you do is, create a sheet with all the information on it. Then use vlookup on a separate sheet in the same workbook. That worked very well for me and kept me from having to type it out every time.

Hope this helps.
  • #11
  • Jan 6, 2009 8:39pm Jan 6, 2009 8:39pm
ill post an excel program for this.... gimme 15 mins
  • #12
  • Jan 6, 2009 9:16pm Jan 6, 2009 9:16pm
attached. type your pair in any cell from A2 to A50. eg. EURUSD. dont use EUR/USD. then click on "GET DATA". To turn the data off, click on the button again. There is a little indicator below the button giving status of data. ie. on or off. Remember to turn on macros in your excel options before clicking on the button. BTW, this works in 2007. not sure about 2003 but it should work.
Attached File(s)
File Type: xls forexfactory.xls   40 KB | 1,245 downloads
  • #13
  • Jan 20, 2009 11:50am Jan 20, 2009 11:50am
Quoting qweabc
ill post an excel program for this.... gimme 15 mins
Thanks. I tried to look at your vbprogram but it is password protected.
  • #14
  • May 16, 2010 5:54pm May 16, 2010 5:54pm
Hello!

I am trying to use Excel with mt4 dde to do some calculations on position sizing. the problem is that each time I reference the cell containing the live quote in a formula I get the #VALUE! error message. I tried different sample spreadsheets shared on forums but the problem remains.
I run Excel 2003 and under Win XP.

I would appreciate any help!
  • #15
  • May 16, 2010 8:04pm May 16, 2010 8:04pm
sounds like you havent set your cells to some form of 'number' and have it as 'general' or even worse, 'text'. if you try to do math on general and the cell has something non-numeric like a space then i'm fairly sure this creates the #value middle-finger signal
Congratulations ScalaFX for coming out of the closet!
  • #16
  • May 17, 2010 3:15am May 17, 2010 3:15am
Quoting nubcake
sounds like you havent set your cells to some form of 'number' and have it as 'general' or even worse, 'text'. if you try to do math on general and the cell has something non-numeric like a space then i'm fairly sure this creates the #value middle-finger signal
I found the problem... The dde feed in the excel displays a dot as a fraction separator (eg: 1.2266) and my excel can only interpret comma as a separator (1,2266). I realized earlier that this would be a problem and I installed an english version of excel (i didnt have it before) but it still doesnt work.

Any ideas how I could solve this?
Much obliged
  • #17
  • Last Post: Edited Oct 16, 2010 1:48am Oct 15, 2010 11:57pm | Edited Oct 16, 2010 1:48am
Quoting qweabc
attached. type your pair in any cell from A2 to A50. eg. EURUSD. dont use EUR/USD. then click on "GET DATA". To turn the data off, click on the button again.
@qweabc: although I only trade with one of them, I have 4 different brokers on my computer so every hour I can see an H4 candle close at GMT+0, +1, +2, or +3, etc ... I also use Excel to plan my trades, but each time I switch brokers it changes the spreadsheet ... could you make me a workbook with 4 of these forexfactory worksheets in it, so I can dedicate one sheet to each broker? ... (I would copy and paste it myself, but the code is password protected) ... thankx
0 traders viewing now