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