Ability to group by user defined headings

Hi Guys

I am really enjoying Sharesight, but one thing that would be a big improvement would be the ability to group my holdings in a way that makes sense to me. For example, I don't really want to see Bonds and Shares grouped together under "NZX Securities".

I've also ended up with lots of holdings in the "Other Securities" category, such as managed funds, unlisted bonds, term deposits etc. I would really like to assign each of these to a different group for reporting purposes.

I've looked at your label facility but as these are not mutually exclusive, it isn't much use for this purpose. This shouldn't be that hard .... some additions to the UI, a new column in the database and an extra GROUP BY clause on the SQL?
23 people like
this idea
+1
Reply
next » « previous
  • Angela Thompson (Digital Marketing Manager) May 27, 2016 03:11
    Hi all - just wanted to share this blog article about Asset Allocation that we published this morning - a good starting point for new investors, and for those looking to make the most of our new Custom Groups feature:
    http://www.sharesight.com.au/2016/05/27/asset-allocation-reporting-in-sharesight/
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m undecided
    I applaud Sharesight for implementing this new feature but I cannot see it as being useful while custom groupings are used across all portfolios.

    What I mean is that if I set a custom grouping in Portfolio 2 and enable it and switch back to Portfolio 1 then that custom grouping is applied there as well, even though I don't wan't custom groupings for Portfolio 1 but Group by Market, nor that particular custom grouping inside Portfolio 1.
    • view 1 more comment
    • Hi Martin,

      We have now released the new feature I mentioned above.

      You can now group by market in one portfolio for example, and group by some other category in another portfolio and it will not affect the first portfolio.

      Please reply to this post if you have any questions regarding this new feature.

      Regards
      Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • From my perspective I like this feature as I want to apply most groupings across all f my portfolios. And if I don't, I can just create a new one to apply to the particular portfolio anyway.
    I think it is a fantastic new feature.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • YES!! Brilliant work Sharesight, this is an area my clients having been asking for, I am wrapped with this feature, thank you!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m confused
    I found this feature total rubbish. As soon as i tried it I cant get an accurate listing of my holdings. Old equities sold long ago have come back with value. 3 funds that used to list no problem have gone, but 3 others funds still list. Cant find the documentation how to get back to where it worked
    • Hi John,

      Thanks for your post. It sounds like your reports might be including 'sold positions' rather than just reporting on 'open positions'. This setting can be changed by going into your 'advanced settings' (next tot the date range selector on reports) and selecting report on 'open positions only'.

      Concerning your funds that listed but now have disappeared, this is quite unusual. Could you send a screenshot of this to emma@sharesight.com for us to further investigate?

      Let me know if you have further questions John.

      Cheers,

      Emma
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • This feature is still pretty flakey. Using the drag-drop functionality in firefox is hit and miss - sometimes it saves, sometimes it doesn't. Naming a group is equally faulty. Even after a few attempts it still shows as the default name.
    This error is reported: "Group *********** could not be saved. e.forEach is not a function"
    The product feature itself is a great idea, it just needs to be implemented properly.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • This reply was created from a merged topic originally titled custom asset allocation calcs.

    I'd like to report on my entire portfolio's overall asset allocation eg:

    Aus Shares 30%
    International shares 25%
    Bonds 10%

    etc... including values from managed funds and ETFs.

    I don't think this is possible at the moment?

    I'd like to see it incorporated into the tagging system if possible. So I can set my own asset categories and apply a % of how much of each configured asset contributes to the category (ie a vanguard managed fund I hold might contribute 10% of its value to a "Bonds" tag). And a summary report based on those tags & percentages.

    BTW: VEU.AX is incorrectly marked as in the USA in the diversity report. Also WDIV.AX and others are not 100% australian.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Hi John,

    Thanks for the post. Please bear in mind that with our new Custom Groupings feature (link below) you can define your own asset allocation and apply this view to your portfolio - notably the Diversity Report.

    Please also note that target asset allocation (used in rebalancing) is subjective to your goals, location, and investment types (ETFs e.g.) so we stop short of prescribing a personalised asset allocation and allow you to define your own.

    Investors tend to define asset allocation in many different ways, making it difficult for Sharesight to select a best fit (nor can we provide personal advice).

    As an example, do you consider investments in overseas companies to be just "International Equity" or do you prefer to define by market cap or country or industry?

    We can certainly see the merit in allowing you to compare your portfolio against an asset allocation/weighting of your construction, however, and that is something we will consider as a report enhancement.

    http://help.sharesight.com.au/custom-...

    Doug
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • This reply was created from a merged topic originally titled Custom Groups.

    I have set up several categories under a Custom Group, with each category corresponding to an investment strategy (so I can monitor the performance of each strategy). Are there an unlimited number of Categories that can be set up within a Custom Group? And why is there a limit for no. of Custom Groups? What is its intended purpose?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hi CS2016,

    Thanks for your post! To answer your question, there is currently no limit on how many categories you can add to your Custom Groups. The Custom Groups itself, however, do have a limit. The following plans are allowed to add the following number of Custom Groups: free 1, Investor 3, Expert 5.

    The intended purpose is to provide more value to clients who are on the paid and/or larger Sharesight plans.

    More information on the Custom Groups can be found here: http://help.sharesight.com.au/custom-...

    Have a lovely day.

    Cheers,

    Emma
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hi
    I have used my 5 custom groups under my plan. Just wondering could someone provide me with tips on the best use of labels and how they use them. I'm new to Sharesight and just wondering what people are using labels for in practice once they have used up there quota of custom groups.

    I am tracking 4 people's portfolios in our household and find the most important figures I look at are the total portfolio value, the change in value and the portfolio % return. I have a multitude of different categories of investment. I just introduced my term deposits, which brings down the overall portfolio return but I guess that has to be taken into account! Thanks in advance.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • For what its worth (everyone is different), I use the following headings to see how different sectors are doing, and to check that my allocation stays the way I planned:

    Global ETFs, USA ETFs, Europe ETFs, Asia ETFs, China ETFs, Japan ETFs, Emerging ETFs, Foreign REIT ETF, Domestic REIT ETF, Domestic shares (these are individual shares - not ETFs), Domestic ETFs, and Domestic Bank shares.

    I separate individual domestic shares from domestic ETFs to see how active compares to passive (keeping an eye on weighting and performance).

    I keep my bank shares separate because I want to make sure I do not get overweight in them (I don't exceed 20% of my equity portfolio) Of course I add the domestic ETF holdings in banks to the individual bank shares to come up with a total weight.

    I can look at the diversity of my portfolio on the pie diversity chart (report section) to read off percentages, and I can compare returns in the different sections on the grouped holdings.

    I know that many investor would criticize me for having so many different foreign (and domestic) ETFs as many overlap in their holdings and could be covered in a smaller number, but I like to split rather than lump:)

    I would be grateful for any comments that help me improve although I am happy with what I have described above. Ignorance may be bliss.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hi Mark

    Many thanks for your sharing. My portfolios are pretty much like that too! As long as I have sharesight I figure I'll be able to at least monitor them. I have an index/non index group as well. However I haven't split it out to international index vs domestic index...

    I read an interesting blog by jlcollinsnh.com who has a stock series advocating just two Vanguard funds to hold, an all index fund and a bond fund to keep things simple! I decided that would be far too boring for me! He claims you are going to do just as well doing that as trying to pick a few stocks here and there.
    Anyway I must dig deeper into the sharesight reports and functionality as I still can't figure out the best use of labels. What I'd really like is to be able to set up more than 4 portfolios, especially as I have 4 people I'm tracking for.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Thanks Karin,

    To me investing is not just a way of earning money - it is also a hobby. If I had only two ETFs in my portfolio I would feel like a stamp-collector with only two stamps in his album.

    To me investing is not just a way of earning money - it is also a learning experience. If an expert says that two ETFs do as well as 5, I want to check that for myself - so I buy 7 and follow them to see whether they all do the same (it's my experience so far that they don't).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Interesting discussion.

    In my own portfolio I have a similar approach but fewer categories. Aussie shares active and Aussie shares passive. I then have the same -- active and passive -- for international shares. This only uses one custom group. I don't use labels much anymore -- I find the custom groups are more useful. I also have cash as well, which I treat as an asset class as well as an overall cash/stocks allocation.

    In the Aussie active I hold all my individual ASX stocks. In the Aussie passive I hold the two main Aussie stock ETFs -- STW and VAS. The active and passive have roughly equal amounts in them and that is my target. This way I can actively choose stocks without regard to sector weights, etc. I just buy the stocks I think will do well and take a pretty concentrated approach. The ETFs take care of sectors etc.. and give me the diversification I need. So far the active stocks are beating the passive. It's good to know I am not wasting my time! the active is certainly more volatile, however, so I do need to pay attention.

    For international passive I have three ETFs covering all the major markets. I try and keep these pretty much in proportion to the market weightings. You can find good info on this on the Ishares website.

    International active is a small number of active managed funds and some more specialised ETFs like emerging markets and Japan. While these are passive ETFs I am effectively making a stock pick by over-weighting these markets relative to the world index. so I consider them as active picks.

    At this stage passive international is beating active international, although active has done well in the last year. The passive killer ETF has been IVV which covers the US and has done exceptionally well in the last 5 years, particularly in AUD terms.

    ecco -- if you are managing four portfolios for 4 different entities I would strongly recommend a portfolio for each. That will make the tax much easier and cleaner. You can use consolidated views if you want to see the overall performance. And you can use custom groupings across consolidated views as well.

    Hope that helps,

    Andrew Bird
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Thanks Andrew for your explanation. I have somewhat more holdings than you! I'm still coming to grips with sharesight, I think it's fabulous but just need to delve into it a bit more. It's good to know you don't rely on the labels for anything. I thought I was missing out on something.

    Anyway despite my hit and miss approach the returns have been pretty ok for me probably due to the US market holdings I have. Maybe I can keep that up for the next few years?!

    I've taken my cash holdings out of sharesight - they drag the overall return down too much!

    I'll keep learning. Thanks
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly sad, anxious, confused, frustrated happy, confident, thankful, excited indifferent, undecided, unconcerned

next » « previous