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

[amibroker] Re: importing ASCII error



PureBytes Links

Trading Reference Links

Hi Dick,
This is the file i got from Amiquote when it automatiically download 
EOD data from MSN. 

the only thing i did was added one extra line of data on top, ie: the 
6/16 price stuff. Even this was copy and pasted from previous lines 
and just modified price.


--- In amibroker@xxxxxxxxxxxxxxx, "areehoi" <rhoierman@xxx> wrote:
>
> 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@> 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/