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

[amibroker] Re: importing ASCII error



PureBytes Links

Trading Reference Links

Where is this No of Lines to be skipped?

I went to File->Import Ascii,choose the file and it automatically 
starts and give me error.

Also this file is what i got from MSN EOD thru Amiquote, all i did 
was added one extra line of data on top, ie: the 6/16 price stuff.

--- In amibroker@xxxxxxxxxxxxxxx, "Prashanth" <prash454.ta@xxx> wrote:
>
> Hello,
> 
> There is a Checkbox where No of Lines to be skipped is present. 
Place a value of 1 there. Also check that the date format you are 
importing is the same as you are giving , i.e., MDY.
> 
> Cheers
> 
> Prashanth
> 
>   ----- Original Message ----- 
>   From: hatizen 
>   To: amibroker@xxxxxxxxxxxxxxx 
>   Sent: Friday, June 15, 2007 6:47 PM
>   Subject: [amibroker] importing ASCII error
> 
> 
>   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/