Search found 527 matches

by big easy
19 Nov 2017 17:23
Forum: Financial News, Policy and Economics
Topic: Clippings 2017
Replies: 286
Views: 16439

Re: Clippings 2017

Why not substitute a HISA for a tax efficient bond ETF? If it's CDIC insured, you should have the same credit risk as a government of Canada bond. Minimal liquidity risk. No interest rate risk. No tax inefficiency of premium bonds. No costs to buy or sell. Cash is a reasonably good inflation hedge,...
by big easy
17 Nov 2017 10:28
Forum: Under the Mattress: Protecting Your Money
Topic: Paying with Paypal using a USD bank account from a canadian bank to avoid conversion fees
Replies: 9
Views: 157

Re: Paying with Paypal using a USD bank account from a canadian bank to avoid conversion fees

I think it is part of Paypal or Ebay's business model to collect those 2.5% fx fees. I have a credit card which does not charge any Fx fee (Amazon visa from Chase), however when I have ordred on Ebay, they always convert from USD to CAD and charge 2%+. I would be interested in knowing how to avoid t...
by big easy
06 Nov 2017 15:58
Forum: Financial Planning and Building Portfolios
Topic: Strip bonds or Bond ETF
Replies: 16
Views: 510

Re: Strip bonds or Bond ETF

I think this article sums how things can go wrong but why it is still a good ideal to hold bonds. http://awealthofcommonsense.com/2015/03/the-blueprint-for-a-bond-bear-market/ A much better comparison, if you want to make one, would be the 1950s. At the start of 1950 the 10 year yielded 2.3%. It ros...
by big easy
05 Nov 2017 12:28
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 177
Views: 27717

Re: How to download data?

For people who are looking for a replacement for GETYAHOO or the SMF add-in now that Yahoo has killed their interface: How to get quotes from GoogleFinance/GoogleSheets into LibreOffice . I imagine something similar will work with Excel. I don't have a copy of that product to test with. That's more...
by big easy
04 Nov 2017 00:41
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 177
Views: 27717

Re: How to download data?

I have all my data in a legacy excel spreadsheet that I'd rather not recreate in Google Sheets. Anyhow I figured out a work around. I "published" my google sheet to a web address. Then I query that web address in excel using the Data > From Web command to download the google sheets data to my excel ...
by big easy
02 Nov 2017 21:41
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 177
Views: 27717

Re: How to download data?

I guess i'll have to go back to Google Sheets using the Googlefinance() command and cut and paste the results into excel. :(

Too bad excel doesn't have a Googlefinance() function.
by big easy
01 Nov 2017 21:29
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 177
Views: 27717

Re: How to download data?

Download to excel not working right now - cell shows #VALUE! error
by big easy
28 Oct 2017 18:08
Forum: Financial News, Policy and Economics
Topic: Clippings 2017
Replies: 286
Views: 16439

Re: Clippings 2017

Behind the G&M pay wall: Hey, Canadian stock market: Thanks for 10 years of nothing - The Globe and Mail On an after-inflation basis, the S&P/TSX composite index lost money over the past decade. The index averaged a gain of 1.1 per cent annually for the 10 years to late-October, while inflation ave...
by big easy
27 Oct 2017 17:18
Forum: Financial News, Policy and Economics
Topic: NAFTA Renegotiation
Replies: 63
Views: 3293

Re: NAFTA Renegotiation

If Trump won't be reasonable, I think the Liberals will just try and wait it out. Mid term elections are next year and there is the issue of whether Trump can even cancel the deal himself or if he needs Congress. Then hope to god he doesn't get re-elected.
by big easy
27 Oct 2017 12:38
Forum: Financial News, Policy and Economics
Topic: Clippings 2017
Replies: 286
Views: 16439

Re: Clippings 2017

A study of DBRS bond default rates and rating transitions from 1976-2015 for those interested in corporate bonds. The is a list of 57 defaults brings back memories - Olympia & York and Lehman Bros. were the only two issues to be AA at the time of default.

DBRS Study
by big easy
27 Oct 2017 12:26
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: What did you Buy? What might you buy? (2017)
Replies: 501
Views: 48119

Re: What did you Buy? What might you buy? (2017)

