{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["A","Match Syntax","Stock Data","ASoln"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"A","index":0,"n_rows":41,"n_cols":37,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,1,2,5],[20,19,20,23]]}
[null,"VLOOKUP, MATCH, INDEX, FREQUENCY, DATABASE FUNCTIONS & FREEZE PANES"]
[]
[{"$f":"NOW()","v":"2025-02-27T08:33:19.680"},"Stock Returns by Quarter (%)"]
["Stock","Qtr1","Qtr2","Qtr3","Qtr4","Annual"]
["Stock 1",4.9071936298287415,-0.41607236429053129,-1.9769613797241299,6.4965481459683865,{"$f":"SUM(B5:E5)","v":9.0107080317824675},{"$f":"VLOOKUP(F5,$I$9:$J$13,2)","v":"Buy"},null,"Lookup_value"]
["Stock 2",0.23781666299094795,1.9651942769308279,-2.4333721146530038,-0.88742559394913911,-1.1177867686803671,{"$f":"VLOOKUP(F6,$I$9:$J$13,2)","v":"Sell"},null,null,null,null,"Lookup Table (Range Shaded Tan)"]
["Stock 3",-1.2008549767811711,4.8405703677856975,1.6052926258835143E-2,3.987971583917262,7.6437399011806235,"Buy"]
["Stock 4",-1.6408086628504699,5.9085516524068442,3.4616844824320196,5.6397982614697959,13.36922573345819,"Buy++",null,"Return","Rating",null,null,null,null,null,null,null,"Using MATCH & INDEX to find the Annual Return for any stock:"]
["Stock 5",0.9620103101865789,2.4860063434729636,6.4801923799640946,-1.2580991795878689,8.6701098540357684,"Buy",null,-999,"Short",null,null,null,null,null,null,null,null,"Stock 29","<-- Input name of stock here"]
["Stock 6",4.1577043968756007,-2.3706292885715028,3.4527166242617282,1.8208177663547804,7.0606094989206065,"Buy",null,-10,"Sell",null,null,null,null,null,null,null,null,{"$f":"MATCH(S9,A5:A33,0)","v":29},{"$f":"getformula(S10)","v":"<--  =MATCH(S9,A5:A33,0)"}]
["Stock 7",-1.991506970474229,4.8405262181038111,-1.7594351066984855,6.4741184077439105,7.5637025486750069,"Buy",null,4,"Watch",null,null,null,null,null,null,null,null,{"$f":"INDEX(A5:F33,S10,6)","v":4.2630940714552263},{"$f":"getformula(S11)","v":"<--  =INDEX(A5:F33,S10,6)"}]
["Stock 8",0.75716316851132071,-0.47874396547475007,5.8347896658200771,3.95265875513876,10.065867623995407,"Buy++",null,6,"Buy",null,null,null,null,null,null,null,null,{"$f":"INDEX(A5:F33,MATCH(S9,A5:A33,0),6)","v":4.2630940714552263},{"$f":"getformula(S12)","v":"<--  =INDEX(A5:F33,MATCH(S9,A5:A33,0),6)"}]
["Stock 9",4.9415230632822063,3.9689706937190445,3.8823174014724433,-2.5819413755426552,10.21086978293104,"Buy++",null,10,"Buy++"]
["Stock 10",2.497379585092359,-1.8208472654888492,-1.6867251994302663,6.4788987715334336,5.4687058917066773,"Watch",null,"The VLOOKUP function finds the largest value"]
["Stock 11",2.4547762847245496,2.7113886839820989,-1.7228445763612816,-2.9662973883796746,0.47702300396569219,"Sell",null,"in the first column of the Lookup Table that is",null,null,null,null,null,null,null,null,"MATCH, INDEX & 2-WAY DATA TABLE"]
["Stock 12",3.4707579162069475,3.2246382720643272,5.6924241901868058,8.5996882307721734E-3,12.396420066688853,"Buy++",null,"less than or equal to the lookup_value.",null,null,null,null,null,null,null,null,"Column Input",null,"Row Input"]
["Stock 13",0.26625704455897026,3.7695972825156314,-2.9716926947264914,-0.61006957189972466,0.45409206044838557,"Sell",null,null,null,null,null,null,null,null,null,null,"Stock 3",null,6]
["Stock 14",2.5267493678203428,-0.35290903913042637,-0.1278128675097765,1.3765094737445729,3.4225369349247128,"Sell",null,"Bins: The number in each Bin is the highest value counted",null,null,null,null,null,null,null,null,{"$f":"MATCH(R17,A5:A33,0)","v":3},{"$f":"getformula(R18)","v":"<--  =MATCH(R17,A5:A33,0)"}]
["Stock 15",6.2654532552664737,6.7321997368478304,1.4225290289587758,4.2403505772517391,18.660532598324821,"Buy++",null,null,"by the Frequency function.",null,null,null,null,null,null,null,{"$f":"INDEX(A5:F33,R18,T17)","v":7.6437399011806235},{"$f":"getformula(R19)","v":"<--  =INDEX(A5:F33,R18,T17)"}]
["Stock 16",6.2222627467992719,0.4737998440513751,2.5930190895540157,-1.6380633412576258,7.6510183391470381,"Buy",null,"Below, annual returns are sorted into Bins based on size.",null,null,null,null,null,null,null,null,{"$f":"INDEX(A5:F33,MATCH(R17,A5:A33,0),T17)","v":7.6437399011806235},{"$f":"getformula(R20)","v":"<--  =INDEX(A5:F33,MATCH(R17,A5:A33,0),T17)"}]
["Stock 17",-1.2667117474192497,0.75215712756814757,3.8493613664546817,0.50987423640347407,3.8446809830070534,"Sell",null,"Try changing cell F33 to 26 and 27 to see what happens to",null,null,null,null,null,null,null,null,null,null,"Stock Returns by Quarter (%)"]
["Stock 18",0.10983358670119392,-0.75064144865978522,-0.67324273768384524,6.9851200369356032,5.6710694372931663,"Watch",null,null,"the values in J33:J34.",null,null,null,null,null,null,null,null,null,"Qtr1","Qtr2","Qtr3","Qtr4","Annual",null,"Using XLOOKUP:",null,null,null,null,null,null,"Using VLOOKUP:"]
["Stock 19",-1.6272920507468853,6.0182338765403927,0.82388275114462051,-1.1451114586885198,4.0697131182496076,"Watch",null,"Bins","Count",null,null,null,null,null,null,null,null,{"$f":"R20","v":7.6437399011806235},2,3,4,5,6,null,null,{"$f":"_xlfn.FORMULATEXT(Z24)","v":"=XLOOKUP(S24,$A$5:$A$33,$B$5:$G$33,\"????\")"},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(AG24)","v":"=VLOOKUP($S24,$A$5:$F$33,T$23)"}]
["Stock 20",-1.5742468923135273,2.0558333959375243,4.6392195399063612,4.9511357896854387,10.071941833215796,"Buy++",null,0,null,{"$f":"getformula(J24)","v":"<--  "},null,null,null,null,null,null,null,{"$f":"R17","v":"Stock 3"},-1.2008549767811711,4.8405703677856975,1.6052926258835143E-2,3.987971583917262,7.6437399011806235,null,{"$f":"_xlfn.XLOOKUP(S24,$A$5:$A$33,$B$5:$G$33,\"????\")","v":-1.2008549767811711},4.8405703677856975,1.6052926258835143E-2,3.987971583917262,7.6437399011806235,"Buy",null,{"$f":"VLOOKUP($S24,$A$5:$F$33,T$23)","v":-1.2008549767811711},{"$f":"VLOOKUP($S24,$A$5:$F$33,U$23)","v":4.8405703677856975},1.6052926258835143E-2,3.987971583917262,7.6437399011806235]
["Stock 21",5.1012670673151774,5.9333812952594744,-1.9873008893338813,2.529593957851004,11.576941431091775,"Buy++",null,2,null,{"$f":"getformula(J25)","v":"<--  "},null,null,null,null,null,null,null,"Stock 2",0.23781666299094795,1.9651942769308279,-2.4333721146530038,-0.88742559394913911,-1.1177867686803671,null,{"$f":"_xlfn.XLOOKUP(S25,$A$5:$A$33,$B$5:$G$33,\"????\")","v":0.23781666299094795},1.9651942769308279,-2.4333721146530038,-0.88742559394913911,-1.1177867686803671,"Sell",null,{"$f":"VLOOKUP($S25,$A$5:$F$33,T$23)","v":0.23781666299094795},{"$f":"VLOOKUP($S25,$A$5:$F$33,U$23)","v":1.9651942769308279},{"$f":"VLOOKUP($S25,$A$5:$F$33,V$23)","v":-2.4333721146530038},{"$f":"VLOOKUP($S25,$A$5:$F$33,W$23)","v":-0.88742559394913911},{"$f":"VLOOKUP($S25,$A$5:$F$33,X$23)","v":-1.1177867686803671}]
["Stock 22",5.6395555190960511,6.0847994053344738,0.51306565150360406,5.0651529341153427,17.30257351004947,"Buy++",null,4,null,"<--  ",null,null,null,null,null,null,null,"Stock 22",5.6395555190960511,6.0847994053344738,0.51306565150360406,5.0651529341153427,17.30257351004947,null,{"$f":"_xlfn.XLOOKUP(S26,$A$5:$A$33,$B$5:$G$33,\"????\")","v":5.6395555190960511},6.0847994053344738,0.51306565150360406,5.0651529341153427,17.30257351004947,"Buy++",null,5.6395555190960511,6.0847994053344738,0.51306565150360406,5.0651529341153427,17.30257351004947]
["Stock 23",6.9831360403672775,4.3902944463848605,0.66673474157163426,6.5325493872525886,18.572714615576359,"Buy++",null,6,null,"<--  ",null,null,null,null,null,null,null,"Stock 4",-1.6408086628504699,5.9085516524068442,3.4616844824320196,5.6397982614697959,13.36922573345819,null,{"$f":"_xlfn.XLOOKUP(S27,$A$5:$A$33,$B$5:$G$33,\"????\")","v":-1.6408086628504699},5.9085516524068442,3.4616844824320196,5.6397982614697959,13.36922573345819,"Buy++",null,-1.6408086628504699,5.9085516524068442,3.4616844824320196,5.6397982614697959,13.36922573345819]
["Stock 24",5.6791174477514126,-0.31370972111104223,1.7182406451596046,2.8474905793001604,9.9311389511001344,"Buy",null,8,null,"<--  ",null,null,null,null,null,null,null,"Stock 5",0.9620103101865789,2.4860063434729636,6.4801923799640946,-1.2580991795878689,8.6701098540357684,null,{"$f":"_xlfn.XLOOKUP(S28,$A$5:$A$33,$B$5:$G$33,\"????\")","v":0.9620103101865789},2.4860063434729636,6.4801923799640946,-1.2580991795878689,8.6701098540357684,"Buy",null,0.9620103101865789,2.4860063434729636,6.4801923799640946,-1.2580991795878689,8.6701098540357684]
["Stock 25",1.6707515925676937,2.4017010789449591,4.5472946842127611,5.3319266969872334,13.951674052712647,"Buy++",null,10,null,"<--  ",null,null,null,null,null,null,null,"Stock 6",4.1577043968756007,-2.3706292885715028,3.4527166242617282,1.8208177663547804,7.0606094989206065,null,{"$f":"_xlfn.XLOOKUP(S29,$A$5:$A$33,$B$5:$G$33,\"????\")","v":4.1577043968756007},-2.3706292885715028,3.4527166242617282,1.8208177663547804,7.0606094989206065,"Buy",null,4.1577043968756007,-2.3706292885715028,3.4527166242617282,1.8208177663547804,7.0606094989206065]
["Stock 26",4.6460365571064015,3.7770780105296922,4.9049437238352374,-1.9210026075316817,11.407055683939651,"Buy++",null,12,null,"<--  ",null,null,null,null,null,null,null,"Stock 7",-1.991506970474229,4.8405262181038111,-1.7594351066984855,6.4741184077439105,7.5637025486750069,null,{"$f":"_xlfn.XLOOKUP(S30,$A$5:$A$33,$B$5:$G$33,\"????\")","v":-1.991506970474229},4.8405262181038111,-1.7594351066984855,6.4741184077439105,7.5637025486750069,"Buy",null,-1.991506970474229,4.8405262181038111,-1.7594351066984855,6.4741184077439105,7.5637025486750069]
["Stock 27",5.6702561891721484,5.935013213996843,3.7042633121299602,5.7902257994659845,21.099758514764936,"Buy++",null,14,null,"<--  ",null,null,null,null,null,null,null,"Stock 8",0.75716316851132071,-0.47874396547475007,5.8347896658200771,3.95265875513876,10.065867623995407,null,{"$f":"_xlfn.XLOOKUP(S31,$A$5:$A$33,$B$5:$G$33,\"????\")","v":0.75716316851132071},-0.47874396547475007,5.8347896658200771,3.95265875513876,10.065867623995407,"Buy++",null,0.75716316851132071,-0.47874396547475007,5.8347896658200771,3.95265875513876,10.065867623995407]
["Stock 28",6.8541545768723626,5.0776429296031367,3.6789694843410343,6.4943071437093796,22.105074134525914,"Buy++",null,16,null,"<--  ",null,null,null,null,null,null,null,"Stock 9",4.9415230632822063,3.9689706937190445,3.8823174014724433,-2.5819413755426552,10.21086978293104,null,{"$f":"_xlfn.XLOOKUP(S32,$A$5:$A$33,$B$5:$G$33,\"????\")","v":4.9415230632822063},3.9689706937190445,3.8823174014724433,-2.5819413755426552,10.21086978293104,"Buy++",null,4.9415230632822063,3.9689706937190445,3.8823174014724433,-2.5819413755426552,10.21086978293104]
["Stock 29",3.0358542565013193,-2.0289246302625226,-0.66548686963019055,3.9216513148466206,4.2630940714552263,"Watch",null,18,null,"<--  ",null,null,null,null,null,null,null,"Stock 54",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.XLOOKUP(S33,$A$5:$A$33,$B$5:$G$33,\"????\")","v":"????"},null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"B$4","v":"Qtr1"},{"$f":"C$4","v":"Qtr2"},{"$f":"D$4","v":"Qtr3"},{"$f":"E$4","v":"Qtr4"},{"$f":"F$4","v":"Annual"},null,null,20,null,"<--  ",null,null,null,null,null,null,null,"Stock 11",2.4547762847245496,2.7113886839820989,-1.7228445763612816,-2.9662973883796746,0.47702300396569219,null,{"$f":"_xlfn.XLOOKUP(S34,$A$5:$A$33,$B$5:$G$33,\"????\")","v":2.4547762847245496},2.7113886839820989,-1.7228445763612816,-2.9662973883796746,0.47702300396569219,"Sell",null,2.4547762847245496,2.7113886839820989,-1.7228445763612816,-2.9662973883796746,0.47702300396569219]
[null,">-100",">0",">0",">0",">10",null,null,22,null,"<--  ",null,null,null,null,null,null,null,"Stock 12",3.4707579162069475,3.2246382720643272,5.6924241901868058,8.5996882307721734E-3,12.396420066688853,null,{"$f":"_xlfn.XLOOKUP(S35,$A$5:$A$33,$B$5:$G$33,\"????\")","v":3.4707579162069475},3.2246382720643272,5.6924241901868058,8.5996882307721734E-3,12.396420066688853,"Buy++",null,3.4707579162069475,3.2246382720643272,5.6924241901868058,8.5996882307721734E-3,12.396420066688853]
["Mean",{"$f":"DAVERAGE(B$4:B$33,1,B$34:B$35)","v":2.6122616884486147},{"$f":"DAVERAGE(C$4:C$33,1,C$34:C$35)","v":3.9689322929514259},{"$f":"DAVERAGE(D$4:D$33,1,D$34:D$35)","v":3.2569316678509623},{"$f":"DAVERAGE(E$4:E$33,1,E$34:E$35)","v":4.3540618718050599},{"$f":"DAVERAGE(F$4:F$33,1,F$34:F$35)","v":14.67620381394422},null,null,24,null,"<--  ",null,null,null,null,null,null,null,"Stock 13",0.26625704455897026,3.7695972825156314,-2.9716926947264914,-0.61006957189972466,0.45409206044838557,null,{"$f":"_xlfn.XLOOKUP(S36,$A$5:$A$33,$B$5:$G$33,\"????\")","v":0.26625704455897026},3.7695972825156314,-2.9716926947264914,-0.61006957189972466,0.45409206044838557,"Sell",null,0.26625704455897026,3.7695972825156314,-2.9716926947264914,-0.61006957189972466,0.45409206044838557]
["Minimum",{"$f":"DMIN(B$4:B$33,1,B$34:B$35)","v":-1.991506970474229},{"$f":"DMIN(C$4:C$33,1,C$34:C$35)","v":0.4737998440513751},{"$f":"DMIN(D$4:D$33,1,D$34:D$35)","v":1.6052926258835143E-2},{"$f":"DMIN(E$4:E$33,1,E$34:E$35)","v":8.5996882307721734E-3},{"$f":"DMIN(F$4:F$33,1,F$34:F$35)","v":10.065867623995407},null,null,26,null,"<--  ",null,null,null,null,null,null,null,"Stock 14",2.5267493678203428,-0.35290903913042637,-0.1278128675097765,1.3765094737445729,3.4225369349247128,null,{"$f":"_xlfn.XLOOKUP(S37,$A$5:$A$33,$B$5:$G$33,\"????\")","v":2.5267493678203428},-0.35290903913042637,-0.1278128675097765,1.3765094737445729,3.4225369349247128,"Sell",null,2.5267493678203428,-0.35290903913042637,-0.1278128675097765,1.3765094737445729,3.4225369349247128]
["Maximum",{"$f":"DMAX(B$4:B$33,1,B$34:B$35)","v":6.9831360403672775},{"$f":"DMAX(C$4:C$33,1,C$34:C$35)","v":6.7321997368478304},{"$f":"DMAX(D$4:D$33,1,D$34:D$35)","v":6.4801923799640946},{"$f":"DMAX(E$4:E$33,1,E$34:E$35)","v":6.9851200369356032},{"$f":"DMAX(F$4:F$33,1,F$34:F$35)","v":22.105074134525914},null,null,null,null,"<--  ",null,null,null,null,null,null,null,"Stock 15",6.2654532552664737,6.7321997368478304,1.4225290289587758,4.2403505772517391,18.660532598324821,null,{"$f":"_xlfn.XLOOKUP(S38,$A$5:$A$33,$B$5:$G$33,\"????\")","v":6.2654532552664737},6.7321997368478304,1.4225290289587758,4.2403505772517391,18.660532598324821,"Buy++",null,6.2654532552664737,6.7321997368478304,1.4225290289587758,4.2403505772517391,18.660532598324821]
["Number",{"$f":"DCOUNTA(B$4:B$33,1,B$34:B$35)","v":29},{"$f":"DCOUNTA(C$4:C$33,1,C$34:C$35)","v":21},{"$f":"DCOUNTA(D$4:D$33,1,D$34:D$35)","v":19},{"$f":"DCOUNTA(E$4:E$33,1,E$34:E$35)","v":21},{"$f":"DCOUNTA(F$4:F$33,1,F$34:F$35)","v":13},null,null,"For help on the FREQUENCY function visit:",null,null,null,null,null,null,null,null,null,"Stock 16",6.2222627467992719,0.4737998440513751,2.5930190895540157,-1.6380633412576258,7.6510183391470381,null,{"$f":"_xlfn.XLOOKUP(S39,$A$5:$A$33,$B$5:$G$33,\"????\")","v":6.2222627467992719},0.4737998440513751,2.5930190895540157,-1.6380633412576258,7.6510183391470381,"Buy",null,6.2222627467992719,0.4737998440513751,2.5930190895540157,-1.6380633412576258,7.6510183391470381]
[null,null,null,null,null,null,null,null,"https://www.techonthenet.com/excel/formulas/frequency.php",null,null,null,null,null,null,null,null,null,"Stock 17",-1.2667117474192497,0.75215712756814757,3.8493613664546817,0.50987423640347407,3.8446809830070534,null,{"$f":"_xlfn.XLOOKUP(S40,$A$5:$A$33,$B$5:$G$33,\"????\")","v":-1.2667117474192497},0.75215712756814757,3.8493613664546817,0.50987423640347407,3.8446809830070534,"Sell",null,-1.2667117474192497,0.75215712756814757,3.8493613664546817,0.50987423640347407,3.8446809830070534]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock 18",0.10983358670119392,-0.75064144865978522,-0.67324273768384524,6.9851200369356032,5.6710694372931663,null,{"$f":"_xlfn.XLOOKUP(S41,$A$5:$A$33,$B$5:$G$33,\"????\")","v":0.10983358670119392},-0.75064144865978522,-0.67324273768384524,6.9851200369356032,5.6710694372931663,"Watch",null,0.10983358670119392,-0.75064144865978522,-0.67324273768384524,6.9851200369356032,5.6710694372931663]

