Comments (3)
Fail! Although it did work the first time I have been testing it few days without success. Now I am not able to automatically run the muFund function with the time-trigger. Any clue?
from mufunds.
I have tried by playing with the google sheet permissions (edit anyone with link, public...), and activating the sheet where muFunds are applied before using flush() function, but nothing. Script still gives #NAME errors. The worst thing is that the error is not consistent. Sometimes it works fine. Any idea? @joseballester have you ever find this error?
from mufunds.
To your initial question. I have been playing around with muFunds for several weeks now. Trying to get the spreadsheet to update by running a script. It looks like this is not possible by design. I ended up with a workaround. Make a Macro that makes a copy - delete and re-insert of the ISIN's for the funds you want to update. Find the Macro in macros.gs. Do some changes so the macro is running in the sheet that it is supposed to (var sheet1 = "Yoursheetname";). And call it form a trigger.
I have also looked at this solution:
https://github.com/sheets-market-data/refresh-tool
This guy has a script that looks thru all formulas in the sheet. Delete them and re-inserts them. It works, but I could not find a proper way to control the thing, so I gave up on him. I have been programming in several languages, but I am not a programmer. So it was a little to heavy for me JS is also new for me.
FYI I have also made a script that copies the NAVs to history, it can be shared if you want.
from mufunds.
Related Issues (20)
- muFunds add-on inaccessible in new Google sheets HOT 3
- Automated fetching doesn't work if computer not on? HOT 2
- Cant pull nordics stocks from Morningstar
- muFunds stopped working (Error Loading ....) HOT 9
- Morningstar-gb no longer a useable source HOT 11
- Installation fails on accounts with Advanced Protection enabled
- Error when fetching mutual fund quotes from Morningstar HOT 54
- Morningstar UK not Working
- Data is wrong HOT 3
- Trending feature
- Requested permissions are excessive
- 403 error response - Truncated server response HOT 2
- Canadian mutual fund
- Error in Danish morningstar requests (different from time to time) HOT 2
- Error occurred, stopped working
- Error HOT 5
- Error when retrieving price from morningstar-es HOT 1
- Canada Mutual Funds providing wrong values HOT 3
- Error: You have selected an invalid option (line 16) HOT 1
- Error Función desconocida: 'muFunds'. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mufunds.