Historical 1 minute data request

NJ23

Well-Known Member
#1
Hello
I'm looking for 1 minute TF intraday data (the larger the history, the better). CSV/Text file/AmiBroker any format would do.
Instruments:
Currency Futures(NSE/MCX)
Metals and Energy(MCX)
Indices and Futures(NSE)

If anyone has this data can you please share?

Thanks in advance.
 

Raghuveer

Well-Known Member
#2
Hello
I'm looking for 1 minute TF intraday data (the larger the history, the better). CSV/Text file/AmiBroker any format would do.
Instruments:
Currency Futures(NSE/MCX)
Metals and Energy(MCX)
Indices and Futures(NSE)

If anyone has this data can you please share?

Thanks in advance.
See if these have what you want. Take a look at all links first and decide which ones you want to download.
Data by RM/sr114 is known/preferable.
http: //www. 4shared. com/account/home.jsp#dir=EiRxtDGu
Ami format currencies: https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing

http://www.traderji.com/intraday/95423-request-intraday-data.html#post1001210
http://www.traderji.com/amibroker/95075-ieod-1-min-nov13-feb14-fno-data-needed-3.html#post993859
http: //amibrokertraders.forumotion.in
http://www.traderji.com/metatrader/96369-mcx-1-min-data.html

Also see: http://www.traderji.com/intraday/95875-nse-ieod-sample-2009-1-min-4.html#post1026035

Please post if you manage to gather other MCX data.
 
Last edited:

NJ23

Well-Known Member
#3
See if these have what you want. Take a look at all links first and decide which ones you want to download.
Data by RM/sr114 is known/preferable.
http: //www. 4shared. com/account/home.jsp#dir=EiRxtDGu
Ami format currencies: https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing

http://www.traderji.com/intraday/95423-request-intraday-data.html#post1001210
http://www.traderji.com/amibroker/95075-ieod-1-min-nov13-feb14-fno-data-needed-3.html#post993859
http: //amibrokertraders.forumotion.in
http://www.traderji.com/metatrader/96369-mcx-1-min-data.html

Also see: http://www.traderji.com/intraday/95875-nse-ieod-sample-2009-1-min-4.html#post1026035

Please post if you manage to gather other MCX data.
Thanks Rahuveer,
I can't open the file you have shared. The CDS file. Can you help out please?
 

Raghuveer

Well-Known Member
#4
Thanks Rahuveer,
I can't open the file you have shared. The CDS file. Can you help out please?
CSV/Text file/AmiBroker any format would do.
The CDS files contain 1min data for currencies and are in AmiBroker format.
 

NJ23

Well-Known Member
#6
The CDS files contain 1min data for currencies and are in AmiBroker format.
No, the problem is the file is being downloaded as a binary file. I can't open it with any application(I've tried to open it with 7zip)
 
Last edited:

Raghuveer

Well-Known Member
#7
Thanks Raghuveer for the CDS data.

I am also not able to open it. How to open or get this data in Amibroker?
First method:
Uploaded text format zipped file "Currencies-1min-ASCII.7z" for 4 currencies. Download and extract using 7zip (or any other).
https://drive.google.com/file/d/0B2tN-DvFk0Dna0JBNldqVzc1bG8/view?usp=sharing

Data exported using afl by RM:
Code:
// R M 
// http://www.traderji.com/technical-analysis/69380-charts-day-130.html#post977652
// In the second line you have to change the required dates for data export, e.g., Buy = ( (DateNum() >= 1140601) AND (DateNum() <= 1140630) here export is from 01-06-2014 to 30-06-2014.



fmkdir( "C:\\OHLC" );
Buy = ( (DateNum() >= 1010101) AND (DateNum() <= 1150218) AND (TimeNum() > 090000) AND (TimeNum() < 170000) );
for( i = 0; i < BarCount; i++ )
if( Buy[i] )
{
  fh = fopen( "C:\\OHLC\\"+Name()+".txt", "a"); 
  if( fh ) 
   { 
     y = Year(); 
     m = Month(); 
     d = Day(); 
     r = Hour();
     e = Minute();
   
   for( i = 0; i < BarCount; i++ )
   if( Buy[i] )

   { 
      fputs( Name() + "," , fh );
      ds = StrFormat("%02.0f%02.0f%02.0f,", 
                     y[ i ], m[ i ], d[ i ] ); 
      fputs( ds, fh ); 
     
      ts = StrFormat("%02.0f:%02.0f,", 
                     r[ i ],e[ i ]); 
      fputs( ts, fh ); 

      qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f\n", 
                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ); 
      fputs( qs, fh );
   }
   fclose( fh );
   }
}
Second method:
OR try this - I did not do this before but from web search I think this works - http://www.amibroker.com/kb/2006/10/16/how-to-combine-two-databases-into-one/:
Use Amibroker files from https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing

  1. -save and close Amibroker.
  2. -backup broker.master in a folder outside of Amibroker db.
  3. -backup USDINR_F1 in a folder outside of Amibroker db.
  4. -copy and paste (overwrite) uploaded file USDINR_F1 into Amibroker db in the sub-directory corresponding to the first character of the symbol (../u/ folder for USDINR)
  5. -delete broker.master
  6. -start Amibroker
