Is there an excel macro that will return a company name from a ticker symbol? I have about 2000 company ticker symbols and need the company name. Any help would be greatly appreciated.
Is there an excel macro that will return a company name from a ticker symbol? I have about 2000 company ticker symbols and need the company name. Any help would be greatly appreciated.
1) Google search list of ticker symbols and download a complete list off the internet.
2) Add that list to your workbook as another sheet.
3) Use VLOOKUP to get the info from the downloaded list for your custom list of ticker symbols.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks