Author Topic: portfolio xray for ppl in Canada?  (Read 2438 times)

scrubbyfish

  • Guest
portfolio xray for ppl in Canada?
« on: October 27, 2016, 02:14:15 PM »
arebelspy recently linked to this: http://portfolio.morningstar.com/Rtport/Free/InstantXRayDEntry.aspx

Because my porfolio is necessarily complex, that thing is my dream!
It doesn't seem to recognize several of my ticker symbols, though.
A Canadian Couch Potato reader noted the same.

Is there something like this for folks in Canada?

scrubbyfish

  • Guest
Re: portfolio xray for ppl in Canada?
« Reply #1 on: October 28, 2016, 02:44:08 PM »
...even a similar paid tool, I'd go for...

Something that does the percentages-math for me, like recognizes which fund is 99% Cdn stocks, which is 54% int'l and 46% US, which is 100% US, etc, and makes a nice chart accordingly.

Heckler

  • Handlebar Stache
  • *****
  • Posts: 1346
Re: portfolio xray for ppl in Canada?
« Reply #2 on: October 28, 2016, 05:40:58 PM »
Secret hint.  Register and log into Vanguard Canada as an advisor.  There are some handy tools available.

daverobev

  • Magnum Stache
  • ******
  • Posts: 3340
  • Location: UK
Re: portfolio xray for ppl in Canada?
« Reply #3 on: October 28, 2016, 07:51:59 PM »
Forgive me if I'm asking things you've already explained elsewhere.

Necessarily complex - how so, in that it can't be covered by equity (Canadian, American, developed-ex-N. America, and developing), and bonds (Canadian short and long, or just a single ETF), and perhaps REITs?

If you're asking considering your CURRENT allocation - what I did when I was trying to work out what I have where in my completely unneccessarily complex portfolio was make a spreadsheet. Stick stuff in, hand-wave a bit, and come out with rough percentages - discounting the value of anything in an RRSP by ~20% because I'll pay tax when it comes out.

Not great by any means (for example, I have VXUS, and I really made approximations of what regions/buckets things were in - but honestly this was the worst fund, in that it is... well, world ex America).

Or do you have to have actual mutual funds that are... "themed"... or something? Rather than the straight forward "Canada" (ZCN, VCN), America (VUN, VTI), etc?

Excel's pretty good...

daverobev

  • Magnum Stache
  • ******
  • Posts: 3340
  • Location: UK
Re: portfolio xray for ppl in Canada?
« Reply #4 on: October 28, 2016, 07:54:42 PM »
Oh, man, that site is crap! I just put in VXUS, IEMG, and ICLN, and it came out with... Not Classified, 100%.

LOL! What a load of rubbish. It's for US, as in actual US companies, only.

scrubbyfish

  • Guest
Re: portfolio xray for ppl in Canada?
« Reply #5 on: October 28, 2016, 08:06:39 PM »
Secret hint.  Register and log into Vanguard Canada as an advisor.  There are some handy tools available.

Cool! I'll give that a go :)

...a spreadsheet. Stick stuff in, hand-wave a bit, and come out with rough percentages

Disability rules give my kid and me great deals on certain paths, but they also dictate what we can have, where. So, when I want a simple 30/30/30/10 Cdn stocks/US stocks/Intl stocks/Cdn bonds, I am required to achieve these through a mix and match of funds—for example, not all Vanguard ETF for US stocks. One fund is 54/46 intl/US (or vice versa) so I have to account for that split in relation to the single region funds, etc.

I've been using a spreadsheet, and developed formulas for aspects of it, but it's still a nightmare. The nightmare causes me delays in buying more.

LOL! What a load of rubbish. It's for US, as in actual US companies, only.

Yep.

I have a query in to Morningstar Canada, re: whether they have anything for other humans. Will report here if anything helpful comes of it.

daverobev

  • Magnum Stache
  • ******
  • Posts: 3340
  • Location: UK
Re: portfolio xray for ppl in Canada?
« Reply #6 on: October 28, 2016, 09:20:28 PM »
If it's a lot of work, I don't think I'd worry about exact percentages too much. Do what you can, but the difference between 35 US/ 25 ROW and 30/30 isn't honestly going to matter too much. Certainly not if it means money that should be invested is sat on the sidelines.

scrubbyfish

  • Guest
Re: portfolio xray for ppl in Canada?
« Reply #7 on: October 29, 2016, 10:54:29 AM »
Checked out Heckler's idea—brilliant!! I think we're only able to put in six items at a time, unfortunately.

