Reading News from a CSV file | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Reading CSV into Indicator Buffer 4 replies

Reading and writing a CSV question 3 replies

.CSV Files Editing and Reading 2 replies

Export RSI data to a csv file? 1 reply

Attachments: Reading News from a CSV file
Exit Attachments

Reading News from a CSV file

  • #1
  • First Post: Apr 8, 2010 1:28am Apr 8, 2010 1:28am
Hi All,

The idea I have is that, once a week I download a csv file with the high impact news and I want my EA to read it and to filter trade times based on those events.

Does anyone know of an easy way to go about this? Below is the way the columns in the file are presented.

Thanks in advance
Attached Image (click to enlarge)
Click to Enlarge Name: news.gif Size: 23 KB
  • #2
  • Apr 8, 2010 2:16am Apr 8, 2010 2:16am
Ok.. so a couple of questions.. no on second thoughts;

does anyone know of a piece of code that they could point me to that I could use as an example?
  • #3
  • Edited 8:54am Apr 8, 2010 8:53am | Edited 8:54am
hi asgard,

the basic of accessing csv file and save each cell in a 2 dimension array:
PHP Code
   FileName = "mydata.csv";
   string s[10][100]; //assign array of string that will store 10 columns 100 rows of csv data
   int row=0,col=0; //column and row pointer for the array
   int handle=FileOpen(FileName,FILE_CSV|FILE_READ,","); //comma delimiter
   if(handle>0)
   {
     while(True) //loop through each cell
     {
       string temp = FileReadString(handle); //read csv cell
       if(FileIsEnding(handle)) break; //FileIsEnding = End of File
       s[col][row]=temp; //save reading result to array
       if(FileIsLineEnding(handle)) //FileIsLineEnding = End of Line
       {
         col = 0; //reset col = 0 for the next row
         row++; //next row
       }
       else
       {
         col++; //next col of the same row
       }
     }
     FileClose(handle);
   }
   else
   {
     Comment("File "+FileName+" not found, the last error is ", GetLastError());
   }
The EA below will read a csv file located on tester/files folder on init section, and output each cell by using Comment(). In the real implementation, you can read csv data once on an array in init section. Then in start() section, you only need to access that array

hth
Attached File(s)
File Type: mq4 readcsv.mq4   1 KB | 1,343 downloads
File Type: csv mydata.csv   < 1 KB | 1,177 downloads
  • #4
  • Apr 8, 2010 5:22pm Apr 8, 2010 5:22pm
Hi Sangmane,

Excellent example! Thanks so much for your help, I think you saved me about a week.
  • #5
  • Aug 20, 2014 6:10am Aug 20, 2014 6:10am
Hi Sangmane,
Your EA works wonderful for me,now my csv like this:
Time Bid Ask
2014.08.20 08:14:26 171.754 171.794
2014.08.20 08:14:27 171.754 171.792
2014.08.20 08:14:29 171.755 171.793
2014.08.20 08:14:29 171.756 171.795
2014.08.20 08:14:31 171.756 171.796
2014.08.20 08:14:31 171.756 171.796
2014.08.20 08:14:31 171.756 171.795
2014.08.20 08:14:33 171.755 171.795
2014.08.20 08:14:33 171.755 171.793
2014.08.20 08:14:33 171.757 171.794
2014.08.20 08:14:34 171.757 171.795
2014.08.20 08:14:34 171.757 171.797
2014.08.20 08:14:34 171.758 171.794
2014.08.20 08:14:34 171.758 171.796
2014.08.20 08:14:34 171.758 171.799
2014.08.20 08:14:34 171.758 171.798
2014.08.20 08:14:34 171.761 171.8
2014.08.20 08:14:34 171.76 171.8


Can you show me the way to read the last line and the last-n line?
  • #6
  • Nov 11, 2014 1:57pm Nov 11, 2014 1:57pm
Hi,

I need same as above instead of printing the values, I need to put into the structure using FileReadStruct or FileReadArray function and then print values from the structure. Can anyone have suggestion or piece of code on this.

Thanks & Regards
Pazhani
  • #7
  • Last Post: Nov 11, 2014 8:56pm Nov 11, 2014 8:56pm
I use this to read from a news csv file which only has in it the following format: 2014.10.28 14:25

The file is read and the date and time read into an array which is then used to halt trading.

in my EA the code is:

//--- parameters for data reading
string InpFileName ="News.csv"; // file name
string InpDirectoryName="Data"; // directory name



int openTheFile()
{
//--- open the file
ResetLastError();
int file_handle=FileOpen(InpDirectoryName+"\\"+InpFileName,FILE_READ|FILE_WRITE|FILE_CSV);
if(file_handle!=INVALID_HANDLE)
{
PrintFormat("%s file is open for reading",InpFileName);
int i=0;
//--- read data from the file
while(!FileIsEnding(file_handle))
{
//--- signal time
time_buff[i]=FileReadDatetime(file_handle);
i++;
}
//--- close the file
FileClose(file_handle);
}
else
{
PrintFormat("Failed to open %s file, Error code = %d",InpFileName,GetLastError());
return(-1);
}
return(1);
}
" check out The Traders Outpost "
0 traders viewing now