Figuring out exchange for each symbol?

Discussion in 'Stocks' started by heech, May 9, 2009.

  1. heech



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


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