Originally Posted by shiree

Data should be transferred in the TF you have selected. Provided the data base contains data in that TF.

Shiree Sir, the window in the automatic analysis has the data in the required format, viz.. 3:01:55, but the file that is written to the c drive has just 3:01

The data is there in amibroker, but it is not written to the file in that format

Originally Posted by shiree

AFL below will export data to C://OHLC , create a folder OHLC in C drive. /////////////////////////////////////////////////////////////////////////////////// _SECTION_BEGIN("data export from 28-3-2009 till now"); fmkdir( "C:\\OHLC" ); Buy = ( (DateNum() >= 1090328) AND (DateNum() <= 1100728)); //(1090328) means from 28 March 2009 to (1100728) 28 July 2010 data will be exported to C://OHLC. for( i = 0; i < BarCount; i++ ) if( Buy[i] ) { fh = fopen( "C:\\OHLC\\"+Name()+".txt", "a"); if( fh ) { y = Year(); m = Month(); d = Day(); r = Hour(); e = Minute(); for( i = 0; i < BarCount; i++ ) if( Buy[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,", r[ i ],e[ i ]); fputs( ts, fh ); qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f\n", O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ); fputs( qs, fh ); } fclose( fh ); } } _SECTION_END();

Thank You

Can we use this AFL to export in other TF like 30 mints, 1Hrs etc.

Where we edit the TF value

Any TF , just select the required TF in Auto Analysis>Setting.

Originally Posted by shiree

Any TF , just select the required TF in Auto Analysis>Setting.

Hi Shiree

Hmm confused on the TF selection in the "Auto Analysis>Setting"

Pls give some details on it.

Thanks in advance

Originally Posted by nebujvs

Hi Shiree Hmm confused on the TF selection in the "Auto Analysis>Setting" Pls give some details on it. Thanks in advance

Please somebody post a screen shot of AA setting for the benefit of nebujvs. I am not comfortable with screen capture.

May this screen shot give help. Friends in automatic Analiese window click on setting, and use that TF which u need to convert ur database, in this image i m using 15 minutes TF, when we click on scan all tick data automatic write into new folder like shiree sir write "C:\\OHLC\\" in 15 minute format, then u can make a new blank database and import all data from "C:\\OHLC\\" bye using File/ import wizard, then ur all old tick data convert in 15 minutes TF and ur ami can fly

Attached Images

15 minute TF.PNG (127.6 KB, 46 views)

Shiree sir, even after making the changes in settings, the data thatis written to the ascii file is not giving in seconds. It has say, 15 entries for one minute.... just rhe seconds are missing, and this makes amibroker to consider just the first line of every minute

Originally Posted by shishirshah

Shiree sir, even after making the changes in settings, the data thatis written to the ascii file is not giving in seconds. It has say, 15 entries for one minute.... just rhe seconds are missing, and this makes amibroker to consider just the first line of every minute

What happens when you select TICK in TF???

Originally Posted by shiree

What happens when you select TICK in TF???

Sir,
The data is shown as required in amibroker scan result, but the text file does not contain the seconds.

NIFTY-I,20100201,09:00,4838.00,4838.00,4838.00,4838.00,4 9250
NIFTY-I,20100201,09:00,4842.00,4842.00,4842.00,4842.00,2 2000
NIFTY-I,20100201,09:00,4840.25,4840.25,4840.25,4840.25,3 3950
NIFTY-I,20100201,09:00,4843.00,4843.00,4843.00,4843.00,3 1350

Originally Posted by shishirshah

Sir, The data is shown as required in amibroker scan result, but the text file does not contain the seconds. NIFTY-I,20100201,09:00,4838.00,4838.00,4838.00,4838.00,4 9250 NIFTY-I,20100201,09:00,4842.00,4842.00,4842.00,4842.00,2 2000 NIFTY-I,20100201,09:00,4840.25,4840.25,4840.25,4840.25,3 3950 NIFTY-I,20100201,09:00,4843.00,4843.00,4843.00,4843.00,3 1350

Thats correct .I am getting similar data. Means second is not showing.
Just check after conversion in new data base.