Gridarrow Blog

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?

January 30, 2018

Rebuilding the CoinCap dashboard in Excel

CoinCap.io is one of the most popular pages on the internet for the cryptocurrency trading and investment community. In a single screen it shows the current price, market-cap, 24hr price-change and several other figures for all the major and alternative coins.

We’ll show you how to get that data into your spreadsheet.

January 12, 2018

Bulk export of activities from Marketo

Marketo provides interfaces for retrieval of large sets of person and person related data, called Bulk Extract. Currently, interfaces are offered for two object types: Leads (Persons) Activities Bulk extract is performed by creating a job, defining the set of data to retrieve, enqueuing the job, waiting for the job to complete writing a file, and then retrieving the file over HTTP. What is Gridarrow? Gridarrow is the missing server for Excel.

January 12, 2018

Monitoring bitcoin exchange spreads

Cryptocurrency markets have been in the news a lot over the last year. The price going up or down quickly causes a huge amount of volatility only in the course of a day. The large variation of Bitcoin prices between exchanges is known as the exchange spread.

We’ll show you how to visualise it in real-time in Excel using Gridarrow!

January 11, 2018

Creating a real-time Twitter map in Excel

Knowing where and when people are saying nice (or not so nice!) things about your company is essential for the modern marketer.

This post shows how you can create a real-time map of Tweets using Gridarrow and the Bing Maps plugin for Excel.