YQL results yahoo.finance.analystestimate
I am trying to use yql for yahoo financial data. I checked Show Community Table
in the YQL console to see the database under the Yahoo tag.
I posted a sample yql: https://developer.yahoo.com/yql/console/?q=show%20tables&env=store://datatables.org/alltableswithkeys#h=SELECT+*+FROM+yahoo.finance.analystestimate+WHERE+symbol%3D'PRLB'
but I got as result:
"results": {
"results": {
"symbol": "PRLB"
}
}
I would expect formatted data taken from here like profit estimates, EPS trends ... The same happens for similar tables.
What am I doing wrong?
+3
source to share
1 answer
JS for table no longer works i.e. it needs to be corrected.
This is partially formatted ...
<?xml version="1.0" encoding="UTF-8"?>
<table xmlns="http://query.yahooapis.com/v1/schema/table.xsd">
<meta>
<author><!-- your name or company name --></author>
<description><!-- description of the table --></description>
<documentationURL><!-- url for API documentation --></documentationURL>
<apiKeyURL><!-- url for getting an API key if needed --></apiKeyURL>
<sampleQuery>select * from {table}</sampleQuery>
</meta>
<bindings>
<select itemPath="" produces="XML">
<urls>
<url><!-- REST endpoint to select data from --></url>
</urls>
<inputs>
<key id="" type="xs:string" paramType="query" />
</inputs>
<execute>
<![CDATA[
function getelement(row) { if(row.hasOwnProperty("p")) return(row.p.text()); return(row.font.text()); }
// Setup Query from finance.yahoo.com
var url="http://finance.yahoo.com/q/ae?s=" + symbol;
var restquery = y.rest( url );
var rawresult = restquery.accept( "text/html" ).get().response;
var aequery = y.xpath( rawresult, "//table[@class='yfnc_tableout1']/tr[count(td)=0]/parent::*|" + "//table[@class='yfnc_tableout1']/tr/td/table" );
// Process Results
var aedata = <results symbol={symbol}></results>;
var i = 0; while(i < aequery.length()) {
var table = aequery[i];
var thead = table.tr[0];
var tname = thead.th[0].strong.text().toString().replace(/ /g, "");
var fname1 = thead.th[1].p.text().toString().replace(/\n.*/, "");
var fname2 = thead.th[2].p.text().toString().replace(/\n.*/, "");
var fname3 = thead.th[3].p.text().toString().replace(/\n.*/, "");
var fname4 = thead.th[4].p.text().toString().replace(/\n.*/, "");
fname1 = fname1.replace(/[\s\.]+/g, "").replace(/\&/,"");
fname2 = fname2.replace(/[\s\.]+/g, "").replace(/\&/,"");
fname3 = fname3.replace(/[\s\.]+/g, "").replace(/\&/,"");
fname4 = fname4.replace(/[\s\.]+/g, "").replace(/\&/,"");
var tblval = <{tname}></{tname}>;
var j = 1;
while(j < table.tr.length()) {
var row = table.tr[j].td;
var rname = row[0].p.text().toString().replace(/[\s\.]+/g, "");
rname = rname.replace(/\(.*\)/g,"").replace(/\%/,"").replace(/^(\d)/,"_$1");
rname = rname.replace(/\//, "");
var rval1 = getelement(row[1]);
var rval2 = getelement(row[2]);
var rval3 = getelement(row[3]);
var rval4 = getelement(row[4]);
tblval.appendChild(<{rname}> <{fname1}>{rval1}</{fname1}> <{fname2}>{rval2}</{fname2}> <{fname3}>{rval3}</{fname3}> <{fname4}>{rval4}</{fname4}> </{rname}>); j = j + 1; } aedata.appendChild(tblval); i = i + 1; }
// Return aedata strucuture
response.object = aedata;
]]>
</execute>
</select>
</bindings>
</table>
0
source to share