How can I add this bond with on PP?

English Quotes
1

I’m trying to add this ISIN US912810QN19

However, even if I search with the ISIN, PP is not able to find historical prices.

Any suggestions? Thank you

2

Please read Cannot find Italian Bond

grafik
grafik735×672 46 KB

1 Like
3

Thanks, for US912810QN19 I solved with investing.com as suggested by you.

However, what about when the security is not found on investing.com? For example, I’m having problems with these:

4

Then you have to look around where you can find a better source. In german and hard to read: Quellen für historische Kurse

If you can’t find a source with values from borsa italiana you can use other sources from other exchanges. The values are then not exactly the same, but the direction is correct.

For example
US912810TV08 (Exchange Stuttgart per onvista)

grafik
grafik695×802 53.1 KB

https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=M1&startDate={TODAY:yyyy-MM-dd:-P1M}
$.datetimeLast[*]
$.last[*]

{TODAY:yyyy-MM-dd:-P1M} is a makro which works in PP, not in a browser.
If you want to see the response in a browser use

https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=M1&startDate=2025-03-13

GB00B1VWPJ53

https://api.onvista.de/api/v1/instruments/BOND/16975292/eod_history?idNotation=73097102&range=M1&startDate={TODAY:yyyy-MM-dd:-P1M}
$.datetimeLast[*]
$.last[*]
2 Likes
5

Thanks, very helpful the onvista.de solution. Seems that it contains all I need, even though with small different values.

Just two open points now:

  • is there a way to just use this macro in PP in an “automatic” way to retrieve historical prices and update the price day by day for the next months? I was unable to find a part of PP where I can load this macro
  • how can I just create the API URL for other ISIN? For example, starting from the ISIN US912810TV08, how did you get this URL https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=M1&startDate={TODAY:yyyy-MM-dd:-P1M} ?
6

You must use this macro in the URL (manually inserted instead of a fixed date), otherwise you would have to change the URL every day.

That is exactly what the Macro does.
Today is 13.04.2025
{TODAY:yyyy-MM-dd:-P1M} → 2025-03-13
Tommorow is 14.04.2025
{TODAY:yyyy-MM-dd:-P1M} → 2025-03-14

EDIT:

In a nutshell
use firefox
go to onvista.de
search for US912810TV08

grafik
grafik844×521 53.1 KB

“Alle Kurse”
scrool down to
grafik
grafik981×360 44.2 KB

press ctrl+shift+i
grafik
grafik1669×514 74.4 KB

and change from gettex to Stuttgart and press “Anzeigen”
grafik
grafik1679×525 76.5 KB

mark the response
grafik
grafik1679×635 103 KB

copy the URL

https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=M1&startDate=2025-03-13&withEarnings=false

edit the URL an editor to

https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=M1&startDate={TODAY:yyyy-MM-dd:-P1M}

use the URL in the JSON-Provider for historical quotes

1 Like
7

You must use this macro in the URL (manually inserted instead of a fixed date), otherwise you would have to change the URL every day.

I’m not sure to have correctly understood. When I’m adding a new empty security, where should I load the macro?

Screenshot 2025-04-13 alle 11.28.34
Screenshot 2025-04-13 alle 11.28.341398×1142 169 KB

I don’t know a tutorial, but there are some postings here, for example How can I track certificates? - #2 by ProgFriese In your case I start with your link Investment Centre | Money Management doesn’t find result with the ISIN but with VAN1579AU I found Vanguard Australia FAS I investigate the networktraffic with firefox to find the JSON-response. If you have it, jsonpathfinder is very helpful to find out the correct paths to…

Ok, can you help me even with this ISIN XS2537091899 (Ebrd Tf 28% St27 Try quotazioni in tempo reale | XS2537091899 - Borsa Italiana) Thank you

8

see my EDIT above

You can do it yourself, now.

9

You mean where should you paste the URL

JSON

grafik
grafik693×648 44.9 KB

10

ok, perfect. With the edited message and your last message I solved both problems:

  • load historical values in PP with the API URL
  • find a new API URL for a new ISIN with onvista.de

Just last question: as of now, we are able to retrieve historical values of last month (and I think in the next days it will update and save the price, day-by-day). However, If I want to retrieve older historical values (e.g. price of 6 months ago)? Do you think is it possible?

11

Try it out.

grafik
grafik1311×454 74.9 KB

What do you think range=M1 could mean?

https://api.onvista.de/api/v1/instruments/BOND/258813091/eod_history?idNotation=441762676&range=Y5&startDate=2020-04-13

Maybe range=Y5 is for 5 years?

If you use bigger ranges to fetch the values once, it is OK.

For permanent use, please select small values, like M1 or max M3, otherwise such APIs will soon no longer be accessible.

Please note that the specifications for range and macro must match, for example

range=M1&startDate={TODAY:yyyy-MM-dd:-P1M}

range=M3&startDate={TODAY:yyyy-MM-dd:-P3M}

range=Y1&startDate={TODAY:yyyy-MM-dd:-P1Y}

and so on

1 Like
12

ok, I was trying with range, but I didn’t know that the specifications for range and macro must match, then it didn’t work.

Now with your suggestion all is properly working, thanks again.