The SASEXFSD Interface Engine
- Overview
- Getting Started
-
Syntax
-
Details
-
ExamplesRetrieving Standardized Economic Items for Multiple CountriesRetrieving Economic Items by Using the FQL Syntax for Function Z ScoreUsing ECON_EXPR_DATA with the FQL Syntax for Function ReturnsUsing SPEC_ID_DATA with the FQL Economic Download SyntaxUsing Multiple Database Sources with the FQL SyntaxRetrieving Price Data for One CompanyRetrieving Price and Sales Data for Multiple CompaniesRetrieving Book Value Data for One Company by Using Relative DatesRetrieving Multiple Screen Items for Multiple CompaniesRetrieving Data by Using the ISON= and ISONPARAMS= OptionsRetrieving Benchmark Data by Using the CUTOFF= optionRetrieving Benchmark Data by Using the MATCHDATE= OptionRetrieving Multiple Items for Multiple Companies from an OFDB FileRetrieving a List of Securities from an OFDB fileRetrieving a List of CUSIPs from a Screen File
- References
The ExtractFormulaHistory factlet is used for extracting one or more items for one security, for an index, or for a list of securities over time. ExtractFormulaHistory uses the FactSet Query Language (FQL). The ExtractFormulaHistory factlet uses the options listed in Table 43.12, such as the IDS= option, which specifies the IDs for one or more securities, or the ISON= and ISONPARAMS= options, which specify an FQL formula that extracts the universe along with any ISON parameters necessary for the ISON code. You can use the START=, END=, and FREQ= options or the DATES= option to specify a date range for selecting time series data. You can select data items by using the ITEMS= option, but only the name/value pairs syntax (not the standard FQL syntax) is supported. The ITEMS= option designates multiple shortcut items or item/statistic combinations. You can use any instance of the Formula Library for the ITEMS= option.
The PERIOD= option is used for FactSet Fundamentals database codes to specify the estimate period of the data that you want to select. The CAL= option enables you to set your calendar in the same way that the PSETCAL function in FQL works. You can specify the CAL= option to be LOCAL, FIVEDAY, FIVEDAYEOM, SEVENDAY, or an exchange code. The list of exchange codes is available in the FactSet Online Assistant, page ID 16610. The ORIENTATION= option is supported only for ETI (entity-time-item), so that your SAS output data set is organized by key entities such as CUSIP or ticker, by date so that observations are kept in time series order, and by item. ETI is the default setting for orientation.
Table 43.12: ExtractFormulaHistory Factlet Options
|
Option |
Description |
|---|---|
|
IDS= |
Specifies one or more securities; for example, IDS=IBM,MSFT,FDS |
|
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 ISON codes that use parameters; for example, ISON_MSCI_WORLD(0,1) is written as ISONPARAMS=0,1. |
|
DATES= |
Specifies a date string such as YYYYMMDD:YYYYMMDD:F or relative dates -1b:-4b:m |
|
START= |
Specifies a valid FQL date; START=0 is the default |
|
END= |
Specifies a valid FQL date; END=0 is the default |
|
FREQ= |
Specifies a valid FQL frequencies; for example, M, D, Y. See Table 43.20. |
|
ITEMS= |
Specifies one or more FQL items (only the name/value pair syntax is supported; for example, ff_sales, p_price) |
|
PERIOD= |
Specifies valid time intervals between the data points (observations) in a time series; for example, ANN, QTR, and SEMI-ANN; PERIOD=ANN is the default. |
|
ORIENTATION= |
Specifies an optional orientation (default is currently ETI) |
|
CAL= |
Specifies the calendar setting that replicates the PSETCAL function; for example, LOCAL, FIVEDAY, FIVEDAYEOM, and SEVENDAY, for exchange code CAL=AAM (for a list of exchange codes, see the FactSet Online Assistant, page ID 16610) |