Historical quotes from Onvista

English Quotes
1

Hi Alfadelta,

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

image
image1156Ă—43 3.79 KB

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

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

4

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
5

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

6

I understand. Top.

Andre

7

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

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

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

10

Hi Andre,

sorry I`m not really familiar with boursorma.com but why not using Onvista? Isn’t that Aktueller FRANCE CAC 40(TRG) Kurs heute • QS0011131834 • onvista 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

11

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.