Show HN: Google Sheets GOOGLEFINANCE() reliability enhancement https://ift.tt/Sjo7EQU

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/UkFzBqQ November 25, 2022 at 04:12AM

Comments

Post a Comment

Popular posts from this blog

Save Promotional Expense with Sure Shot Outbound Telemarketing Services Provider

Image
Advertising and promotions are essential for getting hold of new clients. In the competitive business world of today, it has become vital to expand one’s operation. If you stagnate, then your competitors will surpass you. However, advertisement-based promotions do not always guarantee a fixed return. You can spend copious sums of money on mass media advertising. But, it is not a given that your business will receive the anticipated response. And, even if you get the clients, they might not always be the most suitable for your business. Hence, it is important to exploit other alternatives. Partnering with a sure shot outbound telemarketing services provider can be a good start. Pinpoint Your Target with Outbound Telemarketing Services Provider Unlike an advertising campaign that relies on the quality of content and its appeal to a vast group of clients, outbound telemarketing campaigns can be pinpointed towards a particular client base. There are many benefits of employing t...
Read more

Monetize Fiber Services Better and Improve ROI with Top Telecom Billing Software

  Fiber internet connection has changed the way web services are utilized. With speeds in excess of 100 mbps, it is a revolutionary technology that is replacing the traditional copper wire connectivity. Subscribers are drawn towards this technology; however, not all telecom operators are able to monetize it in the best possible manner. There is a pressing need for next-gen telecom software solutions that come with backward compatibility. The Need for Backward Compatibility Fiber is a next-gen technology; however, it has to exist in a universe where copper wire and DSL connectivity is still a reality. Therefore, it needs to be backward compatible. Both the network technology and billing technology need to work with pre-existing infrastructure. So, it is vital that telcos have BSS and OSS software telecom along with relevant telecom billing software that work with older technologies. Flexible Monetization is Key Fiber offers a wide range of options for monetization. There ...
Read more

Find the best backlinks list and unlimited indexing process to know for improvement

https://sites.google.com/view/callcenterusa/home https://vcallglobal.bcz.com/ http://facebookhitlist.com/profiles/blogs/top-8-benefits-for-businesses-with-outsourced-call-center http://ampicillin500.com/Blog-Detail/Top-8-Benefits-For-Businesses-with-Outsourced-Call-Center-Services-1077 https://articlesforwebsite.com/top-8-benefits-for-businesses-with-outsourced-call-center-service/ https://traiborg.com/profile/vcallglobal https://issuu.com/ameliarobert/docs/some_of_identifying_the_best_telemarketing_service https://www.slideshare.net/ameliarobert/some-of-identifying-the-best-telemarketing-service-important https://slides.com/ameliarobert/some-of-identifying-the-best-telemarketing-service-important https://www.scribd.com/document/469110266/Some-of-Identifying-the-Best-Telemarketing-Service-Important https://visual.ly/community/Infographics/business/some-ide...
Read more