Morningstar wrote back: "The securities you are looking for can be found on our Canada site rather than the US site. Please go to Morningstar.ca and register for a free account. There, you can create a portfolio and use the X-ray tool." Will do.

From something I read, I think the first one is based on the second. Maybe, maybe not.

I cozied up with my spreadsheet template this morning. It's definitely faster going as I come to learn it. At this point, I'm down to about one hour all told to pull up each investment account, print the holdings, manually jot down everything the printer didn't print, type everything in to the spreadsheet, tweak and correct my spreadsheet...all without yet calculating rebalance amounts. So, pokey and convoluted, but getting better over time. Took Steps 1 and 2 to see about starting a spreadsheet course in January, so I can sort out its problem areas.

arebelspy

  • Administrator
  • Senior Mustachian
  • *****
  • Posts: 27911
  • Age: -999
  • Location: Traveling the World
Re: portfolio xray for ppl in Canada?
« Reply #8 on: November 05, 2016, 08:37:15 PM »
Morningstar wrote back: "The securities you are looking for can be found on our Canada site rather than the US site. Please go to Morningstar.ca and register for a free account. There, you can create a portfolio and use the X-ray tool." Will do.

How'd this work out for you?  :)
We are two former teachers who accumulated a bunch of real estate, retired at 29, and now travel the world full time with two kids.
If you want to know more about me, or how we did that, or see lots of pictures, this Business Insider profile tells our story pretty well.
We (rarely) blog at AdventuringAlong.com. Check out our Now page to see what we're up to currently.

MustacheAndaHalf

  • Handlebar Stache
  • *****
  • Posts: 1764
Re: portfolio xray for ppl in Canada?
« Reply #9 on: November 05, 2016, 09:28:27 PM »
Oh, man, that site is crap! I just put in VXUS, IEMG, and ICLN, and it came out with... Not Classified, 100%.

LOL! What a load of rubbish. It's for US, as in actual US companies, only.
It worked fine for me.  I searched for "morningstar x ray" and filled in those symbols with 34-33-33%, and shows 55% foreign, 42% U.S., 2% other, 1% cash.  Seems to be working fine.
http://portfolio.morningstar.com/Rtport/Free/InstantXRayDEntry.aspx?ChangeMode=P&entrynum=10&productcode=

Focusing that x-ray on ICLN (fund name "iShares S&P Global Clean Energy Index") I learned about half it's holdings are in utility companies.

daverobev

  • Magnum Stache
  • ******
  • Posts: 3340
  • Location: UK
Re: portfolio xray for ppl in Canada?
« Reply #10 on: November 06, 2016, 06:04:09 AM »
Oh, man, that site is crap! I just put in VXUS, IEMG, and ICLN, and it came out with... Not Classified, 100%.

LOL! What a load of rubbish. It's for US, as in actual US companies, only.
It worked fine for me.  I searched for "morningstar x ray" and filled in those symbols with 34-33-33%, and shows 55% foreign, 42% U.S., 2% other, 1% cash.  Seems to be working fine.
http://portfolio.morningstar.com/Rtport/Free/InstantXRayDEntry.aspx?ChangeMode=P&entrynum=10&productcode=

Focusing that x-ray on ICLN (fund name "iShares S&P Global Clean Energy Index") I learned about half it's holdings are in utility companies.

Must be because I have adblock going. Makes life annoying, but still better than seeing all the adverts. I'll have to try a different browser sometime.

MustacheAndaHalf

  • Handlebar Stache
  • *****
  • Posts: 1764
Re: portfolio xray for ppl in Canada?
« Reply #11 on: November 06, 2016, 07:54:32 AM »
Oh, man, that site is crap! I just put in VXUS, IEMG, and ICLN, and it came out with... Not Classified, 100%.

LOL! What a load of rubbish. It's for US, as in actual US companies, only.
It worked fine for me.  I searched for "morningstar x ray" and filled in those symbols with 34-33-33%, and shows 55% foreign, 42% U.S., 2% other, 1% cash.  Seems to be working fine.
http://portfolio.morningstar.com/Rtport/Free/InstantXRayDEntry.aspx?ChangeMode=P&entrynum=10&productcode=

Focusing that x-ray on ICLN (fund name "iShares S&P Global Clean Energy Index") I learned about half it's holdings are in utility companies.
Must be because I have adblock going. Makes life annoying, but still better than seeing all the adverts. I'll have to try a different browser sometime.
That's odd because running AdBlock Plus didn't trigger it for me.  Maybe it's geo-location related.