Updating quotes automatically for securities through Euronext

English Quotes
1

Hello,

For the past week I have been configuring the software with the all the data needed. Though it has been going very well, there is something thing baffles me. Please forgive me if my question has been asked before, I could not find it when I did a search of the forum and I admit I am a little green at this.

In the All Securities section I have been adding investments stocks and configuring them so they update automatically through Yahoo Finance. (right click > Quotes > Configure online update).

This works perfectly for most of my stocks except for two, for which Yahoo (or most other sites) don’t provide a detailed historical update. The site I managed to find that does this is Euronext but I can’t seem to find a way to feed the Euronext data into a configuration that updates these two specific stock automatically. (I did manage to download a CVS file with historical quotes that I feeded into PP but these quotes aren’t update automatically)

The two stock are:

and

I have tried, but I can’t seem to find how to acquire the API or JSON data to configure these two stocks…

Does anyone have a suggestion I can try?

2

Bildschirmfoto_2021-03-06_15-50-57
Bildschirmfoto_2021-03-06_15-50-57685Ă—615 42.5 KB

HTH

1 Like
3

Thank you so much!
Very clear and works like a charm.

4

Hi there, I am allowing myself to slightly hijack this thread. First, thanks to ProgFriese because I was also trying to solve this issue. However, when I use this solution, the historical data are only fetched since early February, not earlier. I would think that it is because this is how “investing.com” display the historical quote by defaut.

Therefore, I was wondering if there is a way to do a mix of that with the earlier quote from a file. So I would download the historical data in a csv file and the new ones would be fetched via the webside.

5

This feature is already available, you could import historical prices manually and on top automatically per your provider settings:

6

Thanks a lot. I thought it was one or the other.

7

Hi All,

Someone knows where I could find a good link for historical data for ASN Groenprojectenfonds (ASNGF.AS)?

Unfortunately it cannot be found on investing.com…

8

Why not Yahoo Finance till a better source is found?

9

Yahoo has no historical data for ASNGF.AS

Try JSON

Bildschirmfoto_2021-12-15_18-44-46
Bildschirmfoto_2021-12-15_18-44-46699Ă—889 56.2 KB

https://api.onvista.de/api/v1/instruments/FUND/177801288/eod_history?idNotation=297900001&range=Y5&startDate=2019-09-08

$.datetimeLast[*]

$.last[*]
10

Thank you @ProgFriese you are a wizard! This was what I was looking for. Your example will help me to tailor some other Funds for me also.

Very much appreciated.

11

How to find the numbers (for example 177801288 and 297900001 for ASN Groenprojectenfonds) is explained in Historische Kurse von onvista nicht mehr lesbar - #66 by ProgFriese

12

Hi, thanks for sharing. I tried to add historical data from here but does not work.
Any advice ?

13

Bildschirmfoto_2021-12-28_19-05-35
Bildschirmfoto_2021-12-28_19-05-35698Ă—830 60 KB

Hm, works for me.

14

Good morning,
thank you for the reply. Yeah now it works, i guess was a temporary problem of investing :slight_smile:

15

Hi, first of all congratulations for this tool! I have configured the tool with all the financial instruments like stocks, bonds and etf. I have a particular type of instruments called certificates whose quotation can be found only in Euronext Markets: Real-time Stock Market Data | live (e.g. NLBNPIT25EF1, this is a certificate from BNP Paribas). Do you have any advice to automatically update the price? Thank you and Merry Christmas

16

Forget euronext to get rates for PP, it won’t work (nailed down with a bunch of js, POST requests etc).

That’s not true.

If you search for NLBNPIT25EF1 you will find

https://www.marketscreener.com/quote/certificate/PHOENIX-SNOWBALL-WORST-OF-172905822/graphics/

You can use the number 172905822 from marketscreener on zonebourse.com in the following way:

Bildschirmfoto_2024-12-25_12-40-37
Bildschirmfoto_2024-12-25_12-40-37743Ă—891 54.1 KB

https://www.zonebourse.com/mods_a/charts/TV/function/history?from={TODAY:unixtime:-P12M}&to={TODAY:unixtime}&symbol=172905822&resolution=D&requestType=GET&src=itfp
$.t[*]
$.c[*]

The parts {TODAY:unixtime:-P12M} and {TODAY:unixtime} are interpreted by PP, so the URL cannot be used in a browser.

If you want to see an example result in a browser, use something like this:

https://www.zonebourse.com/mods_a/charts/TV/function/history?from=1733742000&to=1735556400&symbol=172905822&resolution=D&requestType=GET&src=itfp
1 Like