ETF & Mutual Fund overlap

Options
Wyodad
Wyodad Quicken Mac Other Member ✭✭
in Investing (Mac)

Perhaps I am looking to do something crazy!!

Wanting to be able to download the top 10 holdings in my mutual funds & ETF to look for overlap and how much we are not diversified. I can see the holding(s) within Security overview of each, but can't see the option to download so I can evaluate in numbers or excel. I've looked at Fidelity and discussed with their CS and was told that is not something available within their tools. Directed me to another site and it too did not offer the download option. It would compare 2 funds/ETF, but no option for output. Looked at Morningstar and nothing with a basic account.

Any input on the topic is appreciated as well as what I might be missing within Quicken.

Quicken Classic for Mac (8.2.1)

Peter

Comments

  • Jon
    Jon Quicken Mac Subscription SuperUser, Mac Beta Beta

    I don't think Quicken has that information stored in your data file. When you click on Security Overview it takes you to an external website. You might have to just manually copy that info from the web page into a spreadsheet.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited July 7

    This is what Morningstar calls the Stock Intersection in their Portfolio X-Ray. You can view but not print or export a version of this in QWin Premier. The Quicken version is limited to the 50 largest holdings of stocks in your portfolio. I don't think this is available in QMac.

    A more complete version is available on the Morningstar website if you have a Morningstar subscription. This is $250/yr, but you can get a 7 day free trial if you are interested.

    From QMac, you should be able to export your holdings to a CSV file and import them to a Morningstar portfolio to see the analysis, or M* can connect directly to most brokerages to download your holdings.

    QWin Premier subscription
  • Wyodad
    Wyodad Quicken Mac Other Member ✭✭

    Jim,

    Thank you for the info. I did have a look at Morningstar X-Ray and did see some potential there as I would be happy with the top 10 holdings in each of my ETF & funds. I will take a look at your export suggestion to my brokerage and see what that might bring.

    Jon,

    Got ya on the external site from overview, but am hoping to find some automation as there will be a day when the data needs to be updated and don't want to be reinventing the wheel.

    Again thank you and have a great day,

Categories