Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 610 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

  • Post #1
  • Quote
  • First Post: Jan 6, 2009 12:01pm Jan 6, 2009 12:01pm
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.
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
use MT4|Bid!A17 and have a look at the dde example in metatrader

good luck
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 | 948 downloads
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
here is one you can pick to bits
Attached File(s)
File Type: xls Bones MM DDE v11.xls   428 KB | 1,559 downloads
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.
Thanks Kiwi. That helped me. I just put the data on one sheet, and then used the vlookup command. I appreciate the help.
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?
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.
ill post an excel program for this.... gimme 15 mins
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,206 downloads
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.
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!
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!
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
  • Post #17
  • Quote
  • Last Post: Edited 2:48am Oct 16, 2010 12:57am | Edited 2: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