Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Automated fetching doesn't work if computer not on? #40

Open
0800-grizzly opened this issue Nov 8, 2021 · 2 comments
Open

Automated fetching doesn't work if computer not on? #40

0800-grizzly opened this issue Nov 8, 2021 · 2 comments

Comments

@0800-grizzly
Copy link

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 :).

@0800-grizzly
Copy link
Author

Any chance to have a look on this?

@petersenx
Copy link

I have the same issue. When initiated from a time based trigger, it rarely fetches any values.

It could be nice with some logging which could indicate whether it actually tries to fetch any values.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants