News Markets Groups Media

USA | Europe | Asia | World| Stocks | Commodities


Number of messages in the thread: 6


« Previous thread Next thread »

1. Date: 2008-12-01 06:42:35
Subject: Download industry groups?
From: DeanB <d...@y...com> Search message by this author

Is there anywhere to download a list of industry groups, along with
their stock symbols? I'm a software developer and want to do some data
studies but I need the lot in a database. I don't mind paying a
subscription if I have to. IBD has a pdf file of all the groups (to
purchase) but its not editable/copyable/breakable/legal.

TIA for any hints!

Show messages with headings

Up
2. Date: 2008-12-01 14:32:03
Subject: Re: Download industry groups?
From: ...@n...com (d.) Search message by this author

DeanB <d...@y...com> wrote:

>Is there anywhere to download a list of industry groups, along with
>their stock symbols? I'm a software developer and want to do some data
>studies but I need the lot in a database. I don't mind paying a
>subscription if I have to. IBD has a pdf file of all the groups (to
>purchase) but its not editable/copyable/breakable/legal.
>
>TIA for any hints!

Exactly what industry groups do you think you want? There are a
number of companies with their own ideas of what constitutes suitable
industry groups and their makeup.

Show messages with headings

Up
3. Date: 2008-12-01 14:47:55
Subject: Re: Download industry groups?
From: DeanB <d...@y...com> Search message by this author

On Dec 1, 9:32 am, d...@n...com (d.) wrote:
> DeanB <d...@y...com> wrote:
> >Is there anywhere to download a list of industry groups, along with
> >their stock symbols? I'm a software developer and want to do some data
> >studies but I need the lot in a database. I don't mind paying a
> >subscription if I have to. IBD has a pdf file of all the groups (to
> >purchase) but its not editable/copyable/breakable/legal.
>
> >TIA for any hints!
>
> Exactly what industry groups do you think you want?  There are a
> number of companies with their own ideas of what constitutes suitable
> industry groups and their makeup.

Doesn't matter that much - IBD's would be prefered.

Show messages with headings

Up
4. Date: 2008-12-01 17:21:19
Subject: Re: Download industry groups?
From: ausound <a...@s...com> Search message by this author

DeanB <d...@y...com> wrote in news:11826f92-98f2-4116-96cd-
49342e1787ba@41g2000yqf.googlegroups.com:

> Is there anywhere to download a list of industry groups, along with
> their stock symbols? I'm a software developer and want to do some data
> studies but I need the lot in a database. I don't mind paying a
> subscription if I have to. IBD has a pdf file of all the groups (to
> purchase) but its not editable/copyable/breakable/legal.
>
> TIA for any hints!
>

http://biz.yahoo.com/ic/

http://biz.yahoo.com/ic/ind_index.html

and as an example :

http://biz.yahoo.com/p/635conameu.html

each of the column headers can be clicked to "sort" the stocks by that
criteria from low unmber to high number...click the very same header again
and it sorts from high number to low number

there's a link in the upper right hand corner to download to spreadsheet

so simple it's as if they knew what you wanted before you asked for it

enjoy

Show messages with headings

Up
5. Date: 2008-12-02 01:57:57
Subject: Re: Download industry groups?
From: DeanB <d...@y...com> Search message by this author

On Dec 1, 12:21 pm, ausound <a...@s...com> wrote:
> DeanB <d...@y...com> wrote in news:11826f92-98f2-4116-96cd-
> 4...@4...googlegroups.com:
>
> > Is there anywhere to download a list of industry groups, along with
> > their stock symbols? I'm a software developer and want to do some data
> > studies but I need the lot in a database. I don't mind paying a
> > subscription if I have to. IBD has a pdf file of all the groups (to
> > purchase) but its not editable/copyable/breakable/legal.
>
> > TIA for any hints!
>
> http://biz.yahoo.com/ic/
>
> http://biz.yahoo.com/ic/ind_index.html
>
> and as an example :
>
> http://biz.yahoo.com/p/635conameu.html
>
> each of the column headers can be clicked to "sort" the stocks by that
> criteria from low unmber to high number...click the very same header again
> and it sorts from high number to low number
>
> there's a link in the upper right hand corner to download to spreadsheet
>
> so simple it's as if they knew what you wanted before you asked for it
>
> enjoy

Ausand,

That is very close to what I want. But I still have to click each
industry group and copy/paste each set of stocks. That's a lot of
clicking!
I'm after a single spreadsheet, prefereably one that is updated once a
week, that holds ALL groups and stocks in one table.

Show messages with headings

Up
6. Date: 2008-12-02 21:50:29
Subject: Re: Download industry groups?
From: DeanB <d...@y...com> Search message by this author

> this is just a quick-n-dirty bash script but you get the idea...
>
> seq 1 9 | while read n; do wgethttp://biz.yahoo.com/p/${n}conameu.html;
> done
>
> strings [1-9]*.html | grep [1-9][1-9]conameu | grep -v csv | cut -c6-8 |
>   while read n; do echo wgethttp://biz.yahoo.com/p/${n}conameu.html; done
>
> seq 1 9 | while read n; do
>   strings ${n}conameu.html | grep [0-9][0-9]conameu | cut -c6-8 |
>     while read n; do
>       echo
>       strings ${n}conameu.html | grep "Browser -" | grep -v title |
>         cut -c11- | awk -F"- Company" '{print $1}'
>       strings ${n}conameu.html | grep colist | grep finance.yahoo |
>         awk -F\> '{print $2}' | awk -F\< '{print $1}'| grep -v "\.OB" |
>         pr -tc12w80
>     done
> done

Mike - Excellent! Just what I wanted. I will start with this list, but
sometime I will have to translate that code into C#. (I assume this is
Linux?)

I appreciate your help!

-Dean

Show messages with headings

Up
 

Display
Pages in this thread: [1]


« Previous thread Next thread »


Search threads:

Advanced search »  




Latest threads

Older threads

 
Privacy policy . Copyright . Contact form .