how to copy ieod data from ami " Quotation editor to Excel ?"

#3
Hello friends

i want help

how to copy ieod data from ami " Quotation editor to Excel ?"


thx
paresh



Just paste this code in FORMULA EDITOR in your Amibroker and hit scan button in automatic analysis........you cannot select certain period from date to to date.......by default all quotes will be imported.




// #### READ THIS FIRST #### READ THIS FIRST #### READ THIS FIRST #### READ THIS
// created a directory on your C drive named AmiBroker data backup
dayhours = ParamToggle("Day hours only", "No|Yes");
fmkdir("c:\\AmiBackup\\");
SetBarsRequired(100000,100000);
lname = Name(); // gets the name of the symbol
// note: if you have names with invalid characters like / you must rename the file before you try to create a Name
// add an IF line for each symbol you need to rename
if (lname == "ER2U8-GLOBEX-FUT") lname = "ER2U8";

/*
Export intraday and EOD data to TXT files
One file for each stock
In the first line insert the directory you want to save them to, make sure the
directory exists
Select your charts to export with the "Apply to" filter in AA window
Select the timeframe period you want to save as using the AA "Settings"
Press Scan button
*/

fh = fopen( "c:\\AmiBackup\\"+Name()+".txt", "w");
if( fh )
{
fputs( "", 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 = 1;

Buy = 1;
 
#4
Thanks for the afl

But what changes, I have to do, to get IEOD data (say for 1 min or 15 mins or 60 mins).
Using this afl as it is, I get EOD data

And also if I want to get data for selected scrips.

Thanks
 

Similar threads