{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Status","Account","Positions","Orders","MarketData","SendOrder","Options"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
["tws.rtd",null,null,"UTC Offset","RTD Throttle (ms)"]
["C5:C15",null,null,-7,1000]
[null,"<< Custom connection string"]
["RTD Server MetaData"]
[null,"SERVER_PATH","RTD($A$1,,B5,$A$3)"]
[null,"VERSION","RTD($A$1,,B6,$A$3)"]
[null,"BUILD_TIME","RTD($A$1,,B7,$A$3)"]
[null,"CONFIGURATION","RTD($A$1,,B8,$A$3)"]
[null,"ASSEMBLY_NAME","RTD($A$1,,B9,$A$3)"]
["STATUS","IsConnected","RTD($A$1,,A10,B10,$A$3)"]
["STATUS","ActiveTopicCount","RTD($A$1,,A11,B11,$A$3)"]
["STATUS","MarketDataType","RTD($A$1,,A12,B12,$A$3)","Local Time"]
["STATUS","LastUpdateUtc","RTD($A$1,,A13,B13,$A$3)",{"$f":"IFERROR(C13+$D$2/24,\"\")","v":""}]
["STATUS","ServerHeartbeatUtc","RTD($A$1,,A14,B14,$A$3)",{"$f":"IFERROR(C14+$D$2/24,\"\")","v":""}]
["STATUS","AccountsCsv","RTD($A$1,,A15,B15,$A$3)"]

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

{"sheet":"Positions","index":2,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["tws.rtd",null,null,null,null,"STATUS","PositionDataState","RTD($A$1,,F1,G1,$A$3)","Local Time","UTC Offset"]
["A5:A5,A7:C7,H1:H3",null,null,null,null,"POSITIONS","PositionsChangedUtc","RTD($A$1,,F2,G2,$A$3)",{"$f":"IFERROR(H2+$J$2/24,\"\")","v":""},-7]
[null,"<< Custom connection string",null,null,null,"STATUS","LastPositionUpdateUtc","RTD($A$1,,F3,G3,$A$3)",{"$f":"IFERROR(H3+$J$2/24,\"\")","v":""}]
[null,"<< Accounts to report (empty = ALL)"]
["RTD(A1,,\"status\",\"AccountsCsv\",$A$3)","<< Accounts available"]
["ContractIDs with Positions","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(\"tws.rtd\", , \"positions\", A4, \"ConIdCsv\", $A$3), , \";\")","RTD($A$1,,\"position\",$A$4,\"conid=\"&$A7#,$A$3)","IFERROR(RTD($A$1,,\"position\",$A$4,\"conid=\"&$A7#,C6#,$A$3),\"\")"]

{"sheet":"Orders","index":3,"n_rows":7,"n_cols":35,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["tws.rtd",null,null,null,null,"STATUS","OrderDataState","RTD($A$1,,F1,G1,A3)","Local Time","UTC Offset"]
["A7:AZ7,H1:H3",null,null,null,null,"STATUS","LastOrderListChangeUtc","RTD($A$1,,F2,G2,A3)",{"$f":"H2+$J$2/24","v":{"$error":"#VALUE!"}},-7]
[null,"<< Custom connection string",null,null,null,"STATUS","LastOrderUpdateUtc","RTD($A$1,,F3,G3,A4)",{"$f":"H3+$J$2/24","v":{"$error":"#VALUE!"}}]
[null,"<< Accounts to report (empty = ALL)"]
["FALSE","<< Only show open orders"]
["OrderID","Status","SYMBOL","SIDE","ORDERTYPE","QUANTITY","LastUpdate","FILLED","REMAINING","LMTPRICE","AVGFILLPRICE","TIF","EXCHANGE","AlgoStrategy","AlgoParams","CONID","SECTYPE","CURRENCY","DisplaySize","Hidden","AllowPreOpen","OutsideRTH","StopPrice","TrailStopPrice","TrailingPercent","ActiveStartTime","ManualOrderTime","RIGHT","PARENTID","WHYHELD","Submitter","ACCOUNT","FAGroup","FAMethod","WarningText"]
["TEXTSPLIT(RTD(\"tws.rtd\", , \"orders\", A4, IF(A5,\"OpenListCsv\",\"ListCsv\"),$A$3), , \",\")","RTD($A$1,,\"order\",$A7#,B$6,$A$3)","RTD($A$1,,\"order\",$A7#,C$6,$A$3)","RTD($A$1,,\"order\",$A7#,D$6,$A$3)","RTD($A$1,,\"order\",$A7#,E$6,$A$3)","RTD($A$1,,\"order\",$A7#,F$6,$A$3)","RTD($A$1,,\"order\",$A7#,G$6,$A$3)+J2/24","RTD($A$1,,\"order\",$A7#,H$6,$A$3)","RTD($A$1,,\"order\",$A7#,I$6,$A$3)","RTD($A$1,,\"order\",$A7#,J$6,$A$3)","RTD($A$1,,\"order\",$A7#,K$6,$A$3)","RTD($A$1,,\"order\",$A7#,L$6,$A$3)","RTD($A$1,,\"order\",$A7#,M$6,$A$3)","RTD($A$1,,\"order\",$A7#,N$6,$A$3)","RTD($A$1,,\"order\",$A7#,O$6,$A$3)","RTD($A$1,,\"order\",$A7#,P$6,$A$3)","RTD($A$1,,\"order\",$A7#,Q$6,$A$3)","RTD($A$1,,\"order\",$A7#,R$6,$A$3)","RTD($A$1,,\"order\",$A7#,S$6,$A$3)","RTD($A$1,,\"order\",$A7#,T$6,$A$3)","RTD($A$1,,\"order\",$A7#,U$6,$A$3)","RTD($A$1,,\"order\",$A7#,V$6,$A$3)","RTD($A$1,,\"order\",$A7#,W$6,$A$3)","RTD($A$1,,\"order\",$A7#,X$6,$A$3)","RTD($A$1,,\"order\",$A7#,Y$6,$A$3)","RTD($A$1,,\"order\",$A7#,Z$6,$A$3)","RTD($A$1,,\"order\",$A7#,AA$6,$A$3)","RTD($A$1,,\"order\",$A7#,AB$6,$A$3)","RTD($A$1,,\"order\",$A7#,AC$6,$A$3)","RTD($A$1,,\"order\",$A7#,AD$6,$A$3)","RTD($A$1,,\"order\",$A7#,AE$6,$A$3)","RTD($A$1,,\"order\",$A7#,AF$6,$A$3)","RTD($A$1,,\"order\",$A7#,AG$6,$A$3)","RTD($A$1,,\"order\",$A7#,AH$6,$A$3)","RTD($A$1,,\"order\",$A7#,AI$6,$A$3)"]

{"sheet":"MarketData","index":4,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["tws.rtd",null,null,null,"UTC Offset",null,null,null," RTD Computed Field "," Description "," Computation "]
["B5:B83",null,null,null,-7,null,null,null,"MarketPrice"," Current market price "," LAST if available, else MID((BID+ASK)/2), else CLOSE "]
[null,"Symbol","Exchange","Prim Exch","Currency",null,null,null,"LastOrClose"," Last traded or close "," LAST if available, else CLOSE "]
["RTD Field","SPY",null,null,null,null,null,null,"MarketDataType"," Actual MarketDataType supplied"]
["LASTTIME","RTD($A$1,,B$4,$A5,IF(ISTEXT(C4),\"exch=\"&C4))/86400+25569+E2/24"]
["MarketDataType","RTD($A$1,,B$4,$A6,IF(ISTEXT($C$4),\"exch=\"&$C$4),IF(ISTEXT($D$4),\"prim=\"&$D$4),IF(ISTEXT($E$4),\"cur=\"&$E$4),$A$3)"]
["MarketPrice","RTD($A$1,,B$4,$A7,IF(ISTEXT($C$4),\"exch=\"&$C$4),IF(ISTEXT($D$4),\"prim=\"&$D$4),IF(ISTEXT($E$4),\"cur=\"&$E$4),$A$3)",null,null,null,null," Tick ID "," IB Name "," RTD Field "," Description "]
[{"$f":"I8:I83","v":"BIDSIZE"},"RTD($A$1,,B$4,$A8#,IF(ISTEXT($C$4),\"exch=\"&$C$4),IF(ISTEXT($D$4),\"prim=\"&$D$4),IF(ISTEXT($E$4),\"cur=\"&$E$4),$A$3)",null,null,null,null,0," BID_SIZE ","BIDSIZE"," Size at best bid "]
["BID",null,null,null,null,null,1," BID ","BID"," Best bid price "]
["ASK",null,null,null,null,null,2," ASK ","ASK"," Best ask price "]
["ASKSIZE",null,null,null,null,null,3," ASK_SIZE ","ASKSIZE"," Size at best ask "]
["LAST",null,null,null,null,null,4," LAST ","LAST"," Last trade price "]
["LASTSIZE",null,null,null,null,null,5," LAST_SIZE ","LASTSIZE"," Last trade size "]
["HIGH",null,null,null,null,null,6," HIGH ","HIGH"," Session high "]
["LOW",null,null,null,null,null,7," LOW ","LOW"," Session low "]
["VOLUME",null,null,null,null,null,8," VOLUME ","VOLUME"," Total volume "]
["CLOSE",null,null,null,null,null,9," CLOSE ","CLOSE"," Previous session close "]
["BIDOPTIONCOMPUTATION",null,null,null,null,null,10," BID_OPTION_COMPUTATION ","BIDOPTIONCOMPUTATION"," Greeks at bid price "]
["ASKOPTIONCOMPUTATION",null,null,null,null,null,11," ASK_OPTION_COMPUTATION ","ASKOPTIONCOMPUTATION"," Greeks at ask price "]
["LASTOPTIONCOMPUTATION",null,null,null,null,null,12," LAST_OPTION_COMPUTATION ","LASTOPTIONCOMPUTATION"," Greeks at last price "]
["MODEL_OPTION_COMPUTATION",null,null,null,null,null,13," MODEL_OPTION ","MODEL_OPTION_COMPUTATION"," Model-computed Greeks "]
["OPEN",null,null,null,null,null,14," OPEN ","OPEN"," Session open price "]
["WEEK13LO",null,null,null,null,null,15," LOW_13_WEEK ","WEEK13LO"," 13-week low "]
["WEEK13HI",null,null,null,null,null,16," HIGH_13_WEEK ","WEEK13HI"," 13-week high "]
["WEEK26LO",null,null,null,null,null,17," LOW_26_WEEK ","WEEK26LO"," 26-week low "]
["WEEK26HI",null,null,null,null,null,18," HIGH_26_WEEK ","WEEK26HI"," 26-week high "]
["WEEK52LO",null,null,null,null,null,19," LOW_52_WEEK ","WEEK52LO"," 52-week low "]
["WEEK52HI",null,null,null,null,null,20," HIGH_52_WEEK ","WEEK52HI"," 52-week high "]
["AVGVOLUME",null,null,null,null,null,21," AVG_VOLUME ","AVGVOLUME"," Average daily volume "]
["OPTIONHISTORICALVOL",null,null,null,null,null,23," OPTION_HISTORICAL_VOL ","OPTIONHISTORICALVOL"," Historical volatility (104) "]
["OPTIONIMPLIEDVOL",null,null,null,null,null,24," OPTION_IMPLIED_VOL ","OPTIONIMPLIEDVOL"," Implied volatility (106) "]
["CALLOPTIONOPENINTEREST",null,null,null,null,null,27," OPTION_CALL_OPEN_INTEREST ","CALLOPTIONOPENINTEREST"," Call option OI "]
["PUTOPTIONOPENINTEREST",null,null,null,null,null,28," OPTION_PUT_OPEN_INTEREST ","PUTOPTIONOPENINTEREST"," Put option OI "]
["CALLOPTIONVOLUME",null,null,null,null,null,29," OPTION_CALL_VOLUME ","CALLOPTIONVOLUME"," Call option volume "]
["PUTOPTIONVOLUME",null,null,null,null,null,30," OPTION_PUT_VOLUME ","PUTOPTIONVOLUME"," Put option volume "]
["INDEXFUTUREPREMIUM",null,null,null,null,null,31," INDEX_FUTURE_PREMIUM ","INDEXFUTUREPREMIUM"," Index future premium (162, IND) "]
["BIDEXCH",null,null,null,null,null,32," BID_EXCH ","BIDEXCH"," Exchange(s) posting best bid "]
["ASKEXCH",null,null,null,null,null,33," ASK_EXCH ","ASKEXCH"," Exchange(s) posting best ask "]
["AUCTIONVOLUME",null,null,null,null,null,34," AUCTION_VOLUME ","AUCTIONVOLUME"," Auction volume "]
["AUCTIONPRICE",null,null,null,null,null,35," AUCTION_PRICE ","AUCTIONPRICE"," Auction price "]
["AUCTIONIMBALANCE",null,null,null,null,null,36," AUCTION_IMBALANCE ","AUCTIONIMBALANCE"," Auction imbalance "]
["PLPRICE",null,null,null,null,null,37," MARK_PRICE ","PLPRICE"," P&L mark price (232) "]
["LASTTIME",null,null,null,null,null,45," LAST_TIMESTAMP ","LASTTIME"," Timestamp of last trade "]
["SHORTABLE",null,null,null,null,null,46," SHORTABLE ","SHORTABLE"," Shortability indicator (>2.5 = easy) "]
["FUNDAMENTALS",null,null,null,null,null,47," FUNDAMENTAL_RATIOS ","FUNDAMENTALS"," Fundamental ratios (258) "]
["HALTED",null,null,null,null,null,49," HALTED ","HALTED"," Trading halt indicator (0=not halted) "]
["TRADECOUNT",null,null,null,null,null,54," TRADE_COUNT ","TRADECOUNT"," Trade count (293) "]
["TRADERATE",null,null,null,null,null,55," TRADE_RATE ","TRADERATE"," Trades per minute (294) "]
["VOLUMERATE",null,null,null,null,null,56," VOLUME_RATE ","VOLUMERATE"," Volume per minute (295) "]
["LASTRTHTRADE",null,null,null,null,null,57," LAST_RTH_TRADE ","LASTRTHTRADE"," Last regular hours trade (318) "]
["RTHISTORICALVOL",null,null,null,null,null,58," RT_HISTORICAL_VOL ","RTHISTORICALVOL"," Real-time historical vol (411) "]
["IBDIVIDENDS",null,null,null,null,null,59," IB_DIVIDENDS ","IBDIVIDENDS"," Dividend info (456) "]
["BONDMULTIPLIER",null,null,null,null,null,60," BOND_FACTOR_MULTIPLIER ","BONDMULTIPLIER"," Bond factor (460) "]
["REGULATORYIMBALANCE",null,null,null,null,null,61," REGULATORY_IMBALANCE ","REGULATORYIMBALANCE"," Regulatory imbalance "]
["SHORTTERMVOLUME3MIN",null,null,null,null,null,63," SHORT_TERM_VOLUME_3_MIN ","SHORTTERMVOLUME3MIN"," 3-minute volume "]
["SHORTTERMVOLUME5MIN",null,null,null,null,null,64," SHORT_TERM_VOLUME_5_MIN ","SHORTTERMVOLUME5MIN"," 5-minute volume "]
["SHORTTERMVOLUME10MIN",null,null,null,null,null,65," SHORT_TERM_VOLUME_10_MIN ","SHORTTERMVOLUME10MIN"," 10-minute volume "]
["DELAYEDBID",null,null,null,null,null,66," DELAYED_BID ","DELAYEDBID"," BID (1) "]
["DELAYEDASK",null,null,null,null,null,67," DELAYED_ASK ","DELAYEDASK"," ASK (2) "]
["DELAYEDLAST",null,null,null,null,null,68," DELAYED_LAST ","DELAYEDLAST"," LAST (4) "]
["DELAYEDBIDSIZE",null,null,null,null,null,69," DELAYED_BID_SIZE ","DELAYEDBIDSIZE"," BIDSIZE (0) "]
["DELAYEDASKSIZE",null,null,null,null,null,70," DELAYED_ASK_SIZE ","DELAYEDASKSIZE"," ASKSIZE (3) "]
["DELAYEDLASTSIZE",null,null,null,null,null,71," DELAYED_LAST_SIZE ","DELAYEDLASTSIZE"," LASTSIZE (5) "]
["DELAYEDHIGH",null,null,null,null,null,72," DELAYED_HIGH ","DELAYEDHIGH"," HIGH (6) "]
["DELAYEDLOW",null,null,null,null,null,73," DELAYED_LOW ","DELAYEDLOW"," LOW (7) "]
["DELAYEDVOLUME",null,null,null,null,null,74," DELAYED_VOLUME ","DELAYEDVOLUME"," VOLUME (8) "]
["DELAYEDCLOSE",null,null,null,null,null,75," DELAYED_CLOSE ","DELAYEDCLOSE"," CLOSE (9) "]
["DELAYEDOPEN",null,null,null,null,null,76," DELAYED_OPEN ","DELAYEDOPEN"," OPEN (14) "]
["CREDITMANMARKPRICE",null,null,null,null,null,78," CREDITMAN_MARK_PRICE ","CREDITMANMARKPRICE"," Credit mark price (221) "]
["CREDITMANSLOWMARKPRICE",null,null,null,null,null,79," CREDITMAN_SLOW_MARK_PRICE ","CREDITMANSLOWMARKPRICE"," Slow credit mark (619) "]
["LASTEXCH",null,null,null,null,null,84," LAST_EXCH ","LASTEXCH"," Exchange of last trade "]
["FUTURESOPENINTEREST",null,null,null,null,null,86," FUTURES_OPEN_INTEREST ","FUTURESOPENINTEREST"," Futures OI (588) "]
["AVGOPTVOLUME",null,null,null,null,null,87," AVG_OPT_VOLUME ","AVGOPTVOLUME"," Average option volume (STK) "]
["DELAYEDLASTTIMESTAMP",null,null,null,null,null,88," DELAYED_LAST_TIMESTAMP ","DELAYEDLASTTIMESTAMP"," LASTTIME (45) "]
["SHORTABLESHARES",null,null,null,null,null,89," SHORTABLE_SHARES ","SHORTABLESHARES"," Shares available to short "]
["DELAYEDHALTED",null,null,null,null,null,90," DELAYED_HALTED ","DELAYEDHALTED"," HALTED (49) "]
["ETFNAVLAST",null,null,null,null,null,96," ETF_NAV_LAST ","ETFNAVLAST"," ETF NAV last (577) "]
["ETFFROZENNAVLAST",null,null,null,null,null,97," ETF_FROZEN_NAV_LAST ","ETFFROZENNAVLAST"," Frozen ETF NAV (623) "]
["ETFNAVHIGH",null,null,null,null,null,98," ETF_NAV_HIGH ","ETFNAVHIGH"," ETF NAV high (614) "]
["ETFNAVLOW",null,null,null,null,null,99," ETF_NAV_LOW ","ETFNAVLOW"," ETF NAV low (614) "]
["SOCIALMARKETANALYTICS",null,null,null,null,null,100," SOCIAL_MARKET_ANALYTICS ","SOCIALMARKETANALYTICS"," Social sentiment "]
["ESTIMATEDIPOMIDPOINT",null,null,null,null,null,101," ESTIMATED_IPO_MIDPOINT ","ESTIMATEDIPOMIDPOINT"," Estimated IPO midpoint "]
["FINALIPOLAST",null,null,null,null,null,102," FINAL_IPO_LAST ","FINALIPOLAST"," Final IPO price "]

{"sheet":"SendOrder","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["tws.rtd",null,"Orders are sent to TWS with Transmit=False.  They will appear in the TWS Orders list but not sent to market unless transmitted from there."]
[null,null,null,"Orders Sent to TWS"]
[null,"<< Custom connection string"]
[]
["Symbol","SPY"]
["Side","BUY"]
["Shares",5]
["Limit",600]
["Account"]

{"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 20260515 Calls"},null,null,null,null,null,null,"RTD(\"tws.rtd\",,A5,\"MarketPrice\")",{"$f":"A5&\" \"&A6&\" Puts\"","v":"SPY 20260515 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,\"Delta\"),\"\")"]
[20,"<< # Strikes"]
["SPY","<< Underlying"]
["20260515","<< Expiration"]
["Available Expirations"]
["TEXTSPLIT(RTD(\"tws.rtd\",,A5,\"OptionExpirationsCSV\"),,\",\")"]