{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Vinayak Portfolio"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Vinayak Portfolio","index":0,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Sr.No","SCRIP","BUY PRICE","MARKET PRICE","QUANTITY","GAIN/LOSS (%)",null,"Buy Value ","Allocation",null,"Market Price ","Allocation",null,"Diff"]
[1,"ADANI PORTS & SEZ",226.31,389.25,70,72,null,{"$f":"+C2*E2","v":15841.7},{"$f":"+H2/$H$31","v":2.7571483278341032E-2},null,{"$f":"+D2*E2","v":27247.5},{"$f":"+K2/$K$31","v":3.3254051249011672E-2},null,{"$f":"+L2-I2","v":5.6825679706706406E-3}]
[2,"ADVANCED ENZYME TECHNOLOGIES LTD",327.33,289.55,45,-11.5,null,{"$f":"+C3*E3","v":14729.849999999999},{"$f":"+H3/$H$31","v":2.5636378227555854E-2},null,{"$f":"+D3*E3","v":13029.75},{"$f":"+K3/$K$31","v":1.5902081815278826E-2},null,{"$f":"+L3-I3","v":-9.7342964122770284E-3}]
[3,"ALKEM LABORATORIES",1050,1756.8,14,67.3,null,14700,2.5584426178479149E-2,null,{"$f":"+D4*E4","v":24595.200000000001},3.0017067300841981E-2,null,4.4326411223628327E-3]
[4,"AUROBINDO PHARMA",656.28,743.6,46,13.3,null,30188.879999999997,5.254184841979357E-2,null,34205.599999999999,4.1746023503190878E-2,null,-1.0795824916602692E-2]
[5,"AVANTI FEEDS",1676.28,1861.8,18,11.1,null,30173.040000000001,5.2514279895258399E-2,null,33512.400000000001,4.090001163693472E-2,null,-1.1614268258323679E-2]
[6,"BAJAJ ELECTRICALS",205.39,340,90,65.5,null,18485.099999999999,3.2172154853864279E-2,null,30600,3.734559017230047E-2,null,5.1734353184361911E-3]
[7,"BERGER PAINTS",251.5,243.45,20,-3.2,null,5030,8.7543988896428646E-3,null,4869,5.9423424362395755E-3,null,-2.8120564534032891E-3]
[8,"BRITANNIA",2825.3,4205,2,48.8,null,5650.6,9.8345141880349859E-3,null,8410,1.0263935076766241E-2,null,4.2942088873125506E-4]
[9,"CANFIN HOMES",2902.01,2775,7,-4.4000000000000004,null,20314.07,3.5355362197242036E-2,null,19425,2.3707127094671133E-2,null,-1.1648235102570903E-2]
[10,"DILIP BUILDCON LTD",355.8,629.4,55,76.900000000000006,null,19569,3.4058614686167242E-2,null,34617,4.2248114215507365E-2,null,8.1894995293401232E-3]
[11,"EDELWEISS FINANCIAL",227,243.9,40,7.4,null,9080,1.580316936738712E-2,null,9756,1.1906652866698151E-2,null,-3.8965165006889686E-3]
[12,"HDFC",1386.54,1752.9,17,26.4,null,23571.18,4.1024157459159466E-2,null,29799.300000000003,3.6368380562791944E-2,null,-4.6557768963675222E-3]
[13,"HEALTHCARE GLOBAL ENTER.",269.95,270.35000000000002,75,0.2,null,20246.25,3.5237325749390029E-2,null,20276.25,2.4746030154611354E-2,null,-1.0491295594778675E-2]
[14,"ICICI PRUDENTIAL LIFE INSURANCE ",334,429.05,77,28.5,null,25718,4.476056275225352E-2,null,33036.85,4.0319629434109959E-2,null,-4.4409333181435612E-3]
[15,"J.KUMAR INFRA",173.75,197.2,180,13.5,null,31275,5.443217202258064E-2,null,35496,4.3320884599868548E-2,null,-1.1111287422712092E-2]
[16,"KARNATAKA BANK",132.99,150.25,260,13,null,34577.4,6.0179791683247955E-2,null,39065,4.7676649675846991E-2,null,-1.2503142007400964E-2]
[17,"KITEX GARMENTS",265.89999999999998,234.2,20,-11.9,null,5318,9.2556447902824562E-3,null,4684,5.7165602734331831E-3,null,-3.5390845168492731E-3]
[18,"L&T FINANCE HOLDINGS",56.38,195.55,951,246.9,null,53617.380000000005,9.3317680305677858E-2,null,185968.05000000002,0.22696361373993082,null,0.13364593343425296]
[19,"MOTHERSON SUMI",199.82,308.35000000000002,117,54.3,null,23378.94,4.0689575820482535E-2,null,36076.950000000004,4.4029901613286786E-2,null,3.340325792804251E-3]
[20,"PETRONET LNG",223.7,227.8,100,1.8,null,22370,3.8933579157318265E-2,null,22780,2.7801717128268129E-2,null,-1.1131862029050137E-2]
[21,"POWER GRID",208.2,214.85,100,3.2,null,20820,3.6235901567070468E-2,null,21485,2.6221241988623387E-2,null,-1.0014659578447081E-2]
[22,"RELAXO FOOTWEARS",422,502.9,50,19.2,null,21100,3.6723223970470072E-2,null,25145,3.068806747982011E-2,null,-6.0351564906499615E-3]
[23,"SYNGENE INTERNATIONAL",431.56,448.2,55,3.9,null,23735.8,4.1310668223615329E-2,null,24651,3.0085168082920881E-2,null,-1.1225500140694449E-2]
[24,"THYROCARE TECHNOLOGIES",584.65,687.5,20,17.600000000000001,null,11693,2.0350931653398414E-2,null,13750,1.6781106695069655E-2,null,-3.5698249583287593E-3]
[25,"TRENT LTD",272.5,299.45,75,9.9,null,20437.5,3.5570184355283509E-2,null,22458.75,2.7409649453665138E-2,null,-8.1605349016183708E-3]
[26,"V GUARD IND.",186.12,185.05,105,-0.6,null,19542.600000000002,3.4012667145275281E-2,null,19430.25,2.371353442631834E-2,null,-1.0299132718956942E-2]
[27,"VOLTAS",231,526.9,10,128.1,null,2310,4.0204098280467232E-3,null,5269,6.4305200855506927E-3,null,2.4101102575039696E-3]
[28,"VRL LOGISTICS",294,333.3,50,13.4,null,14700,2.5584426178479149E-2,null,16665,2.0338701314424425E-2,null,-5.2457248640547238E-3]
[29,"WELSPUN INDIA",54.65,76.900000000000006,300,40.700000000000003,null,16395,2.8534467156201743E-2,null,23070,2.8155645924018688E-2,null,-3.7882123218305544E-4]
[null,null,null,null,null,null,null,{"$f":"SUM(H2:H30)","v":574568.29},null,null,{"$f":"SUM(K2:K30)","v":819373.85}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Net Gain ",null,{"$f":"+K31-H31","v":244805.55999999994}]
[null,null,null,null,null,null,null,null,"Profit % ",null,{"$f":"+K35/H31","v":0.42606869237423445}]
[null,"Note : around 2 lakh rs portfolio created when Feb 2016 market crashed and reamining portfolio added afterwards "]