v7999@-- - 経済統計練習帳

google.load("visualization", "1", {packages:["corechart"]});
var open = new Array();
var high = new Array();
var low = new Array();
var close = new Array();
 var x = new Array();
 var d = new Array();
 var date = new Array();
 
function sample() {
 
        var query = "SELECT * FROM " +
            '1iXUk3I8yixPwKFFgepkZly3r-EEP-pSIDN3xfmgz';
        var encodedQuery = encodeURIComponent(query);
 
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
        url.push('&callback=?');
 
 
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
                sx = 0;
 
                for (var i in rows) {
                    y1=rows[i][0];
                    m1=rows[i][1];
                    d1=rows[i][2];
                  c=rows[i][3];
 if(c=="サービス業")sx=sx+1;
 if(c=="サービス業")open[sx]=rows[i][4];
 if(c=="サービス業")high[sx]=rows[i][5];
 if(c=="サービス業")low[sx]=rows[i][6];
 if(c=="サービス業")close[sx]=rows[i][7];
 
                }
 
 
                number = sx;
 
maxp=0;
minp=99999;
                for(s=1;s<number+1;s++){
                if(open[s]>maxp)maxp=open[s];    
           if(open[s]<minp)minp=open[s];  
                }
 
 
 
 
 
 
 
    paint();
 
 
 
 
 
 
            }
        });
 
}
 
function paint(){
 
var sub=new svgpaint();
 
str="<svg width=\"500\" height=\"500\">";
 
for(s=1;s<100;s++){    
p1=500*(open[s]-minp)/(maxp-minp);
p3=500*(close[s]-minp)/(maxp-minp);
p2=500*(open[s]-close[s])/(maxp-minp);
if(p2>0)str=str+sub.rect(5*s-2,500-p1,4,p2,"red");
if(p2<0)str=str+sub.rect(5*s-1,500-p3,4,-p2,"green");
p1=500*(high[s]-minp)/(maxp-minp);
p2=500*(low[s]-minp)/(maxp-minp);
str=str+sub.line(5*s,500-p1,5*s,500-p2,2,"black");
}
 
str=str+"</svg>";
 
$("#memo").html(str);   
 
}