{"id":15498,"date":"2011-06-26T16:50:49","date_gmt":"2011-06-26T20:50:49","guid":{"rendered":"http:\/\/www.prefblog.com\/?p=15498"},"modified":"2011-06-26T16:50:49","modified_gmt":"2011-06-26T20:50:49","slug":"himipref-yield-calculation-change","status":"publish","type":"post","link":"https:\/\/prefblog.com\/?p=15498","title":{"rendered":"HIMIPref&#8482; Yield Calculation Change"},"content":{"rendered":"<p>In the comments to the <a href=\"http:\/\/www.prefblog.com\/?p=15440\">June 22<\/a> report, Assiduous Reader <i>drap1<\/i> asked:<\/p>\n<blockquote><p>Hi\u2026quick question about last prefletter. I\u2019ve seen this other times, but here is a clear example:<\/p>\n<p>With respect to TRP.PR.B and TRP.PR.C, TRP.PR.C has a higher dividend, higher reset price and higher market price (both are above $25); however, your model evaluates TRP.PR.C to perpetuity, but TRP.PR.B, to its reset date. What am I missing? Why doesn\u2019t TRP.PR.C get evaluated to its reset date?<\/p>\n<p>TRP.PR.C does resets a year later which could create a small difference depending on the yld curve, but I don\u2019t think that\u2019s the answer.<\/p><\/blockquote>\n<p>Good question! For a quick answer, here are the summaries of the two <a href=\"http:\/\/www.prefshares.com\/glossary.html#optionCalculationList\">optionCalculationLists<\/a> on the <a href=\"http:\/\/www.prefshares.com\/glossary.html#pseudoPortfolioReportBox\">pseudoPortfolioReportBox<\/a>:<\/p>\n<blockquote><p>Report Box<br \/>\nInstrument\u2022:\u2022TRP.PR.B (Security A51015)<br \/>\nPseudoPortfolioElement: Pricing Modification &#8211; Base Option ID: Undefined<br \/>\nReporting: YTM (Port Method) at Bid<br \/>\n*****<br \/>\nEvaluated at bid price : 25.4000<br \/>\nCall 2015-07-30 YTM: 3.51 % [Restricted: 3.51 %] (Prob: 45.09 %)<br \/>\nCall 2020-07-30 YTM: 3.46 % [Restricted: 3.46 %] (Prob: 0.30 %)<br \/>\nLimit Maturity 2041-06-10 YTM: 3.47 % [Restricted: 3.47 %] (Prob: 54.61 %)<br \/>\nYTM (Port Method) : 3.4865 %<\/p><\/blockquote>\n<p>and<\/p>\n<blockquote><p>Report Box<br \/>\nInstrument\u2022:\u2022TRP.PR.C (Security A51016)<br \/>\nPseudoPortfolioElement: Pricing Modification &#8211; Base Option ID: Undefined<br \/>\nReporting: YTM (Port Method) at Bid<br \/>\n*****<br \/>\nEvaluated at bid price : 25.9000<br \/>\nCall 2016-02-29 YTM: 3.65 % [Restricted: 3.65 %] (Prob: 52.02 %)<br \/>\nLimit Maturity 2041-06-10 YTM: 3.56 % [Restricted: 3.56 %] (Prob: 47.98 %)<br \/>\nYTM (Port Method) : 3.6095 %<\/p><\/blockquote>\n<p>So part of the problem is a stenographical error: I should have specified that the call on TRP.PR.B was calculated to the second reset date but, frankly, missed that when transcribing the table.<\/p>\n<p>However, the interesting question is the appearance of second reset date in the TRP.PR.B table but not in the TRP.PR.C table, particularly given that the probability of exercise of this option is less than half a percent.<\/p>\n<p>Possible options are added to the calculation list only if the probability of exercise, when initially calculated, is greater than the value <a href=\"http:\/\/www.prefshares.com\/glossary.html#OPTION_EXERCISE_CALCULATION_INCREMENT_PROBABILITY\">OPTION_EXERCISE_CALCULATION_INCREMENT_PROBABILITY<\/a>, which is currently set to 5%. However, subsequent normalizations did not enforce this constraint.<\/p>\n<p>Additionally, as can be seen from the <a href=\"http:\/\/www.prefshares.com\/glossary.html#cashFlowDiscountingAnalysisBox\">cashFlowDiscountingAnalysisBox<\/a>, the <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2011\/06\/TRPB_CF_2020.pdf'>cash flows to 2020 for TRP.PR.B<\/a> extend one month further than the actual call date, as has been previously discussed on PrefBlog in the post <a href=\"http:\/\/www.prefblog.com\/?p=6357\">What is the Yield of RY.PR.Y?<\/a> due to the influence of the <a href=\"http:\/\/www.prefshares.com\/glossary.html#maturityNoticePeriod\">maturityNoticePeriod<\/a>.<\/p>\n<p>&#8220;Cliff Effects&#8221; are a bugaboo in all analysis and have been blamed, at least in part, for the Panic of 2007 (since a credit rating downgrade raised the capital requirements for all regulated holders, who therefore all had a strong prediliction to sell at the same time). By its nature, YTW is subject to cliff effects, at least insofar as it comes to reporting the duration of the YTW scenario (the amount of change in duration for relatively small changes in price is measured by the attribute <a href=\"http:\/\/www.prefshares.com\/glossary.html#pseudoConvexityWorst\">pseudoConvexityWorst<\/a>).<\/p>\n<p>Two changes in programming have been made that should make the calculations at least little easier to explain, although cliff effects will still be present:<br \/>\ni) The constraint <a href=\"http:\/\/www.prefshares.com\/glossary.html#OPTION_EXERCISE_CALCULATION_INCREMENT_PROBABILITY\">OPTION_EXERCISE_CALCULATION_INCREMENT_PROBABILITY<\/a> is enforced during the normalization of option exercise probabilities<br \/>\nii) <a href=\"http:\/\/www.prefshares.com\/glossary.html#maturityNoticePeriod\">maturityNoticePeriod<\/a> is only accounted for when the exercise date is less than <a href=\"http:\/\/www.prefshares.com\/glossary.html#MATURITY_NOTICE_PERIOD\">MATURITY_NOTICE_PERIOD<\/a> days from the calculation date.<\/p>\n<p>I have been toying with the second idea for quite some time and the change will save me a lot of explanations regarding yield calculation. I&#8217;ve resisted the idea because (a) as far as I can tell, it won&#8217;t make much difference and (b) a complex analytical programme is a chaotic system, meaning that small changes to some parts can cause huge differences in output under certain conditions. But now seems as good a time as any to proceed.<\/p>\n<p>The effect of these changes on the YTW calculation is displayed in the following reports:<\/p>\n<ul>\n<li><a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2011\/06\/TRPB_Summary_110610_Revised.pdf'>TRPB_Summary_110610_Revised<\/a>\n<li><a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2011\/06\/TRPC_Summary_110610_Revised.pdf'>TRPC_Summary_110610_Revised<\/a><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In the comments to the June 22 report, Assiduous Reader drap1 asked: Hi\u2026quick question about last prefletter. I\u2019ve seen this other times, but here is a clear example: With respect to TRP.PR.B and TRP.PR.C, TRP.PR.C &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-15498","post","type-post","status-publish","format-standard","hentry","category-programme-bugs"],"_links":{"self":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/15498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15498"}],"version-history":[{"count":0,"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/15498\/revisions"}],"wp:attachment":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}