muFunds
View on GitHub Try in Google Sheets

How muFunds works

In a few words, muFunds works by fetching an HTML page from the chosen data source, parsing the asked data in it and just returning it back to you. More concretely, the performed steps are the following:

  1. The user calls the muFunds function from a Google Sheets spreadsheet for a certain option (asset attribute), id (asset identifier) and source (website where fetch data from).
  2. If source is explicitly given by the user, then muFunds plans to fetch a the asset detail page for that id. Otherwise, muFunds plans to fetch a Morningstar page in generic mode (morningstar).
  3. If the page is cached by Google Apps Script's cache from the last 2 hours, then no external call is performed. Otherwise, the page is fetched and saved in Google Apps Script's cache for the next 2 hours.
  4. The asked attribute is parsed from the Morningstar page's HTML and returned.

Considerations

  • More technical details and the actual code implementation can be found in the Code section of this repository.