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/jpShtkG November 25, 2022 at 04:42AM
Show HN: Tape It, iOS recording app for musicians Hello HN, Over the last 15 months, two friends and I developed the music recording app we felt we wanted based on our own needs as musicians. It's called Tape It [1] and has just recently hit the Apple App Store [2]. We put a lot of effort into a good UX to help musicians really focus on playing their instrument instead of pretending to be a recording engineer. The app records in stereo on newer iPhones (although that's a premium feature; the free version only records in standard mono audio quality). I would be really grateful for advice from this community on how to best approach marketing. We had a great TechCrunch article covering our launch [3], and we posted it on various music websites. Turns out advertising on Google or Apple Search is a dark art, though. We have some good ideas for developing a good social media presence, but they will take time. Please hit us with feedback, opinions and advice that you think a young ind...
Comments