-now you must be able to see USDINR_F1 in symbol list and chart also.

@NJ23: Try and test Second method.
 
Last edited:

NJ23

Well-Known Member
#8
First method:
Uploaded text format zipped file "Currencies-1min-ASCII.7z" for 4 currencies. Download and extract using 7zip (or any other).
https://drive.google.com/file/d/0B2tN-DvFk0Dna0JBNldqVzc1bG8/view?usp=sharing

Data exported using afl by RM:
Code:
// R M 
// http://www.traderji.com/technical-analysis/69380-charts-day-130.html#post977652
// In the second line you have to change the required dates for data export, e.g., Buy = ( (DateNum() >= 1140601) AND (DateNum() <= 1140630) here export is from 01-06-2014 to 30-06-2014.



fmkdir( "C:\\OHLC" );
Buy = ( (DateNum() >= 1010101) AND (DateNum() <= 1150218) AND (TimeNum() > 090000) AND (TimeNum() < 170000) );
for( i = 0; i < BarCount; i++ )
if( Buy[i] )
{
  fh = fopen( "C:\\OHLC\\"+Name()+".txt", "a"); 
  if( fh ) 
   { 
     y = Year(); 
     m = Month(); 
     d = Day(); 
     r = Hour();
     e = Minute();
   
   for( i = 0; i < BarCount; i++ )
   if( Buy[i] )

   { 
      fputs( Name() + "," , fh );
      ds = StrFormat("%02.0f%02.0f%02.0f,", 
                     y[ i ], m[ i ], d[ i ] ); 
      fputs( ds, fh ); 
     
      ts = StrFormat("%02.0f:%02.0f,", 
                     r[ i ],e[ i ]); 
      fputs( ts, fh ); 

      qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f\n", 
                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ); 
      fputs( qs, fh );
   }
   fclose( fh );
   }
}
Second method:
OR try this - I did not do this before but from web search I think this works - http://www.amibroker.com/kb/2006/10/16/how-to-combine-two-databases-into-one/:
Use Amibroker files from https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing

  1. -save and close Amibroker.
  2. -backup broker.master in a folder outside of Amibroker db.
  3. -backup USDINR_F1 in a folder outside of Amibroker db.
  4. -copy and paste (overwrite) uploaded file USDINR_F1 into Amibroker db in the sub-directory corresponding to the first character of the symbol (../u/ folder for USDINR)
  5. -delete broker.master
  6. -start Amibroker
-now you must be able to see USDINR_F1 in symbol list and chart also.

@NJ23: Try and test Second method.
Thanks for the Text files. The second method also works. I didn't know that. Thanks.

BTW, do you mind letting the data source be known(I guess it's from your broker terminal)? I tried verifying yesterday's data for USD with all the three exchanges but it matches none. Closest one is NSE in terms of volume.
 

Raghuveer

Well-Known Member
#9
Thanks for the Text files. The second method also works. I didn't know that. Thanks.

BTW, do you mind letting the data source be known(I guess it's from your broker terminal)? I tried verifying yesterday's data for USD with all the three exchanges but it matches none. Closest one is NSE in terms of volume.
Currencies data upto August 2014 is from link posted in http://www.traderji.com/amibroker/95075-ieod-1-min-nov13-feb14-fno-data-needed-3.html#post993859.
Data after that is from NEST Plus data table.

Maybe some errors happened yesterday during export :confused:. But the Ami format files must not have any errors as they were simply copied to google drive.
Did the ami format files and text files match?

I exported and uploaded all text format currencies data again in file OHLC.7z. Download from same folder https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing
Please test and tell if it matches now.
 
Last edited:

shirajroz

Active Member
#10
Currencies data upto August 2014 is from link posted in http://www.traderji.com/amibroker/95075-ieod-1-min-nov13-feb14-fno-data-needed-3.html#post993859.
Data after that is from NEST Plus data table.

Maybe some errors happened yesterday during export :confused:. But the Ami format files must not have any errors as they were simply copied to google drive.
Did the ami format files and text files match?

I exported and uploaded all text format currencies data again in file OHLC.7z. Download from same folder https://drive.google.com/folderview?id=0B2tN-DvFk0DnZlBsYlp6blNkUFU&usp=sharing
Please test and tell if it matches now.

Thank u Raghuveer bro , u r a GEM
Raghuveer need a favor from u -- is it possible to upload (or provide a Link for ) atleast one month's tick by tick (NOT 1mnt ) data in .csv format or Ami DB format (may b compressed by 7Z) of CRUDEOIL, NIFTY, BNKNIFTY & USDINR.
Need them for Bar Replay.
Thank u
 

Similar threads