How to edit a spreadsheet with Coldfusion?

Take this excel spreadsheet of company names, and put in their stock tickers

• 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 http://finance.yahoo.com/l 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: http://finance.yahoo.com/l?s=ICOS&t=S&m=US 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. http://finance.yahoo.com/l?s=IBP&t=S&m=US 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... http://finance.yahoo.com/l?s=ICOS&t=S&m=US 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. Chris 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). Codes 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 Intuit 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 MBNA Corp 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 NYFIX Inc 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 SDL Inc 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

• Answer:

  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 http://www.istop.com/~mbh/bootsy.xls. Hope that's what you were looking for! Of course, if you need any further clarification, please feel free to ask! Deadlychiapet-ga Source: Yahoo! Finance - Ticker Symbol Lookup http://finance.yahoo.com/l