Import Quotes for Fund- JSON or URL

English Quotes
1

Hi, I am trying to import data for the following fund

Royal London Global Equity Income M

I have tried using a JSON guide but I am unable to get the data pulling through. I have the following set up in PP

image
image678×607 19.3 KB

I don’t really know what I am doing, so any help would be great.
The JSON path from Morningstar is below, which appears to be working correctly
https://tools.morningstar.co.uk/api/rest.svc/timeseries_cumulativereturn/t92wz0sj7c?currencyId=GBP&idtype=Morningstar&frequency=daily&startDate=2021-07-07&id=F000014SEJ]2]0]FOGBR$$ALL

I could use help with the other fields in the Historical Quotes section.

Thanks
Rob

2

In your URL is “…/rest.svc/timeseries_cumulativereturn/…”

For the prices you need “…/rest.svc/timeseries_price/…”

https://tools.morningstar.co.uk/api/rest.svc/timeseries_price/t92wz0sj7c?currencyId=GBP&idtype=Morningstar&frequency=daily&outputType=JSON&startDate=2020-12-31&id=F000014SEJ]2]0]FOGBR$$ALL

$.TimeSeries.Security[0].HistoryDetail[*].EndDate
yyyy-MM-dd
$.TimeSeries.Security[0].HistoryDetail[*].Value

Bildschirmfoto_2024-02-06_22-42-23
Bildschirmfoto_2024-02-06_22-42-23693×756 51 KB

Maybe it is more easy to use FT

https://markets.ft.com/data/funds/tearsheet/historical?s=GB00BL6V1118:GBP

Bildschirmfoto_2024-02-06_22-43-40
Bildschirmfoto_2024-02-06_22-43-40694×550 34.9 KB

3 Likes
3

Hi,
Many thanks for your help, quick reply and detailed help. The FT data didn’t pull lots of history so I wasn’t able to make it product a chart, as the table was limited to a month.

I tried your json, but was still not working, managed to copy and cross reference your main changes to replicate your screenshot as well and have got it working. For my future reference I will post the url.

https://tools.morningstar.co.uk/api/rest.svc/timeseries_price/t92wz0sj7c?currencyId=GBP&idtype=Morningstar&frequency=daily&outputType=JSON&startDate=2020-12-31&id=F000014SEJ]2]0]FOGBR$$ALL

Seems like when posting as code it is deleting the “]2]0]FOGBR$$ALL” part, which is probably what made it not work for me.

Thanks again.

1 Like
4 
https://tools.morningstar.co.uk/api/rest.svc/timeseries_price/t92wz0sj7c?currencyId=GBP&idtype=Morningstar&frequency=daily&outputType=JSON&startDate=2020-12-31&id=F000014SEJ]2]0]FOGBR$$ALL

Uups, your right, I will edit my post