Editing columns

You can customize the data that displays in your screener window by editing the displayed columns.

To add or remove columns from the screener window:

  1. Select the pre-set column view you would like to edit by clicking the appropriate tab. Columns you add/remove only apply to that pre-set column view.

  2. Choose the columns you see when you filter for stocks or options in the main screener window.  


Both stocks and options columns


Column Description 
Symbol The ticker symbol for the security.

Description The full name of the security.

Exch The listing exchange for the security.

Venues The trading venues where the security is traded.

Security type Indicates the type of security. (e.g., stock, option, etc.)

Chg $ The change in price from the previous day’s closing price.

Chg % The change in price from the previous day’s closing price expressed as a percentage.

Last The last price the security was traded at.

Bid The highest price the market is willing to pay for this security.

Bid sz The number of shares in board lots the market is willing to purchase at the bid price. On Canadian markets, one board lot is 100 shares for securities valued over $1.00, 500 shares for securities valued between $0.10 and $1.00, and 1,000 shares for securities valued under $0.10. On U.S. markets, one board lot is 100 shares for all securities. For option orders, one board lot is one option contract.

Ask  The lowest price the market is willing to accept for this security.

Ask sz The number of shares in board lots the market is willing to sell at the ask price. On Canadian markets, one board lot is 100 shares for securities valued over $1.00, 500 shares for securities valued between $0.10 and $1.00, and 1,000 shares for securities valued under $0.10. On U.S. markets, one board lot is 100 shares for all securities. For option orders, one board lot is one option contract.

Bid ask spd The difference between the bid price and the ask price.

Bid ask spd %

The difference between the bid price and the ask price expressed as a percentage.


Calculated using the following formula


[(ask - bid) / ask] x 100

High The highest price traded for the security today.

Low The lowest price traded for the security today.

Day price rank

The current price relative to the daily high and low prices.  A number close to zero means security is currently trading near the low of the day.  A number close to one means security is trading near the high of the day.


Calculated using the following formula


[(last - low) / (high - low)] x 100

High low spd The difference between the daily high and daily low price.

High low spd %

The difference between the daily high and daily low price expressed as a percentage.


Calculated using the following formula


[(high - low) / high] x 100

Open The price the security traded at when the markets opened.

Prev close The price the security traded at when the markets closed the previous day.

Currency The currency of the security.

Tick A change in the security’s price from the previous trade is represented by an up or down arrow. No change is represented by a dash. 

Last trade The date and time the security was last traded at.

Since open chg The difference between the current price and the price when markets opened for the current day. 

Since open chg % The difference between the current price and the price when markets opened for the current day expressed as a percentage.

Price gap

A measure of the difference between the current price and previous day’s high and low prices.


Calculated using the following formulas


If price gap is up: daily low - previous high (If value is negative, then price gap is 0)


If price gap is down: daily high - previous low (If value is positive, then price gap is 0)

Price gap %

A measure of the difference between the current price and previous day’s high and low prices expressed as a percentage.


Calculated using the following formulas


If price gap is up: [(daily low - previous high) / previous high] x 100 (If value is negative, then price gap % is 0)


If price gap is down: [(daily high - previous low) / previous low] x 100 (If value is positive, then price gap % is 0)

Vol The trading volume for the current day.

IV (implied volatility) The estimated volatility of the security’s price, expressed as a percentage. A higher volatility means a more unstable security price.

IV chg The difference between the current implied volatility and the implied volatility at the end of the previous day. 

IV chg % The difference between the current implied volatility and the implied volatility at the end of the previous day expressed as a percentage.


Only stocks columns 


Column Description 
52w high The highest price the security traded at over the past 52 weeks.

52w low The lowest price the security traded at over the past 52 weeks.

52w price rank

The current price relative to the 52-week high and low prices.


Calculated using the following formula


[(last - 52 wk low) / (52 wk high - 52 wk low)] x 100

After hours last The last price in post-market trading. 

After hours chg The difference between the price when markets closed and the last price in post-market trading.

After hours chg % The difference between the price when markets closed and the last price in post-market trading expressed as a percentage.

Chg % 1w The price change over the past week expressed as a percentage.

