JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Totals of a Stock Portfolio
I am trading at the stock Market and a newbee....Need advice to added up totals of a particular trade on a specific date....the catch is the trades are of 365 days and the rows are about 7000+...Will VBA help or Excel Formulas....Either way...if VBA ...it will be helpful to execute a vba macro...
In short I need the Totals of one specific stock ( STT / Fees / Govt Tax / Qty traded in Buy or Sell / Amounts involved ) for each day and each stock.
I may have traded in 5 stock...So will need data for all 5 stock for that date
Stock_01.jpg
108.8 KB
· Views: 14
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
cannot manipulate data in a picture. Please reload sample data and mocked up solution using XL2BB
tradebook-FKP182-EQ (21).xlsx A B C D E F G H I J K 1 Symbol ISIN Trade Date Exchange Segment Series Trade Type Auction Quantity Price 2 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 7 10541.7 3 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 7 10541.65 4 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 1 10541.6 5 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 10 10542.25 6 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 6 10542.15 7 MARUTI INE585B01010 2023-12-04 BSE EQ A buy FALSE 19 10542 8 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 11 1229.8 9 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 47 1229.75 10 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 63 1229.75 11 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 15 1229.4 12 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 5 1229.5 13 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 42 1229.85 14 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 4 1229.85 15 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 97 1229.8 16 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 58 1229.8 17 SUNPHARMA INE044A01036 2023-12-04 NSE EQ EQ buy FALSE 58 1229.8 18 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 19 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 20 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 21 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 22 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 23 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 24 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 25 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 26 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 27 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 28 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 29 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.2 30 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2045.2 31 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 13 2045.25 32 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 72 2045.3 33 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 42 2045.35 34 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 24 2045.35 35 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 36 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 37 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 21 2045.4 38 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 39 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 40 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 41 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 42 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 43 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 44 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 45 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 46 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.4 47 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 48 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.4 49 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2045.45 50 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 36 2045.5 51 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 8 2045.55 52 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 37 2045.55 53 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 65 2045.55 54 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 24 2045.7 55 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2044.35 56 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 9 2044.35 57 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 11 2044.35 58 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 30 2044.8 59 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 1 2044.8 60 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 29 2044.85 61 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 62 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 63 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 64 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 34 2044.85 65 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 66 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 67 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 68 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 69 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 70 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 71 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 72 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 73 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 74 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 75 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 76 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 77 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2044.85 78 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2044.85 79 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 3 2044.85 80 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2044.85 81 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2044.85 82 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 34 2044.9 83 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 19 2045 84 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 26 2045 85 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 47 2045 86 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 33 2045 87 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 88 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 89 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 90 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 91 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 92 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 93 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 94 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 95 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 96 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 97 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2045.1 98 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2045.1 99 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2045.1 100 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2045.1 101 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 42 2048.5 102 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 37 2048.6 103 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2048.75 104 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 4 2048.8 105 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 34 2048.8 106 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 36 2048.95 107 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 22 2049 108 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 34 2049 109 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2049.05 110 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 32 2049.15 111 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 18 2049.55 112 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2049.55 113 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 11 2049.55 114 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 39 2049.95 115 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2049.95 116 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 6 2049.95 117 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 8 2049.95 118 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 59 2049.95 119 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 78 2049.95 120 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 3 2049.95 121 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 6 2049.95 122 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 5 2049.95 123 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 4 2049.95 124 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 8 2049.95 125 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 2 2048.45 126 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 36 2048.45 127 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 16 2048.45 128 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 81 2048.35 129 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 8 2048.3 130 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 5 2048.3 131 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 64 2048.3 132 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 42 2048.25 133 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 37 2048.2 134 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 58 2048.15 135 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 53 2049.95 136 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 108 2049.95 137 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 34 2051.3 138 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 23 2050 139 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 71 2050.15 140 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 81 2050.35 141 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 17 2050.4 142 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.4 143 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.4 144 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.4 145 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 43 2050.4 146 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 64 2050.6 147 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 46 2050.8 148 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 15 2050.9 149 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 150 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 151 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 152 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 153 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 154 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 155 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 156 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 157 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 158 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 159 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 160 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 161 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 162 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 163 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 164 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 165 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 166 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 167 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 168 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2050.95 169 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 10 2050.95 170 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2050.95 171 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2050.95 172 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2050.95 173 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 4 2050.95 174 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2050.95 175 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 57 2051 176 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 33 2051.1 177 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 24 2051.2 178 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 179 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2051.25 180 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 181 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2051.25 182 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 183 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2051.25 184 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 185 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2051.25 186 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 187 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 5 2051.25 188 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 11 2051.25 189 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 31 2051.3 190 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 34 2051.35 191 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2051.35 192 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2051.35 193 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 22 2051.35 194 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2051.35 195 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2051.35 196 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2051.35 197 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2051.35 198 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 12 2051.35 199 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 6 2051.35 200 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ buy FALSE 7 2051.35 201 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 4 2050.3 202 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2052 203 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2052 204 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 68 2051.75 205 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 21 2051.55 206 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 1 2051.35 207 SHRIRAMFIN INE721A01013 2023-12-04 NSE EQ EQ sell FALSE 27 2051.35
In short, I need the Traded Sum for Maruti, of a particular day...If I get this I can tweak the other Worksheet
You can generate the below result using Pivot Table :
Pivot.jpg
132.2 KB
· Views: 4
Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji