Working with Excel (tools, indicators, conversion ...) - Page 11

Nordic12 · #**101** (**permalink**) 04-23-2008, 10:47 PM

Hi

You can use the DDE functionality i think

Interestingly how do u manage to get the indicator values into excel ??

frantacech · #**102** (**permalink**) 04-23-2008, 10:58 PM

Quote:

Originally Posted by Paakari

Hi guys.

I have only one tiny problem.
I get data out from indicator, saved as .txt or .csv.
That's ok.

But data is like 1.5898 and excel understands value like 1,5898.
For example, if I get tick data out, I can't make any charts out from that file because Excel don't understand those numbers because of that point (.).

Same thing with my custom indicator, always point inside the numbers.

Is there any way to make it write , instead of . ?
Or anybody knows how to make that change in Excel, so it will print out chart to web and updating it every 5sec?

You need enable DDE Server in MT - Options > Server > Enable DDE Server

After open Excel and add for example:
=MT4|HIGH!EURUSD
=MT4|ASK!EURUSD
=MT4|BID!EURUSD
=MT4|LOW!EURUSD

frantacech · #**103** (**permalink**) 04-23-2008, 11:04 PM

Quote:

Originally Posted by frantacech

You need enable DDE Server in MT - Options > Server > Enable DDE Server

After open Excel and add for example:
=MT4|HIGH!EURUSD
=MT4|ASK!EURUSD
=MT4|BID!EURUSD
=MT4|LOW!EURUSD

change , to . in control panel windows...

zupcon · #**104** (**permalink**) 04-23-2008, 11:17 PM

Quote:

Originally Posted by Paakari

Hi guys.

I have only one tiny problem.
I get data out from indicator, saved as .txt or .csv.
That's ok.

But data is like 1.5898 and excel understands value like 1,5898.
For example, if I get tick data out, I can't make any charts out from that file because Excel don't understand those numbers because of that point (.).

Same thing with my custom indicator, always point inside the numbers.

Is there any way to make it write , instead of . ?
Or anybody knows how to make that change in Excel, so it will print out chart to web and updating it every 5sec?

Are you using the data import wizard to read the values into Excel ?

If you want me to take a look at the file, PM me and I'll give you an email address.

regards
zu

Linuxser · #**105** (**permalink**) 04-23-2008, 11:52 PM

I suppose you´re using some excel version with a setup different of English.

English language recongnizes the . as decimal separator meawhile another languages like Spanish uses , as decimal separator.

Go to Control Panel, Language and Local settings, click customize and change the , by . within decimal symbol. Inverse for Thousand Separation . by ,

Tell me if works.

Linuxser · #**106** (**permalink**) 04-23-2008, 11:55 PM

Sorry, I just see Francatech post. It´s the same thing.

MrM · #**107** (**permalink**) 04-28-2008, 02:37 PM

Hi,
this must have been asked before, and here it is again:
does anyone have an excel sheet that has a macro in it so the cells of the DDE can be copied to the line below every 1/5/15/30/... minutes?
So excel can create intraday charts with more and more data while the DDE feeds new info to the sheet and every new period of time a new line is created.

muchas graçias amigos!

newdigital · #**108** (**permalink**) 04-28-2008, 02:48 PM

I saw few.
Try to look at the following threads:

Excel:
- Working with Excel (tools, indicators, conversion ...) is here;
- COT Data Excel Sheet is here;
- Save Data To A File thread;
- forex data converters thread and some good converters on this elite section post;
- MULTI FIBO CALCULATOR with DDE off course: original thread.
- FX risk calculator with DDE is here.

Batoobah · #**109** (**permalink**) 05-20-2008, 04:23 AM

Hello,
I'm sorry if this has been asked, I've looked all over and I can´t find what I´m looking for.

I need to export ALL the information from MetaTrader4 to Excel. Not only the prices but all the indicator's data. Just what you see in the 'Data Window'.

For example, a column for Awesome Indicator, other one for Stoch(5,3,3), other for Stoch´s signal, etc... all of the indicators I have in a specific screen.

Thanks in advance for any help!

Linuxser · #**110** (**permalink**) 05-20-2008, 04:40 AM

Quote:

Originally Posted by Batoobah

Hello,
I'm sorry if this has been asked, I've looked all over and I can´t find what I´m looking for.

I need to export ALL the information from MetaTrader4 to Excel. Not only the prices but all the indicator's data. Just what you see in the 'Data Window'.

For example, a column for Awesome Indicator, other one for Stoch(5,3,3), other for Stoch´s signal, etc... all of the indicators I have in a specific screen.

Thanks in advance for any help!

Hello,

I've moved your post to this thread. I'm sure you could find what you need.