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

Syntax: $historicalQuarterlyData <metric> ":" <ticker> <Optional arguments: "yearly" "growth"

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

Example 1

$historicalQuarterlyData Assets: aapl chart

Example with "yearly"

Example with "growth"

$historicalTTMdata Function

Gets the historical value of a metric

Syntax: $historicalTTMData <metric> ":" <ticker> <Optional arguments: "yearly" "growth"

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

Example 1

$historicalTTMdata Operating Cash Flow: aapl chart

Example with "yearly"

Example with "growth"

$historicalProportion Function

Gets the historical value of a metric

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

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

Example 1

$historicalProportion YouTube Ads/Revenue: googl chart

Example with "quarterly"

Example with "yearly"

$perShareComparison Function

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

Syntax: $perShareComparison <metric> ":" <ticker>

<Optional arguments: "TTM" "yearly" "difference">

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

Example 1

$perShareComparison Operating Cash Flow: googl chart

Example with "TTM"

Example with "yearly"

Example with "difference"

$historicalMetricPerShare Function

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

Syntax: $historicalMetricPerShare <metric> ":" <ticker> <optional arguments : "TTM" "yearly" "growth">

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

Example 1

$historicalMetricPerShare Book Value: aapl chart

Example with "TTM"

Example with "yearly"

Example with "growth"