Historical quotes from Onvista

Hi Alfadelta,

sure. For the right configuration you have to choose a different notationId from Onvista. For your ETF please use:


image

Additionally please note that the URL
https://www.onvista.de/onvista/times+sales/popup/historische-kurse/?dateStart={TODAY:dd.MM.yyyy:-P5Y}&interval=Y5&assetName=a&exchange=a&notationId={TICKER}
remains always the same (in this generic format!) independent which financial instrument you want to add (stocks, etfs, funds, etc.). All the required information is taken from the first tab where you enter the ISIN, WKN and the symbol.

Let me know if you where able to manage it to add your ETF.

Best
Alex

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
  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.
  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.

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

Alex.
I would not have found that alone. So I thank you very much to have explained me so clearly.
And sorry not to have found that in the “how to”. I read it.
When I go to download I immediately register the file. I do not have the new window with the “notation_Id”.
Best regards to you.
download

1 Like

Hi Andre,

you are welcome and don’t worry there is no need to apologize. I only wanted to let all know that there are multiple approaches to find the historical courses and they are in the how-to section listed.

When I go to download I immediately register the file. I do not have the new window with the “notation_Id”. So??

In your screenshot you see the name of the file. In this case this your number:
image

Best
Alex

I understand. Top.

Andre

Hi Alex.
Again me. What about the CAC40GR index, symbol PX1GR.PA?
Onvista has not. And Yahoo shows only the last price. So where to find history?
Could you show me how to import from boursorama.com please?
Thanks a lot.
Andre

https://de.investing.com/indices/cac-40-gr-historical-data

Boursorama is somewhat problematic because of the date format it uses:

Hi Andre,

sorry I`m not really familiar with boursorma.com but why not using Onvista? Isn’t that FRANCE CAC 40(TRG) Index: Kurs, Chart & News ( | QS0011131834) exactly you index you want? Or did I miss something? If so please use the following configuration :slight_smile:
image

If I understood it wrong I can investigate further to get the data by another way.

Please let me know.

BR
Alex

Hi Alex
That is the good one.
I didn’t find with Onvista.
I used the “de.investing.com” site as ProgFriese told. As history was not so old I uploaded the CSV file from Euronext. And so all is OK now.
Thanks for answer.