The ExtractOFDBItem factlet provides access to a list of securities and multiple data items for a range of dates uploaded into a single Open FactSet Database (OFDB). An OFDB is a high-performance multidimensional database system that securely stores proprietary numeric and textual data in FactSet.The ExtractOFDBItem factlet uses the options listed in Table 16, such as the OFDB= option, which specifies the OFDB file. Use either the IDS= option, which specifies the IDs for one or more securities, or the ISON= and ISONPARAMS= options, which specify an FQL formula (ISON code) that extracts the universe along with any ISON parameters necessary for the ISON code. Use the ITEMS= option to specify one or more items in the OFDB file. Use the DATES= option to specify a date range in YYYYMMDD:YYYYMMDD:freq format, or use FQL dates when FQLFLAG=Y (yes). By default, FQLFLAG=N (no). The DATESONLY= option specifies whether only the dates in the OFDB file are reported. By default, DATESONLY=N. The ORIENTATION= option supports only ETI, which is the default.
Table 16: ExtractOFDBItem Factlet Options
| Option | Description |
|---|---|
| OFDB= | Specifies the OFDB file |
| IDS= | Specifies one or more securities; for example, IDS=IBM, GM |
| ISON= | Specifies the FQL value that extracts the universe; for example, ISON_SP500 is entered as ISON=SP500, and ISON_MSCI_WORLD(0,1) is written as ISON=MSCI_WORLD. |
| ISONPARAMS= | Specifies the parameters for the ISON codes that use parameters; for example, ISON_MSCI_WORLD(0,1) is written as ISONPARAMS=0,1. |
| ITEMS= | Specifies one or more data items from the OFDB file |
| DATES= | Specifies dates in the format YYYYMMDD:YYYYMMDD:F or relative dates in relative format, such as -1b:-4b:m |
| DATE= | Specifies one date in the format YYYYMMDD (default is 0B, for today’s date) |
| DATESONLY= | Specifies that dates are reported from the OFDB file only when the option is set to Y (default is N) |
| FQLFLAG= | Sets dates to use FQL instead of screening; FQLFLAG=N (default) or Y |
| ORIENTATION= | Specifies an optional orientation (default is currently ETI) |