Export Data from Amibroker to ASCII files

pramodvarmag · #1 31st January 2007, 09:37 AM

Export Data from Amibroker to ASCII files

Here there is a formula available to export data from Amibroker to ASCII files. With the formula we can export data for a specified period from Amibroker database.

How to export:

Download,unzip and copy this afl formula file to Amibroker\Formulas\Custom folder.
Scan with the formula in Automatic Analyser (AA) in Amibroker.
The formula will create a folder in C drive named 'OHLC' and will collecte the data in separate text files for each symbol.

Periodicity:

WE can export the data for different periodicity 1min, 5min, 10min or daily etc. as we required. To configure that go to AA > settings > General > Periodicity and set periodicity. Thus we can get data for 5min, 10min, 1 Hour, daily etc.

Select Date Range:

To set the date range, we have to edit the formula.
Open AA > pick (the formula file) > edit.
In the second line we can see:

Buy = ( (DateNum() >= 1061225) AND (DateNum() <= 1070110) );

First DateNum is the start date and second DateNum is end date.
The current settings will export data from 20061225 to 20070110.
Just like that, we can select another date range. Instead of 2006, should give 106 and for 2007, give 107 etc. Month and date are same. Save the formula and scan it.
It will export and save the data in C:\OHLC folder.
If you want to export for an another date range, that will also be added to the corresponding files just after the current data.

Hello Traders,

I request you to use this formula and let me know the feedback.

Thanking you,
Regards,
Pramod.
pramodvarmag@*****.com

soumya_b · #2 31st January 2007, 07:16 PM

thanx 4 sharing it....it is working fine...
is it possible to export all shares in a single file?

regards,
soumya

pramodvarmag · #3 31st January 2007, 07:24 PM

Saumya,

It may be possible. I have not tried. If I get any solution I will tell here

Regards,

Pramod

rkgoyal_98 · #4 31st January 2007, 11:12 PM

Dear Soumya
Hello,
Yes it is possible
Just change 2 things

1. In the file open instead of Name(), use the file whatever u want ie 31012007.txt
2. Use a instead of w

It will read like this
fh = fopen( "C:\\IntradayData\\31012007.txt", "a");
it may need that file is opened before the loops and header line also added before the loop starts

I will send ou complete file in a day or 2
Rajeev

Thanks

rkgoyal_98 · #5 1st February 2007, 12:11 AM

Dear Soumya and Pramod

Hello

I have modified the formulla to put all the scrips in one file, however i had to remove the header line as it was being added in the middle of file with each ticker. I could not tackel how to put header line only once in the file as file is closed with each ticker and opened in append mode again. Strangel it has made the AFL i bit faster too
Just try
Thanks

pramodvarmag · #6 1st February 2007, 09:03 AM

Dear Rajeev and Soumya,

the new formula from Rajeev is working well. But Irrespective of the existance of data in the given date range, the formula creates the output file. So, If the given range is empty, an empty file will be created. This can be avoided by placing file opening command under the 'if' condition.
Enclosed the modified afl here. try this.

If we want to oexport data for a single day, we modify the second line like this
Buy = ( (DateNum() == 1070131);

Regards,
Pramod.

swagat86 · #7 12th March 2007, 10:31 PM

Quote:

Originally Posted by pramodvarmag

Export Data from Amibroker to ASCII files

Here there is a formula available to export data from Amibroker to ASCII files. With the formula we can export data for a specified period from Amibroker database.

How to export:

Download,unzip and copy this afl formula file to Amibroker\Formulas\Custom folder.
Scan with the formula in Automatic Analyser (AA) in Amibroker.
The formula will create a folder in C drive named 'OHLC' and will collecte the data in separate text files for each symbol.

Periodicity:

WE can export the data for different periodicity 1min, 5min, 10min or daily etc. as we required. To configure that go to AA > settings > General > Periodicity and set periodicity. Thus we can get data for 5min, 10min, 1 Hour, daily etc.

Select Date Range:

To set the date range, we have to edit the formula.
Open AA > pick (the formula file) > edit.
In the second line we can see:

Buy = ( (DateNum() >= 1061225) AND (DateNum() <= 1070110) );

First DateNum is the start date and second DateNum is end date.
The current settings will export data from 20061225 to 20070110.
Just like that, we can select another date range. Instead of 2006, should give 106 and for 2007, give 107 etc. Month and date are same. Save the formula and scan it.
It will export and save the data in C:\OHLC folder.
If you want to export for an another date range, that will also be added to the corresponding files just after the current data.

Hello Traders,

I request you to use this formula and let me know the feedback.

Thanking you,
Regards,
Pramod.
pramodvarmag@*****.com

thanks 4 the AFL bro

P.SUHAS T&I · #8 17th August 2007, 07:49 PM

excellent work, pramod ......many many thanks
p.suhas
trader & investor

chheda · #9 18th August 2007, 01:13 AM

Quote:

Originally Posted by pramodvarmag

Export Data from Amibroker to ASCII files

Here there is a formula available to export data from Amibroker to ASCII files. With the formula we can export data for a specified period from Amibroker database.

How to export:

Download,unzip and copy this afl formula file to Amibroker\Formulas\Custom folder.
Scan with the formula in Automatic Analyser (AA) in Amibroker.
The formula will create a folder in C drive named 'OHLC' and will collecte the data in separate text files for each symbol.

Periodicity:

WE can export the data for different periodicity 1min, 5min, 10min or daily etc. as we required. To configure that go to AA > settings > General > Periodicity and set periodicity. Thus we can get data for 5min, 10min, 1 Hour, daily etc.

Select Date Range:

To set the date range, we have to edit the formula.
Open AA > pick (the formula file) > edit.
In the second line we can see:

Buy = ( (DateNum() >= 1061225) AND (DateNum() <= 1070110) );

First DateNum is the start date and second DateNum is end date.
The current settings will export data from 20061225 to 20070110.
Just like that, we can select another date range. Instead of 2006, should give 106 and for 2007, give 107 etc. Month and date are same. Save the formula and scan it.
It will export and save the data in C:\OHLC folder.
If you want to export for an another date range, that will also be added to the corresponding files just after the current data.

Hello Traders,

I request you to use this formula and let me know the feedback.

Thanking you,
Regards,
Pramod.
pramodvarmag@*****.com

Thnx for export data afl

Is it possible to import data in amibroker using AFL ?

Harish Chheda

pramodvarmag · #10 18th August 2007, 09:33 AM

Hi Harish,

No need of any formula to import data to Amibroker. There is built-in tool in file menu to import ASCII files to Amibroker.

Similar Threads for: Export Data from Amibroker to ASCII files
Thread	Thread Starter	Forum	Replies	Last Post
TradeStation 8.1 : ASCII 3rd Party Data	trader68	Intraday	7	22nd March 2007 01:06 AM
BSE NSE Groups in data files	rrdesai_goa	Data Feeds	1	14th March 2007 01:13 PM
Export Intraday Data.afl	rkgoyal_98	AmiBroker	1	2nd January 2007 11:08 PM
Export to Individual files	swagat86	AmiBroker	1	16th November 2006 05:26 PM
Some advice to add records in ASCII Data files.	a_n_i_l	Software	0	15th September 2006 11:30 AM

The Following User Says Thank You to pramodvarmag For This Useful Post:
scs_r (11th October 2008)