I want to build a database of some 20,000 stocks and would like to use the AlphaVantage API to feed it with data. The documentation can be found here: Documentation.
As of my research in stackoverflow and the Alpha Vantage Documentation, I have only been able to find a csv file of all the current active US stocks (and ETFs) -- the following API request achieves this result even with a demo API key: https://www.alphavantage.co/query?function=LISTING_STATUS&apikey=demo.
I would like, however, to obtain European stocks as well.
The Alpha Vantage Database goes much deeper than US stocks, as can be seen by looking at the search functionality in the API: https://www.alphavantage.co/query?function=SYMBOL_SEARCH&keywords=tesco&apikey=demo
You can get a free API key and input the query https://www.alphavantage.co/query?function=SYMBOL_SEARCH&keywords=AMKBY&apikey={YOUR_API_KEY} for a clearer example. So my question is how do I get all of these tickers and names of the stocks in a database. I could of course do a character matching (i.e. I try all of the combinations for tickers and save the company overview for stocks I have found; this program would, however, either kill my Laptop or not finish in this century. Is there a way I am missing? Maybe these tickers have a specific logic behind them that I can replicate somehow i.e. Yahoo Finance Tickers etc? The Atlas Copco AB is however a counterexample to that thesis, as it is listed in Yahoo and Google as ATCO-A and in Alphavantage as ATLCY.
New ideas will be greatly appreciated.
Thanks for your help!
