The Instrument submodel contains data structures that represent financial instruments. The Instrument (INSTRUMENT) table stores information common to all financial instruments.
Detailed information on each type of instrument represented in the model (i.e., stocks, bonds, mutual funds, ETF, and options) is stored in corresponding tables. Thus, stock-related information is stored in the Stock (STOCK) table, bond-related information is stored in the Bond (BOND) table, and so on.
The association table Instrument Exchange (INSTR_EXCHANGE) is used to specify exchanges where an instrument is traded. The Instrument Rating (INSTR_RATING) table stores information on the ratings assigned to an instrument by rating agencies (e.g., Moody's Investor Service, Standard & Poor's Corporation, Fitch Ratings, etc.).
Information on market indexes is stored in the Market Index (MARKET_INDEX) table. The Index Composition (INDEX_CMPST) table stores information on an index composition and is used to specify all instruments included in an index. The Instrument Benchmark (INSTR_BENCHMK) table specifies a market index (or indexes) used as a benchmark for a given financial instrument.
The association tables Underlying Index (ULYING_INDEX) and Underlying Instrument (ULYING_INSTR) are used, respectively, to specify an underlying index or an underlying financial instrument for an option.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
