(redirected from Lookup table)
Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms, Encyclopedia, Wikipedia.


Statistical composite that measures changes in the economy or in financial markets, often expressed in percentage changes from a base year or from the previous month. Indexes measure the ups and downs of stock, bond, and some commodities markets, in terms of market prices and weighting of companies in the index.


A statistical measure of the value of a certain portfolio of securities. The portfolio may be for a certain class of security, a certain industry, or may include the most important securities in a given market, among other options. The value of an index increases when the aggregate value of the underlying securities increases, and decreases when the aggregate value decreases. An index may track stocks, bonds, mutual funds, and any other security or investment vehicle, including other indices. An index's value may be weighted; for example, securities with higher prices or greater market capitalization may affect the index's value more than others. One of the most prominent examples of an index is the Dow Jones Industrial Average, which is weighted for price and tracks 30 stocks important in American markets.


The relative value of a variable in comparison with itself on a different date. Many security price indicators such as the Standard & Poor's series and the New York Stock Exchange series are constructed as indexes. Also called stock index. See also base period.


To adjust a variable by a selected measure of relative value. For example, it has been proposed that an investor's basis on a security be indexed for changes in consumer prices so that only real increases in value will be taxed. Also called tax indexing. See also subindex.


An index reports changes up or down, usually expressed as points and as a percentage, in a specific financial market, in a number of related markets, or in an economy as a whole.

Each index -- and there are a large number of them -- measures the market or economy it tracks from a specific starting point. That point might be as recent as the previous day or many years in the past.

For those reasons, indexes are often used as performance benchmarks against which to measure the return of investments that resemble those tracked by the index.

A market index may be calculated arithmetically or geometrically. That's one reason two indexes tracking similar markets may report different results. Further, some indexes are weighted and others are not.

Weighting means giving more significance to some elements in the index than to others. For example, a market capitalization weighted index is more influenced by price changes in the stock of its largest companies than by price changes in the stock of its smaller companies.


(1) A statistical indicator that measures changes in the economy in general or in particular areas.An example is the cost-of-living index.(2) A reference point against which measurements are taken for purposes of making future adjustments.An adjustable-rate mortgage might begin with an interest rate of 6 percent and provide that it will increase or decrease in a like percentage as the increase or decrease between today's quoted price for 10-year U.S.Treasury bonds and the price on the loan's annual anniversary date.We would say that 10-year T-bonds are the index.

Some leading loan indices include

• Wall Street Journal prime
• Federal discount rate
• Fed funds rate
• 11th District Cost of Funds
• 10-year Treasuries
• One-year LIBOR

References in periodicals archive ?
For circuit level simulation we choose Lookup table controller to each leaf node and global node of logic block.
The next two forms in the workbook use formulas that will rely on two lookup tables.
The description entered in the lookup table (here, South Shore Lab) should appear.
In this case, a lookup table with three rows for 0, 1,000, and 2,000 will deliver the correct bonus rate.
Imagine you're looking for the value from cell A2 in the left-most column of the lookup table (column X).
In this case, the height is the answer in F10, and the width will be the number of columns in your lookup table.
Let's say that you have a lookup table on a worksheet called Products.
The lookup table contains 35,000 unsorted product records.
In VLOOKUP When you're typing a VLOOKUP formula that points to a lookup table on another worksheet, the second argument in the lookup formula is a difficult to remember mix of apostrophes, exclamations, and dollar signs, e.
Graphics professionals will appreciate its 14-bit 3D lookup table (LUT) for precise color calibrations.
In the range lookup, the lookup table must be sorted ascending by the first column.
The MD212G3 includes a 16-bit lookup table, which provides 1,024 levels of gray out of a palette of 12,277 when using a 10-bit DisplayPort connection.