I was trying to search an option which will export the data from AmiBroker to a folder where the data will be stored in seperate csv sheets. Here is a simple trick to export your Amibroker EOD Database to CSV Format. For eg. Nifty will be stored in a sheet where the data will be there from the date specified in the Automatic Analysis window to the date specified in Automatic Analysis window
AFL Code for Exporting to CSV
Steps to Backup your Data
1)Save the Export to CSV AFL Code to C:\\Program Files\\AmiBroker\\Formulas\\Custom path
2)Create a Folder Name “Amibackup” in C:\\ Drive
3)Open Amibroker ->Analysis-> Automatic Analysis
4)Select All Symbols option from the Apply to coloumn and All Quotatios from the Range Column
you can also select specific Stocks by selecting the suitable options from the Apply to Column
5)Run SCAN
6)Amibroker Database converts to individual .csv file
Download Export CSV data from Amibroker AFL code
Here the limitation is that you cannot specifiy the range of Date. By Default it will download from starting date to
ending date
Related Readings and Observations
Buy RPL Futures Above 188 : Target 194 and 200 RPL Buy RPL May Futures above 188 Target Rs 194 & 200 Max.Profit = 12x1675 = Rs 20,100 Stop Loss Rs 185.40 Market Lot 1675 View Bullish Strategy […]
Nifty and Bank Nifty Future April Overview – I Nifty and Bank Nifty April futures in position buy mode on the hourly charts currently the support comes around 6660 and 12622 respectively. Reverse you position to positional sell mode if […]
Option Pain Charts for Nifty Option Pain, also known as Max Option Pain or Max Pain, is based on the theory that since most options buyers lose in options trading, the price of the underlying stock must be manipulated […]
Sayaji hotels : The Next Super Star in the Hotel Industry Scrip scan: Sayaji hotelsBse Code: 523710cmp : Rs89 Introduction: - Booming tourism industry and higher business travel has led to insufficient rooms in indian hotel […]
Nifty, Nifty Constituents and Escape Velocity Nifty : CMP 4327.47 Nifty Did it. Ya it takes nearly 24 trading sessions to make the candlestick to close exactly well below 20 day EMA(4385) but this time nifty […]
Updated Hourly Charts
Nifty nearing 200 MA(4351) - Check the blue line - which currently act as a strong resistance. I we are able to cross on closing basis then chance of a new uptrend. Else to […]
Great code
thank you
I cud backup my ami data
Hi.. Thanks for the code.. Assume that My hard disk’s C drive crashed due to virus and I can’t able to retrieve any past datas.. So, I’ll format the disk and will create a new database which will accept only .txt format..
My question is,Is it possible to create Ami database which will accept both .csv and .txt format..? Since, our backup is in .csv format I raised this Question..
Thank you..
Yeh Govindharaj… It supports both .txt and .csv format… you just simply edit the afl code and change it to ur required format and get the backup….
Now use import wizard and import ascii funtionality to import those backup data into ur new amidatabase
Hi.. I just replaced .csv with .txt in the first line of the code and got backup in .txt format.. Sorry for the previous post..
But, how to use these datas in a new Database..?
Thank you..
formula error display
Can this be used for IEOD?
yes it can used for IEOD you need to edit the code according to your required output format. Small knowledge of C/C++ is good enough to edit the code
sir idon’t know how to Backup you Amibroker EOD Database in CSV Format can you help to do this pleas sir
i have team wever.
im trader
Dear Rajendran,
While i am trying to take backup the database in amibroker using the above afl it shows an syntax error as below..
fh = fopen( “
—————-^
Error 31.
Syntax error, unexpected $end, expecting ‘)’ or ‘,’
Kindly help in this regard.
Regards,
Swetharanyan
@Swetharanyan
Copy the AFL code from here directly to your notepad and from notepad then copy to your amibroker code editor. Direct copying from
website sometimes creates Double quotation problem.
Yeh spot out the problem. Now it is corrected.
sir,
i am also getting syntax error
While i am trying to take backup the database in amibroker using the above afl it shows an syntax error as below..
fh = fopen( “
—————-^
Error 31.
Syntax error, unexpected $end, expecting ‘)’ or ‘,’
i have adopted the solution u suggested but , its showing error
Hi Sameer,
try this
fh = fopen( “c:\\AmiBackup\\”+Name()+”.csv”, “w”);
if( fh )
{
fputs( “Ticker,Date,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;
Hi, Still the same syntax error appears, pls help.
hi
still the same syntax error apears
i had already done copy to note pad and then copy to farmula
still not working any solution to save data in amibroker ????
solved the problem of syntax error..
the inverted commas should be replaced
for example -- fh = fopen( “c:AmiBackup”+Name()+”.csv”, “w”);
to
fh = fopen(“C:AmiBackup”+Name()+”.csv”, “w”);
this will solve the problem. although you will have to change all the commas in the code.. not just in this line
Nice utility. One query where does it store the csv file?
I am able to resolve on my own. I created the directory named amibackup and also replaced “//” with “\\”
thanks a ton
Hi Rajendran,
I am having a bit of a problem with this code. Firstly, I was trying to export intraday data. So I removed the comments to include time. I am afraid the data is coming in one continuous line and there are no line breaks. The time is also not coming correctly they are all coming as 00:00:00.
When I see the data in the quote editor and of course in Ami the data is displayed correctly as bars.
My final code is pasted below for ready reference.
Please help…
TIA
Praveen.
Code===========================
fh = fopen( “c://AmiBackup//”+Name()+”.csv”, “w”);
if( fh )
{
fputs( “Ticker,Date,Open,High,Low,Close,Volume”, 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",O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );
fputs( qs, fh );
}
fclose( fh );
}
Buy = 0;
Code ends=====================================
Sample output data==============================
Ticker,Date,Open,High,Low,Close,VolumeNIFTY-I,2012-01-02,00:00:00,4637.7998,4656.0000,4592.3999,4648.1001,277565NIFTY-I,2012-01-03,00:00:00,4680.5498,4794.3999,4680.5498,4783.2002,362152NIFTY-I,2012-01-04,00:00:00,4775.2002,4799.0000,4737.6001,4760.2002,353400NIFTY-I,2012-01-05,00:00:00,4759.0000,4791.8501,4740.1001,4758.1001,271152NIFTY-I,2012-01-06,00:00:00,4745.0000,4821.0000,4692.6001,4771.9502,450646NIFTY-I,2012-01-09,00:00:00,4748.3501,4778.0000,4705.1499,4751.7998,321543NIFTY-I,2012-01-10,00:00:00,4780.0000,4876.2998,4779.5000,4870.2998,392413NIFTY-I,2012-01-11,00:00:00,4805.0000,4889.0000,4805.0000,4872.3501,266376
Thanx Rajendran,
I figured out the issue… Guess, the line feeds are missing.. Thats the reason for the data coming continuous.
As regards the time stamp issue, it needs to be set in the settings to one minute and then it comes out just fine.
Posting it here so that others may also benefit…
HIH,
Praveen.
Corrected Code===========================
fh = fopen( “c://AmiBackup//”+Name()+”.csv”, “w”);
if( fh )
{
fputs( “Ticker,Date,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 );
}
hi
is there any update of the afl for exporting the explorer data to excel/csv…?
looking for that please…
Thanks