Gridarrow Blog

August 30, 2018

Sending Zapier Actions to Desktop Excel using Gridarrow webhooks

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.

August 12, 2018

Realtime stock dashboard with the IEX Trading API

Many people were interested in our previous blog post about building a realtime stock dashboard using data from Alpha Vantage. Recently however, we’ve had a better experience with the market data API that is provided by the IEX Group

August 11, 2018

Streaming data into Excel from Raspberry Pi devices via realtime backends Pusher and PubNub

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.

August 10, 2018

Web scraping economic indicators into Excel using Pandas

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!

April 16, 2018

Realtime stock dashboard in Excel with the Alpha Vantage API

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!

April 12, 2018

Use the Amazon Product API with Gridarrow

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.

April 12, 2018

Detailed weather forecast in Excel using the Dark Sky API

The Dark Sky API allows you to look up the weather anywhere on the globe, returning (where available):

  • Current weather conditions
  • Minute-by-minute forecasts out to one hour
  • Hour-by-hour and day-by-day forecasts out to seven days
  • Hour-by-hour and day-by-day observations going back decades

March 19, 2018

Realtime location tracking with Redis Pub/Sub

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:

  • connect to a Redis server with the Python Redis library
  • query or subscribe to whatever data you need
  • stream it instantly to connected Excel users

March 14, 2018

Visualizing the BTC/USD orderbook on the GDAX exchange

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.

March 12, 2018

Streaming real-time stock prices from IEX into Excel

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.