Muy buenas, estoy tratando de sacar el cambio de divisa en tiempo real (o al menos con unos 20 minutos de retraso como mucho). Utilizo yahoo finance. Llamo a la URL así:
Código PHP:
$url = 'https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22GBPEUR%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=';
$data = file_get_contents($url);
echo $data;
Ésta URL me devuelve lo siguiente:
{"query":{"count":1,"created":"2017-05-29T13:43:39Z","lang":"en-US","diagnostics":{"url":[{"execution-start-time":"0","execution-stop-time":"1","execution-time":"1","content":"http://www.datatables.org/yahoo/finance/yahoo.finance.xchange.xml"},{"execution-start-time":"3","execution-stop-time":"4","execution-time":"1","content":"http://download.finance.yahoo.com/d/quotes.csv?s=GBPEUR=X&f=snl1d1t1ab"}],"publiclyCallable":"true","cache":{"execution-start-time":"2","execution-stop-time":"3","execution-time":"1","method":"GET","type":"MEMCACHED","conte nt":"128fd670d335fd8e3695c5d60f4b7ab5"},"query":{" execution-start-time":"3","execution-stop-time":"4","execution-time":"1","content":"select * from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=GBPEUR=X&f=snl1d1t1ab' and columns='Symbol,Name,Rate,Date,Time,Ask,Bid'"},"ja vascript":{"execution-start-time":"2","execution-stop-time":"4","execution-time":"2","instructions-used":"18662","table-name":"yahoo.finance.xchange"},"user-time":"5","service-time":"3","build-version":"2.0.134"},"results":{"rate":{"id":"GBPEU R","Name":"GBP/EUR","Rate":"1.1479","Date":"5/29/2017","Time":"9:14am","Ask":"1.1483","Bid":"1.1479 "}}}}
De aquí, lo que quiero sacar es en "results" -> "rate" -> "Rate". Que en este caso es 1.1479....hay alguna manera de sacarlo sin tener que utilizar funciones de cadenas para llegar a ese dato?
Gracias!!!