{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sim States","Sim Assets","Sim Portfolio","Sim Hit Rates"],"not_rendered":{"charts":4,"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":"Sim States","index":0,"n_rows":117,"n_cols":34,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Transition Probabilities π",null,"From State…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vols",null,null,null,"CorrelsVecl"]
[null,null,null,1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C",null,"(A,B)","(A,C)","(B,C)"]
[null,"To State…",1,0.9,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xll.apaMatrix.Vecl(#REF!)","v":{"$error":"#VALUE!"}}]
[null,null,2,0.1,0.9,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xll.apaMatrix.Vecl(#REF!)","v":{"$error":"#VALUE!"}}]
[null,null,3,0,0.1,0.95,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xll.apaMatrix.Vecl(#REF!)","v":{"$error":"#VALUE!"}}]
[null,null,4,0,0,0.05,0.99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xll.apaMatrix.Vecl(#REF!)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"SUM(D4:D7)","v":1},{"$f":"SUM(E4:E7)","v":1},1,1]
[]
[null,"Initial State",1]
[null,null,"…this is called \"Markov property\": only the current state affects the next state"]
[]
[null,"nObs",100]
[]
[null,null,null,"Simulated State Trajectory"]
[null,null,"t","St"]
[null,null,0,{"$f":"C10","v":1}]
[null,null,{"$f":"C17+1","v":1},{"$f":"_xll.apaMarkovRegimeSwitching.Simulation.States(C13,C10,D4:G7)","v":1}]
[null,null,{"$f":"C18+1","v":2},1]
[null,null,3,1]
[null,null,4,1]
[null,null,5,1]
[null,null,6,1]
[null,null,7,1]
[null,null,8,1]
[null,null,9,2]
[null,null,10,2]
[null,null,11,2]
[null,null,12,3]
[null,null,13,3]
[null,null,14,3]
[null,null,15,3]
[null,null,16,3]
[null,null,17,3]
[null,null,18,3]
[null,null,19,3]
[null,null,20,3]
[null,null,21,3]
[null,null,22,3]
[null,null,23,3]
[null,null,24,3]
[null,null,25,3]
[null,null,26,3]
[null,null,27,4]
[null,null,28,4]
[null,null,29,4]
[null,null,30,4]
[null,null,31,4]
[null,null,32,4]
[null,null,33,4]
[null,null,34,4]
[null,null,35,4]
[null,null,36,4]
[null,null,37,4]
[null,null,38,4]
[null,null,39,4]
[null,null,40,4]
[null,null,41,4]
[null,null,42,4]
[null,null,43,4]
[null,null,44,4]
[null,null,45,4]
[null,null,46,4]
[null,null,47,4]
[null,null,48,4]
[null,null,49,4]
[null,null,50,4]
[null,null,51,4]
[null,null,52,4]
[null,null,53,4]
[null,null,54,4]
[null,null,55,4]
[null,null,56,4]
[null,null,57,4]
[null,null,58,4]
[null,null,59,4]
[null,null,60,4]
[null,null,61,4]
[null,null,62,4]
[null,null,63,4]
[null,null,64,4]
[null,null,65,4]
[null,null,{"$f":"C82+1","v":66},4]
[null,null,67,4]
[null,null,68,4]
[null,null,69,4]
[null,null,70,4]
[null,null,71,4]
[null,null,72,4]
[null,null,73,4]
[null,null,74,4]
[null,null,75,4]
[null,null,76,4]
[null,null,77,4]
[null,null,78,4]
[null,null,79,4]
[null,null,80,4]
[null,null,81,4]
[null,null,82,4]
[null,null,83,4]
[null,null,84,4]
[null,null,85,4]
[null,null,86,4]
[null,null,87,4]
[null,null,88,4]
[null,null,89,4]
[null,null,90,4]
[null,null,91,4]
[null,null,92,4]
[null,null,93,4]
[null,null,94,4]
[null,null,95,4]
[null,null,96,4]
[null,null,97,4]
[null,null,98,4]
[null,null,99,4]
[null,null,100,4]

{"sheet":"Sim Assets","index":1,"n_rows":128,"n_cols":27,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"State 1",null,null,null,"State 2",null,null,null,"State 3",null,null,null,"State 4"]
[null,"Assets","A","B","C",null,"A","B","C",null,"A","B","C",null,"A","B","C"]
[null,"Expected Returns",0.2,0.1,0.05,null,0.25,0.1,0.05,null,-0.2,0.2,0.01,null,0.25,0.15,-0.05]
[]
[null,"Volatilities",0.25,0.15,0.1,null,0.3,0.1,0.05,null,0.5,0.1,0.05,null,0.25,0.15,0.35]
[]
[null,"Correlations",1,0.7,0.3,null,1,0.5,0.7,null,1,-0.5,0.5,null,1,0.4,0.2]
[null,null,{"$f":"D8","v":0.7},1,0.2,null,{"$f":"H8","v":0.5},1,0.8,null,{"$f":"L8","v":-0.5},1,0.4,null,{"$f":"P8","v":0.4},1,0.1]
[null,null,{"$f":"E8","v":0.3},{"$f":"E9","v":0.2},1,null,{"$f":"I8","v":0.7},{"$f":"I9","v":0.8},1,null,{"$f":"M8","v":0.5},{"$f":"M9","v":0.4},1,null,{"$f":"Q8","v":0.2},{"$f":"Q9","v":0.1},1]
[null,"Is Valid?",{"$f":"_xll.apaCorrels.IsValid(C8:E10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(G8:I10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(K8:M10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(O8:Q10)","v":true}]
[]
[null,"Initial State",1]
[]
[null,"Transition Probabilities π",null,"From State…",null,null,null,null,null,null,"Function Arguments",null,null,"Means",null,null,null,null,"Vols",null,null,null,"CorrelsVecl"]
[null,null,null,1,2,3,4,null,null,null,null,"A","B","C",null,null,"A","B","C",null,"(A,B)","(A,C)","(B,C)"]
[null,"To State…",1,0.9,0,0,0,null,null,null,1,{"$f":"C4:E4","v":0.2},0.1,0.05,null,null,{"$f":"C6:E6","v":0.25},0.15,0.1,null,{"$f":"_xll.apaMatrix.Vecl(C8:E10)","v":0.7},0.3,0.2]
[null,null,2,0.1,0.9,0,0,null,null,null,2,{"$f":"G4:I4","v":0.25},0.1,0.05,null,null,{"$f":"G6:I6","v":0.3},0.1,0.05,null,{"$f":"_xll.apaMatrix.Vecl(G8:I10)","v":0.5},0.7,0.8]
[null,null,3,0,0.1,0.95,0.01,null,null,null,3,{"$f":"K4:M4","v":-0.2},0.2,0.01,null,null,{"$f":"K6:M6","v":0.5},0.1,0.05,null,{"$f":"_xll.apaMatrix.Vecl(K8:M10)","v":-0.5},0.5,0.4]
[null,null,4,0,0,0.05,0.99,null,null,null,4,{"$f":"O4:Q4","v":0.25},0.15,-0.05,null,null,{"$f":"O6:Q6","v":0.25},0.15,0.35,null,{"$f":"_xll.apaMatrix.Vecl(O8:Q10)","v":0.4},0.2,0.1]
[null,null,null,{"$f":"SUM(D17:D20)","v":1},{"$f":"SUM(E17:E20)","v":1},1,1]
[]
[null,"nObs",100]
[null,"Show States?",true,null,null,null,null,"Scale",20]
[]
[null,null,null,null,null,null,null,null,"Cumulative Returns"]
[null,null,"Simulated Asset Returns",null,null,null,"A","B","C",null,null,null,null,null,null,null,null,null,null,"Unconditional Statistics for Simulated Asset Returns"]
[null,"State","A","B","C",null,1,1,1,null,null,null,null,null,null,null,null,null,null,"A","B","C",null,null,"A","B","C"]
[null,{"$f":"_xll.apaMarkovRegimeSwitching.Simulation.Assets(C23,C13,L17:N20,Q17:S20,U17:W20,D17:G20,C24)","v":1},0.35785074928488741,8.282300088192332E-2,6.2909409101683855E-2,null,{"$f":"G28*(1+C29/$I$24)","v":1.0178925374642445},{"$f":"H28*(1+D29/$I$24)","v":1.0041411500440962},{"$f":"I28*(1+E29/$I$24)","v":1.0031454704550842},null,null,null,null,null,null,null,null,null,"Exp Rets",{"$f":"AVERAGE(C29:C128)","v":0.17284769685471424},{"$f":"AVERAGE(D29:D128)","v":0.16236938471892248},{"$f":"AVERAGE(E29:E128)","v":-7.6084044616221341E-2},null,"Skew",{"$f":"SKEW(C29:C128)","v":-2.8038052920660354E-2},{"$f":"SKEW(D29:D128)","v":-0.16907625505821011},{"$f":"SKEW(E29:E128)","v":-0.35833242595778403}]
[null,2,0.80769381089871306,0.21691790388914567,0.10464160710510446,null,1.0589998125977373,1.0150319597179163,1.0083940081645155]
[null,3,-0.44747409135872185,0.2345146493561964,-1.0621455172015995E-2,null,1.0353060636531759,1.0269339529238453,1.0078584775768431,null,null,null,null,null,null,null,null,null,"Vols",{"$f":"STDEV(C29:C128)","v":0.33557346061664545},{"$f":"STDEV(D29:D128)","v":0.13713757438476942},{"$f":"STDEV(E29:E128)","v":0.34673894907909714},null,"Kurt",{"$f":"KURT(C29:C128)","v":0.91155687210219893},{"$f":"KURT(D29:D128)","v":-0.16941090350537635},{"$f":"KURT(E29:E128)","v":1.4382368456476562}]
[null,3,0.13050381151341689,0.17498580783998344,-1.0324539280489787E-2,null,1.0420616330226606,1.0359188962913797,1.0073381938547972]
[null,3,0.69328454298173448,7.4041519145333412E-2,2.356625989310767E-2,null,1.0781838941731063,1.0397539467310182,1.008525153538629,null,null,null,null,null,null,null,null,null,"Correls",{"$f":"_xll.apaCorrels(C29:E128)","v":1},9.6936567378963681E-2,7.776333562667237E-2]
[null,4,0.27952635882979632,-0.12060394788010412,0.84037600044949323,null,1.0932529350774634,1.0334840251910342,1.0509021702828041,null,null,null,null,null,null,null,null,null,null,9.6936567378963681E-2,1,-2.679197298998124E-2]
[null,4,0.31382304772329406,0.29891151588680809,1.1347762622212577E-2,null,1.1104073334783857,1.0489300390217668,1.0514984397011808,null,null,null,null,null,null,null,null,null,null,7.776333562667237E-2,-2.679197298998124E-2,1]
[null,4,0.13788177240560862,3.3973295909553808E-2,4.0137645280316062E-2,null,1.118062580039995,1.0507118195519722,1.0536086732704575]
[null,4,0.22782831180351598,1.1620604997384404E-2,-0.33769677553549321,null,1.1307988955450547,1.0513223149030271,1.0358186606884743]
[null,4,-0.23014414739326244,0.16246778164187553,-0.46181452072449736,null,1.1177865581606317,1.0598626151176718,1.0119008557713074]
[null,4,0.22292515669363624,-0.10140307755726211,0.46153489679161647,null,1.1302456953420315,1.0544889485696307,1.0352522336228953]
[null,4,-0.13121755843169236,-3.7782634484144512E-2,-0.3664382400972373,null,1.1228302913134958,1.0524968800440619,1.01628443329562]
[null,4,0.23251321074707368,0.15259797289952975,-0.19786746813296469,null,1.1358839351213645,1.0605273245629521,1.0062299519096627]
[null,4,-1.8939618834098337E-2,0.15580338643298053,8.7475165501474453E-2,null,1.1348082746828159,1.0687890119915331,1.0106309584884547]
[null,4,0.369307610838505,0.27787703054648494,-0.43180152766054974,null,1.1557629413169597,1.083638607838179,0.98881135889963678]
[null,4,0.4248663226311164,0.31115041557305939,-0.72937506200667557,null,1.1803151788524926,1.100497337996172,0.95275064158912037]
[null,4,-0.13756150754082452,0.20740220642011262,0.1822221891990467,null,1.1721968820836792,1.1119096167991653,0.96143125697267862]
[null,4,0.45747511542246111,0.20001406495393553,0.20169292448997489,null,1.1990094272801333,1.1230294949150339,0.97112695106842328]
[null,4,-5.7455502509278888E-2,0.34860818370809649,6.0662492778449373E-3,null,1.1955649428222461,1.1426043585386814,0.97142150597670407]
[null,4,0.42357038033221722,0.32685241545385113,-0.62301571900251862,null,1.2208852376994004,1.1612775082635047,0.94116096257667481]
[null,4,0.61085417463427039,0.20915339334143185,-0.10434504093260971,null,1.2581743799093021,1.1734217648367244,0.93625068861846295]
[null,4,0.75512838141255412,0.15644582469989973,0.24842614000308033,null,1.3056785390610848,1.1826006116227592,0.94788014585089841]
[null,4,0.81854489773514894,0.26467351970551711,0.14354380916423493,null,1.3591163643726216,1.1982507649369638,0.95468326218922794]
[null,4,0.1184358020893802,0.20514643264124061,-0.13140606831580434,null,1.3671647662099853,1.2105416084287866,0.94841070349066825]
[null,4,0.21340975413691468,5.7678320283914383E-2,-0.80694678173753598,null,1.3817530810410616,1.2140327087591847,0.91014485524330691]
[null,4,0.21701781937200129,1.8539369504043834E-2,-0.42856341784195551,null,1.3967463330689653,1.2151580788080689,0.89064211574858976]
[null,4,0.10188031624705315,-1.0336150221872953E-3,0.191074475095934,null,1.4038613809754643,1.2150952785258395,0.89915106448683946]
[null,4,0.44432124459726979,0.20856255258071116,0.16807514448746125,null,1.4350496527773173,1.2277664471717455,0.90670731174082353]
[null,4,0.31605608971486843,0.13488190387783219,9.9557468479399572E-2,null,1.4577274618674914,1.2360466209673378,0.91122078597125755]
[null,4,0.34315582337581052,0.40990342228538656,0.10289272535400203,null,1.4827388452392249,1.2613796079692778,0.91590868547464754]
[null,4,0.78869545148957521,0.3524177567588952,-0.63140033338162438,null,1.5412103143885791,1.283606236562375,0.88699343300685662]
[null,4,3.8555730457144777E-2,0.11947407225969289,-0.3913568861949705,null,1.544181438861546,1.2912741197753772,0.8696368836060091]
[null,4,0.46049587543083481,0.20260452859100919,0.52547066877457538,null,{"$f":"G60*(1+C61/$I$24)","v":1.5797358980371758},{"$f":"H60*(1+D61/$I$24)","v":1.3043550189913202},{"$f":"I60*(1+E61/$I$24)","v":0.89248531734698344}]
[null,4,0.49767711460122921,0.1748825481210825,-0.67768169018616109,null,1.6190458182155321,1.3157604654601067,0.86224426943068166]
[null,4,0.38112292177224039,0.27522161868134504,-2.0483312078139661E-2,null,1.6498985918516036,1.3338667517151495,0.86136118850776489]
[null,4,0.24532246820007073,0.26180318149931558,0.18564223387525786,null,1.6701364515932462,1.3513272796799085,0.8693564392681663]
[null,4,0.1330357028437289,0.29450473342788458,0.33869402535917897,null,1.681245840427378,1.3712258936937063,0.88407873086254929]
[null,4,0.11593086501317149,-0.19816712772108816,4.8829483815224742E-2,null,1.6909912546564052,1.3576392988532031,0.88623718626655112]
[null,4,0.35950346937515371,0.51350862181101919,0.21794745606169874,null,1.7213871157930063,1.3924972731167324,0.89589484327725477]
[null,4,-8.4694106733841701E-2,7.2608677515939912E-2,-3.5364624447471738E-2,null,1.7140975485872445,1.3975526423890106,0.89431069404340846]
[null,4,0.120119000331918,0.10889859358991602,-3.0200313495530394E-2,null,1.7243923327876289,1.4051622182502124,0.89296027087728269]
[null,4,3.8038496442660552E-3,0.1019256054893616,-0.31509990813217487,null,1.7247202992457111,1.4123233187455086,0.87889168591132705]
[null,4,-4.2637116719616563E-3,5.7800007085575048E-2,0.15588255876104329,null,1.724352613742173,1.4164049336370392,0.88574188015501032]
[null,4,1.0564746931096405,0.28830412050209531,0.17489789900288172,null,1.8154393586629765,1.4368227025703921,0.893487599849909]
[null,4,-0.18714486071534481,-2.0322382808213968E-2,-5.7744546868017395E-2,null,1.7984518513672696,1.4353627195209337,0.89090789802063275]
[null,4,0.23625351455741778,0.10583968495154858,-0.45978535181779251,null,1.8196963798996604,1.4429586364221985,0.87042657795419942]
[null,4,4.0573716912276375E-2,4.7130428677990929E-2,0.20576143847179457,null,1.8233879721888775,1.446358999377158,0.8793815891923964]
[null,4,0.23786187017554214,0.11881207458948756,-0.47068621110379405,null,1.8450736958448992,1.4549512450430169,0.85868594977582624]
[null,4,1.4977372962479751E-2,0.26071890679036108,-0.46109167435881204,null,1.846455413689196,1.4739179099450614,0.83888930265930017]
[null,4,1.5532759508311567E-3,-4.2183830490908958E-2,9.0344743469490049E-2,null,1.846598816428614,1.4708091347815295,0.84267876460170288]
[null,4,0.31587392725775865,0.17071753957276664,-0.17808897012655067,null,1.8757634374393559,1.4833637806150821,0.83517517493493132]
[null,4,-0.16675837444575137,0.22421554193054929,-0.26672281638321121,null,1.8601234743557478,1.4999934413126201,0.82403716119333204]
[null,4,-0.10987687708775129,0.12634145057711466,0.13385055653883271,null,1.8499042464377564,1.5094690086741998,0.8295520528250524]
[null,4,-0.14358802081132083,-7.9345762777646461E-2,-0.51775454941784971,null,1.8366230419659337,1.5034805101800761,0.80807683535859798]
[null,4,0.13858974369213117,0.32117700451799658,-0.15075008465944434,null,1.8493498977981899,1.5276246785106173,0.80198595279151574]
[null,4,0.27165823370274861,0.15112233630339433,0.38846391595648533,null,1.8744694541349005,1.5391675890311796,0.81756308297969005]
[null,4,-0.2887846078888997,0.2259843994610746,-0.34801260470235662,null,1.8474035578192973,1.5565589821950376,0.8033369700788775]
[null,4,0.19218328077769448,0.28229254200298104,-0.31377822345250916,null,1.865155561652402,1.5785292317881081,0.79073348771362384]
[null,4,0.24903026625558877,0.2667553966177113,-0.866150183577021,null,1.8883795709587214,1.5995832913530226,0.7564887899364412]
[null,4,0.25338228128170165,0.28841095680529122,-0.44933144673250081,null,1.9123036671394855,1.6226501587304667,0.73949307981548817]
[null,4,0.33943800333596091,0.33838246710097036,-0.69249198927871747,null,1.9447590940667787,1.6501039769281165,0.71388842812052444]
[null,4,0.64946696641749524,0.14965725830093585,-0.61858071832559858,null,2.007911933528598,1.6624514787830431,0.69180854728696817]
[null,4,4.2748211949162396E-2,-1.0826193876608853E-2,-0.26279141579719778,null,2.0122036657740847,1.6615515776820551,0.68271847990686096]
[null,4,-0.40016361005642775,0.15393989182287987,-0.59950363960872277,null,1.971943131620838,1.6743405311883808,0.66225386923024609]
[null,4,0.30573780414189899,0.18124002361360611,-3.8232632905998314E-2,null,{"$f":"G92*(1+C93/$I$24)","v":2.0020880097685607},{"$f":"H92*(1+D93/$I$24)","v":1.6895134070588709},{"$f":"I92*(1+E93/$I$24)","v":0.66098788377660322}]
[null,4,-0.12714213065252694,0.1333804142595067,0.11077128850180114,null,1.9893605230027682,1.700780806965396,0.66464880775510382]
[null,4,0.37338171263521142,0.28796179056352722,0.97683962555353743,null,2.0265000649591509,1.7252688012918878,0.69711157237970878]
[null,4,0.71804783074715028,0.28490137219918588,-7.5774407886170125E-2,null,2.0992562637417946,1.7498453737369131,0.69447041154832523]
[null,4,-0.14704824918015807,-3.0598328291545573E-2,2.7923084211561866E-4,null,2.0838216658336091,1.7471682565766609,0.69448010742621724]
[null,4,0.31970673239883979,-1.5959847042561898E-2,-0.32722946623740773,null,2.1171322566178876,1.7457740296700317,0.68311738968293823]
[null,4,0.53209284127682377,7.3845274095444793E-2,0.31798208879096657,null,2.173457802507019,1.7522198877565165,0.69397834440597883]
[null,4,0.22927480627290625,8.9187408178880156E-3,-2.0381788628316792E-2,null,2.1983737583376257,1.7530012675082591,0.69327111840956324]
[null,4,0.25553600254951586,0.20469097051626348,0.11896512913995087,null,2.2264619404533934,1.7709424440463841,0.6973948728160928]
[null,4,0.65395455714574102,0.30350080231314952,0.29242329463503119,null,2.2992621870669456,1.7978165666773083,0.70759159813461581]
[null,4,0.13481763699046534,1.740324581983782E-2,1.3114554586619864E-2,null,2.3147612418110408,1.7993809588597514,0.70805558556655435]
[null,3,-1.8789533607929954E-2,7.9648980665466954E-2,-1.7601479348379676E-3,null,2.3125865776036738,1.806546901819853,0.70799327143772006]
[null,3,-0.81842095071944398,0.1932876958256658,-6.7678928045276088E-2,null,2.2179531123305023,1.824006066222541,0.70559746015401137]
[null,3,-4.8407233052084414E-2,0.24769590275287678,3.5110384330288964E-2,null,2.2125848636701435,1.846596007682527,0.70683615005443545]
[null,3,0.167711839386465,0.24308427859623238,9.42206926141754E-2,null,2.2311386975343819,1.8690399306018366,0.71016607963557887]
[null,3,5.7861485322558137E-2,0.26728584188725479,5.5208757283588157E-2,null,2.2375935474843809,1.8940183261704269,0.71212644897166077]
[null,3,-3.1428431312411381E-2,0.28519839932488733,6.0011560419047892E-2,null,2.2340773447287705,1.9210268759162172,0.71426323994258401]
[null,3,-0.21227898740209949,0.26073011845132832,4.0022530091955305E-2,null,2.210364960902921,1.9460703541615081,0.71569257104329298]
[null,3,0.47208122052797213,-7.3328384368380295E-2,-4.6166489357293956E-2,null,2.2625385503306865,1.9389352444146148,0.71404052037008481]
[null,3,-6.3071792623161371E-2,0.15871557081661575,-3.370590721308054E-2,null,2.2554034322182681,1.9543222051193008,0.7128371511937861]
[null,3,-0.23986460187067388,0.2337796655063768,3.2074352857590062E-2,null,2.2283538599019286,1.9771662446895246,0.71398034070965555]
[null,3,-6.2826156125423804E-2,0.24055794780911349,3.0464525775853714E-2,null,2.2213539145266843,2.0009473974045231,0.71506789433430573]
[null,3,8.6695660968163224E-2,4.4033722122163277E-2,-3.0258528296603748E-2,null,2.2309830018198897,2.0053528554884421,0.71398604922857034]
[null,3,3.27226912135134E-3,0.17482104938508289,3.3238382521696447E-2,null,2.2313480206592455,2.022881750017635,0.71517263629954109]
[null,3,-0.15952814452576436,0.36684360737557187,8.2091229436662722E-2,null,2.213549880182895,2.0599858119411691,0.71810810634820554]
[null,3,-0.49029567507026228,0.15794300300762626,-4.0296519470524934E-2,null,2.1592851835425964,2.0762538292057235,0.7166612434837355]
[null,3,-0.79022187284661216,0.45092532847067818,5.8338012695357072E-2,null,2.0739694644551476,2.123065601201878,0.71875167311976673]
[null,3,0.49557254605353501,9.772150423708699E-2,1.8750853592246933E-2,null,2.1253595808520136,2.1334390594090511,0.71942553348935923]
[null,3,1.0522414022744622,0.10052895492842014,0.11589432410849129,null,2.237179148136673,2.1441626793613442,0.72359440028686628]
[null,3,-0.10536054026559791,0.23445424880263149,2.7758800697410137E-2,null,2.2253936279507425,2.1692980818763594,0.72459870592403242]
[null,4,0.38343700987404072,4.3406265999883578E-2,-0.31207580598115925,null,2.2680585418754511,2.1740061383551077,0.71329221966582501]
[null,4,-0.15167098588900046,-5.9782395707919517E-2,-1.2544534506310738,null,2.2508586081204403,2.1675077735933783,0.66855262535242044]
[null,4,0.30097355458868191,0.43555723816934211,-0.41605331249797967,null,2.2847310539285672,2.2147114585722241,0.65464494863456568]
[null,4,-2.4804029218433721E-2,-0.10294903631238392,0.10393808776093925,null,2.281897527137672,2.2033113380537239,0.65804707584073741]
[null,4,0.35081631283442194,0.26562921819316332,-5.8992707089812274E-2,null,2.3219238709744934,2.232574531461891,0.65610607692091838]
[null,4,8.8600057282968048E-2,6.2535419894907116E-2,0.51090118250213934,null,2.3322100003732449,2.2395552807504733,0.67286634544820523]

{"sheet":"Sim Portfolio","index":2,"n_rows":129,"n_cols":22,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"State 1",null,null,null,"State 2",null,null,null,"State 3",null,null,null,"State 4"]
[null,"Assets","A","B","C",null,"A","B","C",null,"A","B","C",null,"A","B","C"]
[null,"Expected Returns",0.2,0.1,0.05,null,0.25,0.1,0.05,null,-0.2,0.2,0.01,null,0.25,0.15,-0.05]
[]
[null,"Volatilities",0.25,0.15,0.1,null,0.3,0.1,0.05,null,0.5,0.1,0.05,null,0.25,0.15,0.35]
[]
[null,"Correlations",1,0.7,0.3,null,1,0.5,0.7,null,1,-0.5,0.5,null,1,0.4,0.2]
[null,null,{"$f":"D8","v":0.7},1,0.2,null,{"$f":"H8","v":0.5},1,0.8,null,{"$f":"L8","v":-0.5},1,0.4,null,{"$f":"P8","v":0.4},1,0.1]
[null,null,{"$f":"E8","v":0.3},{"$f":"E9","v":0.2},1,null,{"$f":"I8","v":0.7},{"$f":"I9","v":0.8},1,null,{"$f":"M8","v":0.5},{"$f":"M9","v":0.4},1,null,{"$f":"Q8","v":0.2},{"$f":"Q9","v":0.1},1]
[null,"Is Valid?",{"$f":"_xll.apaCorrels.IsValid(C8:E10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(G8:I10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(K8:M10)","v":true},null,null,null,{"$f":"_xll.apaCorrels.IsValid(O8:Q10)","v":true}]
[]
[null,"Initial State",1]
[]
[null,"Transition Probabilities π",null,"From State…",null,null,null,null,null,"Function Arguments",null,null,"Means",null,null,null,null,"Vols",null,null,null,"CorrelsVecl"]
[null,null,null,1,2,3,4,null,null,null,"A","B","C",null,null,"A","B","C",null,"(A,B)","(A,C)","(B,C)"]
[null,"To State…",1,0.9,0,0,0,null,null,1,{"$f":"C4:E4","v":0.2},0.1,0.05,null,null,{"$f":"C6:E6","v":0.25},0.15,0.1,null,{"$f":"_xll.apaMatrix.Vecl(C8:E10)","v":0.7},0.3,0.2]
[null,null,2,0.1,0.9,0,0,null,null,2,{"$f":"G4:I4","v":0.25},0.1,0.05,null,null,{"$f":"G6:I6","v":0.3},0.1,0.05,null,{"$f":"_xll.apaMatrix.Vecl(G8:I10)","v":0.5},0.7,0.8]
[null,null,3,0,0.1,0.95,0.01,null,null,3,{"$f":"K4:M4","v":-0.2},0.2,0.01,null,null,{"$f":"K6:M6","v":0.5},0.1,0.05,null,{"$f":"_xll.apaMatrix.Vecl(K8:M10)","v":-0.5},0.5,0.4]
[null,null,4,0,0,0.05,0.99,null,null,4,{"$f":"O4:Q4","v":0.25},0.15,-0.05,null,null,{"$f":"O6:Q6","v":0.25},0.15,0.35,null,{"$f":"_xll.apaMatrix.Vecl(O8:Q10)","v":0.4},0.2,0.1]
[null,null,null,{"$f":"SUM(D17:D20)","v":1},{"$f":"SUM(E17:E20)","v":1},1,1]
[]
[]
[null,"nObs",100,null,"Portfolio Constituent Weights"]
[null,"Show States?",true,null,"A","B","C"]
[null,"nPaths",600,null,0.6,0.2,0.2]
[]
[null,null,"Simulated Portfolio Returns"]
[null,null,"Mean","95% Conf","90% Conf","75% Conf","Median","75% Conf","90% Conf","95% Conf"]
[null,null,{"$f":"_xll.apaMarkovRegimeSwitching.Simulation.Portfolio(C24,C26,E26:G26,C13,K17:M20,P17:R20,T17:V20,D17:G20)","v":0.14170922518951445},-0.13956950561998122,-8.9601348633364566E-2,1.4244368580662742E-2,0.13671649226927571,0.2602444612580852,0.3818664682399916,0.45308931063509728]
[null,null,0.1474195950392502,-0.15424045877063644,-9.5169483223392567E-2,2.6836100826119653E-2,0.13526823271706068,0.27943216065366971,0.38562424213365643,0.4375028549962795]
[null,null,0.15570109232559293,-0.17545527049054177,-8.572005100197673E-2,3.0409010339205858E-2,0.16285135945609325,0.28748127369805632,0.40349426104517372,0.45866406142693522]
[null,null,0.15767554083959684,-0.15405377100310813,-7.9894022048864824E-2,3.0563204993461615E-2,0.16702390357432187,0.28361933056885835,0.40501052201162702,0.46036107693059097]
[null,null,0.14464964349014603,-0.22649239273339178,-0.11050328543261731,2.9799017300189974E-2,0.1454607463407811,0.27849519543759327,0.40867781625893529,0.46380149744153221]
[null,null,0.13771713903556851,-0.20715408666662957,-0.10751531850465475,1.6799956072775443E-2,0.14356683380822644,0.26579015448368504,0.39413263311936614,0.44344188355598746]
[null,null,0.14899258724711453,-0.19580046389413577,-0.13119033224627175,1.616019938930302E-2,0.16506164692942615,0.29972928117198877,0.42233487648720619,0.48439526921777964]
[null,null,0.12454374123194155,-0.28454144132523157,-0.14960079996165637,-7.549298980568918E-3,0.14333068228682116,0.27248309035877671,0.40735504460486238,0.46508168901856944]
[null,null,0.1106594157443813,-0.29955942597801616,-0.20100507800760845,-1.5038573032971268E-2,0.1271967921548533,0.26908242258950299,0.36618130269655425,0.4405157575559997]
[null,null,0.13010723138428051,-0.25748323217338531,-0.13424884225562195,2.0948793504609446E-3,0.14044973810242695,0.28803429752764759,0.3916903976253272,0.4673701906446161]
[null,null,7.9377237206448278E-2,-0.38924081308550063,-0.23052621427959491,-7.4616429950512889E-2,9.6865943531964122E-2,0.24169954484858597,0.36732898497466226,0.4462158914419353]
[null,null,9.677954453439036E-2,-0.35570075471126789,-0.23105542528692957,-3.8180468212561589E-2,0.12143564298343426,0.26380251778798625,0.38143397839676085,0.45203839927739786]
[null,null,7.1399501382400504E-2,-0.38499742918834079,-0.25618643428635907,-7.6426313235472693E-2,9.2253423426110703E-2,0.24999159870487977,0.37605424834260576,0.45550801283977682]
[null,null,8.5337680019056311E-2,-0.40166134051023988,-0.27333824609029589,-5.9807810671989245E-2,0.10742647889202163,0.26050248162422507,0.41302601467879074,0.50154231895298806]
[null,null,9.6806720768864277E-2,-0.43918252978366895,-0.26267131062150784,-5.9435454626210311E-2,0.12871807902448823,0.28442738614598817,0.41995529967978218,0.47177622513725043]
[null,null,7.4070069236937416E-2,-0.39740361980182726,-0.30151163593648744,-9.0005607487210121E-2,9.7839493027434971E-2,0.26278408673657422,0.37198137398732284,0.447078943817737]
[null,null,7.8998874629784888E-2,-0.4417329331394047,-0.28178226037349807,-7.0461054062812736E-2,0.10273107923729488,0.25859622646882141,0.40686917512714993,0.49170753579613768]
[null,null,5.1638964254833733E-2,-0.42602561465455263,-0.30714960336858532,-8.5694785900092579E-2,6.3197192685415932E-2,0.20693045981770297,0.33739789829260791,0.4237199960888553]
[null,null,7.8696474266174474E-2,-0.43207184402164345,-0.32318167098057443,-9.1828133808817047E-2,0.10902013864147703,0.26177797970215821,0.39235453077380977,0.49425099159875663]
[null,null,8.8380349407485917E-2,-0.39011716606433566,-0.24351831840589847,-8.2762292743504592E-2,0.11954040568930874,0.28023606257445771,0.40908379344426993,0.47413988069947505]
[null,null,5.7193934261477085E-2,-0.43614571414121128,-0.2999871738954582,-0.10151339977621882,7.6487250021074898E-2,0.2361926463099539,0.4007926927899933,0.45581906168255648]
[null,null,5.2654473546289882E-2,-0.45753379603786859,-0.29799168935461701,-8.9175266150227833E-2,7.2236464742191503E-2,0.23206179676774791,0.36566851313353366,0.47341394311195817]
[null,null,5.7614080550275129E-2,-0.44588096806333966,-0.2929520919763034,-8.7842392863659191E-2,8.8823938703023936E-2,0.22861944322208738,0.36034287391466735,0.45292175965195852]
[null,null,5.5770792038260561E-2,-0.44084061244511957,-0.30999725409940748,-0.11063543971799064,8.4365019951877646E-2,0.25124125229906658,0.36194360437688838,0.44086330197974133]
[null,null,7.405979037526049E-2,-0.45677860985183655,-0.29395167783413989,-9.081716441492306E-2,0.10299884370714185,0.2437918971413581,0.4236538521260258,0.48123912591291412]
[null,null,6.8989253821531024E-2,-0.40297715762099795,-0.2786863395915265,-9.0806236410360383E-2,0.10410234749999171,0.2594535860670571,0.36455664954584233,0.44573798277738008]
[null,null,5.3386561759830628E-2,-0.42701485634274922,-0.31645269635333678,-0.12234407190570859,7.3902244764566749E-2,0.25685255763637493,0.3869354019152505,0.45293535298762139]
[null,null,5.4942848751900517E-2,-0.4335390233887601,-0.30450817557698417,-0.10623077208342291,7.750543264951465E-2,0.24142075192917917,0.36902299012597101,0.45688794902460939]
[null,null,6.9739583843796901E-2,-0.44063414951973934,-0.31981556340399492,-8.5229196796021159E-2,8.9323421615384785E-2,0.26182941942395799,0.39749447575171526,0.49285743188143455]
[null,null,5.376022262071134E-2,-0.45765498151754652,-0.32065647043195589,-0.11021847951927546,7.329193614489761E-2,0.23418011057909208,0.39495469234888508,0.47368529281552851]
[null,null,6.2496241871343408E-2,-0.4108605266598212,-0.3082026437312132,-0.12662543262898956,7.8141779893934213E-2,0.27944786674404554,0.3907407067960626,0.4484831248061476]
[null,null,6.2518136125609219E-2,-0.47366988429515755,-0.30393996767364534,-8.5610437989583815E-2,9.6146800288841122E-2,0.25542335622030948,0.38334250591535318,0.47158153986351847]
[null,null,7.0799481169827483E-2,-0.42373882467057511,-0.25749277848134444,-7.3296059711925418E-2,0.10827247410754143,0.25250815116593794,0.37144676691555634,0.42186895514026829]
[null,null,6.9953441817011408E-2,-0.42280500926477554,-0.28338032019568493,-8.4944716650961496E-2,0.10316904998481249,0.24510970129085802,0.37404143897234304,0.4457160091476946]
[null,null,6.1848127089244101E-2,-0.43609788426513585,-0.3043960979527115,-8.9792769291951791E-2,8.5670739098061513E-2,0.24151233072297876,0.37582560911568857,0.46829260634970749]
[null,null,8.6867188365627804E-2,-0.37462655026717351,-0.26451830182378705,-7.555689680050022E-2,0.11263922441982527,0.25727303263528062,0.39682253583846172,0.51377702761268373]
[null,null,7.9976598505582003E-2,-0.36455329483086935,-0.25197832096949274,-8.4825424117062259E-2,9.4886585436444584E-2,0.24645071342667124,0.39520049987109879,0.47453453404113061]
[null,null,6.4994439589829311E-2,-0.43484852481091196,-0.3164978865058044,-0.11115846234837147,8.4249148433863608E-2,0.24506964229341199,0.40305282696885208,0.48873227388519891]
[null,null,6.8190598663648641E-2,-0.39440354432821745,-0.29149391974813949,-9.4609411440429197E-2,9.1168684611353121E-2,0.25195484690170922,0.39678419072713705,0.4658801738610554]
[null,null,8.9470870494425453E-2,-0.42262549011819706,-0.27273370886044557,-5.6205887163139401E-2,0.11360338992864974,0.27557207276356627,0.41716120796479961,0.49515034945170272]
[null,null,6.7110527459144725E-2,-0.44219258480665852,-0.29168932105631007,-8.0273491722432838E-2,9.5654322335067252E-2,0.2541284668927134,0.37972575086091231,0.47668114687151686]
[null,null,8.7263734330247408E-2,-0.30690299723869968,-0.21776585998045067,-8.0764912382736975E-2,9.3203307793959578E-2,0.25510084143059597,0.39720574088760435,0.48373137179699283]
[null,null,0.10558752028946333,-0.37631660192693389,-0.23063887868673885,-3.6288718614208959E-2,0.13351363710960296,0.2738385223447321,0.38803554477042462,0.4487581538900241]
[null,null,0.10166587793904386,-0.36952250883603949,-0.23097137254803246,-5.3479476926775828E-2,0.12612460643251969,0.27220765086643417,0.41627614477441738,0.48255835264916946]
[null,null,9.5209289771561928E-2,-0.35398142784212905,-0.22646476497659954,-3.7268580703089103E-2,0.11514423291343664,0.25883462492409109,0.38920767566935383,0.46094458981372732]
[null,null,9.4236105344229812E-2,-0.38694254080778262,-0.25191182688419772,-4.013678823504277E-2,0.12003998040665843,0.27787670619974553,0.39869710110825773,0.4600587070099515]
[null,null,8.598436885015609E-2,-0.38029335944170078,-0.24350686790440279,-5.2286636049313655E-2,0.11823476652998485,0.25358718423984039,0.38410024453874536,0.46256983215533082]
[null,null,0.10532187759078837,-0.33734152384175825,-0.22898969306604003,-4.2528720981973252E-2,0.11783742806146072,0.28030430599928335,0.41700639576746734,0.49129338094138686]
[null,null,8.9287827615721641E-2,-0.44579809489167038,-0.29650660616006125,-7.229174694677859E-2,0.12236491610304308,0.28725087057809601,0.41491859961180966,0.4953653552370183]
[null,null,0.10829472061186982,-0.31825822663966802,-0.21111142224995669,-5.8253754185615569E-2,0.12797572676741303,0.28709213458440624,0.4121535153301854,0.47672271671945599]
[null,null,9.4446382096876114E-2,-0.30608397182196279,-0.20691909165720218,-5.0072124180700825E-2,0.10817204647557266,0.25852758510839247,0.37698969848968389,0.46446850788685801]
[null,null,0.11277279815249824,-0.33596361852887102,-0.21447557483383126,-2.9458806953903047E-2,0.14146341026681969,0.28029310719220119,0.38953794648672829,0.45115479613024861]
[null,null,9.533749416681378E-2,-0.34254086224634056,-0.23843538033113054,-4.793114716776422E-2,0.10877904893477695,0.25524802033410299,0.40453268482754567,0.46957247370428495]
[null,null,7.9430245578611822E-2,-0.38977306209008844,-0.21877945523141798,-6.5781200686553187E-2,9.8333603766389874E-2,0.24092504578187052,0.3776887072672695,0.45061357042677569]
[null,null,8.8601431063210737E-2,-0.37683989727310185,-0.24358470302211208,-5.3993633953328443E-2,0.1130542165630508,0.2476345264484115,0.39854350180063164,0.45314706155256829]
[null,null,0.10639110042923809,-0.38689119826904772,-0.22991768070205632,-3.1040942405066149E-2,0.13553189750454731,0.2705582760661065,0.39977770404756197,0.45754889931009302]
[null,null,8.6303608895326775E-2,-0.35404763289678448,-0.24417952317119013,-6.4120821178675597E-2,0.11376485306809682,0.26671242323787198,0.37050343795003027,0.44471905966836939]
[null,null,0.1004313444157806,-0.33900189615737347,-0.20664881331004559,-4.9863079426968375E-2,0.12589995786909006,0.26648149779266039,0.36630930023351976,0.45819095022001549]
[null,null,9.853616878122165E-2,-0.36531206564746177,-0.23083592266641315,-4.1848226163978937E-2,0.11824303111410722,0.26257497168799487,0.41246466974279572,0.4694551265627952]
[null,null,8.4656329275989275E-2,-0.3709426574501169,-0.22304811155950663,-6.3608600409339203E-2,0.11237083272709282,0.26239687553835034,0.38383239336742619,0.44289286764626046]
[null,null,0.11193942480999378,-0.31286276264550117,-0.22338908570938243,-2.4620051911360817E-2,0.12133327101373981,0.27478848412979123,0.38827274848627719,0.45970252955307678]
[null,null,0.1029874659520409,-0.34837573996261828,-0.20499238970861949,-2.8434677889164581E-2,0.13443355635193838,0.2705982163221391,0.3776090501598563,0.43651078585949049]
[null,null,0.10565137763363522,-0.40950818677812806,-0.21207543661633838,-1.4271586399715484E-2,0.12507115555933843,0.26379621016637189,0.37861751565011792,0.4752050982206818]
[null,null,0.10769705944359335,-0.34521847691969237,-0.18445796690962732,-3.5011408299069395E-2,0.12756375636850548,0.27422912126676569,0.40365190118276778,0.47666907134295694]
[null,null,0.1199067347968184,-0.30833519091619255,-0.20338297352333559,-2.0082772296030706E-2,0.13844490339802229,0.28040429563461056,0.40690253075606841,0.49606918831601521]
[null,null,0.10751045914337411,-0.32169755814566159,-0.17897035201176534,-3.0951850965063206E-2,0.13188323439089603,0.27302231086671291,0.38756841342928916,0.4647650521232598]
[null,null,0.10396836971650364,-0.33669679093875099,-0.18546016386871556,-3.8329307495680282E-2,0.12461096569124094,0.27708126301845143,0.3703627192339054,0.44930222763058453]
[null,null,0.1022958436082325,-0.3514857783512389,-0.21442562362578596,-4.7348340414971997E-2,0.1187400925619059,0.27940421535990684,0.390349823261887,0.46157849220306585]
[null,null,0.10872321417571906,-0.30558569666168761,-0.19599678427449324,-3.9085394089294984E-2,0.12784197588666701,0.27006808491728601,0.40861571854108952,0.47359398875072994]
[null,null,0.1175979524280653,-0.30571454526924718,-0.200319161814908,-1.9064343039231768E-2,0.14236637575267269,0.27485611092523787,0.40277985120157062,0.4693760817142148]
[null,null,0.12241325771251257,-0.35376817116711035,-0.15562045409035208,-9.8817060188342125E-3,0.13830975380326282,0.27612633820080756,0.40494408567176943,0.48140135217077479]
[null,null,0.11727735255466044,-0.28542634967286251,-0.18715664939674806,-3.5165073502351818E-2,0.13087556251163851,0.29502394295672146,0.41991361040666286,0.46637003149355494]
[null,null,0.10930508771419838,-0.28148053235703513,-0.19751904993322739,-2.1888527946500078E-2,0.11642733019283567,0.25840675944190206,0.40990522341279223,0.47939089770510623]
[null,null,0.11068244136660899,-0.32563847998446821,-0.22392429136356201,-3.2964356417816115E-2,0.12839545473719433,0.27856180436249839,0.40121666750407969,0.48576949848981787]
[null,null,0.11433540266410359,-0.32605893634789029,-0.20224121899763547,-2.5359598582989775E-2,0.1372195914895003,0.28125031911553022,0.4006574709129932,0.47307050150923563]
[null,null,9.8686052694786905E-2,-0.33589314895176248,-0.2000172897214581,-2.8133446347126608E-2,0.12057108240795075,0.24628660258199059,0.37974868426148162,0.44601356108764584]
[null,null,0.11990671685660004,-0.28532288778259357,-0.16514236511057728,-1.5961334939982676E-2,0.13006263204645535,0.27161571914684024,0.40392754246145612,0.46188808111181617]
[null,null,0.12564500095694864,-0.32185362864725547,-0.1939653489627835,-4.7992927592513113E-3,0.1515935241210761,0.2893294853575058,0.4044043868964427,0.49388088252155526]
[null,null,0.11548173138440158,-0.32355854394296774,-0.1882336478355921,-2.2152303068197293E-2,0.12983814048535414,0.28605528520165113,0.38950086950126783,0.45428994548256524]
[null,null,0.10571492603019479,-0.35697498384914034,-0.2256743141915292,-5.2010261007673024E-2,0.13089874989529807,0.27762662768180968,0.40383755256923187,0.46527294545145426]
[null,null,0.12409183823887436,-0.30948321490730724,-0.19615577054855782,-2.3650167840618679E-2,0.1460095441102271,0.28046142368472321,0.39949207526341524,0.49199124839296388]
[null,null,0.1197154404905157,-0.35865812157133259,-0.21107682880216086,-2.3904050747650549E-2,0.14630755751008628,0.29578610220833845,0.42534429224107528,0.48716854973042106]
[null,null,0.13752347884972899,-0.26004809323768879,-0.15921692946677313,3.6769746981594794E-3,0.15523777016727502,0.29367860092427023,0.41702289432447126,0.48076970430996047]
[null,null,0.11512739898544706,-0.33051064721507312,-0.19923111898071746,-3.9912765207289091E-2,0.12974896001868452,0.28420921401634458,0.42916337337392485,0.50453617509948845]
[null,null,0.10765363851076204,-0.34531156488178449,-0.16176045655593901,-3.0898738193989913E-2,0.1225993234995162,0.26854252415823759,0.39471628553780436,0.46225599419309071]
[null,null,0.12138880586946137,-0.28341696596867383,-0.17477387089344118,-1.7433208908224043E-2,0.13571381241728514,0.27876142905636281,0.40512602436728812,0.47740977366395404]
[null,null,0.13702826194252918,-0.25324931923752658,-0.13224445586157435,6.2316974551990326E-3,0.14845566355289846,0.28102174106619959,0.41418046672967035,0.48232734352211865]
[null,null,0.11665482976510434,-0.29904442353411276,-0.18937864410010172,-1.3457404681270855E-2,0.13676393023424788,0.2677712321460527,0.40079226633028786,0.45899306673538809]
[null,null,0.12215168946804918,-0.26491184597789263,-0.16559771058093561,-4.3111224485794606E-3,0.13680114639815091,0.26981014878050308,0.39689355462588538,0.48031889618089729]
[null,null,0.1258916995158911,-0.27811030619587396,-0.1743073423066529,-1.5540664254947906E-2,0.13499827660631819,0.27819594828254474,0.40141432770147922,0.48105983830182503]
[null,null,0.1334760987255337,-0.27493032718333144,-0.14267221286784454,4.2058385055886577E-3,0.14611498521252375,0.2897760621876766,0.40577836061207384,0.45878148187804507]
[null,null,0.12870948519334507,-0.27024683297060259,-0.17100229492597557,-1.4541702697320812E-2,0.1521520479504499,0.28590416226865845,0.40843753335397875,0.47216070251511061]
[null,null,0.12364896950029532,-0.25564416185042144,-0.16793041380973425,-1.5289446450759726E-3,0.14136896242657629,0.26079694275750293,0.38415693880510587,0.46023845230201099]
[null,null,0.12307367245422818,-0.30524290810123872,-0.16075284938096573,6.2599497036399925E-3,0.15330254272684204,0.27703302781082484,0.39001364042028863,0.44500702172105772]
[null,null,0.13412674718836778,-0.26712707968242783,-0.15141717746500857,-5.0260808288963834E-3,0.12866859171823919,0.29102649057454477,0.42663524349984949,0.48479123260630519]
[null,null,0.13042829539972661,-0.28470079889695848,-0.15610103339975512,-1.4558116497586565E-2,0.14674318375335216,0.28632013077544427,0.40556522481078777,0.49361415489932564]
[null,null,0.12964407493270472,-0.22408818238386888,-0.1517966136637362,-7.3216352535178022E-3,0.14984182190243303,0.27944951156303255,0.3875326886091135,0.48078286367567952]
[null,null,0.11813236207455141,-0.26851809787079262,-0.16127481283596956,-5.9551127666857455E-3,0.12475802843011943,0.26182845315833914,0.40261040813338089,0.45455101574509493]
[null,null,0.10960155442224213,-0.3010151746921072,-0.18130658510133926,-2.5783179760134906E-2,0.12677312511771005,0.27344554606555366,0.38824752743399726,0.4515775723919021]
[null,null,0.11757746647669068,-0.35792678696536401,-0.19572458914176497,-1.1389399098334725E-2,0.14089800254264973,0.27712739565999561,0.41017942614184288,0.48700831532850314]

{"sheet":"Sim Hit Rates","index":3,"n_rows":119,"n_cols":20,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Initial State",1]
[null,null,"…this is called \"Markov property\": only the current state affects the next state"]
[]
[null,"Transition Probabilities π",null,"From State…"]
[null,null,null,1,2,3,4,null,null,"Eigenvalues",null,null,null,null,"Det",null,"Eigenvectors π"]
[null,"To State…",1,0.9,0,0,0,null,"π",{"$f":"_xll.apaEigenvalues(D7:G10)","v":0.9},0.9,0.94763932022500208,0.99236067977499787,null,{"$f":"MDETERM(D7:G10)","v":0.76139999999999997},null,{"$f":"_xll.apaEigenvectors(D7:G10)","v":1},0,0,0]
[null,null,2,0.1,0.9,0,0,null,"π'",{"$f":"_xll.apaEigenvalues(TRANSPOSE(D7:G10))","v":0.76679225864866962},1.0704846264236429,0.90944097405279989,0.99328214087488731,null,{"$f":"MDETERM(TRANSPOSE(D7:G10))","v":0.76139999999999997},null,0,1,0,0]
[null,null,3,0,0.1,0.95,0.01,null,null,null,null,null,null,null,null,null,0,0,0.9732489894677302,0.22975292054736096]
[null,null,4,0,0,0.05,0.99,null,null,null,null,null,null,null,null,null,0,0,-0.22975292054736096,0.9732489894677302]
[null,null,null,{"$f":"SUM(D7:D10)","v":1},{"$f":"SUM(E7:E10)","v":1},1,1,null,null,null,null,null,null,null,null,null,"…equilibrium is also known as Perron-Frobeniuseigenvector."]
[]
[]
[null,"nObs",100]
[null,"Show States?",true]
[null,"nPaths",500]
[]
[null,null,null,"Simulated Hit Rates"]
[null,null,null,"Regime 1","Regime 2","Regime 3","Regime 4"]
[null,null,null,{"$f":"_xll.apaMarkovRegimeSwitching.Simulation.HitRates(C14,C16,C2,D7:G10)","v":0.90200000000000002},9.8000000000000004E-2,0,0]
[null,null,null,0.8,0.188,1.2E-2,0]
[null,null,null,0.7,0.27800000000000002,2.1999999999999999E-2,0]
[null,null,null,0.626,0.32400000000000001,0.05,0]
[null,null,null,0.56000000000000005,0.36,7.5999999999999998E-2,4.0000000000000001E-3]
[null,null,null,0.51200000000000001,0.39,9.1999999999999998E-2,6.0000000000000001E-3]
[null,null,null,0.46200000000000002,0.38800000000000001,0.13800000000000001,1.2E-2]
[null,null,null,0.40799999999999997,0.40400000000000003,0.17,1.7999999999999999E-2]
[null,null,null,0.36199999999999999,0.42599999999999999,0.186,2.5999999999999999E-2]
[null,null,null,0.32,0.42599999999999999,0.218,3.5999999999999997E-2]
[null,null,null,0.28199999999999997,0.43,0.24199999999999999,4.5999999999999999E-2]
[null,null,null,0.26200000000000001,0.39800000000000002,0.28399999999999997,5.6000000000000001E-2]
[null,null,null,0.224,0.39600000000000002,0.314,6.6000000000000003E-2]
[null,null,null,0.2,0.38600000000000001,0.33600000000000002,7.8E-2]
[null,null,null,0.184,0.372,0.35,9.4E-2]
[null,null,null,0.17199999999999999,0.35,0.36599999999999999,0.112]
[null,null,null,0.154,0.32600000000000001,0.38600000000000001,0.13400000000000001]
[null,null,null,0.13800000000000001,0.30599999999999999,0.39600000000000002,0.16]
[null,null,null,0.122,0.28999999999999998,0.40400000000000003,0.184]
[null,null,null,0.11799999999999999,0.26800000000000002,0.41599999999999998,0.19800000000000001]
[null,null,null,0.106,0.25600000000000001,0.42799999999999999,0.21]
[null,null,null,9.6000000000000002E-2,0.25600000000000001,0.432,0.216]
[null,null,null,8.4000000000000005E-2,0.23799999999999999,0.44800000000000001,0.23]
[null,null,null,7.5999999999999998E-2,0.22,0.45800000000000002,0.246]
[null,null,null,7.0000000000000007E-2,0.21199999999999999,0.44400000000000001,0.27400000000000002]
[null,null,null,0.06,0.19800000000000001,0.45600000000000002,0.28599999999999998]
[null,null,null,5.1999999999999998E-2,0.188,0.44400000000000001,0.316]
[null,null,null,4.3999999999999997E-2,0.17799999999999999,0.442,0.33600000000000002]
[null,null,null,0.04,0.16600000000000001,0.44400000000000001,0.35]
[null,null,null,3.7999999999999999E-2,0.15,0.436,0.376]
[null,null,null,3.4000000000000002E-2,0.14599999999999999,0.42799999999999999,0.39200000000000002]
[null,null,null,2.5999999999999999E-2,0.13800000000000001,0.42199999999999999,0.41399999999999998]
[null,null,null,0.02,0.13600000000000001,0.41399999999999998,0.43]
[null,null,null,0.02,0.126,0.40600000000000003,0.44800000000000001]
[null,null,null,0.02,0.11600000000000001,0.40400000000000003,0.46]
[null,null,null,1.2E-2,0.108,0.41,0.47]
[null,null,null,8.0000000000000002E-3,0.104,0.40200000000000002,0.48599999999999999]
[null,null,null,8.0000000000000002E-3,9.8000000000000004E-2,0.38600000000000001,0.50800000000000001]
[null,null,null,6.0000000000000001E-3,9.1999999999999998E-2,0.38,0.52200000000000002]
[null,null,null,4.0000000000000001E-3,7.8E-2,0.39400000000000002,0.52400000000000002]
[null,null,null,4.0000000000000001E-3,7.0000000000000007E-2,0.38,0.54600000000000004]
[null,null,null,2E-3,0.06,0.39,0.54800000000000004]
[null,null,null,2E-3,5.6000000000000001E-2,0.38200000000000001,0.56000000000000005]
[null,null,null,2E-3,0.05,0.378,0.56999999999999995]
[null,null,null,2E-3,4.5999999999999999E-2,0.36399999999999999,0.58799999999999997]
[null,null,null,0,4.3999999999999997E-2,0.34799999999999998,0.60799999999999998]
[null,null,null,0,3.7999999999999999E-2,0.35799999999999998,0.60399999999999998]
[null,null,null,0,0.03,0.35599999999999998,0.61399999999999999]
[null,null,null,0,2.5999999999999999E-2,0.33800000000000002,0.63600000000000001]
[null,null,null,0,2.1999999999999999E-2,0.34399999999999997,0.63400000000000001]
[null,null,null,0,0.02,0.33,0.65]
[null,null,null,0,0.02,0.312,0.66800000000000004]
[null,null,null,0,1.6E-2,0.28599999999999998,0.69799999999999995]
[null,null,null,0,1.4E-2,0.27800000000000002,0.70799999999999996]
[null,null,null,0,1.4E-2,0.26800000000000002,0.71799999999999997]
[null,null,null,0,1.4E-2,0.26200000000000001,0.72399999999999998]
[null,null,null,0,0.01,0.26200000000000001,0.72799999999999998]
[null,null,null,0,6.0000000000000001E-3,0.26800000000000002,0.72599999999999998]
[null,null,null,0,6.0000000000000001E-3,0.26400000000000001,0.73]
[null,null,null,0,4.0000000000000001E-3,0.26400000000000001,0.73199999999999998]
[null,null,null,0,4.0000000000000001E-3,0.26,0.73599999999999999]
[null,null,null,0,4.0000000000000001E-3,0.26,0.73599999999999999]
[null,null,null,0,4.0000000000000001E-3,0.26400000000000001,0.73199999999999998]
[null,null,null,0,2E-3,0.26200000000000001,0.73599999999999999]
[null,null,null,0,2E-3,0.26400000000000001,0.73399999999999999]
[null,null,null,0,2E-3,0.254,0.74399999999999999]
[null,null,null,0,2E-3,0.252,0.746]
[null,null,null,0,2E-3,0.246,0.752]
[null,null,null,0,2E-3,0.246,0.752]
[null,null,null,0,2E-3,0.24199999999999999,0.75600000000000001]
[null,null,null,0,2E-3,0.22800000000000001,0.77]
[null,null,null,0,2E-3,0.218,0.78]
[null,null,null,0,2E-3,0.19600000000000001,0.80200000000000005]
[null,null,null,0,2E-3,0.20200000000000001,0.79600000000000004]
[null,null,null,0,2E-3,0.19800000000000001,0.8]
[null,null,null,0,2E-3,0.192,0.80600000000000005]
[null,null,null,0,2E-3,0.19400000000000001,0.80400000000000005]
[null,null,null,0,2E-3,0.184,0.81399999999999995]
[null,null,null,0,2E-3,0.18,0.81799999999999995]
[null,null,null,0,2E-3,0.184,0.81399999999999995]
[null,null,null,0,2E-3,0.17799999999999999,0.82]
[null,null,null,0,2E-3,0.17799999999999999,0.82]
[null,null,null,0,2E-3,0.182,0.81599999999999995]
[null,null,null,0,2E-3,0.182,0.81599999999999995]
[null,null,null,0,2E-3,0.17599999999999999,0.82199999999999995]
[null,null,null,0,2E-3,0.17599999999999999,0.82199999999999995]
[null,null,null,0,2E-3,0.17199999999999999,0.82599999999999996]
[null,null,null,0,2E-3,0.17799999999999999,0.82]
[null,null,null,0,2E-3,0.17399999999999999,0.82399999999999995]
[null,null,null,0,2E-3,0.17399999999999999,0.82399999999999995]
[null,null,null,0,2E-3,0.17799999999999999,0.82]
[null,null,null,0,2E-3,0.17,0.82799999999999996]
[null,null,null,0,2E-3,0.17599999999999999,0.82199999999999995]
[null,null,null,0,2E-3,0.17399999999999999,0.82399999999999995]
[null,null,null,0,2E-3,0.17199999999999999,0.82599999999999996]
[null,null,null,0,0,0.16600000000000001,0.83399999999999996]
[null,null,null,0,0,0.17,0.83]
[null,null,null,0,0,0.17,0.83]
[null,null,null,0,0,0.17199999999999999,0.82799999999999996]
[null,null,null,0,0,0.17,0.83]