search_table.expr

#
# Execute a search query and layout results in a TABLE.
#
#---
$query = "medical country:canada"
#---

# Run search query
$results = SEARCH($query)

# Filter only Toronto stocks
$results = FILTER($results, ENDS_WITH($1, ".TO"))

# Count results to build table name
$count = count($results)

# Build table
TABLE($query + ' (' + $count + ')', $results,
  ['Symbol', $1, symbol],
  ['Industry', F($1, "General.Industry"), text],
  ['Price', S($1, close), currency]
)

Download