public function stock($stockCode, $timeFrame, $dataType)
{
$graphData = Stock::getGraphData($stockCode, $timeFrame, $dataType);
$prices = \Lava::DataTable();
$prices->addStringColumn('Date')->addNumberColumn($dataType)->addNumberColumn('50 Day Moving Average')->addNumberColumn('200 Day Moving Average')->addRows($graphData);
return $prices->toJson();
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show(Request $request, $id)
{
if ($request->stockCodeFind) {
return redirect('stocks/' . $request->stockCodeFind);
}
if (Stock::where('stock_code', $id)->first()) {
$priceGraphData = Stock::getGraphData($id, 'last_month', 'Price');
$prices = \Lava::DataTable();
$prices->addStringColumn('Date')->addNumberColumn('Price')->addNumberColumn('50 Day Moving Average')->addNumberColumn('200 Day Moving Average')->addRows($priceGraphData);
$stockPriceLava = \Lava::LineChart('StockPrice')->dataTable($prices)->customize(['explorer' => ['actions' => ['dragToZoom', 'rightClickToReset']]])->setOptions(['width' => 620, 'height' => 360, 'title' => 'Price of ' . strtoupper($id)]);
$sector = Stock::where('stock_code', $id)->pluck('sector');
$motRecentSectorHistoricalsDate = SectorHistoricals::getMostRecentSectorHistoricalsDate();
return view('pages.individualstock')->with(['stockPriceLava' => $stockPriceLava, 'stock' => Stock::where('stock_code', $id)->first(), 'relatedStocks' => StockMetrics::getMetricsByStockList(Stock::getRelatedStocks($id), 'omit'), 'metrics' => StockMetrics::where('stock_code', $id)->first(), 'mostRecentStockHistoricals' => Historicals::where('stock_code', $id)->orderBy('date', 'DESC')->limit(1)->first(), 'sectorAverage' => SectorHistoricals::where(['sector' => $sector, 'date' => $motRecentSectorHistoricalsDate])->first()]);
}
return redirect('/');
}
