Would DDE be an option - but I do't know whether it is still working!
May be you can try: https://www.mql5.com/en/code/1246
- www.mql5.com
Would DDE be an option - but I do't know whether it is still working!
May be you can try: https://www.mql5.com/en/code/1246
Hi Thank you for your response.
I am aware of DDE excel where we use the formula in the cell to retrieve the Ask or Bid Price.
But I am trying get a text message to a specific cell in Excel when a new signal is generated from the chart .
- www.mql5.com
You cannot write data (using only MQL) to an excel spreadsheet. You can write a CSV file which can be opened by excel in CSV mode, but it is not a workbook. You could, however, use this open source library which can put values directly to an excel workbook.
Anyone who is aware of writing data to a specific cell in an Excel!!!!
Example please.
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
You agree to website policy and terms of use
I am able to write the values to the excel on each tick
using
int A = FileOpen(FileName,FILE_WRITE);
FileWrite(A, Bid);
FileWrite(A, Ask);
---------------------------------------------
I would like to know how to write this data to a specified cell in an Excel.
For example I want to write some text to the Cell "B3" of Sheet1.
I am aware of DDE excel where we use the formula in the cell to retrieve the Ask or Bid Price.
But I am trying get a text message to a specific cell in Excel when a new signal is generated from the chart .
Thanks in Advance
Naren