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

Re: [amibroker] RE: ASX Data



PureBytes Links

Trading Reference Links

Hello,

After downloading sample ASX file I have created quickly the format definition file...
but during testing I found out that AmiBroker has a bug in ASCII importer with handling
names enclosed in quotation marks. This will be fixed in version 3.30 Beta-2
which will be available tommorow from AmiBroker/Win32 web site.
The following example shows format definition file for ASX data source.
Please keep in mind that only new 3.30 beta-2 version will be able to properly
import this file. However, you can try a workaround $FORMAT also given below.

Another solution is to remove all quotation marks from the CSV file by using Find & Replace function
of a text editor.

Best regards,
Tomasz Janeczko

# ASX www.StockWatch.com.au import format definition file
#
# To download this data
# simply ftp anonymously to www.stockwatch.com.au
# cd /pub/csv/yyyymm
# where yyyy is year and mm is month
#( for June 2000 this will be /pub/csv/200006
# and download appropriate .csv file
#
# AmiBroker 3.25 has a bug in handling names enclosed with quotation marks
# so it needs following format command
# $FORMAT NAME,SKIP,SKIP,SKIP,SKIP,DATE_DMY,OPEN,CLOSE,LOW,HIGH,VOLUME
#
# but for AmiBroker 3.30 and above correct format command is as follows
$FORMAT NAME,SKIP,SKIP,DATE_DMY,OPEN,CLOSE,LOW,HIGH,VOLUME

$SEPARATOR ,
$SKIPLINES 1
$AUTOADD 1
$DEBUG 1
----- Original Message -----
From: Tomasz Janeczko
To: amibroker@xxxx
Sent: Monday, June 12, 2000 8:13 PM
Subject: RE: [amibroker] RE: ASX Data


Hi Freddie and Mark,

I just tried anonymous FTP to www.stockwatch.com.au and it works just fine. So I have downloaded some files
and will find out how to import them into AmiBroker. Mark, thank you again for the information!

Best regards,
Tomasz Janeczko

----- Original Message -----
From: Mark Allen
To: amibroker@xxxx
Sent: Monday, June 12, 2000 7:16 PM
Subject: [amibroker] RE: ASX Data


Hi Freddie,

My current ASX data source is Stockwatch, though I use Insight Trader (an Oz charting/analysis program). Though I am an indirect
OzEmail customer, I believe it may be available via anonymous ftp from www.stockwatch.com.au after midnight each trading day.

"cd" to "pub/csv/<month>" and "get" "<day>.csv", where <month> = "yyyymm" and <day> = "yyyymmdd".

If I remember rightly from the quick tests I did with unreg version of AmiBroker v3.25 for Windows, the resultant file will need
some tweaking (append second field to first, and then skip second and third fields on import. Date format might also need changing,
and quotes removed).

Regards,

Mark
-----Original Message-----
From: Freddy G [mailto:freddyg@x...]
Sent: Monday, 12 June 2000 9:42 PM
To: amibroker@xxxx
Subject: [amibroker]


Any help on getting data from Australian stock exchange???
regards fred