I am getting errors when enter formulas on some of the future tickers
=MT4|BID!6EU8 this creates an error any ticker that starts with a number creates an error as Excel see it as a invalid formula =MT4|BID!EURUSD AND OTHERS WORK FINE
I posted this question in some of the excel forums , but didnt get any help as most of them are not
Please, take a look to my last post on: https://www.mql5.com/en/forum/176455
How to save zig zag peak and low to a file
From this forum I learned to save data into a cvs file. I tried to also make the zig zag point onto the data file, but failure. I don't really understand the indicator. Can anyone give me some tips?
read the history data
I want to analyze the history data of usdchf, could you pleaase tell me how to load it into excel.
You have an excel file in your broker platform folder (DDE-Sample.xls). Check it and you will understand how it works.
Sorry to move your post but this long thread have all answers you need.
Besides, here is the short answer:
Open the History Center (Tools --> History Center or just press F2).
Go to USDCHF and double click on desired timeframe
Click on export and sabe the file. In the picture we're going to save USDCHF M30.
Note:best to import is to save file using CSV.
Then go to your Excel and import the file. For more http://office.microsoft.com/en-us/excel/HP100997251033.aspx
Sorry for my last answer. My bad. I understood wrong your need (historical datas).
Linuxser's answer is the good one!
Thank you very much! i am working on it by the way , how to find all my post that i posted.
The easy way:
Click over you own name and then click on Find all posts.
your getprices script was very helpful. It was the first time I had ever tried writing my own script and it worked beautifully based on your sample code.
Thanks for posting it.
Expert to read a Excel spreadsheet and put trades?
exist something like it? Than can read cells of a spreadsheet and open trades?
thanks in advance.