Gridarrow Blog

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.

March 7, 2018

Monitoring the Gridarrow Kubernetes cluster using the Stackdriver API

Gridarrow runs on Kubernetes - the open-source cluster management platform. It makes sure that your apps are deployed and keep on running healthy.

Today we’ll show you how to use Gridarrow to create live dashboard in Excel for monitoring such systems.

February 12, 2018

Creating a timeseries chart from real-time data

Gridarrow is great at streaming real-time data to Excel, where the values in the grids are updated continuously. But what if you want to create a timeseries chart from that real-time data?

We’ll show you how you can easily sample the data to create a live timeseries chart by using a little bit of VBA.

February 9, 2018

Financial news sentiment analysis using Xignite and pysentiment

Automatically processing financial news flow to calculate the “sentiment” for trading decisions is a complex and ongoing area of quantitative research.

This blog post shows you a very simple example of sentiment analysis using news from the Xignite global news feed, and a dashboard to view the results in Excel.

February 5, 2018

A configurable app for Google Analytics reporting with Excel

There are several dedicated Google Analytics (GA) plugins for Excel already out there, but often you’ll find that you have to work with a clunky interface, or they use a legacy version of the API (V3, or even V2!), or that they don’t support automatic refresh, or some other irritating niggle that prevents you getting the data into Excel exactly as you would want to see it. What is Gridarrow?