楼主: Whatsappp
163 6

[经管数据集] 美国上市公司常用财务指标1950-2022年Compustat 数据库整理 981个变量 6G [推广有奖]

院士

44%

还不是VIP/贵宾

-

威望
1
论坛币
127153 个
通用积分
1846.8748
学术水平
683 点
热心指数
655 点
信用等级
638 点
经验
116961 点
帖子
3122
精华
0
在线时间
2895 小时
注册时间
2018-3-30
最后登录
2024-4-27

初级热心勋章 初级信用勋章 中级热心勋章

楼主
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:15:04 |只看作者 |坛友微信交流群|倒序 |AI写论文
相似文件 换一批

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
美国上市公司常用财务指标1950-2022年

包含指标


变量名变量标签
gvkeyGlobal Company Key
datadateData Date
yearData Year - Fiscal
indfmtIndustry Format
consolLevel of Consolidation - Company Annual Descriptor
popsrcPopulation Source
datafmtData Format
ticTicker Symbol
cusipCUSIP
conmCompany Name
acctchgAdoption of Accounting Changes
acctstdAccounting Standard
acqmethAcquisition Method
adrrADR Ratio
ajexAdjustment Factor (Company) - Cumulative by Ex-Date
ajpAdjustment Factor (Company) - Cumulative byPay-Date
bsprBalance Sheet Presentation
compstComparability Status
curcdISO Currency Code
curncdNative Currency Code
currtrCurrency Translation Rate
curuscnUS Canadian Translation Rate
finalFinal Indicator Flag
fyrFiscal Year-end Month
ismodIncome Statement Model Number
ltcmLong Term Contract Method
ogmOIL & GAS METHOD
pddurPeriod Duration
scfCash Flow Format
srcSource Document
staltStatus Alert
udplUtility - Liberalized Depreciation Code
updUpdate Code
apdedateActual Period End date
fdateFinal Date
pdatePreliminary Date
acchgAccounting Changes - Cumulative Effect
accoAcceptances Outstanding
accrtARO Accretion Expense
acdoCurrent Assets of Discontinued Operations
acoCurrent Assets - Other - Total
acodoOther Current Assets Excl Discontinued Operations
acomincAccumulated Other Comprehensive Income (Loss)
acoxCurrent Assets - Other - Sundry
acoxarCurrent Assets - Other - Total As Reported
acqaoAcquired Assets > Other Long-Term Assets
acqcshiShares Issued for Acquisition
acqgdwlAcquired Assets - Goodwill
acqicAcquisitions - Current Income Contribution
acqintanAcquired Assets - Intangibles
acqinvtAcquired Assets - Inventory
acqlntalAcquired Loans
acqniintcNet Interest Income Contribution
acqppeAcquired Assets > Property, Plant & Equipment


1950-2022年 样本量500w+

美国上市公司常用财务指标1950-2022年 Compustat 数据库整理 (76 Bytes, 需要: RMB 99 元)
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:compustat 美国上市公司 上市公司 美国上市 财务指标

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html
沙发
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:15:40 |只看作者 |坛友微信交流群
指标续:
变量名变量标签
acqscAcquisitions - Current Sales Contribution
actCurrent Assets - Total
adpacAmortization of Deferred Policy Acquisition Costs
aediAccrued Expenses and Deferred Income
afudccAllowance for Funds Used During Construction (Cash Flow)
afudciAllowance for Funds Used During Construction (Investing) (Cash Flow)
aldoLong-term Assets of Discontinued Operations
amAmortization of Intangibles
amcAmortization (Cash Flow) - Utility
amdcAmortization of Deferred Charges
amgwAmortization of Goodwill
anoAssets Netting & Other Adjustments
aoAssets - Other
aociderglAccum Other Comp Inc - Derivatives Unrealized Gain/Loss
aociotherAccum Other Comp Inc - Other Adjustments
aocipenAccum Other Comp Inc - Min Pension Liab Adj
aocisecglAccum Other Comp Inc - Unreal G/L Ret Int in Sec Assets
aodoOther Assets excluding Discontinued Operations
aol2Assets Level2 (Observable)
aolochAssets and Liabilities - Other - Net Change
aoxAssets - Other - Sundry
apAccounts Payable - Trade
apalchAccounts Payable and Accrued Liabilities - Increase/(Decrease)
apbAccounts Payable/Creditors - Brokers, Dealers, and Clearing Organizations
apcAccounts Payable/Creditors - Customer
apofsAccounts Payable/Creditors - Other - FS
aqaAcquisition/Merger After-tax
aqcAcquisitions
aqdAcquisition/Merger Diluted EPS Effect
aqepsAcquisition/Merger Basic EPS Effect
aqiAcquisitions - Income Contribution
aqpAcquisition/Merger Pretax
aqpl1Assets Level1 (Quoted Prices)
aqsAcquisitions - Sales Contribution
arbAccounts Receivable/Debtors - Brokers, Dealers, and Clearing  Organizations
arcAccounts Receivable/Debtors - Customer
arceAs Reported Core - After-tax
arcedAs Reported Core - Diluted EPS Effect
arceepsAs Reported Core - Basic EPS Effect
artfsAccounts Receivable/Debtors - Total
atAssets - Total
aul3Assets Level3 (Unobservable)
autxrAppropriations to Untaxed Reserves
balrBenefits Assumed - Life
banlrBenefits Assumed - Nonlife
bastAverage Short-Term Borrowings
bastrAverage Short-Term Borrowings Rate
batrBenefits Assumed - Total
bcefBrokerage, Clearing and Exchange Fees
bclrBenefits Ceded - Life
bcltblBenefits and Claims - Total (Business Line)
bcnlrBenefits Ceded - Nonlife
bcrblBenefits and Claims - Reinsurance (Business Line)
bctBenefits and Claims - Total (Insurance)
bctblBenefits and Claims - Other (Business Line)
bctrBenefits Ceded - Total
billexceBillings in Excess of Cost & Earnings
bkvlpsBook Value Per Share
bltblBenefits - Life - Total (Business Line)
caCustomers'' Acceptance
capr1Risk-Adjusted Capital Ratio - Tier 1
capr2Risk-Adjusted Capital Ratio - Tier 2
capr3Risk-Adjusted Capital Ratio - Combined
capsCapital Surplus/Share Premium Reserve
capsftCapitalized Software
capxCapital Expenditures
capxvCapital Expend Property, Plant and Equipment Schd V
cbCompensating Balance
cbiClaims Incurred - Insurance
cdpacCapitalized Deferred Polcy Acquisition Costs
cdvcCash Dividends on Common Stock (Cash Flow)
ceiexbillCost & Earnings in Excess of Billings
ceqCommon/Ordinary Equity - Total
ceqlCommon Equity - Liquidation Value
ceqtCommon Equity - Tangible
cfbdCommissions and Fees - (Broker/Dealer)
cfereCommissions and Fees - (Real Estate)
cfoCommissions and Fees - Other
cfpdoCommissions and Fees Paid - Other
cgaCapital Gains - After-Tax
cgriCapital Gains - Realized (Insurance)
cgtiCapital Gains - Total (Insurance)
cguiCapital Gains - Unrealized (Insurance)
chCash
cheCash and Short-Term Investments
chechCash and Cash Equivalents - Increase/(Decrease)
chsCash and Deposits - Segregated
ciComprehensive Income - Total
cibegniComp Inc - Beginning Net Income
cicurrComp Inc - Currency Trans Adj
ciderglComp Inc - Derivative Gains/Losses
cimiiComprehensive Income - Noncontrolling Interest
ciotherComp Inc - Other Adj
cipenComp Inc - Minimum Pension Adj
cisecglComp Inc - Securities Gains/Losses
citotalComprehensive Income - Parent
cld2Capitalized Leases - Due in 2nd Year
cld3Capitalized Leases - Due in 3rd Year
cld4Capitalized Leases - Due in 4th Year
cld5Capitalized Leases - Due in 5th Year
clfcContingent Liabilities - Forward and Future Contracts
clfxContingent Liabilities - Foreign Exchange Commitments
clgContingent Liabilities - Guarantees
clisContingent Liabilities - Interest Rate Swaps
cllContingent Liabilities - Letters of Credit
cllcContingent Liabilities - Loan Commitments
cloContingent Liabilities - Other
clrllCredit Loss Reserve Allocated for LDC Loans
cltContingent Liabilities - Total
cmpCommercial Paper
cnltblClaims - Non-Life - Total (Business Line)
cogsCost of Goods Sold
cpcblCommercial Property and Casualty Claims (Business Line)
cpdoiClaims Paid - Other
cpnliClaims Paid - Non-Life
cppblCommercial Property and Casualty Premiums (Business Line)
cpreiClaims Paid - Reinsurance
crvConsolidation Reserves
crvnliReserves for Claims (Losses) - Nonlife (Insurance)
cshfdCommon Shares Used to Calc Earnings Per Share - Fully Diluted
cshiCommon Shares Issued
cshoCommon Shares Outstanding
cshpriCommon Shares Used to Calculate Earnings Per Share - Basic
cshrCommon/Ordinary Shareholders
cshrcCommon Shares Reserved for Conversion - Convertible Debt
cshrpCommon Shares Reserved for Conversion - Preferred Stock
cshrsoCommon Shares Reserved for Conversion - Stock Options
cshrtCommon Shares Reserved for Conversion - Total
cshrwCommon Shares Reserved for Conversion - Warrants and Other
cstkCommon/Ordinary Stock (Capital)
cstkcvCommon Stock-Carrying Value
cstkeCommon Stock Equivalents - Dollar Savings
dbiDeath Benefits - Insurance
dcDeferred Charges
dcloDebt - Capitalized Lease Obligations
dcomDeferred Compensation
dcpstkConvertible Debt and Preferred Stock
dcsDebt - Consolidated Subsidiary
dcvsrDebt - Senior Convertible
dcvsubDebt - Subordinated Convertible
dcvtDebt - Convertible
ddDebt - Debentures
dd1Long-Term Debt Due in One Year
dd2Debt - Due in 2nd Year
dd3Debt - Due in 3rd Year
dd4Debt - Due in 4th Year
dd5Debt - Due in 5th Year
depcDepreciation and Depletion (Cash Flow)
deracDerivative Assets - Current
deraltDerivative Assets Long-Term
derhedglGains/Losses on Derivatives and Hedging
derlcDerivative Liabilities- Current
derlltDerivative Liabilities Long-Term
dfpacDeferred Policy Acquisition Costs
dfsDebt - Finance Subsidiary
dfxaDepreciation of Tangible Fixed Assets
diladjDilution Adjustment
dilavxDilution Available - Excluding Extraordinary Items
dlcDebt in Current Liabilities - Total
dlcchCurrent Debt - Changes
dltisLong-Term Debt - Issuance
dltoOther Long-term Debt
dltpLong-Term Debt - Tied to Prime
dltrLong-Term Debt - Reduction
dltsubLong-Term Debt - Subordinated
dlttLong-Term Debt - Total
dmDebt - Mortgages & Other Secured
dnDebt - Notes
doDiscontinued Operations
donrNonrecurring Disc Operations
dpDepreciation and Amortization
dpacbDepreciation (Accumulated) - Buildings
dpaccDepreciation (Accumulated) - Construction in Progress
dpacliDepreciation (Accumulated) - Land and Improvements
dpaclsDepreciation (Accumulated) - Leases
dpacmeDepreciation (Accumulated) - Machinery and Equipment
dpacnrDepreciation (Accumulated) - Natural Resources
dpacoDepreciation (Accumulated) - Other
dpacreAccumulated Depreciation of RE Property
dpactDepreciation, Depletion and Amortization (Accumulated)
dpcDepreciation and Amortization (Cash Flow)
dpdcDeposits - Demand - Customer
dpltbDeposits - Long-Term Time - Bank
dpretDepr/Amort of Property
dpscDeposits - Savings - Customer
dpstbDeposits - Short-Term Demand - Bank
dptbDeposits - Total - Banks
dptcDeposits - Total - Customer
dpticDeposits - Time - Customer
dpviebDepreciation (Accumulated) - Ending Balance (Schedule VI)
dpvioDepreciation (Accumulated) - Other Changes (Schedule VI)
dpvirDepreciation (Accumulated) - Retirements (Schedule VI)
drcDeferred Revenue - Current
drciDeduction From Policy and Claims Reserves for Reinsurance Ceded
drltDeferred Revenue - Long-term
dsDebt-Subordinated

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html

