Excel Real Time Fields

Field	Description
Settle	For futures, the settlement price.
24 hour high	The rolling 24 hour high
24 hour low	The rolling 24 hour low
24 hour average	The rolling 24 hour average
24 hour open	The rolling 24 hour open
24 hour close	The rolling 24 hour close
Expiration	For options, the expiration date of the option.
Strike	For options, the strike price of the option.
Open Interest	For options, the open interest for the option.
Shares Outstanding	All shares currently owned by stockholders, company officials, and investors in the public domain.
Beta	Beta value for this stock
EPS Diluted Date/Time	The date and time of the last reported diluted EPS.
EPS Date/Time	The date and time of the last reported EPS.
Dividend Yield	The dividend per share, divided by the price per share.
EPS Diluted	The last reported diluted EPS for the company associated with the current symbol.
Dividend	The last reported dividend for the company associated with the current symbol.
EPS	The last reported EPS for the company associated with the current symbol.
PE Ratio	The last reported PE ratio for the company associated with the current symbol.
Price to Book Ratio	The last reported Price to Book ratio for the company associated with the current symbol.
Market Capitalization	The market-cap of the company associated with the symbol requested.
Short Interest	The quantity of stock shares that investors have sold short but not yet covered or closed out.
Description	Description of the symbol. Usually the name of the company associated with the current symbol.
Average Volume	The average of the last 30 trading days volume.
Security Type	The classification of the security
Close	The closing price of the symbol from the previous trading day.
Currency Code	The currency of the ticker.
Ask	The current best ask price.
Bid	The current best bid price.
Close Date/Time	The date and time of the previous closing price.
Year High Date	The date of the 52-week high.
Year Low Date	The date of the 52-week low.
Last Trade Date (Outside of market Hours)	The date of the last trade of current symbol (during pre/post market).
Last Trade Date	The date of the last trade of current symbol.
Last Trade Direction	The direction of the last trade.
Last Trade Exchange	The exchange on which the last trade occurred.
Year High	The highest price for equity during the past 52 weeks.
High	The highest price for the equity during the current trading day.
Year Low	The lowest price for equity during the past 52 weeks.
Low	The lowest price for the equity during the current trading day.
Bid Size	The number of shares bid at the current best bid price.
Ask Size	The number of shares offered at the current best ask price.
Last Trade Size	The number of shares traded in the last trade.
Open	The price at which the first trade occurred during market hours.
Last (Outside of Market Hours)	The price of the last trade of the current symbol the occurred outside of market hours.
Last	The price of the last trade of the current symbol.
Exchange	The primary exchange of the current symbol.
Last Trade Time (Outside of Market Hours)	The time of the last trade of current symbol (during pre/post market).
Last Trade Time	The time of the last trade of current symbol.
Volume	The volume of shares traded during the current trading day.
Time of last update to bid, ask, or trade	Time of last update to bid, ask, or trade
10 Day Moving Average	The sum of the previous 10 days close prices divided by 10.
10 Week Moving Average	The sum of the previous 10 weeks of close prices divided by the number of trade days in that 10-week period.
1 Year Annual Revenue Growth Rate	The year-over-year percent change in annual revenue.
200 Day Moving Average	The sum of the previous 200 days of close prices divided by 200.
30 Week Moving Average	The sum of the previous 30 weeks of close prices divided by the number of trade days in that 30-week period.
3 Year Annual Capital Spending Growth Rate	The 3-Year Growth Rate is the compound annual growth rate of capital spending, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (3) being considered.
3 Year Annual Dividend Growth Rate	The Three Year Annual Dividend Growth Rate is the average of the previous three year-over-year percent changes of the annual dividends. We take the AsOfDate, go back in time three calendar years and at each date prior, we sum the quarterly or semi-annual dividends going back one year. Those three data points, which are used in the calculation are summations of previous dividends.
3 Year Annual Income Growth Rate	The 3-Year Growth Rate is the compound annual growth rate of annual income, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (3) being considered.
3 Year Annual R&D Growth Rate	The 3-Year Growth Rate is the compound annual growth rate of research and development, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (3) being considered.
3 Year Annual Revenue Growth Rate	The 3-Year Growth Rate is the compound annual growth rate of annual revenue, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (3) being considered.
50 Day Moving Average	The sum of the previous 50 days close prices divided by 50.
5 Day Moving Average	The sum of the previous 5 days close prices divided by 5.
5 Year Annual Capital Spending Growth Rate	The 5-Year Growth Rate is the compound annual growth rate of capital spending, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (5) being considered.
5 Year Annual Dividend Growth Rate	The Five Year Annual Dividend Growth Rate is the average of the previous five year-over-year percent changes of the annual dividends. We take the AsOfDate, go back in time five calendar years and at each date prior, we sum the quarterly or semi-annual dividends going back one year. Those five data points, which are used in the calculation are summations of previous dividends.
5 Year Annual Income Growth Rate	The 5-Year Growth Rate is the compound annual growth rate of annual income. This figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (5) being considered.
5 Year Annual R&D Growth Rate	The 5-Year Growth Rate is the compound annual growth rate of research and development, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (5) being considered.
5 Year Annual Revenue Growth Rate	The 5-Year Growth Rate is the compound annual growth rate of annual revenue, this figure is derived by taking the nth root of the total percentage growth rate, where n is the number of years in the period (5) being considered.
5 Year Average Debt Equity Ratio	The sum of the previous 5 years of long-term debt divided by the sum of the previous 5 years of common stock equity, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year Average Gross Profit Margin	The sum of the previous 5 years of revenue minus the sum of the previous 5 years cost of goods divided by the sum of the previous 5 years revenue, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year Average Net Profit Margin	The sum of the previous 5 years of net income from continuing and discontinued operations divided by the sum of the previous 5 years of revenue, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year Average PERatio	The arithmetic average of the year-end P/E ratio for each of the past 5 fiscal years.
5 Year Average Pre Tax Profit Margin	The sum of the previous 5 years of pre-tax earnings from continuing operations (not including discontinued or extraordinary items) divided by the sum of the previous 5 years of revenue, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year Average R&D As Percent Of Sales	The average of the previous 5 years of Research and Development expenses divided by the average of the previous 5 years of revenue, data taken from the annual reports
5 Year Average Return On Equity	The average of the previous 5 years of Return on Equity values, the Net Income from Total Operations divided by Common Equity, data taken from the annual reports
5 Year Average Return On Assets	The average of the previous 5 years of Return on Asset values, the earnings from total operations (not including extraordinary items) divided by total assets, expressed as a percentage, data taken from the annual reports
5 Year Average Return On Invested Capital	The sum of the previous 5 years of Net Income from Total Operations divided by the sum of the previous 5 years Invested Capital, data taken from the annual reports (5 Year Average).
5 Year Average SG&A As Percent Of Sales	The sum of the previous 5 years of selling, general and administrative expenses divided by the sum of the previous 5 years of revenue, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year Average Total Debt Equity Ratio	The sum of the previous 5 years of short-term debt and long-term debt divided by the sum of the previous 5 years of common stock equity, expressed as percentage-data taken from the annual reports (5 Year Average).
5 Year High PERatio	For each of the past 5 fiscal years, we calculate the following ratio: The highest price a stock had (intra-day trading) for that calendar year / that fiscal year's EPS. 5-Year High P/E is the highest of those 5 ratios.
5 Year High Price	The highest of all the (intra-trading day) highs during the preceding 5 years.
5 Year Low PERatio	For each of the past 5 fiscal years, we calculate the following ratio: Lowest Price a stock had (intra-day trading) for that calendar year / that fiscal years EPS. The 5-Year Low P/E is the lowest of those 5 ratios.
5 Year Low Price	The lowest of all the (intra-trading day) lows during the preceding 5 years.
Accounts Payable	Represents the claims of trade creditors for unpaid goods or services that are due within the normal operating cycle of the company.
Accounts Payable (Cash Flow)	Represents the change in the amount of accounts payable from one year to the next as reported in the cash flow statement.
Accounts Receivable Change	Represents the change in the amount of receivables net of allowances from one year to the next.
Accounts Receivables Days	Returns receivables days for the period and date(s) requested.
Accounts Receivables Net	Represents claims against customers for merchandise sold or services performed in the ordinary course of business.
Accrued Expenses	Returns accrued expenses for the period and date(s) requested in local currency by default.
Accumulated Depreciation	Represents expense related to the fixed assets still carried on the books of the company. Sometimes the term reserve for depreciation is used.
Accumulated Depreciation - Construction in Progress	Accumulated Depreciation - Construction in Progress.
Accumulated Depreciation - Machinery & Equipment	Represents the portion of accumulated depreciation that relates to the reduction in the useful economic life of the machinery and equipment.
Accumulated Minority Interest	Represents the portion of the net worth (at par or stated value) of a subsidiary pertaining to shares not owned by the controlling company and its consolidated subsidiaries. If minority interest is shown on the asset side, it is updated as a negative and the total assets are adjusted to exclude it.
Accumulated Other Compensation Income - Other Adjustments	Accum Other Comp Inc - Other Adjustments.
Additional Paid - In Capital or Capital Surplus (including Deferred Compensation)	Represents the amount received in excess of par value from the sale of common stock. Along with common stock it is the equity capital received from parties outside the company.
Company Address - Line 1	Represents the current location of the corporate offices of a company
Company Address - Line 2	Represents the current location of the corporate offices of a company
ADR To Common Share Ratio	Represents the relationship between the American Depositary Receipt and the common share represented by the ADR. For example, an ADR ratio of 5 represents that 5 shares of the ADR are equivalent to 1 outstanding share. This multiplier is used to adjust the shares of the underlying non-U.S. company to arrive at the ADRequivalent shares. It is the reciprocal of the ADR exchange ratio.
Amortization of Intangible Assets	Represents the cost allocation for intangible assets such as patents and leasehold improvements, trademarks, book plates, tools and film costs. It is a non-cash charge.
Asset Turnover	Returns asset turnover for the period and date(s) requested in local currency by default.
Auditors Opinion	Code Description: 01 Not audited, 02 No audit report in abbreviated version, 03 Partial audit (not all statements audited), 04 Consolidated statements appear not to be audited, but parent company statements audited, 05 Qualified, 06 Unqualified
Average Daily Percent Price Change 4 Weeks	The average daily percent price change over the last 4 weeks. This value is calculated as follows: avg(abs((closing price-opening price)/opening price)) where abs() is the absolute value and avg() is the average.
Average Daily Percent Volume Change 4 Weeks	The average daily percent volume change over the last 4 weeks. This value is calculated as follows: avg(abs((closing The average daily percent volume change over the last 4 weeks. This value is calculated as follows: avg(abs((volume-AverageDailyVolumeLast4weeks)/AverageDailyVolumeLast4weeks)) where abs() is the absolute value and avg() is the average.-opening price)/opening price)) where abs() is the absolute value and avg() is the average.
Average Daily Volume Last 10 Days	Total volume for the previous 10 days divided by the actual number of trade days of the previous 10 days.
Average Daily Volume Last 12 Months	Total volume for the previous 12 months divided by the actual number of trade days of the previous 12 months.
Average Daily Volume Last 13 Weeks	Total volume for the previous 13 weeks divided by the actual number of trade days of the previous 13 weeks.
Average Daily Volume Last 20 Days	Total volume for the previous 20 days divided by the actual number of trade days of the previous 20 days.
Average Daily Volume Last 26 Weeks	Total volume for the previous 26 weeks divided by the actual number of trade days of the previous 26 weeks.
Average Daily Volume Last 2 Weeks	Total volume for the previous 2 weeks divided by the actual number of trade days of the previous 2 weeks.
Average Daily Volume Last 3 Months	Total volume for the previous 3 months divided by the actual number of trade days of the previous 3 months.
Average Daily Volume Last 4 Weeks	Total volume for the previous 4 weeks divided by the actual number of trade days of the previous 4 weeks.
Average Daily Volume Last 52 Weeks	Total volume for the previous 52 weeks divided by the actual number of trade days of the previous 52 weeks.
Average Daily Volume Last 6 Months	Total volume for the previous 6 months divided by the actual number of trade days of the previous 6 months.
Average Daily Volume Last 9 Months	Total volume for the previous 9 months divided by the actual number of trade days of the previous 9 months.
Average Daily Volume Last Month	Total volume for the previous month divided by the actual number of trade days of the previous month.
Average Daily Volume YTD	Total volume for the current year divided by the actual number of trade days of the current year.
Beta	The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a minimum of 30 days to a maximum of 3 years (however much is available) historical regression of the daily returns on the stock onto the daily returns on the S&P 500: Ri = a + b(Rm) + e where Ri is the monthly total returns on the stock, a is the stock's Alpha, b is the stock's Beta (this fundamental), Rmis the monthly total returns on the market (S&P 500), and e is a random error term. A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down. A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare. A beta of 0 means there is no correlation between the stock and the market. Note that this value may be different than the other Beta values
Beta 12 Month	The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a 12-month historical regression of the return on the stock onto the return on the S&P 500: Ri = a + b(Rm) + e where Ri is the monthly total returns on the stock, a is the stock's Alpha, b is the stock's Beta, Rmis the monthly total returns on the market (S&P 500), and e is a random error term. A minimum of 12 monthly returns are required for this calculation. A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down. A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare.
Beta 24 Month	The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a 24-month historical regression of the return on the stock onto the return on the S&P 500: Ri = a + b(Rm) + e where Ri is the monthly total returns on the stock, a is the stock's Alpha, b is the stock's Beta, Rmis the monthly total returns on the market (S&P 500), and e is a random error term. A minimum of 12 monthly returns are required for this calculation. A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down. A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare.
Beta 36 Month	The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a 36-month historical regression of the return on the stock onto the return on the S&P 500: Ri = a + b(Rm) + e where Ri is the monthly total returns on the stock, a is the stock's Alpha, b is the stock's Beta, Rmis the monthly total returns on the market (S&P 500), and e is a random error term. A minimum of 12 monthly returns are required for this calculation. A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down. A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare.
Beta 60 Month	The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a 60-month historical regression of the return on the stock onto the return on the S&P 500: Ri = a + b(Rm) + e where Ri is the monthly total returns on the stock, a is the stock's Alpha, b is the stock's Beta, Rmis the monthly total returns on the market (S&P 500), and e is a random error term. A minimum of 12 monthly returns are required for this calculation. A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down. A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare.
Book Value	The same as shareholder's equity. Calculated by (Total Assets - Total Liabilities). This is the total book value, as derived from the latest balance sheet.
Book Value Per Share	Represents book value (proportioned common equity divided by outstanding shares) at the company's fiscal year end.
Business Description	Represents the current business description.
Capital Expenditures	Returns total capital expenditures for the period and date(s) requested in local currency by default.
Capital Expenditures Fixed Assets	Represents the funds used to acquire fixed assets other than those associated with acquisitions.
Cash Dividends Paid	Represents the total common and preferred dividends paid to shareholders of the company.
Cash & Equivalents - Generic	Returns cash and equivalents for the period and the dates requested in local currency by default. This represents Cash and Due from Banks excluding Restricted Cash for Banks, Cash excluding Restricted Cash for Insurance companies, and Cash and Short-Term Investments excluding Restricted Cash for all other industries.
Cash Flow Per Share	Returns the current cash flow per share. This is calculated as Funds from Operations divided by Common Shares Outstanding.
Cash Per Share	Represents money available for use in the normal operations of the company. It is the most liquid of all of the company's assets.
Cash & Short Term Investments	Represents the sum of cash and short term investments.
Chief Executive Officer	Returns the current CEO of the company
Change in Capital Stock	Returns sale/repurchase of stock, net for the period and date(s) requested in local currency by default.
Change in Current Debt	Represents the increase or decrease in short-term borrowings from one year to the next as reported in the cash flow statement.
Changes in Working Capital	Represents the net change in working capital apart from the increase/decrease in short term borrowings and increase/decrease in cash & equivalents.
City	Returns the current city where the company is headquartered
Common Shares Outstanding - Security Level	Represents the number of shares outstanding at the company's year end. It is the difference between issued shares and treasury shares. This value is at the security-level.
Common Shares Used to Calculate EPS - Fully Diluted	Represents the average annual number of shares used by the company in computing its fully diluted earnings per share from the Income Statement, if reported by the company.
Common Stock Par or Carry Value	Represents the par or stated value of the issued common shares of the company. It includes the value of all multiple shares. Along with capital surplus it is the equity capital received from parties outside the company.
Company Founded Date	Returns the company founded date of the security or securities requested
Company Name	Represents the legal name of the company as reported in the 10-K for U.S. companies and the annual report for non-U.S. Companies
Consolidated Net Income	Represents consolidated net income for the period and date(s) requested in local currency by default.
Corporate Location - Country	Represents the location of the corporate offices of a company.
Cost of Goods Sold (COGS) including Depreciation and Amortization	Returns the cost of goods sold for the period and date(s) requested in local currency by default.
Cumulative Translation Adjustment	Represents the gains and losses from the translation of foreign currency. These amounts are not recognized as part of the current income but will be realized when the foreign entity is sold or liquidated. It is shown as part of Shareholders' Equity and is based on the current rate of exchange.
Currency	The currency associated with this security's fundamental types.
Current Ratio	Returns the current ratio for the period and date(s) requested in local currency by default.
Current Revenue Per Employee	The TTM revenue divided by the latest employee number.
Customer Liability on Acceptances	Represents funds from customers (usually borrowed from the bank), which by agreement are deposited in the bank. The agreement is supported by a letter of credit, which alloFF the funds to be used only for a specific purpose.
Daily Volume As Percent Of 10 Day Average Volume	Volume from the latest trading session divided by the average volume for the previous 10 days, expressed as a percentage.
Date Of 52 Week High	The date of the 52-Week High
Date Of 52 Week Low	The date of the 52-Week Low.
Days Sales Outstanding	The average collection period. It indicates the average length of time a firm must wait after making a sale before it receives payment. Equals Accounts Receivable divided by Sales, multiplied by 365 (TTM).
Days Sales Outstanding - Time Weighted	The time-weighted collection period. It indicates the length of time a firm must wait after making a sale before it receives payment. Equals Accounts Receivable divided by Sales, multiplied by Accounts Receivables Days (TTM). Accounts Receivables Days is the number of days that a customer invoice is outstanding before it is collected.
Capital Leases	Debt Capital Leases.
Other Receivables	Debt Other Receivables.
Decrease in Deposits	Decrease in Deposits.
Decrease in Loans	Represents the decrease in loans from one period to the next. It includes: principal collected on loans and leases and proceeds from loan sales. This item is typically found under Investing Activities in a Cash Flow Statement.
Deferred Tax Assets	Represents the debit balance of the deferred tax account. It is the amount of tax benefit which has been deferred to some future period.
Deferred Taxes	Represents the accumulation of taxes which are deferred as a result of timing differences between reporting sales and expenses for tax and financial reporting purposes.
Deferred Taxes (excluding Investment Tax Credits)	Represents the increase or decrease in the deferred tax liability from one year to the next resulting from timing differences in recognition of revenue and expenses for tax and financial reporting purposes. It is a non-cash charge.
Deferred Taxes & Investment Tax Credit	Represents the increase or decrease in the deferred tax liability from one year to the next resulting from timing differences in recognition of revenue and expenses for tax and financial reporting purposes. Deferred taxes are shown net of investment tax credits.
Deferred Tax Liabilities	Represents the credit balance of the deferred tax account. It is the amount of tax charge which has been deferred to some future period.
Depreciation & Amortization	Depreciation represents the process of allocating the cost of a depreciable asset to the accounting periods covered during its expected useful life to a business. It is a non-cash charge for use and obsolescence of an asset.
Depreciation	Depreciation represents the process of allocating the cost of a depreciable asset to the accounting periods covered during its expected useful life to a business.
Depreciation or Depletion (excluding Amortization)	Depreciation represents the process of allocating the cost of a depreciable asset to the accounting periods covered during its expected useful life to a business. It is a non-cash charge.
Dividend Ex-Date	Represents the date on or after which a buyer will no longer be entitled to the dividend declared on a share.
Dividend Ex-Date, Semi-Annual	Represents the date on or after which a buyer will no longer be entitled to the dividend declared on a share for a semi-annual reporting entity.
Payout Ratio	The TTM dividend per share divided by TTM EPS, expressed as a percentage. The percentage indicates the percent of EPS that was paid out as a dividend.
Dividend Rate	The dividend rate equals the number of times the company pays dividends per year multiplied by the latest dividend, expressed in the currency that the security is traded in.
Dividends Per Share LTM- Security	Represents the sum of the interim dividends per share, including extras, declared by the company in the last twelve months at the security-level. If interim data is not available it is the most recent dividends per share reported by the company in the last two years.
Dividends Per Share - Security	Represents the total dividends per share declared, including extra dividends for the period and date(s) requested in local currency by default.
Dividends Per Share - Security, Semi-Annual	Represents the total semi-annual dividends per share declared, including extra dividends for the period and date(s) requested in local currency by default for a semi-annual-reporting entity.
Dividend Yield - Daily	Returns the dividends per share divided by the most recent Last Close price, multiplied by 100, for the period and date(s) requested in local currency by default.
Dividend Yield - Fiscal	Returns the dividends per share divided by the fiscal period end price, multiplied by 100, for the period and date(s) requested in local currency by default. This value is available on an Annual basis, at the end of a company's fiscal calendar year.
Dividend Yield - Security	Returns the dividends per share divided by the fiscal period end price, multiplied by 100, for the period and date(s) requested in local currency by default. This value is available on an Annual basis, at the end of a company's fiscal calendar year. This value is on the security-level.
Dollar Volume 1 Week	The total dollar volume in a security during a given week.
Country Of Domicile	Country code for the company's country of domicile
Earnings Growth	The difference between the latest TTM earnings from total operations and the TTM earnings one year prior, expressed as a percentage
EBITDA	Returns EBITDA (Operating Income Plus Depreciation & Amortization) for the period and date(s) requested in local currency by default.
EBITDA (From Cash Flow)	Returns earnings before interest, taxes, depreciation & amortization (EBITDA) with preference for depreciation & amortization from the Cash Flow statement for the period and date(s) requested in local currency by default.
EBITDA Margin	Returns the EBITDA divided by Net Sales, expressed as a percentage.
EBIT Margin	Returns the EBIT margin for the period and date(s) requested.
EBIT (Operating Income)	Returns EBIT (Operating Income) for the period and date(s) requested in local currency by default.
EBIT Per Share	Represents the average annual number of shares used by the company in computing its fully diluted earnings per share from the Income Statement, if reported by the company.
Earnings Per Share - Fiscal Period	Represents fiscal period earnings for the requested time period.
EPS - Basic - Before Extraordinaries	Returns basic earnings per share before extraordinaries for the period and date(s) requested in local currency by default.
EPS (Recurring)	Represents diluted earnings per share before unusual expenses for the period and date(s) requested in local currency by default.
EPS From Continuing Operations	Represents the per share amount earned by a company before any gain/loss adjustment for discontinued operations and extraordinary items but after preferred dividends are deducted.
EPS (Diluted)	The TTM diluted earnings per share from total operations.
Earnings Per Share - Security Level	Represents fiscal period earnings for the requested time period at the security-level.
Equity in Earnings of Affiliates Income	Represents that portion of the earnings or losses of a subsidiary whose financial accounts are not consolidated with the controlling company's assets.
Exchange Rate Effect	Represents the effect of translating from one currency to another on the cash flow of the company.
Extraordinary Gains or Losses from Sale of Asset	Extraordinary gains or losses from the sale of an asset.
Extraordinary Item	Represents gains and losses resulting from non-recurring unusual events.
Extraordinary Items (Including Accounting Change)	Returns extraordinary items including accounting change for the period and date(s) requested in local currency by default.
FactSet Company Entity ID	FactSet Company Entity ID.
Fax Number	FAX number for company as given in the latest report.
Federal Home Loan Advances Increase (Decrease)	Federal Home Loan Advances Increase (Decrease).
Filing Status	Represents the update status for the period and date(s) requested. Possible values are: Final, Preliminary, or Blank, if the update is not available.
Fiscal Period End Date	The Fiscal Period End Date (YYYYMM).
Fiscal Period Length - Days	Returns the fiscal period length in days
Fiscal Period - Start Date	The Fiscal Period Start Date
Float	Returns the annual shares outstanding less closely held shares (float) for the fiscal year for the date(s) requested.
Float As Percent Of Shares Outstanding	Float divided by Latest shares outstanding, expressed as a percentage.
Float - Current	Returns the current shares outstanding less closely held shares (float)
Foreign Currency Adjustment (Net)	Represents realized foreign currency gains and losses. Transaction gains or losses happen when the exchange rate changes between the date of purchase and the date of sale.
Free Cash Flow	Returns free cash flow for the period and date(s) requested in local currency by default.
Free Cash Flow Per Share (Diluted)	Returns free cash flow per share (diluted) for the period and date(s) requested.
Funds from Operations	Represents the sum of net income and all non-cash charges or credits. It is the cash flow of the company.
General Industry Classification	This item represents the company's general industry classification. This is different from, but related to the type of financial statement template applied to the company. Valid types are Industrial, Utility, Transportation, Bank, Insurance and Other Financial. Companies with a GeneralIndustryClassification type of Industrial, Utility or Transportation will have a StatementTemplate type of Industrial. Companies with a GeneralIndustryClassification type of Bank will have a StatementTemplate type of Bank. Companies with a GeneralIndustryClassification type of Insurance will have a StatementTemplate type of Insurance. Companies with a GeneralIndustryClassification type of Other Financial will have a StatementTemplate type of OtherFinancial.
Gross Income	Represents the difference between sales or revenues and cost of goods sold and depreciation.
Gross Income Margin	Returns gross income margin for the period and date(s) requested. This is calculated as Gross Income divided by Net Sales or Revenue multiplied by 100.
High Price Last 13 Weeks	The highest of all the (intra-trading day) highs during the preceding 13 weeks.
High Price Last 26 Weeks	The highest of all the (intra-trading day) highs during the preceding 26 weeks.
High Price Last 3 Months	The highest of all the (intra-trading day) highs during the preceding 3 months.
High Price Last 4 Weeks	The highest of all the (intra-trading day) highs during the preceding 4 weeks.
High Price Last 52 Weeks	The 52-Week High Price The highest of all the (intra-trading day) highs during the preceding 52 weeks.
High Price Last 6 Months	The highest of all the (intra-trading day) highs during the preceding 6 months.
High Price Last 9 Months	The highest of all the (intra-trading day) highs during the preceding 9 months.
High Price MTD	The highest of all the (intra-trading day) highs during this month.
High Price YTD	The highest of all the (intra-trading day) highs during the past year-to-date.
Income Taxes	Represents all income taxes levied on the income of a company by federal, state and foreign governments.
Income Tax Payable	Represents an accrued tax liability which is due within the normal operating cycle of the company.
Increase in Deposits	Increase in Deposits.
Increase in Loans	Represents the increase in loans from one period to the next. It includes: loans originated or acquired, leases made to customers, purchase of loan portfolios. This item is typically found under Investing Activities in a Cash Flow Statement.
Industry	This item represents the FactSet industry classification of the issuing company for this security.
Industry Name	This item represents the FactSet industry classification of the issuing company for this security, with spaces.
Instrument Class	Returns the Instrument Class of the security or securities requested
Instrument Level Industry	Returns the Industry of the company on the Instrument-Level, primarily can be used to classify non-equities.
Instrument Level Sector	Returns the Sector of the company on the Instrument-Level, primarily can be used to classify non-equities.
Insurance Policy Liabilities - Insurance	Represents the sum of benefit and loss reserves, unearned premiums, policy and contract claims and other reserves.
Intangible Assets	Represents other assets not having a physical existence. The value of these assets lie in their expected future return.
Interest Expense	Returns interest expense, net of interest capitalized for the period and date(s) requested in local currency by default.
Interest Income	Represents income received from all earning assets such as loans and investment securities.
Interest Receivables	Represents all the interest income due but not yet collected.
Inventories	Represents tangible items or merchandise net of advances and obsolescence acquired for either (1) resale directly or (2) included in the production of finished goods manufactured for sale in the normal course of operation.
Inventories (Cash Flow)	Represents the change in the amount of inventories from one year to the next as reported in the cash flow statement.
Inventories - Finished Goods	Represents the inventory of goods which are ready for sale.
Inventories - Progress Payments & Other	Represents other inventories effecting Total Inventories but not included in Finished goods, Work in Process or Raw Materials.
Inventories - Raw Materials	Represents the inventory of raw materials or supplies that indirectly or directly enter into the production of finished goods.
Inventories - Work In Progress	Represents the inventory of products which are in various stages of production. Data for this field is generally not available prior to 1989.
Investment in Unconsolidated Affiliates	Represents long-term investments and advances in unconsolidated affiliates in which the company has a business relationship or exercises control. It includes joint ventures.
Investment Securities	Represents securities owned by the firm as part of their portfolio.
Investments and Long-Term Receivables	Returns investments and LT Receivables for the period and date(s) requested in local currency by default.
Investor Relations Email	Represents the e-mail address of the investor relations contact.
ISO Country Code	ISO Country Code.
Issuance or Reduction of Debt, Net	Returns net issuance/reduction of debt for the period and date(s) requested in local currency by default.
Last Close	The close price of the latest trade day. Requires a subscription to XigniteGlobalHistorical.
Last High	The high price of the latest trading day. Requires a subscription to XigniteGlobalHistorical.
Last Low	The low price of the latest trading day. Requires a subscription to XigniteGlobalHistorical.
Last Open	The open price of the latest trade day. Requires a subscription to XigniteGlobalHistorical.
Last Trade Date	The date of the latest stock trading day. Requires a subscription to XigniteGlobalHistorical.
Last Volume	The volume of the latest trading day. Requires a subscription to XigniteGlobalHistorical.
Latest Close As Percent Of 10 Day Average	The latest close price divided by the 10 day average price, expressed as a percentage.
Latest Close As Percent Of 10 Week Average	The latest close price divided by the 10 week average price, expressed as a percentage.
Latest Close As Percent Of 200 Day Average	The latest close price divided by the 200 day average price, expressed as a percentage.
Latest Close As Percent Of 30 Week Average	The latest close price divided by the 30 week average price, expressed as a percentage.
Latest Close As Percent Of 52 Week High	The latest close price divided by the high price for the previous 52 weeks, expressed as a percentage.
Latest Close As Percent Of 52 Week Low	The latest close price divided by the low price for the previous 52 weeks, expressed as a percentage.
Latest Close As Percent Of 5 Day Average	The latest close price divided by the 5 day average price, expressed as a percentage.
Latest Close As Percent Of 5 Year High	The latest close price divided by the high price for the previous 5 years, expressed as a percentage.
Latest Close As Percent Of 5 Year Low	The latest close price divided by the low price for the previous 5 years, expressed as a percentage.
Leverage Ratio	The total assets divided by total stockholder's equity (TTM).
Loan Loss Provision	Represents losses that the bank expects to take as a result of uncollectible or troubled loans.
Business Description - Extended	Returns the long business description of a company.
Long Term Debt	Represents all interest-bearing financial obligations, excluding amounts due within one year. It is shown net of premium or discount.
Long Term Debt To Equity Ratio	Returns long term debt as a percent of shareholder's equity for the period and date(s) requested in local currency by default.
Long Term Debt To Total Capital	Returns long term debt as a percent of total capital for the period and date(s) requested in local currency by default.
Long-Term Note Receivable	Represents amounts due from customers which will not be collected within the normal operating cycle of the company.
Losses, Claims & Reserves	Returns Losses, Benefits, Adjusted & LT Reserves for the period and date(s) requested in local currency by default.
Low Price Last 13 Weeks	The lowest of all the (intra-trading day) lows during the preceding 13 weeks.
Low Price Last 26 Weeks	The lowest of all the (intra-trading day) lows during the preceding 26 weeks.
Low Price Last 3 Months	The lowest of all the (intra-trading day) lows during the preceding 3 months.
Low Price Last 4 Weeks	The lowest of all the (intra-trading day) lows during the preceding 4 weeks.
Low Price Last 52 Weeks	The lowest of all the (intra-trading day) lows during the preceding 52 weeks.
Low Price Last 6 Months	The lowest of all the (intra-trading day) lows during the preceding 6 months.
Low Price Last 9 Months	The lowest of all the (intra-trading day) lows during the preceding 9 months.
Low Price MTD	The lowest of all the (intra-trading day) lows during this month.
Low Price YTD	The lowest of all the (intra-trading day) lows during the past year-to-date.
Market Capitalization	The latest close price multiplied by the number of common shares outstanding.
Market Capitalization - Fiscal	Returns the market value using the fiscal period-end price for the period and date(s) requested in local currency by default.
Market Capitalization Fully Diluted	Returns the Market Capitalization by multiplying the fully-diluted shares outstanding by the last closing price
Market Capitalization - Security Level	Represents market value using fiscal period-end price for the period and date(s) requested in local currency by default. This is calculated as the previous close price multiplied by Common Shares Outstanding.
Minority Interest Expense	Represents the portion of earnings/losses of a subsidiary pertaining to common stock not owned by the controlling company or other members of the consolidated group.
Miscellaneous Funds	Returns miscellaneous funds for the period and date(s) requested in local currency by default.
NAICS Code	Company NAICS Code.
Net Assets From Acquisitions	Represents assets acquired through pooling of interests or mergers. It does not include capital expenditures of acquired companies.
Net Change in Cash	Represents the change in cash and short term investments from one year to the next. This item is available only when the Statement of Changes in Financial Position is based on cash and short term investments.
Net Financing Cash Flow	Returns net cash from financing activities for the period and date(s) requested in local currency by default.
Net Goodwill	Represents the excess cost over the fair market value of the net assets purchased. It is included in other intangible assets.
Net Income - After Extraordinary Items	Returns net income after extrardinary items for the period and date(s) requested in local currency by default.
Net Income Available to Common	Returns net income available to common basic EPS before extraordinaries for the period and date(s) requested in local currency by default.
Net Income (Starting Line)	Represents the beginning figure of the sources and uses statement as defined by the company. For U.S. corporations, it is usually the net income reported by the company before discontinued operations, extraordinary items and provision for preferred and common dividends.
Net Income From Continuing Operations	Returns net income for the period and date(s) requested. Excludes discontinued operations. Represents income before extraordinary items and preferred and common dividends, but after operating and non-operating income and expenses, minority interest and equity in earnings.
Net Income From Total Operations	Net income from total operations.
Net Interest Income	Represents the difference between the total interest income and total interest expense of the bank.
Net Interest Income after Loan Loss Provision	Returns net interest after loan loss provision for the period and date(s) requested in local currency by default.
Net Investing Cash Flow	Returns net cash from investing activities for the period and date(s) requested in local currency by default.
Net Loans	Represents the total amount of money loaned to customers after deducting reserves for loan losses.
Net Operating Cash Flow	Returns net cash from operating activities for the period and date(s) requested in local currency by default.
Net Property, Plant & Equipment	Represents Gross Property, Plant and Equipment less accumulated reserves for depreciation, depletion and amortization.
Non-Equity Reserves	Represents a reserve set aside from shareholders' equity with no designated payee. This item is only applicable to non-U.S. corporations.
Non-Interest Expense	Represents all expenses of the bank except interest expense and provision for loan losses.
Non-Interest Income - Banks	Represents all other operating revenues of the bank besides interest income.
Non-Operating Expense	Returns total non-operating income for the period and date(s) requested in local currency by default.
Non-Operating Income (Expense)	Returns total non-operating income for the period and date(s) requested in local currency by default.
Notes Payable	Notes Payable.
Number of Employees	Represents the number of both full- and part-time employees of the company.
Operating Income	Represents the difference between sales and total operating expenses.
Operating Income after Interest Expense	Returns operating income after interest expense for the period and date(s) requested in local currency by default.
Operating Income After Unusual Items	Returns operating income after unusual items for the period and date(s) requested in local currency by default.
Operating Income before Interest Expense	Returns operating income before interest expense for the period and date(s) requested in local currency by default.
Operating Lease Expense	Represents the amount of rental expense paid for operating leases during the year.
Operating Margin	Returns operating margin for the period and date(s) requested. This is calculated as Operating Income divided by Net Sales or Revenue, multiplied by 100.
Ordinary Income	Represents the operating profit plus any non-operating income minus any non-operating expense before any extraordinary items. This item is only available for Japanese companies.
Other Accruals	Represents the change in the amount of accruals from one year to the next as reported in the cash flow statement.
Other After Tax Adjustments	Represents miscellaneous items reported net of tax which are included in the company's net income.
Other Assets	Returns other assets for the period and date(s) requested in local currency by default.
Other Current Assets	Returns other current assets for the period and date(s) requested in local currency by default.
Other Current Liabilities	Returns other current liabilities for the period and date(s) requested in local currency by default.
Other Financing Activities (Sources)	Represents any other funds derived from financing activities not included in additions to stock, proceeds from stock options, long-term borrowings, increase/decrease of short-term debt, reduction of long-term debt, total cash dividends paid or common/preferred redeemed, retired, converted or purchased.
Net Financing Active Other Cash Flow	Returns other financing activities for the period and date(s) requested in local currency by default.
Other Funds (Non Cash)	Represents non-cash items included in funds from operations other than net income, depreciation, depletion and amortization, and deferred taxes. In cases where the start line reported by the company is other than net income some cash items may be included.
Other Intangible Assets	Represents all other assets of the company besides current assets, long term receivables, investment in unconsolidated subsidiaries, other investments and net property, plant and equipment.
Other Liabilities	Returns other liabilities for the period and date(s) requested in local currency by default.
Other Liabilities (excluding Deferred Revenue)	Represents all other liabilities of the company besides current liabilities, long-term debt, provision for risk and charges and deferred taxes.
Other Operating Expense	Represents all other operating expenses besides interest expense, salaries and benefits expense, equipment expense and provision for loan losses.
Other Sources	Represents any other funds derived from the investing activities and not included in capital expenditures, net assets from acquisitions, increase in investments or additions to property. It includes but is not restricted to: decrease in federal funds sold, decrease in securities purchased under agreements to resell, increase in bank card receivables and collection of longer-term loans. This item is typically found under Investing Activities in a Cash Flow Statement.
Other Uses	Represents any other funds employed in investing activities and not included in capital expenditures, net assets from acquisitions, increase in investments, decrease in investments or additions to property.
Price to Earnings Growth Ratio	The trailing PEGRatio is the PERatio divided by the annual trailing EPS growth rate as of the AsOfDate.
PE Ratio	Returns price divided by earnings per share for the period requested, using the most recent close price within that period.
PE Ratio - Fiscal	Returns the close price divided by earnings per share using the fiscal period-end price for the period and date(s) requested in local currency by default. For quarterly or semi-annual periodicities, this formula uses a 12-month Earnings Per Share figure.
PE Ratio - Security Level	Returns price to earnings per share for the period and date(s) requested. This is calculated as the close price divided by the Earnings Per Share - Fiscal Period value at the security-level.
Percent Of Shares Outstanding Held By Insiders	Returns the percent of shares outstanding held by insiders. The value is calculated using the following formula: SharesCloselyHeld/ SharesOutstanding
Percent Price Change 10 Days	The percentage change in the latest close price of the stock vs. the close price 10 days ago.
Percent Price Change 13 Weeks	The percentage change in the latest close price of the stock vs. the close price 13 weeks ago.
Percent Price Change 1 Week	The percentage change in the latest close price of the stock vs. the close price one week ago.
Percent Price Change 26 Weeks	The percentage change in the latest close price of the stock vs. the close price 26 weeks ago.
Percent Price Change 2 Weeks	The percentage change in the latest close price of the stock vs. the close price 2 weeks ago.
Percent Price Change 3 Months	The percentage change in the latest close price of the stock vs. the close price 3 months ago.
Percent Price Change 4 Weeks	The percentage change in the latest close price of the stock vs. the close price 4 weeks ago.
Percent Price Change 52 Weeks	The percentage change in the latest close price of the stock vs. the close price 52 weeks ago.
Percent Price Change 6 Months	The percentage change in the latest close price of the stock vs. the close price 6 months ago.
Percent Price Change 9 Months	The percentage change in the latest close price of the stock vs. the close price 9 months ago.
Percent Price Change MTD	The percentage change in the latest close price of the stock vs. the close price one month ago.
Percent Price Change YTD	The percentage change in the latest close price of the stock vs. the close price at the beginning of the calendar year.
Phone Number	Represents the phone number/fax number at which the investor relations officer can be reached.
Preferred Dividends	Represents actual cash dividend payment on preferred stock or the provision for preferred dividends, if in arrears. It also includes accretion on preferred stock.
Preferred Stock - Carrying Value	Represents a claim prior to the common shareholders on the earnings of a company and on the assets in the event of liquidation.
Premium Balance Receivables - Insurance	Represents unpaid premiums due from policyholders.
Prepaid Expenses	Represents payments made in advance for services to be received within the normal operating cycle of the company.
Pretax Income	Represents all income/loss before any federal, state or local taxes. Extraordinary items reported net of taxes are excluded.
Pre Tax Interest Coverage Ratio	Returns EBIT interest coverage for the period and date(s) requested.
Pre Tax Profit Margin	Returns pretax margin for the period and date(s) requested.
Price To Book	The latest closing price divided by the latest book value per share (TTM).
Price To Book - Fiscal	Returns price to book value using price as of the last trading day for the period and date(s) requested in local currency by default.
Price to Cash Flow	Returns price to cash flow ratio for the period and date(s) requested.
Price to Free Cash Flow	Returns price to free cash flow for the period and date(s) requested in local currency by default.
Price to Sales - Fiscal	Returns the close price divided by sales per share using the fiscal period-end price for the period and date(s) requested in local currency by default.
Price to Tangible Book - Fiscal	Price to tangible book value as reported in the company's balance sheet.
Price to Tangible Book	The latest close price divided by latest tangible book value per share.
Property	Represents the architectural structure used in a business such as a factory, office complex or warehouse.
Property	Represents the real estate without buildings held for productive use. Land is recorded at its purchase price plus any costs related to its purchase such as lawyer's fees, escrow fees, title and recording fees.
Provision for Risks Charges	For non-U.S. corporations, this item includes provisions for pension funds, repairs and maintenance, litigation claims, etc.
Purchase or Sale of Investments	Returns purchase/sale of investments for the period and date(s) requested in local currency by default.
Quick Ratio	Returns the quick ratio, a measure of short term liquidity, for the period and date(s) requested. It is equal to Cash & Equivalents plus Receivables divided by Current Liabilities.
Research and Development As Percent Of Sales	Returns research and development as a percent of sales for the period and date(s) requested.
Real Estate Assets	For Banks this represents property owned by the bank but not classified as part of premises or equipment. It includes but is not restricted to: Real estate acquired from foreclosures, Lands held for resale, Lands held for future branch expansion. For Insurance and Other Financial Companies this represents the company's investment in real estate. This item does not include real estate used in the operation of the company. For Industrial Companies this represents a company's investment in real estate and property.
Receivables Per Day Sales	The average collection period. It indicates the average length of time a firm must wait after making a sale before it receives payment. Equals Accounts Receivable divided by Sales divided by 360 (TTM).
Receivables Turnover	Returns sales divided by receivables for the period and date(s) requested.
Research & Development	Represents all direct and indirect costs related to the creation and development of new processes, techniques, applications and products with commercial possibilities.
Reserves Increase (Decrease)	Represents allocations to and/or from discretionary reserves and is most common in European countries. Only allocations to reserves included in net income apply.
Retained Earnings	Represents the accumulated after tax earnings of the company which have not been distributed as dividends to shareholders or allocated to a reserve account.
Return On Assets	This is calculated as Net Income divided by Total Assets.
Return On Average Total Equity	This is calculated as Net Income divided by the two fiscal period average of Total Shareholders' Equity. If you request data on a quarterly or semiannual frequency, the formula uses the LTM value for Net Income.
Return On Common Equity	Returns the return on common equity for the period and date(s) requested.
Revenue Per Share	Returns sales per share for the period and date(s) requested in local currency by default.
Revenue To Assets	Revenues divided by total assets (TTM).
Sale of Fixed Assets and Businesses	Represents the amount a company received from the sale of property, plant and equipment.
Total Sales (or Revenue)	Represents gross sales and other operating revenue less discounts, returns and allowances.
Sector	This item represents the FactSet sector classification of the issuing company for this security.
Sector Name	This item represents the FactSet sector classification of the issuing company for this security, with spaces
Securities In Custody	Represents securities borrowed from other financial institutions to be used as temporary collateral for loans. It is also securities deposited by the customers as collateral for margin transactions.
Security is Primary Issue	Returns True if the security is a primary issue; returns False if it is a secondary issue.
SG& A Excluding Other	Represents expenses not directly attributable to the production process but relating to selling, general and administrative functions.
Selling General and Administrative Expenses SG& A And Other	Returns selling, general & admin expense & other for the period and date(s) requested in local currency by default.
Shares Held By Institutions	Represents the institutional ownership shares held for each equity share class.
Shares - Number Of Closely Held	Represents shares held by insiders. For Japanese companies, closely held represents the holdings of the ten largest shareholders. For companies with more than one class of common stock, closely held shares for each class are added together.
Shares Outstanding	Represents the number of shares outstanding at the company's year end. It is the difference between issued shares and treasury shares.
Shares Outstanding - Current	Represents the number of current shares outstanding at the company's most recent fiscal period end. It is the difference between issued shares and treasury shares.
Share Type - Security	Represents the name of the security whose prices and dividends are shown with the fundamental data of the company. This item is provided for all share types at the security level. The share names are generally shown in the language of the country in which the company is domiciled.
Short Interest Shares	Represents the total number of shares of a stock that have been sold short and not yet covered. A large increase or decrease in a stock's short interest from the previous month is often considered a good indicator of investor sentiment.
Short Term Debt (including Current Portion of Long Term Debt)	Represents that portion of debt payable within one year including current portion of long-term debt and sinking fund requirements of preferred stock or debentures.
Short Term Receivables	Represents the amounts due to the company resulting from the sale of goods and services on credit to customers (after applicable reserves). These assets should reasonably be expected to be collected within a year or within the normal operating cycle of a business.
SIC Code	Company Primary SIC Code.
State	The headquarters state as given in the latest report.
State Of Incorporation	Company state of incorporation.
Stock Option Compensation Expense	Stock Option Compensation Expense.
Tangible Book Value Per Share	Represents the fiscal year end book value of a company excluding intangible other assets. This item is generally not available prior to 1989.
Tangible Other Assets	Represents other assets not delineated other than intangibles.
Tier 1 Capital	Represents the primary capital supporting the lending and deposit activities of a bank. Data for this field is generally not available prior to 1996 for non-U.S. companies and 1991 for U.S. companies.
Tier 2 Capital	Represents the supplemental capital supporting the lending and deposit activities of a bank. Data for this field is generally not available prior to 1996 for non-U.S. companies and 1991 for U.S. companies.
Total Assets	Represents the sum of total current assets, long-term receivables, investment in unconsolidated subsidiaries, other investments, net property plant and equipment, deferred tax assets, and other assets.
Total Cash	Represents money available for use in the normal operations of the company. It is the most liquid of all of the company's assets.
Cash & Due from Banks	Represents amounts due to the bank from other banks.
Common Equity	Represents common shareholders' investment in the company.
Total Current Assets	Represents cash and other assets that are reasonably expected to be realized in cash, sold or consumed within one year or one operating cycle.
Total Current Liabilities	Represents debt or other obligations that the company expects to satisfy within one year.
Total Customer Deposits	Represents the value of money held by the bank or financial company on behalf of its customers.
Total Debt	Represents all interest bearing and capitalized lease obligations. It is the sum of long and short-term debt.
Total Debt To Equity Ratio	Returns total debt as a percent of total equity for the period and date(s) requested in local currency by default.
Total Deposits	Represents the value of money held by the bank or financial company on behalf of its customers.
Total Enterprise Value	Returns enterprise value for the period and date(s) requested in local currency by default.
Total Equity	Represents total equity for the period and date(s) requested in local currency by default.
Total Expenses	Represents the sum of all expenses related to operations.
Total Interest Expense - Banks	Represents the total amount of interest paid by the bank.
Invested Capital - Total	Returns total invested capital for the period and date(s) requested in local currency by default.
Total Investments and Advances	Returns total investments and advances for the period and date(s) requested in local currency by default.
Investments	Represents investment in securities which directly or indirectly creates a loan made by the bank.
Total Liabilities	Represents all short- and long-term obligations expected to be satisfied by the company.
Total Liabilities & Stockholders Equity	Represents the sum of total liabilities, minority interest, non-equity reserves, preferred stock and common equity.
Total Operating Expenses	Represents the sum of all expenses related to operations.
Total Shareholders Equity	Returns total shareholders' equity for the period and date(s) request in local currency by default.
Total Volume 1 Week	The total volume traded of a security during the current week.
Total Volume Last 10 Days	The total volume traded of a security over the last 10 days.
Total Volume Last 12 Months	The total volume traded of a security over the last 12 months.
Total Volume Last 13 Weeks	The total volume traded of a security over the last 13 weeks.
Total Volume Last 20 Days	The total volume traded of a security over the last 20 days.
Total Volume Last 26 Weeks	The total volume traded of a security over the last 26 weeks.
Total Volume Last 2 Weeks	The total volume traded of a security over the last 2 weeks.
Total Volume Last 3 Months	The total volume traded of a security over the last 3 months.
Total Volume Last 4 Weeks	The total volume traded of a security over the last 4 weeks.
Total Volume Last 52 Weeks	The total volume traded of a security over the last 52 weeks.
Total Volume Last 6 Months	The total volume traded of a security over the last 6 months.
Total Volume Last 9 Months	The total volume traded of a security over the last 9 months.
Total Volume MTD	The total volume traded of a security during the current month.
Total Volume YTD	The total volume traded of a security during the current calendar year.
Unusual Expense	Returns unusual expense for the period and date(s) requested in local currency by default.
Website	Website address from latest report.
Weekly Volume As Percent Of Shares Outstanding	The previous week's total volume divided by the number of shares outstanding, expressed as a percentage.
Working Capital	Returns total working capital for the period and date(s) requested in local currency by default.
Working Capital Per Share	Represents the difference between current assets and current liabilities divided by outstanding shares.
Zip Code	The postal code as given in the latest report.

Excel Real Time Fields

Field

Description