• Australian (ASX) Stock Market Forum

Search ASX companies by state?

Discussion in 'ASX Stock Chat' started by prawn_86, Nov 10, 2010.

  1. prawn_86

    prawn_86 Mod: Call me Dendrobranchiata

    Posts:
    5,850
    Likes Received:
    1
    Joined:
    May 23, 2007
    Seems a simple question but i can't figure out how to do it.

    Does anyone know a website in which i can search the list of ASX companies by the state in which they are headquartered? I can't seem to do it on the ASX site.

    Thanks
     
  2. prawn_86

    prawn_86 Mod: Call me Dendrobranchiata

    Posts:
    5,850
    Likes Received:
    1
    Joined:
    May 23, 2007
    Can anyone help with this? Still cant figure out how to do it myself
     
  3. Whiskers

    Whiskers It's a small world

    Posts:
    3,266
    Likes Received:
    0
    Joined:
    Aug 21, 2007
    Ole Etrade has this function, prawn. Select your state from 'Predefined Value'.

    I've maintained one Etrade account because it's handy for some of these functions that I don't have with my other brokers.

    You may need to be an account holder to get access to all functions though.
     

    Attached Files:

  4. pixel

    pixel Well-Known Member

    Posts:
    4,264
    Likes Received:
    11
    Joined:
    Feb 3, 2010
    From ASX Company Research: http://www.asx.com.au/research/companies/index.htm, you can download the entire list of ASX-listed companies.
    While that doesn't show the state, you can scan the ASX - same page - for each code and filter for telephone number or postcode. I would run an Excel macro, loop over all 2,247 codes, reading the URL -
    ="http://www.asx.com.au/asx/research/companyInfo.do?by=asxCode&allinfo=&asxCode="&Code
    Locate the Head Office Telephone and/or last 4 characters of Registered Office Address, and stick it (=Formula()) into the table.

    Doesn't cost you a cent and you can rerun it every so often to be sure you've got the most current information.
    (You can also IM or email me, and for 50 bucks :2twocents I'll write it for you.)
     
  5. pixel

    pixel Well-Known Member

    Posts:
    4,264
    Likes Received:
    11
    Joined:
    Feb 3, 2010
    On second thoughts, I'm not 100% sure what the state filter would tell you.
    WA, for example, is full of mining companies whose home offices are registered "on The Terrace" or at least in West Perth, but they operate in Queensland, Africa, Mexico, or anywhere in between.
     
  6. pixel

    pixel Well-Known Member

    Posts:
    4,264
    Likes Received:
    11
    Joined:
    Feb 3, 2010
    How does this fit your needs? I have adapted one of my standard programs that provides a forecast of upcoming dividends, customised for clients' watchlists or portfolios.

    View attachment Ex-DivPlus.xls

    Sort the list by Aussie Postcode to get the State or Territory. Or break it down by GICS.
    Anybody interested in the complete program, drop me a line.
     
Loading...

Share This Page