Pairs Equivalency Calculator

I discussed the concept during my seminar on Floating Rate Issues; prepared a spreadsheet that was linked in the February 2010 Edition of PrefLetter; and have finally linked it in a “PrefPick” in Canadian Moneysaver … so it’s time to link to it publicly.

The Pairs Equivalency Calculator allows for easy valuation comparison between elements of a Strong Pair. ‘Nuff said?

9 Responses to “Pairs Equivalency Calculator”

1. […] trying to decide which way to jump may be interested in the Pairs Equivalency Calculator I published earlier this year. I will post again once the final rate is […]

2. […] announcement of the Selected Percentage Rate was reported on PrefBlog. Data for the Pairs Equivalency Calculator have been updated, but as yet the RatchetRate complement to this issue, Series Q, does not […]

3. […] we can use this price for comparison purposes since it is close to the other BCE RatchetRates. The Pairs Equivalency Calculator (quick method) tells us that given a price of 22.40 on BCE.PR.E and 23.75 on BCE.PR.F, Canada Prime […]

4. […] to the “Quick Method” of the updated Pair Equivalency Calculator, this implies that the break-even 3-Month Bill rate is […]

5. […] We can examine the comparables with the help of the Pairs Equivalency Calculator: […]

6. […] We can examine the comparables with the help of the Pairs Equivalency Calculator: […]

7. […] We can examine the comparables with the help of the Pairs Equivalency Calculator: […]

8. Yahoo! Finance keeps changing their interface for quote downloads, breaking spreadsheets such as this one. Has anyone taken a run at update/fixing this useful calculator? Question also raised on FWF, see https://www.financialwisdomforum.org/forum/viewtopic.php?f=33&t=122700

9. jiHymas says:

Googledocs (see the Yield Calculator for an example) should be able to do it, with judicious use of the GOOGLEFINANCE function.

Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider.