الخميس، 24 نوفمبر 2022
Show HN: Google Sheets GOOGLEFINANCE() reliability enhancement https://ift.tt/lNhKftV
Show HN: Google Sheets GOOGLEFINANCE() reliability enhancement Anyone who uses GOOGLEFINANCE() for stock/ETF prices and then logs your total portfolio assets daily (by trigger), knows that it is not 100% reliable. What I wanted was something that would use the last good data point if GOOGLEFINANCE was failing. So I added caching to solve this problem. There is also another issue that GOOGLEFINANCE is particularly bad with Canadian stock symbols. It also does not find stock/etf dividend yields. For this I query a few finance websites to pull in the missing info. Now the problem looking up a couple hundred symbols using =CACHEFINANCE() (my custom function) was the dreaded 'Loading' error, which would also cause asset tracking to fail - so... I also added the capability to run as a trigger function, so it has now been 100% success for my logging. The app script will create a trigger for each job required (i.e. pricing is one, yieldpct is another, etc.). It will also automatically exit and re-start the trigger if it can't get through all requests before the 6 minute mark (a Google restriction). This is especially needed with the 'Yieldpct' because all data is found using URL fetch - which is much slower than a working GOOGLEFINANCE. I have made this an open source project if you want to use the Google Apps Script. Please let me know of any suggestions to help improve going forward. This version works for me, but of course the first person using other than me will probably find something wrong. I'm sure my README.md could use some further enhancements. https://ift.tt/Ils4F7H November 25, 2022 at 01:42AM
الاشتراك في:
تعليقات الرسالة (Atom)
������ �����
خدمات طبيه https://www.cut-titles.com/Y4ZR
-
أهم ما يجب معرفته عند زيارة تركيا تركيا من البلاد السياحية التي ذاع صيتها بين الكثير من محبي السفر والترحال، لما تتمتع به ...
-
عملية تصحيح البصر في تركيا- التلكفة والمميزات2019 عملية تصحيح النظر وكما يبدو من الاسم هي وسيلة لتصحيح ما أصاب العين من ضعف ...
-
https://ift.tt/2TqClyp via /r/aww https://ift.tt/365Bzd8
-
Show HN: Typed parser combinator library with error recovery for Python https://ift.tt/W0f3CJd March 31, 2022 at 11:37PM
-
Medical News Today: Can meditation, hypnosis, and CBT help address the opioid crisis? A new review and meta-analysis has concluded that medi...
-
Medical News Today: Tea tree oil for nail fungus: Does it work? Tea tree oil is an essential oil that appears to have antifungal properties....
ليست هناك تعليقات:
إرسال تعليق