Joined
·
680 Posts
Hi all,
I have been working with options for my investment portfolios for a couple of years now, but mostly using my US holdings. I do some options strategies in my Canadian holdings of course, but since the volume is so low I need to be careful. To ensure I knew which Canadian securities had enough options volume to trade with reasonably, I decided to run a screen to find a list of optionable stocks and ETFs that had a decent amount of volume. Well I dug around, but neither Questrade or RBCDI had any tools for me to do this - and nothing else I found let me run the screen I wanted. So... what to do?
Well I started with http://m-x.ca/accueil_en.php and dug around until I found end-of-day data that I could download as a spreadsheet. It contained all options that traded that day broken down by contract (month and strike) and including a total volume and open interest for each underlying. Well a good start but how do I get this filtered and sorted? The short answer is to start with manually working the spreadsheet to cut out everything except the total lines, and then use conditional formatting to identify issues lacking in volume and remove them. As I went through this process I thought about how this was simply volume from a single day (Aug. 23rd) during a low volume period and how that wouldn't really be a good guide. Looking at the data I figured that Open Interest is a much better indicator, so I'd work with that instead. Next I did some formula work to pull out ticker symbols, total OI, and then sort the whole list by OI.
So - I arbitrarily decided that anything under 10 thousand contracts of open interest was too thin, I only wanted to see things over that number. I ended up adding a couple of issues into that mix that didn't meet that screen but had over 5k in open interest and were securities I traded or invested in - namely Telus and XFN.
Phew. Well it was quite a bit of work. I thought some of you might like to see the list of 29 securities I ended up with - sorted by open interest. Please tell me your thoughts, suggestions, or ideas. Is 10k open interest too high or arbitrary? Should I try 5K, or maybe screen using some other metric?
If anybody wants the actual spreadsheet I have shared it on Skydrive. If that doesn't work for some reason, PM me.
Yikes that's small. Here is a copy/paste of the raw data.
Name Ticker OpenInt
iShares S&P/TSX 60 Index Fund*(XIU) 17.270 XIU 372,505
Suncor Energy Inc.*(SU) 31.250 SU 93,523
Continental Gold Limited*(CNL) 7.730 CNL 61,580
Royal Bank of Canada*(RY) 53.290 RY 54,411
Bank of Nova Scotia (The)*(BNS) 52.500 The 53,387
Bank of Montreal*(BMO) 57.540 BMO 38,134
Canadian Imperial Bank of Commerce*(CM) 75.600 CM 36,888
Toronto-Dominion Bank (The)*(TD) 80.500 The 34,241
Barrick Gold Corporation*(ABX) 37.870 ABX 33,804
Canadian Natural Resources Limited*(CNQ) 30.850 CNQ 30,683
Yamana Gold Inc.*(YRI) 16.580 YRI 29,785
Goldcorp Inc.*(G) 39.910 G 26,087
Teck Resources Limited., Cl. B*(TCK) 29.100 TCK 22,449
Canadian Oil Sands Trust*(COS) 21.460 COS 20,885
First Quantum Minerals*(FM) 19.420 FM 18,037
Silver Wheaton Corp.*(SLW) 33.790 SLW 16,808
Bombardier Inc., Cl. B*(BBD) 3.580 BBD 16,250
Detour Gold Corp. *(DGC) 26.590 DGC 15,959
Potash Corporation of Saskatchewan*(POT) 41.120 POT 15,722
EnCana Corporation*(ECA) 21.620 ECA 15,359
Sun Life Financial*(SLF) 23.030 SLF 14,981
BCE Inc.*(BCE) 44.420 BCE 14,851
SNC-Lavalin Group Inc.*(SNC) 36.670 SNC 12,317
TransCanada Corporation*(TRP) 45.150 TRP 12,111
iShares S&P/TSX Capped Energy Index Fund*(XEG) 16.110 XEG 11,013
Talisman Energy Inc.*(TLM) 13.270 TLM 10,568
Cameco Corporation*(CCO) 22.800 CCO 10,343
iShares S&P/TSX Capped Financials Index Fund*(XFN) 22.020 XFN 8,630
TELUS Corporation*(T) 63.540 T 5,393
I have been working with options for my investment portfolios for a couple of years now, but mostly using my US holdings. I do some options strategies in my Canadian holdings of course, but since the volume is so low I need to be careful. To ensure I knew which Canadian securities had enough options volume to trade with reasonably, I decided to run a screen to find a list of optionable stocks and ETFs that had a decent amount of volume. Well I dug around, but neither Questrade or RBCDI had any tools for me to do this - and nothing else I found let me run the screen I wanted. So... what to do?
Well I started with http://m-x.ca/accueil_en.php and dug around until I found end-of-day data that I could download as a spreadsheet. It contained all options that traded that day broken down by contract (month and strike) and including a total volume and open interest for each underlying. Well a good start but how do I get this filtered and sorted? The short answer is to start with manually working the spreadsheet to cut out everything except the total lines, and then use conditional formatting to identify issues lacking in volume and remove them. As I went through this process I thought about how this was simply volume from a single day (Aug. 23rd) during a low volume period and how that wouldn't really be a good guide. Looking at the data I figured that Open Interest is a much better indicator, so I'd work with that instead. Next I did some formula work to pull out ticker symbols, total OI, and then sort the whole list by OI.
So - I arbitrarily decided that anything under 10 thousand contracts of open interest was too thin, I only wanted to see things over that number. I ended up adding a couple of issues into that mix that didn't meet that screen but had over 5k in open interest and were securities I traded or invested in - namely Telus and XFN.
Phew. Well it was quite a bit of work. I thought some of you might like to see the list of 29 securities I ended up with - sorted by open interest. Please tell me your thoughts, suggestions, or ideas. Is 10k open interest too high or arbitrary? Should I try 5K, or maybe screen using some other metric?

