derive type:single value:IF(State == 'NY','New York, New York!','some other place') as:'isNewYork'
NOTE: For a larger dataset, you might maintain your buy, sell, and hold evaluations for each stock in a separate reference dataset that you join to the source dataset before performing comparisons between column values. See Join PagePanel.
To assist in evaluation, you might first want to create columns that contain the cost (
Basis) and the current value (
CurrentValue) for each stock: