Forex
Google

Go Back   Forex Trading > Downloads > Tools and utilities
Reload this Page Working with Excel (tools, indicators, conversion ...)
Forex Forum Register FAQ Members List Calendar Search Today's Posts Mark Forums Read


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

Reply
Page 11 of 12 « First < 910 11 12 >
 
LinkBack (6) Thread Tools Display Modes
  #101 (permalink)  
Old 05-20-2008, 03:23 AM
Batoobah Batoobah is offline
Junior Member
  
Join Date: May 2008
Posts: 1
Batoobah is on a distinguished road
Thumbs up Exporting to Excel
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #102 (permalink)  
Old 05-20-2008, 03:40 AM
Linuxser's Avatar
Linuxser Linuxser is offline
Moderator
  
Join Date: May 2006
Location: Helliconia (Autumn)
Posts: 2,182
Linuxser has disabled reputation
Quote:
Originally Posted by Batoobah View Post
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #103 (permalink)  
Old 05-22-2008, 03:59 PM
droesparky's Avatar
droesparky droesparky is offline
Senior Member
  
Join Date: Apr 2006
Posts: 390
droesparky is on a distinguished road
Export current price
I know its here somewhere but havent been able to find it.
How do you export the current chart price to a excel spreedsheet and have it update. Im using MS office 2007.
I have the Enable Server DDE box checked.
__________________
My Pips in 2008 = +154
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #104 (permalink)  
Old 05-22-2008, 05:05 PM
droesparky's Avatar
droesparky droesparky is offline
Senior Member
  
Join Date: Apr 2006
Posts: 390
droesparky is on a distinguished road
Ive done all this but excel 2007 just sits there and does nothing.

Is there something in excel I need to turn on that Ive missed.


<<<<<<<<<<<<<<
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
>>>>>>>>>>>
__________________
My Pips in 2008 = +154
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #105 (permalink)  
Old 05-22-2008, 05:13 PM
Linuxser's Avatar
Linuxser Linuxser is offline
Moderator
  
Join Date: May 2006
Location: Helliconia (Autumn)
Posts: 2,182
Linuxser has disabled reputation
Quote:
Originally Posted by droesparky View Post
Ive done all this but excel 2007 just sits there and does nothing.

Is there something in excel I need to turn on that Ive missed.


<<<<<<<<<<<<<<
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
>>>>>>>>>>>

Hello

DDE links are not automatically updated in Excel 2007
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #106 (permalink)  
Old 05-22-2008, 08:27 PM
droesparky's Avatar
droesparky droesparky is offline
Senior Member
  
Join Date: Apr 2006
Posts: 390
droesparky is on a distinguished road
Thanks but none of those ideas worked either.
__________________
My Pips in 2008 = +154
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #107 (permalink)  
Old 05-22-2008, 08:49 PM
Linuxser's Avatar
Linuxser Linuxser is offline
Moderator
  
Join Date: May 2006
Location: Helliconia (Autumn)
Posts: 2,182
Linuxser has disabled reputation
Quote:
Originally Posted by droesparky View Post
Thanks but none of those ideas worked either.


This works?

='MT4'|HIGH!EURUSD
='MT4'|ASK!EURUSD
='MT4'|BID!EURUSD
='MT4'|LOW!EURUSD
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #108 (permalink)  
Old 05-23-2008, 01:33 PM
droesparky's Avatar
droesparky droesparky is offline
Senior Member
  
Join Date: Apr 2006
Posts: 390
droesparky is on a distinguished road
That one worked Linuxser Thank YOu very much!
__________________
My Pips in 2008 = +154
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #109 (permalink)  
Old 05-25-2008, 12:17 AM
dgrspencer dgrspencer is offline
Junior Member
  
Join Date: Feb 2008
Posts: 19
dgrspencer is on a distinguished road
Very basic help with a script
I downloaded and then altered an indicator from these forums for extracting OCHL information to an excel spreadsheet. It is attached.

I would like to alter this script for a different purpose (I will still be using the first) but what I don't know, is how to change the name of the excel file that is created?

Many thanks,

Dave
Attached Files
File Type: mq4 DGRSwithwkandmonth.mq4 (4.8 KB, 17 views)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #110 (permalink)  
Old 05-25-2008, 12:59 AM
luxinterior luxinterior is offline
Senior Member
  
Join Date: Nov 2006
Posts: 131
luxinterior is on a distinguished road
PHP Code:
int handle=FileOpen("Exported"+symbol+periodDesc(period)+".csv", FILE_CSV|FILE_WRITE, ',');
/
/ 
Read about the 'FileOpen' in the mql help file. You can see where it's naming the file in the snippet above.

Quote:
If FILE_READ does not combine with FILE_WRITE, the file will be opened only if it already exists. If the file does not exist, it can be created using the FILE_WRITE mode.
Hope that helps.

Lux
__________________
Build An Expert Advisor. FREE E-course As Seen On TV
ForexArea.com
Users of Gap Trader from 'Forex-Assistant' MUST Read This
Last edited by luxinterior : 05-25-2008 at 01:02 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 11 of 12 « First < 910 11 12 >

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

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


All times are GMT. The time now is 10:50 AM.

Contact Us - Forex TSD| Metatrader Indicators and Experts Advisors - Archive - Top