{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Status","Accounts","Positions","Orders","MarketData","StageOrder","Options"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Status","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,0,3,2],[0,2,1,2]]}
["tws.rtd","RTD Server Name",{"$error":"#VALUE!"}]
[null,"Custom connection string"]
[0,"RTD Throttle (ms)"]
["RTD Server Status & Metadata"]
["STATUS","IsConnected","RTD($A$1,,A5,B5,$A$2)"]
["STATUS","LastUpdateUtc","IFERROR(utctolocal(RTD($A$1,,A6,B6,$A$2)),\"\")"]
["STATUS","ServerHeartbeatUtc","utctolocal(RTD($A$1,,A7,B7,$A$2))"]
["STATUS","AccountsCsv","RTD($A$1,,A8,B8,$A$2)"]
["STATUS","ActiveTopicCount","RTD($A$1,,A9,B9,$A$2)"]
["STATUS","MarketDataType","RTD($A$1,,A10,B10,$A$2)"]
["STATUS","MarketDataState","RTD($A$1,,A11,B11,$A$2)"]
["STATUS","MarketDataMessage","RTD($A$1,,A12,B12,$A$2)"]
["STATUS","ConfigWarnings","RTD($A$1,,A13,B13,$A$2)"]
[null,"SERVER_PATH","RTD($A$1,,B14,$A$2)"]
[null,"VERSION","RTD($A$1,,B15,$A$2)"]
[null,"BUILD_TIME","RTD($A$1,,B16,$A$2)"]
[null,"ASSEMBLY_NAME","RTD($A$1,,B17,$A$2)"]
[null,"TWSAPI_STATE","RTD($A$1,,B18,$A$2)"]
[null,"TWSAPI_VERSION","RTD($A$1,,B19,$A$2)"]
[null,"TWSAPI_MESSAGE","RTD($A$1,,B20,$A$2)"]
[null,"LICENSE_STATE","RTD($A$1,,B21,$A$2)"]
[null,"LICENSE_MESSAGE","RTD($A$1,,B22,$A$2)"]
[null,"LICENSE_DAYS_REMAINING","RTD($A$1,,B23,$A$2)"]
[null,"UPDATE_AVAILABLE","RTD($A$1,,B24,$A$2)"]
[null,"UPDATE_CRITICAL","RTD($A$1,,B25,$A$2)"]
[null,"UPDATE_MESSAGE","RTD($A$1,,B26,$A$2)"]
[null,"UPDATE_LATEST_VERSION","RTD($A$1,,B27,$A$2)"]

{"sheet":"Accounts","index":1,"n_rows":284,"n_cols":3,"rows_kept":284,"cut":false,"hidden":false,"merged":[[0,2,1,5],[2,0,2,5]]}
["tws.rtd","RTD Server Name",{"$error":"#VALUE!"}]
[null,"Custom connection"]
["Account Data"]
["AccountsCSV","TEXTSPLIT(RTD(A1,,\"status\",A4,A2),\",\")"]
[{"$f":"A149:A284","v":"AccountName"},"IFERROR(RTD($A$1,,\"account\",B4#,A5#,$A$2),\"\")"]
["OpenPositionCount"]
["AccountCode"]
["AccountReady"]
["AccountType"]
["AccruedCash"]
["AccruedCash-C"]
["AccruedCash-S"]
["AccruedDividend"]
["AccruedDividend-C"]
["AccruedDividend-S"]
["AvailableFunds"]
["AvailableFunds-C"]
["AvailableFunds-S"]
["Billable"]
["Billable-C"]
["Billable-S"]
["BuyingPower"]
["CashBalance"]
["ColumnPrio-S"]
["CorporateBondValue"]
["Currency"]
["Cushion"]
["DailyPNL"]
["DayTradesRemaining"]
["DayTradesRemainingT+1"]
["DayTradesRemainingT+2"]
["DayTradesRemainingT+3"]
["DayTradesRemainingT+4"]
["DayTradingStatus-S"]
["DVPEquityWithLoanValue"]
["DVPNetLiquidation"]
["EquityWithLoanValue"]
["EquityWithLoanValue-C"]
["EquityWithLoanValue-S"]
["ExcessLiquidity"]
["ExcessLiquidity-C"]
["ExcessLiquidity-S"]
["ExchangeRate"]
["FullAvailableFunds"]
["FullAvailableFunds-C"]
["FullAvailableFunds-S"]
["FullExcessLiquidity"]
["FullExcessLiquidity-C"]
["FullExcessLiquidity-S"]
["FullInitMarginReq"]
["FullInitMarginReq-C"]
["FullInitMarginReq-S"]
["FullMaintMarginReq"]
["FullMaintMarginReq-C"]
["FullMaintMarginReq-S"]
["FundValue"]
["FutureOptionValue"]
["FuturesPNL"]
["FxCashBalance"]
["GrossPositionValue"]
["GrossPositionValue-S"]
["Guarantee"]
["Guarantee-S"]
["HighestSeverity"]
["IncentiveCoupons"]
["IncentiveCoupons-S"]
["IndianStockHaircut"]
["IndianStockHaircut-S"]
["InitMarginReq"]
["InitMarginReq-C"]
["InitMarginReq-S"]
["IssuerOptionValue"]
["Leverage"]
["Leverage-S"]
["LookAheadAvailableFunds"]
["LookAheadAvailableFunds-C"]
["LookAheadAvailableFunds-S"]
["LookAheadExcessLiquidity"]
["LookAheadExcessLiquidity-C"]
["LookAheadExcessLiquidity-S"]
["LookAheadInitMarginReq"]
["LookAheadInitMarginReq-C"]
["LookAheadInitMarginReq-S"]
["LookAheadMaintMarginReq"]
["LookAheadMaintMarginReq-C"]
["LookAheadMaintMarginReq-S"]
["LookAheadNextChange"]
["MaintMarginReq"]
["MaintMarginReq-C"]
["MaintMarginReq-S"]
["MoneyMarketFundValue"]
["MutualFundValue"]
["NetDividend"]
["NetLiquidation"]
["NetLiquidationByCurrency"]
["NetLiquidation-C"]
["NetLiquidation-S"]
["NetLiquidationUncertainty"]
["NLVAndMarginInReview"]
["OptionMarketValue"]
["PASharesValue"]
["PASharesValue-C"]
["PASharesValue-S"]
["PhysicalCertificateValue"]
["PhysicalCertificateValue-S"]
["PostExpirationExcess"]
["PostExpirationExcess-C"]
["PostExpirationExcess-S"]
["PostExpirationMargin"]
["PostExpirationMargin-C"]
["PostExpirationMargin-S"]
["PreviousDayEquityWithLoanValue"]
["PreviousDayEquityWithLoanValue-S"]
["PreviousEquityWithLoanValue"]
["RealCurrency"]
["RealizedPnL"]
["RegTEquity"]
["RegTEquity-S"]
["RegTMargin"]
["RegTMargin-S"]
["SegmentTitle"]
["SegmentTitle-S"]
["SettledCash"]
["SettledCashByDate"]
["SettledCashByDate-S"]
["SMA"]
["SMA-S"]
["StockMarketValue"]
["TBillValue"]
["TBondValue"]
["TotalCashBalance"]
["TotalCashValue"]
["TotalCashValue-C"]
["TotalCashValue-S"]
["TotalDebitCardPendingCharges"]
["TotalDebitCardPendingCharges-S"]
["TradingType-S"]
["UnrealizedPnL"]
["WarrantValue"]
["WhatIfPMEnabled"]
[]
[]
[]
[]
[]
[]
[]
["Account Field","Description"]
["AccountName"]
["OpenPositionCount"]
["AccountCode"," The account ID number"]
["AccountReady"," For internal use only"]
["AccountType"," Identifies the IB account structure"]
["AccruedCash"," Total accrued cash value of stock, commodities and securities"]
["AccruedCash-C"," Reflects the current's month accrued debit and credit interest to date, updated daily in commodity segment"]
["AccruedCash-S"," Reflects the current's month accrued debit and credit interest to date, updated daily in security segment"]
["AccruedDividend"," Total portfolio value of dividends accrued"]
["AccruedDividend-C"," Dividends accrued but not paid in commodity segment"]
["AccruedDividend-S"," Dividends accrued but not paid in security segment"]
["AvailableFunds"," This value tells what you have available for trading"]
["AvailableFunds-C"," Net Liquidation Value - Initial Margin"]
["AvailableFunds-S"," Equity with Loan Value - Initial Margin"]
["Billable"," Total portfolio value of treasury bills"]
["Billable-C"," Value of treasury bills in commodity segment"]
["Billable-S"," Value of treasury bills in security segment"]
["BuyingPower"," Buying power serves as a measurement of the dollar value of securities that one may purchase in a securities account without depositing additional funds"]
["CashBalance"," Cash recognized at the time of trade + futures PNL"]
["ColumnPrio-S"]
["CorporateBondValue"," Value of non-Government bonds such as corporate bonds and municipal bonds"]
["Currency"," Open positions are grouped by currency"]
["Cushion"," Excess liquidity as a percentage of net liquidation value"]
["DailyPNL"]
["DayTradesRemaining"," The Number of Open/Close trades a user could put on before Pattern Day Trading is detected. A value of \"-1\" means that the user can put on unlimited day trades."]
["DayTradesRemainingT+1"," Number of Open/Close trades one could do tomorrow before Pattern Day Trading is detected"]
["DayTradesRemainingT+2"," Number of Open/Close trades one could do two days from today before Pattern Day Trading is detected"]
["DayTradesRemainingT+3"," Number of Open/Close trades one could do three days from today before Pattern Day Trading is detected"]
["DayTradesRemainingT+4"," Number of Open/Close trades one could do four days from today before Pattern Day Trading is detected"]
["DayTradingStatus-S"]
["DVPEquityWithLoanValue"]
["DVPNetLiquidation"]
["EquityWithLoanValue"," Forms the basis for determining whether a client has the necessary assets to either initiate or maintain security positions. Cash + stocks + bonds + mutual funds"]
["EquityWithLoanValue-C"," Cash account: Total cash value + commodities option value - futures maintenance margin requirement + minimum (0, futures PNL) Margin account: Total cash value + commodities option value - futures maintenance margin requirement"]
["EquityWithLoanValue-S"," Cash account: Settled Cash Margin Account: Total cash value + stock value + bond value + (non-U.S. & Canada securities options value)"]
["ExcessLiquidity"," This value shows your margin cushion, before liquidation"]
["ExcessLiquidity-C"," Equity with Loan Value - Maintenance Margin"]
["ExcessLiquidity-S"," Net Liquidation Value - Maintenance Margin"]
["ExchangeRate"," The exchange rate of the currency to your base currency"]
["FullAvailableFunds"," Available funds of whole portfolio with no discounts or intraday credits"]
["FullAvailableFunds-C"," Net Liquidation Value - Full Initial Margin"]
["FullAvailableFunds-S"," Equity with Loan Value - Full Initial Margin"]
["FullExcessLiquidity"," Excess liquidity of whole portfolio with no discounts or intraday credits"]
["FullExcessLiquidity-C"," Net Liquidation Value - Full Maintenance Margin"]
["FullExcessLiquidity-S"," Equity with Loan Value - Full Maintenance Margin"]
["FullInitMarginReq"," Initial Margin of whole portfolio with no discounts or intraday credits"]
["FullInitMarginReq-C"," Initial Margin of commodity segment's portfolio with no discounts or intraday credits"]
["FullInitMarginReq-S"," Initial Margin of security segment's portfolio with no discounts or intraday credits"]
["FullMaintMarginReq"," Maintenance Margin of whole portfolio with no discounts or intraday credits"]
["FullMaintMarginReq-C"," Maintenance Margin of commodity segment's portfolio with no discounts or intraday credits"]
["FullMaintMarginReq-S"," Maintenance Margin of security segment's portfolio with no discounts or intraday credits"]
["FundValue"," Value of funds value (money market funds + mutual funds)"]
["FutureOptionValue"," Real-time market-to-market value of futures options"]
["FuturesPNL"," Real-time changes in futures value since last settlement"]
["FxCashBalance"," Cash balance in related IB-UKL account"]
["GrossPositionValue"," The sum of the absolute value of all stock and equity option positions"]
["GrossPositionValue-S"," Long Stock Value + Short Stock Value + Long Option Value + Short Option Value"]
["Guarantee"]
["Guarantee-S"]
["HighestSeverity"," A measure of how close the account is to liquidation"]
["IncentiveCoupons"]
["IncentiveCoupons-S"]
["IndianStockHaircut"," Margin rule for IB-IN accounts"]
["IndianStockHaircut-S"]
["InitMarginReq"," Initial Margin requirement of whole portfolio"]
["InitMarginReq-C"," Initial Margin of the commodity segment in base currency"]
["InitMarginReq-S"," Initial Margin of the security segment in base currency"]
["IssuerOptionValue"," Real-time mark-to-market value of Issued Option"]
["Leverage"," GrossPositionValue / NetLiquidation"]
["Leverage-S"," GrossPositionValue / NetLiquidation in security segment"]
["LookAheadAvailableFunds"," This value reflects your available funds at the next margin change"]
["LookAheadAvailableFunds-C"," Net Liquidation Value - look ahead Initial Margin"]
["LookAheadAvailableFunds-S"," Equity with Loan Value - look ahead Initial Margin"]
["LookAheadExcessLiquidity"," This value reflects your excess liquidity at the next margin change"]
["LookAheadExcessLiquidity-C"," Net Liquidation Value - look ahead Maintenance Margin"]
["LookAheadExcessLiquidity-S"," Equity with Loan Value - look ahead Maintenance Margin"]
["LookAheadInitMarginReq"," Initial margin requirement of whole portfolio as of next period's margin change"]
["LookAheadInitMarginReq-C"," Initial margin requirement as of next period's margin change in the base currency of the account"]
["LookAheadInitMarginReq-S"," Initial margin requirement as of next period's margin change in the base currency of the account"]
["LookAheadMaintMarginReq"," Maintenance margin requirement of whole portfolio as of next period's margin change"]
["LookAheadMaintMarginReq-C"," Maintenance margin requirement as of next period's margin change in the base currency of the account"]
["LookAheadMaintMarginReq-S"," Maintenance margin requirement as of next period's margin change in the base currency of the account"]
["LookAheadNextChange"," Time (Unix Timestamp) when look-ahead values take effect"]
["MaintMarginReq"," Maintenance Margin requirement of whole portfolio"]
["MaintMarginReq-C"," Maintenance Margin for the commodity segment"]
["MaintMarginReq-S"," Maintenance Margin for the security segment"]
["MoneyMarketFundValue"," Market value of money market funds excluding mutual funds"]
["MutualFundValue"," Market value of mutual funds excluding money market funds"]
["NetDividend"," The sum of the Dividend Payable/Receivable Values for the securities and commodities segments of the account"]
["NetLiquidation"," The basis for determining the price of the assets in your account. Total cash value + stock value + options value + bond value"]
["NetLiquidationByCurrency"," Net liquidation for individual currencies"]
["NetLiquidation-C"," Total cash value + futures PNL + commodities options value"]
["NetLiquidation-S"," Total cash value + stock value + securities options value + bond value"]
["NetLiquidationUncertainty"]
["NLVAndMarginInReview"]
["OptionMarketValue"," Real-time mark-to-market value of options"]
["PASharesValue"," Personal Account shares value of whole portfolio"]
["PASharesValue-C"," Personal Account shares value in commodity segment"]
["PASharesValue-S"," Personal Account shares value in security segment"]
["PhysicalCertificateValue"]
["PhysicalCertificateValue-S"]
["PostExpirationExcess"," Total projected \"at expiration\" excess liquidity"]
["PostExpirationExcess-C"," Provides a projected \"at expiration\" excess liquidity based on the soon-to expire contracts in your portfolio in commodity segment"]
["PostExpirationExcess-S"," Provides a projected \"at expiration\" excess liquidity based on the soon-to expire contracts in your portfolio in security segment"]
["PostExpirationMargin"," Total projected \"at expiration\" margin"]
["PostExpirationMargin-C"," Provides a projected \"at expiration\" margin value based on the soon-to expire contracts in your portfolio in commodity segment"]
["PostExpirationMargin-S"," Provides a projected \"at expiration\" margin value based on the soon-to expire contracts in your portfolio in security segment"]
["PreviousDayEquityWithLoanValue"," Marginable Equity with Loan value as of 16:00 ET the previous day in securities segment"]
["PreviousDayEquityWithLoanValue-S"," IMarginable Equity with Loan value as of 16:00 ET the previous day"]
["PreviousEquityWithLoanValue"," Marginable Equity with Loan value as of 16:00 ET the previous day"]
["RealCurrency"," Open positions are grouped by currency"]
["RealizedPnL"," Shows your profit on closed positions, which is the difference between your entry execution cost and exit execution costs, or (execution price + commission and fees to open the positions) - (execution price + commission and fees to close the position)"]
["RegTEquity"," Regulation T equity for universal account"]
["RegTEquity-S"," Regulation T equity for security segment"]
["RegTMargin"," Regulation T margin for universal account"]
["RegTMargin-S"," Regulation T margin for security segment"]
["SegmentTitle"," Account segment name"]
["SegmentTitle-S"]
["SettledCash"," Cash recognized at the time of settlement - purchases at the time of trade - commissions - taxes - fees"]
["SettledCashByDate"]
["SettledCashByDate-S"]
["SMA"," Special Memorandum Account: Line of credit created when the market value of securities in a Regulation T account increase in value"]
["SMA-S"," Regulation T Special Memorandum Account balance for security segment"]
["StockMarketValue"," Real-time mark-to-market value of stock"]
["TBillValue"," Value of treasury bills"]
["TBondValue"," Value of treasury bonds"]
["TotalCashBalance"," Total Cash Balance including Future PNL"]
["TotalCashValue"," Total cash value of stock, commodities and securities"]
["TotalCashValue-C"," CashBalance in commodity segment"]
["TotalCashValue-S"," CashBalance in security segment"]
["TotalDebitCardPendingCharges"]
["TotalDebitCardPendingCharges-S"]
["TradingType-S"," Account Type"]
["UnrealizedPnL"," The difference between the current market value of your open positions and the average cost, or Value - Average Cost"]
["WarrantValue"," Value of warrants"]
["WhatIfPMEnabled"," To check projected margin requirements under Portfolio Margin model"]

{"sheet":"Positions","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,13,1,15],[1,11,1,12],[2,11,2,12]]}
["tws.rtd","RTD Server Name",null,null,null,null,null,null,null,null,"PositionDataState","RTD($A$1,,\"status\",K1,$A$2)",null,{"$error":"#VALUE!"}]
[null,"Custom connection",null,null,null,null,null,null,null,null,"LastPositionListChangeUTC","utctolocal(RTD($A$1,,\"status\",K2,$A$2))"]
[null,"Accounts to report (empty = ALL)",null,null,null,null,null,null,null,null,"LastPositionUpdateUTC","utctolocal(RTD($A$1,,\"status\",K3,$A$2))"]
["Accounts Available:","RTD(A1,,\"status\",\"AccountsCsv\",$A$2)"]
["ContractID","Position",{"$f":"{\"LocalSymbol\",\"AverageCost\",\"MarketValue\",\"DailyPNL\",\"RealizedPNL\",\"UnrealizedPNL\",\"SecType\",\"Exchange\",\"Currency\",\"TradingClass\",\"Right\",\"Expiration\",\"Strike\",\"Multiplier\"}","v":"LocalSymbol"},"AverageCost","MarketValue","DailyPNL","RealizedPNL","UnrealizedPNL","SecType","Exchange","Currency","TradingClass","Right","Expiration","Strike","Multiplier"]
["TEXTSPLIT(RTD($A$1, , \"positions\", A3, \"ConIdCsv\", $A$2), , \";\")","RTD($A$1,,\"position\",$A$3,\"conid=\"&$A6#,$A$2)","IFERROR(RTD($A$1,,\"position\",$A$3,\"conid=\"&$A6#,C5#,$A$2),\"\")"]

{"sheet":"Orders","index":3,"n_rows":6,"n_cols":80,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,13,1,15],[1,11,1,12],[2,11,2,12]]}
["tws.rtd","RTD Server Name",null,null,null,null,null,null,null,null,"OrderDataState","RTD($A$1,,\"status\",K1,$A$2)",null,{"$error":"#VALUE!"}]
[null,"Custom connection",null,null,null,null,null,null,null,null,"LastOrderListChangeUTC","utctolocal(RTD($A$1,,\"status\",K2,$A$2))"]
[null,"Accounts to report (empty = ALL)",null,null,null,null,null,null,null,null,"LastOrderUpdateUTC","utctolocal(RTD($A$1,,\"status\",K3,$A$2))"]
[false,"Only show open orders"]
["PermID",{"$f":"{\"FirstSeenUTC\",\"LastUpdate\"}","v":"FirstSeenUTC"},"LastUpdate",{"$f":"{\"Status\",\"Symbol\",\"Side\",\"OrderType\",\"Quantity\",\"Filled\",\"Remaining\",\"LmtPrice\",\"AvgFillPrice\",\"TIF\",\"Exchange\",\"AlgoStrategy\",\"AlgoParams\",\"ConId\",\"SecType\",\"Currency\",\"DisplaySize\",\"Hidden\",\"AllowPreOpen\",\"OutsideRTH\",\"StopPrice\",\"TrailStopPrice\",\"TrailingPercent\",\"ActiveStartTime\",\"Right\",\"ParentId\",\"WhyHeld\",\"Submitter\",\"Account\",\"FAGroup\",\"FAMethod\",\"WarningText\",\"OrderId\",\"ClientId\",\"OrdRef\",\"Expiry\",\"Strike\",\"Multiplier\",\"PrimaryExchange\",\"LocalSymbol\",\"TradingClass\",\"GoodTillDate\",\"GoodAfterTime\",\"OCAGroup\",\"OCAType\",\"MinQty\",\"PercentOffset\",\"DiscretionaryAmt\",\"CashQty\",\"LmtPriceOffset\",\"ActiveStopTime\",\"ModelCode\",\"OpenClose\",\"AllOrNone\",\"BlockOrder\",\"SweepToFill\",\"NotHeld\",\"Solicited\",\"WhatIf\",\"IncludeOvernight\",\"CompletedStatus\",\"CompletedTime\",\"RejectReason\",\"CommissionAndFees\",\"MinCommissionAndFees\",\"MaxCommissionAndFees\",\"CommissionAndFeesCurrency\",\"MarginCurrency\",\"InitMarginBefore\",\"MaintMarginBefore\",\"EquityWithLoanBefore\",\"InitMarginChange\",\"MaintMarginChange\",\"EquityWithLoanChange\",\"InitMarginAfter\",\"MaintMarginAfter\",\"EquityWithLoanAfter\"}","v":"Status"},"Symbol","Side","OrderType","Quantity","Filled","Remaining","LmtPrice","AvgFillPrice","TIF","Exchange","AlgoStrategy","AlgoParams","ConId","SecType","Currency","DisplaySize","Hidden","AllowPreOpen","OutsideRTH","StopPrice","TrailStopPrice","TrailingPercent","ActiveStartTime","Right","ParentId","WhyHeld","Submitter","Account","FAGroup","FAMethod","WarningText","OrderId","ClientId","OrdRef","Expiry","Strike","Multiplier","PrimaryExchange","LocalSymbol","TradingClass","GoodTillDate","GoodAfterTime","OCAGroup","OCAType","MinQty","PercentOffset","DiscretionaryAmt","CashQty","LmtPriceOffset","ActiveStopTime","ModelCode","OpenClose","AllOrNone","BlockOrder","SweepToFill","NotHeld","Solicited","WhatIf","IncludeOvernight","CompletedStatus","CompletedTime","RejectReason","CommissionAndFees","MinCommissionAndFees","MaxCommissionAndFees","CommissionAndFeesCurrency","MarginCurrency","InitMarginBefore","MaintMarginBefore","EquityWithLoanBefore","InitMarginChange","MaintMarginChange","EquityWithLoanChange","InitMarginAfter","MaintMarginAfter","EquityWithLoanAfter"]
["TEXTSPLIT(RTD($A$1,, \"orders\", A3, IF(A4, \"OpenListCsv\", \"ListCsv\"), $A$2),, \",\")","utctolocal(RTD($A$1,, \"order\", $A6#, B5#, $A$2))",null,"IFNA(RTD($A$1,, \"order\", $A6#, D5#, $A$2),\"\")"]

