App Icon
José Ballester
•  184
Overview
µFunds is a Google Sheets add-on introducing all type of data for your mutual funds into your spreadsheet: last NAV and its date, currency or expenses ratio, as well as fund category, investment style and other attributes from Morningstar. By the use of a simple spreadsheet formula, the desired data can be introduced into your document for many purposes, e.g. portfolio supervision and management or investment strategies. Once installed, µFunds is ready to use: after introducing the data attribute and the fund identifier, the information will appear in the selected cell. Funds can be identified by their ISIN (European funds), ticker (American funds) and also by their Morningstar Security ID (all funds and many pension plans).
µFunds is a Google Sheets add-on to import all type of data for your mutual funds, pension plans, ETFs, stocks, insurance-linked funds... into your spreadsheet.

More concretely, you will be able to import an asset's last NAV and its date, currency or expenses ratio, as well as asset category and other attributes from Morningstar and other data sources. By the use of a simple spreadsheet formula, the desired data can be introduced into your document for many purposes, e.g. portfolio supervision and management or investment strategies.

Once installed, µFunds is ready to use: after introducing the data attribute and the fund identifier, the information will appear in the selected cell. Funds can be identified by their ISIN (European funds), ticker (American funds) and also by their Morningstar Security ID (all funds and many pension plans). Check the documentation for a complete list of compatible assets, countries and identifiers.
Reviews
Language:
Sort by:
Profile Picture
A User of µFunds
October 11, 2020
Very useful add-on for managing International Mutual Funds. Simple and Effective. Thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of µFunds
October 4, 2020
I wanted to simply import the price nav for a series of Australian listed funds into Google Sheets. It all looked okay using this product, but after two days of frustration and tears, i have not faound any combination of ISIN, APIR or morningstar or morningstar-au that will produce that for Australian funds. Worse still, the explanation page suggests using the Morningstar ID - which I yet to find from Morningstar Australia which, by the way, I use every day. I can't find any way to email my problems for someone to simply give me an example of an Australian fund returning a price on Googel Sheets. That is the reason for my low rating as the product has frustrated the hell out of me!
Is this review helpful?
Yes
No
Profile Pciture
A user of µFunds
October 12, 2020
I cant seem to get it working either. Can you please give the formula to get the daily price for the Vanguard Lifestrategy High Growth Fund (VAN0015AU)?
Profile Pciture
José Ballester
October 9, 2020
Sorry to hear your that. The issue was that Morningstar had changed the way results were delivered, so parsing was not working properly. I've solved it today following your email and your issue on GitHub. µFunds is maintained voluntarily, so I've tried to have a look at the issue as soon as I've been able to. Now everything should work fine with the same instructions as always.
Profile Picture
A User of µFunds
June 26, 2020
I am having a hard time converting an Indian Mutual fund nav into data can someone write the exact script if I have to extract NAV for "INF200K01AL3"
Is this review helpful?
Yes
No
Profile Picture
A User of µFunds
February 4, 2020
The add-on is not working. Got an error "Unknown function: 'muFunds'.
Is this review helpful?
Yes
No
Profile Pciture
A user of µFunds
February 21, 2020
Thank you for your reply. I have created a new sheet and there is only one cell using the formula. But still have the same problem.
Profile Pciture
A user of µFunds
February 7, 2020
I see that sometimes too, it suddenly stops working. I think it can happen if you're editing a lot of cells, maybe there are limits on Google's side? When I come back the next day it works again.
Profile Picture
A User of µFunds
November 22, 2019
Excellent! must have to keep track of your portfolio
Is this review helpful?
Yes
No
Profile Picture
A User of µFunds
October 14, 2019
Worked flawlessly for months, however something in apps script seems to have broken this addon: Error on line 162: The prefix "xml" cannot be bound to any namespace other than its usual namespace; neither can the namespace for "xml" be bound to any prefix other than "xml".
Is this review helpful?
Yes
No
Profile Picture
A User of µFunds
February 19, 2019
Very good. Thanks,
Is this review helpful?
Yes
No
Profile Pciture
A user of µFunds
October 20, 2019
As started learning this function i've been trying to add morning star review in my google sheets but didn't have any success. Any help would be appreciated.
Profile Picture
A User of µFunds
December 27, 2018
Really helpful application, such a shame it doesn´t autoupdate but that´s easy to add with a simple macro. Thank you very much for this helpful tool! Would be awesome to add some features like fund components, average dividend yield or YTM, duration and the like.
Is this review helpful?
Yes
No
Profile Picture
A User of µFunds
July 5, 2018
Looks good, but is there a need for all the permission required to use the addon?
Is this review helpful?
Yes
No
Profile Picture
Jo Wouters
June 22, 2018
Great addon, which provides the data needed for all common funds I have searched for and works very stable. I would like to add an option to get the data from cache, since muFunds needs quite some time when executing and thus blocks the spreadsheet for about a minute when opening it. I will add this caching in the spreadsheet; but it would be better to be able to implement it in muFunds itself.
Is this review helpful?
Yes
No
1-10 of 16
Additional information
José Ballester
Terms of Service
Search
Clear search
Close search
Google apps
Main menu