financial

Summary

This dataset provides PIT (point-in-time) financial statements for US stocks, including various financial metrics and indicators. The data’s index indicates the date the data was included in the database.

Users can choose from 3 types of data frames by adjusting the ‘mode’ parameter:

1. Default behavior: In this case, the values in the data frame become the most recent values at the point in time, not including the fiscal date.

2. Original: In this case, the values in the data frame become dictionaries possibly including multiple keys and values. If you are considering pre-announced data revisions, this option can be a solution.

3. Unpivot: In this case, there will be 4 columns (‘id’, ‘pit’, ‘fiscal’, ‘value’). Each row contains information about the announced data’s announcing date, fiscal quarter, and value.

Since the collection of PIT data started recently, data before 2023-08-09, is the same as the research data, not the PIT data.

If you want to load quarterly period end cm,

This dataset provides 90 days delayed financial statements for US stocks, including various financial metrics and indicators.

Most US companies disclose their IR materials within 90 days after the end of the quarter, but for some that do not, there may be a look-ahead bias. Therefore, it is not recommended to use this data for modeling purposes, but rather for research purposes.

Example code

from finter.data import ContentFactory
cf = ContentFactory("us_stock", 20200101, 20200201)
df = cf.get_df("pit-atq") # pit cm
df = cf.get_df("atq") # period end cm

Metadata

valid from
delivery schedule
time zone
data frequency

1982-01-31

30 5 * * 2-6

US/Eastern

1d

Item List

Balance Sheet

Current Assets

  • accoq: Quarterly liquid assets of U.S. stocks

  • actq: Quarterly total current assets of U.S. stocks

  • apoq: Prepaid expenses and other current assets of U.S. stocks

  • caq: Current assets of U.S. stocks

  • cheq: Cash and cash equivalents of U.S. stocks

  • chq: Cash items of U.S. stocks

  • chsq: Short-term investment items in U.S. stocks

  • csh12q: Quarterly data on cash and cash equivalents for U.S. stocks over the past 12 months

  • cshiq: Quarterly data on cash and short-term investments in U.S. stocks

  • cibegniq: Basic inventory items of U.S. stocks

  • cicurrq: Current inventory items of U.S. stocks

  • capcstq: Capitalized software cost items of U.S. stocks

  • capsftq: Capitalized software costs for U.S. stocks

  • aul3q: Unused credit limit items of U.S. stocks

  • autxrq: Tax refund items for U.S. stocks related to automobiles

  • artfsq: Accounts receivable financial items of U.S. stocks

  • acchgq: Quarterly changes in accounts receivable for U.S. stocks

Non-Current Assets

  • adpacq: Quarterly accumulated depreciation of U.S. stocks

  • anoq: Quarterly non-operating assets of U.S. stocks

  • aoq: Other asset items of U.S. stocks

  • aotq: Total asset items of U.S. stocks

  • atq: Total asset items of U.S. stocks

  • dfpacq: Quarterly data on the acquisition costs of deferred policy for U.S. stocks

  • aqpl1q: Acquisition of Preferred Stocks in U.S. Stocks

  • deracq: Quarterly data on derivative assets of U.S. stocks

  • ivaoq: Other investments in U.S. stocks

  • ivltq: Long-term investment in U.S. stocks

  • gdwlq: Quarterly goodwill of U.S. stocks

  • intanq: Total intangible assets of U.S. stocks

Current Liabilities

  • acoq: Quarterly current liabilities of U.S. stocks

  • acoxq: Quarterly current liabilities and other debts of U.S. stocks

  • apq: Accounts payable for U.S. stocks

  • cltq: Quarterly data on total current liabilities of U.S. stocks

  • dlcq: Quarterly data on current liabilities of U.S. stocks

  • dd1q: Quarterly data on liquidity among long-term liabilities of U.S. stocks

  • pclq: Current liabilities of U.S. stocks

  • ulcoq: Current liabilities of U.S. stocks

Non-Current Liabilities

  • aol2q: Other liabilities (non-current) of U.S. stocks

  • derhedglq: Quarterly data on hedge derivatives liabilities of U.S. stocks

  • derlcq: Quarterly data on liquid derivative liabilities of U.S. stocks

  • derlltq: Quarterly data on long-term derivative liabilities of U.S. stocks

  • dlttq: Quarterly data on the total long-term debt of U.S. stocks

  • rllq: Quarterly long-term debt of U.S. stocks

  • pllq: Long-term debt of U.S. stocks

  • ltq: Total long-term debt of U.S. stocks

Shareholders’ Equity

  • ceqq: Common stock capital item of U.S. stocks

  • cstkq: Quarterly data of common stocks in the United States

  • cshprq: Quarterly data of preferred stocks in the United States

  • pstkq: Quarterly preferred stock capital of U.S. stocks

  • seqq: Quarterly shareholder equity of U.S. stocks

  • lseq: Shareholder equity of U.S. stocks

  • ucapsq: Capital surplus of U.S. stocks

Accumulated Other Comprehensive Income

  • acomincq: Quarterly cumulative other comprehensive income of U.S. stocks

  • aociderglq: Other comprehensive income items related to deferred corporate tax liabilities of U.S. stocks

  • aociotherq: Other items in the other comprehensive income of U.S. stocks

  • aocipenq: Other comprehensive income items related to pensions for U.S. stocks

  • aocisecglq: Other comprehensive income items related to securities of U.S. stocks

  • ciotherq: Other comprehensive income items of U.S. stocks

Other Balance Sheet Items

  • ancq: Quarterly net current assets of U.S. stocks

  • aqaq: Acquisition asset items of U.S. stocks

  • aqdq: Acquisition debt items of U.S. stocks

  • aqpq: Acquisition cost item of U.S. stocks

  • dpactq: Quarterly data on the total accumulated depreciation of U.S. stocks

  • glaq: Quarterly total assets of U.S. stocks

  • gldq: Quarterly total liabilities of U.S. stocks

  • glpq: Total debt and preferred equity of U.S. stocks

  • lsq: Total liabilities and shareholders' equity of U.S. stocks

Income Statement

Revenue

  • istq: Total revenue of U.S. stocks

  • saleq: Quarterly revenue of U.S. stocks

  • salq: Quarterly revenue of U.S. stocks (alternative)

  • prcq: Quarterly revenue of U.S. stocks

  • revtq: Quarterly total revenue of U.S. stocks

  • xsq: Quarterly revenue of U.S. stocks

Cost of Goods Sold & Operating Expenses

  • cogsq: Quarterly data on the cost of goods sold for U.S. stocks

  • prcpq: Quarterly cost of goods sold for U.S. stocks

  • rectoq: Quarterly total operating expenses of U.S. stocks

  • finxoprq: Quarterly financial accounts of U.S. stocks - Operating expenses

  • iobdq: Other operating and administrative expenses of U.S. stocks

  • isgtq: Selling, general and administrative expenses of U.S. stocks

  • xcomq: Quarterly selling and administrative expenses of U.S. stocks

  • xsg aq: Quarterly selling and administrative expenses of U.S. stocks

  • ssnpq: Selling and general administrative expenses of U.S. stocks

  • msa q: Selling and administrative expenses of U.S. stocks

  • saaq: Quarterly selling and administrative expenses of U.S. stocks

  • scq: Quarterly Selling Expenses of U.S. Stocks (Alternative)

  • scoq: Quarterly selling expenses of U.S. stocks

  • sctq: Quarterly total selling expenses of U.S. stocks

Operating Income

  • arcedq: Quarterly operating income items of U.S. stocks

  • arceq: Current earnings item of U.S. stocks

  • oproq: Operating profit of U.S. stocks

  • xoiq: Quarterly operating profit of U.S. stocks

  • xoprq: Quarterly operating profit of U.S. stocks

  • xoptq: Quarterly operating profit of U.S. stocks

  • spiopq: Operating profit of U.S. stocks

Non-Operating Income and Expenses

  • ioiq: Non-operating income (expenses) of U.S. stocks

  • nopioq: Non-operating income and expenses of U.S. stocks

  • nopiq: Non-operating income from U.S. stocks

  • ioreq: Other operating income from U.S. stocks

  • xoreq: Quarterly non-operating income from U.S. stocks

  • xobdq: Quarterly non-operating expenses of U.S. stocks

Earnings Before Tax (EBT) and Net Income

  • ibq: Quarterly basic earnings of U.S. stocks

  • ibmiiq: Net income before minority interest deductions for U.S. stocks

  • niq: Net income of U.S. stocks

  • npq: Net income of U.S. stocks

  • pncpq: Quarterly net income of U.S. stocks

  • pncq: Quarterly net income of U.S. stocks

  • xiq: Quarterly net income of U.S. stocks

  • nitq: Net income after corporate tax deduction for U.S. stocks

  • esubq: Quarterly special items and net income before discontinued operations of U.S. stocks

Depreciation, Amortization, and Related

  • dpq: Quarterly data on depreciation and amortization of U.S. stocks

  • amq: Quarterly amortization expenses of U.S. stocks

  • wddq: Quarterly depreciation expense of U.S. stocks

  • wdpq: Quarterly depreciation expense of U.S. stocks

  • rrdq: Quarterly depreciation expense of U.S. stocks

  • xagtq: Quarterly amortization of intangible assets for U.S. stocks

  • wdaq: Quarterly depreciation and amortization before working capital for U.S. stocks

  • wdepsq: Quarterly depreciation and amortization expenses of U.S. stocks

  • oiadpq: Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) of U.S. Stocks

  • oibdpq: Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) of U.S. Stocks

Interest & Taxes

  • intcq: Interest expense of U.S. stocks

  • spidq: Interest and related costs of U.S. stocks

  • xintq: Quarterly interest expenses of U.S. stocks

  • finxintq: Quarterly financial accounts of U.S. stocks - Interest expenses

  • tieq: Total interest expense of U.S. stocks

  • txpq: Corporate tax payment on U.S. stocks

  • txtq: Total corporate tax on U.S. stocks

  • iptiq: Corporate tax reserves for U.S. stocks

Special Items & Adjustments

  • spiq: Special items of U.S. stocks

  • xioq: Quarterly special items of U.S. stocks

  • uspiq: Quarterly special items of U.S. stocks

  • spcedq: Quarterly special items of U.S. stocks (diluted)

  • spcedpq: Quarterly special items of U.S. stocks (diluted, per share)

Cashflow

Operating Cashflow

  • cfoq: Cash flow items resulting from operating activities of U.S. stocks

  • cshopq: Quarterly data on cash flows from operating activities of U.S. stocks

  • ffoq: Cash flow from operating activities for U.S. stocks on a quarterly basis

  • spioaq: Interest payments resulting from the operating activities of U.S. stocks

Investing Cashflow

  • capr1q: Capital expenditures for U.S. stocks in the first quarter

  • capr2q: Capital expenditures for U.S. stocks in the second quarter

  • capr3q: Capital expenditures of U.S. stocks for the third quarter

  • caprtq: Total capital expenditures for U.S. stocks

  • rcpq: Quarterly capital expenditures of U.S. stocks

  • spcepq: Capital expenditures per share of U.S. stocks

  • spceq: Capital expenditures of U.S. stocks

Financing Cashflow

  • cfbdq: Cash inflow item due to the issuance of bonds in U.S. stocks

  • cfereq: Cash outflow items due to stock buybacks of U.S. stocks

  • cfpdoq: Cash outflow item due to the payment of preferred stock dividends in U.S. stocks

  • udvpq: Dividend payments of U.S. stocks

  • updvpq: Quarterly dividend payments of U.S. stocks

  • dvpq: Quarterly data on dividend payments of U.S. stocks

  • dvpdpq: Quarterly data on preferred stock dividends of U.S. stocks

  • dvrreq: Quarterly data on dividend reinvestment of U.S. stocks

  • rrpq: Quarterly share repurchase amount of U.S. stocks

Other / Summary Cashflow

  • cshfdq: Quarterly cash flow data of U.S. stocks

  • cshfd12: Quarterly data of 12-month cash flow for U.S. stocks

Ratio

Profitability & Efficiency Ratios

  • eroq: Quarterly operating profit margin of U.S. stocks

  • xoproq: Quarterly operating profit margin of U.S. stocks

  • ratiq: Quarterly operating income ratio compared to interest expenses of U.S. stocks

Return Ratios

  • eqrtq: Quarterly Return on Equity of U.S. Stocks

Capital Structure Ratios

  • setaq: Quarterly shareholder equity to total assets ratio of U.S. stocks

  • seta12: Annual shareholder equity to total assets ratio of U.S. stocks

  • setdq: Quarterly shareholder equity to debt ratio of U.S. stocks

  • setd12: Annual shareholder equity to debt ratio of U.S. stocks

  • setpq: Quarterly shareholder equity to price ratio of U.S. stocks

Note

  • We provide Financial CM converted into USD. According to Compustat’s policy, balance sheet items are converted using a 12-month exchange rate, while income statement and cash flow items are converted using the monthly exchange rate.

  • Unit : 1 million

PreviousfundflowNextmarket

Last updated