{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Рассчёт суммы ставки"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Рассчёт суммы ставки","index":0,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,6,1,7],[2,4,2,5],[2,6,2,7],[6,1,20,1],[6,3,6,14],[7,2,7,3]],"flags":["formulas_cached_only"]}
[]
[null,"Размер банка:",1000,null,"Перевес:",null,0.05]
[null,"Коэффициент на событие",2.1,null,"Риск:",null,10]
[null,"Сумма ставки:",30.10299956639812]
[]
[]
[null,"Отношение к риску выбирается индивидуально в каждом случае. При любой финансовой стратегии нужно выбрать удовлетворительное значение для ставки по равной линии (55% вероятность), а остальные будут рассчитываться по формуле. Я бы рекомендовал не ставить больше 4-5% по равной линии (этому соответствует отношение в районе 7-8), если вы хотите избежать крупных (до 50% просадок) - ставьте порядка 10-11, что даст ставки около 3%. Ещё есть одно интересное правило - средняя ставка на равную линию должна равняться проценту с оборота, то есть если вы бьёте линию с роем 10% - вы можете смело ставить 10% на равную мазу (и треть банка на 80% мазу, ага), просто перевес такой большой, что слиться вы не успеете... Одним словом посмотрите внимательно, какие суммы ставок устраивают вас лично и выберите наибольшую, если не знаете сколько ставить - ставьте 9, это не слишком мало, но и не слишком много.",null,"Вероятность события:"]
[null,null,"Отношение к риску:",null,0.01,0.1,0.2,0.30000000000000004,0.4,0.5,0.6000000000000001,0.7,0.8,0.9,0.99]
[null,null,null,2,0.01,0.02287874528033756,0.0484550065040282,0.07745097999287161,0.1109243748081782,0.1505149978319906,0.19897000433601889,0.2614393726401688,0.3494850021680095,0.5000000000000001,1]
[null,null,null,4,0.0010912013506125223,0.01143937264016878,0.0242275032520141,0.038725489996435804,0.0554621874040891,0.0752574989159953,0.09948500216800944,0.1307196863200844,0.17474250108400474,0.25000000000000006,0.5]
[null,null,null,7,0.0006235436289214412,0.006536784365810731,0.013844287572579484,0.022128851426534743,0.03169267851662234,0.043004285094854454,0.056848572667433955,0.07469696361147679,0.0998528577622884,0.14285714285714288,0.2857142857142857]
[null,null,null,9,0.00048497837805000987,0.0050841656178527905,0.010767779223117377,0.0172113288873048,0.024649861068484043,0.03344777729599791,0.0442155565191153,0.05809763836448195,0.07766333381511321,0.11111111111111112,0.2222222222222222]
[null,null,null,10,0.0004364805402450089,0.004575749056067511,0.009691001300805639,0.01549019599857432,0.02218487496163564,0.030102999566398118,0.03979400086720377,0.052287874528033754,0.06989700043360189,0.1,0.19999999999999998]
[null,null,null,11,0.00039680049113182623,0.004159771869152283,0.00881000118255058,0.014081996362340289,0.020168068146941488,0.027366363242180107,0.0361763644247307,0.04753443138912159,0.0635427276669108,0.09090909090909091,0.1818181818181818]
[null,null,null,12,0.00036373378353750743,0.003813124213389593,0.008075834417338033,0.0129084966654786,0.01848739580136303,0.025085832971998432,0.03316166738933648,0.043573228773361464,0.05824750036133491,0.08333333333333334,0.16666666666666666]
[null,null,null,15,0.0002909870268300059,0.0030504993707116744,0.006460667533870427,0.01032679733238288,0.014789916641090426,0.020068666377598746,0.026529333911469184,0.03485858301868917,0.04659800028906792,0.06666666666666668,0.13333333333333333]
[null,null,null,30,0.00014549351341500296,0.0015252496853558372,0.0032303337669352134,0.00516339866619144,0.007394958320545213,0.010034333188799373,0.013264666955734592,0.017429291509344583,0.02329900014453396,0.03333333333333334,0.06666666666666667]
[null,null,null,40,0.00010912013506125222,0.0011439372640168778,0.0024227503252014096,0.00387254899964358,0.00554621874040891,0.007525749891599529,0.009948500216800943,0.013071968632008438,0.017474250108400473,0.025,0.049999999999999996]
[null,null,null,50,8.729610804900177e-05,0.0009151498112135023,0.0019382002601611278,0.003098039199714864,0.004436974992327127,0.0060205999132796235,0.007958800173440753,0.01045757490560675,0.013979400086720377,0.02,0.039999999999999994]
[null,null,null,60,7.274675670750148e-05,0.0007626248426779186,0.0016151668834676067,0.00258169933309572,0.0036974791602726064,0.005017166594399687,0.006632333477867296,0.008714645754672292,0.01164950007226698,0.01666666666666667,0.03333333333333333]