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

dgrspencer · #91 (**permalink**) 04-16-2008, 11:20 PM

Quote:

Originally Posted by zupcon

There are several ways to get the CSV data into excel.

If your using Excel 2007 there's a data tab, with the option to import from a text file.

In earlier versions you need to use the file import wizard (I dont have an old version of excel so cant remember where this is found, probably under the data menu). Once the wizard starts it guides you step by step through the process, it allows you to pick the delimiter etc, drop unwanted columns etc

You can write a macro to read text files, but its not necessary, and unless your opening hundreds of files, probably not worth the effort.

Another option is to use star office, if you double click a text file the application is sensible enough to start the import wizard, and you coud always save the spreadsheet in XLS format if you really wanted to use Excel

hope this helps

That helps enormously. In 5mins look, it looks like you can set it to update itself automatically. What I can't see is how to only import say a few rows - otherwise I end up with so much data it's very cluttered.

Once setup, because it will refresh itself automatically I presumably then only have to worry about my indicator within MT4 which creates the csv files.... I haven't worked out yet whether the indicator simply writes over the previous file.....

Paakari · #92 (**permalink**) 04-23-2008, 09:40 PM

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?

Nordic12 · #93 (**permalink**) 04-23-2008, 09:47 PM

Hi

You can use the DDE functionality i think

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

frantacech · #94 (**permalink**) 04-23-2008, 09: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 · #95 (**permalink**) 04-23-2008, 10: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 · #96 (**permalink**) 04-23-2008, 10: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 · #97 (**permalink**) 04-23-2008, 10: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 · #98 (**permalink**) 04-23-2008, 10:55 PM

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

MrM · #99 (**permalink**) 04-28-2008, 01: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 · #**100** (**permalink**) 04-28-2008, 01: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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

LinkBacks (?) LinkBack to this Thread: http://www.forex-tsd.com/tools-utilities/4457-working-excel-tools-indicators-conversion.html
Posted By	For	Type	Date
hilbert transform trend line	This thread	Refback	01-31-2008 09:08 PM
Ôèíàíñîâàÿ êîìïàíèÿ UMIS: Ôîðåêñ (Forex), îáó÷åíèå Ôîðåêñ (FOREX) òðåéäåðîâ, èíòåðíåò-òðåéäèíã, áèðæåâàÿ èãðà íà ðûíêå Forex, èãðà íà áèðæå. Ôîíäîâûé ðûíîê, ôüþ÷åðñû	This thread	Refback	01-30-2008 07:54 AM
hilbert transform trend line	This thread	Refback	01-25-2008 09:06 AM
Biznes i handel » Forex - systemy i strategie :: RE: hilbert transform trend line	This thread	Pingback	01-25-2008 08:23 AM
Firma - Twoja firma » Blog Archive » Forex - systemy i strategie :: RE: hilbert transform trend line	This thread	Pingback	01-25-2008 07:51 AM
Working with Excel (tools, indicators, conversion ...) - Forex Trading	This thread	Refback	12-28-2007 03:09 AM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mql2Mq4 Conversion Tool Beta V0.2	yousky	Tools and utilities	33	10-20-2006 08:59 AM
4 Hr Expert very profitable needs conversion	saslam	Expert Advisors - Metatrader 4	8	09-24-2006 11:57 AM
Some useful tools ( portable version, so, working WITHOUT installation )	De Vinci	Tools and utilities	1	08-18-2006 03:16 PM
Thread subscription tools not working	cardio	General Discussion	1	02-21-2006 07:13 PM

Register in Forex TSD!
Trading Systems Leaders in this forum (automated trading systems) are winning more than 3000 pips in a month (30000$ investing one lot every time). Click here to register and get more information