ISMEMBER() Function

Author: Optuma Team Last updated: Jul 18, 2022 18:56

Overview

The ISMEMBER() function can be used to show if the underlying stock is part of the selected index (S&P500, ASX200 for example) either currently, or at some time in the past.

In this example, ASH left the SPX in 2008, and AMZN has been in the index since 2005, using the following in a Show View:

ISMEMBER(SYMBOLLIST=S&P 500)

ohM00u1VXL

This example is for the ASX200 using ISMEMBER(SYMBOLLIST=ASX 200), which shows KAR on the left being in the index from 2012 to 2016, and Z1P joining recently:

Capture

To read more about index membership, see this article on survivorship bias-free data.