{"sheet":"Match Syntax","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Stock Data","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Data/Stocks Command"]
[]
["Select cells containing ticker symbols (Tan fill)"]
["On the ribbon select Data/Stocks"]
[]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Ticker symbol\",TRUE)","v":"AAPL"},{"$f":"_FV(B6,\"Price\")","v":240.36},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":-2.7040000000000002E-2}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Ticker symbol\",TRUE)","v":"MSFT"},{"$f":"_FV(B7,\"Price\")","v":399.73},{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":4.5989999999999998E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Ticker symbol\",TRUE)","v":"MMM"},{"$f":"_FV(B8,\"Price\")","v":147.43},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":6.0729999999999994E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Ticker symbol\",TRUE)","v":"AEP"},{"$f":"_FV(B9,\"Price\")","v":106.89},{"$f":"_FV(B9,\"Change (%)\",TRUE)","v":-6.9679999999999994E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Ticker symbol\",TRUE)","v":"BRKA"},{"$f":"_FV(B10,\"Price\")","v":451500},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":1.109E-3}]
[]
["Select all stocks (Tan Fill) & click Insert Data icon to upper right to add data to table."]
["Select all stocks (Tan Fill) & Right click. Select Data Type/Refresh to update table. "]
["Click icon to left of stock name for more firm information."]
[]
["Web:","https://www.excel-university.com/articles/cal-cpa/get-current-and-historical-stock-prices-into-excel/"]

