Historical quotes from Onvista

English Quotes
3

Hi Andre,

great to hear. Oh yes of course. It is a bit tricky but let me try to explain it for you.

First of all it depends on which type of asset you want to add.

For ETFs please do the following:

  1. Go to https://www.onvista.de/ and search for your ETF by using the search bar in the upper right corner
  2. If you found your ETF then go to the Tab Alle Kurse und Handelsplätze. Maybe you have to scroll down a bit
    image
    image1262×798 41.8 KB
  3. After the view of Alle Kurse und Handelsplätze opened, please scroll down to the section Times and Sales
  4. Choose your desired Handelsplatz (aka Stock Exchange) and klick on the Download als CSV button.
    image
    image693×627 18.3 KB
  5. A new Windows window will open where you can save the .csv, but this is not required. You need only from the file name the notationId. See below screenshot to find the right number.
    image

If we talking about Aktien/Stocks then the approach is a bit different to find the notationId because Onvista has different screens for stocks.

For stocks do the following:

  1. Go to https://www.onvista.de/ and search for your Stock by using the search bar in the upper right corner
  2. If you found your Stock then swipe over the Tab Kurse and select from there the view T&S/Historie.
    image
  3. On the new view that opened you will find two sections Times & Sales and Historische Kurse. Here it doesn’t matter from which one you will take the notationId. For instance if you choose the Times & Sales you can again choose your desired exchange and after that click on the button Anzeigen.
  4. A new window will open where you can see in the search/navigation bar the full link/url and inside the url you see the notation. The number from there is your notationId that you can use.
    image
    image1307×757 76.1 KB

Please note:

  • Choose always first your desired exchange. Because if you need a different exchange then of course the notationId will be a different one.
  • The generic link that I posted
    https://www.onvista.de/onvista/times+sales/popup/historische-kurse/?dateStart={TODAY:dd.MM.yyyy:-P5Y}&interval=Y5&assetName=a&exchange=a&notationId={TICKER}
    is looking only 5 years back. So in case you need more historic data you have to adjust the interval accordingly.
  • As I said this approach was already described in this forum. I found the link Quellen für historische Kurse where I got the initial idea as well. So all props goes to the initial source of the how-to :-).

Best
Alex