{"sheet":"MarketData","index":4,"n_rows":79,"n_cols":14,"rows_kept":79,"cut":false,"hidden":false,"merged":[[3,0,3,2],[4,1,4,2],[3,5,3,6],[0,6,1,6]]}
["tws.rtd","RTD Server Name",null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null," RTD Field "]
[null,"Custom connection",null,null,null,null,null,null,null,null,null,null,null,"MarketDataType"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MarketPrice"]
["Market Data Inspector",null,null,null,null,"Contract Specification Examples",null,"MarketPrice","Notes",null,null," Tick ID "," IB Name ","LastOrClose"]
["Contract:","SPY",null,null,null,"Ticker","AAPL","RTD($A$1,, $G3, H$4, $A$2)","Bare ticker defaults to STK / SMART / USD.",null,null,0," BID_SIZE ","BIDSIZE"]
["LastTime","RTD($A$1,,B$4,$A5,$A$3)/86400+25569+E2/24"," Timestamp of last trade ",null,null,"Ticker@Exchange","AAPL@NASDAQ","RTD($A$1,, $H4, I$2, $A$3)","Routes to a named exchange instead of SMART.",null,null,1," BID ","BID"]
[{"$f":"N2:N73","v":"MarketDataType"},"IFERROR(RTD($A$1,,B$5,$A8#,$A$2),\"\")"," Actual MarketDataType supplied",null,null,"Compact","AAPL@NASDAQ/STK/USD","RTD($A$1,, $H5, I$2, $A$3)","SYMBOL@EXCH[/PRIMEXCH]/SECTYPE[/EXP][/RIGHT][/STRIKE][/CURRENCY]",null,null,2," ASK ","ASK"]
["MarketPrice",null," MID if available →  LAST → CLOSE",null,null,"Compact + PrimaryExch","AAPL@SMART/NASDAQ/STK/USD","RTD($A$1,, $H6, I$2, $A$3)","A security type must follow the primary exchange.",null,null,3," ASK_SIZE ","ASKSIZE"]
["LastOrClose",null," LAST if available, else CLOSE ",null,null,"Compact future","ES@CME/FUT/202612/USD","RTD($A$1,, $H7, I$2, $A$3)","Futures take the contract month YYYYMM.",null,null,4," LAST ","LAST"]
["BIDSIZE",null," Size at best bid ",null,null,"Compact option","SPY@SMART/OPT/20261218/C/680/USD","RTD($A$1,, $H8, I$2, $A$3)","Segments after the security type are read by shape, so any of them can be omitted.",null,null,5," LAST_SIZE ","LASTSIZE"]
["BID",null," Best bid price ",null,null,"Pipe","SPY|OPT|20261218|C|680","RTD($A$1,, $H9, I$2, $A$3)","SYMBOL|SECTYPE|EXPIRY|RIGHT|STRIKE. No exchange or currency segment.",null,null,6," HIGH ","HIGH"]
["ASK",null," Best ask price ",null,null,"FX pair","EUR.USD/CASH","RTD($A$1,, $H10, I$2, $A$3)","BASE.QUOTE/CASH. Routes to IDEALPRO.",null,null,7," LOW ","LOW"]
["ASKSIZE",null," Size at best ask ",null,null,"ConID","conid=265598","RTD($A$1,, $H11, I$2, $A$3)","IBKR contract ID identifies exactly one contract. This one is AAPL.",null,null,8," VOLUME ","VOLUME"]
["LAST",null," Last trade price ",null,null,null,"Ensure expiration dates are valid!",null,null,null,null,9," CLOSE ","CLOSE"]
["LASTSIZE",null," Last trade size ",null,null,null,null,null,null,null,null,14," OPEN ","OPEN"]
["HIGH",null," Session high ",null,null,null,null,null,null,null,null,15," LOW_13_WEEK ","WEEK13LO"]
["LOW",null," Session low ",null,null,null,null,null,null,null,null,16," HIGH_13_WEEK ","WEEK13HI"]
["VOLUME",null," Total volume ",null,null,null,null,null,null,null,null,17," LOW_26_WEEK ","WEEK26LO"]
["CLOSE",null," Previous session close ",null,null,null,null,null,null,null,null,18," HIGH_26_WEEK ","WEEK26HI"]
["OPEN",null," Session open price ",null,null,null,null,null,null,null,null,19," LOW_52_WEEK ","WEEK52LO"]
["WEEK13LO",null," 13-week low ",null,null,null,null,null,null,null,null,20," HIGH_52_WEEK ","WEEK52HI"]
["WEEK13HI",null," 13-week high ",null,null,null,null,null,null,null,null,21," AVG_VOLUME ","AVGVOLUME"]
["WEEK26LO",null," 26-week low ",null,null,null,null,null,null,null,null,23," OPTION_HISTORICAL_VOL ","OPTIONHISTORICALVOL"]
["WEEK26HI",null," 26-week high ",null,null,null,null,null,null,null,null,24," OPTION_IMPLIED_VOL ","OPTIONIMPLIEDVOL"]
["WEEK52LO",null," 52-week low ",null,null,null,null,null,null,null,null,27," OPTION_CALL_OPEN_INTEREST ","CALLOPTIONOPENINTEREST"]
["WEEK52HI",null," 52-week high ",null,null,null,null,null,null,null,null,28," OPTION_PUT_OPEN_INTEREST ","PUTOPTIONOPENINTEREST"]
["AVGVOLUME",null," Average daily volume ",null,null,null,null,null,null,null,null,29," OPTION_CALL_VOLUME ","CALLOPTIONVOLUME"]
["OPTIONHISTORICALVOL",null," Historical volatility",null,null,null,null,null,null,null,null,30," OPTION_PUT_VOLUME ","PUTOPTIONVOLUME"]
["OPTIONIMPLIEDVOL",null," Implied volatility",null,null,null,null,null,null,null,null,31," INDEX_FUTURE_PREMIUM ","INDEXFUTUREPREMIUM"]
["CALLOPTIONOPENINTEREST",null," Call option Open Interest",null,null,null,null,null,null,null,null,32," BID_EXCH ","BIDEXCH"]
["PUTOPTIONOPENINTEREST",null," Put option Open Interest",null,null,null,null,null,null,null,null,33," ASK_EXCH ","ASKEXCH"]
["CALLOPTIONVOLUME",null," Call option volume ",null,null,null,null,null,null,null,null,34," AUCTION_VOLUME ","AUCTIONVOLUME"]
["PUTOPTIONVOLUME",null," Put option volume ",null,null,null,null,null,null,null,null,35," AUCTION_PRICE ","AUCTIONPRICE"]
["INDEXFUTUREPREMIUM",null," Index future premium",null,null,null,null,null,null,null,null,36," AUCTION_IMBALANCE ","AUCTIONIMBALANCE"]
["BIDEXCH",null," Exchange(s) posting best bid ",null,null,null,null,null,null,null,null,37," MARK_PRICE ","PLPRICE"]
["ASKEXCH",null," Exchange(s) posting best ask ",null,null,null,null,null,null,null,null,46," SHORTABLE ","SHORTABLE"]
["AUCTIONVOLUME",null," Auction volume ",null,null,null,null,null,null,null,null,49," HALTED ","HALTED"]
["AUCTIONPRICE",null," Auction price ",null,null,null,null,null,null,null,null,54," TRADE_COUNT ","TRADECOUNT"]
["AUCTIONIMBALANCE",null," Auction imbalance ",null,null,null,null,null,null,null,null,55," TRADE_RATE ","TRADERATE"]
["PLPRICE",null," P&L mark price",null,null,null,null,null,null,null,null,56," VOLUME_RATE ","VOLUMERATE"]
["SHORTABLE",null," Timestamp of last trade ",null,null,null,null,null,null,null,null,57," LAST_RTH_TRADE ","LASTRTHTRADE"]
["HALTED",null," Shortability indicator (>2.5 = easy) ",null,null,null,null,null,null,null,null,58," RT_HISTORICAL_VOL ","RTHISTORICALVOL"]
["TRADECOUNT",null," Trading halt indicator (0=not halted) ",null,null,null,null,null,null,null,null,59," IB_DIVIDENDS ","IBDIVIDENDS"]
["TRADERATE",null," Trade count",null,null,null,null,null,null,null,null,60," BOND_FACTOR_MULTIPLIER ","BONDMULTIPLIER"]
["VOLUMERATE",null," Trades per minute",null,null,null,null,null,null,null,null,61," REGULATORY_IMBALANCE ","REGULATORYIMBALANCE"]
["LASTRTHTRADE",null," Volume per minute",null,null,null,null,null,null,null,null,63," SHORT_TERM_VOLUME_3_MIN ","SHORTTERMVOLUME3MIN"]
["RTHISTORICALVOL",null," Last regular hours trade",null,null,null,null,null,null,null,null,64," SHORT_TERM_VOLUME_5_MIN ","SHORTTERMVOLUME5MIN"]
["IBDIVIDENDS",null," Real-time historical vol",null,null,null,null,null,null,null,null,65," SHORT_TERM_VOLUME_10_MIN ","SHORTTERMVOLUME10MIN"]
["BONDMULTIPLIER",null," Dividend info",null,null,null,null,null,null,null,null,66," DELAYED_BID ","DELAYEDBID"]
["REGULATORYIMBALANCE",null," Bond factor",null,null,null,null,null,null,null,null,67," DELAYED_ASK ","DELAYEDASK"]
["SHORTTERMVOLUME3MIN",null," Regulatory imbalance ",null,null,null,null,null,null,null,null,68," DELAYED_LAST ","DELAYEDLAST"]
["SHORTTERMVOLUME5MIN",null," 3-minute volume ",null,null,null,null,null,null,null,null,69," DELAYED_BID_SIZE ","DELAYEDBIDSIZE"]
["SHORTTERMVOLUME10MIN",null," 5-minute volume ",null,null,null,null,null,null,null,null,70," DELAYED_ASK_SIZE ","DELAYEDASKSIZE"]
["DELAYEDBID",null," 10-minute volume ",null,null,null,null,null,null,null,null,71," DELAYED_LAST_SIZE ","DELAYEDLASTSIZE"]
["DELAYEDASK",null," Delayed BID",null,null,null,null,null,null,null,null,72," DELAYED_HIGH ","DELAYEDHIGH"]
["DELAYEDLAST",null," Delayed ASK",null,null,null,null,null,null,null,null,73," DELAYED_LOW ","DELAYEDLOW"]
["DELAYEDBIDSIZE",null," Delayed LAST",null,null,null,null,null,null,null,null,74," DELAYED_VOLUME ","DELAYEDVOLUME"]
["DELAYEDASKSIZE",null," Delayed BIDSIZE",null,null,null,null,null,null,null,null,75," DELAYED_CLOSE ","DELAYEDCLOSE"]
["DELAYEDLASTSIZE",null," Delayed ASKSIZE",null,null,null,null,null,null,null,null,76," DELAYED_OPEN ","DELAYEDOPEN"]
["DELAYEDHIGH",null," Delayed LASTSIZE",null,null,null,null,null,null,null,null,78," CREDITMAN_MARK_PRICE ","CREDITMANMARKPRICE"]
["DELAYEDLOW",null," Delayed HIGH",null,null,null,null,null,null,null,null,79," CREDITMAN_SLOW_MARK_PRICE ","CREDITMANSLOWMARKPRICE"]
["DELAYEDVOLUME",null," Delayed LOW",null,null,null,null,null,null,null,null,84," LAST_EXCH ","LASTEXCH"]
["DELAYEDCLOSE",null," Delayed VOLUME",null,null,null,null,null,null,null,null,86," FUTURES_OPEN_INTEREST ","FUTURESOPENINTEREST"]
["DELAYEDOPEN",null," Delayed CLOSE",null,null,null,null,null,null,null,null,87," AVG_OPT_VOLUME ","AVGOPTVOLUME"]
["CREDITMANMARKPRICE",null," Delayed OPEN",null,null,null,null,null,null,null,null,88," DELAYED_LAST_TIMESTAMP ","DELAYEDLASTTIMESTAMP"]
["CREDITMANSLOWMARKPRICE",null," Credit mark price",null,null,null,null,null,null,null,null,89," SHORTABLE_SHARES ","SHORTABLESHARES"]
["LASTEXCH",null," Slow credit mark",null,null,null,null,null,null,null,null,90," DELAYED_HALTED ","DELAYEDHALTED"]
["FUTURESOPENINTEREST",null," Exchange of last trade ",null,null,null,null,null,null,null,null,96," ETF_NAV_LAST ","ETFNAVLAST"]
["AVGOPTVOLUME",null," Futures OI",null,null,null,null,null,null,null,null,97," ETF_FROZEN_NAV_LAST ","ETFFROZENNAVLAST"]
["DELAYEDLASTTIMESTAMP",null," Average option volume (STK) ",null,null,null,null,null,null,null,null,98," ETF_NAV_HIGH ","ETFNAVHIGH"]
["SHORTABLESHARES",null," Delayed LASTTIME",null,null,null,null,null,null,null,null,99," ETF_NAV_LOW ","ETFNAVLOW"]
["DELAYEDHALTED",null," Shares available to short ",null,null,null,null,null,null,null,null,101," ESTIMATED_IPO_MIDPOINT ","ESTIMATEDIPOMIDPOINT"]
["ETFNAVLAST",null," HALTED",null,null,null,null,null,null,null,null,102," FINAL_IPO_LAST ","FINALIPOLAST"]
["ETFFROZENNAVLAST",null," ETF NAV last"]
["ETFNAVHIGH",null," Frozen ETF NAV"]
["ETFNAVLOW",null," ETF NAV high"]
["ESTIMATEDIPOMIDPOINT",null," ETF NAV low"]
["FINALIPOLAST",null," Estimated IPO midpoint "]
[null,null," Final IPO price "]

{"sheet":"StageOrder","index":5,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["tws.rtd",null,"Staged Counter:",0,null,"Important notes"]
[null,null,null,"Orders Staged here",null,"1. StageOrder cells are one-way: each edit stages a new order in TWS — it never modifies or cancels an existing one."]
[null,"<< Custom connection string",null,null,null,"2. Review and submit staged orders in TWS; the last click is always yours and must be performed in TWS."]
["Order API Reference",null,null,null,null,"3. Deleting a StageOrder cell does not cancel the order in TWS — cancel staged orders in TWS itself."]
["Symbol","SPY","Required",null,null,"4. The Stage Order button also appends \"tag={StagedCounter}\" from cell D1 to ensure a unique ticket each click."]
["Side","BUY","Required: BUY or SELL",null,null,"5. Track Order status on the Orders sheet."]
["Shares",5,"Required: whole number > 0"]
["Type","LMT","Required: MKT, LMT, STP, etc."]
["Limit",100.25,"Required for LMT and STP LMT",null,null,"Examples. To run one add a leading \"=\" to make Excel evaluate it as a formula.  Ensure any date values are valid."]
["Stop",null,"Required for STP; for TRAIL, this or TrailingPercent",null,null,"Rule exercised","Formula (text)","What breaking the rule returns"]
["TrailingPercent",null,"TRAIL types only; value must be in range (0, 100)",null,null,"MKT - no price keys","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=5\", \"type=MKT\", $A$3)","Omit Type: StageOrder requires Type (e.g., LMT, MKT)."]
["TIF",null,"Blank = DAY",null,null,"LMT - Limit required","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=5\", \"type=LMT\", \"limit=100.10\", \"tif=DAY\", $A$3)","Omit Limit: StageOrder for LMT requires Limit > 0."]
["GoodTillDate",null,"Required if TIF=GTD. YYYYMMDD [HH:MM:SS [TZ]]",null,null,"STP - Stop required","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=STP\", \"stop=95.00\", $A$3)","Omit Stop: StageOrder for STP requires Stop > 0."]
["GoodAfterTime",null,"YYYYMMDD [HH:MM:SS [TZ]]",null,null,"STP LMT - Stop and Limit required","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=STP LMT\", \"stop=95.00\", \"limit=94.50\", $A$3)","Omit either: StageOrder for STP LMT requires {Limit > 0, Stop > 0}."]
["OutsideRTH",null,"TRUE or FALSE",null,null,"TRAIL by percent","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=TRAIL\", \"trailingpercent=2.5\", $A$3)","Supply both or neither: StageOrder for TRAIL requires exactly one of Stop or TrailingPercent."]
["Display",null,"Iceberg display size, whole number > 0",null,null,"TRAIL by amount","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=TRAIL\", \"stop=1.50\", $A$3)","Add Stop to an LMT order: StageOrder Stop is only valid for STP, STP LMT, TRAIL, TRAIL LIMIT types."]
["Hidden",null,"TRUE or FALSE",null,null,"GTD - TIF and GoodTillDate required","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=5\", \"type=LMT\", \"limit=100.10\", \"tif=GTD\", \"goodtilldate=20261231 16:00:00\", $A$3)","Either without the other: StageOrder GoodTillDate requires TIF=GTD. / StageOrder TIF=GTD requires GTD=YYYYMMDD [HH:MM:SS [TZ]]."]
["AllOrNone",null,"TRUE or FALSE",null,null,"OCA leg 1 - OCAgroup and OCAtype required","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=LMT\", \"limit=110.00\", \"ocagroup=SPY-EXIT-1\", \"ocatype=1\", $A$3)","Either without the other: StageOrder OCAgroup and OCAtype are required together."]
["MinQty",null,"Whole number > 0",null,null,"OCA leg 2 - same OCAgroup, other leg","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=SELL\", \"shares=5\", \"type=STP\", \"stop=95.00\", \"ocagroup=SPY-EXIT-1\", \"ocatype=1\", $A$3)","(OCAtype: 1=cancel remaining with block, 2=reduce remaining with block, 3=reduce remaining without block)."]
["OCAgroup",null,"One-cancels-all group name. Requires OCAtype.",null,null,"Iceberg, after-hours, good-after time","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=500\", \"type=LMT\", \"limit=99.00\", \"display=100\", \"OutsideRTH=TRUE\", \"GAT=20261231 09:35:00\", $A$3)"]
["OCAtype",null,"1, 2 or 3. Requires OCAgroup.",null,null,"Option - requires expiry, strike, right","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"sec=OPT\", \"exp=20261218\", \"strike=680\", \"right=C\", \"side=BUY\", \"shares=1\", \"type=LMT\", \"limit=2.50\", $A$3)","Omit any of the three: StageOrder sec=OPT requires exp=, strike=, and right= (or loc=LOCALSYMBOL)."]
["Park",null,"TRUE stages a ticket only visible in your TWS instance",null,null,"Future - requires expiry","RTD($A$1,, \"StageOrder\", \"sym=ES\", \"sec=FUT\", \"exch=CME\", \"exp=202612\", \"cur=USD\", \"side=BUY\", \"shares=1\", \"type=LMT\", \"limit=6500.00\", $A$3)","Omit Expiry: StageOrder sec=FUT requires exp= (or loc=LOCALSYMBOL)."]
["Exchange",null,"Blank = SMART",null,null,"FX pair","RTD($A$1,, \"StageOrder\", \"sym=EUR\", \"sec=CASH\", \"cur=USD\", \"exch=IDEALPRO\", \"side=BUY\", \"shares=25000\", \"type=LMT\", \"limit=1.0850\", $A$3)"]
["Account",null,"Account number, if multiple available",null,null,"ConID - unique contract identifier","RTD($A$1,, \"StageOrder\", \"conid=756733\", \"side=BUY\", \"shares=5\", \"type=LMT\", \"limit=100.10\", $A$3)","Add Sym: StageOrder conID identifies the contract by itself - do not also supply 'sym'. Only Exchange may accompany conID."]
["FAgroup",null,"Financial-advisor allocation group (e.g., \"All\")",null,null,"Park - a ticket only visible in your TWS","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=5\", \"type=LMT\", \"limit=100.10\", \"park=TRUE\", $A$3)"]
["AlgoStrategy",null,"Examples: Adaptive, TWAP, VWAP",null,null,"Algo","RTD($A$1,, \"StageOrder\", \"sym=SPY\", \"side=BUY\", \"shares=500\", \"type=LMT\", \"limit=99.00\", \"algo=Adaptive\", \"algoparams=adaptivePriority=Normal\", $A$3)"]
["AlgoParams",null,"Pipe-delimited list of {tag=value}"]
["SecType",null,"Blank = STK"]
["Currency",null,"Blank = USD"]
["Expiry",null,"OPT, FOP, FUT only. YYYYMM or YYYYMMDD"]
["Strike",null,"OPT and FOP only"]
["Right",null,"OPT and FOP only. C or P"]
["Multiplier",null,"Contract multiplier"]
["Local",null,"Exchange local symbol. Case-sensitive."]
["TC",null,"Trading class. Case-sensitive."]
["Primary",null,"Primary listing exchange"]

{"sheet":"Options","index":6,"n_rows":8,"n_cols":21,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,8],[0,10,0,16]]}
["tws.rtd",null,{"$f":"A5&\" \"&A6&\" Calls\"","v":"SPY 20260731 Calls"},null,null,null,null,null,null,"RTD(\"tws.rtd\",,A5,\"MarketPrice\")",{"$f":"A5&\" \"&A6&\" Puts\"","v":"SPY 20260731 Puts"},null,null,null,null,null,null,null,null,"Strikes","--TEXTSPLIT(RTD(\"tws.rtd\",,A5,\"OptionStrikesCSV\"),,\",\")"]
["A8,U1,J1,C3:Q3",null,"Delta","IV","Volume","BidSize","Bid","Ask","AskSize","Strike","BidSize","Bid","Ask","AskSize","Volume","IV","Delta",null,{"$f":"_xlfn.XMATCH(J1,U:U,1,2)","v":1},"Strike Index"]
[null,null,"IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,\"ModelDelta\"),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,\"ModelImpliedVol\"),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,E$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,F$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,G$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,H$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=C\",\"exp=\"&$A$6,I$2),\"\")","INDEX(U1#,SEQUENCE(2*A4,1,S2-A4))","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,K$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,L$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,M$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,N$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,O$2),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,\"ModelImpliedVol\"),\"\")","IFNA(RTD(\"tws.rtd\",,\"sym=\"&$A$5,\"sec=OPT\",\"strike=\"&$J3#,\"right=P\",\"exp=\"&$A$6,\"ModelDelta\"),\"\")"]
[20,"<< # Strikes"]
["SPY","<< Underlying"]
["20260731","<< Expiration"]
["Available Expirations"]
["TEXTSPLIT(RTD(\"tws.rtd\",,A5,\"OptionExpirationsCSV\"),,\",\")"]