Blog

Recent Microsoft Excel Performance Improvements

The latest release of Excel is focused on performance improvements. The main areas that have been addressed are RealTimeData functions, faster opening of workbooks with many user defined functions and faster aggregation. RealTimeData functions (RTD) are commonly used to update a spreadsheet from a real-time data source. For example, if you have a stock portfolio…

Partnership Announcement: EODHistoricalData.com

We are pleased to announce today our partnership with data provider EODHistoricalData.com which provides comprehensive historical and fundamental data from 60+ exchanges around the world. This partnership significantly increases the data coverage of Excel Price Feed especially fundamental data as we can now offer up to 20 years of company financial history for many stocks.…

IG Client Sentiment Analysis

IG client sentiment is an indicator that IG Index provides to show what percentage of clients have long or short positions. For example looking at the NASDAQ index, we can currently see that 56% of clients are long this market and 44% are short: A general consensus is that this is often a “contrarian” indicator,…

Excel: Calculate trading days between two dates

Yesterday a customer contacted us asking if our financial markets data Add-in could calculate the number of trading days between two dates. Unfortunately we don’t have this functionality as implementing it is not as easy as you may think. You need to take into account weekends, which for most financial markets are Saturday and Sunday.…

Volatile Excel Functions

Today I was talking to a customer and his issue was a strange one which I hadn’t seen before. Every time he changed ANYTHING on his spreadsheet he noticed that it would refresh unrelated formulas, i.e. formulas that did not reference the cells he was updating. The main formula on his sheet was this: This…

Pre-market stock prices

Stock markets are generally only open during specific times, the “trading day”. For example, the US market is open from 9:30am to 4:00pm (EST). However, this is not the only period when trading takes place and when prices can change, there is also the pre-market which is “open” before the regular market opens. This is…

Building an IG Index watchlist in Excel

IG Index / IG Markets provides over 16,000 different markets to trade, including FX, stocks, indices, commodities and cryptocurrencies. Keeping track of potential trading opportunities within this universe is daunting, you really need a way to filter out which markets you are interested in and monitor just those markets. This is where watchlists can help.…

Welcome to our blog

This blog will be a place where we will share our thoughts, ideas and news covering finance, trading and technology. We will post product news, articles about Excel as well as thoughts on developments in trading and financial markets. We hope you enjoy what we write and we would love to hear from you, so…


Follow My Blog

Get new content delivered directly to your inbox.