[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: importing ASCII error



PureBytes Links

Trading Reference Links

Here is what my file looks like:
<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>,<oi>
A,20070614,38.37,38.98,38.36,38.85,1564700
AA,20070614,40.4,41.3,40.35,41.16,7237300
AAI,20070614,11.25,11.34,11.11,11.29,2387500
AAP,20070614,41.1,41.27,40.86,41,830400
AAR,20070614,24.6,24.68,24.52,24.57,1000
AAV,20070614,13.14,13.3,13.12,13.29,896900
I've never had any problem with import using Wizard or ASCII.  I would
susspect you have "date" wrong and no Symbol??  I get data from
EODData.com.  Use Metastock format.

Dick H


--- In amibroker@xxxxxxxxxxxxxxx, "hatizen" <hatizen@xxx> wrote:
>
> Hi, 
> 
> I get the following error when trying to import the aqm file below
> 
> Logging started for 'C:\Program 
> Files\AmiBroker\AmiQuote\Download\A.aqm' file, using format 
> definition file 'Formats\aqm.format'
> Error in line DATE,OPEN,HIGH,LOW,CLOSE,VOLUME
> Invalid (close) price. Prices must be positive. If you want to import 
> no quotation data please specify $NOQUOTES 1 ('no quotation data' box 
> in Wizard)
> Invalid date format/value
> 
> File to be imported
> # $NAME A
> "US and Canadian historical stock prices and US indices prices 
> provided by CSI, Inc."
> "US historical mutual fund and industry prices provided by Media 
> General Financial Services."
> "International stock prices and International indices prices provided 
> by Interactive Data Corporation."
> Agilent Technologies Inc (A)
> Daily prices
> DATE,OPEN,HIGH,LOW,CLOSE,VOLUME
> 6/16/2007,37.82,38.47,37.72,38.47,2904500
> 6/15/2007,37.82,38.47,37.72,38.47,2904500
> 6/14/2007,37.82,38.47,37.72,38.47,2904500
> 6/13/2007,37.82,38.47,37.72,38.47,2004500
> 6/12/2007,37.44,37.83,37.1,37.47,2158000
> 6/11/2007,37.38,37.92,37.15,37.71,1504700
> 6/8/2007,37.3,37.55,36.94,37.53,2656400
> 6/7/2007,38.12,38.37,37.26,37.26,2551800
>




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

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

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/