|
PureBytes Links
Trading Reference Links
|
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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
|