{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BaseAlgo"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"comments":1,"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":"BaseAlgo","index":0,"n_rows":68,"n_cols":21,"rows_kept":68,"cut":false,"hidden":false,"merged":[[25,11,25,12],[16,2,16,9],[24,11,24,16],[4,11,4,12],[1,2,1,16],[3,2,3,9],[3,11,3,12],[25,15,25,16]]}
[]
[null,null,"RUTC 2018 XAIC Algorithmic ETF Trading Case - Base Algorithm"]
[]
[null,null,"Market Info",null,null,null,null,null,null,null,null,"Strategy Calculations",null,null,null,null,"Parameters"]
[null,null,"Ticker","Position","Last","Bid Size","Bid","Ask","Ask Size","Volume",null,"Tender Order info"]
[null,null,"CAD",{"$f":"RTD(\"rit2.rtd\",,$C6,\"POSITION\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C6,\"LAST\")","v":0},null,{"$f":"RTD(\"rit2.rtd\",,$C6,\"BID\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C6,\"ASK\")","v":0},null,{"$f":"RTD(\"rit2.rtd\",,$C6,\"VOLUME\")","v":0},null,"Tender RTD link",{"$f":"RTD(\"rit2.rtd\",,\"TENDERINFO\",1)","v":""},null,null,null,"Market order comission"]
[null,null,"USD",{"$f":"RTD(\"rit2.rtd\",,$C7,\"POSITION\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C7,\"LAST\")","v":0},null,{"$f":"RTD(\"rit2.rtd\",,$C7,\"BID\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C7,\"ASK\")","v":0},null,{"$f":"RTD(\"rit2.rtd\",,$C7,\"VOLUME\")","v":0},null,"Tender ID",{"$f":"VALUE(N7)","v":{"$error":"#VALUE!"}},{"$f":"TRANSPOSE(parsertd($M$6))","v":""},null,null,0.02]
[null,null,"BULL",{"$f":"VALUE(RTD(\"rit2.rtd\",,$C8,\"POSITION\"))","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"LAST\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"BSZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"BID\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"ASK\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"ASZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C8,\"VOLUME\")","v":0},null,"Ticker",{"$f":"N8","v":""},""]
[null,null,"BEAR",{"$f":"VALUE(RTD(\"rit2.rtd\",,$C9,\"POSITION\"))","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"LAST\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"BSZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"BID\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"ASK\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"ASZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C9,\"VOLUME\")","v":0},null,"Volume",{"$f":"VALUE(N9)","v":{"$error":"#VALUE!"}},"",null,null,"Desired premium for tender"]
[null,null,"RUTC",{"$f":"VALUE(RTD(\"rit2.rtd\",,$C10,\"POSITION\"))","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"LAST\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"BSZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"BID\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"ASK\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"ASZ\")","v":0},{"$f":"RTD(\"rit2.rtd\",,$C10,\"VOLUME\")","v":0},null,"Price",{"$f":"VALUE(N10)","v":{"$error":"#VALUE!"}},"",null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,"Start tick",{"$f":"VALUE(N11)","v":{"$error":"#VALUE!"}},""]
[null,null,"Time Remaining",null,{"$f":"RTD(\"rit2.rtd\",,\"timeremaining\")","v":300},null,null,null,null,null,null,"End tick",{"$f":"VALUE(N12)","v":{"$error":"#VALUE!"}},"",null,null,"Desired premium for ETF arb"]
[null,null,{"$f":"\"# of limit orders for \"&C8","v":"# of limit orders for BULL"},null,{"$f":"RTD(\"rit2.rtd\",,$C$8,\"LIMITORDERS\")","v":0},null,null,null,null,null,null,"Signal",{"$f":"IF(M9>0,IF((M10+Q7+Q10)<INDEX(C19:D68,MATCH(M9,$D$19:$D$68,1)+1,1),1,0),IF(M9<0,IF((M10-Q7-Q10)<INDEX(I19:J68,MATCH(ABS(M9),$I$19:$I$68,1)+1,1),1,0)))","v":{"$error":"#VALUE!"}},null,null,null,0.2]
[null,null,{"$f":"\"# of limit orders for \"&C9","v":"# of limit orders for BEAR"},null,{"$f":"RTD(\"rit2.rtd\",,$C$9,\"LIMITORDERS\")","v":0}]
[null,null,{"$f":"\"# of limit orders for \"&C10","v":"# of limit orders for RUTC"},null,{"$f":"RTD(\"rit2.rtd\",,$C$10,\"LIMITORDERS\")","v":0},null,null,null,null,null,null,"ETF arbitrage",null,null,null,null,"RUTC trade size (ETF arb)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Potential Profit",null,"Signal",null,5000]
[null,null,"Order Book info for RUTC",null,null,null,null,null,null,null,null,"Sell RUTC and Buy BULL + BEAR",{"$f":"$G$10*$E$7-SUM($H$8:$H$9)-Q7*2-Q7*$E$7","v":-0.04},null,{"$f":"IF(M17>Q13,1,0)","v":0}]
[null,null,"BidVWAP","Cum Bid Vol","Bid Volume","Bid Price","Ask Price","Ask Volume","Cum Ask Vol","AskVWAP",null,"Buy RUTC and Sell BULL + BEAR",{"$f":"$H$10*$E$7-SUM($G$8:$G$9)-Q7*2-Q7*$E$7","v":-0.04},null,{"$f":"IF(M18>Q13,1,0)","v":0},null,"Tender order size"]
[1,{"$f":"D19","v":0},{"$f":"SUMPRODUCT(F19:$F$19,E19:$E$19)/D19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E19:$E$19)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A19)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A19)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A19)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A19)","v":0},{"$f":"SUM(H19:$H$19)","v":0},{"$f":"SUMPRODUCT(G19:$G$19,H19:$H$19)/I19","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,5000]
[2,0,{"$f":"SUMPRODUCT(F$19:$F20,E$19:$E20)/D20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E20)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A20)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A20)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A20)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A20)","v":0},{"$f":"SUM(H$19:$H20)","v":0},{"$f":"SUMPRODUCT(G$19:$G20,H$19:$H20)/I20","v":{"$error":"#DIV/0!"}}]
[3,0,{"$f":"SUMPRODUCT(F$19:$F21,E$19:$E21)/D21","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E21)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A21)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A21)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A21)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A21)","v":0},{"$f":"SUM(H$19:$H21)","v":0},{"$f":"SUMPRODUCT(G$19:$G21,H$19:$H21)/I21","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Order delay"]
[4,0,{"$f":"SUMPRODUCT(F$19:$F22,E$19:$E22)/D22","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E22)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A22)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A22)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A22)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A22)","v":0},{"$f":"SUM(H$19:$H22)","v":0},{"$f":"SUMPRODUCT(G$19:$G22,H$19:$H22)/I22","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,1]
[5,0,{"$f":"SUMPRODUCT(F$19:$F23,E$19:$E23)/D23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E23)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A23)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A23)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A23)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A23)","v":0},{"$f":"SUM(H$19:$H23)","v":0},{"$f":"SUMPRODUCT(G$19:$G23,H$19:$H23)/I23","v":{"$error":"#DIV/0!"}}]
[6,0,{"$f":"SUMPRODUCT(F$19:$F24,E$19:$E24)/D24","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E24)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A24)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A24)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A24)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A24)","v":0},{"$f":"SUM(H$19:$H24)","v":0},{"$f":"SUMPRODUCT(G$19:$G24,H$19:$H24)/I24","v":{"$error":"#DIV/0!"}}]
[7,0,{"$f":"SUMPRODUCT(F$19:$F25,E$19:$E25)/D25","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E25)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A25)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A25)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A25)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A25)","v":0},{"$f":"SUM(H$19:$H25)","v":0},{"$f":"SUMPRODUCT(G$19:$G25,H$19:$H25)/I25","v":{"$error":"#DIV/0!"}},null,"Control Panel"]
[8,0,{"$f":"SUMPRODUCT(F$19:$F26,E$19:$E26)/D26","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E26)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A26)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A26)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A26)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A26)","v":0},{"$f":"SUM(H$19:$H26)","v":0},{"$f":"SUMPRODUCT(G$19:$G26,H$19:$H26)/I26","v":{"$error":"#DIV/0!"}},null,"Tender offers",null,null,null,"ETF arbitrage",null,null,null,null,"ON"]
[9,0,{"$f":"SUMPRODUCT(F$19:$F27,E$19:$E27)/D27","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E27)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A27)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A27)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A27)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A27)","v":0},{"$f":"SUM(H$19:$H27)","v":0},{"$f":"SUMPRODUCT(G$19:$G27,H$19:$H27)/I27","v":{"$error":"#DIV/0!"}},null,"Auto Accept Tender",{"$f":"IF($M$28=\"ON\",tenderaccept($M$8,$E$12),\"Not Running\")","v":"Not Running"},null,null,"Status",{"$f":"IF(Q28=\"ON\",arb($E$12),\"Not Running\")","v":"Not Running"},null,null,null,"OFF"]
[10,0,{"$f":"SUMPRODUCT(F$19:$F28,E$19:$E28)/D28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E28)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A28)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A28)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A28)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A28)","v":0},{"$f":"SUM(H$19:$H28)","v":0},{"$f":"SUMPRODUCT(G$19:$G28,H$19:$H28)/I28","v":{"$error":"#DIV/0!"}},null,"Switch","OFF",null,null,"Switch","OFF"]
[11,0,{"$f":"SUMPRODUCT(F$19:$F29,E$19:$E29)/D29","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E29)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A29)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A29)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A29)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A29)","v":0},{"$f":"SUM(H$19:$H29)","v":0},{"$f":"SUMPRODUCT(G$19:$G29,H$19:$H29)/I29","v":{"$error":"#DIV/0!"}}]
[12,0,{"$f":"SUMPRODUCT(F$19:$F30,E$19:$E30)/D30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E30)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A30)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A30)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A30)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A30)","v":0},{"$f":"SUM(H$19:$H30)","v":0},{"$f":"SUMPRODUCT(G$19:$G30,H$19:$H30)/I30","v":{"$error":"#DIV/0!"}},null,"Auto Position Close out",{"$f":"IF(M32=\"ON\",position_closeout($M$31,$E$12),\"Not Running\")","v":"Not Running"}]
[13,0,{"$f":"SUMPRODUCT(F$19:$F31,E$19:$E31)/D31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E31)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A31)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A31)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A31)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A31)","v":0},{"$f":"SUM(H$19:$H31)","v":0},{"$f":"SUMPRODUCT(G$19:$G31,H$19:$H31)/I31","v":{"$error":"#DIV/0!"}},null,"Ticker","RUTC"]
[14,0,{"$f":"SUMPRODUCT(F$19:$F32,E$19:$E32)/D32","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E32)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A32)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A32)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A32)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A32)","v":0},{"$f":"SUM(H$19:$H32)","v":0},{"$f":"SUMPRODUCT(G$19:$G32,H$19:$H32)/I32","v":{"$error":"#DIV/0!"}},null,"Switch","OFF"]
[15,0,{"$f":"SUMPRODUCT(F$19:$F33,E$19:$E33)/D33","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E33)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A33)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A33)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A33)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A33)","v":0},{"$f":"SUM(H$19:$H33)","v":0},{"$f":"SUMPRODUCT(G$19:$G33,H$19:$H33)/I33","v":{"$error":"#DIV/0!"}}]
[16,0,{"$f":"SUMPRODUCT(F$19:$F34,E$19:$E34)/D34","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E34)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A34)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A34)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A34)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A34)","v":0},{"$f":"SUM(H$19:$H34)","v":0},{"$f":"SUMPRODUCT(G$19:$G34,H$19:$H34)/I34","v":{"$error":"#DIV/0!"}}]
[17,0,{"$f":"SUMPRODUCT(F$19:$F35,E$19:$E35)/D35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E35)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A35)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A35)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A35)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A35)","v":0},{"$f":"SUM(H$19:$H35)","v":0},{"$f":"SUMPRODUCT(G$19:$G35,H$19:$H35)/I35","v":{"$error":"#DIV/0!"}}]
[18,0,{"$f":"SUMPRODUCT(F$19:$F36,E$19:$E36)/D36","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E36)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A36)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A36)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A36)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A36)","v":0},{"$f":"SUM(H$19:$H36)","v":0},{"$f":"SUMPRODUCT(G$19:$G36,H$19:$H36)/I36","v":{"$error":"#DIV/0!"}}]
[19,0,{"$f":"SUMPRODUCT(F$19:$F37,E$19:$E37)/D37","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E37)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A37)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A37)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A37)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A37)","v":0},{"$f":"SUM(H$19:$H37)","v":0},{"$f":"SUMPRODUCT(G$19:$G37,H$19:$H37)/I37","v":{"$error":"#DIV/0!"}}]
[20,0,{"$f":"SUMPRODUCT(F$19:$F38,E$19:$E38)/D38","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E38)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A38)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A38)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A38)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A38)","v":0},{"$f":"SUM(H$19:$H38)","v":0},{"$f":"SUMPRODUCT(G$19:$G38,H$19:$H38)/I38","v":{"$error":"#DIV/0!"}}]
[21,0,{"$f":"SUMPRODUCT(F$19:$F39,E$19:$E39)/D39","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E39)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A39)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A39)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A39)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A39)","v":0},{"$f":"SUM(H$19:$H39)","v":0},{"$f":"SUMPRODUCT(G$19:$G39,H$19:$H39)/I39","v":{"$error":"#DIV/0!"}}]
[22,0,{"$f":"SUMPRODUCT(F$19:$F40,E$19:$E40)/D40","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E40)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A40)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A40)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A40)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A40)","v":0},{"$f":"SUM(H$19:$H40)","v":0},{"$f":"SUMPRODUCT(G$19:$G40,H$19:$H40)/I40","v":{"$error":"#DIV/0!"}}]
[23,0,{"$f":"SUMPRODUCT(F$19:$F41,E$19:$E41)/D41","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E41)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A41)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A41)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A41)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A41)","v":0},{"$f":"SUM(H$19:$H41)","v":0},{"$f":"SUMPRODUCT(G$19:$G41,H$19:$H41)/I41","v":{"$error":"#DIV/0!"}}]
[24,0,{"$f":"SUMPRODUCT(F$19:$F42,E$19:$E42)/D42","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E42)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A42)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A42)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A42)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A42)","v":0},{"$f":"SUM(H$19:$H42)","v":0},{"$f":"SUMPRODUCT(G$19:$G42,H$19:$H42)/I42","v":{"$error":"#DIV/0!"}}]
[25,0,{"$f":"SUMPRODUCT(F$19:$F43,E$19:$E43)/D43","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E43)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A43)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A43)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A43)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A43)","v":0},{"$f":"SUM(H$19:$H43)","v":0},{"$f":"SUMPRODUCT(G$19:$G43,H$19:$H43)/I43","v":{"$error":"#DIV/0!"}}]
[26,0,{"$f":"SUMPRODUCT(F$19:$F44,E$19:$E44)/D44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E44)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A44)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A44)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A44)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A44)","v":0},{"$f":"SUM(H$19:$H44)","v":0},{"$f":"SUMPRODUCT(G$19:$G44,H$19:$H44)/I44","v":{"$error":"#DIV/0!"}}]
[27,0,{"$f":"SUMPRODUCT(F$19:$F45,E$19:$E45)/D45","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E45)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A45)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A45)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A45)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A45)","v":0},{"$f":"SUM(H$19:$H45)","v":0},{"$f":"SUMPRODUCT(G$19:$G45,H$19:$H45)/I45","v":{"$error":"#DIV/0!"}}]
[28,0,{"$f":"SUMPRODUCT(F$19:$F46,E$19:$E46)/D46","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E46)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A46)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A46)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A46)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A46)","v":0},{"$f":"SUM(H$19:$H46)","v":0},{"$f":"SUMPRODUCT(G$19:$G46,H$19:$H46)/I46","v":{"$error":"#DIV/0!"}}]
[29,0,{"$f":"SUMPRODUCT(F$19:$F47,E$19:$E47)/D47","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E47)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A47)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A47)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A47)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A47)","v":0},{"$f":"SUM(H$19:$H47)","v":0},{"$f":"SUMPRODUCT(G$19:$G47,H$19:$H47)/I47","v":{"$error":"#DIV/0!"}}]
[30,0,{"$f":"SUMPRODUCT(F$19:$F48,E$19:$E48)/D48","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E48)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A48)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A48)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A48)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A48)","v":0},{"$f":"SUM(H$19:$H48)","v":0},{"$f":"SUMPRODUCT(G$19:$G48,H$19:$H48)/I48","v":{"$error":"#DIV/0!"}}]
[31,0,{"$f":"SUMPRODUCT(F$19:$F49,E$19:$E49)/D49","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E49)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A49)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A49)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A49)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A49)","v":0},{"$f":"SUM(H$19:$H49)","v":0},{"$f":"SUMPRODUCT(G$19:$G49,H$19:$H49)/I49","v":{"$error":"#DIV/0!"}}]
[32,0,{"$f":"SUMPRODUCT(F$19:$F50,E$19:$E50)/D50","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E50)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A50)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A50)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A50)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A50)","v":0},{"$f":"SUM(H$19:$H50)","v":0},{"$f":"SUMPRODUCT(G$19:$G50,H$19:$H50)/I50","v":{"$error":"#DIV/0!"}}]
[33,{"$f":"D51","v":0},{"$f":"SUMPRODUCT(F$19:$F51,E$19:$E51)/D51","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E51)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A51)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A51)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A51)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A51)","v":0},{"$f":"SUM(H$19:$H51)","v":0},{"$f":"SUMPRODUCT(G$19:$G51,H$19:$H51)/I51","v":{"$error":"#DIV/0!"}}]
[34,0,{"$f":"SUMPRODUCT(F$19:$F52,E$19:$E52)/D52","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E52)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A52)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A52)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A52)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A52)","v":0},{"$f":"SUM(H$19:$H52)","v":0},{"$f":"SUMPRODUCT(G$19:$G52,H$19:$H52)/I52","v":{"$error":"#DIV/0!"}}]
[35,0,{"$f":"SUMPRODUCT(F$19:$F53,E$19:$E53)/D53","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E53)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A53)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A53)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A53)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A53)","v":0},{"$f":"SUM(H$19:$H53)","v":0},{"$f":"SUMPRODUCT(G$19:$G53,H$19:$H53)/I53","v":{"$error":"#DIV/0!"}}]
[36,0,{"$f":"SUMPRODUCT(F$19:$F54,E$19:$E54)/D54","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E54)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A54)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A54)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A54)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A54)","v":0},{"$f":"SUM(H$19:$H54)","v":0},{"$f":"SUMPRODUCT(G$19:$G54,H$19:$H54)/I54","v":{"$error":"#DIV/0!"}}]
[37,0,{"$f":"SUMPRODUCT(F$19:$F55,E$19:$E55)/D55","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E55)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A55)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A55)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A55)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A55)","v":0},{"$f":"SUM(H$19:$H55)","v":0},{"$f":"SUMPRODUCT(G$19:$G55,H$19:$H55)/I55","v":{"$error":"#DIV/0!"}}]
[38,0,{"$f":"SUMPRODUCT(F$19:$F56,E$19:$E56)/D56","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E56)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A56)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A56)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A56)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A56)","v":0},{"$f":"SUM(H$19:$H56)","v":0},{"$f":"SUMPRODUCT(G$19:$G56,H$19:$H56)/I56","v":{"$error":"#DIV/0!"}}]
[39,0,{"$f":"SUMPRODUCT(F$19:$F57,E$19:$E57)/D57","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E57)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A57)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A57)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A57)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A57)","v":0},{"$f":"SUM(H$19:$H57)","v":0},{"$f":"SUMPRODUCT(G$19:$G57,H$19:$H57)/I57","v":{"$error":"#DIV/0!"}}]
[40,0,{"$f":"SUMPRODUCT(F$19:$F58,E$19:$E58)/D58","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E58)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A58)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A58)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A58)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A58)","v":0},{"$f":"SUM(H$19:$H58)","v":0},{"$f":"SUMPRODUCT(G$19:$G58,H$19:$H58)/I58","v":{"$error":"#DIV/0!"}}]
[41,0,{"$f":"SUMPRODUCT(F$19:$F59,E$19:$E59)/D59","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E59)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A59)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A59)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A59)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A59)","v":0},{"$f":"SUM(H$19:$H59)","v":0},{"$f":"SUMPRODUCT(G$19:$G59,H$19:$H59)/I59","v":{"$error":"#DIV/0!"}}]
[42,0,{"$f":"SUMPRODUCT(F$19:$F60,E$19:$E60)/D60","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E60)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A60)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A60)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A60)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A60)","v":0},{"$f":"SUM(H$19:$H60)","v":0},{"$f":"SUMPRODUCT(G$19:$G60,H$19:$H60)/I60","v":{"$error":"#DIV/0!"}}]
[43,0,{"$f":"SUMPRODUCT(F$19:$F61,E$19:$E61)/D61","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E61)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A61)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A61)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A61)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A61)","v":0},{"$f":"SUM(H$19:$H61)","v":0},{"$f":"SUMPRODUCT(G$19:$G61,H$19:$H61)/I61","v":{"$error":"#DIV/0!"}}]
[44,0,{"$f":"SUMPRODUCT(F$19:$F62,E$19:$E62)/D62","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E62)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A62)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A62)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A62)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A62)","v":0},{"$f":"SUM(H$19:$H62)","v":0},{"$f":"SUMPRODUCT(G$19:$G62,H$19:$H62)/I62","v":{"$error":"#DIV/0!"}}]
[45,0,{"$f":"SUMPRODUCT(F$19:$F63,E$19:$E63)/D63","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E63)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A63)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A63)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A63)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A63)","v":0},{"$f":"SUM(H$19:$H63)","v":0},{"$f":"SUMPRODUCT(G$19:$G63,H$19:$H63)/I63","v":{"$error":"#DIV/0!"}}]
[46,0,{"$f":"SUMPRODUCT(F$19:$F64,E$19:$E64)/D64","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E64)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A64)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A64)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A64)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A64)","v":0},{"$f":"SUM(H$19:$H64)","v":0},{"$f":"SUMPRODUCT(G$19:$G64,H$19:$H64)/I64","v":{"$error":"#DIV/0!"}}]
[47,0,{"$f":"SUMPRODUCT(F$19:$F65,E$19:$E65)/D65","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E65)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A65)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A65)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A65)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A65)","v":0},{"$f":"SUM(H$19:$H65)","v":0},{"$f":"SUMPRODUCT(G$19:$G65,H$19:$H65)/I65","v":{"$error":"#DIV/0!"}}]
[48,0,{"$f":"SUMPRODUCT(F$19:$F66,E$19:$E66)/D66","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E66)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A66)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A66)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A66)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A66)","v":0},{"$f":"SUM(H$19:$H66)","v":0},{"$f":"SUMPRODUCT(G$19:$G66,H$19:$H66)/I66","v":{"$error":"#DIV/0!"}}]
[49,0,{"$f":"SUMPRODUCT(F$19:$F67,E$19:$E67)/D67","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E67)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A67)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A67)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A67)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A67)","v":0},{"$f":"SUM(H$19:$H67)","v":0},{"$f":"SUMPRODUCT(G$19:$G67,H$19:$H67)/I67","v":{"$error":"#DIV/0!"}}]
[50,0,{"$f":"SUMPRODUCT(F$19:$F68,E$19:$E68)/D68","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E$19:$E68)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BSZ\",$A68)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"BID\",$A68)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASK\",$A68)","v":0},{"$f":"RTD(\"rit2.rtd\",,$C$10,\"ASZ\",$A68)","v":0},{"$f":"SUM(H$19:$H68)","v":0},{"$f":"SUMPRODUCT(G$19:$G68,H$19:$H68)/I68","v":{"$error":"#DIV/0!"}}]