Récupérer les cours historiques en JSON

Bonjour,

  1. Dans le “JSON” ci-dessous quel est :

    Le chemin vers la date et
    Le chemin vers le prix à indiquer dans PP (Cotations historique) pour récupérer les infos

    Un lien web pour comprendre comment résoudre l’opération, dans le futur me serait très utile

 {"chart":{"result":[{"meta":{"currency":"EUR","symbol":"0P0000YGEN.F","exchangeName":"FRA","instrumentType":"MUTUALFUND","firstTradeDate":1514876400,"regularMarketTime":1683748800,"gmtoffset":7200,"timezone":"CEST","exchangeTimezoneName":"Europe/Berlin","regularMarketPrice":213.16,"chartPreviousClose":208.39,"priceHint":2,"currentTradingPeriod":{"pre":{"timezone":"CEST","start":1683871200,"end":1683871200,"gmtoffset":7200},"regular":{"timezone":"CEST","start":1683871200,"end":1683921600,"gmtoffset":7200},"post":{"timezone":"CEST","start":1683921600,"end":1683921600,"gmtoffset":7200}},"dataGranularity":"1d","range":"1mo","validRanges":["1mo","3mo","6mo","ytd","1y","2y","5y","10y","max"]},"timestamp":[1681279200,1681365600,1681452000,1681711200,1681797600,1681884000,1681970400,1682056800,1682316000,1682402400,1682488800,1682575200,1682661600,1683007200,1683093600,1683180000,1683266400,1683525600,1683612000,1683698400,1683784800,1683871200],"indicators":{"quote":[{"volume":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,null],"low":[208.38999938964844,211.39999389648438,211.1300048828125,211.44000244140625,211.39999389648438,210.99000549316406,210.0399932861328,210.3000030517578,210.25999450683594,207.5,206.89999389648438,210.77999877929688,212.13999938964844,210.30999755859375,209.47000122070312,208.89999389648438,212.6300048828125,null,212.05999755859375,213.16000366210938,null,null],"high":[208.38999938964844,211.39999389648438,211.1300048828125,211.44000244140625,211.39999389648438,210.99000549316406,210.0399932861328,210.3000030517578,210.25999450683594,207.5,206.89999389648438,210.77999877929688,212.13999938964844,210.30999755859375,209.47000122070312,208.89999389648438,212.6300048828125,null,212.05999755859375,213.16000366210938,null,null],"open":[208.38999938964844,211.39999389648438,211.1300048828125,211.44000244140625,211.39999389648438,210.99000549316406,210.0399932861328,210.3000030517578,210.25999450683594,207.5,206.89999389648438,210.77999877929688,212.13999938964844,210.30999755859375,209.47000122070312,208.89999389648438,212.6300048828125,null,212.05999755859375,213.16000366210938,null,null],"close":[208.38999938964844,211.39999389648438,211.1300048828125,211.44000244140625,211.39999389648438,210.99000549316406,210.0399932861328,210.3000030517578,210.25999450683594,207.5,206.89999389648438,210.77999877929688,212.13999938964844,210.30999755859375,209.47000122070312,208.89999389648438,212.6300048828125,null,212.05999755859375,213.16000366210938,null,null]}],"adjclose":[{"adjclose":[208.38999938964844,211.39999389648438,211.1300048828125,211.44000244140625,211.39999389648438,210.99000549316406,210.0399932861328,210.3000030517578,210.25999450683594,207.5,206.89999389648438,210.77999877929688,212.13999938964844,210.30999755859375,209.47000122070312,208.89999389648438,212.6300048828125,null,212.05999755859375,213.16000366210938,null,null]}]}}],"error":null}}
  1. Autre question la traduction exacte en français de :slight_smile:
    fiftyTwoWeekLowChange et fiftyTwoWeekHighChange

Merci de vos réponses

En général, https://jsonpathfinder.com/ est très utile.
Mais pas pour ton exemple:

D’où provient cette réponse JSON ?

Tu veux peut-être lire et comprendre A fund is not found by the intrument search in the system
pour finir sur https://www.boursorama.com/bourse/action/graph/ws/GetTicksEOD?symbol=0P0000YGEN&length=7300&period=0 ?

@ProgFriese Merci
Pour utiliser jsonpathfinder.com il faut coller le JSON juste après } ?
J’obtiens le message :

There seems to be a problem with your JSON.
Error message: Unexpected non-whitespace character after JSON at position 156

D’où provient cette réponse JSON ?
De https://query1.finance.yahoo.com/v8/finance/chart/0P0000YGEN.F?range=1mo&interval=1d

Il faut insérer la réponse dans son intégralité. Si j’insère directement la réponse de https://query1.finance.yahoo.com/v8/finance/chart/0P0000YGEN.F?range=1mo&interval=1d, cela fonctionne aussi.


$.chart.result[0].timestamp[*]
et
$.chart.result[0].indicators.quote[0].close[*]

boursorama est plus fiable que yahoo

1 Like

@ProgFriese
Merci. Avec tes informations et précisions j’ai avancé ; maintenant que je sais manipuler “l’historique de Yahoo” (plaisir intellectuel satisfait), peux fiable je l’abandonne au profit de Boursorama.
Bonne journée

:smile:

:+1: