This is a real Excel-compatible spreadsheet. Formulas work with relative references and autofill (drag handle):
📊 Row & Column Formulas
=B1 + 100 — Strike 2 (Col C) from Strike 1 (Col B) + 100
=D1 - E1 — Far Bid (Col D) − Near Ask (Col E)
=D1 - 2*E1 — 1:2 Ratio spread
=SUM(B1:B5) — Sum of 5 strikes
🧮 Math Functions
=ROUND(B1*1.01, 0) — 1% OTM rounded
=INT(B1/100)*100 — Nearest hundred
=ABS(B1-23000) — Absolute distance
=IF(B1>23000, B1+100, B1+50) — Conditional
🎯 Market & Strike Formulas
=ATM - 50 — ATM strike minus 50 pts
=choose - 50 — Dynamic ATM strike - 50 pts
=SPOT + 100 — Index Spot price + 100 pts
=CHOOSE(2, 24000, 24500) — Pick 2nd item (24500)
+50 / -50 — In Col C, auto =B1±50
⚡ Excel Shortcuts
Ctrl + Shift + = — Insert Column
Ctrl + = — Insert Row
Ctrl + Shift + - — Delete Column
Ctrl + - — Delete Row
Ctrl + Z / Y — Undo / Redo
Delete — Clear selected cells
Ctrl + B / I / U — Bold / Italic / Underline
