Zapier is the tool that gives you internet superpowers, providing the glue between over 1000 web applications. Using the Zapier webhook action together with Gridarrow allows you to bring that connectivity directly into Desktop Excel.
Pusher and PubNub are realtime backends that are commonly used for communication with Internet of Things devices, receiving geotracking updates, and many other use cases. Together with Gridarrow they can provide a very effective way to build live dashboards in Excel.
Previous entries on our blog have shown how easy it is to get data from APIs into Excel using Gridarrow. But what happens if the data you need isn’t easily accessible via an API, but is available as html tables. That’s where web scraping comes in!
Alpha Vantage is an API that provides realtime and historical stock and forex data, digital/crypto currency data and over 50 technical indicators. It supports intraday, daily, weekly, and monthly quotes and technical analysis with chart-ready time series. What’s more, it’s 100% free with unlimited API calls!
The Amazon Product Advertising API is a world-class web service used by millions of customers every day.
It gives access to much of the same data that is used by Amazon including the items for sale, customer reviews and seller reviews. You can search for items by keyword, similarity to other products, or by navigating product categories.
The Dark Sky API allows you to look up the weather anywhere on the globe, returning (where available):
If you use Redis in your company, you know there’s valuable information flowing through it. It’s can be really useful to have that data easily available in Excel.
In this post you’ll learn how using Gridarrow allows you to:
It’s useful to visualize the shape of the order book by plotting the cumulative sum of liquidity on each side. In this example you’ll see how Gridarrow can stream exchange data into Excel where such visualisations are easy to create.
Not so long ago getting a real-time feed of stock prices was an expensive proposition - something usually available only to the professional financial establishment.
Since IEX Trading (the heroes of Michael Lewis’s bestselling book Flash Boys) came on the scene, the landscape has changed. These guys have been on a mission to disrupt the financial markets and, democratise access to market data.
Gridarrow is a perfect fit for connecting to IEX data and streaming it to Excel.