muFunds icon indicating copy to clipboard operation
muFunds copied to clipboard

Published 20 hours ago • verified publisher icon joseballester

Data is wrong

Open carlotavaldes opened this issue 2 years ago • 3 comments

Hi, It's been over a week that I notice that the "change" numbers given by muFunds do not correspond with the morningstar info. Some examples with the latest numbers, September 5th: ES0112611001, muFunds is quoting 2,57%, and morningstar 2,13% ES0124037021, muFunds is quoting -0.28%, and morningstar 0,13% ES0159201013, muFunds is quoting -2.05%, and morningstar -1,65% ES0116567035, muFunds is quoting -0.66%, and morningstar -0,25% etc. I could go on, but all seem to be wrong. Any tips on this? Thanks!

carlotavaldes avatar Sep 07 '22 11:09 carlotavaldes

Oh, well. I tried.

carlotavaldes avatar Oct 03 '22 17:10 carlotavaldes

@carlotavaldes Thanks for your feedback and sorry for the delay.

The issue was that the changes given were always in GBP currency. Therefore, funds in GBP were returning correct values, but funds in other currencies were returning the result of the NAV change and the exchange rate change between GBP and the currency in which the fund was denominated.

This has now been solved by always returning the change in the fund currency. These changes have been deployed in a new version of the Google Sheets add-on and should be available shortly.

joseballester avatar Oct 05 '22 21:10 joseballester

@joseballester, I think the same issue is occurring, and all the change numbers are wrong.

carlotavaldes avatar Sep 29 '23 12:09 carlotavaldes