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

[amibroker] Re: How to load this data?



PureBytes Links

Trading Reference Links

--- In amibroker@xxxxxxxxxxxxxxx, "protraderinc" <protraderinc@xxx> 
wrote:
>
> Hi,
> 
> I found a website for free download of ASX stocks data(let me know I'm
> wrong) from http://www.float.com.au/scgi-bin/prod/dl.cgi
> 
> I had tried and there are errors. I believe I must have done something
> wrong. Can someone please guide me thru what should I do to get it
> running? Or is there a site recommended for reasonable price paid data
> for ASX and easy to load?
> 
> Best regards
> Dave
>

Hello Dave,

It's your lucky day as the Aussies have a very strong contingent in the 
forum.

four possible methods:

1) Manual - if you want to do your own thing - the AB help manual 
(Database Management) in conjunction with the posts at the UKB >> Data 
>> Database Management section covers all (or most) of the basic 
principles of DM - Setup A Custom Database includes using Excel to 
condition CSV files for use with AB (you need to understand 
concatenation - there is a downloadable Excel file there, with example 
formulas, that you can use as a template).

http://www.amibroker.org/userkb/category/data/yahoo/database-management/

Applying all of that to your site -

- download the current year as a CSV file (check the CSV box),
- delete all of the data columns and use concatenate to add .ax to the -
 symbols (as the Yahoo suffix),
- copy N paste the appended symbol list into a new CSV file
- import the new list into AB using the ASCII Import Wizard.

This method has mainly academic interest (customization is mainly good 
for specialist databases that you can't get easily from somewhere else).

Extra work is the cost of custom databases.

Notice that the current year list from your site is a little dirty.
A few of the symbols have a "." (dot) after them so you will need to 
clean this up using Excel - this is typical of the challenges faced 
when scratching up lists (another typical glitch is that the symbols 
can contain extra spaces - I don't know how AB would handle that - 
probably without a problem - but I always remove them anyway).

The good coders could do all, or most, of the above stuff from within 
AB but the principles are the same.

2) Standard and Poors have a downloadable sectorized list of AllOrd 
members - you can download that and import it using the ASCII Import 
Wizard (exactly as per the methods used in the UKB posts).

3) Michael, who is a strong programmer and very helpful to fellow users 
has provided an auto database setup for ASX users at the AB third party 
site http://www.amibroker.org/3rdparty/ASX_Setup/

Michael automatically downloads and uses the S&P list.

4) Premium Data (Norgate Investor Services) and JustData (Bodhi 
Freeway)  are reasonably priced providers of ASX data (plus more) - 
links to them are in the AB help manual >> Tutorials >> Updating Quotes 
data list or at the UKB >> Data >> Resources pages.

There are links to other Aussie providers in the AB help manual - I 
just haven't researched them.

Cheers,

Brian_Z

http://www.amibroker.org/userkb/



Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

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