|
PureBytes Links
Trading Reference Links
|
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@xxxxxxx]
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@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/
------------------------ 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/
|