Re: [amibroker] Re: ASCii Import - How To Import Last Line of Data Only

[Robert Chevallier <robert.chevallier@xxxxxxxxx>]

Another way could be to use the "tail" utility in a command line batch (see for instance http://sourceforge.net/projects/unxutils/)

and use to 1st create files with just the last line (tail -n 1 file-alllines > file-lastline )

and use these files for import

2009/11/13 lesv99 <ebsn247lsm@xxxxxxxxxxxxx>

 

If there is no way to do it with ASCii Importer then how about importing data using AFL? You would just need a "for" loop like the one below to extract the last line in the data array, but I don't have a clue about the rest of the code needed for importing data (if it's possible at all), I couldn't find any examples in AFL Library:

for( i = BarCount-1; i < BarCount; i++ )

I export data using AFL all the time, here is example (the code is based on Graham Kavanagh's code from AFL Library):

http://img44.imageshack.us/img44/7641/11122009212131.png

--- In amibroker@xxxxxxxxxxxxxxx, "lesv99" <ebsn247lsm@xxx> wrote:
>
> Is there a way to import only the last line from ASCii data file?
>
> This option could be expected in $SKIPLINES command, but I don't see it there.
>
> The data file format is as follows (file name = ticker symbol):
>
> Date,Open,High,Low,Close,Volume,OpenInt
>
> 11/09/09, 2.4500, 2.5100, 2.4500, 2.5000, 1137245, 652
> 11/10/09, 2.5500, 2.7300, 2.5500, 2.6300, 837775, 510
> 11/11/09, 2.75, 3.49, 2.73, 3.27, 6465800, 489
> 11/12/09, 3.19, 3.56, 3, 3.16, 4803500, 742
>
> Format definition file to import all lines of data looks like this:
>
> $FORMAT Date_MDY, Open, High, Low, Close, Volume, OpenInt
> $SEPARATOR ,
> $SKIPLINES 2
> $AUTOADD 1
> $CONT 1
> $DEBUG 1
> $BREAKONERR 1
>
> How to import the last line only:
>
> 11/12/09, 3.19, 3.56, 3, 3.16, 4803500, 0

__._,_.___

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___