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

[amibroker] Re: To AFL VETERANS



PureBytes Links

Trading Reference Links


HI Prashant

I thank you for efforts you have taken to understand my problem. ON 
the contrary I also appreciate for accurately diagnosing the problem 
and solving it.I was even still unsuccesful to import the data even 
after your advise . the one simple adjustment in database setting of 
base time interval to 1-minute was standing in my way . As soon as I 
changed the databse to 1 min, The chart which was always 
showing "too few quotations"
changed to the intraday chart, as due to it the intraday icon was 
not getting also activated.I was unsuccesful from last 3 days 
working to convert the data , but you have helped to attain me even 
ID tick format .

Thanks nRegards


--- In amibroker@xxxxxxxxxxxxxxx, "Prashanth" <prash454@xxxx> wrote:
> Hello,
> 
> If possible, do send me Privately, the file with the format
> 
> Index Date Time Open High Low Close Volume
> 1 26/10/2004 09:56:00 279.05 280.85 279 280.85 2160
> 2 26/10/2004 09:57:00 280.8 281.85 280.8 281.6 45886
> 3 26/10/2004 09:58:00 281.75 281.75 281.5 281.5 46751
> 
> I will try to do the needfull.
> 
> Regards
> 
> Prashanth
> 
> ----- Original Message ----- 
> From: "iascool" <sai20_2000@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Saturday, October 30, 2004 6:49 PM
> Subject: [amibroker] To AFL VETERANS
> 
> 
> >
> >
> > To  AFL VETERANS,
> >
> > I have been strugling to import the intraday data I get from by
> > broker in AB.
> > i have tried to do in
> >
> > 1)
> > Data (TICK-FORMAT)
> > 20041030.13 289.5 154
> > 20041030.13 289.5 318
> > 20041030.13 289.5 1210
> > 20041030.13 289.4 1579
> > 20041030.13 289.6 2041
> > 20041030.13 289.7 302
> >
> > I have tried to create a format file in notepad as follows
> > $FORMAT DATE_YMD.Time_HH:MM:SS,CLOSE,VOLUME
> > $NOQUOTES 1
> > $SEPARATOR
> > $SKIPLINES 1
> > $AUTOADD 1
> > $DEBUG 1
> >
> > But get the error as
> > Error in line 20041030.132221,289.5,154
> > 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
> > Error in line 20041030.132225,289.5,318
> > 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)
> >
> >
> > 2)
> > Data (1min-format)
> > Index Date Time Open High Low Close Volume
> > 1 26/10/2004 09:56:00 279.05 280.85 279 280.85 2160
> > 2 26/10/2004 09:57:00 280.8 281.85 280.8 281.6 45886
> > 3 26/10/2004 09:58:00 281.75 281.75 281.5 281.5 46751
> > 4 26/10/2004 09:59:00 281.8 281.9 281.7 281.9 26829
> > 5 26/10/2004 10:00:00 281.7 282 281.5 281.7 46151
> > 6 26/10/2004 10:01:00 281.7 281.85 281.5 281.5 29965
> > 7 26/10/2004 10:02:00 281.5 281.6 281.25 281.25 40723
> >
> >
> > I have tried to create a format file in notepad as follows
> > $FORMAT skip,DATE_DMY,Time_HH:MM:SS,OPEN,HIGH,LOW,CLOSE,VOLUME
> > $NOQUOTES 1
> > $SEPARATOR
> > $SKIPLINES 1
> > $AUTOADD 1
> > $DEBUG 1
> >
> > ERROR:
> > Error in line Index,Date Time,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
> > Error in line 1,26/10/2004 
09:56:00,279.05,280.85,279.00,280.85,2160
> > Invalid date format/value
> >
> > May I please know whether it is at all possible to
> > import the data specified above in AB.If yes is my approach 
correct?
> > The past messages I have read is the import is possible , but the
> > details are not available. Kindly advise to overcome this 
obstacle.
> >
> > Thanks
> >
> >
> >
> >
> >
> >
> >
> > Check AmiBroker web page at:
> > http://www.amibroker.com/
> >
> > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >





------------------------ Yahoo! Groups Sponsor --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

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

<*> 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/