Appendix J2: Market Scan Criteria

["And",...]

["Or",...]

["Not",[...]]

["Xor",[...],[...]]

// Matches when there's a Dividend date and the Expiry date is an exact value.
["And",["Date","Dividend"],["ExpiryDate","2024-01-01"]]
// Matches when the reference price is an exact value, or within a range.
["Or",["Price","Reference",3.0],["Price","Reference",{"Min":1.5,"Max":2.5}]]
// Matches when there is no Dividend date
["Not",["Date","Dividend"]]

// Matches when there's a Dividend date and reference price is either a specific value, or within a range
["And",["Date","Dividend"],["Or",["Price","Reference",3.0],["Price","Reference",{"Min":1.5,"Max":2.5}]]]
// Matches when there is no Dividend date, and when the Expiry date is different to the given value
["Not",["And",["Date","Dividend"],["ExpiryDate","2024-01-01"]]]

// Checks if the Sharia category code is assigned
["Category","Sharia"]

// Checks if at least one of Sharia or Foreign category codes are assigned
["Category","Sharia","Foreign"]
// Matches symbols in the Malaysian Buy-In and Odd-Lot markets
["Market","MYX:BI","MYX:OD"]

// Checks whether there is a Dividend date
["Date","Dividend"]
// Checks whether there is a Reference Price
["Price","Reference"]

// Checks whether the Dividend date matches.
["Date","Dividend","2024-01-01"]
// Checks whether the Reference Price matches.
["Price","Reference",2.0]

// Dividend date between two values
["Date","Dividend","2023-01-01","2023-12-31"]
// Reference price less than or equal to the maximum
["Price","Reference",null,2.5]
// Start date greater than or equal to the minimum
["Date","Start","2023-01-01",null]

// Dividend date exactly matches
["Date","Dividend",{"At":"2023-01-01"}]
// Reference price between two values
["Price","Reference",{"Min":1.5,"Max":2.5}]
// Dividend date less than or equal to the maximum
["Date","Dividend",{"Max":"2023-12-31"}]
// Dividend date greater than or equal to the minimum
["Date","Dividend",{"Min":"2023-01-01"}]

// Whether an ISIN alternative code is set
["AltCode","ISIN"]
// Whether the Short attribute is set
["Attribute","Short"]

// Whether 'I' is within the Short attribute.
["Attribute","Short","I"]

// Whether the Underlying alternative code starts with 'BHP'
["AltCode","Underlying","BHP","FromStart"]
// Whether 'i' is within the Short attribute, ignoring case.
["Attribute","Short","i",true]
// Whether the Underlying alternative code starts with 'bhp', ignoring case.
["AltCode","Underlying","bhp","FromStart",true]

// Matches whenever the Underlying code exactly matches the string 'BHP'.
["AltCode","Underlying","BHP",{"As":"Exact"}]
// Matches whenever the Underlying code starts with 'bhp', ignoring case.
["AltCode","Underlying","bhp",{"As":"FromStart","IgnoreCase":true}]

// Checks if a symbol has an expiry date
["ExpiryDate"]
// Checks if the symbol has traded today
["LastPrice"]
// If there are no parameters, you can also just specify the criteria type directly inside another criteria
["And","ExpiryDate","LastPrice"]

// Checks if the expiry date matches
["ExpiryDate","2024-01-01"]
// Checks if the lot size matches
["LotSize",100]

// Expiry date between two values
["ExpiryDate","2023-01-01","2023-12-31"]
// Previous Close less than or equal to the maximum
["PreviousClose",null,2.0]
// Strike Price greater than or equal to the minimum
["StrikePrice",10.5,null]

// Expiry date exactly matches
["ExpiryDate",{"At":"2023-01-01"}]
// Previous Close between two values
["PreviousClose",{"Min":8,"Max":10}]
// Strike Price less than or equal to the maximum
["StrikePrice",{"Max":10}]
// Strike Price greater than or equal to the minimum
["StrikePrice",{"Min":8}]

// Checks if the symbol is not an index
["IsIndex",false]

// Checks if the symbol is an index
["IsIndex"]
// If there are no parameters, you can also just specify the criteria type directly inside another criteria
["And","IsIndex","LastPrice"]

// Checks if the symbol has a CallOrPut value.
["CallOrPut"]

// Whether 'LIMITED' is within the Name.
["Name","LIMITED"]

// Whether the Code starts with 'BHP'
["Code","BHP","FromStart"]
// Whether 'ltd' is within the Name, ignoring case.
["Name","ltd",true]
// Whether the Name starts with 'Tel', ignoring case.
["Name","Tel","FromStart",true]

// Matches whenever the Name exactly matches the string 'BHP'.
["Name","BHP",{"As":"Exact"}]
// Matches whenever the Name starts with 'bhp', ignoring case.
["Name","bhp",{"As":"FromStart","IgnoreCase":true}]

/* Check whether the Last Price equals 10 */
["=","LastPrice",10.0]
/* Check whether the Last Price is less than the Auction Price */
["<","LastPrice","Auction"]
/* Check whether the Last Price is twice the Previous Closing Price or more */
[">","LastPrice",["*","PreviousClose",2]]

/* Match all symbols */
["All"]
/* Match no symbols */
["None"]

/* Adds 10 to the last price */
["+","LastPrice",10.0]
/* Adds 10 to the last price */
["Add","LastPrice",10.0]
/* Multiplies the previous close by 1.5 */
["*","PreviousClose",1.5]
/* Multiplies the previous close by 1.5 */
["Mul",1.5,"PreviousClose"]

/* Negates the auction remainder */
["-","Remainder"]
/* Returns the absolute value of the auction remainder */
["Abs","Remainder"]

/* No criteria pair. Always returns -1 */
["If",-1.0]
/* One criteria pair. If the Market is ASX, returns 1, otherwise returns -1 */
["If",["Market","ASX"],1.0, -1.0]
/* Two criteria pairs. If the Market is ASX, returns 1, if the Market is CXA returns 2, otherwise returns -1 */
["If",["Market","ASX"],1.0,["Market","CXA"],2.0, -1]
/* If the Market is ASX, returns the Last Price + 10, otherwise returns the last Price - 10 */
["If",["Market","ASX"],["+","LastPrice",10.0],["-","LastPrice",10.0]]
/* If the Market is MYX, returns the Extended Reference Price, otherwise returns the Previous Close  */
["If",["Market","MYX"],["Extended","Reference"],"PreviousClose"]