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!!!
I built a simple vba model that returns stock symbols.
Is that something you can work with?
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!!
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.
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!
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.
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!
Originally Posted by Ron Coderre
I'm stuck in Excel 2003...is there a good way to convert this for use as a .xls file, rather than .xlsm?
Thanks!
Converted....see attachment
You're awesome - thanks for the speedy help
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
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
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.
dead thead
Last edited by protonLeah; 11-21-2010 at 12:13 AM.
Ben Van Johnson
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.
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
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
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!
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.
@Zafar_Alam:
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.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.
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.
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
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,
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]
Hey Ron,
I would appreciate help in converting the following companies into a list of
tickers.
Thank you for your help.
Best,
TJ
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.
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks