Closed Thread
Results 1 to 29 of 29

Ticker symbol lookup?

  1. #1
    Registered User
    Join Date
    01-14-2005
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    32

    Ticker symbol lookup?

    Hello there.

    I have a list of names of public companies and am trying to get their ticker symbols. Is there a way to feed a company name to yahoo finance and then get the ticker symbol back?

    I have tried Data - Get External Data - From Web, but that seems to only collect a data table.

    My list is over 250 companies long and although I could slog through it, I am sure there is an easier way! I can use yahoo or google or msn. Any help would be greatly appreciated!!!

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    I built a simple vba model that returns stock symbols.

    Is that something you can work with?
    Attached Files Attached Files
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    01-14-2005
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Ticker symbol lookup?

    Wow! Thank you! This is really great. And yes, I can be coached through VBA. This is already a great help, and if you have any desire to modify this, what I am really looking for is to enter bulk company names (the are pretty exactly correct) and to have a ticker returned in the next column. As an added challenge, some of the stocks are on foreign stock exchanges and so I would need their country "tag". For example, EDF Energies Nouvelles SA is a French company that trades on the Paris stock exchange so it's ticker is "FR:EEN" or sometimes "EEN.FR". Using your example, Boeing is "US:BA"

    But any way, thank you so much for helping me and even if I never hear from you again you have been a great help and I sincerely thank you. Cheers to you and yours!!

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Thanks for the kind words...Much appreciated.

    Regarding processing a list of company names:
    I'll see what I can do for you. This may take a little while...so don't wait up for me

    Off-topic: Please edit your profile to indicate the version of Excel you are using.
    Sometimes knowing the version makes a big difference in the kinds of solutions you get.

  5. #5
    Registered User
    Join Date
    01-14-2005
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Ticker symbol lookup?

    Thanks! I have updated my profile. This would save me a couple of days of work, but I am willing to do it so if it gets too much of a pain, just drop it. But thanks again!

  6. #6
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    OK...I attached the modified Excel file to process a list of company names and build a list of ticker symbols. (WebQueryNYSESymbol_v2a.xlsm)

    Please let me know if you can use something like that.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-14-2005
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Ticker symbol lookup?

    Wow! Again, thank you so much. I now have a new batch of ticker symbols to look up and am eager to do it. A task I hated before. I really, really appreciate it!

  8. #8
    Registered User
    Join Date
    10-14-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Ticker symbol lookup?

    Quote Originally Posted by Ron Coderre View Post
    OK...I attached the modified Excel file to process a list of company names and build a list of ticker symbols. (WebQueryNYSESymbol_v2a.xlsm)

    Please let me know if you can use something like that.

    I'm stuck in Excel 2003...is there a good way to convert this for use as a .xls file, rather than .xlsm?

    Thanks!

  9. #9
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Converted....see attachment
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    10-14-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Ticker symbol lookup?

    Quote Originally Posted by Ron Coderre View Post
    Converted....see attachment
    You're awesome - thanks for the speedy help

  11. #11
    Registered User
    Join Date
    06-29-2010
    Location
    ny, ny
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Ticker symbol lookup?

    hey ron i tried using your excel prog (2003) to convert company names to stock symbols. however after using the prog i got back no results. i have attached the list to this message. i gathered the company names from yahoo finance. what do you think is wrong. thanks so much
    Attached Files Attached Files

  12. #12
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Try a less complete search string.
    For instance, it couldn't find any listing for: Aastrom Biosciences, Inc.
    BUT...it did find the symbol for: Aastrom

  13. #13
    Registered User
    Join Date
    11-20-2010
    Location
    Houston, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Ticker symbol lookup?

    He ron,
    I have a list of companies and I am trying to obtain ticker symbols but the query results in no data returned. Any help would be appreciated? I have many more, but here is a short list. Thanks.

    724 Solutions Inc.
    Abitibi Consolidated Inc.
    Aeterna Laboratories Inc.
    Agnico-Eagle Mines Ltd.
    Agrium Inc.
    AimGlobal Technologies Co. Inc.
    Air Canada
    Alliance Atlantis Communications Corp.
    Altair International, Inc.
    Angiotech Pharmaceuticals, Inc.
    AT Plastics Inc.
    AT&T Canada Inc.
    ATI Technologies Inc.
    Axcan Pharma Inc.
    Ballard Power Systems Inc.
    Bank of Montreal
    Barrick Gold Corp.
    BCE Inc.
    BCI Telecom Holding Inc.
    Bema Gold Corp.
    Big Rock Brewery Ltd.
    Biomira Inc.
    Boardwalk Equities Inc.
    Brascan Corp.
    Brookfield Properties Corp.

  14. #14
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,919

    Re: Ticker symbol lookup?

    dead thead
    Last edited by protonLeah; 11-21-2010 at 12:13 AM.
    Ben Van Johnson

  15. #15
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Well....not quite dead.

    Sometimes using less restrictive search terms results in matched items.
    I used this abbreviated list:
    724 Solutions
    Abitibi
    Aeterna Lab
    Agnico-Eagle
    Agrium
    AimGlobal Tech
    Air Canada

    And got these results:
    Please Login or Register  to view this content.

  16. #16
    Registered User
    Join Date
    05-30-2011
    Location
    Ny, NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Ticker symbol lookup?

    Hi Ron!

    Are you still listening to this thread?

  17. #17
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Quote Originally Posted by DerbyDad03 View Post
    Hi Ron!

    Are you still listening to this thread?
    Since this thread is stale...How about posting a new question, referencing this one if it's relevant.

    Ron

  18. #18
    Registered User
    Join Date
    03-16-2012
    Location
    Gurgaon, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Ticker symbol lookup?

    Hi Ron,

    This is just the thing I was looking for. Excellent stuff. Thanks so much for reducing the manual effort of identifying tickers for companies one by one.

    Just wanted to clarify with you once, that in case I want to use a different source than http://stocks.tradingcharts.com/stocks/symbols/s/ where shall I make changes in the code? I mean what if I want to use http://in.finance.yahoo.com/lookup? Can we just replce the names it would be done?

    I am just exploring things so thought to ask an expert.

    Regards,
    Zafar

  19. #19
    Registered User
    Join Date
    03-16-2012
    Location
    Gurgaon, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Ticker symbol lookup?

    In case you think I should post this query in any new thread I can do that but thought all related posts should be together to make things easier.
    Last edited by Zafar_Alam; 03-16-2012 at 09:16 AM. Reason: Duplication!

  20. #20
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Ticker symbol lookup?

    Actually, you'd need to do a bit of work to be able to use the URL you posted.

    The actual structure would need to be:
    "URL;http://in.finance.yahoo.com/lookup/all?s=" & strNameParam & "&t=A&m=ALL&r=1"

    However, that website does not present the stock information in a web table. Consequently, you'd need to write code to identify the data area you need and extract that information.

  21. #21
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,919

    Re: Ticker symbol lookup?

    @Zafar_Alam:
    In case you think I should post this query in any new thread I can do that but thought all related posts should be together to make things easier.
    Pretty smug retort, that! Reading and adhering to the rules is easy. If you think it's related then post a link as the rules request/require. Without rules the forum is chaotic and confused. How about you try to drive on the road per your own rules! This thread should be locked to prevent any future tangential appendages.

  22. #22
    Registered User
    Join Date
    01-08-2012
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Ticker symbol lookup?

    The issue for those that are not getting results is probably due to the underlying web site's (http://stocks.tradingcharts.com/stocks/symbols/s) search syntax. It appears that they can only handle a single word and multiple words (such as "AimGlobal Tech" or "Air Canada") do not return data. I wonder if there is any syntax that the site's search recognizes to return on multi-word searchs? I tried using quotes at the site but that did not work.

  23. #23
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,684

    Re: Ticker symbol lookup?

    Here is an alternative that works for me.

    http://www.youtube.com/watch?v=MXIoV...re=uploademail
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  24. #24
    Registered User
    Join Date
    03-09-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Ticker symbol lookup?

    hi Ron..I read your posts and if found it very helping...
    I am completely new in excel and i own a business of cellular handset sales, I want to maintain a stock list of mobile handsets which i purchase and sell
    could it possible for you to walk me through the process,cuz i am having a lot of difficulty in maintaining the stock manually,
    your help would be greatly appreciated,

  25. #25
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Ticker symbol lookup?

    enayat,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  26. #26
    Registered User
    Join Date
    03-04-2015
    Location
    New York, USA
    MS-Off Ver
    2011
    Posts
    9

    Re: Ticker symbol lookup?

    Hey Ron,

    I would appreciate help in converting the following companies into a list of
    tickers.

    Thank you for your help.

    Best,
    TJ
    Attached Files Attached Files

  27. #27
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,919

    Re: Ticker symbol lookup?

    tjkawa,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  28. #28
    Registered User
    Join Date
    04-28-2017
    Location
    france
    MS-Off Ver
    2016
    Posts
    1

    Re: Ticker symbol lookup?

    Hello !

    First of all, thanks for the great work.

    But unfortunatly it didn't work at all for my list of companies, even when I tried 'Apple' :-/

    Can you help me on that ?

    My companies are mostly european so the symbol format would be more like CS.PA for Axa for example.

    Thank you very much in advance.

    Here is my list of companies:

    Accor
    Air France
    Air Liquide
    Airbus
    Apple
    ArcelorMittal
    Axa
    BNP Paribas
    Bouygues
    Cap Gemini
    Carrefour
    Casino
    Credit Agricole
    Danone
    Eiffage
    Electricite de France
    Engie
    Essilor
    Kering
    LafargeHolcim
    Lagardere
    Legrand
    L'Oreal
    LVMH
    Michelin
    Natixis
    Neopost SA
    Nokia
    Orange
    Pernod-Ricard
    Peugeot
    Publicis
    Renault
    Safran
    Saint Gobain
    Sanofi SA
    Schneider Electric SA
    Societe Generale
    STMicroelectronics
    Suez Environnement
    TechnipFMC PLC
    Total
    UnibaiI-Rodamco SE
    Valeo
    Vallourec
    Veolia Environnement
    Vinci
    Vivendi

  29. #29
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,919

    Re: Ticker symbol lookup?

    horizion,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1