ThinkValue.co: SEC Financial Data API
ThinkValue.co's SEC Financial Data API provides easy access to quarterly and trailing 12-month (TTM) financial data for U.S. publicly traded companies.
Get the list of all available tickers.
Note: stocks that aren't filing in U.S. GAAP will not return meaningful data.Getting Started
The API is simple to use. Use the base URL with a ticker symbol to get a JSON response with all available data. You can also export the data to a CSV file.
API Endpoints
Financial Data (JSON):
https://www.thinkvalue.co/api/financials/[ticker]
CSV Export:
https://www.thinkvalue.co/api/financials/[ticker]?format=csv
Examples
Use the following examples to get started quickly.
cURL Request
curl https://www.thinkvalue.co/api/financials/PINS
Link: https://www.thinkvalue.co/api/financials/PINS
You can also analyze the data directly in Google Sheets using our pre-built template: Google Sheets Template
API Key Conventions
All API keys follow a clear convention to help you quickly identify the data.
They are structured as
[period]_[statement]_[item_name].
| Prefix | Meaning | Example |
|---|---|---|
q |
Quarterly period | q_is_revenue |
ttm |
Trailing 12-Months (last 4 quarters) | ttm_is_revenue |
is |
Income Statement | q_is_revenue |
cf |
Cash Flow Statement | q_cf_operations |
bs |
Balance Sheet | q_bs_cash |
f |
Financial Ratios | ttm_f_roe |
Available Data Items
Below is a comprehensive list of all available financial data points.
Quarterly Data
Data points prefixed with q_ represent quarterly figures.
Metadata
| Key | Description |
|---|---|
end |
Data up to the quoted period ending date |
filed |
Date at which filing was made |
Income Statement
| Key | Description |
|---|---|
q_is_revenue |
Revenue, net sales |
q_is_cogs |
Cost of goods sold (C.O.G.S.) |
q_is_gross_profit |
Gross profit |
q_is_research_dev |
Research & development expenses (R&D) |
q_is_marketing |
Sales & marketing expenses |
q_is_admin |
General & administrative expenses |
q_is_sales_gen_admin |
Consolidated sales, marketing & general administrative expenses (SG&A) |
q_is_opex |
Operating expenses |
q_is_ebit |
Operating income (EBIT) |
q_is_nopat |
Net operating profit after tax |
q_is_interest_expense |
Gross interest expense |
q_is_interest_income |
Interest income from investments |
q_is_interest_expense_net |
Net interest expense |
q_is_pre_tax_income |
Pre-tax income |
q_is_tax |
Income tax expense |
q_is_tax_rate |
Income tax rate |
q_is_net_income |
Net income attributable to shareholders |
q_is_comprehensive_net_income |
Net income including unrealized gains/losses, pension liability changes, etc. |
q_is_gross_profit_margin |
Gross margin |
q_is_cogs_margin |
Cost of revenue margin |
q_is_ebit_margin |
EBIT margin |
q_is_net_margin |
Net margin |
Per Share Data
| Key | Description |
|---|---|
q_is_eps_basic |
Earnings Per Share (Basic) |
q_is_eps_diluted |
Earnings Per Share (Diluted) |
q_is_dividend_per_share |
Dividend declared per share |
q_is_shares_basic |
Number of basic common shares outstanding |
q_is_shares_diluted |
Number of diluted shares outstanding |
Cash Flow Statement
| Key | Description |
|---|---|
q_cf_operations |
Cash flows from operating activities |
q_cf_change_wc |
Change in non-cash working capital |
q_cf_depreciation |
Depreciation, amortization, and depletion |
q_cf_sbc |
Stock-based compensation (SBC) |
q_cf_investing |
Cash flows from investing |
q_cf_capex |
Consolidated capex, including PPE and cash acquisitions |
q_cf_acquisitions |
Acquisitions of businesses or intangibles |
q_cf_ppe_capex |
Capital expenditures for property, plant & equipment |
q_cf_financing |
Cash flows from financing activities |
q_cf_dividends |
Dividend payments |
q_cf_buybacks |
Common share repurchases |
q_cf_fcfe |
Free Cash Flow to Equity (FCFE) |
Balance Sheet
| Key | Description |
|---|---|
q_bs_deferred_revenue |
Revenue received in advance |
q_bs_cash |
Cash and equivalents |
q_bs_cash_marketable |
Cash + marketable securities |
q_bs_acc_receivable |
Accounts receivable |
q_bs_inventory |
Inventory |
q_bs_current_assets |
Current assets |
q_bs_total_assets |
Total assets |
q_bs_acc_payable |
Accounts payable |
q_bs_short_term_debt |
Debt maturing in ≤12 months |
q_bs_current_liabilities |
Current liabilities |
q_bs_long_term_debt |
Debt maturing in more than 12 months |
q_bs_total_debt |
Total debt |
q_bs_retained_earnings |
Retained earnings |
q_bs_total_liabilities_net |
Total liabilities net of equity |
q_bs_minority_interest |
Non-controlling (minority) interest |
q_bs_equity |
Book value of shareholder equity |
q_bs_total_liabilities_gross |
Total liabilities including equity |
Trailing 12-Month (TTM) Data
Data points prefixed with ttm_ represent trailing 12-month figures, which are a sum of the last four
quarters.
TTM Metrics
| Key | Description | Formula |
|---|---|---|
ttm_is_revenue |
Total revenue for the last 12 months | |
ttm_is_cogs |
Cost of goods sold | |
ttm_is_gross_profit |
Gross profit | |
ttm_is_opex |
Operating expenses | |
ttm_is_ebit |
EBIT | |
ttm_is_interest_expense |
Interest expense | |
ttm_is_pre_tax_income |
Pre-tax income | |
ttm_is_tax |
Tax expense | |
ttm_is_tax_rate |
Average tax rate | |
ttm_is_net_income |
Net income | |
ttm_is_nopat |
Net operating profit after tax | |
ttm_is_comprehensive_net_income |
Comprehensive net income | |
ttm_is_gross_margin |
Gross margin | gross profit / revenue |
ttm_is_ebit_margin |
EBIT margin | EBIT / revenue |
ttm_is_net_margin |
Net margin | net income / revenue |
ttm_is_eps_basic |
Basic EPS | |
ttm_is_eps_diluted |
Diluted EPS |
TTM Cash Flow Metrics
| Key | Description |
|---|---|
ttm_cf_operations |
Cash from operations |
ttm_cf_depreciation |
Depreciation & amortization |
ttm_cf_capex |
Capital expenditures |
ttm_cf_ppe_capex |
Capex for property, plant & equipment |
ttm_cf_acquisitions |
Cash for acquisitions |
ttm_cf_sbc |
Stock-based compensation |
ttm_cf_dividends |
Dividends paid |
ttm_cf_buybacks |
Share buybacks |
ttm_bs_net_change_debt |
Net change in total debt |
ttm_cf_fcfe |
Free Cash Flow to Equity |
Financial Ratios (TTM)
| Key | Description | Formula |
|---|---|---|
ttm_f_roe |
Return on Equity | Net Income / Current Equity |
ttm_f_roe_avg |
Return on Equity (Average) | Net Income / Avg Equity (4Q) |
ttm_f_roa |
Return on Assets | Net Income / Current Assets |
ttm_f_roa_avg |
Return on Assets (Average) | Net Income / Avg Assets (4Q) |
ttm_f_roic |
Return on Invested Capital | NOPAT / (Debt + Equity - Cash) |
ttm_f_sales_to_cap |
Sales to Capital Ratio | Revenue / (Debt + Equity - Cash) |
TTM Growth Metrics
| Key | Description |
|---|---|
ttm_is_rev_growth |
Year-over-Year revenue growth |
ttm_is_rev_growth_q |
Quarter-over-Quarter revenue growth |
ttm_is_cogs_growth |
Year-over-Year COGS growth |
ttm_is_gross_profit_growth |
Year-over-Year gross profit growth |
ttm_is_gross_profit_growth_q |
Quarter-over-Quarter gross profit growth |
ttm_is_ebit_growth |
Year-over-Year operating income growth |
ttm_is_ebit_growth_q |
Quarter-over-Quarter operating income growth |
ttm_is_net_income_growth |
Year-over-Year net income growth |
ttm_is_net_income_growth_q |
Quarter-over-Quarter net income growth |
ttm_is_eps_basic_growth |
Year-over-Year Basic EPS growth |
ttm_is_eps_diluted_growth |
Year-over-Year Diluted EPS growth |