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…
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…
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,…
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…
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…
Follow My Blog
Get new content delivered directly to your inbox.
