I would like to keep a track of market gaps.
I use TradeStation EOD and Excel.
I can manually devise a way in Excel, but to do this over nearly 20 years of daily data for the SPI would be laborious to say the least.
I was a systems programmer in the '70's using mainly Assembler and maybe I need to purchase a compiler of some kind to do this. Any suggestions would be welcome.