Figuring out exchange for each symbol?

H

heech

Hi,

Is there a quick way (in excel or other similar platform) for automatically figuring out what US exchange a particular symbol is trading on?

I have a list of 160+ stocks, and I need to specify the exchange for each. Obviously I could just look at each symbol by hand, but would *really* like something that's automated.

I used to just assume any symbol that was 3 characters or less = NYSE, and anything that was 4 characters = NASDAQ. But I just noticed this week that the newly renamed AGCO still trades on the NYSE (NYSE:AGCO).

Any tips?
 
Quote from local_crusher:

Yahoo does it:

http://finance.yahoo.com/q?s=XOM,AGCO,PIKE,MSFT&d=s

Add your symbols to the above URL (comma separated)

You still need to check the result manually
More...
Thanks, I'll put that in the toolbox.

For now, I figured out some of the other data I'm downloading gives me the exchange for each symbol.

I get implied vol data (50 symbols at a time) using ivolatility.com, and they conveniently attach the exchange to each symbol. So that's even easier... of course, I just found a mistake in their data... no free lunches out there.
 
You must log in or register to reply here.
Back
Top