{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Data","Ref"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,12,13,14],[5,9,5,14],[2,2,2,6],[5,2,5,3],[6,2,7,3]]}
[]
[]
[null,null,"Excel Dollar Cost Averaging Calculator"]
[]
[]
[null,null,"User Inputs",null,null,null,null,null,null,"DCA Summary For MICROSOFT CORPORATION (XNAS:MSFT)"]
[null,null,"Complete the user inputs then click refresh."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S&P 500 Benchmark"]
[null,null,"Stock Ticker",{"$error":"#VALUE!"},null,null,null,null,null,"Total Amount Invested",2300,null,"Total Profit",743.01948786341472,215.17325927791808]
[null,null,null,null,null,null,null,null,null,"No of Shares Acquired",8.0639693869605011,null,"Total ROI",0.32305195124496294,9.3553590990399157E-2]
[null,null,"Start Date","2022-01-01",null,null,null,null,null,"Average Price Paid",285.2193367349729,null,"Annualised ROI",0.17621015522452524,5.1029231449308633E-2]
[null,null,"End Date","2023-11-01"]
[null,null,"Payment Frequency","Monthly",null,null,null,null,null,"Current Price",{"$f":"_FV(D9,\"Price\",TRUE)","v":370.6},null,"Positive ROI and better than the benchmark."]
[null,null,null,null,null,null,null,null,null,"Current Investment Value",3043.0194878634147]
[null,null,"Payment Amount",100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Max Pain",-0.15217135502866438,null,"Date of Max Pain","2022-10-01"]

{"sheet":"Data","index":1,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"Data"]
[]
[null,{"$f":"_xlfn.STOCKHISTORY(Input!D9,Input!D11,Input!D12,VLOOKUP(Input!D13,Ref!$B$4:$C$6,2,FALSE),1,0,2,1)","v":"Date"},"Open","Close","Mid-Price","No of Shares","Total Shares","Portfolio Value","Invested Amount","Running Profit",null,{"$f":"_xlfn.STOCKHISTORY(Ref!F11,B4,Input!D12,VLOOKUP(Input!D13,Ref!$B$4:$C$6,2,FALSE),1,0,2,1)","v":"Date"},"Open","Close","Benchmark Mid-Price","Benchmark No of Shares","Benchmark Total Shares","Benchmark Portfolio Value","Benchmark Invested Amount","Benchmark Running Profit"]
[null,44562,335.35,310.98,323.16500000000002,0.309439450435536,0.309439450435536,100,100,0,null,44562,476.3,449.91,463.10500000000002,0.21593375152503211,0.21593375152503211,100,100,0]
[null,44593,310.41000000000003,298.79000000000002,304.60000000000002,0.32829940906106364,0.63773885949659959,194.25525660266425,200,-2.8723716986678766E-2,null,44593,450.68,436.63,443.65499999999997,0.22540036740259889,0.44133411892763097,195.80008853283812,200,-2.0999557335809414E-2]
[null,44621,296.39999999999998,308.31,302.35500000000002,0.33073704751037686,0.96847590700697639,292.82353286309439,300,-2.3921557123018716E-2,null,44621,435.04,451.64,443.34000000000003,0.22556051788694906,0.66689463681458006,295.66106828537596,300,-1.4463105715413462E-2]
[null,44652,309.37,277.52,293.44499999999999,0.34077936240181295,1.3092552694087893,384.19441253166218,400,-3.951396867084455E-2,null,44652,453.31,412,432.65499999999997,0.2311310397429823,0.89802567655756238,388.53529909101212,400,-2.8661752272469698E-2]
[null,44682,277.70999999999998,271.87,274.78999999999996,0.36391426179991998,1.6731695312087094,459.77025548084117,500,-8.045948903831765E-2,null,44682,412.07,412.93,412.5,0.24242424242424243,1.1404499189818047,470.43559157999442,500,-5.9128816840011152E-2]
[null,44713,275.19499999999999,256.83,266.01249999999999,0.37592218410788969,2.0490917153165991,545.08400992065674,600,-9.1526650132238763E-2,null,44713,415.17,377.25,396.21000000000004,0.25239140859645137,1.3928413275782561,551.85766239978091,600,-8.0237229333698493E-2]
[null,44743,256.39,280.74,268.565,0.37234933814905147,2.4214410534656503,650.31431652400238,700,-7.0979547822853747E-2,null,44743,376.56,411.99,394.27499999999998,0.25363008052755059,1.6464714081058067,649.16251443091687,700,-7.2624979384404473E-2]
[null,44774,277.82,261.47000000000003,269.64499999999998,0.37085797993658332,2.7922990334022337,752.92947286174524,800,-5.8838158922818448E-2,null,44774,409.15,395.18,402.16499999999996,0.24865415936245075,1.8951255674682574,762.15317384087166,800,-4.7308532698910423E-2]
[null,44805,258.87,232.9,245.88499999999999,0.40669418630660675,3.1989932197088407,786.5844478281083,900,-0.12601728019099079,null,44805,392.89,357.18,375.03499999999997,0.26664178010052397,2.1617673475687815,810.73841719545794,900,-9.9179536449491179E-2]
[null,44835,235.41,232.13,233.76999999999998,0.42777088591350476,3.6267641056223452,847.82864497133562,1000,-0.15217135502866438,null,44835,361.08,386.21,373.64499999999998,0.26763371649560413,2.4294010640643857,907.7335605823373,1000,-9.2266439417662702E-2]
[null,44866,234.6,255.14,244.87,0.40837995671172456,4.0351440623340693,988.08572654374359,1100,-0.10174024859659674,null,44866,390.14,407.68,398.90999999999997,0.2506831114787797,2.6800841755431652,1069.1123784659239,1100,-2.8079655940069146E-2]
[null,44896,253.87,239.82,246.845,0.4051125200024307,4.4402565823364997,1096.0551360668533,1200,-8.6620719944288951E-2,null,44896,408.77,382.43,395.6,0.25278058645096058,2.9328647619941259,1160.2412998448763,1200,-3.3132250129269777E-2]
[null,44927,243.08,247.81,245.44499999999999,0.4074232516449714,4.8476798339814708,1189.838776851582,1300,-8.4739402421859997E-2,null,44927,384.37,406.48,395.42500000000001,0.25289245748245559,3.1857572194765815,1259.7280485115273,1300,-3.0978424221902095E-2]
[null,44958,248,249.42,248.70999999999998,0.40207470548027829,5.2497545394617493,1305.6664515095315,1400,-6.7381106064620361E-2,null,44958,405.21100000000001,396.26,400.7355,0.24954115619903902,3.4352983756756204,1376.6460122255576,1400,-1.6681419838887449E-2]
[null,44986,250.76,288.3,269.52999999999997,0.37101621340852597,5.6207707528702748,1514.9663410211251,1500,9.9775606807500777E-3,null,44986,395.41,409.39,402.4,0.2485089463220676,3.6838073219976879,1482.3640663718695,1500,-1.1757289085420326E-2]
[null,45017,286.52,307.26,296.89,0.33682508673245987,5.9575958396027344,1768.7506288196557,1600,0.10546914301228483,null,45017,408.85,415.93,412.39,0.24248890613254445,3.9262962281302323,1619.1653015186264,1600,1.1978313449141496E-2]
[null,45047,306.97000000000003,328.39,317.68,0.31478217073784942,6.2723780103405842,1992.6090463249968,1700,0.17212296842646871,null,45047,415.47,417.85,416.66,0.24000384006144096,4.1663000681916733,1735.9305864127427,1700,2.113563906631926E-2]
[null,45078,325.93,340.54,333.23500000000001,0.30008852611520398,6.5724665364557886,2190.1758862758447,1800,0.21676438126435818,null,45078,418.09,443.28,430.68499999999995,0.23218825823978084,4.3984883264314538,1894.3629448691304,1800,5.2423858260627995E-2]
[null,45108,339.19,335.92,337.55500000000001,0.29624801884137397,6.8687145552971627,2318.568941713334,1900,0.22029944300701787,null,45108,442.92,457.79,450.35500000000002,0.22204705177027012,4.6205353782017236,2080.8812102500374,1900,9.5200636973703887E-2]
[null,45139,335.19,327.76,331.47500000000002,0.30168187646127159,7.1703964317584346,2376.807157217127,2000,0.18840357860856352,null,45139,456.27,450.35,453.31,0.22059958968476318,4.8411349678864868,2194.5348922926232,2000,9.7267446146311609E-2]
[null,45170,331.31,315.75,323.52999999999997,0.30909034710845984,7.4794867788668942,2419.8383575668063,2100,0.15230397979371726,null,45170,453.17,427.48,440.32500000000005,0.22710497927667062,5.068239947163157,2231.6727547346172,2100,6.2701311778389154E-2]
[null,45200,316.27999999999997,338.11,327.19499999999999,0.30562814223933743,7.7851149211062314,2547.2506766113534,2200,0.15784121664152426,null,45200,426.62,418.2,422.40999999999997,0.23673681967756446,5.3049767668407215,2240.8752360811891,2200,1.8579652764176859E-2]
[null,45231,339.79,378.91,358.61,0.27885446585427065,8.0639693869605011,2891.8200618579053,2300,0.25731307037300233,null,45231,419.2,456.4,437.25,0.22870211549456831,5.5336788823352894,2419.6010913011055,2300,5.2000474478741524E-2]

{"sheet":"Ref","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,"References"]
[null,null,null,null,"Benchmark Stats"]
[null,"Input Frequency","Value",null,null,"Actuals"]
[null,"Daily",0,null,"Total Amount Invested",2300]
[null,"Weekly",1,null,"No of Shares Aquired",5.5336788823352894]
[null,"Monthly",2,null,"Average Price Paid",415.63669466656296]
[]
[null,null,null,null,"Current Share Price",{"$f":"_FV(F11,\"Price\",TRUE)","v":468.79}]
[null,null,null,null,"Current Investment Value",2515.1732592779181]
[]
[null,null,null,null,"Bench Epic",{"$error":"#VALUE!"}]