Workspaces

Thom Hartle
May 09, 2022
Updated: May 11, 2022

Monitoring market data in Excel may be enhanced by including Forward Curve charts. However, there are issues with Excel charting and the purpose of this post is to offer solutions using Excel functions.

For example, if the “Last Trade” for... more

Thom Hartle
Jul 12, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for Short Sterling calendar spreads traded on the ICE platform. This monitor uses a matrix-style format. The outrights are displayed along the top row and at the start of each row. The best bid... more