Sunday, September 18, 2022

Export Amibroker Database All in One


Export database in csv or txt . Select parameter File Format .txt or .csv

Export data desired period. Select From Date and To Date in parameter.

Export data without timestamp stamp for EOD. Timeframe iEOD export with timestamp. EOD export without timestamp.

Define ouput file path in PC. Entrer drive in Output Drive. Enter folder name in Output Folder Name.

Export Name of Symbol without expiry date. Parameter Segment , Equity export the same name . Futures remove unwanted part and suffix -I or given value. Options remove expiry data or weekly and rename as Spot+Strike+CE/PE

Parameter Settings:

Future - No. of Characters after Name. To cut underlying Name. Eg. From BANKNIFTY-I.NFO to BANKNIFTY it need to cut 6 characters . So enter 6. To Cut BANKNIFTY22SEPFUT, it need to enter 8. 

Future suffix. suffix to be added with above cut name. It cut name as above and suffix given value. BANKNIFTY-I.NFO to BANKNIFTY-I

Options - No. of Characters after Name. same as said for Futures.

Number of characters between Name and Strike. For BANKNIFTY_40000CE-15SEP2022 , there is underscore only between BANKNIFTY and 40000, So enter 1.

Length of Strike Price. For strike price 40000 have 5 digit. So enter 5.

Number of characters between Name and CE/PE. For BANKNIFTY_40000CE-15SEP2022, Between BANKNIFTY and CE , there is _40000, So enter 6

If you want export Aux1 and Aux2 also two lines disabled with // enable this and disable alternate line.

Select timeframe in Periodicity of Analysis Settings, like 1 Minutue, 5 Minute, Daily as required timeframe for export data. Click Explore to check settings are correct and click Scan to export


Freelance for Setup, Suggestions and Modifications

AFL Download