Spreadsheet: 886235d1736267261-function-to-find-the-right-column-to-pull-data-from-0dte-butterfly-calculator
Sheet: ES Option chain

Stock quote and option quote for SPX on 1/7/25 08:17:57
UNDERLYING
LAST | LX | Net Chng | BID | BX | ASK | AX | Size | Volume | Open | High | Low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES ASK | ES BID | AVG
UNDERLYING EXTRA INFO
Last Size | Yield | PE | Div | [NAME].[NAME] | [NAME].Date | 52High | 52Low | Shares | Beta
 |  |  |  | -- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAST +50 |  | LAST -50
7 JAN 25  (0)  100 ([NAME])
 |  | Delta | Gamma | Theta | Vega | BID | BX | ASK | AX | Exp | Strike | BID | BX | ASK | AX | Delta | Gamma | Theta | Vega
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES +50 ASK | ES +50 BID | AVG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES -50 ASK | ES -50 BID
8 JAN 25  (1)  100 ([NAME])
9 JAN 25  (2)  100 ([NAME])
10 JAN 25  (3)  100 ([NAME])
13 JAN 25  (6)  100 ([NAME])
14 JAN 25  (7)  100 ([NAME])
15 JAN 25  (8)  100 ([NAME])
16 JAN 25  (9)  100 ([NAME])
17 JAN 25  (9)  100
17 JAN 25  (10)  100 ([NAME])
21 JAN 25  (14)  100 ([NAME])
22 JAN 25  (15)  100 ([NAME])
23 JAN 25  (16)  100 ([NAME])
24 JAN 25  (17)  100 ([NAME])
27 JAN 25  (20)  100 ([NAME])
28 JAN 25  (21)  100 ([NAME])
29 JAN 25  (22)  100 ([NAME])
30 JAN 25  (23)  100 ([NAME])
31 JAN 25  (24)  100 ([NAME])
3 FEB 25  (27)  100 ([NAME])
4 FEB 25  (28)  100 ([NAME])
5 FEB 25  (29)  100 ([NAME])
6 FEB 25  (30)  100 ([NAME])
7 FEB 25  (31)  100 ([NAME])
10 FEB 25  (34)  100 ([NAME])
11 FEB 25  (35)  100 ([NAME])
12 FEB 25  (36)  100 ([NAME])
14 FEB 25  (38)  100 ([NAME])
21 FEB 25  (44)  100
21 FEB 25  (45)  100 ([NAME])
24 FEB 25  (48)  100 ([NAME])
28 FEB 25  (52)  100 ([NAME])
7 MAR 25  (59)  100 ([NAME])
21 MAR 25  (72)  100
21 MAR 25  (73)  100 ([NAME])
31 MAR 25  (83)  100 ([NAME])
17 APR 25  (99)  100
17 APR 25  (100)  100 ([NAME])
30 APR 25  (113)  100 ([NAME])
16 MAY 25  (128)  100
16 MAY 25  (129)  100 ([NAME])
30 MAY 25  (143)  100 ([NAME])
20 JUN 25  (163)  100
30 JUN 25  (174)  100 ([NAME])
18 JUL 25  (191)  100
15 AUG 25  (219)  100
19 SEP 25  (254)  100
30 SEP 25  (266)  100 ([NAME])
17 OCT 25  (282)  100
21 NOV 25  (317)  100
19 DEC 25  (345)  100
31 DEC 25  (358)  100 ([NAME])
16 JAN 26  (373)  100
20 MAR 26  (436)  100
18 JUN 26  (526)  100
18 DEC 26  (709)  100
17 DEC 27  (1073)  100
15 DEC 28  (1437)  100
21 DEC 29  (1808)  100
9 JAN 25  (1)  1 /ESH25 (Wednesday) (Wk2)
10 JAN 25  (2)  1 /ESH25 (Thursday) (Wk2)
11 JAN 25  (3)  1 /ESH25 (Wk2)
14 JAN 25  (6)  1 /ESH25 (Monday) (Wk3)
15 JAN 25  (7)  1 /ESH25 (Tuesday) (Wk3)
16 JAN 25  (8)  1 /ESH25 (Wednesday) (Wk3)
17 JAN 25  (9)  1 /ESH25 (Thursday) (Wk3)
18 JAN 25  (10)  1 /ESH25 (Wk3)
22 JAN 25  (14)  1 /ESH25 (Tuesday) (Wk4)
23 JAN 25  (15)  1 /ESH25 (Wednesday) (Wk4)
24 JAN 25  (16)  1 /ESH25 (Thursday) (Wk4)
25 JAN 25  (17)  1 /ESH25 (Wk4)
28 JAN 25  (20)  1 /ESH25 (Monday) (Wk5)
29 JAN 25  (21)  1 /ESH25 (Tuesday) (Wk5)
30 JAN 25  (22)  1 /ESH25 (Wednesday) (Wk5)
31 JAN 25  (23)  1 /ESH25 (Thursday) (Wk5)
1 FEB 25  (24)  1 /ESH25 (EOM)
4 FEB 25  (27)  1 /ESH25 (Monday) (Wk1)
5 FEB 25  (28)  1 /ESH25 (Tuesday) (Wk1)
6 FEB 25  (29)  1 /ESH25 (Wednesday) (Wk1)
7 FEB 25  (30)  1 /ESH25 (Thursday) (Wk1)
8 FEB 25  (31)  1 /ESH25 (Wk1)
11 FEB 25  (34)  1 /ESH25 (Monday) (Wk2)
12 FEB 25  (35)  1 /ESH25 (Tuesday) (Wk2)
13 FEB 25  (36)  1 /ESH25 (Wednesday) (Wk2)
15 FEB 25  (38)  1 /ESH25 (Wk2)
22 FEB 25  (45)  1 /ESH25 (Wk3)
25 FEB 25  (48)  1 /ESH25 (Monday) (Wk4)
1 MAR 25  (52)  1 /ESH25 (EOM)
8 MAR 25  (59)  1 /ESH25 (Wk1)
15 MAR 25  (66)  1 /ESH25 (Wk2)
22 MAR 25  (73)  1 /ESM25 (Wk3)
22 MAR 25  (73)  1 /ESH25 (AM Settled)
1 APR 25  (83)  1 /ESM25 (EOM)
18 APR 25  (100)  1 /ESM25 (Thursday) (Wk3)
1 MAY 25  (113)  1 /ESM25 (EOM)
17 MAY 25  (129)  1 /ESM25 (Wk3)
31 MAY 25  (143)  1 /ESM25 (EOM)
21 JUN 25  (164)  1 /ESU25 (Wk3)
21 JUN 25  (164)  1 /ESM25 (AM Settled)
1 JUL 25  (174)  1 /ESU25 (EOM)
19 JUL 25  (192)  1 /ESU25 (Wk3)
16 AUG 25  (220)  1 /ESU25 (Wk3)
20 SEP 25  (255)  1 /ESZ25 (Wk3)
20 SEP 25  (255)  1 /ESU25 (AM Settled)
1 OCT 25  (266)  1 /ESZ25 (EOM)
18 OCT 25  (283)  1 /ESZ25 (Wk3)
22 NOV 25  (318)  1 /ESZ25 (Wk3)
20 DEC 25  (346)  1 /ESH26 (Wk3)
20 DEC 25  (346)  1 [NAME] (AM Settled)
1 JAN 26  (358)  1 /ESH26 (EOM)
17 JAN 26  (374)  1 /ESH26 (Wk3)
21 MAR 26  (437)  1 /ESM26 (Wk3)
21 MAR 26  (437)  1 /ESH26 (AM Settled)
1 APR 26  (448)  1 [NAME] (EOM)
19 JUN 26  (527)  1 /ESM26 (AM Settled)
19 JUN 26  (527)  1 /ESU26 (Thursday) (Wk3)
1 JUL 26  (539)  1 /ESU26 (EOM)
19 SEP 26  (619)  1 /ESZ26 (Wk3)
19 SEP 26  (619)  1 /ESU26 (AM Settled)
19 DEC 26  (710)  1 /ESH27 (Wk3)
19 DEC 26  (710)  1 /ESZ26 (AM Settled)
20 MAR 27  (801)  1 /ESM27 (Wk3)
18 DEC 27  (1074)  1 /ESH28 (Wk3)
18 DEC 27  (1074)  1 /ESZ27 (AM Settled)
16 DEC 28  (1438)  1 /ESH29 (Wk3)
16 DEC 28  (1438)  1 /ESZ28 (AM Settled)
22 DEC 29  (1809)  1 /ESH30 (Wk3)
22 DEC 29  (1809)  1 /ESZ29 (AM Settled)