EA to read CSV file and plot values in indicator window | Page 3 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Import data excel/csv file in MT4 separate window 0 replies

Need little help to modify indicator to read csv file 3 replies

getting value from CSV file to mql indi and plot it 5 replies

How to convert expert advisor values into CSV file? 2 replies

Splitting values in a CSV file into individual cells 2 replies

Attachments: EA to read CSV file and plot values in indicator window
Exit Attachments

EA to read CSV file and plot values in indicator window

  • #41
  • Aug 16, 2017 5:52am Aug 16, 2017 5:52am
Hi hanover,

Hope all is well.

Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please? What I'd like to achieve is for a spreadsheet cell to change the value of the fx pair based on the daily closing price - this means that the cell's value would get overwritten every day. I have intraday prices working in my spreadsheet fine (importing it live from e-rates.com), but need the closing prices of the previous day to calculate changes between x-pairs. I appreciate I can input the closing prices manually to do the job, but trying to limit the number of manual data input steps.

Many thanks,

Rob
  • #42
  • Aug 16, 2017 7:33am Aug 16, 2017 7:33am
Quoting Robski
Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please?
Sorry, I don't know how to do this, or if it is even possible. You could try opening a new thread, or posting your question in one of the "I code for free" threads, maybe another programmer knows the answer.
  • #43
  • Aug 16, 2017 7:36am Aug 16, 2017 7:36am
Quoting Robski
Hi hanover, Hope all is well. Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please? What I'd like to achieve is for a spreadsheet cell to change the value of the fx pair based on the daily closing price - this means that the cell's value would get overwritten every day. I have intraday prices working in my spreadsheet fine (importing it live from e-rates.com), but need the closing prices of the previous day to calculate changes between x-pairs. I appreciate I can input the closing prices manually...
Rob,

This is not possible using the MQL std lib and/or API functions because MT cannot write to a .xls file. A CSV file, as you know is just a text file, and as such won't preserve your excel formulas and macros. It can be done with third-party libraries, however, but that would be on you to code yourself. Here is one such library.

If you just want to overwrite the csv everyday and then import to excel then here is a simple script to do just that.
Attached File(s)
File Type: mq4 RatesToCSV.mq4   2 KB | 534 downloads
  • #44
  • Aug 17, 2017 2:58pm Aug 17, 2017 2:58pm
Quoting Robski
Hi hanover, Hope all is well. Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please? What I'd like to achieve is for a spreadsheet cell to change the value of the fx pair based on the daily closing price - this means that the cell's value would get overwritten every day. I have intraday prices working in my spreadsheet fine (importing it live from e-rates.com), but need the closing prices of the previous day to calculate changes between x-pairs. I appreciate I can input the closing prices manually...
Can be solved easily by using Excel's RTD() function.

https://www.forexfactory.com/showthr...td#post9989461

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #45
  • Aug 17, 2017 3:50pm Aug 17, 2017 3:50pm
Thanks everyone. It's much appreciated. I'll go through the suggestions over the weekend to see what I can make work.

Rob
  • #46
  • Oct 21, 2017 9:29pm Oct 21, 2017 9:29pm
Hi all,

I've been looking around the forum and founded this thread on what I'm interested for. Just asking some favors from you guys, is it possible to make indicators/EA that can read EXCEL value that was input manually and then the indicator/EA automatically draw the horizontal line on the specific pair that we input into the Excel. Kindly see the picture below. Your helps is really appreciated. Thanks!!
Attached Image (click to enlarge)
Click to Enlarge Name: Capture.PNG Size: 78 KB
  • #47
  • Sep 8, 2022 2:49pm Sep 8, 2022 2:49pm
import data from mt4 are from ohl candles data, but I look for csv file to import indicators data ( to select desired mt4 indicators or customized )
  • #48
  • Last Post: Sep 15, 2024 9:48am Sep 15, 2024 9:48am
Quoting piptakers
{quote} Dear hanover, I tried, in vain, all your suggestions, but was unable to get the required output as indicator. Also, I was unable to decode your code. So I did a search and research and wrote some piece of code for the same. Its working now. I am attaching the mq4 file and the csv data file (with sample data), so that others can benefit from it. My requirement was simple to plot the values 2 columns (2nd and 3rd column of csv) without any calculations. I have put comments and remarks inside the mq4 for the help, if some one wants to do some...
Thank you so very much piptakers and hanover for your generous contributions.

Green pips for you both!
0 traders viewing now