Working with Excel (tools, indicators, conversion ...) - page 12
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
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.
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
>>>>>>>>>>>
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
Thanks but none of those ideas worked either.
Thanks but none of those ideas worked either.
This works?
='MT4'|HIGH!EURUSD
='MT4'|ASK!EURUSD
='MT4'|BID!EURUSD
='MT4'|LOW!EURUSD
That one worked Linuxser Thank YOu very much!
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
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.
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