使用道具

藤椅
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:16:26 |只看作者 |坛友微信交流群
指标续:
变量名变量标签
dtTotal Debt Including Current
dteaExtinguishment of Debt After-tax
dtedExtinguishment of Debt Diluted EPS Effect
dteepsExtinguishment of Debt Basic EPS Effect
dtepExtinguishment of Debt Pretax
duddDebt - Unamortized Debt Discount and Other
dvCash Dividends (Cash Flow)
dvcDividends Common/Ordinary
dvdnpDividends Declared and Not Provided
dvintfDividends & Interest Receivable (Cash Flow)
dvpDividends - Preferred/Preference
dvpaPreferred Dividends in Arrears
dvpdCash Dividends Paid
dvpdpDividends and Bonuses Paid Policyholders
dvpibbDepreciation (Accumulated) - Beginning Balance (Schedule VI)
dvrpivDividends Received from Permanent Investments
dvrreDevelopment Revenue (Real Estate)
dvscoDividends - Share Capital - Other
dvtDividends - Total
dxd2Debt (excl Capitalized Leases) - Due in 2nd Year
dxd3Debt (excl Capitalized Leases) - Due in 3rd Year
dxd4Debt (excl Capitalized Leases) - Due in 4th Year
dxd5Debt (excl Capitalized Leases) - Due in 5th Year
eaExchange Adjustments (Assets)
ebitEarnings Before Interest and Taxes
ebitdaEarnings Before Interest
eieaEquity in Earnings - After-Tax
emolDirectors'' Emoluments
empEmployees
epsfiEarnings Per Share (Diluted) - Including Extraordinary Items
epsfxEarnings Per Share (Diluted) - Excluding Extraordinary Items
epspiEarnings Per Share (Basic) - Including Extraordinary Items
epspxEarnings Per Share (Basic) - Excluding Extraordinary Items
esopctCommon ESOP Obligation - Total
esopdltESOP Debt - Long Term
esopnrPreferred ESOP Obligation - Non-Redeemable
esoprPreferred ESOP Obligation - Redeemable
esoptPreferred ESOP Obligation - Total
esubEquity in Earnings - Unconsolidated Subsidiaries
esubcEquity in Net Loss - Earnings
excadjExchange Adjustments (Liabilities)
exreExchange Rate Effect
fatbProperty, Plant, and Equipment - Buildings at Cost
fatcProperty, Plant, and Equipment - Construction in Progress at Cost
fatdFixed Assets and Investments - Disposals - Gain (Loss)
fateProperty, Plant, and Equipment - Machinery and Equipment at Cost
fatlProperty, Plant, and Equipment - Leases at Cost
fatnProperty, Plant, and Equipment - Natural Resources at Cost
fatoProperty, Plant, and Equipment - Other at Cost
fatpProperty, Plant, and Equipment - Land and Improvements at Cost
fcaForeign Exchange Income (Loss)
fdfrFederal Funds Purchased
feaForeign Exchange Assets
felForeign Exchange Liabilities
ffoFunds From Operations (REIT)
ffsFederal Funds Sold
fiaoFinancing Activities - Other
finacoFinance Division Other Current Assets, Total
finaoFinance Division Other Long-Term Assets, Total
fincfFinancing Activities - Net Cash Flow
finchFinance Division - Cash
findlcFinance Division Long-Term Debt   Current
findltFinance Division Debt  Long-Term
finivstFinance Division  Short-Term  Investments
finlcoFinance Division Other Current Liabilities, Total
finltoFinance Division Other Long Term Liabilities, Total
finnpFinance Division Notes Payable
finreccFinance Division  Current  Receivables
finrecltFinance Division  Long-Term  Receivables
finrevFinance Division Revenue
finxintFinance Division Interest Expense
finxoprFinance Division Operating Expense
fopoFunds from Operations - Other
fopoxFunds from Operations - Other excluding Option Tax Benefit
foptFunds From Operations - Total
fsrcoSources of Funds - Other
fsrctSources of Funds - Total
fuseoUses of Funds - Other
fusetUses of Funds - Total
gbblGroup Benefits (Business Line)
gdwlGoodwill
gdwlamGoodwill Amortization
gdwliaImpairments of Goodwill After-tax
gdwlidImpairments of Goodwill Diluted EPS Effect
gdwliepsImpairments of Goodwill Basic EPS Effect
gdwlipImpairments of Goodwill Pretax
geqrvGrants - Equity Reserves
glaGain/Loss After-tax
glceaGain/Loss on Sale (Core Earnings Adjusted) After-tax
glcedGain/Loss on Sale (Core Earnings Adjusted) Diluted EPS
glceepsGain/Loss on Sale (Core Earnings Adjusted) Basic EPS Effect
glcepGain/Loss on Sale (Core Earnings Adjusted) Pretax
gldGain/Loss Diluted EPS Effect
glepsGain/Loss Basic EPS Effect
glivGains/Losses on investments
glpGain/Loss Pretax
govgrGovernment Grants
govtownPercent of Gov''t Owned
gpGross Profit (Loss)
gphblGroup Premiums - Health (Business Line)
gplblGroup Premiums - Life (Business Line)
gpoblGroup Premiums - Other (Business Line)
gprblGroup Premiums - Retirement Benefits (Business Line)
gptblGroup Premiums - Total (Business Line)
gwoGoodwill Written Off
hedgeglGain/Loss on Ineffective Hedges
iaeqInvestment Assets - Equity Securities (Insurance)
iaeqciInvestment Assets (Insurance) - Equity Securities (Cost)
iaeqmiInvestment Assets (Insurance) - Equity Securities (Market)
iaficiInvestment Assets (Insurance) - Fixed Income Securities (Cost)
iafxiInvestment Assets - Fixed Income Securities (Insurance)
iafxmiInvestment Assets (Insurance) - Fixed Income Securities (Market)
ialiInvestment Assets (Insurance) - Listed Securities-Total
ialoiInvestment Assets - Loans - Other (Insurance)
ialtiInvestment Assets - Loans - Total (Insurance)
iamliInvestment Assets - Mortgage Loans (Insurance)
iaoiInvestment Assets - Other (Insurance)
iapliInvestment Assets - Policy Loans (Insurance)
iareiInvestment Assets - Real Estate (Insurance)
iasciInvestment Assets (Insurance) - Securities - Sundry (Cost)
iasmiInvestment Assets (Insurance) - Securities - Sundry (Market)
iassiInvestment Assets - Securities - Sundry (Insurance)
iastiInvestment Assets - Securities - Total (Insurance)
iatciInvestment Assets (Insurance) - Securities - Total (Cost)
iatiInvestment Assets - Total (Insurance)
iatmiInvestment Assets (Insurance) - Securities - Total (Market)
iauiInvestment Assets (Insurance) - Unlisted Securities - Total
ibIncome Before Extraordinary Items
ibadjIncome Before Extraordinary Items - Adjusted for Common Stock Equivalents
ibblIndividual Benefits (Business Line)
ibcIncome Before Extraordinary Items (Cash Flow)
ibcomIncome Before Extraordinary Items - Available for Common
ibkiInvestment Banking Income
ibmiiIncome before Extraordinary Items and Noncontrolling Interests
icaptInvested Capital - Total
idiisInterest and Dividend Income - Investment Securities
idilbInterest and Dividend Income - Loans/Claims/Advances - Banks
idilcInterest and Dividend Income - Loans/Claims/Advances - Customers
idisInterest and Dividend Income - Sundry
idistInterest and Dividend Income - Short-Term Investments
iditInterest and Related Income - Total
iditsInterest and Dividend Income - Trading Securities
iireInvestment Income (Real Estate)
initbIncome - Non-interest - Total (Bank)
intanIntangible Assets - Total
intanoOther Intangibles
intcInterest Capitalized
intpnInterest Paid - Net
invchInventory - Decrease (Increase)
invfgInventories - Finished Goods
invoInventories - Other
invofsInventory/Stock - Other
invrehInventory/Stock - Real Estate Held for Development
invreiInventory/Stock - Real Estate Under Development
invresInventory/Stock - Real Estate Held for Sale
invrmInventories - Raw Materials
invtInventories - Total
invwipInventories - Work In Process
iobdIncome - Other (Broker Dealer)
ioiIncome - Other (Insurance)
ioreIncome - Other (Real Estate)
ipInvestment Property
ipablIndividual Premiums - Annuity (Business Line)
ipcInvestment Property (Cost)
iphblIndividual Premiums - Health (Business Line)
iplblIndividual Premiums - Life (Business Line)
ipoblIndividual Premiums - Other (Business Line)
iptblIndividual Premiums - Total (Business Line)
iptiInsurance Premiums - Total (Insurance)
ipvInvestment Property (Valuation)
ireiInterest and Related Income - Reinsurance (Insurance)
irentRental Income
iriiInterest and Related Income (Insurance)
irliInterest and Related Income - Life (Insurance)
irnliInterest and Related Income - Non-Life (Insurance)
irsiInterest and Related Income - Sundry (Insurance)
iseqInvestment Securities - Equity
iseqcInvestment Securities - Equity (Cost)
iseqmInvestment Securities - Equity (Market)
isfiInvestment Securities - Fixed Income
isfxcInvestment Securities - Fixed Income (Cost)
isfxmInvestment Securities - Fixed Income (Market)
isgrInvestment Securities - Gain (Loss) - Realized
isgtInvestment Securities - Gain (Loss) - Total
isguInvestment Securities - Gain (Loss) - Unrealized
islgInvestment Securities - Local Governments
islgcInvestment Securities - Local Governments (Cost)
islgmInvestment Securities - Local Governments (Market)
isltInvestment Securities - Listed - Total

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html

