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

RE: [amibroker] Re: Import problem, filling RT in QQQ ticker



PureBytes Links

Trading Reference Links

You have a time column in the date, try removing that

Cheers,
Graham
http://groups.msn.com/ASXShareTrading
http://groups.msn.com/FMSAustralia


-----Original Message-----
From: Herman van den Bergen [mailto:psytek@xxxxxxxx] 
Sent: Sunday, 14 September 2003 12:36 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: Import problem, filling RT in QQQ ticker


Thanks HB, but it doesn't make any difference, still get this error:

Logging started for 'C:\Program
Files\AmiBroker\QQQMinData\qqq1yr1min\qqq.txt' file, using format definition
file 'Formats\wizard.format'
Error in line 08/08/2001	14:35	41	41.04	40.91	40.95
886400
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)

herman

-----Original Message-----
From: hmab1 [mailto:hossamb@xxxxxxxxxxxx]
Sent: Saturday, September 13, 2003 12:27 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Import problem, filling RT in QQQ ticker



Herman,

Your first column is the date; you should not be skipping it.

Your column definitions should be: mdy, time, etc.

HB

--- In amibroker@xxxxxxxxxxxxxxx, "Herman van den Bergen" <psytek@xxxx>
wrote:
> perhaps some kind soul can step me through this ...
>
> I have a 1-year QQQ data file in this format:
>
> 08/08/2001      14:35   41      41.04   40.91   40.95   886400
> 08/08/2001      14:36   40.95   41      40.84   40.85   296700
> 08/08/2001      14:37   40.85   40.88   40.8    40.83   721400
>
> and want to load this data into an empty QQQ ticker i created in a
new
> real-time database (1-min) with 50000bars depth) . Using the import
wizard I
> defined fields as follows:
>
>
>
> I keep getting the error msg (each line) : "Error in line
08/08/2001 14:35
> 41 41.04 40.91 40.95 886400 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)".
>
> I have no Negative values anywhere.
>
> What am I doing wrong? Any help would be appreciated,
> herman.
>
> PS. I did look through the Help but could find how to add ASCII
data to an
> empty ticker.



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/l.m7sD/LIdGAA/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/ 


------------------------ 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/l.m7sD/LIdGAA/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/