LinkBack URL
About LinkBacks
I am interested in a company name to ticker symbol converter for the following companies attached in the excel document. Thanks for you help.
I am interested in a company name to ticker symbol converter for the following companies attached in the excel document. Thanks for you help.
Sorry...Not getting what you are trying to do...
Can you explain a bit more??
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
I believe OP wants to retrieve something like this...Originally Posted by sourabhg98
http://www.marketwatch.com/tools/quo...y=all&Type=All
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
@sixthsense
So he basically needs to get short forms of the company names?
Yes, Sixthsense you are correct. I want to convert the list of company names I posted in the excel file into a list of stock ticker symbols. For example, Google to GOOG or Apple to AAPL.
Thanks for any help in advance. It will be greatly appreciated.
I saw this accomplished in a prior expired thread:http://www.excelforum.com/excel-prog...ol-lookup.html
No we should not take it in that way... It is the short form assigned by the Stock Market.
So it should be a web query which needs to be written in VBA as UDF to do the search using HTML object and get the resulting value in cell, If found
Hmm...I saw that thread....got it what is required...but don't know how we can make a web query through vba...hahahaa..
So is it easily possible? It would save me so much time.
I am not an expert in using HTML object in VBA but I know some of them abousetta, romperstomper, snb, pike who are the masters in that area
I will call all members help for this thread so that you will have chance to get the experts advice
We need HTML knowledge to use it in VBA
Last edited by :) Sixthsense :); 03-05-2015 at 02:37 AM.
Hi Excel Experts
I watched this video for making a dynamic excel query using parameters
https://www.youtube.com/watch?v=ZJ30U0qw850
In this video the query (.iqy) was created like this
http://razball.com/player/1744/
and then a parameter was entered like this
http://razball.com/player/["PlayerID", "Enter Player ID here"]
But I had to enter a parameter into this
http://www.marketwatch.com/tools/quo...D=mktw&Lookup=Sandy+Spring+Bancorp&Country=us&Type=All
So a parameter is required for Sandy+Spring+Bancorp
I tried various variations but was not able to make a successful query
Can someone suggest how to do this?
Your Text Sandy Spring Bancorp Formula Conversion Sandy+Spring+Bancorp Your Link http://www.marketwatch.com/tools/quo...D=mktw&Lookup=~&Country=us&Type=All Formula Conversion http://www.marketwatch.com/tools/quo...D=mktw&Lookup=Sandy+Spring+Bancorp&Country=us&Type=All
Your Text Sandy Spring Bancorp Formula Conversion =SUBSTITUTE(B1," ","+") Your Link http://www.marketwatch.com/tools/quo...D=mktw&Lookup=~&Country=us&Type=All Formula Conversion =SUBSTITUTE(B3,"~",B2)
Use Replace instead of Substitute in VBA
Last edited by :) Sixthsense :); 03-05-2015 at 03:17 AM.
Which stock exchange do you want the ticker for?
@sixthsense
Hello again
I can make the link but i need to incorporate a parameter
I tried this...
Then in company name field I inserted "Sandy+Spring+Bancorp&Country" but excel says this when I make an external query
Please Login or Register to view this content.
"This web query returned no data. To change the query, click OK, Click the arrow on the name box in the formula bar, click the name of the external data range for the web query, right-click the selection, and then click Edit Query"
Oh yes...I got my mistake.....its working now...
What I was able to make is this
Excel file attached
and link for .iqy file is this... http://we.tl/GHlY2XVIEI
I think experts here can further develop this for all company names....
Please tell if this works..
Thanks
We can't help if you don't tell us which exchange you want the Ticker for
@kyle
Actually this question is by tjkawa but he doesn't seem to be online
However I use this site for query--
http://www.marketwatch.com/tools/quo...ry=us&Type=All
Apologies, I didn't check the username
The stock exchange is NASDAQ
So with the information that the stock exchange is the NASDAQ, would anyone be able to help me?
Maybe download a list from here http://www.nasdaq.com/symbol/?Load=true
and use vlookup function for your companies....
I can lookup multiple companies at once with that function?
Anyone? I would really appreciate the help
What's wrong with sourabhg98's suggestion?
Finally Found a solution for you
Check attached...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks