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.
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.
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.
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.
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?