|
PureBytes Links
Trading Reference Links
|
> -----Original Message-----
> From: Tomasz Janeczko [mailto:tjaneczk@x...]
>
> # 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
How did you handle the Stock Code and Issuer Codes in fields 1 and 2? I
merged them in a spreadsheet before import so that AmiBroker sees both TLS
and TLSCB ("CB" was originally in the 2nd field with no recognition of it's
purpose by AmiBroker that I could see).
For anyone interested, I wrote a BAT file that makes it easy to log into
Stockwatch and grab the day's data file by double-clicking an icon and
entering two simple strings ("yyyymm dd"). The script then "auto" navigates
to the correct directory and downloads the correct file. It then also loads
the file into Excel to run a macro, but this can easily be commented out or
deleted if unwanted. This script could quite easily be modified for
AmigaDOS/Amiga CLI FTP client if not using PC. If wanted, just ask.
Regards,
Mark
|