MATCHFUNFIELD() Function

Author: Optuma Team Last updated: Oct 14, 2022 19:37

The MATCHFUNFIELD() scripting function allows you to reference any fundamental / data value available, including text such as Sectors or Asset Class.

Examples

If you wanted to run a scan across an entire exchange, but limit the results to just symbols that are Stocks (excluding ETFs, etc), you can add the following criteria to your script:

MATCHFUNFIELD(FEED=MA, FIELD=Asset Class, FIELDVALUE=Stock)

Click on the Field option to select the required data from the data lilst, and enter Field Value:

Capture

Only codes with an Asset Class of Stock would be displayed in the scans results.

Match

Using the example script above, only codes in the Watchlist with an Asset Class of STOCK passes the criteria.

Nasdaq-only scan

To scan for only Nasdaq stocks from the US Equities exchange use the following with the market identifier MIC field:

MATCHFUNFIELD(FEED=MA, FIELD=MIC, FIELDVALUE=XNAS)

Capture