Export Data from Amibroker to ASCII files

J

jb1222

New Member
#14
#14
Thanks a lot Pramod for this formula!

Btw is it possible to add more intervals to the Periodicity list so that
export to other custom intervals will be possible. For example now
it is not possible to export to 30 min, 45 min or 135 min intervals....
and such intervals are very useful to look at.

jb
 
G

gerybubus

New Member
#15
#15
Dear pramodvarmag and forum members,

I'd like to export data from Amibroker to ASCII csv file. But not just ticker, date, time, colse and volume columns, but RSI, ROC, %K-%D, MACD, OVB etc. (indiators) data too.
How can I do this? I coundn't find it in the AmiBroker help menu. :-(
I'd like to export minutely data, so each line of csv file will represet one minute data.
Can somebody help me to write such AFL file?

Thanks
Gery
 
A

amibroker-india

Member
#16
#16
gerybubus said:
Dear pramodvarmag and forum members,

I'd like to export data from Amibroker to ASCII csv file. But not just ticker, date, time, colse and volume columns, but RSI, ROC, %K-%D, MACD, OVB etc. (indiators) data too.
How can I do this? I coundn't find it in the AmiBroker help menu. :-(
I'd like to export minutely data, so each line of csv file will represet one minute data.
Can somebody help me to write such AFL file?

Thanks
Gery
Click to expand...
Hello,

See this. It has answer to your query.

http://www.amibroker.com/kb/2006/03/04/how-to-export-quotations-from-amibroker-to-csv-file/

You will have to add columns for other details (RSI, ROC, etc.) to be exported.

I hope this helps.

Best regards,

AmiBroker-India
 
G

gerybubus

New Member
#17
#17
Dear amibroker-india,

sorry but I haven't found the answer for my question yet. :-((
It's just candle stick data too.

What sould I change on the following line to refer to the indicators data:

qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f\n", O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );

I'd like to export MA(Close,15), MA(Close,45), MACD(12,26), RSI(15), OBV, TRIX(9) data too.

I tried MA(Close,15)[ i ] but I got syntax error. :-(
 
G

gerybubus

New Member
#18
#18
Well, the following syntax works fine:

Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
AddColumn( RSI(14), "RSI");
AddColumn( MACD(), "MACD");
AddColumn( MA(C,15), "MA15");
AddColumn( MA(C,45), "MA45");
AddColumn( MA(C,100), "MA100");

But remember to set the correct PERIODICITY in AA window settings. (for intraday data)

Thanks!
 
C

cyberman

New Member
#20
#20
Hello All,

Can anyone tell me how to export the data using this formula to 5 decimal places? Right now it is exporting to 2 decimal places only which is no good for Forex.

Thank You
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M Amibroker One minute Data export to csv file AmiBroker 3
D Amibroker data Export in Ninja format Afl AmiBroker 7
B Export data to file from Amibroker AmiBroker 0
M Amibroker to Metastock data export Development of Software Utilities 3
yasu222 Tradetiger to Amibroker data export in offline mode Data Feeds 16

Similar threads