Stock Market Names and Symbols

[raskew]

Currently working on a stock trading journal. Field strStock requires the user to enter a stock symbol. Want to convert to a combo box where the user can search on either stock name or symbol. Problem being, have Googled this for over an hour and can't find a downloadable listing of stock market names and symbols.

If you know of one, I'd sure appreciate it if you could point me at it. Note: There are a host of sites that allow you to punch in a symbol and will then return current price, history, etc.. Not what I'm looking for -- just need a two field listing (strSymbol, strName) in a format that I can convert to Access, e.g. .xls.

Thanks - Bob

 

[MSAccessRookie]

I hope that I am allowed to reference another forum in here. I came across an entry in a Java forum that sort of speaks to your situation. Check out this link where a student wants to develop a java base GUI to get stock information. I do not write in Java, so I cannot speak to its value, but the student seemed to think it set him on the right track.

http://forum.java.sun.com/thread.jspa?threadID=597452&messageID=3449675

 

[raskew]

MSAccessRookie -

I do appreciate that. It brought me as close to anything I'd found. Thought I'd hit paydirt with a recommended Yahoo site, which even included a downloadable csv file which was supposed to open as an Excel spreadsheet-- which it did, except the message it included was "...missing symbols list" and was otherwise blank.

And, the "symbols list" is exactly what I'm looking for.

It just seems strange that this symbols list, which is something that seemingly every online stock site must use, is so hard to find.

Oh well, thanks again. I appreciate your effort.

Best wishes - Bob

 

[georgedwilkinson]

Bob, a long time ago (around 1997, I think), I signed up on Nasdaq's web site to get stock quotes. I had to sign a contract (no cost) but they provided VBA code for Excel, which I used constantly.

Unfortunately, there is now a security with the ticker symbol "VB" so it is difficult to get a good search on it.

Some stuff at http://www.nasdaq.com/aspx/ResearchAndToolsHub.aspx. Also, there may be some tools available at http://bigcharts.marketwatch.com/tools/ (which I also recall signing up for back then).

Just in case it helps.

 

[raskew]

George -

Thanks for the pointers. Both are good sites which I've bookmarked for future use. Unfortuneately, neither offer what I'm trying to find.

Thanks again - Bob

 

[raskew]

In case anyone's interested, I was pointed to this site: http://nationalsms.com/tickerlist.pdf by someone who spent less than a minute on a Google to find it.

It contains a listing, in pdf format (not downloadable). I was however able to copy and paste it to a Word document. Enclosed it in a table. Went to Excel and imported the table. Went to Access and imported the XLS.

Interesting exercise.

Thanks again to George and MSAccessRookie for their assistance.

Bob

 

[access2010]

A charity I volunteer at would like a database such as you are working on to keep historical data on their stock investments.

Would you be interested in allowing us to use your database?

Thank you

10finch46 at wehavemail.ca

 

[hankster]

I am a career Access/VBA programmer, but I have no knowledge of interfacing to sites on the Internet. A few years back, I used to download historical stock data from Yahoo Finance using this function. URLDownloadToFile

With VBA code, I could build each URL from a list of all NYSE Stock Symbols and get historical data O-C-H-L-V downloaded from Yahoo finance on each stock. But they no longer support it. I could also direct it to an Excel file in one of my folders. Excel is only for the data exchange as I plot all the data right on the Access form. I would simply traverse all the data in each stock file and look for patterns mathematically. Actually, they were Japanese Candlesticks.

I wonder if anyone has code to do something similar. Or I would be happy to pay someone to do it. I just need the downloader. I can process the data.

Regards,

Hank

 

[Gasman]

Hank,
You are responding to a 13 year old thread?

However I use www.alphavantage.co to get the prices for the few stocks I own. Limited usage is free.
Admittedly I just use the downloads in Excel, but a man of your experience, should have no trouble converting to Access import?

 

[gemma-the-husky]

I just saw this, but it's US stocks.

List of All Stock Ticker Symbols | Stock Analysis

 

[Gasman]

@CJ_London NYSE was mentioned by @hankster so probably ideal?

 

[theDBguy]

I just need the downloader. I can process the data.

Hi @hankster, can you please elaborate on this? Are you saying your API for downloading a file no longer work, or are you saying Yahoo Finance no longer offers the files, and you are now looking for a different approach?

 

[arnelgp]

i made similar code to "scrape" from finance/yahoo.
i forget the involved thread.

 

[hankster]

Thanks for the code. Is it ready to run. I made a form to call GetYahooData. Is there more I have to do?
Hank

 

[hankster]

Oh BTW. yes, yahoo finance no longer supports the urls I send
Hank

 

[Gasman]

Both Yahoo and then Google stopped some time back for me.
That is why I went to Alpha. However I was downloading the data, not web scraping.

 

[CJ_London]

@Gasman - not sure what you mean by this, this is not a thread I've participated in?

@CJ_London NYSE was mentioned by @hankster so probably ideal?

 

[hankster]

I was hoping downloading was what you were doing. I run to run the code but I wasn't familiar with all your functions. Can you give me a hint about how to use it? If I can make it work, I can certainly make changes to suit my needs, if I have to. Thanks for following up on this.

 

[Gasman]

@Gasman - not sure what you mean by this, this is not a thread I've participated in?

Oops, sorry. Looking back I can see it was @gemma-the-husky

 

[jdraw]

I recognize that this is an old thread, but because of these recent posts I'll offer this older link for info.