Running web queries, where find data?

I know this is a little off the subject for this forum, but I find that I
usually get the most intelligent answers here. So please forgive me this side
question.

I want to run a web query to import ALL the stock symbols on the NYSE, AMEX,
and NASDAQ exchanges. i.e. Not just a few, but ALL OF THEM. - just a
comprehensive list of ALL symbols.

Can someone please post where they can be found on the web for import using
a web query to Excel?

Thanks much in advance.

Web query this site:
http://talk2mepc.voicebox.com/faq/stock_symbols.php

Delete the header rows, then use Data/Text to Columns and choose - as the
delimiter.

Mike F
"quartz" <[email protected]> wrote in message
news:[email protected]...
>I know this is a little off the subject for this forum, but I find that I
> usually get the most intelligent answers here. So please forgive me this
> side
> question.
>
> I want to run a web query to import ALL the stock symbols on the NYSE,
> AMEX,
> and NASDAQ exchanges. i.e. Not just a few, but ALL OF THEM. - just a
> comprehensive list of ALL symbols.
>
> Can someone please post where they can be found on the web for import
> using
> a web query to Excel?
>
> Thanks much in advance.

Then you can use this to navigate to the company name desired. Right click
sheet tab>view code>insert this>name a range findthis and type in the
1st letter of the co name to be taken to the 1st stock that starts with that
letter.

Private Sub Worksheet_Change(ByVal Target As Range)
x = Application.Match([findthis], Columns(1)) + 2
If Target.Address = [findthis].Address Then Cells(x, 1).Select
End Sub


--
Don Guillett
SalesAid Software
[email protected]
"Mike Fogleman" <[email protected]> wrote in message
news:[email protected]...
> Web query this site:
> http://talk2mepc.voicebox.com/faq/stock_symbols.php
>
> Delete the header rows, then use Data/Text to Columns and choose - as the
> delimiter.
>
> Mike F
> "quartz" <[email protected]> wrote in message
> news:[email protected]...
> >I know this is a little off the subject for this forum, but I find that I
> > usually get the most intelligent answers here. So please forgive me this
> > side
> > question.
> >
> > I want to run a web query to import ALL the stock symbols on the NYSE,
> > AMEX,
> > and NASDAQ exchanges. i.e. Not just a few, but ALL OF THEM. - just a
> > comprehensive list of ALL symbols.
> >
> > Can someone please post where they can be found on the web for import
> > using
> > a web query to Excel?
> >
> > Thanks much in advance.
>
>