- Introduction
- Function Introduction
- Performance Monitor
- Fusion Hunter
- Quantitative Chart
- SEC Filing
- Insider Trading (Search by Ticker)
- Insider Trading (Search by Reporter)
- Insider Trading (Top Insider Trading)
- Institutional Holdings
- Investment Trends (Investment Company List)
- Investment Trends (Sector & Industry Sentiment)
- Investment Trends (Investment Company Sentiment)
- Investment Trends (Top Institutional Trading)
- Investment Trends (Top Institutional Hldg Change)
- Key Ratio Distribution
- Screener
- Financial Statement
- Key Metrics
- High Current Difference
- Low Current Difference
- Relative Strength Index
- KDJ
- Bollinger Bands
- Price Earnings Ratio
- Price to Book Value
- Debt Equity Ratio
- Leverage Ratio
- Return on Equity
- Return on Assets
- Gross Margin
- Net Profit Margin
- Operating Margin
- Income Growth
- Sales Growth
- Quick Ratio
- Current Ratio
- Interest Coverage
- Institutional Ownership
- Sector & Industry Classification
- Data Portal
- API
- SEC Forms
- Form 4
- Form 3
- Form 5
- CT ORDER
- Form 13F
- Form SC 13D
- Form SC 14D9
- Form SC 13G
- Form SC 13E1
- Form SC 13E3
- Form SC TO
- Form S-3D
- Form S-1
- Form F-1
- Form 8-k
- Form 1-E
- Form 144
- Form 20-F
- Form ARS
- Form 6-K
- Form 10-K
- Form 10-Q
- Form 10-KT
- Form 10-QT
- Form 11-K
- Form DEF 14A
- Form 10-D
- Form 13H
- Form 24F-2
- Form 15
- Form 25
- Form 40-F
- Form 424
- Form 425
- Form 8-A
- Form 8-M
- Form ADV-E
- Form ANNLRPT
- Form APP WD
- Form AW
- Form CB
- Form CORRESP
- Form DSTRBRPT
- Form EFFECT
- Form F-10
- Form F-3
- Form F-4
- Form F-6
- Form F-7
- Form F-9
- Form F-n
- Form X-17A-5
- Form F-X
- Form FWP
- Form G-405
- Form G-FIN
- Form MSD
- Form N-14
- Form N-18F1
- Form N-18F1
- Form N-30B-2
- Form N-54A
- Form N-8A
- Form N-CSR
- Form N-MFP
- Form N-PX
- Form N-Q
- Form TTW
- Form TA-1
- Form T-3
- Form SC 14F1
- Form SE
- Form SP 15D2
- Form SUPPL
- Form 10-12G
- Form 18-K
- Form SD
- Form STOP ORDER
- Form TH
- Form 1
- Form 19B-4(e)
- Form 40-APP
- Form 497
- Form ABS-15G
- Form DRS
- Form MA
- Form UNDER
- AI sentiment
- Access guide
- Academy
- Term of service
- GDPR compliance
- Contact Us
- Question Center
| Font Size: |
Key Ratios
Key ratios table contains most recent as well as historical data reflecting both the financial condition and investment value of publicly traded companies. Financial ratios eligible for peer comparison also come with three quantile ranking values reflecting their corresponding rank at industry, sector, and the whole market level. The table is updated weekly (every Saturday) using the latest information available. The table is constructed as shown below
CREATE TABLE `mjdatacombs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`recdate` date NOT NULL,
`x52wk_high` decimal(17,7) DEFAULT NULL,
`x52wk_low` decimal(17,7) DEFAULT NULL,
`volume_average` decimal(17,7) DEFAULT NULL,
`volume` decimal(17,7) DEFAULT NULL,
`v2o` decimal(17,7) DEFAULT NULL,
`previous_close` decimal(17,7) DEFAULT NULL,
`beta` decimal(17,7) DEFAULT NULL,
`hcd` decimal(17,7) DEFAULT NULL,
`lcd` decimal(17,7) DEFAULT NULL,
`rps` decimal(17,7) DEFAULT NULL,
`eps` decimal(17,7) DEFAULT NULL,
`oeps` decimal(17,7) DEFAULT NULL,
`bps` decimal(17,7) DEFAULT NULL,
`pe` decimal(17,7) DEFAULT NULL,
`forward_pe` decimal(17,7) DEFAULT NULL,
`poe` decimal(17,7) DEFAULT NULL,
`peg` decimal(17,7) DEFAULT NULL,
`p2b` decimal(17,7) DEFAULT NULL,
`p2s` decimal(17,7) DEFAULT NULL,
`debt_equity_ratio` decimal(17,7) DEFAULT NULL,
`leverage_ratio` decimal(17,7) DEFAULT NULL,
`interest_coverage` decimal(17,7) DEFAULT NULL,
`gross_margin` decimal(17,7) DEFAULT NULL,
`net_profit_margin` decimal(17,7) DEFAULT NULL,
`income_growth` decimal(17,7) DEFAULT NULL,
`sales_growth` decimal(17,7) DEFAULT NULL,
`quick_ratio` decimal(17,7) DEFAULT NULL,
`current_ratio` decimal(17,7) DEFAULT NULL,
`return_on_assets` decimal(17,7) DEFAULT NULL,
`return_on_equity` decimal(17,7) DEFAULT NULL,
`return_on_capital` decimal(17,7) DEFAULT NULL,
`dividend_rate` decimal(17,7) DEFAULT NULL,
`payout_ratio` decimal(17,7) DEFAULT NULL,
`yield` decimal(17,7) DEFAULT NULL,
`institutional_ownership` decimal(17,7) DEFAULT NULL,
`one_year_target` decimal(17,7) DEFAULT NULL,
`shares_outstanding` decimal(17,7) DEFAULT NULL,
`equity` decimal(17,7) DEFAULT NULL,
`assets` decimal(17,7) DEFAULT NULL,
`quick_ratio_idsqt` decimal(17,7) DEFAULT NULL,
`quick_ratio_secqt` decimal(17,7) DEFAULT NULL,
`quick_ratio_allqt` decimal(17,7) DEFAULT NULL,
`debt_equity_ratio_idsqt` decimal(17,7) DEFAULT NULL,
`debt_equity_ratio_secqt` decimal(17,7) DEFAULT NULL,
`debt_equity_ratio_allqt` decimal(17,7) DEFAULT NULL,
`return_on_equity_idsqt` decimal(17,7) DEFAULT NULL,
`return_on_equity_secqt` decimal(17,7) DEFAULT NULL,
`return_on_equity_allqt` decimal(17,7) DEFAULT NULL,
`return_on_assets_idsqt` decimal(17,7) DEFAULT NULL,
`return_on_assets_secqt` decimal(17,7) DEFAULT NULL,
`return_on_assets_allqt` decimal(17,7) DEFAULT NULL,
`return_on_capital_idsqt` decimal(17,7) DEFAULT NULL,
`return_on_capital_secqt` decimal(17,7) DEFAULT NULL,
`return_on_capital_allqt` decimal(17,7) DEFAULT NULL,
`net_profit_margin_idsqt` decimal(17,7) DEFAULT NULL,
`net_profit_margin_secqt` decimal(17,7) DEFAULT NULL,
`net_profit_margin_allqt` decimal(17,7) DEFAULT NULL,
`gross_margin_idsqt` decimal(17,7) DEFAULT NULL,
`gross_margin_secqt` decimal(17,7) DEFAULT NULL,
`gross_margin_allqt` decimal(17,7) DEFAULT NULL,
`income_growth_idsqt` decimal(17,7) DEFAULT NULL,
`income_growth_secqt` decimal(17,7) DEFAULT NULL,
`income_growth_allqt` decimal(17,7) DEFAULT NULL,
`sales_growth_idsqt` decimal(17,7) DEFAULT NULL,
`sales_growth_secqt` decimal(17,7) DEFAULT NULL,
`sales_growth_allqt` decimal(17,7) DEFAULT NULL,
`payout_ratio_idsqt` decimal(17,7) DEFAULT NULL,
`payout_ratio_secqt` decimal(17,7) DEFAULT NULL,
`payout_ratio_allqt` decimal(17,7) DEFAULT NULL,
`p2b_idsqt` decimal(17,7) DEFAULT NULL,
`p2b_secqt` decimal(17,7) DEFAULT NULL,
`p2b_allqt` decimal(17,7) DEFAULT NULL,
`pe_idsqt` decimal(17,7) DEFAULT NULL,
`pe_secqt` decimal(17,7) DEFAULT NULL,
`pe_allqt` decimal(17,7) DEFAULT NULL,
`yield_idsqt` decimal(17,7) DEFAULT NULL,
`yield_secqt` decimal(17,7) DEFAULT NULL,
`yield_allqt` decimal(17,7) DEFAULT NULL,
`forward_pe_idsqt` decimal(17,7) DEFAULT NULL,
`forward_pe_secqt` decimal(17,7) DEFAULT NULL,
`forward_pe_allqt` decimal(17,7) DEFAULT NULL,
`hcd_idsqt` decimal(17,7) DEFAULT NULL,
`hcd_secqt` decimal(17,7) DEFAULT NULL,
`hcd_allqt` decimal(17,7) DEFAULT NULL,
`lcd_idsqt` decimal(17,7) DEFAULT NULL,
`lcd_secqt` decimal(17,7) DEFAULT NULL,
`lcd_allqt` decimal(17,7) DEFAULT NULL,
`peg_idsqt` decimal(17,7) DEFAULT NULL,
`peg_secqt` decimal(17,7) DEFAULT NULL,
`peg_allqt` decimal(17,7) DEFAULT NULL,
`institutional_ownership_idsqt` decimal(17,7) DEFAULT NULL,
`institutional_ownership_secqt` decimal(17,7) DEFAULT NULL,
`institutional_ownership_allqt` decimal(17,7) DEFAULT NULL,
`v2o_idsqt` decimal(17,7) DEFAULT NULL,
`v2o_secqt` decimal(17,7) DEFAULT NULL,
`v2o_allqt` decimal(17,7) DEFAULT NULL,
`current_ratio_idsqt` decimal(17,7) DEFAULT NULL,
`current_ratio_secqt` decimal(17,7) DEFAULT NULL,
`current_ratio_allqt` decimal(17,7) DEFAULT NULL,
`leverage_ratio_idsqt` decimal(17,7) DEFAULT NULL,
`leverage_ratio_secqt` decimal(17,7) DEFAULT NULL,
`leverage_ratio_allqt` decimal(17,7) DEFAULT NULL,
`poe_idsqt` decimal(17,7) DEFAULT NULL,
`poe_secqt` decimal(17,7) DEFAULT NULL,
`poe_allqt` decimal(17,7) DEFAULT NULL,
`interest_coverage_idsqt` decimal(17,7) DEFAULT NULL,
`interest_coverage_secqt` decimal(17,7) DEFAULT NULL,
`interest_coverage_allqt` decimal(17,7) DEFAULT NULL,
`p2s_idsqt` decimal(17,7) DEFAULT NULL,
`p2s_secqt` decimal(17,7) DEFAULT NULL,
`p2s_allqt` decimal(17,7) DEFAULT NULL,
`operating_margin` decimal(17,7) DEFAULT NULL,
`operating_margin_idsqt` decimal(17,7) DEFAULT NULL,
`operating_margin_secqt` decimal(17,7) DEFAULT NULL,
`operating_margin_allqt` decimal(17,7) DEFAULT NULL,
`assets_idsqt` decimal(17,7) DEFAULT NULL,
`assets_secqt` decimal(17,7) DEFAULT NULL,
`assets_allqt` decimal(17,7) DEFAULT NULL,
`equity_idsqt` decimal(17,7) DEFAULT NULL,
`equity_secqt` decimal(17,7) DEFAULT NULL,
`equity_allqt` decimal(17,7) DEFAULT NULL,
`marketcap` decimal(17,7) DEFAULT NULL,
`marketcap_idsqt` decimal(17,7) DEFAULT NULL,
`marketcap_secqt` decimal(17,7) DEFAULT NULL,
`marketcap_allqt` decimal(17,7) DEFAULT NULL,
`revenue` decimal(17,7) DEFAULT NULL,
`revenue_idsqt` decimal(17,7) DEFAULT NULL,
`revenue_secqt` decimal(17,7) DEFAULT NULL,
`revenue_allqt` decimal(17,7) DEFAULT NULL,
`netincome` decimal(17,7) DEFAULT NULL,
`netincome_idsqt` decimal(17,7) DEFAULT NULL,
`netincome_secqt` decimal(17,7) DEFAULT NULL,
`netincome_allqt` decimal(17,7) DEFAULT NULL,
`rsi` decimal(17,7) DEFAULT NULL,
`rsi_idsqt` decimal(17,7) DEFAULT NULL,
`rsi_secqt` decimal(17,7) DEFAULT NULL,
`rsi_allqt` decimal(17,7) DEFAULT NULL,
`k_w_9_3_3` decimal(17,7) DEFAULT NULL,
`d_w_9_3_3` decimal(17,7) DEFAULT NULL,
`j_w_9_3_3` decimal(17,7) DEFAULT NULL,
`j_w_9_3_3_idsqt` decimal(17,7) DEFAULT NULL,
`j_w_9_3_3_secqt` decimal(17,7) DEFAULT NULL,
`j_w_9_3_3_allqt` decimal(17,7) DEFAULT NULL,
`rsi_w_5` decimal(17,7) DEFAULT NULL,
`rsi_w_5_idsqt` decimal(17,7) DEFAULT NULL,
`rsi_w_5_secqt` decimal(17,7) DEFAULT NULL,
`rsi_w_5_allqt` decimal(17,7) DEFAULT NULL,
`sma_w_20` decimal(17,7) DEFAULT NULL,
`sd_w_20` decimal(17,7) DEFAULT NULL,
`bbw_w_20_2` decimal(17,7) DEFAULT NULL,
`bbp_w_20_2` decimal(17,7) DEFAULT NULL,
`bbw_w_20_2_idsqt` decimal(17,7) DEFAULT NULL,
`bbw_w_20_2_secqt` decimal(17,7) DEFAULT NULL,
`bbw_w_20_2_allqt` decimal(17,7) DEFAULT NULL,
`bbc_s1` decimal(17,7) DEFAULT NULL,
`bbc_s1_idsqt` decimal(17,7) DEFAULT NULL,
`bbc_s1_secqt` decimal(17,7) DEFAULT NULL,
`bbc_s1_allqt` decimal(17,7) DEFAULT NULL,
`cfops` decimal(17,7) DEFAULT NULL,
`pcfo` decimal(17,7) DEFAULT NULL,
`pcfo_idsqt` decimal(17,7) DEFAULT NULL,
`pcfo_secqt` decimal(17,7) DEFAULT NULL,
`pcfo_allqt` decimal(17,7) DEFAULT NULL,
`fcfps` decimal(17,7) DEFAULT NULL,
`pfcf` decimal(17,7) DEFAULT NULL,
`pfcf_idsqt` decimal(17,7) DEFAULT NULL,
`pfcf_secqt` decimal(17,7) DEFAULT NULL,
`pfcf_allqt` decimal(17,7) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_mjdatacombs_on_symbol_and_recdate` (`symbol`,`recdate`),
KEY `index_mjdatacombs_on_recdate` (`recdate`)
) ENGINE=InnoDB AUTO_INCREMENT=76877601 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Field definition
symbol: The trading symbol of corresponding stock.
recdate: The date when the record was generated.
x52wk_high: The highest stock price during previous 52 weeks.
x52wk_low: The lowest stock price during previous 52 weeks.
volume_average: Average trading volume of 10 trailing trading days.
volume: Trading volume on the closest Friday.
v2o: Calculated by dividing average trading volume by overall shares outstanding.
previous_close: The price at market close on the closest Friday.
beta: Volatility of stock price. Beta larger than 1 indicates the stock is more volatile than the market, and tends to move up and down with the market.
hcd: Calculated through equation (52wk High - Current Price) / Current Price.
lcd: Calculated through equation (52wk Low - Current Price) / Current Price.
rsi: Weekly relative strength index of the last 14 weeks.
rsi_w_5: Weekly relative strength index of the last 5 weeks.
k_w_9_3_3: Weekly stochastic slow K of the last 9 weeks, smoothed over 3 periods.
d_w_9_3_3: Weekly stochastic slow D of the last 9 weeks.
j_w_9_3_3: Weekly stochastic slow J of the last 9 weeks.
rps: Trailing 12 months revenue per share.
eps: Earnings per share. Calculated by dividing trailing 12 months net income by shares outstanding.
oeps: Operating incomes per share. Calculated by dividing trailing 12 months operating income by shares outstanding.
bps: Book value per share. Calculated by dividing shareholder's equity by shares outstanding.
pe: Price to earnings ratio. Calculated by dividing price by trailing 12 months earnings per share.
forward_pe: Price to earnings ratio using forcasted earnings.
poe: Price to operating income ratio. Calculated by dividing price by trailing 12 months operating income per share.
peg: Price to earnings to growth ratio. Calculated by dividing price to earnings ratio by expected income growth.
p2b: Price to book value ratio. Calculated by dividing price by book value per share.
p2s: Price to sales ratio. Calculated by dividing price by trailing 12 months revenue per share.
debt_equity_ratio: Calculated by dividing total liabilities by shareholder's equity.
leverage_ratio: Calculated by dividing total assets by shareholder's equity.
interest_coverage: Calculated by dividing trailing 12 months EBIT by interest expense.
gross_margin: Calculated by dividing trailing 12 months gross profit by revenue * 100%. Gross profit is calculated as revenue minus cost of goods sold.
net_profit_margin: Calculated by dividing trailing 12 months net income by revenue * 100%.
income_growth: Net income growth of the latest quarter over same quarter last year * 100%.
sales_growth: Revenue growth of the latest quarter over same quarter last year * 100%.
quick_ratio: Calculated by dividing current assets less inventories by current liabilities.
current_ratio: Calculated by dividing current assets by current liabilities.
return_on_assets: Calculated by dividing trailing 12 months net income by total assets * 100%.
return_on_equity: Calculated by dividing trailing 12 months net income by shareholder's equity * 100%.
dividend_rate: Trailing 12 months dividend per share.
payout_ratio: Calculated by dividing dividend rate by earnings per share * 100%.
yield: Calculated by dividing dividend rate by stock price per share * 100%.
institutional_ownership: The ratio of institutional holding shares amount to overall shares outstanding.
shares_outstanding: The overall shares outstanding (in million shares) documented as of recdate.
equity: Shareholder's equity ($1000 based).
assets: Total assets ($1000 based).
marketcap: Market capitalization ($1000 based) of the class of security.
revenue: Trailing 12 months sales revenue ($1000 based).
netincome: Trailing 12 months net income ($1000 based).
*_idsqt: Industry level quantile ranking score [0~1] of corresponding financial metric. Each metric was tuned independently so that higher score (i.e. closer to 1) represents better performance. Irrespective of whether the metric is the higher the better (e.g. "return_on_assets", "sales_growth"), or the lower the better (e.g. "pe", "p2b", "leverage_ratio","debt_equity_ratio").
*_secqt: Sector level quantile ranking score [0~1] of corresponding metric.
*_allqt: Market level quantile ranking score [0~1] of corresponding metric.
Balance Sheet
Balance sheet table contains financial data reported on balance sheet or equivalent (e.g. financial condition, financial position) of each XBRL filing. The information is extracted directly from XBRL-minisql. The currency units in balance sheet table are 1000 based. The table is constructed as shown below
CREATE TABLE `x_balancesheet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`fdate` date NOT NULL,
`currentassets` decimal(30,5) DEFAULT NULL,
`currentassetslessinventory` decimal(30,5) DEFAULT NULL,
`assets` decimal(30,5) DEFAULT NULL,
`currentliabilities` decimal(30,5) DEFAULT NULL,
`liabilities` decimal(30,5) DEFAULT NULL,
`shareholdersequity` decimal(30,5) DEFAULT NULL,
`shareholdersequityincludenoncontrol` decimal(30,5) DEFAULT NULL,
`liabilitiesandequity` decimal(30,5) DEFAULT NULL,
`shares_outstanding` decimal(30,5) DEFAULT NULL,
`otherequity` decimal(30,5) DEFAULT NULL,
`currency` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_cik_period` (`cik`,`period`),
KEY `index_cik` (`cik`),
KEY `index_symbol` (`symbol`),
KEY `index_period` (`period`),
KEY `index_fdate` (`fdate`)
) ENGINE=InnoDB AUTO_INCREMENT=1260602 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Field definition
symbol: Name of the trading symbol as reported in the XBRL filing. Note that same symbol might be reported by different companies in the same reporting period. So the CIK should be used for unique identification of a company.
cik: Central Index Key reported in the XBRL filing.
period: Period of report. There are four reporting periods per year.
fdate: The XBRL filing date.
currentassets: Current assets of the reporting company. Current assets are the assets that can easily be converted to cash within one operating cycle.
currentassetslessinventory: Current assets minus inventory.
assets: Total assets of the reporting company. Total Assets = Current Assets + Noncurrent Assets.
currentliabilities: Current liabilities of the reporting company. Current liabilities are a company's debts or obligations that are due within one year.
liabilities: Total liabilities of the reporting company. Total Liabilities = Current Liabilities + Noncurrent Liabilities.
shareholdersequity: Shareholder's equity of the reporting company. Shareholder's Equity = Total Assets - Total Liabilities - Non-controlling Interest (i.e. minority interest) - Redeemable Equity.
shareholdersequityincludenoncontrol: Shareholder's equity plus non controlling interest.
otherequity: Temporary or redeemable equity (in 1000 shares).
liabilitiesandequity: Total liabilities and shareholder's equity include non-controlling interest. This field should be equal to "assets" field.
shares_outstanding: Overall shares outstanding (in 1000 shares) of the reporting company for the reporting period.
currency: The type of currency used in the report (e.g. USD, JPY, CAD).
Income Statement
The table contains financial data reported on income statement or equivalent (e.g. earning statement, operation statement) of each XBRL filing. The information is extracted directly from XBRL-minisql. The currency units in income statement table are 1000 based. The table is constructed as shown below
CREATE TABLE `x_income` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`monthend` int(4) NOT NULL,
`fdate` date NOT NULL,
`revenue` decimal(30,5) DEFAULT NULL,
`costofsale` decimal(30,5) DEFAULT NULL,
`grossprofit` decimal(30,5) DEFAULT NULL,
`operatingexpenses` decimal(30,5) DEFAULT NULL,
`costsandexpenses` decimal(30,5) DEFAULT NULL,
`operatingincome` decimal(30,5) DEFAULT NULL,
`ebit` decimal(30,5) DEFAULT NULL,
`interestexpense` decimal(30,5) DEFAULT NULL,
`netincome` decimal(30,5) DEFAULT NULL,
`shares_outstanding` decimal(30,5) DEFAULT NULL,
`currency` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`sobasicanddiluted` decimal(30,5) DEFAULT NULL,
`epsbasicanddiluted` decimal(32,7) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_cik_period_monthend` (`cik`,`period`,`monthend`),
KEY `index_cik` (`cik`),
KEY `index_symbol` (`symbol`),
KEY `index_period` (`period`),
KEY `index_monthend` (`monthend`),
KEY `index_fdate` (`fdate`)
) ENGINE=InnoDB AUTO_INCREMENT=3300498 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Field definition
symbol: Name of the trading symbol as reported in the XBRL filing. Note that same symbol might be reported by different companies in the same reporting period. So the CIK should be used for unique identification of a company.
cik: Central Index Key reported in the XBRL filing.
period: Period of report. There are four reporting periods per year.
monthend: The record could be income statement for previous 3 or 12 months ended at the reporting period.
fdate: The XBRL filing date.
revenue: Total revenue.
costofsale: Cost of goods sold * -1.
grossprofit: Calculated by subtracting cost of goods sold from total revenue.
operatingexpenses: Operating expenses * -1.
costsandexpenses: Costs and expenses * -1.
operatingincome: Calculated by subtracting costs and expenses from total revenue.
ebit: Earnings before interest expenses and tax.
interestexpense: Interest expense * -1.
netincome: Self-explanatory.
shares_outstanding: Overall shares outstanding (in 1000 shares) of the reporting company for the reporting period.
sobasicanddiluted: Shares outstanding basic and diluted (in 1000 shares).
epsbasicanddiluted: Earnins per shares basic and diluted.
currency: The type of currency used in the report (e.g. USD, JPY, CAD).
Income Statement (Trailing 12 Months)
Similar to x_income table but for trailing 12 months data only
Statement of Cash Flow
The table contains financial data reported on statement of cashflow of each XBRL filing. The information is extracted directly from XBRL-minisql. The currency units in cash flow table are 1000 USD. The table is constructed as shown below
CREATE TABLE `x_cashflow` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`monthend` int(4) NOT NULL,
`fdate` date NOT NULL,
`investing` decimal(30,5) DEFAULT NULL,
`financing` decimal(30,5) DEFAULT NULL,
`operating` decimal(30,5) DEFAULT NULL,
`excheffect` decimal(30,5) DEFAULT NULL,
`cashchange` decimal(30,5) DEFAULT NULL,
`currency` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_cik_period` (`cik`,`period`),
KEY `index_cik` (`cik`),
KEY `index_symbol` (`symbol`),
KEY `index_period` (`period`),
KEY `index_monthend` (`monthend`),
KEY `index_fdate` (`fdate`)
) ENGINE=InnoDB AUTO_INCREMENT=3580884 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Field definition
symbol: Name of the trading symbol as reported in the XBRL filing. Note that same symbol might be reported by different companies in the same reporting period. So the CIK should be used for unique identification of a company.
cik: Central Index Key reported in the XBRL filing.
period: Period of report. There are four reporting periods per year.
monthend: The record could be income statement for previous 3, 6, 9, or 12 months ended at the reporting period.
fdate: The XBRL filing date.
investing: Cash provided by or used in investing activities.
financing: Cash provided by or used in financing activities.
operating: Cash provided by or used in operating activities.
excheffect: Effect of exchange rate on cash.
cashchange: Cash period increase/decrease.
currency: The type of currency used in the report (e.g. USD, JPY, CAD).
Shares outstanding history
The table contains shares outstanding history of companies publicly traded on the US market. The table is constructed as shown below
CREATE TABLE `x_so` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`stdsymbol` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`shares_outstanding` bigint(20) NOT NULL,
`metadata` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`secclass` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_cik_period_metadata` (`cik`,`period`,`metadata`),
KEY `index_symbol` (`symbol`),
KEY `index_stdsymbol` (`stdsymbol`),
KEY `index_cik` (`cik`),
KEY `index_period` (`period`)
) ENGINE=InnoDB AUTO_INCREMENT=1351213 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Field definition
symbol: Name of the trading symbol as reported in the XBRL filing.
stdsymbol: Name of the trading symbol for specific class of security.
cik: Central index key as reported in the XBRL filing.
period: The reporting period.
shares_outstanding: The amount of shares outstanding (x1).
metadata: Description about the record.
secclass: Class of the security.
Stock split history
The table contains both forward (many for 1) and reverse (1 for many) stock split history of companies publicly traded on the US market. The table is constructed as shown below
CREATE TABLE `splits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(30) NOT NULL,
`recdate` date NOT NULL,
`direction` smallint(1) NOT NULL,
`times` decimal(17,7) NOT NULL,
`sto` int(11) DEFAULT NULL,
`sfrom` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_splits_on_symbol_and_recdate` (`symbol`,`recdate`),
KEY `index_splits_on_recdate` (`recdate`)
) ENGINE=InnoDB AUTO_INCREMENT=724800 DEFAULT CHARSET=latin1
Field definition
symbol: Name of the trading symbol as reported in the XBRL filing.
recdate: Date of the closest saturday after a split takes effect.
direction: Either 0 or 1. 0 for reverse split (1 for many). 1 for forward split (many for 1).
times: E.g. a value equals to 2 means the stock has either 1 for 2, or 2 for 1 split. The direction of split is determined by "direction" field.