Forex
Google
New signals service!

Go Back   Forex Trading > Downloads > Tools and utilities
Working with Excel (tools, indicators, conversion ...) Working with Excel (tools, indicators, conversion ...)
Forex Forum Register Blogs 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 12 of 17 « First < 21011 12 1314 > Last »
 
LinkBack (6) Thread Tools Display Modes
  #111 (permalink)  
Old 05-22-2008, 04:59 PM
droesparky's Avatar
Senior Member
  
Join Date: Apr 2006
Posts: 397
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
  #112 (permalink)  
Old 05-22-2008, 06:05 PM
droesparky's Avatar
Senior Member
  
Join Date: Apr 2006
Posts: 397
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
  #113 (permalink)  
Old 05-22-2008, 06:13 PM
Linuxser's Avatar
Moderator
  
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,306
Blog Entries: 46
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
__________________
Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #114 (permalink)  
Old 05-22-2008, 09:27 PM
droesparky's Avatar
Senior Member
  
Join Date: Apr 2006
Posts: 397
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
  #115 (permalink)  
Old 05-22-2008, 09:49 PM
Linuxser's Avatar
Moderator
  
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,306
Blog Entries: 46
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
__________________
Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #116 (permalink)  
Old 05-23-2008, 02:33 PM
droesparky's Avatar
Senior Member
  
Join Date: Apr 2006
Posts: 397
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
  #117 (permalink)  
Old 05-25-2008, 01:17 AM
Junior Member
  
Join Date: Feb 2008
Posts: 22
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, 31 views)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #118 (permalink)  
Old 05-25-2008, 01:59 AM
Senior Member
  
Join Date: Nov 2006
Posts: 215
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 02:02 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #119 (permalink)  
Old 05-25-2008, 12:33 PM
Junior Member
  
Join Date: Feb 2008
Posts: 22
dgrspencer is on a distinguished road
Quote:
Originally Posted by luxinterior View Post
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.



Hope that helps.

Lux

Thanks very much Lux it helps enormously.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #120 (permalink)  
Old 05-25-2008, 01:38 PM
rod30's Avatar
Member
  
Join Date: Mar 2008
Location: GEEZ GEELAND
Posts: 79
rod30 is on a distinguished road
convert Mt to Prn
this convert metatrader format to Prn format save it on indicators
drag it to a chart go to experts/ files
but ive got only the ex4
Attached Files
File Type: ex4 DATA_candle_v1.ex4 (5.9 KB, 24 views)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 12 of 17 « First < 21011 12 1314 > Last »

Bookmarks

Tags
adaptive moving average excel, excel, forex excel, Kaufman, parabolic SAR calculation excel, parabolic sar excel, parabolic sar formula excel, kaufman, Excel Hilbert transform

« 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
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
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 10:08 PM
Финансовая компания UMIS: Форекс (Forex), обучение Форекс (FOREX) трейдеров, интернет-трейдинг, биржевая игра на рынке Forex, игра на бирже. Фондовый рынок, фьючерсы This thread Refback 01-30-2008 08:54 AM
hilbert transform trend line This thread Refback 01-25-2008 10:06 AM
Biznes i handel » Forex - systemy i strategie :: RE: hilbert transform trend line This thread Pingback 01-25-2008 09:23 AM
Firma - Twoja firma » Blog Archive » Forex - systemy i strategie :: RE: hilbert transform trend line This thread Pingback 01-25-2008 08:51 AM
Working with Excel (tools, indicators, conversion ...) - Forex Trading This thread Refback 12-28-2007 04: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 09:59 AM
4 Hr Expert very profitable needs conversion saslam Expert Advisors - Metatrader 4 8 09-24-2006 12:57 PM
Some useful tools ( portable version, so, working WITHOUT installation ) De Vinci Tools and utilities 1 08-18-2006 04:16 PM
Thread subscription tools not working cardio General Discussion 1 02-21-2006 08:13 PM


All times are GMT. The time now is 03:46 AM.

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


Search Engine Friendly URLs by vBSEO 3.2.0 ©2008, Crawlability, Inc.