Home Add Stock Quote Graphs With PHP (Alpha Vantage API)

Add Stock Quote Graphs With PHP (Alpha Vantage API)

October 4, 2017

The PHP function on this page supports the article published here, titled “Add Stock Quote Graphs to WordPress With Shortcode (Alpha Vantage API)”. The PHP function retrieves stock data from the Alpha Vantage API and renders it into a Google graph. It’s rather incomplete in that it only seeks to provide a single generic example of how the data might be used.

Find the WordPress shortcode article here.

The function requires use of Simple Cache.

PHP Function

<?php
include('../simple-cache/cache.inc.php');

/*
	Add Stock Quote Graphs to WordPress With Shortcode
	http://www.beliefmedia.com/stock-quote-graph-wordpress
*/


function beliefmedia_alphavantage_quotes($symbol, $args = '') {

  $atts = array(
    'width' => '600',
    'height' => '410',
    'time' => '2',
    'number' => '90',
    'size' => 'compac', /* compac or full */
    'interval' => '60', /* 1min, 5min, 15min, 30min, 60min */
    'apikey' => 'xxxxxxxxxxxxxxxxx',
    'cache' => 3600
  );

 /* Merge $args with $atts */
 $atts = (empty($args)) ? $atts : array_merge($atts, $args);

 $transient = 'alpha_vantage_stock_' . md5(serialize($atts) . $symbol);
 $cachedposts = beliefmedia_get_transient($transient, $atts['cache']);

 if ($cachedposts !== false) {
  return $cachedposts;

 } else {

    switch ($atts['time']) {
        case 1:
            $series = 'TIME_SERIES_INTRADAY';
            $series_name = 'Time Series (' . $atts['interval'] . 'min)';
            break;
        case 2:
            $series = 'TIME_SERIES_DAILY';
            $series_name = 'Time Series (Daily)';
            break;
        case 3:
            $series = 'TIME_SERIES_DAILY_ADJUSTED';
            $series_name = 'Time Series (Daily)';
            break;
        case 4:
            $series = 'TIME_SERIES_WEEKLY';
            $series_name = 'Weekly Time Series';
            break;
        case 5:
            $series = 'TIME_SERIES_MONTHLY';
            $series_name = 'Monthly Time Series';
            break;
        default:
            $series = 'Time Series (Daily)';
            break;
    }

    /* Get Stock data */
    $data = @file_get_contents('https://www.alphavantage.co/query?function=' . $series . '&symbol=' . $symbol . '&interval=' . $atts['interval'] . 'min&apikey=' . $atts['apikey'] . '&interval=' . $atts['interval'] . 'min&outputsize=' . $atts['size']);
    if ($data === false) return '<p>Data currently unavailable.</p>';
    $data = json_decode($data, true);
    $data = $data[$series_name];

    /* Return portion of results & reverse */ 
    if ($atts['number'] != '') $data = array_slice($data, 0, $atts['number'], true);
    $data = array_reverse($data, true);

    foreach ($data AS $key => $value) {
      $chart .= ',[new Date(' . str_replace(array('-', ' ', ':'), ',', $key) . '), ' . $value['4. close'] . ']';
    }

    $chart = ltrim($chart, ',');

   /* Build chart with fresh data */
   $return = "<script type='text/javascript' src='https://www.gstatic.com/charts/loader.js'></script>
    <script type='text/javascript'>
      google.charts.load('current', {packages: ['corechart', 'line']});
      google.charts.setOnLoadCallback(drawTrendlines);

    function drawTrendlines() {
      var data = new google.visualization.DataTable();
        data.addColumn('date', 'Date');
        data.addColumn('number', 'Close');

      data.addRows([
        $chart
      ]);

      var options = {
        hAxis: {
          title: 'Date'
        },
        backgroundColor: 'transparent',
        vAxis: {
          title: 'Stock Price'
        },
        colors: ['#AB0D06'],
        trendlines: {
          // 0: {type: 'exponential', color: '#333', opacity: 1},
          // 1: {type: 'linear', color: '#111', opacity: .3}
        }
      };

      var chart = new google.visualization.LineChart(document.getElementById('chart_div_$interval'));
      chart.draw(data, options);
    }
    </script>";
 
    /* Chart container */
    $return .= '<div id="chart_div_' . $interval . '" style="width: ' . $atts['width'] . 'px; height: ' . $atts['height'] . 'px;"></div>';

   /* Set transient chart data */
   beliefmedia_set_transient($transient, $return, $atts['cache']);
   return $return;
 }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

<?php

include('../simple-cache/cache.inc.php');

Add Stock Quote Graphs to WordPress With Shortcode

http://www.beliefmedia.com/stock-quote-graph-wordpress

function beliefmedia_alphavantage_quotes($symbol, $args = '') {

$atts = array(

'width' => '600',

'height' => '410',

'time' => '2',

'number' => '90',

'size' => 'compac', /* compac or full */

'interval' => '60', /* 1min, 5min, 15min, 30min, 60min */

'apikey' => 'xxxxxxxxxxxxxxxxx',

'cache' => 3600

);

/* Merge $args with $atts */

$atts = (empty($args)) ? $atts : array_merge($atts, $args);

$transient = 'alpha_vantage_stock_' . md5(serialize($atts) . $symbol);

$cachedposts = beliefmedia_get_transient($transient, $atts['cache']);

if ($cachedposts !== false) {

return $cachedposts;

} else {

switch ($atts['time']) {

case 1:

$series = 'TIME_SERIES_INTRADAY';

$series_name = 'Time Series (' . $atts['interval'] . 'min)';

break;

case 2:

$series = 'TIME_SERIES_DAILY';

$series_name = 'Time Series (Daily)';

break;

case 3:

$series = 'TIME_SERIES_DAILY_ADJUSTED';

$series_name = 'Time Series (Daily)';

break;

case 4:

$series = 'TIME_SERIES_WEEKLY';

$series_name = 'Weekly Time Series';

break;

case 5:

$series = 'TIME_SERIES_MONTHLY';

$series_name = 'Monthly Time Series';

break;

default:

$series = 'Time Series (Daily)';

break;

}

/* Get Stock data */

$data = @file_get_contents('https://www.alphavantage.co/query?function=' . $series . '&symbol=' . $symbol . '&interval=' . $atts['interval'] . 'min&apikey=' . $atts['apikey'] . '&interval=' . $atts['interval'] . 'min&outputsize=' . $atts['size']);

if ($data === false) return '<p>Data currently unavailable.</p>';

$data = json_decode($data, true);

$data = $data[$series_name];

/* Return portion of results & reverse */

if ($atts['number'] != '') $data = array_slice($data, 0, $atts['number'], true);

$data = array_reverse($data, true);

foreach ($data AS $key => $value) {

$chart .= ',[new Date(' . str_replace(array('-', ' ', ':'), ',', $key) . '), ' . $value['4. close'] . ']';

}

$chart = ltrim($chart, ',');

/* Build chart with fresh data */

$return = "<script type='text/javascript' src='https://www.gstatic.com/charts/loader.js'></script>

google.charts.load('current', {packages: ['corechart', 'line']});

google.charts.setOnLoadCallback(drawTrendlines);

function drawTrendlines() {

var data = new google.visualization.DataTable();

data.addColumn('date', 'Date');

data.addColumn('number', 'Close');

data.addRows([

$chart

]);

var options = {

hAxis: {

title: 'Date'

backgroundColor: 'transparent',

vAxis: {

title: 'Stock Price'

colors: ['#AB0D06'],

trendlines: {

// 0: {type: 'exponential', color: '#333', opacity: 1},

// 1: {type: 'linear', color: '#111', opacity: .3}

}

};

var chart = new google.visualization.LineChart(document.getElementById('chart_div_$interval'));

chart.draw(data, options);

}

</script>";

/* Chart container */

$return .= '<div id="chart_div_' . $interval . '" style="width: ' . $atts['width'] . 'px; height: ' . $atts['height'] . 'px;"></div>';

/* Set transient chart data */

beliefmedia_set_transient($transient, $return, $atts['cache']);

return $return;

}

Usage

The function requires only a stock symbol. To alter the default attributes as defined by the $atts array, pass them via an $args array as a second function argument.

/* Basic usage */
echo beliefmedia_alphavantage_quotes($symbol = 'F');

1 2	/* Basic usage */ echo beliefmedia_alphavantage_quotes($symbol = 'F');

WordPress Shortcode Result

The result as returned from our shortcode function is as follows:

Download

Download the WordPress shortcode here.

Title: Add Stock Quote Graphs With PHP
Description: Add a stock quote graph with a PHP function. Utilizes the Alpha Vantage API. WordPress shortcode version is also available.
Download: PHP Code (V0.1) | Plugin Page

Short URL for this post: http://shor.tt/1XVa