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