2
$\begingroup$

I'm collecting stock data for private analysis. I found a very excessive list of stock at https://www.xetra.com/xetra-de/instrumente/alle-handelbaren-instrumente/boersefrankfurt

but the problem is that they are uniquely identified by their ISIN, as it's at my location, Germany, rather common. But when requesting the data from yahoo finance their ticker symbol is needed to build the URL, however when you enter the ISIN in their search field you get the correct output without any struggle.

As of right now im using the url to request the site by html and parse it to get the information.

I'm looking for suggestions to either

  • build a url with an ISIN for yahoofinance(or an equally fast provider)
  • map the ISIN to the relevant ticker symbol
  • any other method to retrieve data from yahoofinance e.g. open-source libs
  • other sources of live trading information, most importantly present prices

Thanks

$\endgroup$
0
$\begingroup$

Just use the symbol (in the CSV files, this is in the "Mnemonic" column) and attach an .F suffix for Frankfurt Boerse.

More information.

Note: Since scraping the API is expensive (although quotes can be retrieved in large batches of up to 500 symbols), you typically want to restrict the lookups to the symbols which you can trade with your broker, thereby making sure you only fetch data for the symbols you can actually trade. (In my original scraper I neglected that and later realized I'm fetching loads of symbols I cannot trade.)

$\endgroup$
0
$\begingroup$

let's work through an example.

Daimler equity has isin DE0007100000

Going to https://bsym.bloomberg.com/ , we find German ticker symbol DAI. (there is also an API, I believe free)

We can find on Yahoo Finance https://finance.yahoo.com/quote/DAI.DE

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.