|
PureBytes Links
Trading Reference Links
|
thanks, William for pointing me in the right direction, now let me
see if i can correct it.
--- In amibroker@xxxxxxxxxxxxxxx, "William Peters"
<williampeters@xxxx> wrote:
>
> The standard ascii.format file contains the following definition
(or something very similar):
>
> $FORMAT DATE_DMY,OPEN,HIGH,LOW,CLOSE,VOLUME
> $SEPARATOR ,
> $SKIPLINES 1
> $AUTOADD 1
> $DEBUG 1
>
>
> I notice you have time data in the third column, you can either
skip this using the Skip command or you can remove it from your data.
There is also a ticker column which you need to account for and the
other thing is you need to make sure that the date format in the
ascii.format definition file is the same as your data. The above
format DATE_DMY expects the date to be in that format so you will
need to change this to DATE_YMD as this is the format of your data.
Here is a format defintion that should work on your data. The
ascii.format file can be found in the AmiBroker\Formats directory,
you can edit this file using notepad. First make a backup of your
original ascii.format file.
>
> $FORMAT TICKER,DATE_YMD,SKIP,OPEN,HIGH,LOW,CLOSE,VOLUME
> $SEPARATOR ,
> $SKIPLINES 0
> $AUTOADD 1
> $DEBUG 1
>
> There is a section in the help file with a heading: Reference Guide-
->ASCII importer reference where you can find out more on this topic.
>
> Regards,
> William Peters
> www.amitools.com
>
>
>
> -----Original Message-----
> From: goldwing01 [mailto:GOLDWING01@x...]
> Sent: Sunday November 23, 2003 3:01 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] import help
>
>
> I`m importing data for EOD into Amibroker, but it is just not
working
> or less say not looking correct Can someone point my in the right
> direction. It is a TXT file that I am importing and the data looks
> like this
>
> XLNX,011129,0930,34.850000,36.460000,34.630000,36.300000,8230200
> XLNX,011130,0930,35.790000,36.740000,35.230000,36.110000,5039300
> XLNX,011203,0930,35.630000,36.100000,34.550000,34.880000,7069300
> XLNX,011204,0930,35.260000,37.800000,35.030000,37.780000,7853800
> XLNX,011205,0930,38.010000,43.250000,37.910000,42.410000,18671700
> XLNX,011206,0930,42.180000,43.100000,40.790000,42.290000,9165600
>
>
> What I need to do to make this work? Thanks in advance
>
> I would truly like to get away from Yahoo EOD.
>
>
>
>
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|