Category: API

        Somewhere I came across Standard Library but best searched for under StdLib. I signed up for it and found a couple of videos. It looked like magic and required serious coding, so I put it down at the time. I have been receiving regular “onboarding” emails (Seems pretty common and irritating when you sign up

         I was looking at the GlideApps showcase and the Bogdan Popa created a News App. In it he uses IMPORTXML in Google Sheets to pull in web data that he filters to different tables. A nice app. I started thinking about what other import formulas does Google Sheets have, I know it has GOOGLEFINANCE

        Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately

        After tinkering with Tables in Coda.io for planning for my website in the morning I did find I was more focused on what I needed to do on the website and completed most of the tasks in that part of the project. 3 down and one to go. Coda.io and Zapier I had a parting

        It’s not often one comes across a tool that looks really really interesting where you think you can get some great leverage, but from what I have seen so far Coda.io looks really useful. I’m even starting this post off with a Part 1 as I expect to be doing quite a lot of exploration

        Following on from the previous post  I want to try and be able to update a Google Sheet from a web page via the link. I will be following this video: Unfortunately there is not a link to code for this addition, unlike videos 1 & 2 so I’ll need to write it from looking

        I like it when I find some useful code and it works straight away. When it doesn’t I end up spending an awful lot of time trying to figure out what is happening. turning the programmers dark magic into something comprehensible. Continuing on from the previous post I started to look at the output and

        Getting data from the web and being able to manipulate it and display it on your own website. Using Google sheets to refresh the data at specified intervals allows you to get live feed from sites that do not have an API for drawing the data down. At the end of the last post I

        In the previous post “Stock Data 1. Capture via API and Excel from Web” I used Excel to grab some data from the Web & show it as a Table inside Excel. After bringing the data in I had trouble creating a chart from the Table. So, after messing around with the Charts again today

        I started looking at getting financial data from the Web, looking at the NZX (NZ stock Exchange) but no-one had free API’s. Actually Quandl did but it was only monthly on overall stocks/bonds and stops the previous month. So I spent a little time fluffing with their free API before realising that was the case.