{"sheet":"ASoln","index":3,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":true,"merged":[[2,1,2,5]]}
[null,"VLOOKUP TABLE"]
[null,"Database Functions",null,null,{"$f":"NOW()","v":"2025-02-27T08:33:19.680"}]
[null,"Stock Returns by Quarter (%)"]
["Stock","Qtr1","Qtr2","Qtr3","Qtr4","Annual"]
["Stock 1",4.9071936298287415,-0.41607236429053129,-1.9769613797241299,6.4965481459683865,{"$f":"SUM(B5:E5)","v":9.0107080317824675},{"$f":"VLOOKUP(F5,$I$9:$J$13,2)","v":"B"},null,"Lookup_value"]
["Stock 2",0.23781666299094795,1.9651942769308279,-2.4333721146530038,-0.88742559394913911,{"$f":"SUM(B6:E6)","v":-1.1177867686803671},{"$f":"VLOOKUP(F6,$I$9:$J$13,2)","v":"F"},null,null,null,null,"Lookup Table (Range Shaded Tan)"]
["Stock 3",-1.2008549767811711,4.8405703677856975,1.6052926258835143E-2,3.987971583917262,7.6437399011806235,"B"]
["Stock 4",-1.6408086628504699,5.9085516524068442,3.4616844824320196,5.6397982614697959,13.36922573345819,"A",null,"Return","Grade"]
["Stock 5",0.9620103101865789,2.4860063434729636,6.4801923799640946,-1.2580991795878689,8.6701098540357684,"B",null,-100,"F",null,null,null,null,null,"Stock 3"]
["Stock 6",4.1577043968756007,-2.3706292885715028,3.4527166242617282,1.8208177663547804,7.0606094989206065,"B",null,0,"D",null,null,null,null,null,{"$f":"MATCH(P9,A5:A33,0)","v":3},{"$f":"getformula(P10)","v":"<--  =MATCH(P9,A5:A33,0)"}]
["Stock 7",-1.991506970474229,4.8405262181038111,-1.7594351066984855,6.4741184077439105,7.5637025486750069,"B",null,4,"C",null,null,null,null,null,{"$f":"INDEX(A5:F33,P10,6)","v":7.6437399011806235},{"$f":"getformula(P11)","v":"<--  =INDEX(A5:F33,P10,6)"}]
["Stock 8",0.75716316851132071,-0.47874396547475007,5.8347896658200771,3.95265875513876,10.065867623995407,"A",null,6,"B",null,null,null,null,null,{"$f":"INDEX(A5:F33,MATCH(P9,A5:A33,0),6)","v":7.6437399011806235},{"$f":"getformula(P12)","v":"<--  =INDEX(A5:F33,MATCH(P9,A5:A33,0),6)"}]
["Stock 9",4.9415230632822063,3.9689706937190445,3.8823174014724433,-2.5819413755426552,10.21086978293104,"A",null,10,"A"]
["Stock 10",2.497379585092359,-1.8208472654888492,-1.6867251994302663,6.4788987715334336,5.4687058917066773,"C"]
["Stock 11",2.4547762847245496,2.7113886839820989,-1.7228445763612816,-2.9662973883796746,0.47702300396569219,"D",null,"The VLOOKUP function finds the largest value"]
["Stock 12",3.4707579162069475,3.2246382720643272,5.6924241901868058,8.5996882307721734E-3,12.396420066688853,"A",null,"in the first column of the Lookup Table that is"]
["Stock 13",0.26625704455897026,3.7695972825156314,-2.9716926947264914,-0.61006957189972466,0.45409206044838557,"D",null,"less than or equal to the lookup_value."]
["Stock 14",2.5267493678203428,-0.35290903913042637,-0.1278128675097765,1.3765094737445729,3.4225369349247128,"D"]
["Stock 15",6.2654532552664737,6.7321997368478304,1.4225290289587758,4.2403505772517391,18.660532598324821,"A",null,"Bins","Count"]
["Stock 16",6.2222627467992719,0.4737998440513751,2.5930190895540157,-1.6380633412576258,7.6510183391470381,"B",null,0,{"$f":"FREQUENCY(F5:F33,I20:I33)","v":1},{"$f":"getformula(J20)","v":"<--  {=FREQUENCY(F5:F33,I20:I33)}"}]
["Stock 17",-1.2667117474192497,0.75215712756814757,3.8493613664546817,0.50987423640347407,3.8446809830070534,"D",null,2,2,{"$f":"getformula(J21)","v":"<--  {=FREQUENCY(F5:F33,I20:I33)}"}]
["Stock 18",0.10983358670119392,-0.75064144865978522,-0.67324273768384524,6.9851200369356032,5.6710694372931663,"C",null,4,2,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 19",-1.6272920507468853,6.0182338765403927,0.82388275114462051,-1.1451114586885198,4.0697131182496076,"C",null,6,4,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 20",-1.5742468923135273,2.0558333959375243,4.6392195399063612,4.9511357896854387,10.071941833215796,"A",null,8,4,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 21",5.1012670673151774,5.9333812952594744,-1.9873008893338813,2.529593957851004,11.576941431091775,"A",null,10,3,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 22",5.6395555190960511,6.0847994053344738,0.51306565150360406,5.0651529341153427,17.30257351004947,"A",null,12,5,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 23",6.9831360403672775,4.3902944463848605,0.66673474157163426,6.5325493872525886,18.572714615576359,"A",null,14,3,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 24",5.6791174477514126,-0.31370972111104223,1.7182406451596046,2.8474905793001604,9.9311389511001344,"B",null,16,0,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 25",1.6707515925676937,2.4017010789449591,4.5472946842127611,5.3319266969872334,13.951674052712647,"A",null,18,1,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 26",4.6460365571064015,3.7770780105296922,4.9049437238352374,-1.9210026075316817,11.407055683939651,"A",null,20,2,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 27",5.6702561891721484,5.935013213996843,3.7042633121299602,5.7902257994659845,21.099758514764936,"A",null,22,1,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 28",6.8541545768723626,5.0776429296031367,3.6789694843410343,6.4943071437093796,22.105074134525914,"A",null,24,1,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
["Stock 29",3.0358542565013193,-2.0289246302625226,-0.66548686963019055,3.9216513148466206,4.2630940714552263,"C",null,26,0,"<--  {=FREQUENCY(F5:F33,I20:I33)}"]
[null,{"$f":"B$4","v":"Qtr1"},{"$f":"C$4","v":"Qtr2"},{"$f":"D$4","v":"Qtr3"},{"$f":"E$4","v":"Qtr4"},{"$f":"F$4","v":"Annual"}]
[null,">-100",">0",">0",">0",">10"]
["Mean",{"$f":"DAVERAGE(B$4:B$33,1,B$34:B$35)","v":2.6122616884486147},{"$f":"DAVERAGE(C$4:C$33,1,C$34:C$35)","v":3.9689322929514259},{"$f":"DAVERAGE(D$4:D$33,1,D$34:D$35)","v":3.2569316678509623},{"$f":"DAVERAGE(E$4:E$33,1,E$34:E$35)","v":4.3540618718050599},{"$f":"DAVERAGE(F$4:F$33,1,F$34:F$35)","v":14.67620381394422}]
["Minimum",{"$f":"DMIN(B$4:B$33,1,B$34:B$35)","v":-1.991506970474229},{"$f":"DMIN(C$4:C$33,1,C$34:C$35)","v":0.4737998440513751},{"$f":"DMIN(D$4:D$33,1,D$34:D$35)","v":1.6052926258835143E-2},{"$f":"DMIN(E$4:E$33,1,E$34:E$35)","v":8.5996882307721734E-3},{"$f":"DMIN(F$4:F$33,1,F$34:F$35)","v":10.065867623995407}]
["Maximum",{"$f":"DMAX(B$4:B$33,1,B$34:B$35)","v":6.9831360403672775},{"$f":"DMAX(C$4:C$33,1,C$34:C$35)","v":6.7321997368478304},{"$f":"DMAX(D$4:D$33,1,D$34:D$35)","v":6.4801923799640946},{"$f":"DMAX(E$4:E$33,1,E$34:E$35)","v":6.9851200369356032},{"$f":"DMAX(F$4:F$33,1,F$34:F$35)","v":22.105074134525914}]
["Number",{"$f":"DCOUNTA(B$4:B$33,1,B$34:B$35)","v":29},{"$f":"DCOUNTA(C$4:C$33,1,C$34:C$35)","v":21},{"$f":"DCOUNTA(D$4:D$33,1,D$34:D$35)","v":19},{"$f":"DCOUNTA(E$4:E$33,1,E$34:E$35)","v":21},{"$f":"DCOUNTA(F$4:F$33,1,F$34:F$35)","v":13}]