MCX Crude IEOD data

RockyRobust

Well-Known Member
#21
Thanks bro . i dont know how to extract IEOD from amibroker ( if you know pls share) . This data i extracted directly from nest using RTD But i dont know why data available from 28 july .
There is an IEOD data Export AFL which helps in exporting the Data from Amibroker in csv or txt format whatever you prefer.

Here is the code:

fmkdir( "C:\\SaveData" );
Buy = Status( "barinrange" );

//if we want to export data for a single Day, we modify the Second line like this
//Buy = ( (DateNum() == 1070129));

for( i = 0; i < BarCount; i++ )
if( Buy )
{
fh = fopen( "C:\\SaveData\\EOD.csv", "a");//if we want to export all data in a single file//
// fh = fopen( "C:\\SaveData\\"+Name()+".txt", "a");// if we want to export data in an individual file//
if( fh )
{
y = Year();
m = Month();
d = Day();
// r = Hour();
// e = Minute();

for( i = 0; i < BarCount; i++ )
if( Buy )

{
fputs( Name() + "," , fh );
ds = StrFormat("%02.0f/%02.0f/%02.0f%02,",
y[ i ], m[ i ], d[ i ] );
fputs( ds, fh );

// ts = StrFormat("%02.0f:%02.0f,",
// r[ i ],e[ i ]);
// fputs( ts, fh );

qs = StrFormat("%g,%g,%g,%g,%1.0f\n",
O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );
fputs( qs, fh );
}
fclose( fh );
}
}


Just use this AFL through the New Analysis & Scan the Tickers the data for which you have to export. Also choose the From Dates to End Date , the time period for which you want to get data. Through settings choose the Time Frame like 1 min., 5 min. etc , in which you want the data.
 
#23
The time stamp in this data is not right. The data most probably is showing GMT Timestamp.
Its not my data.
Its the same data as in post 17 (NT data) converted to ami data.
So cant say anything about its time stamp.
 
#24
The data provided does not seem to be accurate and even the time zone is different. Still looking for the MCX crude data. Can anyone please help
 

yachusai

Well-Known Member
#25
The data provided does not seem to be accurate and even the time zone is different. Still looking for the MCX crude data. Can anyone please help
Bro if you import data in NT7 before import choose IST timezone .if chart doesnt plot correctly then again import using utc .
 

chintan786

Well-Known Member
#26
can anyone upload Nifty Sep series data of 31st Aug 2017 in NT-7 format.

Regards,
 
#28
This data starts from 9.16 and not 9.15
If you want start from 9.15
then I have that also, but problem in this one is (dont know how it mixed up)
one line is aug series and next line is sep series and it continued till end and so for sep data you have to delete every other line of aug series.
So if you are ready to take this much pain then let me know, I will convert it to Ninja format and post

A sample is like this
NIFTY17SEPFUT 20170831;091500;9871.0000;9883.0000;9871.0000;9875.2000;86925; aug series
NIFTY17SEPFUT 20170831;091500;9891.1000;9912.4000;9891.1000;9904.1000;50700; sep series
NIFTY17SEPFUT 20170831;091600;9875.2000;9875.5000;9869.4000;9871.9500;67875;
NIFTY17SEPFUT 20170831;091600;9904.1000;9904.5000;9898.0000;9898.0500;22125;
NIFTY17SEPFUT 20170831;091700;9870.0000;9873.0000;9868.2500;9873.0000;42900;
NIFTY17SEPFUT 20170831;091700;9898.0500;9900.0000;9897.3500;9900.0000;36825;
NIFTY17SEPFUT 20170831;091800;9873.0000;9875.0000;9872.0000;9872.0500;27750;
NIFTY17SEPFUT 20170831;091600;9904.1000;9904.5000;9898.0000;9898.0500;22125;
NIFTY17SEPFUT 20170831;091700;9870.0000;9873.0000;9868.2500;9873.0000;42900;
NIFTY17SEPFUT 20170831;091700;9898.0500;9900.0000;9897.3500;9900.0000;36825;
NIFTY17SEPFUT 20170831;091800;9873.0000;9875.0000;9872.0000;9872.0500;27750;
 

chintan786

Well-Known Member
#29
You may download (NF SEP data in Aug series of 31.8 in NT format) from following link
Cannot vouch for data.
If you find it useful then use it otherwise throw in the dustbin.
Not my data
Collected from different sources and converted to Ninja format.

https://www.sendspace.com/file/n5smk8
Not Working at my end. reqiure data in below format only:
20170831 091500; 9871.0000; 9883.0000; 9871.0000; 9875.2000; 86925;
 
#30
Not Working at my end. reqiure data in below format only:
20170831 091500; 9871.0000; 9883.0000; 9871.0000; 9875.2000; 86925;
Is there a space in between 091500; 9871.0000; and so on in a row. It seems so but I do not find a space in NT data files that I have.
Further you also do not want ticker.

I will try to get data in this format and will post if I get it.


Presently, I can post as per your requirement for NT data (as per sample below),
but then you have to delete every other line (of aug series), as mentioned in post 28 above.

A sample is like this
20170831 091500; 9871.0000; 9883.0000; 9871.0000; 9875.2000; 86925; aug series
20170831 091500; 9891.1000; 9912.4000; 9891.1000; 9904.1000; 50700; sep series
20170831 091600; 9875.2000; 9875.5000; 9869.4000; 9871.9500; 67875;
20170831 091600; 9904.1000; 9904.5000; 9898.0000; 9898.0500; 22125;
20170831 091700; 9870.0000; 9873.0000; 9868.2500; 9873.0000; 42900;
20170831 091700; 9898.0500; 9900.0000; 9897.3500; 9900.0000; 36825;
 

Similar threads