search

nicwortel / indexfondsenvergelijken.nl

A comparison website for index funds, ETF's, banks and brokers in the Netherlands
https://www.indexfondsenvergelijken.nl/
51 stars 17 forks source link

Properly annualise Rabobank min/max fees #8

Closed praseodym closed 3 years ago

praseodym commented 3 years ago

Rabobank specifies service fees per quarter. The service fee percentages were properly annualised, but the minimum and maximum fees were not.

nicwortel commented 3 years ago

Hi, thanks for sending in a pull request!

I did a quick check, but I believe the data is actually correct. In the simulation, the broker service fee is calculated after every quarter. To calculate it, the yearly fee is divided by 4, and the minimum or maximum fee is used when applicable. As this is done every quarter, the total service fee after 1 year will be correct.

This can be verified by running the simulation for 1 year, using a € 1 monthly investment and 0% expected growth and dividends:

afbeelding

As expected, this returns a € 20 total service fee for the Rabobank:

afbeelding

However, I believe you may be referring to the "Tarieven" tab, and I think you have spotted something that I didn't notice before. Currently, quarterly min and max service fees and the annualized service fee percentages are displayed next to each other:

afbeelding

This doesn't make a lot of sense and can clearly cause some confusion. I'll have to present this data in a different way, but I'll have to think about the best way to present this as annualized fees may make a lot of sense for other banks/brokers.

gerbenvl commented 3 years ago

Display in the same way as with ING? Although it's a little bit different since with Rabo it's deducted quarterly.

gerbenvl commented 3 years ago

Slightly offtopic but Rabo costs related: doesn't Rabo also charge a small fee for NT dividend handling?

nicwortel commented 3 years ago

Display in the same way as with ING? Although it's a little bit different since with Rabo it's deducted quarterly.

ING also collects service fees every quarter. However, the invested capital which the service fee is based on is calculated differently. ING takes the average of the invested capital at the end of each month (see this PDF, page 3). Rabobank takes the average of the invested capital at the start and the end of the quarter (see this PDF, also page 3). While this is taken into account in the simulation (see the serviceFeeCalculation key in brokers.json and Simulation.ts), this is not yet displayed on the website.

For Binck Fundcoach I'm not really sure how often the service fee is collected or how the portfolio value is calculated.

Slightly offtopic but Rabo costs related: doesn't Rabo also charge a small fee for NT dividend handling?

Yes, you are correct. I think I came accross this back when I didn't handle dividends, but now that I calculate dividends I should be able to take this into account.

praseodym commented 3 years ago

Forgot to reply here, thanks for the clarification! As this PR doesn’t make much sense as-is I’ll close it.