Excel Real Time Fields

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