NF tick data for 21Jan2010 to 02Feb2010

shanki99

Well-Known Member
#1
Someone

Plz help me by sharing NF and BankNF futures TICK data for the dates between 21Jan2010 and 02Feb2010.

Those who dont know how to export in Ami

Analysis>>Automatic Analysis

Pick the below mentioned saved Export Query

Select Symbol as NIFTY Fut/ Banknifty Fut

In Settings>>General Tab>> Periodicity field>> Select TICK

Press Explore button in Auto analysis window

Bingo !....data is populated

Press down arrow in File Button in Auto analysis main window

Select EXPORT and Select Save as File Type as TEXT (saving as .csv file type has some date issues and so text file type is always preferable)

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);
 

pkgmtnl

Well-Known Member
#2
Use this AFL and Scan, it will save the TXT file in c:\savadata folder

but make sure u hav this data folder in C:\ if not make


_SECTION_BEGIN("Export Intraday Data");

fh = fopen( "c:\\SaveData\\"+Name()+".txt", "w");
if( fh )
{
fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume,openintrest \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,%.0f\n",
O[ i ],H[ i ],L[ i ],C[ i ],V[ i ],OI[ i ] );
fputs( qs, fh );
}

fclose( fh );
}

Buy = 0;
_SECTION_END();
 

sub2501

Active Member
#3
hi PKGMTNL,
this afl has a defect as i've found it exports the quotes wrt to time and not wrt to date, i mean to say the quotes are like
PHP:
Ticker,Date,Time,Open,High,Low,Close,Volume 
^NSEI,2008-01-02,15:30:55,6172.0000,6196.6499,6063.5000,6176.1499,0
^NSEI,2008-01-03,15:30:55,6141.7002,6229.2998,6138.4502,6178.3999,0
^NSEI,2008-01-04,15:30:55,6226.3501,6298.9502,6201.2500,6261.8501,0
^NSEI,2008-02-07,15:30:55,5337.7998,5341.2500,5115.2500,5131.6001,0
^NSEI,2008-09-01,15:30:55,4316.2002,4364.5000,4281.6001,4360.5498,0
^NSEI,2008-09-02,15:30:55,4372.3501,4521.2500,4348.6499,4501.6499,0
^NSEI,2008-09-04,15:30:55,4448.6001,4504.0000,4419.7998,4453.7002,0
^NSEI,2008-09-05,15:30:55,4348.0498,4444.3501,4329.2998,4355.3501,0
it could be the defect in my settings but there is no mistake in formula ie ur formula and the formula i found at amibroker site is the same. pls help
 

sub2501

Active Member
#5
sorry for the above post, actually there was some default in amibroker, pls download from the link below of NF and can any one pls give the ieod of reliance, well i uninstalled and reinstalled amibroker and during the process i deleted reliance quotes pls can upload it,

PHP:
http://rapidshare.com/files/355170321/NIFTY_F1.rar.html
 

sub2501

Active Member
#7
sorry this time, i dont have tick data i analyse on minimum 1min data,
any thing more pls knock !!!!!!!!!!!!!!!!!!!!!!
 

Similar threads