네이버에서 환율시세 크롤링해서 활용하기(3)

https://www.moayo.net/p-moayo-20590 (짧은주소)

크롤링한 환율 데이터로 구글챠트를 활용해 챠트를 그리는 방법입니다

환율 정보를 크롤링한 내용을 가지고

구글 챠트를 활용해 그래프를 그리는 소스입니다

구글챠트 https://developers.google.com/chart 달러리치 블로그 https://m.blog.naver.com/boot/222430430028

추후에 더 정리해 유용한 보조지표로 사용할 계획입니다

01_dollar.php

<?
include "{$_SERVER[DOCUMENT_ROOT]}swww/header.php";//헤더정보
include $_SERVER[DOCUMENT_ROOT]."swww/top.php";//탑부분 호출

$tableName="t21081801_hdollar";

//현재 환율
$sql="  select * from $tableName where 1 ";
$sql.=" order by ext1 desc";
$sql.=" limit 0,1";
$result=mysql_query($sql,$dbcon);
$row=mysql_fetch_array($result);
$info_text.="<div style='line-height:150%;'>환율:".number_format($row[p_int1],2)."</div>";


//52주 (최대값+최소값)/2 평균값
$sdate=date("Y-m-d",strtotime("-1 years"));//1년전 52주를 기준으로
$edate=date("Y-m-d");
$asql="select (max(p_int1)+min(p_int1))/2 as avg_price , min(p_int1) as min_avg_price from $tableName where 1";
$asql.=" and ext1>='$sdate'";
$asql.=" and ext1<='$edate'";
$aresult=mysql_query($asql,$dbcon);
$arow=mysql_fetch_array($aresult);

$sdate=date("Y-m-d",strtotime("-1 years"));//1년전 52주를 기준으로
$edate=date("Y-m-d");
$asql="select * from $tableName where 1";
$asql.=" and ext1>='$sdate'";
$asql.=" and ext1<='$edate'";
$info_text.="<div style='line-height:150%;'>52주평균값:".number_format($arow[avg_price],2)."</div>";
$info_text.="<div style='line-height:150%;'>52최저가:".number_format($arow[min_avg_price],2)."</div>";


//환율기록
$dsql="  select * from $tableName where 1 ";
$dsql.=" and ext1>='".date("Y-m-d 00:00:00",strtotime("-1 years"))."'";
$dsql.=" and ext1<='".date("Y-m-d 23:59:59")."'";
$dsql.=" order by ext1 asc";
//$dsql.=" limit 0,10";
$dresult=mysql_query($dsql,$dbcon);
while($drow=mysql_fetch_array($dresult)){
  $data1.=",['".date("y.m.d",strtotime($drow[ext1]))."',  ".$drow[p_int1].",".$arow[avg_price]."]";
}

//환율의 최고저저가
$msql="  select max(p_int1) as max_p_int1, min(p_int1) as min_p_int1 from $tableName where 1 ";
$msql.=" and ext1>='".date("Y-m-d 00:00:00",strtotime("-1 years"))."'";
$msql.=" and ext1<='".date("Y-m-d 23:59:59")."'";
$mresult=mysql_query($msql,$dbcon);
$mrow=mysql_fetch_array($mresult);

//현재환율위치
$now_dollar=round((($row[p_int1]-$mrow[min_p_int1])/($mrow[max_p_int1]-$mrow[min_p_int1]))*100);
?>


<div><?=$info_text?></div>

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {
        var data = google.visualization.arrayToDataTable([
          ['X', '환율','']
          <?=$data1?>
        ]);

        var options = {

          vAxis: {gridlines:{color:'#cccccc', count:5}},
          legend: 'none',
          width: 700,
          height: 300,
            series: {
            0: { lineWidth: 1 },
            1: { lineDashStyle: [4, 4] }
          },
          colors: ['#e2431e', '#3333ff']




        };

        var chart = new google.visualization.LineChart(document.getElementById('line_top_x'));
        chart.draw(data, options);
      }
  </script>

<div id="line_top_x"></div>
<br><br><br><br>


<div style="position:relative;border:1px solid #dddddd;background:#ffffff;width:550px;height:20px;border-radius:10px;">
  <!-- 타이틀 -->
  <div style="position:absolute;top:-25px;left:0px;">원달러환율</div>

  <!-- 평균값 -->
  <div style="border-radius:10px;width:20px;height:20px;background:#cccccc;position:absolute;left:50%;margin-left:-5px;"></div>

  <!-- 현재원달러환율 빨강동그라미 및 환율금액 -->
  <div style="border-radius:7px;width:14px;height:14px;background:#ff0000;position:absolute;left:<?=$now_dollar?>%;margin-left:-2px;margin-top:3.5px;">
    <!-- 환율금액 -->
    <div style="position:absolute;top:-4px;left:17px;white-space:nowrap;color:#ff6600;font-weight:bold;"><?=number_format($row[p_int1],2)?>원</div>
  </div> 
  
  <!-- 평균환율금액 -->
  <div style="position:absolute;left:50%;top:30px;margin-left:-20px;"><?=number_format($arow[avg_price],2)?>원</div>

  <!-- 최저환율금액 -->
  <div style="position:absolute;left:0%;top:30px;"><?=number_format($mrow[min_p_int1],2)?>원</div>

  <!-- 최고환율금액 -->
  <div style="position:absolute;right:0%;top:30px;"><?=number_format($mrow[max_p_int1],2)?>원</div>
</div>

<?
include $_SERVER[DOCUMENT_ROOT]."swww/bottom.php";//하단 호출
include "{$_SERVER[DOCUMENT_ROOT]}swww/tail.php";//종료
?>

유사한정보