{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Market Data","Place Orders","Get Orders","Get Fills","Get Fills By ","Get Worksheet Orders","Status"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":59,"comments":0,"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":"Market Data","index":0,"n_rows":10,"n_cols":35,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BidPrice","BidQuantity","OfferPrice","OfferQuantity","LastTradePrice"]
["1|G|XNYM:F:CL:202109",{"$f":"_xll.CMED.MD($A3,B$2)","v":""},{"$f":"_xll.CMED.MD($A3,C$2)","v":""},{"$f":"_xll.CMED.MD($A3,D$2)","v":""},{"$f":"_xll.CMED.MD($A3,E$2)","v":""},{"$f":"_xll.CMED.MD($A3,F$2)","v":""}]
["1|G|XNYM:F:CL:202110",{"$f":"_xll.CMED.MD($A4,B$2)","v":""},{"$f":"_xll.CMED.MD($A4,C$2)","v":""},{"$f":"_xll.CMED.MD($A4,D$2)","v":""},{"$f":"_xll.CMED.MD($A4,E$2)","v":""},{"$f":"_xll.CMED.MD($A4,F$2)","v":0.04}]
["1|G|XNYM:F:CL:202111",{"$f":"_xll.CMED.MD($A5,B$2)","v":""},{"$f":"_xll.CMED.MD($A5,C$2)","v":""},{"$f":"_xll.CMED.MD($A5,D$2)","v":""},{"$f":"_xll.CMED.MD($A5,E$2)","v":""},{"$f":"_xll.CMED.MD($A5,F$2)","v":""}]
[]
[]
[]
[null,null,null,null,"Market data",null,null,null,null,null,null,null,null,null,null,null,null,"Statistics"]
[null,"Contract Code","Error Code","Error Message","Contract Code","Prices depth Bid","Prices depth Ask","Bid Price - depth1 (getFullDepth)","Bid Qty - depth1 (getFullDepth)","Ask Price - depth1 (getFullDepth)","Ask Qty - depth1 (getFullDepth)","Bid Price - depth1","Bid Qty - depth1","Ask Price - depth1","Ask Qty - depth1","Remove","Stale","Change","ClearedVolume","SubscriptionLevel","HighestBid","HighestTradePrice","IndicativeOpeningPrice","IndicativeOpeningPrice","LastTradeDateTime","LastTradeDirection","LastTradePrice","LastTradeQuantity","LowestOffer","LowestTradePrice","OpenInterest","OpenTradePrice","SettlementPrice","CurrentSessionSettlementPrice","TradeVolume"]

{"sheet":"Place Orders","index":1,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Order Token","UserSuppliedToken-1"]
[null,null,null,"Account","CMETEST1"]
["Buy","Fill Kill Remainder",null,"CMED Code","1|G|XNYM:F:CL:202109"]
["Sell","Good Till Cancelled",null,"Side","Buy"]
[null,"Fill Or Kill",null,"Price",30]
[null,"Good For Day",null,"Quantity",50]
[null,"Good Till Date",null,"Order Type","Limit"]
[null,null,null,"Disclosed Quantity"]
[null,null,null,"Stop Price"]
[null,null,null,"Time in Force","Good Till Cancelled"]
[null,null,null,"Time In Force Date"]
[null,null,null,"Active",true]
[null,null,null,"Good After Logout",true]
[null,"Limit",null,"Manual",true]
[null,"Market"]
[null,"Market Limit"]
[null,"Stop",null,"Order ID","State","Order Date","Slot","Token","Account","Contract Code","Side","Price","Total Quantity","Filled Quantity","Disclosed Quantity","Average Trade Price","Owner","Ownership","Source","Hon","Ton","Last filled Time","Order Version","Trader"]

{"sheet":"Get Orders","index":2,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Order Id"]
[]
[null,null,"Order ID","Order Date","Slot","Token","Account","Contract Code","Side","Price","Total Quantity","Filled Quantity","Disclosed Quantity","Average Trade Price","Owner","Ownership","Source","State","Hon","Ton","Last filled Time","Order Version","Trader"]
[]
[]
[]
[null,null,"Token","UserSuppliedToken-1"]
[]
[null,null,"Order ID","Order Date","Slot","Token","Account","Contract Code","Side","Price","Total Quantity","Filled Quantity","Disclosed Quantity","Average Trade Price","Owner","Ownership","Source","State","Hon","Ton","Last filled Time","Order Version","Trader"]
[]
[]
[]
["Mine",null,"Ownership","Mine"]
["My Company",null,"Source","Trading Client"]
[]
["All",null,"Order ID","Order Date","Slot","Token","Account","Contract Code","Side","Price","Total Quantity","Filled Quantity","Disclosed Quantity","Average Trade Price","Owner","Ownership","Source","State","Hon","Ton","Last filled Time","Order Version","Trader"]
["VBA"]
["Worksheet"]
["Trading Client"]
["Agency Crossing"]
["RFC Crossing"]

{"sheet":"Get Fills","index":3,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Mine",null,"Ownership","My Company"]
["My Company",null,"Source","All"]
[]
["All",null,"ContractCode","Side","Slot","Source","Token","OrderId","OrderSide","OrderContractCode","OrderOwner","OrderOwnership","Price","FilledQuantity","IsLeg","IsStrategy","FillId","FillVersion"]
["VBA"]
["Trading Client"]
["Agency Crossing"]
["RFC Crossing"]
["Worksheet"]

{"sheet":"Get Fills By ","index":4,"n_rows":5,"n_cols":19,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Fill Id",null,"Filtered By","Order Id"]
["Token (VBA only)",null,"Id",1234]
["Order Id"]
[null,null,"ContractCode","Side","Slot","Source","Token","OrderId","OrderSide","OrderContractCode","OrderOwner","OrderOwnership","Price","FilledQuantity","TradeDate","IsLeg","IsStrategy","FillId","FillVersion"]

{"sheet":"Get Worksheet Orders","index":5,"n_rows":8,"n_cols":23,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Bid"]
["Offer",null,"Contract Code","1|G|XNYM:F:CL:202108"]
[null,null,"Side","Bid"]
["Mine",null,"Slot",1]
["My Company",null,"Ownership","Mine"]
[]
[]
[null,null,"Order ID","Order Date","Slot","Token","Account","Contract Code","Side","Price","Total Quantity","Filled Quantity","Disclosed Quantity","Average Trade Price","Owner","Ownership","Source","State","Hon","Ton","Last filled Time","Order Version","Trader"]

{"sheet":"Status","index":6,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Excel API Status"]
[null,"IsConnected",true]
[null,"IsOrderEntry Enabled",false]