Coolly Comparing Investment Platform charges - SnowMan's spreadsheet

SnowMan
SnowMan Forumite Posts: 3,293
Part of the Furniture 1,000 Posts Photogenic
Forumite
edited 12 May 2020 at 6:29AM in Savings & investments
It isn't any longer possible to edit the post linking to my investment platform comparison spreadsheet, so I thought I'd set up a new thread.

The thread is set up to provide a link to a spreadsheet enabling annual platform charges to be calculated and compared between platforms. This includes both custody charges for holding funds and/or shares/ETFs, and for dealing costs based on the number of annual sales and purchases of funds or shares/ETFs.

The spreadsheet (version 35 currently) can be downloaded by going to this link and downloading the file.

https://drive.google.com/file/d/1wacGNlqMm2ehFSDY02NLLZ_ccBa6JdU2/view?usp=sharing

The basic idea is that platform charges and fund manager charges are now separated. So the starting point in looking at costs, in choosing an investment platform, is to compare platform costs for your own particular mix of ISAs, dealing account and SIPPs and based on your mix of funds and shares/ETFs.

The principle is that fund manager costs can be ignored as they cancel out, that is they are the same for each platform. This ignores any 'super clean' funds offered by some platforms, certain 'dirty' funds which have higher charges, and ignores the lack of availability of some funds or ETFs on some platforms.

The answers are shown as £ figures and percentages (so you can use the latter to add in your average percentage fund manager cost to estimate your total cost).

Most of the other comparisons I have seen only compare ISA only or SIPP only or dealing account only portfolios. This does not allow for the considerable discounts on SOME platforms for holding ISAs and SIPPs and dealing accounts on the same platform.

That is why the spreadsheet allows you to add in all the different accounts so these discounts can be considered.

It is also a good idea to look at options of keeping funds and shares separately. This is why the spreadsheet works out an everything together cost, a shares and ETFs only cost (based on the shares and ETF element only) and a funds only cost (based on the funds element only)

There is also a column that calculates exit charges by way of re-registration. High exit cost platforms should other things being equal be avoided, because it will be difficult to switch to other platforms following a price increase, without significant cost.

Some of these platforms (in particular AJ Bell Youinvest) have form for putting up charges without allowing customers the temporary option of a free exit through re-registration (past OFT guidance seems to suggest they can't do this but not everyone will want to take a case through the county courts, and the legal position remains unclear). The Financial Ombudsman Service, in my view, are causing significant customer detriment by not properly assessing fairness in relation to applying unfair terms legislation, and this is compounded by the inaction of the Financial Conduct Authority to deal with this issue.

The spreadsheet is a continual work in progress but it is just about getting there. Because of the incredible complexity of charging structures and the complicated interactions between accounts there are bound to be a few errors in there.

I will update the spreadsheet and link when a new version of the spreadsheet is produced.
I came, I saw, I melted
«13456710

Comments

  • SnowMan
    SnowMan Forumite Posts: 3,293
    Part of the Furniture 1,000 Posts Photogenic
    Forumite
    edited 8 January 2017 at 8:33PM
    Some other DIY investment platform comparison tools that are available are:-

    The Monevator broker comparison table provides a detailed summary of platform charges.

    The excellent Justin Modray's Compare Fund Platforms website and tool.

    The langcat consultancy have a downloadable direct platform guide (which importantly includes cat pictures) and produce regular heat mapped comparisons of investment platforms in their blog (this is the latest version I can find) and these comparisons are used in some newspaper articles.
    I came, I saw, I melted
  • LHW99
    LHW99 Forumite Posts: 3,842
    Part of the Furniture 1,000 Posts Name Dropper
    Forumite
    Thanks Snowman, I'm sure many will find this useful, as will I
  • darkidoe
    darkidoe Forumite Posts: 1,125
    Seventh Anniversary 1,000 Posts Name Dropper
    Forumite
    Excellent tool! Just what we need! Thanks!

    Save 12K in 2020 # 38 £0/£20,000
  • bigadaj
    bigadaj Forumite Posts: 11,531
    Ninth Anniversary 10,000 Posts Name Dropper
    Forumite
    'Fund manager costs cancel out' what about HL's special deals......
  • chockydavid1983
    chockydavid1983 Forumite Posts: 711
    Part of the Furniture 500 Posts
    Forumite
    Nice one SnowMan
  • jdw2000
    jdw2000 Forumite Posts: 418
    Ninth Anniversary 100 Posts
    Forumite
    Thank you, Snowman. That is a fantastic contribution.
  • jdw2000
    jdw2000 Forumite Posts: 418
    Ninth Anniversary 100 Posts
    Forumite
    edited 9 January 2017 at 11:59AM
    Next to Halifax it should probably say the same as it says next to iWeb: "£60 charge for transferring into SIPP not included in figures". That applies to both of them.
  • talexuser
    talexuser Forumite Posts: 3,457
    Part of the Furniture 1,000 Posts Name Dropper
    Forumite
    Great resource Snowman. :T
  • SnowMan
    SnowMan Forumite Posts: 3,293
    Part of the Furniture 1,000 Posts Photogenic
    Forumite
    jdw2000 wrote: »
    Next to Halifax it should probably say the same as it says next to iWeb: "£60 charge for transferring into SIPP not included in figures". That applies to both of them.
    Thanks good point.

    I did have a warning about the Halifax £60 SIPP transfer in charge in the funds and shares and ETFs combined comparison, but you are right there was no warning in the shares and ETFs only comparison or the funds only comparison, so I've added those warnings in.

    I've noticed that Barclays are about to do a complete overhaul of charges, so I've added a warning that the charges allowed for are based on their old structure also.

    There are no changes to the formulae so I've left the version as version 27.
    I came, I saw, I melted
  • Sean473
    Sean473 Forumite Posts: 88
    Fourth Anniversary 10 Posts
    Forumite
    Hi Snow,

    You might want to add the Santander Investment Hub, it's a funds platform.

    Thanks,
    Sean
Meet your Ambassadors

Categories

  • All Categories
  • 340K Banking & Borrowing
  • 249.1K Reduce Debt & Boost Income
  • 448.3K Spending & Discounts
  • 231.9K Work, Benefits & Business
  • 602.9K Mortgages, Homes & Bills
  • 171.6K Life & Family
  • 245.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 15.8K Discuss & Feedback
  • 15.1K Coronavirus Support Boards