Falling oil prices are adding to the downdraft in stocks, as the decline in Canadian and U.S. markets gained speed Tuesday.
U.S. stocks slumped back into negative territory for 2018 and Canadian stocks were hit again by tumbling oil prices, as investors weigh further evidence that global economic activity is slowing.
The Standard and Poor’s 500, which declined 1.8 per cent, is now down 10 per cent since hitting its high point in September, while Canada’s S&P/TSX Composite Index closed at its lowest level in two years, weighed down by Tuesday’s 6.6-per-cent decline in crude oil.
…
The S&P 500′s decline to 2,641.89 means the index is now down 1.2 per cent for the year. The 30-member Dow Jones Industrial Average fell 551.80 points on Tuesday, or 2.2 per cent, closing at 24,465.64.
But the real hit was to the Canadian preferred share market:
The TXPR Index hit a new 52-week low today of 647.89, before closing at 648.12, well below the prior low (set on November 19) of 661.68. There have now been nine straight days of losses, during which the price index has gone down 5.60%. At 2,882,187 shares trading, volume was on the high side, but nothing special in the context of the past thirty days.
CPD closed at 12.98, just above its low for the day of 12.965, well below the prior 52-week low of 13.27 set on November 19. At 448,849 shares volume, this was easily the highest turnover in the past thirty days – second place was 275,220 on October 31. Capitulation? You tell me.
ZPR closed at a new low of 10.60 today, just above the day’s low of 10.58, far below the prior 52-week low of 10.86, hit on November 19. Volume was the third-highest in the past thirty days.
Today’s tables are not for the faint of heart. Volume was high in quite a few individual issues, which may be due to market-makers hedging their (presumably) ever-increasing inventory of CPD and ZPR.
| HIMIPref™ Preferred Indices These values reflect the December 2008 revision of the HIMIPref™ Indices Values are provisional and are finalized monthly |
|||||||
| Index | Mean Current Yield (at bid) |
Median YTW |
Median Average Trading Value |
Median Mod Dur (YTW) |
Issues | Day’s Perf. | Index Value |
| Ratchet | 0.00 % | 0.00 % | 0 | 0.00 | 0 | -1.8386 % | 2,871.7 |
| FixedFloater | 0.00 % | 0.00 % | 0 | 0.00 | 0 | -1.8386 % | 5,269.5 |
| Floater | 4.05 % | 4.27 % | 37,443 | 16.81 | 4 | -1.8386 % | 3,036.8 |
| OpRet | 0.00 % | 0.00 % | 0 | 0.00 | 0 | -0.2601 % | 3,192.4 |
| SplitShare | 4.51 % | 5.14 % | 71,128 | 4.15 | 6 | -0.2601 % | 3,812.4 |
| Interest-Bearing | 0.00 % | 0.00 % | 0 | 0.00 | 0 | -0.2601 % | 2,974.6 |
| Perpetual-Premium | 5.97 % | 6.01 % | 51,573 | 13.86 | 3 | -0.9960 % | 2,844.0 |
| Perpetual-Discount | 5.70 % | 5.84 % | 71,920 | 14.09 | 31 | -0.7588 % | 2,876.6 |
| FixedReset Disc | 4.81 % | 5.58 % | 159,755 | 14.66 | 58 | -3.0503 % | 2,314.8 |
| Deemed-Retractible | 5.44 % | 7.31 % | 77,937 | 5.14 | 27 | -0.9085 % | 2,856.4 |
| FloatingReset | 4.00 % | 4.78 % | 38,124 | 5.34 | 6 | -3.4400 % | 2,618.2 |
| FixedReset Prem | 5.15 % | 5.08 % | 195,331 | 2.53 | 22 | -0.8820 % | 2,486.9 |
| FixedReset Bank Non | 2.98 % | 4.25 % | 126,192 | 2.97 | 6 | -0.3570 % | 2,564.8 |
| FixedReset Ins Non | 4.83 % | 7.39 % | 122,495 | 5.25 | 22 | -2.6517 % | 2,326.7 |
| Performance Highlights | |||
| Issue | Index | Change | Notes |
| TRP.PR.H | FloatingReset | -7.04 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 14.65 Evaluated at bid price : 14.65 Bid-YTW : 5.15 % |
| RY.PR.M | FixedReset Disc | -6.71 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.13 Evaluated at bid price : 21.13 Bid-YTW : 5.67 % |
| GWO.PR.N | FixedReset Ins Non | -6.23 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 15.95 Bid-YTW : 11.40 % |
| TD.PF.J | FixedReset Prem | -5.69 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.23 Evaluated at bid price : 22.87 Bid-YTW : 5.40 % |
| TRP.PR.C | FixedReset Disc | -5.31 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 14.80 Evaluated at bid price : 14.80 Bid-YTW : 6.19 % |
| EMA.PR.F | FixedReset Disc | -5.29 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.57 Evaluated at bid price : 20.57 Bid-YTW : 5.98 % |
| TRP.PR.E | FixedReset Disc | -5.21 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 19.30 Evaluated at bid price : 19.30 Bid-YTW : 6.06 % |
| TRP.PR.F | FloatingReset | -5.04 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 17.90 Evaluated at bid price : 17.90 Bid-YTW : 5.12 % |
| TRP.PR.B | FixedReset Disc | -4.87 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 14.46 Evaluated at bid price : 14.46 Bid-YTW : 6.04 % |
| BAM.PF.G | FixedReset Disc | -4.84 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.22 Evaluated at bid price : 21.22 Bid-YTW : 6.08 % |
| TRP.PR.D | FixedReset Disc | -4.74 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 19.29 Evaluated at bid price : 19.29 Bid-YTW : 6.12 % |
| BAM.PF.E | FixedReset Disc | -4.74 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.10 Evaluated at bid price : 20.10 Bid-YTW : 6.08 % |
| SLF.PR.G | FixedReset Ins Non | -4.67 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 16.95 Bid-YTW : 10.64 % |
| MFC.PR.F | FixedReset Ins Non | -4.64 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 15.84 Bid-YTW : 11.39 % |
| MFC.PR.K | FixedReset Ins Non | -4.41 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.50 Bid-YTW : 9.23 % |
| SLF.PR.J | FloatingReset | -4.39 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 17.00 Bid-YTW : 10.33 % |
| PWF.PR.Q | FloatingReset | -4.30 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 19.81 Evaluated at bid price : 19.81 Bid-YTW : 4.20 % |
| HSE.PR.G | FixedReset Disc | -4.23 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.71 Evaluated at bid price : 22.17 Bid-YTW : 6.51 % |
| BMO.PR.Y | FixedReset Disc | -4.17 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.80 Evaluated at bid price : 22.30 Bid-YTW : 5.48 % |
| BAM.PF.F | FixedReset Disc | -4.12 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.18 Evaluated at bid price : 21.18 Bid-YTW : 6.16 % |
| PWF.PR.P | FixedReset Disc | -4.12 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 16.30 Evaluated at bid price : 16.30 Bid-YTW : 5.72 % |
| MFC.PR.Q | FixedReset Ins Non | -4.11 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 21.24 Bid-YTW : 7.81 % |
| BAM.PR.Z | FixedReset Disc | -4.08 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.90 Evaluated at bid price : 20.90 Bid-YTW : 6.21 % |
| BAM.PR.R | FixedReset Disc | -4.02 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 17.66 Evaluated at bid price : 17.66 Bid-YTW : 6.24 % |
| TD.PF.C | FixedReset Disc | -3.97 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.54 Evaluated at bid price : 20.54 Bid-YTW : 5.53 % |
| MFC.PR.L | FixedReset Ins Non | -3.95 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.45 Bid-YTW : 9.17 % |
| TRP.PR.G | FixedReset Disc | -3.94 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.75 Evaluated at bid price : 20.75 Bid-YTW : 6.15 % |
| NA.PR.W | FixedReset Disc | -3.89 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.00 Evaluated at bid price : 20.00 Bid-YTW : 5.68 % |
| BAM.PF.A | FixedReset Disc | -3.87 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.55 Evaluated at bid price : 21.87 Bid-YTW : 5.98 % |
| BAM.PF.B | FixedReset Disc | -3.85 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.48 Evaluated at bid price : 20.48 Bid-YTW : 6.09 % |
| BAM.PR.X | FixedReset Disc | -3.80 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 16.45 Evaluated at bid price : 16.45 Bid-YTW : 5.86 % |
| TRP.PR.A | FixedReset Disc | -3.78 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 17.32 Evaluated at bid price : 17.32 Bid-YTW : 6.08 % |
| MFC.PR.G | FixedReset Ins Non | -3.77 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 21.44 Bid-YTW : 7.39 % |
| RY.PR.Z | FixedReset Disc | -3.69 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.87 Evaluated at bid price : 20.87 Bid-YTW : 5.42 % |
| CM.PR.P | FixedReset Disc | -3.67 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.47 Evaluated at bid price : 20.47 Bid-YTW : 5.52 % |
| CU.PR.F | Perpetual-Discount | -3.64 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 19.05 Evaluated at bid price : 19.05 Bid-YTW : 5.94 % |
| BIP.PR.E | FixedReset Disc | -3.62 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.06 Evaluated at bid price : 21.06 Bid-YTW : 6.30 % |
| RY.PR.H | FixedReset Disc | -3.54 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.98 Evaluated at bid price : 20.98 Bid-YTW : 5.44 % |
| CM.PR.O | FixedReset Disc | -3.53 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.76 Evaluated at bid price : 20.76 Bid-YTW : 5.58 % |
| CM.PR.Q | FixedReset Disc | -3.49 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.70 Evaluated at bid price : 22.15 Bid-YTW : 5.59 % |
| MFC.PR.N | FixedReset Ins Non | -3.45 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.89 Bid-YTW : 8.74 % |
| MFC.PR.M | FixedReset Ins Non | -3.43 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 20.00 Bid-YTW : 8.76 % |
| BIP.PR.F | FixedReset Disc | -3.26 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.66 Evaluated at bid price : 23.75 Bid-YTW : 5.50 % |
| BAM.PR.K | Floater | -3.25 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 15.79 Evaluated at bid price : 15.79 Bid-YTW : 4.43 % |
| TD.PF.B | FixedReset Disc | -3.23 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.95 Evaluated at bid price : 20.95 Bid-YTW : 5.48 % |
| IAG.PR.G | FixedReset Ins Non | -3.22 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 21.36 Bid-YTW : 7.44 % |
| IAG.PR.A | Deemed-Retractible | -3.16 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 20.20 Bid-YTW : 8.88 % |
| BMO.PR.W | FixedReset Disc | -3.15 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.61 Evaluated at bid price : 20.61 Bid-YTW : 5.47 % |
| BIP.PR.A | FixedReset Disc | -3.14 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.53 Evaluated at bid price : 21.90 Bid-YTW : 6.62 % |
| MFC.PR.J | FixedReset Ins Non | -3.09 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 21.96 Bid-YTW : 7.34 % |
| BMO.PR.S | FixedReset Disc | -3.08 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.08 Evaluated at bid price : 21.08 Bid-YTW : 5.51 % |
| SLF.PR.I | FixedReset Ins Non | -2.96 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.00 Bid-YTW : 6.89 % |
| NA.PR.S | FixedReset Disc | -2.93 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.90 Evaluated at bid price : 20.90 Bid-YTW : 5.65 % |
| MFC.PR.I | FixedReset Ins Non | -2.85 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 21.82 Bid-YTW : 7.19 % |
| RY.PR.J | FixedReset Disc | -2.84 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.95 Evaluated at bid price : 22.54 Bid-YTW : 5.45 % |
| TD.PF.E | FixedReset Disc | -2.84 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.61 Evaluated at bid price : 22.94 Bid-YTW : 5.49 % |
| BMO.PR.T | FixedReset Disc | -2.77 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.72 Evaluated at bid price : 20.72 Bid-YTW : 5.48 % |
| TD.PF.D | FixedReset Disc | -2.75 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.27 Evaluated at bid price : 22.61 Bid-YTW : 5.50 % |
| SLF.PR.H | FixedReset Ins Non | -2.73 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.23 Bid-YTW : 8.68 % |
| BAM.PR.T | FixedReset Disc | -2.67 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 17.86 Evaluated at bid price : 17.86 Bid-YTW : 6.20 % |
| HSE.PR.A | FixedReset Disc | -2.66 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 15.00 Evaluated at bid price : 15.00 Bid-YTW : 6.41 % |
| BIP.PR.D | FixedReset Disc | -2.64 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.74 Evaluated at bid price : 23.61 Bid-YTW : 6.24 % |
| POW.PR.D | Perpetual-Discount | -2.60 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.00 Evaluated at bid price : 21.00 Bid-YTW : 6.04 % |
| MFC.PR.H | FixedReset Ins Non | -2.56 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.80 Bid-YTW : 7.16 % |
| TRP.PR.K | FixedReset Prem | -2.48 % | YTW SCENARIO Maturity Type : Call Maturity Date : 2022-05-31 Maturity Price : 25.00 Evaluated at bid price : 24.33 Bid-YTW : 5.74 % |
| CM.PR.S | FixedReset Disc | -2.46 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.51 Evaluated at bid price : 21.78 Bid-YTW : 5.42 % |
| PWF.PR.A | Floater | -2.44 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.00 Evaluated at bid price : 20.00 Bid-YTW : 3.47 % |
| IFC.PR.A | FixedReset Ins Non | -2.21 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 18.15 Bid-YTW : 9.69 % |
| NA.PR.C | FixedReset Disc | -2.20 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.67 Evaluated at bid price : 23.60 Bid-YTW : 5.75 % |
| SLF.PR.B | Deemed-Retractible | -2.12 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 20.75 Bid-YTW : 8.59 % |
| PWF.PR.T | FixedReset Disc | -2.03 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.41 Evaluated at bid price : 21.70 Bid-YTW : 5.42 % |
| W.PR.H | Perpetual-Discount | -1.92 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 23.69 Evaluated at bid price : 24.00 Bid-YTW : 5.79 % |
| NA.PR.E | FixedReset Disc | -1.90 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.39 Evaluated at bid price : 21.70 Bid-YTW : 5.56 % |
| W.PR.J | Perpetual-Discount | -1.90 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 23.53 Evaluated at bid price : 23.80 Bid-YTW : 5.95 % |
| HSE.PR.C | FixedReset Disc | -1.89 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.28 Evaluated at bid price : 21.28 Bid-YTW : 6.40 % |
| TD.PF.A | FixedReset Disc | -1.87 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.00 Evaluated at bid price : 21.00 Bid-YTW : 5.42 % |
| GWO.PR.Q | Deemed-Retractible | -1.78 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.11 Bid-YTW : 7.73 % |
| CU.PR.C | FixedReset Disc | -1.75 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 19.67 Evaluated at bid price : 19.67 Bid-YTW : 5.66 % |
| NA.PR.G | FixedReset Disc | -1.71 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.59 Evaluated at bid price : 23.60 Bid-YTW : 5.32 % |
| BMO.PR.D | FixedReset Disc | -1.71 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.96 Evaluated at bid price : 24.18 Bid-YTW : 5.38 % |
| IAG.PR.I | FixedReset Ins Non | -1.69 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 23.30 Bid-YTW : 6.38 % |
| EMA.PR.H | FixedReset Disc | -1.68 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.51 Evaluated at bid price : 23.40 Bid-YTW : 5.22 % |
| CU.PR.H | Perpetual-Discount | -1.66 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.72 Evaluated at bid price : 23.05 Bid-YTW : 5.70 % |
| BAM.PR.C | Floater | -1.64 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 16.18 Evaluated at bid price : 16.18 Bid-YTW : 4.32 % |
| SLF.PR.E | Deemed-Retractible | -1.60 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.68 Bid-YTW : 9.28 % |
| BIP.PR.B | FixedReset Prem | -1.59 % | YTW SCENARIO Maturity Type : Call Maturity Date : 2020-12-31 Maturity Price : 25.00 Evaluated at bid price : 24.70 Bid-YTW : 6.55 % |
| MFC.PR.B | Deemed-Retractible | -1.55 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.74 Bid-YTW : 9.15 % |
| SLF.PR.C | Deemed-Retractible | -1.51 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.60 Bid-YTW : 9.30 % |
| IFC.PR.E | Deemed-Retractible | -1.48 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.65 Bid-YTW : 7.31 % |
| CU.PR.D | Perpetual-Discount | -1.46 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.53 Evaluated at bid price : 21.53 Bid-YTW : 5.72 % |
| GWO.PR.T | Deemed-Retractible | -1.41 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.40 Bid-YTW : 7.47 % |
| BNS.PR.I | FixedReset Disc | -1.40 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.74 Evaluated at bid price : 23.95 Bid-YTW : 4.98 % |
| GWO.PR.P | Deemed-Retractible | -1.38 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 23.55 Bid-YTW : 6.76 % |
| GWO.PR.H | Deemed-Retractible | -1.32 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 20.93 Bid-YTW : 8.47 % |
| VNR.PR.A | FixedReset Disc | -1.30 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.17 Evaluated at bid price : 22.70 Bid-YTW : 5.55 % |
| GWO.PR.I | Deemed-Retractible | -1.29 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.84 Bid-YTW : 9.12 % |
| BMO.PR.C | FixedReset Prem | -1.29 % | YTW SCENARIO Maturity Type : Call Maturity Date : 2022-05-25 Maturity Price : 25.00 Evaluated at bid price : 24.50 Bid-YTW : 5.14 % |
| PWF.PR.G | Perpetual-Premium | -1.27 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 24.53 Evaluated at bid price : 24.78 Bid-YTW : 6.01 % |
| BMO.PR.E | FixedReset Prem | -1.22 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.88 Evaluated at bid price : 24.25 Bid-YTW : 5.10 % |
| PWF.PR.L | Perpetual-Discount | -1.18 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.44 Evaluated at bid price : 21.70 Bid-YTW : 5.93 % |
| TD.PF.I | FixedReset Disc | -1.18 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 22.99 Evaluated at bid price : 24.31 Bid-YTW : 5.25 % |
| GWO.PR.S | Deemed-Retractible | -1.15 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 23.23 Bid-YTW : 6.86 % |
| PWF.PR.S | Perpetual-Discount | -1.14 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.76 Evaluated at bid price : 20.76 Bid-YTW : 5.84 % |
| BNS.PR.F | FloatingReset | -1.12 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2022-01-31 Maturity Price : 25.00 Evaluated at bid price : 23.78 Bid-YTW : 4.78 % |
| PWF.PR.O | Perpetual-Discount | -1.08 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 24.32 Evaluated at bid price : 24.63 Bid-YTW : 5.94 % |
| MFC.PR.C | Deemed-Retractible | -1.08 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 19.18 Bid-YTW : 9.54 % |
| GWO.PR.G | Deemed-Retractible | -1.06 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.40 Bid-YTW : 7.53 % |
| BMO.PR.Q | FixedReset Bank Non | -1.04 % | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2022-01-31 Maturity Price : 25.00 Evaluated at bid price : 22.76 Bid-YTW : 5.12 % |
| POW.PR.G | Perpetual-Discount | -1.01 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 24.21 Evaluated at bid price : 24.55 Bid-YTW : 5.76 % |
| PWF.PR.Z | Perpetual-Discount | -1.00 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 21.50 Evaluated at bid price : 21.78 Bid-YTW : 5.96 % |
| BAM.PF.C | Perpetual-Discount | 1.04 % | YTW SCENARIO Maturity Type : Limit Maturity Maturity Date : 2048-11-20 Maturity Price : 20.40 Evaluated at bid price : 20.40 Bid-YTW : 6.05 % |
| Volume Highlights | |||
| Issue | Index | Shares Traded |
Notes |
| BNS.PR.H | FixedReset Prem | 77,400 | YTW SCENARIO Maturity Type : Call Maturity Date : 2022-01-26 Maturity Price : 25.00 Evaluated at bid price : 25.40 Bid-YTW : 4.44 % |
| RY.PR.R | FixedReset Prem | 70,700 | YTW SCENARIO Maturity Type : Call Maturity Date : 2021-08-24 Maturity Price : 25.00 Evaluated at bid price : 25.75 Bid-YTW : 4.35 % |
| GWO.PR.N | FixedReset Ins Non | 58,400 | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 15.95 Bid-YTW : 11.40 % |
| GWO.PR.M | Deemed-Retractible | 56,600 | YTW SCENARIO Maturity Type : Hard Maturity Maturity Date : 2025-01-31 Maturity Price : 25.00 Evaluated at bid price : 25.10 Bid-YTW : 5.92 % |
| RY.PR.G | Deemed-Retractible | 38,600 | YTW SCENARIO Maturity Type : Call Maturity Date : 2018-12-20 Maturity Price : 25.00 Evaluated at bid price : 25.10 Bid-YTW : -0.96 % |
| NA.PR.A | FixedReset Prem | 35,800 | YTW SCENARIO Maturity Type : Call Maturity Date : 2021-08-15 Maturity Price : 25.00 Evaluated at bid price : 25.36 Bid-YTW : 4.90 % |
| There were 58 other index-included issues trading in excess of 10,000 shares. | |||
| Wide Spread Highlights | ||
| Issue | Index | Quote Data and Yield Notes |
| MFC.PR.K | FixedReset Ins Non | Quote: 19.50 – 22.00 Spot Rate : 2.5000 Average : 1.4995 YTW SCENARIO |
| MFC.PR.N | FixedReset Ins Non | Quote: 19.89 – 22.25 Spot Rate : 2.3600 Average : 1.3757 YTW SCENARIO |
| BAM.PF.B | FixedReset Disc | Quote: 20.48 – 23.00 Spot Rate : 2.5200 Average : 1.5468 YTW SCENARIO |
| VNR.PR.A | FixedReset Disc | Quote: 22.70 – 24.90 Spot Rate : 2.2000 Average : 1.3775 YTW SCENARIO |
| TRP.PR.C | FixedReset Disc | Quote: 14.80 – 16.80 Spot Rate : 2.0000 Average : 1.1898 YTW SCENARIO |
| TRP.PR.F | FloatingReset | Quote: 17.90 – 19.90 Spot Rate : 2.0000 Average : 1.1945 YTW SCENARIO |
Quick question on the Quotes you show. Do you pull these from Bloomberg or do you have some other APIs that mere mortals like us could use in Excel to track our investments?
Thanks much!
I use paid services. And, unfortunately, I’m not aware of anywhere to get free quotations in an easily downloadable format.
If you do find one, let me know!
Thanks. After some searching, I found Interactive Brokers’ API. You need IB’s Trader Workstation and it allows upto 120 quotes without any charge. Requires a bit of tweaking to get the API and Excel working together, but you can get the delayed/EOD quotes nicely within Excel.
Thanks, that’s useful to know about the IB platform.
In Excel it seems quite difficult, but in a Google spreadsheet I use google finance function:
=GOOGLEFINANCE(“ENB.PF.V”, “name”)
=GOOGLEFINANCE(“ENB.PF.V”, “price”)
With a few exception, like TDB900, TDB952, it works quite well.
Google description of googlefinance() function.
Very nice! Pity it doesn’t have bids and offers.
I’m not sure if you can get quotes for all Preferreds in Google Finance. Perhaps, it’s possible, but not using the commonly used tickers that are used. If it’s possible, can someone please show me?
e.g. how do you get the quote for slf.pr.a in google finance?
Try =GOOGLEFINANCE(substitute(“SLF.PR.A”, “.PR.”,”-“), “name”)
Wow! That’s super awesome. Many thanks!