使用道具

板凳
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:17:08 |只看作者 |坛友微信交流群
指标续:
变量名变量标签
isngInvestment Securities - National Governments
isngcInvestment Securities - National Governments (Cost)
isngmInvestment Securities - National Governments (Market)
isotcInvetsment Securities - Other (Cost)
isothInvestment Securities - Other
isotmInvetsment Securities - Other (Market)
isscInvestment Securities - Sundry (Cost)
issmInvestment Securities - Sundry (Market)
issuInvestment Securities - Sundry
istInvestment Securities -Total
istcInvestment Securities - Total (Cost)
istmInvestment Securities - Total (Market)
isutInvestment Securities - Unlisted - Total
itcbInvestment Tax Credit (Balance Sheet)
itccInvestment Tax Credit - Net (Cash Flow) - Utility
itciInvestment Tax Credit (Income Account)
ivacoInvesting Activities - Other
ivaeqInvestment and Advances - Equity
ivaoInvestment and Advances - Other
ivchIncrease in Investments
ivgodInvestments Grants and Other Deductions
iviInvestment Income - Total (Insurance)
ivncfInvesting Activities - Net Cash Flow
ivptInvestments - Permanent - Total
ivstShort-Term Investments - Total
ivstchShort-Term Investments - Change
lcabgLoans/Claims/Advances - Banks and Government - Total
lcaclLoans/Claims/Advances - Commercial
lcacrLoans/Claims/Advances - Consumer
lcagLoans/Claims/Advances - Government
lcalLoans/Claims/Advances - Lease
lcaltLoans/Claims/Advances - Long-Term (Banks)
lcamLoans/Claims/Advances - Mortgage
lcaoLoans/Claims/Advances - Other
lcastLoans/Claims/Advances - Short-Term - Banks
lcatLoans/Claims/Advances - Total
lcoCurrent Liabilities - Other - Total
lcoxCurrent Liabilities - Other - Sundry
lcoxarCurrent Liabilities - Other - Total As Reported
lcoxdrCurrent Liabilities - Other - Excluding Deferred Revenue
lctCurrent Liabilities - Total
lcuacuLoans/Claims/Advances - Customer - Total
liLeasing Income
lifLife Insurance in Force
lifrLIFO Reserve
lifrpLIFO Reserve - Prior
llomlLDC Loans Outstanding - Medium and Long-Term
llooLDC Loans Outstanding - Other
llotLDC Loans Outstanding - Total
llrciLoan Loss Recoveries - Credited to Income
llrcrLoan Loss Recoveries - Credited to Reserves
llwociLoan Loss Written Off - Charged to Income
llwocrLoan Loss Written Off - Charged to Reserves
lnoLiabilities Netting & Other Adjustments
loLiabilities - Other - Total
lol2Liabilities Level2 (Observable)
loxdrLiabilities - Other - Excluding Deferred Revenue
lqpl1Liabilities Level1 (Quoted Prices)
lrvLegal Reserves
lsLiabilities - Other - Sundry
lseLiabilities and Stockholders Equity - Total
lstLife Insurance Surrenders and Terminations
ltLiabilities - Total
lul3Liabilities Level3 (Unobservable)
mibNoncontrolling Interest (Balance Sheet)
mibnNoncontrolling Interests - Nonredeemable - Balance Sheet
mibtNoncontrolling Interests - Total - Balance Sheet
miiNoncontrolling Interest (Income Account)
mrc1Rental Commitments - Minimum - 1st Year
mrc2Rental Commitments - Minimum - 2nd Year
mrc3Rental Commitments - Minimum - 3rd Year
mrc4Rental Commitments - Minimum - 4th Year
mrc5Rental Commitments - Minimum - 5th Year
mrctRental Commitments - Minimum - 5 Year Total
mrctaThereafter Portion of Leases
msaMarketable Securities Adjustment
msvrvMandatory Securities Valuation Reserve (Statutory)
mtlLoans From Securities Finance Companies for Margin Transactions
natNonadmitted Assets - Total (Statutory)
ncoNet Charge-Offs
nfsrNon-Financial Services Revenue
niNet Income (Loss)
niadjNet Income Adjusted for Common/Ordinary Stock (Capital) Equivalents
nieciNet Income Effect Capitalized Interest
niintNet Interest Income
niintpfcPro Forma Net Interest Income - Current
niintpfpPro Forma Net Interest Income - Prior
niitNet Interest Income (Tax Equivalent)
nimNet Interest Margin
nioNet Items - Other
nipfcPro Forma Net Income - Current
nipfpPro Forma Net Income - Prior
nitNet Item - Total
nitsNet Income - Total (Statutory)
nopiNonoperating Income (Expense)
nopioNonoperating Income (Expense) - Other
npNotes Payable - Short-Term Borrowings
npanlNonperforming Assets - Nonaccrual Loans
npaoreNonperforming Assets - Other Real Estate Owned
nparlNonperforming Assets - Restructured Loans
npatNonperforming Assets - Total
nrtxtNonrecurring Income Taxes After-tax
nrtxtdNonrecurring Income Tax Diluted EPS Effect
nrtxtepsNonrecurring Income Tax Basic EPS Effect
oancfOperating Activities - Net Cash Flow
obOrder Backlog
oiadpOperating Income After Depreciation
oibdpOperating Income Before Depreciation
opepsEarnings Per Share from Operations
opiliOperating Income - Life
opincarOperating Income - As Reported
opiniOperating Income - Non-Life
opioiOperating Income - Other
opiriOperating Income - Reinsurance
opitiOperating Income - Total
oprepsxEarnings Per Share - Diluted - from Operations
optcaOptions - Cancelled (-)
optdrDividend Rate - Assumption (%)
optexOptions Exercisable (000)
optexdOptions - Exercised (-)
optfvgrOptions - Fair Value of Options Granted
optgrOptions - Granted
optlifeLife of Options - Assumption (# yrs)
optosbyOptions Outstanding - Beg of Year
optoseyOptions Outstanding - End of Year
optprcbyOptions Outstanding Beg of Year - Price
optprccaOptions Cancelled - Price
optprcexOptions Exercised - Price
optprceyOptions Outstanding End of Year - Price
optprcgrOptions Granted - Price
optprcwaOptions Exercisable - Weighted Avg Price
optrfrRisk Free Rate - Assumption (%)
optvolVolatility - Assumption (%)
palrPremiums Assumed - Life
panlrPremiums Assumed - Nonlife
patrPremiums Assumed - Total
pclProvision - Credit Losses (Income Account)
pclrPremiums Ceded - Life
pcnlrPremiums Ceded - Nonlife
pctrPremiums Ceded - Total
pdvcCash Dividends on Preferred/Preference Stock (Cash Flow)
piPretax Income
pidomPretax Income - Domestic
pifoPretax Income - Foreign
pllProvision for Loan/Asset Losses
pltblPremiums - Life - Total (Business Line)
pncaCore Pension Adjustment
pncadCore Pension Adjustment Diluted EPS Effect
pncaepsCore Pension Adjustment Basic EPS Effect
pnciaCore Pension Interest Adjustment After-tax
pncidCore Pension Interest Adjustment Diluted EPS Effect
pnciepsCore Pension Interest Adjustment Basic EPS Effect
pncipCore Pension Interest Adjustment Pretax
pncwiaCore Pension w/o Interest Adjustment After-tax
pncwidCore Pension w/o Interest Adjustment Diluted EPS Effect
pncwiepsCore Pension w/o Interest Adjustment Basic EPS Effect
pncwipCore Pension w/o Interest Adjustment Pretax
pnlblPremiums - Nonlife - Total (Business Line)
pnliPremiums Written - Non-Life
pnrshoNonred Pfd Shares Outs (000)
poblPremiums - Other (Business Line)
ppcblPersonal Property and Casualty Claims (Business Line)
ppegtProperty, Plant and Equipment - Total (Gross)
ppenbProperty, Plant, and Equipment - Buildings (Net)
ppencProperty, Plant, and Equipment - Construction in Progress (Net)
ppenliProperty, Plant, and Equipment - Land and Improvements (Net)
ppenlsProperty, Plant, and Equipment - Leases (Net)
ppenmeProperty, Plant, and Equipment - Machinery and Equipment (Net)
ppennrProperty, Plant, and Equipment - Natural Resources (Net)
ppenoProperty, Plant, and Equipment - Other (Net)
ppentProperty, Plant and Equipment - Total (Net)
ppevbbProperty, Plant and Equipment - Beginning Balance (Schedule V)
ppevebProperty, Plant, and Equipment - Ending Balance (Schedule V)
ppevoProperty, Plant, and Equipment - Other Changes (Schedule V)
ppevrProperty, Plant and Equipment - Retirements (Schedule V)
pppablPersonal Property and Casualty Premiums - Automobile (Business Line)
ppphblPersonal Property and Casualty Premiums - Homeowners (Business Line)
pppoblPersonal Property and Casualty Premiums - Other (Business Line)
ppptblPersonal Property & Casualty Premiums - Total (Business Line)
prcParticipation Rights Certificates
prcaCore Post Retirement Adjustment
prcadCore Post Retirement Adjustment Diluted EPS Effect
prcaepsCore Post Retirement Adjustment Basic EPS Effect
preblPremiums - Reinsurance (Business Line)
priPremiums Written - Reinsurance
prodvProposed Dividends
prshoRedeem Pfd Shares Outs (000)
prstkcPurchase of Common and Preferred Stock
prstkccPurchase of Common Stock (Cash Flow)

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html

使用道具

报纸
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:17:40 |只看作者 |坛友微信交流群
指标续:
变量名变量标签
prstkpcPurchase of Preferred/Preference Stock (Cash Flow)
prvtPolicy Reserves - Total (Statutory)
pstkPreferred/Preference Stock (Capital) - Total
pstkcPreferred Stock - Convertible
pstklPreferred Stock - Liquidating Value
pstknPreferred/Preference Stock - Nonredeemable
pstkrPreferred/Preference Stock - Redeemable
pstkrvPreferred Stock - Redemption Value
ptblPremiums - Total (Business Line)
ptranPrincipal Transactions
pvclProvision - Credit Losses (Balance Sheet)
pvoProvision - Other
pvonProvisions - Other (Net)
pvplProvision - Pension Liabilities
pvtProvisions - Total
pwoiPremiums Written - Other
radpReinsurance Assets - Deposits and Other (Insurance)
ragrResale Agreements
rariReinsurance Assets - Receivable/Debtors (Insurance)
ratiReinsurance Assets - Total (Insurance)
rcaRestructuring Costs After-tax
rcdRestructuring Costs Diluted EPS Effect
rcepsRestructuring Costs Basic EPS Effect
rclReserves for Credit Losses (Assets)
rcpRestructuring Costs Pretax
rdipIn Process R&D Expense
rdipaIn Process R&D Expense After-tax
rdipdIn Process R&D Expense Diluted EPS Effect
rdipepsIn Process R&D Expense Basic EPS Effect
rdpRegulatory Deposits
reRetained Earnings
reaRetained Earnings - Restatement
reajoRetained Earnings - Other Adjustments
recchAccounts Receivable - Decrease (Increase)
reccoReceivables - Current - Other
recdReceivables - Estimated Doubtful
rectReceivables - Total
rectaRetained Earnings - Cumulative Translation Adjustment
rectrReceivables - Trade
recubUnbilled Receivables
retTotal RE Property
reunaRetained Earnings - Unadjusted
reunrRetained Earnings - Unrestricted
revtRevenue - Total
risRevenue/Income - Sundry
rllReserve for Loan/Asset Losses
rloReinsurance Liabilities - Other
rlpReinsurance Liabilities - Payables/Creditors
rlriReinsurers'' Liability for Reserves (Insurance)
rltReinsurance Liabilities - Total
rmumAuditors'' Remuneraton
rpagRepurchase Agreements
rraReversal - Restructruring/Acquisition Aftertax
rrdReversal - Restructuring/Acq Diluted EPS Effect
rrepsReversal - Restructuring/Acq Basic EPS Effect
rrpReversal - Restructruring/Acquisition Pretax
rstcheRestricted Cash & Investments - Current
rstcheltLong-Term Restricted Cash & Investments
rvbciReserves for Benefits - Life - Claims (Insurance)
rvbpiReserves for Benefits - Life - Policy (Insurance)
rvbtiReserves for Benefits - Life - Total (Insurance)
rvdoReserves - Distributable - Other
rvdtReserves - Distributable - Total
rveqtEquity Reserves - Total
rvlrvRevaluation Reserve
rvnoReserves - Nondistributable - Other
rvntReserves - Nondistributable - Total
rvriReserves - Reinsurance (Insurance)
rvsiReserves - Sundry (Insurance)
rvtiReserves - Total
rvtxrReserves - Tax-Regulated
rvupiReserves for Unearned Premiums (Insurance)
rvutxReserves - Untaxed
saaSeparate Account Assets
salSeparate Account Liabilities
saleSales/Turnover (Net)
salepfcPro Forma Net Sales - Current Year
salepfpPro Forma Net Sales - Prior Year
sbdcSecurities Borrowed and Deposited by Customers
scSecurities In Custody
scoShare Capital - Other
scstkcSale of Common Stock (Cash Flow)
secuSecurities Gains (Losses) - Unrealized
seqStockholders Equity - Parent
seqoOther Stockholders- Equity Adjustments
setaSettlement (Litigation/Insurance) After-tax
setdSettlement (Litigation/Insurance) Diluted EPS Effect
setepsSettlement (Litigation/Insurance) Basic EPS Effect
setpSettlement (Litigation/Insurance) Pretax
sivSale of Investments
spceS&P Core Earnings
spcedS&P Core Earnings EPS Diluted
spceepsS&P Core Earnings EPS Basic
spiSpecial Items
spidOther Special Items Diluted EPS Effect
spiepsOther Special Items Basic EPS Effect
spioaOther Special Items After-tax
spiopOther Special Items Pretax
sppeSale of Property
sppivSale of Property, Plant and Equipment and Investments - Gain (Loss)
spstkcSale of Preferred/Preference Stock (Cash Flow)
sretGain/Loss on Sale of Property
srtSurplus - Total (Statutory)
ssnpSecurities Sold Not Yet Purchased
sstkSale of Common and Preferred Stock
stboShort-Term Borrowings - Other
stioShort-Term Investments - Other
stkcoStock Compensation Expense
stkcpaAfter-tax stock compensation
tdcDeferred Income Taxes - Net (Cash Flow)
tdscdTrading/Dealing Account Securities - Corporate Debt
tdsceTrading/Dealing Account Securities - Corporate Equity
tdsgTrading/Dealing Securities - Gain (Loss)
tdslgTrading/Dealing Account Securities - Local Governments
tdsmmTrading/Dealing Account Securities - Money Market
tdsngTrading/Dealing Account Securities - National Governments
tdsoTrading/Dealing Account Securities - Other
tdssTrading/Dealing Account Securities - Sundry
tdstTrading/Dealing Account Securities - Total
teqStockholders Equity - Total
tfTrust Fees
tfvaTotal Fair Value Assets
tfvceTotal Fair Value Changes including Earnings
tfvlTotal Fair Value Liabilities
tieInterest Expense - Total (Financial Services)
tiiInterest Income - Total (Financial Services)
tlcfTax Loss Carry Forward
transaCumulative Translation Adjustment
tsaTreasury Stock (Assets)
tsafcTotal Sources/Applications of Funds (Cash Flow)
tsoTreasury Stock - Other Share Capital
tstkTreasury Stock - Total (All Capital)
tstkcTreasury Stock - Common
tstkmeTreasury Stock Book Value - Memo Entry
tstknTreasury Stock - Number of Common Shares
tstkpTreasury Stock - Preferrred
txachIncome Taxes - Accrued - Increase/(Decrease)
txbcoExcess Tax Benefit Stock Options - Cash Flow Operating
txbcofExcess Tax Benefit of Stock Options - Cash Flow Financing
txcIncome Taxes - Current
txdbDeferred Taxes (Balance Sheet)
txdbaDeferred Tax Asset - Long Term
txdbcaDeferred Tax Asset - Current
txdbclDeferred Tax Liability - Current
txdcDeferred Taxes (Cash Flow)
txdfedDeferred Taxes-Federal
txdfoDeferred Taxes-Foreign
txdiIncome Taxes - Deferred
txditcDeferred Taxes and Investment Tax Credit
txdsDeferred Taxes-State
txeqaTax - Equivalent Adjustment
txeqiiTax - Equivalent Interest Income (Gross)
txfedIncome Taxes - Federal
txfoIncome Taxes - Foreign
txndbNet Deferred Tax Asset (Liab) - Total
txndbaNet Deferred Tax Asset
txndblNet Deferred Tax Liability
txndbrDeferred Tax Residual
txoIncome Taxes - Other
txpIncome Taxes Payable
txpdIncome Taxes Paid
txrIncome Tax Refund
txsIncome Taxes - State
txtIncome Taxes - Total
txtubadjustOther Unrecog Tax Benefit Adj.
txtubbeginUnrecog. Tax Benefits - Beg of Year
txtubendUnrecog. Tax Benefits - End of Year
txtubmaxChg. In Unrecog. Tax Benefits - Max
txtubminChg. In Unrecog. Tax Benefits - Min
txtubposdecDecrease- Current Tax Positions
txtubposincIncrease- Current Tax Positions
txtubpospdecDecrease- Prior Tax Positions
txtubpospincIncrease- Prior Tax Positions
txtubsettleSettlements with Tax Authorities
txtubsoflimitLapse of Statute of Limitations
txtubtxtrImpact on Effective Tax Rate
txtubxintbsInterest & Penalties Accrued - B/S
txtubxintisInterest & Penalties Reconized - I/S
txvaValue Added Taxes
txwExcise Taxes
uaolochOther Assets and Liabilities - Net Change (Statement of Cash Flows)
uaoxOther Assets - Utility
uaptAccounts Payable - Utility
ucapsPaid in Capital - Other
ucconsContributions in Aid of Construction
uceqCommon Equity Total - Utility
ucustadCustomer Advances for Construction
udcopresDeferred Credits and Operating Reserves - Other
uddDebt (Debentures)
udfccDeferred Fuel - Increase (Decrease) (Statement of Cash Flows)
udmbDebt (Mortgage Bonds) - Utility
udoltDebt (Other Long-Term) - Utility
udpcoDebt (Pollution Control Obligations) - Utility
udpfaDepreciation of Fixed Assets
udvpPreferred Dividend Requirements
ufretsdFunds for Retirement of Securities and Short-Term Debt (Cash Flow)
ugiGross Income (Income Before Interest Charges)
uiUnearned Income

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html

使用道具

地板
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:18:06 |只看作者 |坛友微信交流群
指标续:
变量名变量标签
uinvtInventories - Utility
ulcmCurrent Liabilities - Miscellaneous
ulcoCurrent Liabilities - Other - Utility
uniamiNet Income before Extraordinary Items and after Noncontrolling Interest
unlUnappropriated Net Loss
unnpUnappropriated Net Profit (Stockholders'' Equity)
unnplUnappropriated Net Profit
unopincNonoperating Income (Net) - Other
unwccWorking Capital (Use) - Increase (Decrease) (Cash Flow)
uoisOther Internal Sources - Net (Cash Flow)
uopiOperating Income - Total - Utility
uopresOperating Reserves
updvpPreference Dividend Requirements*
upmcstkPremium on Common Stock*
upmpfPremium on Preferred Stock*
upmpfsPremium on Preference Stock*
upmsubpPremium on Subsidiary Preferred Stock*
upstkPreferred Stock at Carrying Value
upstkcPreference Stock at Carrying Value*
upstksfPreferred/Preference Stock Sinking Fund Requirement
urectReceivables (Net)
urectrAccounts Receivable - Trade - Utility
urevubAccrued Unbilled Revenues (Balance Sheet)
uspiSpecial Items
ustdncShort-Term Debt - Decrease (Increase) (Cash Flow)
usubdvpSubsidiary Preferred Dividends
usubpstkSubsidiary Preferred Stock at Carrying Value
utfdocTotal Funds From Operations (Cash Flow)
utfoscTotal Funds from Outside Sources (Cash Flow)
utmeMaintenance Expense - Total
utxfedCurrent Taxes - Federal (Operating)
uwkcapcWorking Capital (Source) - Decrease (Increase) (Cash Flow)
uxinstInterest On Short-Term Debt - Utility
uxintdInterest on Long-Term Debt*
vpacInvestments - Permanent - Associated Companies
vpoInvestments - Permanent - Other
wcapWorking Capital (Balance Sheet)
wcapcWorking Capital Change - Other - Increase/(Decrease)
wcapchWorking Capital Change - Total
wdaWritedowns After-tax
wddWritedowns Diluted EPS Effect
wdepsWritedowns Basic EPS Effect
wdpWritedowns Pretax
xaccAccrued Expenses
xadAdvertising Expense
xagoAdministrative and General Expense - Other
xagtAdministrative and General Expense - Total
xcomCommunications Expense
xcomiCommissions Expense (Insurance)
xdeplDepletion Expense (Schedule VI)
xdpDepreciation Expense (Schedule VI)
xdvreExpense - Development (Real Estate)
xeqoEquipment and Occupancy Expense
xiExtraordinary Items
xidoExtraordinary Items and Discontinued Operations
xidocExtraordinary Items and Discontinued Operations (Cash Flow)
xindbInterest Expense - Deposits - Banks
xindcInterest Expense - Deposits - Customer
xinsInterest Expense - Sundry
xinstInterest Expense - Short-Term Borrowings
xintInterest and Related Expense - Total
xintdInterest Expense - Long-Term Debt
xintoptImplied Option Expense
xiviInvestment Expense (Insurance)
xivreExpense - Investment (Real Estate)
xlrStaff Expense - Total
xnbiOther Insurance Expense
xnfNon-Financial Services Expense
xninsOther Expense - Noninsurance
xnitbExpense - Noninterest - Total (Bank)
xobdExpense - Other (Broker/Dealer)
xoiExpenses - Other (Insurance)
xoprOperating Expenses - Total
xoprarOperatings Expenses - As Reported
xoptdImplied Option EPS Diluted
xoptepsImplied Option EPS Basic
xoreExpense - Other (Real Estate)
xppPrepaid Expenses
xprPension and Retirement Expense
xrdResearch and Development Expense
xrdpResearch & Development - Prior
xrentRental Expense
xsExpense - Sundry
xsgaSelling, General and Administrative Expense
xstfStaff Expense (Income Account)
xstfoStaff Expense - Other
xstfwsStaff Expense - Wages and Salaries
xtExpense - Total
xuwOther Underwriting Expenses - Insurance
xuwliUnderwriting Expense - Life
xuwnliUnderwriting Expense - Non-Life
xuwoiUnderwriting Expense - Other
xuwreiUnderwriting Expense - Reinsurance
xuwtiUnderwriting Expense - Total
exchgStock Exchange Code
cikCIK Number
costatActive/Inactive Status Marker
ficCurrent ISO Country Code - Incorporation
naicshNorth America Industrial Classification System - Historical
sichStandard Industrial Classification - Historical
cshtr_cCommon Shares Traded - Annual - Calendar
dvpsp_cDividends per Share - Pay Date - Calendar
dvpsx_cDividends per Share - Ex-Date - Calendar
prcc_cPrice Close - Annual - Calendar
prch_cPrice High - Annual - Calendar
prcl_cPrice Low - Annual - Calendar
adjex_cCumulative Adjustment Factor by Ex-Date - Calendar
cshtr_fCommon Shares Traded - Annual - Fiscal
dvpsp_fDividends per Share - Pay Date - Fiscal
dvpsx_fDividends per Share - Ex-Date - Fiscal
mkvaltMarket Value - Total - Fiscal
prcc_fPrice Close - Annual - Fiscal
prch_fPrice High - Annual - Fiscal
prcl_fPrice Low - Annual - Fiscal
adjex_fCumulative Adjustment Factor by Ex-Date - Fiscal
rankRank - Auditor
auAuditor
auopAuditor Opinion
auopicAuditor Opinion - Internal Control
ceosoChief Executive Officer SOX Certification
cfosoChief Financial Officer SOX Certification
add1Address Line 1
add2Address Line 2
add3Address Line 3
add4Address Line 4
addzipPostal Code
busdescS&P Business Description
cityCity
conmlCompany Legal Name
countyCounty Code
dlrsnResearch Co Reason for Deletion
einEmployer Identification Number
faxFax Number
fyrcCurrent Fiscal Year End Month
ggroupGIC Groups
gindGIC Industries
gsectorGIC Sectors
gsubindGIC Sub-Industries
idbflagInternational, Domestic, Both Indicator
incorpCurrent State/Province of Incorporation Code
locCurrent ISO Country Code - Headquarters
naicsNorth American Industry Classification Code
phonePhone Number
pricanCurrent Primary Issue Tag - Canada
prirowPrimary Issue Tag - Rest of World
priusaCurrent Primary Issue Tag - US
sicStandard Industry Classification Code
spcindcdS&P Industry Sector Code
spcseccdS&P Economic Sector Code
spcsrcS&P Quality Ranking - Current
stateState/Province
stkoStock Ownership Code
weburlWeb URL
dldteResearch Company Deletion Date
ipodateCompany Initial Public Offering Date

数据索引大全
https://bbs.pinggu.org/thread-11521234-1-1.html

使用道具

7
Whatsappp 企业认证  学生认证  发表于 2024-3-7 22:20:12 |只看作者 |坛友微信交流群


论文常用数据


STATA论文复刻实证分析

使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加JingGuanBbs
拉您进交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-4-28 15:03