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

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

Show HN: AI generated puzzles from Wikipedia articles https://ift.tt/zLGwlYo

Show HN: AI generated puzzles from Wikipedia articles https://ift.tt/ZQJVunH November 25, 2022 at 03:31AM

Show HN: World Cup 2022 CLI Dashboard – Watch matches in your terminal https://ift.tt/AUMOV9j

Show HN: World Cup 2022 CLI Dashboard – Watch matches in your terminal https://ift.tt/IqNZRkK November 25, 2022 at 03:26AM

Show HN: Have fun betting virtual (not real) money on predictions from HN users https://ift.tt/IeYdiMh

Show HN: Have fun betting virtual (not real) money on predictions from HN users I wanted to see how difficult it would be to build a web app using a sub-$300 android smartphone. Decided to build a fun predictions website where you could bet virtual (not real) money on predictions made by others, and also make predictions of your own. Building it turned out to be considerably easier and more fun than I anticipated. Primary tools used were: # QuickEdit as the mobile code editor (Note: the free version of the QuickEdit app is riddled with ads, it shows an advert each time you close a tab, but it unfortunately had the best UI of the 3 or so Android code editors I tested. Ended up using NetGuard to block it from retrieving & displaying ads), # PHP for the Backend ( custom PHP microframework I've used and built on over the past few years ). # jQuery for the frontend js ( cringing ) - it appears I'm simply too lazy to learn React/Vue/et al. Every once in a while, I pick one of them to learn, but I always end up returning to jQuery - or time-permitting - amateur level vanilla JS. # Bootstrap for the CSS - Battle-tested. For a purely backend dev with minimal design skills, good ol' Bootstrap (and in a growing number of cases, Tailwind) is always a life saver. # Whole thing is hosted on 2 VMs (1 hosting the web app, and 1 hosting Redis & MySQL). # As to the site itself, it turned out to be pretty cool to play around with. Go there, view the predictions, bet on the predictions you believe will come true, or against the ones you think will not. You get $50,000 to bet with (not real money). No signup is required to bet, but a quick signup is required to make a prediction. Hope you guys like it, and please be ruthless in telling me of any bugs you've found. So go on here => kudotap.com And Have Fun! https://kudotap.com November 25, 2022 at 02:37AM

Show HN: Stable Diffusion v2 web interface https://ift.tt/ieSEchW

Show HN: Stable Diffusion v2 web interface https://ift.tt/iXQsR32 November 25, 2022 at 01:28AM

Show HN: WinkNLP delivers 600k tokens/second speed on browsers (MBP M1) https://ift.tt/bOnPdhC

Show HN: WinkNLP delivers 600k tokens/second speed on browsers (MBP M1) https://ift.tt/ak4Kdqi November 24, 2022 at 11:21PM

Show HN: OpenDolphin – A Community Built Open Source Social Network https://ift.tt/Ii8TcnX

Show HN: OpenDolphin – A Community Built Open Source Social Network Hey HN! I'm trying to create a community of people that are willing to contribute to the OpenDolphin project. The goal of the project is to build an Open Source _centralized_ social network that would ideally compete with Twitter, Facebook and Instagram. The main difference between the well established social and this one would be that it is going to be built and managed in the public, in the most transparent way possible. Features will be implemented and requested by the community - and generally speaking everything would be community-centric. If the project takes off, this might become one of the most transparent companies / projects out there. If you fancy joining us, come say "Hi" on our Slack instance, and help us shape the next social network! https://ift.tt/OkNeJRT November 24, 2022 at 06:25AM