I am geting MT4 live data in my excel file. All is runing well but only GBPUSD value show N/A

New comment
 

Hi all another riddle,

At the moment I am using an MT4 Client Terminal and DDE server is enabled.

With EXCEL 2007 I can run

Using the command :

='MT4'|BID!EURUSD I get 1.14745

='MT4'|BID!AUDUSD I get 1.53659

='MT4'|BID!GBPUSD I get N/A

Please note:

That GBPUSD is updating in my MT Client Terminal.

Something is wrong with GBPUSD ? the response is N/A

Does anyone know how re-set MT Client DDE or what actions should I take to get the GBPUSD price.

Also I tried some other MT Clients from other competitors and still same problem

I've also noted that with wrong quotes formulas of the excel cell gets changed (e.x. =MT4|bid!gbpusd instead of how it is typed in MT4 GBPUSD all in CAPITAL letters)

Please help me for how can I get data from MT4 to excel for a particular pair “GBPUSD”

Thanks

 

Make sure

1) GBPUSD is shown in the MarrketWatch of the terminal

2) the Excel-GBPUSD is the same as the one in the MarketWatch

 

GBPUSD is showing in the MarketWatch of the terminal. When I type in excel cell as "='MT4'|BID!GBPUSD", after press Enter key, then typed formula convert as "='MT4'|BID!gbpUSD" and value show "N/A". When I start my excel file then some other formula convert as following type:

='MT4'|bid!_xlbgnm.UK100

='MT4'|bid!_xlbgnm.GER30

='MT4'|bid!_xlbgnm.US500

 

='MT4'|bid!_xlbgnm.US30

 

What is xlbgnm and how this add in formula.

Please help. 

 
Ganga Ram Choudhary:

GBPUSD is showing in the MarketWatch of the terminal. When I type in excel cell as "='MT4'|BID!GBPUSD", after press Enter key, then typed formula convert as "='MT4'|BID!gbpUSD" and value show "N/A". When I start my excel file then some other formula convert as following type:

='MT4'|bid!_xlbgnm.UK100

='MT4'|bid!_xlbgnm.GER30

='MT4'|bid!_xlbgnm.US500

 

='MT4'|bid!_xlbgnm.US30

 

What is xlbgnm and how this add in formula.

Please help. 

Hi Ganga,

Did you find any solve about this problem. I have same problem. İf you solve please Do you share solved for me?

Very thanks, for interesteds.

New comment