Closed Thread
Results 1 to 29 of 29

Ticker symbol lookup?

Hybrid View

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

  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?

    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

  13. #13
    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

  14. #14
    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.

  15. #15
    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!

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

    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.
    Ben Van Johnson

  17. #17
    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,678

    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

  18. #18
    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]

  19. #19
    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

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

    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.

  21. #21
    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

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

    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