If anyone is interested in this I can share the Excel code/formula I came up with to make this a reality. I created the capability of strike prices to automatically update to the first strike price that is ITM as the stock price changes. I even utilized it in a way that an expert told me couldn't be done. I use ToS to pull live data about stocks and options from the exchange and crunch it through my algorithm to find the best possible trades. I found some literature for using RTD with ToS and dove right in. This is when I stumbled across the Excel RTD function capabilities. I back tested it, manually entering in all of the data, and wanted to see if I could come up with future estimations of yields. So I started out trying to model a trading strategy I came up with involving stocks and options.
