Get User Data

The Gist

• For the user, userGrowth, metricPerUser, and metricPerUserCAGR, you can use the word "all" to request the data for all tickers that have available user data

• 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
$users <ticker(s)>	Get the number of users for a company as of the most recent quarter
$userGrowth <ticker(s)>	Get the year over year growth for a company's users
$usersAdded <ticker(s)>	See how many users a company gained in the most recent quarter
$metricPerUser <metric> ":" <ticker(s)> <Optional arguments: "quarterly">	Get the value of a metric relative to the number of users a company has
$metricPerUserCAGR <# of years> "year"<metric> ":" <ticker(s)> <Optional arguments: "quarterly">	Get the compound annual growth rate of a metric given a number of years, metric, and ticker(s)
$historicalMetricPerUser <metric> ":" <ticker> <Optional arguments: "TTM" "yearly" "growth">	Get the historical value of a metric per user for a company

$users Function

The users function gets the number of users a company has as of the most recent quarter

Syntax: $users <tickers>

Hint: You can just use the word "all" instead of typing tickers to get all available user data

Example with tickers

$users coin snap nflx dis roku abnb

Example with "all"

$users all

$usersAdded Function

The users function gets the number of users a company added in the most recent quarter

Syntax: $usersAdded <tickers>

Hint: You can just use the word "all" instead of typing tickers to get all available user data

Example with tickers

$usersAdded dis fb snap uber nflx roku coi

Example with "all"

$usersAdded all

$userGrowth Function

This function gets the year over year growth of a company's users

Syntax: $userGrowth <tickers>

Hint: You can just use the word "all" instead of typing stock tickers to get all available user growth data

Example with tickers

$userGrowth sq snap twtr fb abnb coin sklz pins

Example with "all"

$userGrowth all

$metricPerUser Function

This function gets a metric per user for a company

Syntax: $metricPerUser <metric> ":" <tickers> <Optional arguments: "quarterly"

Quarterly is used to get the value of a metric per user only from the most recent quarter versus from the last 12 months

Hint: You can just use the word "all" instead of typing stock tickers to get all available user growth data

Example with tickers

$metricPerUser Revenue: snap lmnd fb baba

Example with "quarterly"

$metricPerUser Revenue: snap lmnd fb baba quarterly

Example with "all"

$metricPerUser Revenue: all

$metricPerUserCAGR Function

This function gets the compound annual growth rate for the value of a metric per user

Syntax: $metricPerUserCAGR <# of years> "years" <metric> ":" <tickers>

<Optional Arguments: "quarterly">

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

Hint: You can just use the word "all" instead of typing stock tickers to get all available user growth data

Example with tickers

$metricPerUserCAGR 3 year Gross Profit: fb nflx

Example with "quarterly"

$metricPerUserCAGR Gross Profit: fb nflx quarterly

Example with "all"

$metricPerUserCAGR 3 year Gross Profit: all

$historicalMetricPerUser Function

This function gets the historical value of a metric per user for a company

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

<Optional Arguments: "TTM" "yearly" "growth">

All Optional arguments can be used together

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

Yearly means that the data shown will be spread 4 quarters apart

Growth means that the year over year growth for a metric per user is shown

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

Simple Example

$historicalMetricPerUser Revenue: snap chart

This is the output you will get if you type the above command

Example with "TTM"

$historicalMetricPerUser Revenue: snap TTM chart

Example with "yearly"

$historicalMetricPerUser Revenue: snap yearly chart

Example with "growth"

$historicalMetricPerUser Revenue: snap growth chart

Example with a combination

$historicalMetricPerUser Revenue: snap TTM yearly growth chart