If anybody wants the actual spreadsheet I have shared it on Skydrive. If that doesn't work for some reason, PM me.
Yikes that's small. Here is a copy/paste of the raw data.
Name Ticker OpenInt
iShares S&P/TSX 60 Index Fund*(XIU) 17.270 XIU 372,505
Suncor Energy Inc.*(SU) 31.250 SU 93,523
Continental Gold Limited*(CNL) 7.730 CNL 61,580
Royal Bank of Canada*(RY) 53.290 RY 54,411
Bank of Nova Scotia (The)*(BNS) 52.500 The 53,387
Bank of Montreal*(BMO) 57.540 BMO 38,134
Canadian Imperial Bank of Commerce*(CM) 75.600 CM 36,888
Toronto-Dominion Bank (The)*(TD) 80.500 The 34,241
Barrick Gold Corporation*(ABX) 37.870 ABX 33,804
Canadian Natural Resources Limited*(CNQ) 30.850 CNQ 30,683
Yamana Gold Inc.*(YRI) 16.580 YRI 29,785
Goldcorp Inc.*(G) 39.910 G 26,087
Teck Resources Limited., Cl. B*(TCK) 29.100 TCK 22,449
Canadian Oil Sands Trust*(COS) 21.460 COS 20,885
First Quantum Minerals*(FM) 19.420 FM 18,037
Silver Wheaton Corp.*(SLW) 33.790 SLW 16,808
Bombardier Inc., Cl. B*(BBD) 3.580 BBD 16,250
Detour Gold Corp. *(DGC) 26.590 DGC 15,959
Potash Corporation of Saskatchewan*(POT) 41.120 POT 15,722
EnCana Corporation*(ECA) 21.620 ECA 15,359
Sun Life Financial*(SLF) 23.030 SLF 14,981
BCE Inc.*(BCE) 44.420 BCE 14,851
SNC-Lavalin Group Inc.*(SNC) 36.670 SNC 12,317
TransCanada Corporation*(TRP) 45.150 TRP 12,111
iShares S&P/TSX Capped Energy Index Fund*(XEG) 16.110 XEG 11,013
Talisman Energy Inc.*(TLM) 13.270 TLM 10,568
Cameco Corporation*(CCO) 22.800 CCO 10,343
iShares S&P/TSX Capped Financials Index Fund*(XFN) 22.020 XFN 8,630
TELUS Corporation*(T) 63.540 T 5,393