You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I followed this guide to create an automated data storing for my funds https://mufunds.com/history.html. Manual operations works fine, but the automation (time-based trigger) does not always work. Sometimes I get just a "#NAME?" in the value field, while the date and fund name get printed correctly.
One of the funds I track is 'FI4000223565', which I use "morningstar-FI" for in a cell call (=muFunds("nav"; "FI4000223565";"morningstar-fi")).
Does the trigger require the computer on which the script has been built to be running when the trigger launches?
Rgds,
Björn
PS. Disclosure: I modified the script a bit and added three instances of it for one page, to collect three different funds with one Sheet. As I remember, the results above were the same before modifying, and running each of these manually produces the expected results, so the modifications seem OK.
PPS. It would be awesome to have an example of a script taking into account fetching several funds :).
The text was updated successfully, but these errors were encountered:
Hi,
I followed this guide to create an automated data storing for my funds https://mufunds.com/history.html. Manual operations works fine, but the automation (time-based trigger) does not always work. Sometimes I get just a "#NAME?" in the value field, while the date and fund name get printed correctly.
One of the funds I track is 'FI4000223565', which I use "morningstar-FI" for in a cell call (=muFunds("nav"; "FI4000223565";"morningstar-fi")).
Does the trigger require the computer on which the script has been built to be running when the trigger launches?
Rgds,
Björn
PS. Disclosure: I modified the script a bit and added three instances of it for one page, to collect three different funds with one Sheet. As I remember, the results above were the same before modifying, and running each of these manually produces the expected results, so the modifications seem OK.
PPS. It would be awesome to have an example of a script taking into account fetching several funds :).
The text was updated successfully, but these errors were encountered: