{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ввод данных","Расчет данных"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Ввод данных","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,7,2,7],[1,8,2,8],[1,9,1,10],[0,0,0,10],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,2,4],[1,5,1,6]]}
["Ввод данных по сделкам"]
["Дата","Ticker","Время",null,"Направление","Цена",null,"Объем","Комиссия общ.","Метод"]
[null,null,"Вход","Выход",null,"Вход","Выход",null,null,"Вход","Выход"]
["2015-02-25","AEE","11:41:00","12:33:00","Long",43.77,43.88,200,1.444,"а","б"]
["2015-02-25","DYN","10:20:00","10:21:00","Short",28.984999999999999,29.08,400,2.766,"а","б"]
["2015-02-25","CHK","14:43:00","14:55:00","Short",18.001999999999999,18.07,200,1.034,"а","б"]
["2015-02-25","CHK","15:25:00","15:38:00","Short",17.98,18.02,400,2.3679999999999999,"а","б"]
["2015-02-25","CHK","15:38:00","15:41:00","Long",18.010000000000002,17.940000000000001,400,2.1280000000000001,"а","б"]
["2015-02-26","AR","11:21:00","11:23:00","Short",39.74,39.96,200,1.234,"а","б"]
["2015-02-26","RIG","12:06:00","12:11:00","Long",16.18,16.14,200,1.1839999999999999,"а","б"]
["2015-02-26","SDRL","13:19:00","14:06:00","Short",11.61,11.51,200,1.274,"а","б"]
["2015-02-27","JCP","09:51:00","12:56:00","Long",8.25,8.66,200,1.1639999999999999,"а","б"]

{"sheet":"Расчет данных","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,2,1,3],[1,11,1,12],[0,0,0,15],[1,8,1,10],[1,0,2,0],[1,1,2,1],[1,4,2,4],[1,7,2,7],[1,13,2,13],[1,14,2,14],[1,15,2,15]]}
["Расчет данных по сделкам"]
["Дата","Ticker","Время",null,"Направление","Цена",null,"Объем","Комиссия",null,null,"Метод",null,"Tick","Gross","Net"]
[null,null,"Вход","Выход",null,"Вход","Выход",null,"Итого","Брокер","UT","Вход","Выход"]
[{"$f":"'Ввод данных'!A4","v":"2015-02-25"},{"$f":"'Ввод данных'!B4","v":"AEE"},{"$f":"'Ввод данных'!C4","v":"11:41:00"},{"$f":"'Ввод данных'!D4","v":"12:33:00"},{"$f":"'Ввод данных'!E4","v":"Long"},{"$f":"'Ввод данных'!F4","v":43.77},{"$f":"'Ввод данных'!G4","v":43.88},{"$f":"'Ввод данных'!H4","v":200},{"$f":"'Ввод данных'!I4","v":1.444},{"$f":"I4-K4","v":0.84399999999999997},{"$f":"H4/100*0.3","v":0.6},{"$f":"'Ввод данных'!J4","v":"а"},{"$f":"'Ввод данных'!K4","v":"б"},{"$f":"IF(E4=\"Long\",G4-F4,F4-G4)","v":0.10999999999999943},{"$f":"N4*H4/2","v":10.999999999999943},{"$f":"O4-I4","v":9.5559999999999441}]
[{"$f":"'Ввод данных'!A5","v":"2015-02-25"},{"$f":"'Ввод данных'!B5","v":"DYN"},{"$f":"'Ввод данных'!C5","v":"10:20:00"},{"$f":"'Ввод данных'!D5","v":"10:21:00"},{"$f":"'Ввод данных'!E5","v":"Short"},{"$f":"'Ввод данных'!F5","v":28.984999999999999},{"$f":"'Ввод данных'!G5","v":29.08},{"$f":"'Ввод данных'!H5","v":400},{"$f":"'Ввод данных'!I5","v":2.766},1.5660000000000001,1.2,{"$f":"'Ввод данных'!J5","v":"а"},{"$f":"'Ввод данных'!K5","v":"б"},{"$f":"IF(E5=\"Long\",G5-F5,F5-G5)","v":-9.4999999999998863E-2},{"$f":"N5*H5/2","v":-18.999999999999773},-21.765999999999771]
[{"$f":"'Ввод данных'!A6","v":"2015-02-25"},{"$f":"'Ввод данных'!B6","v":"CHK"},{"$f":"'Ввод данных'!C6","v":"14:43:00"},{"$f":"'Ввод данных'!D6","v":"14:55:00"},{"$f":"'Ввод данных'!E6","v":"Short"},{"$f":"'Ввод данных'!F6","v":18.001999999999999},{"$f":"'Ввод данных'!G6","v":18.07},{"$f":"'Ввод данных'!H6","v":200},{"$f":"'Ввод данных'!I6","v":1.034},0.43400000000000005,0.6,{"$f":"'Ввод данных'!J6","v":"а"},{"$f":"'Ввод данных'!K6","v":"б"},-6.8000000000001393E-2,-6.8000000000001393,-7.8340000000001391]
[{"$f":"'Ввод данных'!A7","v":"2015-02-25"},{"$f":"'Ввод данных'!B7","v":"CHK"},{"$f":"'Ввод данных'!C7","v":"15:25:00"},{"$f":"'Ввод данных'!D7","v":"15:38:00"},{"$f":"'Ввод данных'!E7","v":"Short"},{"$f":"'Ввод данных'!F7","v":17.98},{"$f":"'Ввод данных'!G7","v":18.02},{"$f":"'Ввод данных'!H7","v":400},{"$f":"'Ввод данных'!I7","v":2.3679999999999999},1.1679999999999999,1.2,{"$f":"'Ввод данных'!J7","v":"а"},{"$f":"'Ввод данных'!K7","v":"б"},-3.9999999999999147E-2,-7.9999999999998295,-10.36799999999983]
[{"$f":"'Ввод данных'!A8","v":"2015-02-25"},{"$f":"'Ввод данных'!B8","v":"CHK"},{"$f":"'Ввод данных'!C8","v":"15:38:00"},{"$f":"'Ввод данных'!D8","v":"15:41:00"},{"$f":"'Ввод данных'!E8","v":"Long"},{"$f":"'Ввод данных'!F8","v":18.010000000000002},{"$f":"'Ввод данных'!G8","v":17.940000000000001},{"$f":"'Ввод данных'!H8","v":400},{"$f":"'Ввод данных'!I8","v":2.1280000000000001},0.92800000000000016,1.2,{"$f":"'Ввод данных'!J8","v":"а"},{"$f":"'Ввод данных'!K8","v":"б"},-7.0000000000000284E-2,-14.000000000000057,-16.128000000000057]
[{"$f":"'Ввод данных'!A9","v":"2015-02-26"},{"$f":"'Ввод данных'!B9","v":"AR"},{"$f":"'Ввод данных'!C9","v":"11:21:00"},{"$f":"'Ввод данных'!D9","v":"11:23:00"},{"$f":"'Ввод данных'!E9","v":"Short"},{"$f":"'Ввод данных'!F9","v":39.74},{"$f":"'Ввод данных'!G9","v":39.96},{"$f":"'Ввод данных'!H9","v":200},{"$f":"'Ввод данных'!I9","v":1.234},0.63400000000000001,0.6,{"$f":"'Ввод данных'!J9","v":"а"},{"$f":"'Ввод данных'!K9","v":"б"},-0.21999999999999886,-21.999999999999886,-23.233999999999888]
[{"$f":"'Ввод данных'!A10","v":"2015-02-26"},{"$f":"'Ввод данных'!B10","v":"RIG"},{"$f":"'Ввод данных'!C10","v":"12:06:00"},{"$f":"'Ввод данных'!D10","v":"12:11:00"},{"$f":"'Ввод данных'!E10","v":"Long"},{"$f":"'Ввод данных'!F10","v":16.18},{"$f":"'Ввод данных'!G10","v":16.14},{"$f":"'Ввод данных'!H10","v":200},{"$f":"'Ввод данных'!I10","v":1.1839999999999999},0.58399999999999996,0.6,{"$f":"'Ввод данных'!J10","v":"а"},{"$f":"'Ввод данных'!K10","v":"б"},-3.9999999999999147E-2,-3.9999999999999147,-5.1839999999999149]
[{"$f":"'Ввод данных'!A11","v":"2015-02-26"},{"$f":"'Ввод данных'!B11","v":"SDRL"},{"$f":"'Ввод данных'!C11","v":"13:19:00"},{"$f":"'Ввод данных'!D11","v":"14:06:00"},{"$f":"'Ввод данных'!E11","v":"Short"},{"$f":"'Ввод данных'!F11","v":11.61},{"$f":"'Ввод данных'!G11","v":11.51},{"$f":"'Ввод данных'!H11","v":200},{"$f":"'Ввод данных'!I11","v":1.274},0.67400000000000004,0.6,{"$f":"'Ввод данных'!J11","v":"а"},{"$f":"'Ввод данных'!K11","v":"б"},9.9999999999999645E-2,9.9999999999999645,8.7259999999999636]
[{"$f":"'Ввод данных'!A12","v":"2015-02-27"},{"$f":"'Ввод данных'!B12","v":"JCP"},{"$f":"'Ввод данных'!C12","v":"09:51:00"},{"$f":"'Ввод данных'!D12","v":"12:56:00"},{"$f":"'Ввод данных'!E12","v":"Long"},{"$f":"'Ввод данных'!F12","v":8.25},{"$f":"'Ввод данных'!G12","v":8.66},{"$f":"'Ввод данных'!H12","v":200},{"$f":"'Ввод данных'!I12","v":1.1639999999999999},0.56399999999999995,0.6,{"$f":"'Ввод данных'!J12","v":"а"},{"$f":"'Ввод данных'!K12","v":"б"},0.41000000000000014,41.000000000000014,39.836000000000013]