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?
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
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.