{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Permanent portfolio Lumpsum","Permanent portfolio SIP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":152,"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":"Permanent portfolio Lumpsum","index":0,"n_rows":61,"n_cols":43,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,8],[27,3,27,5],[0,25,0,36],[1,35,1,36],[2,35,2,36],[17,1,17,4],[8,2,8,4],[6,0,6,5],[4,3,4,4],[7,2,7,4],[9,0,9,5],[10,0,10,5],[12,0,12,7],[0,12,0,23],[1,22,1,23],[2,22,2,23],[22,0,22,2],[25,3,25,4],[26,3,26,4],[13,6,13,7],[15,6,15,7],[14,6,14,7],[16,6,16,7],[17,5,17,7]]}
["The Permanent Portfolio Simulator: Indian Edition for Lump sum investments with annual rebalancing",null,null,null,null,null,null,null,null,null,"Annual ",null,"Permanent portfolio of a lumpsum investment with annual rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,"Permanent portfolio of a lumpsum investment with annual rebalancing"]
["Enter no of years (max 32)",null,null,25,null,null,"Enter data only in green cells",null,null,null,"CAGR of",null,"Year of","Year","Sensex","Investment","Total",null,"FD","Monthly","Total",null,"Asset Allocation",null,null,"Year of","Year","Gold","Investment","Total",null,"Liquid","Monthly","Total",null,"Asset Allocation"]
["Choose a starting year between",null,null,1979,"and",{"$f":"2012-time1+1","v":1988},null,null,null,null,"permanent",null,"return",null,"return ",null,null,null,"return",null,null,null,"After investment",null,null,"return",null,"return ",null,null,null,"return",null,null,null,"After investment"]
["Starting year",null,1988,null,null,null,null,null,null,null,"portfolio",null,null,null,null,null,null,null,null,null,null,null,"Equity","Debt",null,null,null,null,null,null,null,null,null,null,null,"Equity","Debt"]
[null,null,null,"Lumpsum investment",null,100000,null,null,null,null,{"$f":"IF(N5=0,\"\",((Q5+U5+AD5+AH5)/cont1)^(1/N5)-1)","v":""},null,1979,{"$f":"IF(S3=start-1+time1,0,IF(N3<>0,N3+1,IF(M5=start,1,0)))","v":0},0.28999999999999998,{"$f":"IF(S3=start-1+time1,0,IF(M5=start,cont1*eqper,0))","v":0},{"$f":"IF(N5=0,0,(P5+eqper*(Q3+U3))*(1+O5))","v":0},{"$f":"IF(N5=time1,Q5,0)","v":0},7.0000000000000007E-2,{"$f":"IF(S3=start-1+time1,0,IF(M5=start,cont1*bondper,0))","v":0},{"$f":"IF(N5=0,0,(T5+bondper*(Q3+U3))*(1+S5))","v":0},{"$f":"IF(N5=time1,U5,0)","v":0},{"$f":"IF(N5=0,0,Q5/(Q5+U5+AD5+AH5))","v":0},{"$f":"IF(N5=0,0,U5/(Q5+U5+AD5+AH5))","v":0},null,1979,{"$f":"IF(AF3=start-1+time1,0,IF(AA3<>0,AA3+1,IF(Z5=start,1,0)))","v":0},0.46,{"$f":"IF(AF3=start-1+time1,0,IF(Z5=start,cont1*eqper,0))","v":0},{"$f":"IF(AA5=0,0,(AC5+eqper*(AD3+AH3))*(1+AB5))","v":0},{"$f":"IF(AA5=time1,AD5,0)","v":0},{"$f":"AQ5+liqpl","v":0.05},{"$f":"IF(AF3=start-1+time1,0,IF(Z5=start,cont1*bondper,0))","v":0},{"$f":"IF(AA5=0,0,(AG5+bondper*(AD3+AH3))*(1+AF5))","v":0},{"$f":"IF(AA5=time1,AH5,0)","v":0},{"$f":"IF(AA5=0,0,AD5/(Q5+U5+AD5+AH5))","v":0},{"$f":"IF(AA5=0,0,AH5/(Q5+U5+AD5+AH5))","v":0},null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"M5+1","v":1980},{"$f":"IF(M5=start-1+time1,0,IF(N5<>0,N5+1,IF(M6=start,1,0)))","v":0},0.34108527131782945,{"$f":"IF(S5=start-1+time1,0,IF(M6=start,cont1*eqper,0))","v":0},{"$f":"IF(N6=0,0,(P6+eqper*(Q5+U5+AD5+AH5))*(1+O6))","v":0},0,7.4999999999999997E-2,{"$f":"IF(S5=start-1+time1,0,IF(M6=start,cont1*bondper,0))","v":0},{"$f":"IF(N6=0,0,(T6+bondper*(Q5+U5+AD5+AH5))*(1+S6))","v":0},0,0,0,null,{"$f":"Z5+1","v":1980},{"$f":"IF(Z5=start-1+time1,0,IF(AA5<>0,AA5+1,IF(Z6=start,1,0)))","v":0},0.31,{"$f":"IF(AF5=start-1+time1,0,IF(Z6=start,cont1*eqper,0))","v":0},{"$f":"IF(AA6=0,0,(AC6+gper*(Q5+U5+AD5+AH5))*(1+AB6))","v":0},0,0.05,{"$f":"IF(AF5=start-1+time1,0,IF(Z6=start,cont1*bondper,0))","v":0},{"$f":"IF(AA6=0,0,(AG6+lper*(Q5+U5+AD5+AH5))*(1+AF6))","v":0},0,0,0,null,null,null,null,null,0.05]
["The Permanent portfolio assest allocation",null,null,null,null,null,null,null,null,null,"",null,{"$f":"M6+1","v":1981},0,0.26011560693641617,0,0,0,0.08,0,0,0,0,0,null,{"$f":"Z6+1","v":1981},0,0.13,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["% in equities",0.25,"% in long term debt (FDs)",null,null,0.25,null,null,null,null,"",null,1982,0,-2.7522935779816515E-2,0,0,0,0.08,0,0,0,0,0,null,1982,0,0,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["% in gold",0.25,"% in short term (liquid) debt (SB acc!)",null,null,0.25,null,null,null,null,"",null,1983,0,0.15566037735849056,0,0,0,0.08,0,0,0,0,0,null,1983,0,0.08,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["Total must be 100% other wise you will get weird results!",null,null,null,null,null,null,null,null,null,"",null,1984,0,0.44489795918367347,0,0,0,0.08,0,0,0,0,0,null,1984,0,7.0000000000000007E-2,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["If you wish enhance SB acc returns by a small amount to make it resemble a liquid fund",null,null,null,null,null,null,null,null,null,"",null,1985,0,0.62146892655367236,0,0,0,8.5000000000000006E-2,0,0,0,0,0,null,1985,0,7.0000000000000007E-2,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["enter the incremental return here",null,null,null,null,null,null,null,null,null,"",null,1986,0,-0.11149825783972125,0,0,0,8.5000000000000006E-2,0,0,0,0,0,null,1986,0,0.09,0,0,0,0.05,0,0,0,0,0,null,null,null,null,null,0.05]
["Results",null,null,null,null,null,null,null,null,null,"",null,1987,0,-0.2196078431372549,0,0,0,0.09,0,0,0,0,0,null,1987,0,0.33,0,0,0,0.05,0,0,0,0,{"$f":"IF(AA13=0,0,AH13/(Q13+U13+AD13+AH13))","v":0},null,null,null,null,null,0.05]
["Start Year","Equity corpus","Debt Corpus","Gold Corpus","liq debt  corpus","Total corpus","Difference between",null,null,null,0.2409924623115578,null,1988,1,0.79396984924623115,25000,44849.246231155783,0,0.09,25000,27250.000000000004,0,0.36139821629227703,0.21958231679540002,null,1988,1,0.03,25000,25750,0,0.05,25000,26250,0,0.20749521678831376,0.21152425012400916,null,null,null,null,null,0.05]
[{"$f":"start","v":1988},{"$f":"MAX(R3:R58)","v":376314.96845932479},{"$f":"MAX(V3:V58)","v":379019.40138370259},{"$f":"MAX(AE3:AE58)","v":396405.61245634948},{"$f":"MAX(AI3:AI38)","v":361633.19031105563},{"$f":"B15+C15+D15+E15","v":1513373.1726104324},"AM and GM",null,null,null,0.14880158391803655,null,1989,2,9.3837535014005602E-2,0,33936.103398645901,0,0.09,0,33817.044597989952,0,0.25714135201696281,0.25623921718402232,null,1989,2,0.02,0,31645.307788944727,0,0.05,0,32576.052135678397,0,0.23978348764009427,0.2468359431589206,null,null,null,null,null,0.05]
[null,"% Equity","%Debt","% Gold","%liq debt","CAGR",null,null,null,null,0.15792167570608728,null,1990,3,0.49551856594110116,0,49342.581706795929,0,0.09,0,35963.053408543077,0,0.31782226442921241,0.23164290709413038,null,1990,3,7.0000000000000007E-2,0,35303.180868936775,0,0.05,0,34643.308329330481,0,0.22739257852359585,0.22314224995306134,null,null,null,null,null,0.05]
[null,{"$f":"B15/F15","v":0.24865973262246704},{"$f":"C15/F15","v":0.25044675579251102},{"$f":"D15/F15","v":0.26193513908574545},{"$f":"E15/F15","v":0.23895837249927654},{"$f":"(F15/cont1)^(1/time1)-1","v":0.11480226197184074},{"$f":"AVERAGE(K4:K38)-F17","v":2.8330345751719638E-2},null,null,null,0.28790993606061388,null,1991,4,2.6686643835616439,0,142391.98473540301,0,0.12,0,43470.594807809757,0,0.51753957939793893,0.15799873423225386,null,1991,4,0.25,0,48516.288848001961,0,0.05,0,40753.682632321645,0,0.17633787302706905,0.148123813342738,null,null,null,null,null,0.05]
[null,"Final asset allocation",null,null,null,null,null,null,null,null,0.20229269907174596,null,1992,5,-0.46767794632438742,0,36614.78114846479,0,0.11,0,76349.282909031361,0,0.14574893611583237,0.30391624388186733,null,1992,5,-0.05,0,65343.980868089893,0,0.06,0,72910.126021237156,0,0.26010849701601257,0.29022632298628775,null,null,null,null,null,0.06]
[null,null,null,null,null,null,null,null,null,null,0.2067331101885963,null,1993,6,0.6567295046032442,0,104050.13897501589,0,0.1,0,69084.997010376392,0,0.33695762661992001,0.22372595420800248,null,1993,6,0.1,0,69084.997010376392,0,0.06,0,66572.815300908158,0,0.22372595420800248,0.21559046496407511,null,null,null,null,null,0.06]
[null,null,null,null,null,null,null,null,null,null,0.1767695762431043,null,1994,7,-0.13707329981476582,0,66616.419978530233,0,0.11,0,85690.043152327824,0,0.21317745208818784,0.27421445154854363,null,1994,7,0.03,0,79514.184186394283,0,4.4999999999999998E-2,0,80672.15774250681,0,0.25445124783333328,0.25815684852993515,null,null,null,null,null,4.4999999999999998E-2]
["Click on the macro to find out the % difference",null,null,null,null,null,null,null,null,null,0.1620957272632555,null,1995,8,3.2505366452008584E-2,0,80662.624550460678,0,0.12,0,87497.985416732583,0,0.24251416676720405,0.2630648475103044,null,1995,8,0.06,0,82810.593340836189,0,4.4999999999999998E-2,0,81638.745321862079,0,0.24897208782225236,0.2454488979002393,null,null,null,null,null,4.4999999999999998E-2]
["between the two corpuses for all possible ",null,null,null,null,null,null,null,null,null,0.14825535510565802,null,1996,9,-1.782001782001782E-3,0,83004.309277180379,0,0.11,0,92299.260744794898,0,0.23919622666351156,0.26598179162315033,null,1996,9,0.02,0,84815.536900622334,0,4.4999999999999998E-2,0,86894.34907955915,0,0.24441570041046246,0.25040628130287573,null,null,null,null,null,4.4999999999999998E-2]
["investment durations between",null,null,null,null,null,null,null,null,null,0.1371673601222887,null,1997,10,0.15828622433799464,0,100485.22643680422,0,0.105,0,95862.46722059579,0,0.27788068333094212,0.26509695844495312,null,1997,10,-0.14000000000000001,0,74607.893040463692,0,4.4999999999999998E-2,0,90657.265380563433,0,0.20631980476258796,0.25070255346151676,null,null,null,null,null,4.4999999999999998E-2]
[{"$f":"D3","v":1979},null,{"$f":"F3","v":1988},null,null,null,null,null,null,null,0.12587358655130054,null,1998,11,-3.9301310043668124E-2,0,86850.248315779449,0,0.09,0,98539.502191371401,0,0.23571386479667006,0.2674388081449855,null,1998,11,-0.02,0,88595.148759214644,0,4.4999999999999998E-2,0,94471.357605489087,0,0.24044957062576675,0.25639775643257784,null,null,null,null,null,4.4999999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,0.12574165633148304,null,1999,12,0.33716577540106951,0,123171.77410535725,0,8.5000000000000006E-2,0,99943.759676490547,0,0.2973352200435212,0.24126306526986696,null,1999,12,0.03,0,94877.486144502545,0,4.4999999999999998E-2,0,96259.197107771994,0,0.22903314030227001,0.23236857438434189,null,null,null,null,null,4.4999999999999998E-2]
["Start Year","Final Corpus","CAGR","For a duration of",null,{"$f":"time1","v":25},"years",null,null,null,0.11260400370471491,null,2000,13,-0.27934413117376522,0,74633.322844979848,0,8.5000000000000006E-2,0,112365.91387050568,0,0.18642525182797873,0.28067682091149221,null,2000,13,0.02,0,105634.31534370119,0,0.04,0,107705.57642887181,0,0.26386208048822307,0.26903584677230591,null,null,null,null,null,0.04]
[1979,1480776.835542639,{"$f":"IF(A27=\"\",\"\",(B27/cont1)^(1/time1)-1)","v":0.11383172716108603},"the average CAGR is",null,{"$f":"SUM(C27:C61)/(C24-A24+1)","v":0.11222359982045324},null,null,null,null,0.10605814613837361,null,2001,14,-3.7458379578246395E-2,0,96335.768363282128,0,7.4999999999999997E-2,0,107591.14078116574,0,0.23490710030242004,0.26235242972086076,null,2001,14,0.02,0,102086.47776445493,0,0.04,0,104088.17340689524,0,0.24892974727002601,0.25381072270669319,null,null,null,null,null,0.04]
[1980,1313187.7766122101,0.10849330200419516,"Variation in the average CAGR is",null,null,{"$f":"STDEV(C27:C61)","v":2.2534202468561266E-3},null,null,null,0.10084271818957435,null,2002,15,-0.1210723551455751,0,90112.39963987231,0,4.2500000000000003E-2,0,106882.71915730486,0,0.21325805536141348,0.25294633069721711,null,2002,15,0.16,0,118929.45249158143,0,0.04,0,106626.40568210749,0,0.28145586916908572,0.25233974477228371,null,null,null,null,null,0.04]
[1981,1361625.8981181667,0.11010053542780529,null,null,null,null,null,null,null,0.10932430757357614,null,2003,16,0.83371597244998363,0,193709.61891145559,0,0.04,0,109863.25401242518,0,0.36831102288159406,0.20888920070052217,null,2003,16,7.0000000000000007E-2,0,113032.38633970669,0,3.5000000000000003E-2,0,109335.06529121159,0,0.21491485072072958,0.20788492569715428,null,null,null,null,null,3.5000000000000003E-2]
[1982,1388360.5705332805,0.11096426779032331,null,null,null,null,null,null,null,0.10755987922498744,null,2004,17,0.16133071006975497,0,152697.66264238552,0,5.2499999999999998E-2,0,138388.04789848148,0,0.26889933596193166,0.24370022134602276,null,2004,17,7.0000000000000007E-2,0,140689.03681840876,0,3.5000000000000003E-2,0,136087.05897855424,0,0.24775224402873577,0.23964819866330977,null,null,null,null,null,3.5000000000000003E-2]
[1983,1487104.5622187268,0.11402172490231988,null,null,null,null,null,null,null,0.11443504788454217,null,2005,18,0.73725550592946254,0,246630.26241686134,0,0.06,0,150483.37867952496,0,0.35080086313184,0.21404388338421448,null,2005,18,0.12,0,159001.30577459242,0,3.5000000000000003E-2,0,146934.2423899135,0,0.22615957489652852,0.20899567858741697,null,null,null,null,null,3.5000000000000003E-2]
[1984,1371252.9745398029,0.11041342373146357,null,null,null,null,null,null,null,0.11639228855138373,null,2006,19,0.15886524822695036,0,203684.818307145,0,7.4999999999999997E-2,0,188944.46961386479,0,0.25144264060937138,0.23324613372316688,null,2006,19,0.34,0,235521.47840239891,0,3.5000000000000003E-2,0,181913.97772125585,0,0.29074401785027315,0.22456720781718859,null,null,null,null,null,3.5000000000000003E-2]
[1985,1511634.6506416467,0.11475100752236966,null,null,null,null,null,null,null,0.11549404664471608,null,2007,20,0.19675642594859241,0,242362.54696746351,0,8.2500000000000004E-2,0,219223.77135708736,0,0.27234560524998203,0.24634429470426722,null,2007,20,0.08,0,218717.48089205945,0,3.5000000000000003E-2,0,209604.25252155695,0,0.24577537023612803,0.23553472980962267,null,null,null,null,null,3.5000000000000003E-2]
[1986,1392943.3294644663,0.11111072058463423,null,null,null,null,null,null,null,0.11003999571826606,null,2008,21,-0.37944259780107387,0,138059.75719563616,0,0.08,0,240275.17396930518,0,0.15415440402363956,0.26828582779866939,null,2008,21,0.28999999999999998,0,286995.34668555896,0,3.5000000000000003E-2,0,230263.70838725078,0,0.32045251653729956,0.2571072516403915,null,null,null,null,null,3.5000000000000003E-2]
[1987,1477964.3036147733,0.1137470271084946,null,null,null,null,null,null,null,0.11725568510155671,null,2009,22,0.80541821178409556,0,404230.42327948759,0,0.06,0,237332.40635300404,0,0.35259194407775496,0.20701434065688687,null,2009,22,0.22,0,273156.16580251406,0,3.5000000000000003E-2,0,231734.94393901806,0,0.2382617883032094,0.20213192696214893,null,null,null,null,null,3.5000000000000003E-2]
[1988,1513373.1726104324,0.11480226197184074,null,null,null,null,null,null,null,0.11702122042382213,null,2010,23,0.11000171164489074,0,318141.45875679853,0,8.2500000000000004E-2,0,310259.09734309511,0,0.24957870364357007,0.24339507215156117,null,2010,23,0.22,0,349668.45150907716,0,3.5000000000000003E-2,0,296644.95681302861,0,0.27431130533478487,0.23271491887008389,null,null,null,null,null,3.5000000000000003E-2]
[null,null,"",null,null,null,null,null,null,null,0.11593086308792699,null,2011,24,-0.10542277049601645,0,285082.5216756679,0,0.09,0,347359.55530499486,0,0.20496308862557314,0.24973781942309087,null,2011,24,0.34,{"$f":"IF(AF36=start-1+time1,0,IF(Z37=start,cont1*eqper,0))","v":0},427029.17808136984,{"$f":"IF(AA37=time1,AD37,0)","v":0},0.04,{"$f":"IF(AF36=start-1+time1,0,IF(Z37=start,cont1*bondper,0))","v":0},331425.63074971986,{"$f":"IF(AA37=time1,AH37,0)","v":0},0.30701713580453371,0.23828195614680228,null,null,null,null,null,0.04]
[null,null,"",null,null,null,null,null,null,null,0.11480226197184074,null,2012,25,8.2222477591358312E-2,0,376314.96845932479,376314.96845932479,0.09,0,379019.40138370259,379019.40138370259,0.24865973262246704,0.25044675579251102,null,2012,25,0.14000000000000001,0,396405.61245634948,396405.61245634948,0.04,0,361633.19031105563,361633.19031105563,0.26193513908574545,0.23895837249927654,null,null,null,null,null,0.04]
[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,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Permanent portfolio SIP","index":1,"n_rows":69,"n_cols":52,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,8],[7,2,7,4],[12,0,12,5],[17,1,17,4],[19,0,19,2],[20,0,20,2],[24,2,24,3],[25,2,25,3],[26,2,26,4],[0,26,0,41],[1,38,1,41],[3,38,3,39],[3,40,3,41],[0,9,0,24],[3,21,3,22],[3,23,3,24],[1,21,1,24],[18,0,18,2],[8,2,8,4],[10,0,10,5],[9,0,9,5],[6,0,6,5]]}
["The Permanent Portfolio Simulator: Indian Edition for SIP investments with annual rebalancing",null,null,null,null,null,null,null,null,"Permanent portfolio of a SIP investment with annual rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permanent portfolio of a SIP investment with annual rebalancing"]
["Enter no of years (max 32)",null,null,25,null,null,"Enter data only in green cells",null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,"Year of","Year","Gold","Annual","invest. From","Total Gold",null,"lid debt","Annual","invest. From","Total liq debt ",null,"Asset Allocation"]
["Choose a starting year between",null,null,1979,"and",{"$f":"2012-time1+1","v":1988},null,null,null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Gold","liq debt","Gold","liq debt"]
["Starting year",null,1987,null,null,null,null,null,null,"return",null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,"return",null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,null,{"$f":"-1E-300","v":-1E-300}]
["monthly contribution in 1st year",null,null,1000,null,null,null,null,null,1979,{"$f":"IF(Q4=start-1+time1,0,IF(K4<>0,K4+1,IF(J5=start,1,0)))","v":0},0.28999999999999998,{"$f":"IF(K5=0,0,IF(Q4=start-1+time1,0,IF(M4<>0,M4*(1+inca),IF(J5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(K5=1,0,IF(K5=0,0,eqper*(O4+T4+AF4+AK4)))","v":0},{"$f":"IF(K5=0,0,(M5+N5)*(1+L5))","v":0},{"$f":"IF(K5=time1,O5,0)","v":0},7.0000000000000007E-2,{"$f":"IF(K5=0,0,IF(Q4=start-1+time1,0,IF(R4<>0,R4*(1+inca),IF(J5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(K5=1,0,IF(K5=0,0,bondper*(O4+T4+AF4+AK4)))","v":0},{"$f":"IF(K5=0,0,(R5+S5)*(1+Q5))","v":0},{"$f":"IF(K5=time1,T5,0)","v":0},{"$f":"IF(K5=0,0,(M5+N5)/(M5+N5+R5+S5+AD5+AE5+AI5+AJ5))","v":0},{"$f":"IF(K5=0,0,(R5+S5)/(M5+N5+R5+S5+AD5+AE5+AI5+AJ5))","v":0},{"$f":"IF(K5=0,0,O5/(O5+T5+AF5+AK5))","v":0},{"$f":"IF(K5=0,0,T5/(O5+T5+AF5+AK5))","v":0},null,1979,{"$f":"IF(AH4=start-1+time1,0,IF(AB4<>0,AB4+1,IF(AA5=start,1,0)))","v":0},0.46,{"$f":"IF(AB5=0,0,IF(AH4=start-1+time1,0,IF(AD4<>0,AD4*(1+inca),IF(AA5=start,12*cont1*gper1,0))))","v":0},{"$f":"IF(AB5=1,0,IF(AB5=0,0,gper1*(O4+T4+AF4+AK4)))","v":0},{"$f":"IF(AB5=0,0,(AD5+AE5)*(1+AC5))","v":0},{"$f":"IF(AB5=time1,AF5,0)","v":0},{"$f":"AZ5+liqpl1","v":7.0000000000000007E-2},{"$f":"IF(AB5=0,0,IF(AH4=start-1+time1,0,IF(AI4<>0,AI4*(1+inca),IF(AA5=start,12*cont1*lper1,0))))","v":0},{"$f":"IF(AB5=1,0,IF(AB5=0,0,lper1*(O4+T4+AF4+AK4)))","v":0},{"$f":"IF(AB5=0,0,(AI5+AJ5)*(1+AH5))","v":0},{"$f":"IF(AB5=time1,AK5,0)","v":0},{"$f":"IF(AB5=0,0,(AD5+AE5)/(M5+N5+R5+S5+AD5+AE5+AI5+AJ5))","v":0},{"$f":"IF(AB5=0,0,(AI5+AJ5)/(M5+N5+R5+S5+AD5+AE5+AI5+AJ5))","v":0},{"$f":"IF(AB5=0,0,AF5/(O5+T5+AF5+AK5))","v":0},{"$f":"IF(AB5=0,0,AK5/(O5+T5+AF5+AK5))","v":0},null,{"$f":"IF(Q4=start-1+time1,0,IF(K4<>0,K4+1,IF(J5=start,1,0)))","v":0},{"$f":"IF(AR4=time1,totalcorpus,IF(K5=0,-1E-300,IF(Q4=start-1+time1,-1E-300,IF(AS4<>-1E-300,-ABS(AS4*(1+inca)),IF(J5=start,-12*cont1,-1E-300)))))","v":-1E-300},{"$f":"IF(AR4=time1,DATE(YEAR(AT4)+1,1,1),IF(Q4=start-1+time1,0,IF(K4<>0,DATE(YEAR(AT4)+1,1,1),IF(J5=start,DATE(start,1,1),0))))","v":"00:00:00"},{"$f":"start-1+time1","v":2011},null,null,null,null,0.05]
["% increase or","decrease each year",null,null,null,null,null,null,null,{"$f":"J5+1","v":1980},{"$f":"IF(J5=start-1+time1,0,IF(K5<>0,K5+1,IF(J6=start,1,0)))","v":0},0.34108527131782945,0,0,{"$f":"IF(K6=0,0,(M6+N6)*(1+L6))","v":0},0,7.4999999999999997E-2,0,0,{"$f":"IF(K6=0,0,(R6+S6)*(1+Q6))","v":0},0,{"$f":"IF(K6=0,0,(M6+N6)/(M6+N6+R6+S6+AD6+AE6+AI6+AJ6))","v":0},{"$f":"IF(K6=0,0,(R6+S6)/(M6+N6+R6+S6+AD6+AE6+AI6+AJ6))","v":0},{"$f":"IF(K6=0,0,O6/(O6+T6+AF6+AK6))","v":0},{"$f":"IF(K6=0,0,T6/(O6+T6+AF6+AK6))","v":0},null,{"$f":"AA5+1","v":1980},{"$f":"IF(AA5=start-1+time1,0,IF(AB5<>0,AB5+1,IF(AA6=start,1,0)))","v":0},0.31,0,0,{"$f":"IF(AB6=0,0,(AD6+AE6)*(1+AC6))","v":0},0,7.0000000000000007E-2,0,0,{"$f":"IF(AB6=0,0,(AI6+AJ6)*(1+AH6))","v":0},0,{"$f":"IF(AB6=0,0,(AD6+AE6)/(M6+N6+R6+S6+AD6+AE6+AI6+AJ6))","v":0},{"$f":"IF(AB6=0,0,(AI6+AJ6)/(M6+N6+R6+S6+AD6+AE6+AI6+AJ6))","v":0},{"$f":"IF(AB6=0,0,AF6/(O6+T6+AF6+AK6))","v":0},{"$f":"IF(AB6=0,0,AK6/(O6+T6+AF6+AK6))","v":0},null,{"$f":"IF(J5=start-1+time1,0,IF(K5<>0,K5+1,IF(J6=start,1,0)))","v":0},-1E-300,"00:00:00",null,null,null,null,null,0.05]
["The Permanent portfolio assest allocation",null,null,null,null,null,null,null,null,{"$f":"J6+1","v":1981},0,0.26011560693641617,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,{"$f":"AA6+1","v":1981},0,0.13,0,0,0,0,7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",null,null,null,null,null,0.05]
["% in equities",0.25,"% in long term debt (FDs)",null,null,0.25,null,null,null,1982,0,-2.7522935779816515E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,1982,0,0,0,0,0,0,7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",null,null,null,null,null,0.05]
["% in gold",0.25,"% in short term (liquid) debt (SB acc!)",null,null,0.25,null,null,null,1983,0,0.15566037735849056,0,0,0,{"$f":"IF(K9=time1,O9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,1983,0,0.08,0,0,0,{"$f":"IF(AB9=time1,AF9,0)","v":0},7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",1,null,null,null,null,0.05]
["Total must be 100% other wise you will get weird results!",null,null,null,null,null,null,null,null,1984,0,0.44489795918367347,0,0,0,{"$f":"IF(K10=time1,O10,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,1984,0,7.0000000000000007E-2,0,0,0,{"$f":"IF(AB10=time1,AF10,0)","v":0},7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",2,null,null,null,null,0.05]
["If you wish enhance SB acc returns by a small amount to make it resemble a liquid fund",null,null,null,null,null,null,null,null,1985,0,0.62146892655367236,0,0,0,{"$f":"IF(K11=time1,O11,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1985,0,7.0000000000000007E-2,0,0,0,{"$f":"IF(AB11=time1,AF11,0)","v":0},7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",3,null,null,null,null,0.05]
["enter the incremental return here",null,0.02,null,null,null,null,null,null,1986,0,-0.11149825783972125,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1986,0,0.09,0,0,0,0,7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,0,-1E-300,"00:00:00",4,null,null,null,null,0.05]
["Results",null,null,null,null,null,null,null,null,1987,1,-0.2196078431372549,3000,0,2341.1764705882351,0,0.09,3000,0,3270.0000000000005,0,0.25,0.25,0.18274484595252305,0.25524587905780799,null,1987,1,0.33,3000,0,3990,0,7.0000000000000007E-2,3000,0,3210,0,0.25,0.25,0.31144680655677487,0.25056246843289404,null,1,-12000,"1987-01-01",5,null,null,null,null,0.05]
["Start Year","Equity corpus","Debt Corpus","Gold Corpus","liq debt  corpus","Total corpus",null,null,null,1988,2,0.79396984924623115,3000,3202.794117647059,11127.625628140706,0,0.09,3000,3202.794117647059,6761.0455882352953,0,0.25,0.25,0.35994797390629252,0.21870116252104738,null,1988,2,0.03,3000,3202.794117647059,6388.8779411764717,0,7.0000000000000007E-2,3000,3202.794117647059,6636.9897058823544,0,0.25,0.25,0.20666256641897138,0.21468829715368873,null,2,-12000,"1988-01-01",6,null,null,null,null,0.05]
[{"$f":"start","v":1987},{"$f":"MAX(P3:P58)","v":325282.8613572655},{"$f":"MAX(U3:U58)","v":396341.76590433833},{"$f":"MAX(AG3:AG58)","v":487245.84065303975},{"$f":"MAX(AL3:AL38)","v":385433.27693449415},{"$f":"B15+C15+D15+E15","v":1594303.744849138},null,null,null,1989,3,9.3837535014005602E-2,3000,7728.6347158587068,11735.383351660575,0,0.09,3000,7728.6347158587068,11694.211840285991,0,0.25,0.25,0.25593802432885904,0.25504011115771807,null,1989,3,0.02,3000,7728.6347158587068,10943.207410175881,0,7.0000000000000007E-2,3000,7728.6347158587068,11479.639145968817,0,0.25,0.25,0.23866138842281875,0.25036047609060402,null,3,-12000,"1989-01-01",7,null,null,null,null,0.05]
[null,"% Equity","%Debt","% Gold","%liq debt","CAGR",null,null,null,1990,4,0.49551856594110116,3000,11463.110437022817,21629.850179824138,0,0.09,3000,11463.110437022817,15764.790376354871,0,0.25,0.25,0.31647713263047234,0.23066251561386542,null,1990,4,7.0000000000000007E-2,3000,11463.110437022817,15475.528167614415,0,7.0000000000000007E-2,3000,11463.110437022817,15475.528167614415,0,0.25,0.25,0.22643017587783118,0.22643017587783118,null,4,-12000,"1990-01-01",8,null,null,null,null,0.05]
[null,{"$f":"B15/F15","v":0.20402816113816857},{"$f":"C15/F15","v":0.24859865454423957},{"$f":"D15/F15","v":0.30561669457732205},{"$f":"E15/F15","v":0.24175648974026967},{"$f":"XIRR(AS5:AS39,AT5:AT39)","v":0.11271900534629822},null,null,null,1991,5,2.6686643835616439,3000,17086.424222851958,73690.349139486847,0,0.12,3000,17086.424222851958,22496.795129594197,0,0.25,0.25,0.51608349833552525,0.15755420984424759,null,1991,5,0.25,3000,17086.424222851958,25108.030278564947,0,7.0000000000000007E-2,3000,17086.424222851958,21492.473918451597,0,0.25,0.25,0.17584175205831198,0.15052053976191507,null,5,-12000,"1991-01-01",9,null,null,null,null,0.05]
[null,"Final asset allocation",null,null,null,null,null,null,null,1992,6,-0.46767794632438742,3000,35696.9121165244,20599.219728772965,0,0.11,3000,35696.9121165244,42953.572449342086,0,0.25,0.25,0.14495516621229163,0.302261071816674,null,1992,6,-0.05,3000,35696.9121165244,36762.066510698176,0,0.08,3000,35696.9121165244,41792.665085846354,0,0.25,0.25,0.2586919083115678,0.29409185365946661,null,6,-12000,"1992-01-01",10,null,null,null,null,0.06]
["Click on the macro to find out the % difference",null,null,null,null,null,null,null,null,1993,7,0.6567295046032442,3000,35526.880943664895,63828.62037970611,0,0.1,3000,35526.880943664895,42379.56903803139,0,0.25,0.25,0.33559252194361261,0.22281958105549576,null,1993,7,0.1,3000,35526.880943664895,42379.56903803139,0,0.08,3000,35526.880943664895,41609.031419158091,0,0.25,0.25,0.22281958105549576,0.21876831594539584,null,7,-12000,"1993-01-01",11,null,null,null,null,0.06]
["between the two corpuses for all possible ",null,null,null,null,null,null,null,null,1994,8,-0.13707329981476582,3000,47549.197468731749,43620.252168704479,0,0.11,3000,47549.197468731749,56109.609190292249,0,0.25,0.25,0.21212936313379013,0.27286627361045024,null,1994,8,0.03,3000,47549.197468731749,52065.673392793702,0,6.5000000000000002E-2,3000,47549.197468731749,53834.895304199308,0,0.25,0.25,0.25320023587276014,0.26180412738299952,null,8,-12000,"1994-01-01",12,null,null,null,null,4.4999999999999998E-2]
["investment durations between",null,null,null,null,null,null,null,null,1995,9,3.2505366452008584E-2,3000,51407.607513997435,56176.146734016977,0,0.12,3000,51407.607513997435,60936.520415677136,0,0.25,0.25,0.24138026209150584,0.26183485561094411,null,1995,9,0.06,3000,51407.607513997435,57672.063964837282,0,6.5000000000000002E-2,3000,51407.607513997435,57944.102002407264,0,0.25,0.25,0.24780798834607207,0.24897689395147804,null,9,-12000,"1995-01-01",13,null,null,null,null,4.4999999999999998E-2]
[{"$f":"D3","v":1979},"and",{"$f":"F3","v":1988},null,null,null,null,null,null,1996,10,-1.782001782001782E-3,3000,58182.208279234663,61073.181475054262,0,0.11,3000,58182.208279234663,67912.251189950475,0,0.25,0.25,0.23805535477578638,0.26471316312953902,null,1996,10,0.02,3000,58182.208279234663,62405.852444819357,0,6.5000000000000002E-2,3000,58182.208279234663,65159.051817384912,0,0.25,0.25,0.24324993368660344,0.25398154840807124,null,10,-12000,"1996-01-01",14,null,null,null,null,4.4999999999999998E-2]
[null,null,null,null,null,null,null,null,null,1997,11,0.15828622433799464,3000,64137.584231802248,77764.538951028298,0,0.105,3000,64137.584231802248,74187.030576141478,0,0.25,0.25,0.27655374114768738,0.26383106139663548,null,1997,11,-0.14000000000000001,3000,64137.584231802248,57738.322439349933,0,6.5000000000000002E-2,3000,64137.584231802248,71501.527206869388,0,0.25,0.25,0.2053345817204584,0.25428061573521882,null,11,-12000,"1997-01-01",15,null,null,null,null,4.4999999999999998E-2]
[null,null,null,null,null,null,null,null,null,1998,12,-3.9301310043668124E-2,3000,70297.854793347273,70417.153076578164,0,0.09,3000,70297.854793347273,79894.661724748526,0,0.25,0.25,0.23456283351902893,0.26613285852129459,null,1998,12,-0.02,3000,70297.854793347273,71831.897697480323,0,6.5000000000000002E-2,3000,70297.854793347273,78062.215354914835,0,0.25,0.25,0.23927541408336578,0.26002889387631073,null,12,-12000,"1998-01-01",null,null,null,null,null,4.4999999999999998E-2]
["Start Year","CAGR","For a duration of",null,{"$f":"time1","v":25},"years",null,null,null,1999,13,0.33716577540106951,3000,75051.481963430459,104367.77040083308,0,8.5000000000000006E-2,3000,75051.481963430459,84685.857930322047,0,0.25,0.25,0.29601875199772704,0.24019485977436045,null,1999,13,0.03,3000,75051.481963430459,80393.02642233338,0,6.5000000000000002E-2,3000,75051.481963430459,83124.828291053433,0,0.25,0.25,0.22801908347243438,0.23576730475547822,null,13,-12000,"1999-01-01",null,null,null,null,null,4.4999999999999998E-2]
[1979,0.10986533761024475,"the average CAGR is",null,{"$f":"SUM(B26:B60)/(C22-A22+1)","v":0.11174685716629029},null,null,null,null,2000,14,-0.27934413117376522,3000,88142.870761135477,65682.644715683316,0,8.5000000000000006E-2,3000,88142.870761135477,98890.014775831994,0,0.25,0.25,0.18546569566489376,0.27923213908486266,null,2000,14,0.02,3000,88142.870761135477,92965.728176358185,0,0.06,3000,88142.870761135477,96611.443006803616,0,0.25,0.25,0.26250394642079256,0.2727982188294511,null,14,-12000,"2000-01-01",null,null,null,null,null,0.04]
[1980,0.10676862597465517,"Variation in the average CAGR is",null,null,{"$f":"STDEV(B26:B60)","v":3.0357526704118173E-3},null,null,null,2001,15,-3.7458379578246395E-2,3000,88537.457668669274,88108.612833688603,0,7.4999999999999997E-2,3000,88537.457668669274,98402.766993819459,0,0.25,0.25,0.23376609374094487,0.26107811386005841,null,2001,15,0.02,3000,88537.457668669274,93368.206822042659,0,0.06,3000,88537.457668669274,97029.705128789443,0,0.25,0.25,0.24772062896489266,0.25743516343410416,null,15,-12000,"2001-01-01",null,null,null,null,null,0.04]
[1981,0.11279018521308901,null,null,null,null,null,null,null,2002,16,-0.1210723551455751,3000,94227.32294458503,85455.781971184711,0,4.2500000000000003E-2,3000,94227.32294458503,101359.4841697299,0,0.25,0.25,0.21222817835450075,0.25172478898557332,null,2002,16,0.16,3000,94227.32294458503,112783.69461571863,0,0.06,3000,94227.32294458503,103060.96232126014,0,0.25,0.25,0.28009664769617748,0.25595038496374845,null,16,-12000,"2002-01-01",null,null,null,null,null,0.04]
[1982,0.11481509804725648,null,null,null,null,null,null,null,2003,17,0.83371597244998363,3000,100664.98076947335,190092.13102070367,0,0.04,3000,100664.98076947335,107811.58000025229,0,0.25,0.25,0.36683740035568335,0.20805342926701087,null,2003,17,7.0000000000000007E-2,3000,100664.98076947335,110921.52942333648,0,5.5000000000000007E-2,3000,100664.98076947335,109366.55471179438,0,0.25,0.25,0.21405497049586694,0.21105419988143889,null,17,-12000,"2003-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1983,0.11399838328361511,null,null,null,null,null,null,null,2004,18,0.16133071006975497,3000,129547.9487890217,153932.00348544409,0,5.2499999999999998E-2,3000,129547.9487890217,139506.71610044534,0,0.25,0.25,0.2676598345666002,0.24257687619784526,null,2004,18,7.0000000000000007E-2,3000,129547.9487890217,141826.30520425324,0,5.5000000000000007E-2,3000,129547.9487890217,139838.08597241787,0,0.25,0.25,0.24661022093272633,0.24315306830282823,null,18,-12000,"2004-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1984,0.10709487795829772,null,null,null,null,null,null,null,2005,19,0.73725550592946254,3000,143775.77769064013,254987.02793014335,0,0.06,3000,143775.77769064013,155582.32435207855,0,0.25,0.25,0.34938982999923646,0.21318293051029652,null,2005,19,0.12,3000,143775.77769064013,164388.87101351697,0,5.5000000000000007E-2,3000,143775.77769064013,154848.44546362534,0,0.25,0.25,0.22524988884106803,0.21217735064939888,null,19,-12000,"2005-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1985,0.11483651995658872,null,null,null,null,null,null,null,2006,20,0.15886524822695036,3000,182451.66718984107,214913.49233205695,0,7.4999999999999997E-2,3000,182451.66718984107,199360.54222907915,0,0.25,0.25,0.25035622902845234,0.23223834403297222,null,2006,20,0.34,3000,182451.66718984107,248505.23403438705,0,5.5000000000000007E-2,3000,182451.66718984107,195651.50888528232,0,0.25,0.25,0.28948779628296073,0.2279176306556146,null,20,-12000,"2006-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1986,0.11406856179237365,null,null,null,null,null,null,null,2007,21,0.19675642594859241,3000,214607.69437020138,260423.40657339583,0,8.2500000000000004E-2,3000,214607.69437020138,235560.32915574301,0,0.25,0.25,0.27111166875436282,0.24522816428077771,null,2007,21,0.08,3000,214607.69437020138,235016.30991981752,0,5.5000000000000007E-2,3000,214607.69437020138,229576.11756056244,0,0.25,0.25,0.24466181748105306,0.23899834948380641,null,21,-12000,"2007-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1987,0.11271900534629822,null,null,null,null,null,null,null,2008,22,-0.37944259780107387,3000,240144.04080237969,150884.83432047445,0,0.08,3000,240144.04080237969,262595.56406657008,0,0.25,0.25,0.15339231173969445,0.26695950461930801,null,2008,22,0.28999999999999998,3000,240144.04080237969,313655.81263506983,0,5.5000000000000007E-2,3000,240144.04080237969,256516.96304651056,0,0.25,0.25,0.31886829718417348,0.26077988645682398,null,22,-12000,"2008-01-01",null,null,null,null,null,3.5000000000000003E-2]
[1988,0.110511976480484,null,null,null,null,null,null,null,2009,23,0.80541821178409556,3000,245913.29351715624,449392.59327103395,0,0.06,3000,245913.29351715624,263848.09112818562,0,0.25,0.25,0.35122010260668757,0.20620890291961352,null,2009,23,0.22,3000,245913.29351715624,303674.2180909306,0,5.5000000000000007E-2,3000,245913.29351715624,262603.52466059983,0,0.25,0.25,0.2373347750584231,0.20523621941527573,null,23,-12000,"2009-01-01",null,null,null,null,null,3.5000000000000003E-2]
[null,null,null,null,null,null,null,null,null,2010,24,0.11000171164489074,3000,319879.60678768752,358396.91618956247,0,8.2500000000000004E-2,3000,319879.60678768752,349517.17434767174,0,0.25,0.25,0.24846139594117786,0.24230544717607599,null,2010,24,0.22,3000,319879.60678768752,393913.12028097874,0,5.5000000000000007E-2,3000,319879.60678768752,340637.98516101029,0,0.25,0.25,0.27308327533931886,0.23614988154342736,null,24,-12000,"2010-01-01",null,null,null,null,null,3.5000000000000003E-2]
[null,null,null,null,null,null,null,null,null,2011,{"$f":"IF(J36=start-1+time1,0,IF(K36<>0,K36+1,IF(J37=start,1,0)))","v":25},-0.10542277049601645,{"$f":"IF(K37=0,0,IF(Q36=start-1+time1,0,IF(M36<>0,M36*(1+inca),IF(J37=start,12*cont1*eqper,0))))","v":3000},360616.29899480578,{"$f":"IF(K37=0,0,(M37+N37)*(1+L37))","v":325282.8613572655},{"$f":"IF(K37=time1,O37,0)","v":325282.8613572655},0.09,3000,360616.29899480578,{"$f":"IF(K37=0,0,(R37+S37)*(1+Q37))","v":396341.76590433833},{"$f":"IF(K37=time1,T37,0)","v":396341.76590433833},0.25,0.25,0.20402816113816857,0.24859865454423957,null,2011,{"$f":"IF(AA36=start-1+time1,0,IF(AB36<>0,AB36+1,IF(AA37=start,1,0)))","v":25},0.34,3000,360616.29899480578,{"$f":"IF(AB37=0,0,(AD37+AE37)*(1+AC37))","v":487245.84065303975},{"$f":"IF(AB37=time1,AF37,0)","v":487245.84065303975},0.06,3000,360616.29899480578,{"$f":"IF(AB37=0,0,(AI37+AJ37)*(1+AH37))","v":385433.27693449415},{"$f":"IF(AB37=time1,AK37,0)","v":385433.27693449415},0.25,0.25,0.30561669457732205,0.24175648974026967,null,25,-12000,"2011-01-01",null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,null,null,2012,0,8.2222477591358312E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,2012,0,0.14000000000000001,0,0,0,0,0.06,0,0,0,0,0,0,0,0,null,0,1594303.744849138,"2012-01-01",null,null,null,null,null,0.04]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,-1E-300,"00:00:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["% in equities",null,"% in FDs"]