Is this the orats sheet? I automate this in R now but heres my orginal Excel file. The calculations incorporate term structure and use bus days. If your implied vols are calculated using 365, you will have to change the implied move to sqrt(1/365)*.... and then you can use calendar days for dte1 and 2Ya. I have the similar numbers. I was leaning downside because of all the bad publicity. If it was downside move, I was not expecting lot of downside.
With huge error bands around the mean, we have to expect good with the bad with these earning plays
View attachment 197407
iv.1 and iv.2 are just the iv's for the first expiration and second expiration. use the same expirations for the spx.