JSON HELP!!! Hi, sorry to bother you guys again with this issue. Everything that worked for me last week with JSON has stopped working now. Do you know what could happen?
Buenas, siento molestaros otra vez con este tema. Todo lo que me iba la semana pasada con JSON, ha dejado de funcionarme ahora. Sabéis que puede pasar?
Morningstar had a new launch of their websites:
The things of your interest is now just readable with authorization:
In short: Morningstar is no longer usable for PP.
Solution: Fundsquare, see Los precios no actualizan en Yahoo Finance - Qué hacer? - #2 by ProgFriese
ProgFriese, are you sure it is only possible with the API now? I know that from the graph on the new website it can be set as a table and by Price & Volume Details and selecting Show All below then you can get all historical NAVs https://global.morningstar.com/es/inversiones/fondos/F00000WK7J/grafico But I can’t see how to download that table or get it as a JSON.
It’s a pain not to have a JSON or CSV with the complete history, and Fundsquare doesn’t have spanish or german funds, etc…
XHS , por ahora lo que se me ocurre más fácil a parte de yahoo, que como sabes tampoco tiene todo el histórico y se suele retrasar con la publicación de precios, es desde tabla obtener los precios desde FT. Pero ojo!, entiendo se pueden Mantener los históricos que obtuvimos desde los json de MS al cambiar para obtener ahora las cotizaciones desde esa tabla
Pero, ahí sólo te dan los Precios de los últimos tres meses, así que No te olvides al aceptar, cuando te pregunte ¿qué deseas hacer con las cotizaciones históricas existentes? Darle a MANTENER! Haría lo mismo ya sea que lo pases a obtener por Yahoo, fundsquare, investing o desde donde sea.
Gracias!! Tengo ganas de llorar por eso.
Replace ‘only’ with ‘not’, then I’m sure.
When will we know if Morningstar (JSON) works?. Where can I follow these updates? Thanks
¿Cuándo sabremos si Morningstar (JSON) funciona? Donde puedo seguir estas actualizaciones?? Gracias
Para descargarlos de FT, como se hace? Thanks!!
How can I download Financial Times prices??
Te lo describí en anterior mensaje, ¿aún no hiciste? Desde “Tabla en sitio web” y mete el link que te pasé:
https://markets.ft.com/data/funds/tearsheet/historical?s=LU1299306321:EUR
Para el resto de fondos sólo cambia el isin, y dale a mantener que verás que aunque FT en esa tabla sólo te da de un mes, si le das a mantener todo el histórico se mantiene igual y FT actualiza igual de rápido o en algún fondo incluso más que MS!!
PD: si te empeñas con los JSON de MS y hasta que dure (cambien igual esa web):
https://lt.morningstar.com/api/rest.svc/timeseries_price/t92wz0sj7c?currencyId=EUR&idtype=Morningstar&frequency=daily&outputType=JSON&startDate=2015-11-19&id=F00000WK7J]2]0]FOEUR$$ALL
Ruta a la fecha $.TimeSeries.Security[*].HistoryDetail[*].EndDate
Ruta para la cotizacion $.TimeSeries.Security[*].HistoryDetail[*].Value
Muchas gracias @BravePawn, this also works for UK listed securities, changing currencyID to GBP or GBX.
It works again. Vuelve a funcionar
Good evening.
Is anybody experiencing issues with the Morningstar JSON tool? I’m not getting price updates since Monday. Apparently the URL is not working.
What is your error log saying.
More information would be useful!
Hi. I’m not getting any error. Is just that the prices don’t get updated. I have tried to copy paste the URL in my web browser and it doesn’t return any data when in the past yes so perhaps Morningstar could have changed its URL?
Can you guys please paste in url, date and price strings?
This males our life way easier.
$.TimeSeries.Security[].HistoryDetail[].EndDate
$.TimeSeries.Security[].HistoryDetail[].Value
I’m pretty sure the url @BravePawn posted still works. You need to make an almost exact carbon copy of the that @XHS the only difference being is that you need to substitute the Morningstar ID he used with the valid Morningstar Id for the fund you’re interested in. I’m out and about atm so unable to perform any testing but by the looks of it you may need to use ‘0P0000A96U’
Try changing only the beginning of the link, leaving the rest the same, so:
to
As you can see, I posted this link a while ago, since the one you have stopped working.
Any errors during the update should appear in Help/Show Error Log. If there are many, it might be easier to add the update path to your assets table, sort it by that column, and that way you’ll know that all entries should be replaced with it (at least for now).
Regards
Perfect. You are the GOAT
