Google Answers Logo
View Question
Q: Take this excel spreadsheet of company names, and put in their stock tickers ( Answered 5 out of 5 stars,   0 Comments )
Subject: Take this excel spreadsheet of company names, and put in their stock tickers
Category: Business and Money
Asked by: bootsy-ga
List Price: $20.00
Posted: 11 Jun 2003 15:26 PDT
Expires: 11 Jul 2003 15:26 PDT
Question ID: 216198
Hi - Here's a list of about 300 company names.  I need stock tickers
and industry codes for each one (very basic).  I've done a few
hundred, and it took me a couple of hours.  Figure someone might be
faster and could do these in less for $20.

1) Stock Tickers
       I think the easiest way is to just go to and plug in the name.  DON'T USE the whole
name, normally just the first word or two works.  And don't sweat it
if it's not obvious, JUST SKIP IT.  To make it easy - just grab the US
listings...that's easiest.
       So for example, see the 4th listing down sheet - I
just typed in ICOS, and got this result:  The last one is the most
appropriate, so use that.  If it wasn't obvious, then just skip it.
       Some will be confusing - JUST SKIP THEM.  for example, the 3rd
one down - IBP Inc gets this result.  So that's confusing - just
SKIP IT.  I'm just looking for someone to do the easy ones - Nasdaq
and NYSE stuff.

2) Industry codes - very simple.  
            Again back to the ICOS example... you see the last listing
also says Biotechnology and Drugs - so that's B for biotech (see the
top of excel spreadsheet for codes).  If it's something that's not
listed, just put it as Other.  If it's not listed at all, just put it
as other.  I don't expect you to look up what the company does -
that's way to much effort for $20.

Extra notes
1) Don't edit ANY of the names in the first column.  
2) Easiest to be in excel, press CTRL-C (copy) on the company you are
doing, paste into the Yahoo lookup page, and then delete all the words
except the first word in the company name.
3) JUST DO THE EASY ONES - I can't stress this enough - if it's not
obvious, then SKIP IT.  Thanks!

Any questions...lemme know.


OK - I JUST REALIZED  you can't attach a file.  Makes it alittle more
difficult, but no biggie.

Just take this, paste it into excel or create a table in word.  In
fact, if you select everything below, and paste into excel, the
columns will already be there (just resize the first column so you can
read the company names).

t	tech/telecom
m	media
b	biotech/medical
r	retail
I	industrial
o	other

Companies	Ticker	Industry

