Banknifty Fut iEOD data

shanki99

shanki99

Well-Known Member
#1
#1
Can someone share Banknifty Futures iEOD data for the period from 19Sep09 to 25Nov09 by just pressing the Export button in Amibroker

I lost those data some time back

To be frank iam a bit lazy to download those data, that too past data

Those who help me, i guarantee them that i will take a back up regularly

Thanx

Those who dont know how to export in Ami

Analysis>>Automatic Analysis

Pick the below mentioned Export Query

Select Symbol as Banknifty Fut

In Settings, Select 1 min periodicity

Press Explore button in Auto analysis window

Bingo !....data is populated

Press down arrow in File Button in Auto analysis main window

Press Export and save the data

Plz send it to me


Export Query
Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
 
sub2501

sub2501

Active Member
#2
#2
this is the 1st time i'm doing, pls check the data
thanks.

Link :-http:/ / rapidshare. com/files/319277208/bank_nifty_fut.rar.html
MD5: F038169818D94C6486DD8780BDCA3B11
remove spaces thanks
subha.
 
shanki99

shanki99

Well-Known Member
#3
#3
Thanx Suba for the data

The data is fine but there are problems while i try to download the data into Amibroker

The AM PM on the time field is causing trouble

I have been trying to resole this for many days but cud not succeed

If there is no AM PM in the time field, then data is getting uploaded properly, otherwise not

Can some one help me on this??

Thanx in advance
 
sub2501

sub2501

Active Member
#4
#4
hi shanki
I've uploaded the banknifty in another .csv format, pls check whether it shows the error or not,
if it doesnot show then there is mistake in the afl-"price export" wherein the date/time comes together whereas it should come in different column.
thanks
subha.
 
Last edited:
shanki99

shanki99

Well-Known Member
#5
#5
sub2501 said:
hi shanki
I've uploaded the banknifty in another .csv format, pls check whether it shows the error or not,
if it doesnot show then there is mistake in the afl-"price export" wherein the date/time comes together whereas it should come in different column.
thanks
subha.
Click to expand...
Hi Subha

Thanx for ur response

U came back a bit late and in between I broke my head and finally cud resolve it by adding a separate Time column and by manually filling it for many dates.

But the correct solution cud be instead of saving the export file as .csv, save it as a plain vanilla text file. There is no issue with date in case of txt file. The same AFL is sufficient.

Anyways thanx again

Btw where are u from ? Coimbatore?
 
sub2501

sub2501

Active Member
#6
#6
hi, i'm from northeast india(nagaland) might have heard, well i found an afl to convert the intraday amidata into text and it directly saves the data to ur specefied folder.

The afl is given below:-
PHP: 
fh = fopen( "c:\\nameoffolder\\"+Name()+".txt", "w"); 
if( fh ) 
{ 
   fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume \n", fh ); 
   y = Year(); 
   m = Month(); 
   d = Day(); 
   r = Hour();
   e = Minute();
   n = Second();
   
   for( i = 0; i < BarCount; 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:%02.0f,", 
                     r[ i ],e[ i ],n[ i ] ); 
      fputs( ts, fh ); 

      qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f\n", 
                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ); 
      fputs( qs, fh ); 
   } 

   fclose( fh ); 
} 

Buy = 0;
In the 1st line specify the path where u want to save the data in place of- nameoffolder
thanks
subha

#########what abt the odin project????????
 
T

Trader4242

Active Member
#8
#8
sub2501 said:
hi, i'm from northeast india(nagaland) might have heard, well i found an afl to convert the intraday amidata into text and it directly saves the data to ur specefied folder.

The afl is given below:-
PHP: 
fh = fopen( "c:\\nameoffolder\\"+Name()+".txt", "w"); 
if( fh ) 
{ 
   fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume \n", fh ); 
   y = Year(); 
   m = Month(); 
   d = Day(); 
   r = Hour();
   e = Minute();
   n = Second();
   
   for( i = 0; i < BarCount; 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:%02.0f,", 
                     r[ i ],e[ i ],n[ i ] ); 
      fputs( ts, fh ); 

      qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f\n", 
                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ); 
      fputs( qs, fh ); 
   } 

   fclose( fh ); 
} 

Buy = 0;
In the 1st line specify the path where u want to save the data in place of- nameoffolder
thanks
subha
Click to expand...
Hello subha

Thanks for the excellent code for exporting data to a text file.

Thanks

:)
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
P Request - for 1minute IEOD data of BankNifty Future from Dec,2017 backwards.... Intraday 3
A Banknifty futures IEOD data Intraday 0
A Banknifty futures IEOD data Futures 5
S BankNifty Spot & Future price Difference Futures 2
S BankNifty Future Intraday Hedging Strategy Introductions 2

Similar threads