search

joseballester / muFunds

µFunds lets you import your asset data from Morningstar and other sources to your Google Sheets spreadsheet by using a simple formula.
https://mufunds.com
81 stars 11 forks source link

Data is wrong #53

Open carlotavaldes opened 2 years ago

carlotavaldes commented 2 years ago

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 commented 2 years ago

Oh, well. I tried.

joseballester commented 2 years ago

@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.

carlotavaldes commented 1 year ago

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