Chg % 1m
The price change over the past month expressed as a percentage.

Chg % 3m
The price change over the past three months expressed as a percentage.

Chg % 6m
The price change over the past six months expressed as a percentage.

Chg % 1y
The price change over the past year expressed as a percentage.

Chg % YTD
The price change since January 1 of the current year expressed as a percentage.

Vol 3m avg The average trading volume over the past three months. 

Vol 20d avg The average trading volume over the past 20 days. 

Vol 20d rel

The trading volume relative to the 20-day average expressed as a ratio.


Calculated using the following formula


current volume / 20-day average volume
Total opt vol The total trading volume of all option contracts from the same underlying security for the current day. 

Total opt vol 5d avg The average trading volume of all option contracts from the same underlying security over the past five days. 

Total opt vol 5d rel

The total trading volume of all option contracts from the same underlying security relative to the 5-day average expressed as a ratio.


Calculated using the following formula


total option volume/five-day average option volume

Total call vol The total trading volume for all call option contracts from the same underlying security for the current day. 

Total call vol 5d avg The average trading volume of all call option contracts from the same underlying security over the past five days.

Total call vol 5d rel

The total trading volume of all call option contracts relative to the 5-day average expressed as a ratio.


Calculated using the following formula


total call volume/five-day average call volume

Total put vol The total trading volume for all put option contracts from the same underlying security for the current day.

Total put vol 5d avg The average trading volume of all put option contracts from the same underlying security over the past five days.

Total put vol 5d rel

The total trading volume of all put option contracts relative to the 5-day average expressed as a ratio.


Calculated using the following formula


total put volume/five-day average put volume

Total OI The total open interest of all option contracts from the same underlying security that are not closed or delivered for the current day. 

Total OI chg
The difference between the current total open interest and the total open interest of the previous day from the same underlying security. 

Total OI chg % The difference between the total open interest and the total open interest of the previous day from the same underlying security expressed as a percentage.

Total call OI The total open interest of all call option contracts from the same underlying security that are not closed or delivered for the current day.

Total call OI chg The difference between the total call open interest and the total call open interest of the previous day from the same underlying security.

Total call OI chg % The difference between the total call open interest and the total call open interest of the previous day from the same underlying security expressed as a percentage.

Total put OI The total open interest of all put option contracts from the same underlying security that are not closed or delivered for the current day.

Total put OI chg The difference between the total put open interest and the total put open interest of the previous day from the same underlying security.

Total put OI chg % The difference between the total put open interest and the total put open interest of the previous day from the same underlying security expressed as a percentage.

Put/call ratio

The total put open interest relative to the total call open interest expressed as a ratio.


Calculated using the following formula


total put OI / total call OI

IV 20d avg The average of the implied volatility over the past 20 days. 

IV 20d rel The implied volatility relative to the 20-day average expressed as a ratio.

IV high 52 w The highest implied volatility over the past 52 weeks.

IV low 52 w The lowest implied volatility over the past 52 weeks. 

IV rank 52 w The current implied volatility relative to the past 52 weeks expressed as a percentage. 

HV A measure of the past volatility of a security. 

HV chg The difference between the current historical volatility and the historical volatility of the previous day. 

HV chg % The difference between the current historical volatility and the historical volatility of the previous day expressed as a percentage.

HV 20d avg The average historical volatility over the past 20 days.

HV 20d rel The historical volatility relative to the 20-day average expressed as a ratio. 

HV high 52 w The highest historical volatility over the past 52 weeks.

HV low 52 w The lowest historical volatility over the past 52 weeks.

HV rank 52 w The historical volatility relative to the past 52 weeks expressed as a percentage. 

Mkt cap The total value of all outstanding shares of the security.

Shares The number of shares owned by the public, company officers, and insiders.

EPS Earnings per share:  A company's profit divided by its number of common outstanding shares.

P/E A valuation ratio of the current share price compared to its earnings per share.

Div The distribution of a security’s earnings to shareholders.

Yield The income return on an investment displayed as an annualized percentage.

Ex-date The date on or after which a security is traded without a previously declared dividend or distribution.

Forward P/E A measure of the price-to-earnings ratio using forecasted earnings for the next fiscal year.

