The SASEXFSD Interface Engine (Experimental)

The ExtractDataSnapshot factlet efficiently extracts multiple items as of a single date for a universe of both equity and fixed income securities. It uses the FactSet screening language to extract data for a large universe of securities as of a single date. The ExtractDataSnapshot factlet uses the options listed in Table 43.11, such as the IDS= option, which specifies the IDs for one or more securities, or you can specify fixed securities with the UNIVERSEGROUP= option. If you want to access only current constituents, use the ISON= option to specify your ISON codes instead of using the IDS= option. If your ISON code uses parameters, then use the ISONPARAMS= option to specify the parameters for the code that you use in your ISON= option. Use DATE=YYYYMMDD to specify the day that your snapshot is for, or use the START=, END=, and FREQ= options to specify the date for the FQL scalar data item that you want. Use the ITEMS= option to specify one or more screening items by using the name/value pair syntax. The SASEXFSD engine does not support the standard screening syntax, so use the name/value pair syntax instead. For example, instead of using ITEMS='FF_SALES(QTR,20110401)', use ITEMS='FF_SALES' PERIOD=QTR REL_DATE=20110401 in your SASEXFSD LIBNAME statement. Specify the UNIVERSEGROUP= option to choose between the EQUITY group and the DEBT group. The CAL= option enables you to set your calendar in the same way that the PSETCAL function in FQL does. You can specify the CAL= option to be LOCAL, FIVEDAY, FIVEDAYEOM, SEVENDAY, or an exchange code. The list of exchange codes is available on page ID 16610 in the FactSet Online Assistant. The ORIENTATION= option is supported only for ETI (entity time item format), which is also the default.