Get Ratios

The Gist

• These functions can be used to get any financial ratios you want

• 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	Descriptions
$PEratio <tickers>	Gets the price to earnings ratio
$PSratio <tickers>	Gets the price to sales ratio
$PGPratio <tickers>	Gets the price to gross profit ratio
$POCF <tickers>	Gets the price to operating cash flow ratio
$PFCFratio <tickers>	Gets the price to free cash flow ratio
$PBratio <tickers>	Gets the price to book value
$ROE <tickers>	Gets the return on equity
$DEratio <tickers>	Gets the debt to equity ratio
$currentRatio <tickers>	Gets the current ratio
$sectorPE <exchange>	Gets the average price to earnings ratio by sector for a specific exchange
$proportion <numerator> "/" <denominator> ":" <tickers> <"quarterly" or leave blank>	Gets the numerator as a percent of the denominator
$ratio <numerator> "/" <denominator> ":" <tickers> <"quarterly" or leave blank>	Gets the numerator divided by the denominator

$PEratio Function

Gets the Price to earnings ratio, formula is (Market Cap / Net Income)

Syntax: $PEratio <ticker(s)>

Example 1

$PEratio sq tsla pins googl

$PSratio Function

Gets the Price to sales ratio, formula is (Market Cap / Revenue)

Syntax: $PSratio <ticker(s)>

Example 1

$PSratio ddog net crwd twlo

$PGPratio Function

Gets the Price to gross profit ratio, formula is (Market Cap / Gross Profit)

Syntax: $PGPratio <ticker(s)>

Example 1

$PGPratio sq tsla pins googl

$POCFratio Function

Gets the Price to operating cash flow ratio, formula is (Market Cap / Operating cash flow)

Syntax: $POCFratio <ticker(s)>

Example 1

$POCFratio sq tsla pins googl

$PFCFratio Function

Gets the Price to free cash flow ratio, formula is (Market Cap / Free cash flow)

Syntax: $PFCFratio <ticker(s)>

Example 1

$PFCFratio msft tsla pins googl

$PBratio Function

Gets the Price to book ratio, formula is (Market Cap / Equity)

Syntax: $PBratio <ticker(s)>

Example 1

$PBratio afcg ally dfs jpm gs

$ROE Function

Gets the return on equity, formula is (Net Income / Equity) * 100

Syntax: $ROE <ticker(s)>

Example 1

$ROE ally gs jpm

$DEratio Function

Gets the debt to equity ratio, formula is (Long term debt/ Equity)

Syntax: $DEratio <ticker(s)>

Example 1

$DEratio hd dis nke pypl

$currentRatio Function

Gets the current ratio, formula is (Current assets / Current Liabilities)

Syntax: $currentRatio <ticker(s)>

Example 1

$currentRatio aal mcd hd dis cost

$sectorPE Function

Gets the average price to earnings ratio by sector for a specific exchange

Syntax: $sectorPE <exchange>

Currently the only supported exchanges are NYSE and NASDAQ, you can use "ALL" as an exchange to get the average between both the NASDAQ and NYSE.

NYSE Example

$sectorPE nyse

Nasdaq example

$sectorPE nasdaq

"All" Example

$sectorPE all

$proportion Function

Gets the proportion of one metric to another

Syntax: $proportion <numerator> "/" <denominator> ":" <ticker(s)>

<Optional arguments: "quarterly">

Quarterly means that the proportion is calculated using data from the most recent quarter, otherwise the proportion is calculated based on the last 12 months.

Example 1

$proportion Dividends / Free Cash Flow: lmt mcd aapl

Example with "quarterly"

$proportion Dividends / Free Cash Flow: lmt mcd aapl quarterly

$ratio Function

Gets the ratio of one metric to another (gives data as a %)

Syntax: $ratio <numerator> "/" <denominator> ":" <ticker(s)>

<Optional arguments: "quarterly">

Quarterly means that the proportion is calculated using data from the most recent quarter, otherwise the proportion is calculated based on the last 12 months.

Example 1

$ratio Operating Cash Flow/ Net Income: lmt mcd aapl

Example with "quarterly"

$ratio Operating Cash Flow/ Net Income: lmt mcd aapl quarterly