PEG A ratio that measures a stock’s value by taking into account the earnings’ growth. 

P/S A ratio that compares the current price of a stock to revenue per share. 

P/B A ratio that compares the current price of a stock to its book value. 

P/C A ratio that compares the current price of a stock to its cash assets. 

EPS growth A measure of the growth of earnings-per-share for the current year.

ROE A measure of the profitability of a company by taking into account the amount that shareholders have invested.

Current ratio A measure of the liquidity of a company. 
 
Quick ratio A measure of the short-term liquidity of a company.  

Debt/equity A measure of the financial leverage of a company.  

Sector The part (sector) of the economy this security belongs to.

Industry The primary business activity of this security.

Sub group  The business activity of the security classified under Sector.


Only options columns


Column Description 
Underlying The security that an option contract gets its value from.

Days exp The number of days until the option contract is no longer valid.

Option style Indicates the style of option: American or European.

Multiplier A number that determines the dollar value underlying the option. This number is calculated by taking a constant, usually 100, and multiplying it by the price of the underlying security (or the cash index value).

Cash in lieu Represents any exchange of cash resulting from an option exercise or assignment. 

Option type Identifies whether your option contract is a call or put.

Expiry date The date your option contract expires.

Strike The price at which the option contract can be exercised.

Mark price The midpoint of the ask price and the bid price.

Mark chg The difference between the mark price and the previous closing price. 

Mark chg % The difference between the mark price and the previous closing price expressed as a percentage.

Underlying price The last price of the underlying security. 

Intrinsic value

A measure of the value of a security.


Calculated using the following formulas


Call option: (underlying price - strike price)


Put option: (strike price – underlying price)


If the value is negative, then the intrinsic value is 0. 

Extrinsic value The difference between the mark price and the intrinsic value. 

Intrinsic/price

The percentage of the intrinsic value relative to the extrinsic value.


Calculated using the following formula


[intrinsic value / mark price] x 100

Underlying bid ask spd The difference between the bid price and ask price of the underlying security. 
Underlying vol The trading volume of the underlying security for the current day. 

Undelrying 20d avg The average trading volume for the underlying security over the past 20 days. 
Underlying vol 20d rel

The trading volume of the underlying security relative to the 20-day average expressed as a ratio.


Calculated using the following formula


underlying volume/20-day average underlying volume 

Vol 5d avg The average trading volume of the option over the past five days. 

Vol 5d rel The trading volume of the option relative to the 5-day average expressed as a ratio.
 
OI (open interest) The total number of option contracts that are not closed or delivered for the current day.

OI chg The difference between the current open interest and the open interest of the previous day.

OI chg % The difference between the current open interest and the open interest of the previous day expressed as a percentage.

Vol/OI The current option volume relative to open interest expressed as a ratio.

Delta Measures the change of the option’s price resulting from a change to the underlying stock price. (e.g., a delta of 0.5 means that a call option will increase by $0.50 for every $1 increase in the price of the underlying stock. For put options, the opposite is true; the put option will decrease for every $1 increase in the price of the underlying stock)

Gamma Measures the change of the option’s delta resulting from a change to the underlying stock price. Gamma is greatest when the option is at-the-money, and decreases the further away the option is from being either in-the-money or out-of-the-money. 

Vega Measures the change of the option’s price resulting from a 1% change in volatility to the underlying stock price. As the volatility of the stock price rises, the value of the option’s calls and puts rises as well. 

Theta Measures the daily change of the option’s price with the passage of time. (e.g., if the strike price of an option is $100 and the theta is 2.50, then in theory the value of the option will decrease by $2.50 per day)

Rho Measures the change of the option’s price resulting from a change in the risk-free interest rate. (e.g., if an option has a rho of 10.5, then for every 1% increase in the risk-free interest rate, the value of the option increases by 10.5%)

Underlying IV The implied volatility of the underlying security.

Underlying HV The historical volatility of the underlying security. 

All content in the Exchange, whether provided by Questrade or created by the community members, is for informational purposes only and does not contain advice or recommendations on behalf of Questrade Inc. Use of this site is subject to the terms of service and user posting rules.