Get Historical Data

The Gist

  • Get historical data with these functions

  • Typing "growth" at the end will get the growth of the metric over time

  • All syntax is case insensitive

  • All data can be requested as a chart by typing "chart" at the end of a command

  • All data can be requested as an excel file by typing "excel" at the end of a command

Function
Description

$historicalQuarterlyData <metric> ":" <ticker>

<optional arguments : "growth" "yearly">

Gets the historic quarterly data of a metric for a ticker

$historicalTTMdata <metric> ":" <ticker>

<optional arguments : "growth" "yearly">

Gets the historic trailing 12 month data of a metric for a ticker

$historicalProportion <numerator> "/" <denominator> ":" <ticker> <optional arguments: "quarterly" "spaced yearly">

Gets the historic proportion of one metric to another

$perShareComparison <metric> ":" <ticker> <optional arguments : "TTM" "yearly" "difference">

Shows the growth of a metric per share and the growth of the metric as a whole

$historicalMetricPerShare <metric> ":" <ticker>

<optional arguments : "TTM" "yearly" "growth">

Gets a metric per share over time

$historicalQuarterlyData Function

Gets the historical value of a metric

Yearlymeans that the data shown is spread 4 quarters apart

Growth means that you get the year over year growth for the metric.

I am putting "chart" at the end of all the commands below since the keywords make a lot more sense when seen visually

$historicalQuarterlyData Assets: aapl chart

$historicalTTMdata Function

Gets the historical value of a metric

Yearlymeans that the data shown is spread 4 quarters apart

Growth means that you get the year over year growth for the metric

I am putting "chart" at the end of all the commands below since the keywords make a lot more sense when seen visually

$historicalTTMdata Operating Cash Flow: aapl chart

$historicalProportion Function

Gets the historical value of a metric

Quarterly means that you compare one quarter to another instead of comparing one trailing twelve month period to another.

Yearlymeans that the data shown is spread 4 quarters apart

I am putting "chart" at the end of all the commands below since the keywords make a lot more sense when seen visually

$historicalProportion YouTube Ads/Revenue: googl chart

$perShareComparison Function

Compares the growth of a metric on a per share basis versus the growth of the metric on a nominal basis

TTM means the data shown will represent the 12 months prior from the date of the quarter

Yearly means that the data shown is spread 4 quarters apart

Difference means that the you just see the value of the metrics growth on a per share basis minus the growth of the metric on a nominal basis

I am putting "chart" at the end of all the commands below since the keywords make a lot more sense when seen visually

$perShareComparison Operating Cash Flow: googl chart

$historicalMetricPerShare Function

Compares the growth of a metric on a per share basis versus the growth of the metric on a nominal basis

TTM means the data shown will represent the 12 months prior from the date of the quarter

Yearly means that the data shown is spread 4 quarters apart

Growth means that you get the year over year growth for the metric

I am putting "chart" at the end of all the commands below since the keywords make a lot more sense when seen visually

$historicalMetricPerShare Book Value: aapl chart

Last updated