Error when retrieving price from morningstar-es

[jonliberal]

When running

=muFunds("nav", "US0231351067" , "morningstar-es")

I'm getting error:

Error: NAV is not available for this asset and source. Please try another data source. (line 18).

Even though I can see data for that ISIN in morningstar.es: https://tools.morningstar.es/es/stockreport/default.aspx?SecurityToken=0P000000B7]3]0]E0WWE$$ALL

Who does one need to suck to get this fixed?

[joseballester]

Hi @jonliberal, thanks for raising this issue. Keep calm, you don't need to suck anybody :)

For stocks like the one you're referring to, I'd suggest using the Google Finance function instead of µFunds with Morningstar, as the Compatibility list states:

Many real-time data assets (such as stocks or ETFs) are compatible with Google Finance, and in these cases we recommend the Google Finance function included in Google Sheets, that usually provides reliable data with small delays.

In this case, the equivalent usage of the Google Finance function to µFunds' would be:

µFunds option	Google Finance equivalent
nav	=GOOGLEFINANCE("NASDAQ:AMZN")
date	=GOOGLEFINANCE("NASDAQ:AMZN", "tradetime")
change	=GOOGLEFINANCE("NASDAQ:AMZN", "changepct")/100
expenses	=0 (as stocks do not have TER)
currency	=GOOGLEFINANCE("NASDAQ:AMZN", "currency") or ="USD" (as it won't change)

Let me know if that works!