I2 Technologies Inc	pnk	t
IAC Capital Trust Tr Orig Pfd Secs		
IBP Inc		
ICOS Corp Del Par $0.01	icos	b
IDEC Pharmctls Corp Del	idph	b
Illinois Tool Works Inc	itw	r
Illuminet Hldgs Inc		
Immunex Corp New		
Infineon Techs AF Spdadr
Infonet Svcs Corp Cl B
Informix Corp
Infoseek Corp Del Com
Infospace Com Inc
Inktomi Corp
Intel Corp
Internet Cap Group Inc
Intersil Hldg Corp Cl A
Intgtd Device Tech Calif
Intl Business Mach
Intl Rectifier Corp
Ivax Corp Fla
IXIA California
J Hancock Financial Inds Fd Cl B
Jabil Circuit Inc
Jacobs Engn Grp Inc Dela
Jacor Commntns Del
Jacor Commntns Del
JC Penney Co Com
JDS Uniphase Corp/Uniphase Corp
Jefferson Pilot Corp
John Hancock Govt Income Fund Class B
John Hancock Regional Bank Fund Cl B
Johnson & Johnson
Johnson Controls Inc
Jones Apparel GP Inc Com
JP Morgan & Co Inc
JP Morgan Chase and Co/Chase Manhatn Corp New
Juniper Networks Inc
K Mart Corp
Kansas City S Inds 0.01
Keithley Instruments
Kemet Corp
Keyspan Corp
KLA Tencor Corp PV$0.001
Knight Trimark Grp Cl A
Kohls Corp Wis Pv 1CT
Koninklijke El Sp Adr New
KPMG Consulting Inc Com
Krispy Kreme Doughnuts
Kroger Co
Kyocera Corp
L 3 Commnctns Holdg Cl A
LAM Research Corp
Lattice Semicndtr Corp
Legato Systems Inc
Lehman Brothers Hldgs Com
Level 3 Cmncatns Del
Level One Commntns Inc
Lexmark Intl Gp Inc Cl A
Lilly Eli Co
Linear Technology corp
Linens N Things Inc
Lockheed Martin Corp
Loral Space & Comm PV$0.01
Lord Abbett Research Fd Small Cap Ser Cl B
Lowes Companies Inc
LSI Logic Corp
Lucent Technologies Inc
Lycos Inc
Macromedia Inc
Maxim Integrated Prods
McDonalds Corp
MCI Worldcom Inc PV$0.01
McLeodusa Inc Del A $.01
MDC Holdings Inc Del
Medimmune Inc
Medtronic Inc
Merc Pan Europe Gr Cl B
Merc US Govt Sec PT B
Merck & Co Inc
Mercury Interactive Corp
Mercury Lrg Cp Val B
Mercury US Large Cap Class B
Merrill Lynch & Co Inc
Merrill Lynch Global Financial Services Cl B
Methode Electrncs Cl A
Metlife Inc Com
Metro Goldwyn Mayer Inc
Metromedia F 1 B Netwk A
MFS Emerging Growth Fund Class B
MFS Utilities Fund Class B
MFS Value Fd Cl B/MFS Equity Inc Fd Cl B
Micrel Inc
Microchip Technology Inc
Micron Technology Inc
Microsoft Corp
Millennium Pharms Inc
Minnesota Mng Mfg
MIPS Technologies Cl A
Mondavi Robert Corp A
Monsanto Co New Del Com
Montana Power Co
Morgan St Dean Wttr Disc
Motorola Inc
Munder Framlingtn Health Care Fd Cl B
Munder Index 500 Fund Cl B Shs
Munder Netnet Fd Cl B
Munder US Govt Income Fd Cl B
Munihldgs Cal Ins FD III
Nabors Industries Inc
Nanometrics Inc
Nasdaq 100 Trustsm I
Nations Bond Fund Cl B
Nations Marsico Foused Equities Fd B
Natl Disc Brokers Group
Neoforma Com Inc Com
Netscape Communctns Corp
Network Appliance Inc
Network Solutions Del
Newbridge Networks Corp
Newport Corp
Nextel Communications A
Nextlink Comm A PV$0.02
Nike Inc Cl B
Nine West Group Inc
Nippon Telg&Tel Spdn Adr
Nokia Corp
Nortel Networks Corp New/Nortel Networks Corp Com/Northern Telecom Ltd
Northeast Optic Network
Northrop Grumman Corp
Northstar High Total Return Fd Cl B
Northwest Airlines Crp A
Novell Inc
Novellus Sys Inc
NRG Energy Inc Del Com
Oakley Inc
Oil Sts Intl Inc Del Com
Omnicom Group Com
Onsale Inc Com
OpenTV Corp Cl A
Openwave Sys Inc Calif
Oracle Corp $0.01
Oratec Interventions Inc
Orbital Sciences Corp
Orient Express Hotels A
Orion Pwr Holdgs Inc
Outback Steakhouse Inc
Oxford Health Plans Inc
Packard Bioscience com
Palm Inc
Panamsat Corp Com New
Paychex Inc
PE Corp Celera Gen Group
PE Corp Pe BYOSYS Group
Peoplesoft Inc Com
Pep Boys Conv Liq Yld Option Note
Pepsico Inc
Perkinelmer Inc
Petrleo Bras Vtg Spd Adr
Pfizer Inc Del PV$0.05
Philip Morris Cos Inc
Phone Com Inc
Photronics Inc
Pimco Cal Mun Incm Fund
Pimco Innovation Fd Cl A
Pimco Innovation Fd Cl B
Pimco Target Fund Class B
Pimco Total Return Fd Cl B
Pkg 113 Bac+$9.02 Cash
PLC Capital Trust III Def Int Troig Pfd Secs
Plug Power Inc
PMC Sierra Inc Com
Portal Software Inc Com
Potash Corp Saskatchewan
Power One Inc
Powerwave Technologies
Praxair Inc
Precise Software Sol Ltd
Priceline Com Inc
Procom Technology Inc
Procter Gamble
Putnam Equity Income Fund Class B
Putnam Health Sciences Trust Class B
Qlogic Corp
Qualcomm Inc
Qwest Comm Intl Inc
Radware Ltd
Rambus Inc
Read Rite Corp
Real Networks Inc
Red Hat Inc
Redback Networks Inc
Regus PLC Sponsored Adr
Research in Motion Ltd
RF Micro Devices Inc
Rhythms Netconnections
Rite Aid Corporation
Roberthalf Intl Inc Com
RSA Security Inc Com
Saba Software Inc Com
Safeway Inc
Salton Inc Del PV$0.01
Sandisk Corp Inc
Sanmina Corp
SAP Akgsltt Sponsord Adr
Schering Plough Corp
Schwab Charles Corp New
SCI Sys Inc
Scientific Atlanta
Seagate Technology
Sector Spdr Basic Inds
Seligman Communications & Information Fund Cl D
Service Corp Intl
Servicemaster Company
Shaw Group Inc
Siebel Sys Inc
Smith Intl Inc Del
Software Com Inc
Solectron Corp
Sony Corp Adr New
Spanish Bdcstg Sys A New
Specialty Labs Inc Com
Sprint Corp
Sprint Corp PCS Com Sr 1 Total
Spyglass Inc
St Paul Cos Inc NPV
Starbucks Corp
STMicroelectronics NV
Sun Life Fincl Svcs CDA
Sun Microsystems Inc Com
Superconductor Technolgs
Superior Telecom Inc
Sycamore Networks Inc
Symbol Technologies Dela
Taiwan S Manufctring Adr
Tandy Corporation
TCF Financial Corp
Techne Corp
Tekelec Inc Com
Telebras Holdrs Adr
Telecmuntn Br Sa Spn Adr
Telefonica SA Spain Adr
Telefonos M SA RP L Adr
Telekom Austria Adr
Tellabs Inc Del Pv 1CT
Telocity Inc
Teradyne Inc
Terayon Comm Systs
Teva Pharmactcl Inds Adr
Texas Instruments
Tiffany & Co New
Time Warner Inc
TMP Worldwide Inc Com
Tommy Hilfiger Corp Com
Transwitch Corp
Tricon Global Restrnts
Triquint Semiconductor
Tyco Intl Ltd New
Tycom Ltd
UAL Corp PV $0.01
Unisys Corp
United Health Group Inc
United Parcel Svc Cl B
Universal Comprssn Hldgs
US Airways Group Del $1
Utstarcom Inc Del Com
VA Linux Systems Inc
Verisign Inc
Veritas Software
Viant Corp
Vignette Corp
Vishay Intertechnlgy
Visx Inc Del
Vitesse Semicondctr Corp
Vodafone Airtouch Spdadr
Voicestream Wireless
Wal Mart Stores Inc
Walgreen Co
Walt Disney Co Disny Com
Warnr Lambrt Company
Washington Mutual Inc
Waste Management Inc New
Waters Corp
Wells Fargo & Co New Del
Wherever Net Hldg Adr
Worldcom Inc New GA Com
WW Grainger Incorp
Xcelera Com Inc
Xerox Corp
Xilinx Inc
Xoom Com Inc
Yahoo Inc
Zomax Inc

Clarification of Question by bootsy-ga on 11 Jun 2003 15:46 PDT
By the way - I need this sometime Thursday - so please don't lock it
up unless you are able to complete by this time.
Subject: Re: Take this excel spreadsheet of company names, and put in their stock tickers
Answered By: deadlychiapet-ga on 11 Jun 2003 19:42 PDT
Rated:5 out of 5 stars
Hi there,

I've completed the list for you. I was able to get ticker symbols for
the majority of the companies listed, although there were more than a
few that I couldn't find. As well, there are some defunct companies in
your list such as Xoom, and companies that have been bought out like
Netscape. Anyway, you can grab it from

Hope that's what you were looking for! Of course, if you need any
further clarification, please feel free to ask!


Yahoo! Finance - Ticker Symbol Lookup
bootsy-ga rated this answer:5 out of 5 stars and gave an additional tip of: $5.00
Thanks very much - that was quick!  Great answer, very satisfied.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy