CRSP-COMPUSTAT Data Item Quarterly

/ Uncategorized / By Overallmoney

CRSP/Compustat Quarterly Data – Industrial

Annual Data | Quarterly Data

The table below lists variables from the CRSP/Compustat data items Quarterly. ***Data Name* or XPF Name refers to the variable acronym or mnemonic and *Data Number*** refers to the FTP Name or Data Item Number.

Data Name	Data Number	XPF Label – Description
XSGAQ	1	Selling General and Administrative Expenses
SALEQ	2	Sales/Turnover (Net)
MIIQ	3	Minority Interest – Income Account
XRDQ	4	Research and Development Expense
DPQ	5	Depreciation and Amortization – Total
TXTQ	6	Income Taxes – Total
EPSFIQ	7	Earnings Per Share (Diluted) – Including Extraordinary Items
IBQ	8	Income Before Extraordinary Items
EPSFXQ	9	Earnings Per Share (Diluted) – Excluding Extraordinary items
IBADJQ	10	Income Before Extraordinary Items – Adjusted for Common Stock Equivalents
EPSPIQ	11	Earnings Per Share (Basic) – Including Extraordinary Items
PRCCQ	14	Price – Close – Quarter
CSHPRQ	15	Common Shares Used to Calculate Earnings Per Share – Basic
DVPSXM	16	Index Monthly Dividend
CSHTRQ	18	Common Shares Traded – Quarter
EPSPXQ	19	Earnings Per Share (Basic) – Excluding Extraordinary Items
DVRATE	20	Dividend Rate – Monthly
OIBDPQ	21	Operating Income Before Depreciation – Quarterly
XINTQ	22	Interest and Related Expense- Total
PIQ	23	Pretax Income
DVPQ	24	Dividends – Preferred/Preference
IBCOMQ	25	Income Before Extraordinary Items – Available for Common
XIDOQ	26	Extraordinary Items and Discontinued Operations
EPSX12	27	Earnings Per Share (Basic) – Excluding Extraordinary Items – 12 Months Moving
CSH12Q	28	Common Shares Used to Calculate Earnings Per Share – 12 Months Moving
TIIQ	29	Interest Income – Total (Financial Services)
COGSQ	30	Cost of Goods Sold
NOPIQ	31	Non-Operating Income (Expense) – Total
SPIQ	32	Special Items
DOQ	33	Discontinued Operations
FCAQ	34	Foreign Exchange Income (Loss)
TXDIQ	35	Income Taxes – Deferred
CHEQ	36	Cash and Short-Term Investments
RECTQ	37	Receivables – Total
INVTQ	38	Inventories – Total
ACOQ	39	Current Assets – Other – Total
ACTQ	40	Current Assets – Total
DPACTQ	41	Depreciation Depletion and Amortization (Accumulated)
PPENTQ	42	Property Plant and Equipment – Total (Net)
AOQ	43	Assets – Other
ATQ	44	Assets – Total
DLCQ	45	Debt in Current Liabilities
APQ	46	Account Payable/Creditors – Trade
TXPQ	47	Income Taxes Payable
LCOQ	48	Current Liabilities – Other – Total
LCTQ	49	Current Liabilities – Total
LOQ	50	Liabilities – Other
DLTTQ	51	Long-Term Debt – Total
TXDITCQ	52	Deferred Taxes and Investment Tax Credit
MIBQ	53	Minority Interest – Balance Sheet
LTQ	54	Liabilities – Total
PSTKQ	55	Preferred/Preference Stock (Capital) – Total
CSTKQ	56	Common/Ordinary Stock (Capital)
CAPSQ	57	Capital Surplus/Share Premium Reserve
REQ	58	Retained Earnings
CEQQ	59	Common/Ordinary Equity – Total
SEQQ	60	Shareholders Equity – Total
CSHOQ	61	Common Shares Outstanding
ICAPTQ	62	Invested Capital – Total – Quarterly
PRCHQ	65	Price – High – Quarter
PRCLQ	68	Price – Low – Quarter
NIQ	69	Net Income (Loss)
TIEQ	70	Interest Expense – Total (Financial Services)
PSTKRQ	71	Preferred/Preference Stock – Redeemable
DVPSPQ	72	Dividends per Share – Pay Date – Quarter
WCAPCY	73	Working Capital Change – Other – Increase/(Decrease)
CHECHY	74	Cash and Cash Equivalents – Increase (Decrease)
DLCCHY	75	Changes in Current Debt
IBCY	76	Income Before Extraordinary Items – Statement of Cash Flows
DPCY	77	Depreciation and Amortization – Statement of Cash Flows
XIDOCY	78	Extraordinary Items and Discontinued Operations (Statement of Cash Flows)
TXDCY	79	Deferred Taxes (Statement of Cash Flows)
ESUBCY	80	Equity in Net Loss/Earnings (C/F)
FOPOY	81	Funds from Operations – Other
FOPTY	82	Funds From Operations – Total
SPPEY	83	Sale of Property
SSTKY	84	Sale of Common and Preferred Stock
SIVY	85	Sale of Investments
DLTISY	86	Long-Term Debt – Issuance
FSRCOY	87	Sources of Funds – Other
FSRCTY	88	Sources of Funds – Total
DVY	89	Cash Dividends
CAPXY	90	Capital Expenditures
IVCHY	91	Increase in Investments
DLTRY	92	Long-Term Debt – Reduction
PRSTKCY	93	Purchase of Common and Preferred Stock
AQCY	94	Acquisitions
FUSEOY	95	Uses of Funds – Other
FUSETY	96	Uses of Funds – Total
NIITQ	97	Net Interest Income (Tax Equivalent)
TSTKQ	98	Treasury Stock – Total (All Capital)
NPATQ	99	Nonperforming Assets – Total
AJPQ	100	Adjustment Factor (Company) – Cumulative byPay-Date
WCAPCHY	101	Working Capital Changes – Total
SPPIVY	102	Sale of PPE and Investments – (Gain) Loss
RECCHY	103	Accounts Receivable – Decrease (Increase)
INVCHY	104	Inventory – Decrease (Increase)
APALCHY	105	Accounts Payable and Accrued Liabilities – Increase (Decrease)
TXACHY	106	Income Taxes – Accrued – Increase (Decrease)
AOLOCHY	107	Assets and Liabilities – Other (Net Change)
OANCFY	108	Operating Activities – Net Cash Flow
IVSTCHY	109	Short-Term Investments – Change
IVACOY	110	Investing Activities – Other
IVNCFY	111	Investing Activities – Net Cash Flow
FIAOY	112	Financing Activities – Other
FINCFY	113	Financing Activities – Net Cash Flow
EXREY	114	Exchange Rate Effect
INTPNY	115	Interest Paid – Net
TXPDY	116	Income Taxes Paid
ACCHGQ	117	Accounting Changes – Cumulative Effect
PPEGTQ	118	Property Plant and Equipment – Total (Gross) – Quarterly
XIQ	119	Extraordinary Items
CSTKEQ	120	Common Stock Equivalents – Dollar Savings
CURRTRQ	121	Currency Translation Rate
CSHFDQ	124	Com Shares for Diluted EPS
DILADQ	125	Dilution Adjustment
DILAVQ	126	Dilution Available – Excluding Extraordinary Items
PLLQ	171	Provision for Loan/Asset Losses
RLLQ	172	Reserve for Loan/Asset Losses
NIMQ	173	Net Interest Margin
CAPR1Q	174	Risk-Adjusted Capital Ratio – Tier 1
CAPRTQ	175	Risk-Adjusted Capital Ratio – Total – Quarterly
NCOQ	176	Net Charge-Offs
OPEPSQ	177	Earnings Per Share from Operations
OEPS12	178	Earnings Per Share from Operations – 12 Months Moving
EPSF12	179	Earnings Per Share (Diluted) – Excluding Extraordinary Items – 12 Months Moving
OEPF12	180	Earnings Per Share – Diluted – from Operations – 12MM
OEPSXQ	181	Earnings Per Share – Diluted – from Operations
IVLTQ	233	Total Long-term Investments
GDWLQ	234	Goodwill (net)
INTANOQ	235	Other Intangibles
ALTOQ	236	Other Long-term Assets
REUNAQ	237	Unadjusted Retained Earnings
ACOMINCQ	238	Accumulated Other Comprehensive Income (Loss)
DCOMQ	239	Deferred Compensation
SEQOQ	240	Other Stockholders Equity Adjustments
AQPQ	241	Acquisition/Merger Pretax
AQAQ	242	Acquisition/Merger After-Tax
AQEPSQ	243	Acquisition/Merger Basic EPS Effect
AQDQ	244	Acquisition/Merger Diluted EPS Effect
GLPQ	245	Gain/Loss Pretax
GLAQ	246	Gain/Loss After-Tax
GLEPSQ	247	Gain/Loss Basic EPS Effect
GLDQ	248	Gain/Loss Diluted EPS Effect
GDWLIPQ	249	Impairment of Goodwill Pretax
GDWLIAQ	250	Impairment of Goodwill After-tax
GDWLIEPSQ	251	Impairment of Goodwill Basic EPS Effect
GDWLIDQ	252	Impairment of Goodwill Diluted EPS Effect
SETPQ	253	Settlement (Litigation/Insurance) Pretax
SETAQ	254	Settlement (Litigation/Insurance) After-tax
SETEPSQ	255	Settlement (Litigation/Insurance) Basic EPS Effect
SETDQ	256	Settlement (Litigation/Insurance) Diluted EPS Effect
RCPQ	257	Restructuring Cost Pretax
RCAQ	258	Restructuring Cost After-tax
RCEPSQ	259	Restructuring Cost Basic EPS Effect
RCDQ	260	Restructuring Cost Diluted EPS Effect
WDPQ	261	Writedowns Pretax
WDAQ	262	Writedowns After-tax
WDEPSQ	263	Writedowns Basic EPS Effect
WDDQ	264	Writedowns Diluted EPS Effect
SPIOPQ	265	Other Special Items Pretax
SPIOAQ	266	Other Special Items After-tax
SPIEPSQ	267	Other Special Items Basic EPS Effect
SPIDQ	268	Other Special Items Diluted EPS Effect
DPACREQ	269	Accumulated Depreciation of RE Property
RETQ	270	Total RE Property
SRETQ	271	Gain/Loss on Sale of Property
DPRETQ	272	Depr/Amort of Property
ADRRQ	273	ADR Ratio
RDIPQ	274	In Process R+D
GDWLAMQ	275	Amortization of Goodwill
GDWLAMQ_FN1	276	Goodwill Amortization Footnote
CSHIQ	277	Common Shares Issued
STKCOQ	278	Stock Compensation Expense
TXBCOFY	279	Excess Tax Benefit of Stock Options – Cash Flow Financing

Go to the Top
Annual Data | Quarterly Data