And I recently purchased the Apr 2025 BCE (A low) strip with YTM of 3.08% to tack onto our RRSP bond ladder. I've been purposefully avoiding direct ownership of BBB or lower credits What's your opinion on CBH. Mostly A or AA , 10 year corporate bond ladder with a average YTM around 2.7% (less 0.3% ...
by big easy
26 Oct 2017 16:11
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: What did you Buy? What might you buy? (2017)
Replies: 501
Views: 48119

Re: What did you Buy? What might you buy? (2017)

And I recently purchased the Apr 2025 BCE (A low) strip with YTM of 3.08% to tack onto our RRSP bond ladder. I've been purposefully avoiding direct ownership of BBB or lower credits What's your opinion on CBH. Mostly A or AA , 10 year corporate bond ladder with a average YTM around 2.7% (less 0.3% ...
by big easy
25 Oct 2017 22:07
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: History of Discount Brokers in Canada
Replies: 13
Views: 342

Re: History of Discount Brokers in Canada

Some historical background here - mostly TD centric. Link Soon after the hearing, TD purchased Loewen, Ondaatje, McCutcheon & Company’s base of 800 discount brokerage accounts. By early 1984, Green Line began its operations with eight employees andone telephone line under Keith Gray’s leadership. Th...
by big easy
25 Oct 2017 21:37
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: History of Discount Brokers in Canada
Replies: 13
Views: 342

Re: History of Discount Brokers in Canada

I seem to recall getting 5 1/2" floppy drives from TD Green Line with which to install software on my computer. I think you connected to their servers via dial up modem but I can't remember. I think it operated on DOS but again I can't be sure. We have come along way.
by big easy
22 Oct 2017 11:12
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: YTM vs returns -- Bond ETF 2 years later
Replies: 16
Views: 786

Re: YTM vs returns -- Bond ETF 2 years later

Agreed, some bonds in a fund will have matured and reinvested with different YTMs which will necessarily affect the fund return. Assuming a 10 year ladder with 10 bonds and a 4 year duration, after 4 years 4 of the bonds have matured and been reinvested into 10 year bonds at different ytm. But if yo...
by big easy
21 Oct 2017 22:16
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: YTM vs returns -- Bond ETF 2 years later
Replies: 16
Views: 786

Re: YTM vs returns -- Bond ETF 2 years later

There's a thread over at Bogleheads which suggests SEC Yield (YTM-MER) is a decent predictor of future returns. There's even a post by some guy named Longinvest.

https://www.bogleheads.org/forum/viewto ... 3#p2339965
by big easy
21 Oct 2017 18:28
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: YTM vs returns -- Bond ETF 2 years later
Replies: 16
Views: 786

Re: YTM vs returns -- Bond ETF 2 years later

Longinvest,

As proof of your argument you compared the 2 year actual return of VAB to the YTM. As Altared pointed out you should be using a 5-7 year forward return in line with the duration of the fund which is 6 years.
by big easy
21 Oct 2017 16:15
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: YTM vs returns -- Bond ETF 2 years later
Replies: 16
Views: 786

Re: YTM vs returns -- Bond ETF 2 years later

I think the graph speaks for itself. I didn't say it was an exact prediction of future return but there is an obvious correlation there.
by big easy
21 Oct 2017 10:54
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: YTM vs returns -- Bond ETF 2 years later
Replies: 16
Views: 786

Re: YTM vs returns -- Bond ETF 2 years later

Better late than never.... http://i68.tinypic.com/1z2oq2u.png Sorry for the grainy image but you can find the source here: http://econompicdata.blogspot.ca/2012/02/some-more-ugly-bond-math.html The graph shows that YTM is a reasonable predictor of actual return over longer periods of time correspond...
by big easy
13 Oct 2017 18:15
Forum: Under the Mattress: Protecting Your Money
Topic: Tangerine
Replies: 38
Views: 3203

Re: Tangerine

Thank you Descartes! I agree the website is a little buggy and design is not intuitive. For example, I entered my request to download transactions for the month of August, and was then directed to another screen where I had to enter the same information a second time. Kinda like when you phone a ban...
by big easy
13 Oct 2017 17:25
Forum: Under the Mattress: Protecting Your Money
Topic: Tangerine
Replies: 38
Views: 3203

Re: Tangerine

Anybody know how to download transaction data to a spreadsheet? I've got a Tangerine CC - surely the new website would allow one to download to a csv file, but it appears not.
by big easy
23 Sep 2017 21:51
Forum: Financial Planning and Building Portfolios
Topic: Strategy and Performance Tracking
Replies: 22
Views: 1177

Re: Strategy and Performance Tracking

I too use a spreadsheet to track the value of each account and our (wife and me) total new worth. I track the buys and sells, dividends, ACB, gains and losses for securities held in taxable accounts only and don't bother if it's held in a RSP, TFSA etc. I used to track them all but found it too time...
by big easy
16 Sep 2017 10:56
Forum: Financial Planning and Building Portfolios
Topic: Harvesting of capital gains
Replies: 9
Views: 497

Re: Harvesting of capital gains

I have heard of a similar strategy done just prior to retirement. This is to avoid loosing a big chunk of your savings in the first years of retirement and gradually building back up to your target equity allocation. Probably done over 0-3 years not 10 and preferably in early retirement when your ta...