Spreadsheet: 776145d1649528693-extract-selected-rows-as-per-specific-value-in-adjacent-cell-extract-only-seleted-stocks
Sheet: Sheet2

Volume & Delivery Breakout - |  |  | 2022-04-05 00:00:00 |  |  |  | 3P | VDP | XTRA |  | STOCK w.r.t. |  | SECTOR w.r.t. |  | NIFTY w.r.t.
Security Symbol | Industry | Main Sector | Volume BO | Del BO | Del% BO |  |  |  |  |  | Weekly | Monthly | Weekly | Monthly | Weekly | Monthly
INDUSINDBK | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.7604395831437768 | 0.8792574426862183 | 1.15622161671208 |  | 3P |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
HEROMOTOCO | AUTOMOBILE | NIFTY AUTO | 0.5049174822490885 | 0.4916767050091985 | 0.9739583333333334 |  |  | VDP | XTRA |  | R-B | R-B | W-H | M-H | W-H | M-H
ONGC | OIL & GAS | NIFTY CPSE | 1.13014112356177 | 0.8831130204134862 | 0.7814121362508459 |  |  |  | XTRA |  | R-B | R-B | W-H | M-H | W-H | M-H
BAJAJ-AUTO | AUTOMOBILE | NIFTY AUTO | 0.8086156222513032 | 0.7969494383123885 | 0.9856055932551923 |  |  | VDP |  |  | W-H | M-H | W-H | M-H | W-H | M-H
ADANIPORTS | SERVICES | NIFTY INFRASTRUCTURE | 1.534639514833012 | 1.241618331682419 | 0.8090874379534173 |  | 3P |  | XTRA |  | W-H | M-H | W-H | M-H | W-H | M-H
BRITANNIA | CONSUMER GOODS | NIFTY MNC | 0.8600701555623339 | 0.9553788130735974 | 1.110678098207327 |  |  | VDP | XTRA |  | W-H | R-B | W-H | M-H | W-H | M-H
HINDALCO | METALS | NIFTY METAL | 0.4459071837004907 | 0.3791105224962539 | 0.8502568154879494 |  | 3P |  | XTRA |  | R-B | R-B | W-H | M-H | W-H | M-H
NESTLEIND | CONSUMER GOODS | NIFTY MNC | 0.999949728534084 | 1.006262484478756 | 1.00622852233677 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
CIPLA | PHARMA | NIFTY PHARMA | 0.9587442007116797 | 1.157335123290247 | 1.207218960643618 |  |  |  | XTRA |  | W-L | R-B | W-H | M-H | W-H | M-H
HCLTECH | IT | NIFTY IT | 1.154384684179784 | 1.031351341330512 | 0.8934723481414324 |  |  |  |  |  | W-H | R-B | W-H | R-B | W-H | M-H
TCS | IT | NIFTY IT | 1.571592959645457 | 1.335379581365264 | 0.8496397117694156 |  |  |  |  |  | W-H | M-H | W-H | R-B | W-H | M-H
MARUTI | AUTOMOBILE | NIFTY AUTO | 0.994100144797965 | 0.9844723983290693 | 0.9901363504496665 |  |  | VDP |  |  | W-H | R-B | W-H | M-H | W-H | M-H
EICHERMOT | AUTOMOBILE | NIFTY AUTO | 1.878259473394821 | 1.603794920399574 | 0.854089219330855 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
SHREECEM | CEMENT & CEMENT PRODUCTS | NIFTY COMMODITIES | 1.381148061851303 | 1.424389063634164 | 1.031125071387778 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
KOTAKBANK | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.5335424105568238 | 0.6517223798474582 | 1.22153687997944 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
HINDUNILVR | CONSUMER GOODS | NIFTY FMCG | 0.7546589849257451 | 0.8758028373166282 | 1.160588353818255 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
TATAMOTORS | AUTOMOBILE | NIFTY AUTO | 1.529193473340401 | 1.129889757746542 | 0.7386511024643321 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
AXISBANK | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.6691860596145015 | 0.6876504460309881 | 1.027720739219713 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
SBIN | FINANCIAL SERVICES | NIFTY PSU BANK | 0.8367002977638921 | 0.9561619080578332 | 1.142732049036778 |  |  |  |  |  | R-B | M-H | W-H | M-H | W-H | M-H
INFY | IT | NIFTY IT | 0.74307020814837 | 0.678563911600421 | 0.9131147540983607 |  |  |  |  |  | W-L | R-B | W-H | R-B | W-H | M-H
GRASIM | CEMENT & CEMENT PRODUCTS | NIFTY COMMODITIES | 1.492249578599173 | 1.383515488251829 | 0.927087268605969 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
NTPC | POWER | NIFTY CPSE | 1.551976175410831 | 1.673245427818946 | 1.078193548387097 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
ASIANPAINT | CONSUMER GOODS | NIFTY INDIA CONSUMPTION | 0.9228297513695743 | 0.9104869010242421 | 0.9865168539325843 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
BPCL | OIL & GAS | NIFTY PSE | 0.4500489305946698 | 0.318033319486957 | 0.7066757725798191 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
ITC | CONSUMER GOODS | NIFTY FMCG | 1.708836479731003 | 1.579509111712667 | 0.9243341404358354 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
HDFCBANK | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.3173142555687234 | 0.3469068748727945 | 1.093446299526539 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
M&M | AUTOMOBILE | NIFTY AUTO | 0.6413179607277968 | 0.6868889934045741 | 1.07103825136612 |  | 3P |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
JSWSTEEL | METALS | NIFTY METAL | 0.7191756842061022 | 0.4074843332148126 | 0.5666210670314639 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
BAJFINANCE | FINANCIAL SERVICES | NIFTY FINANCIAL SERVICES | 1.02126488079645 | 0.8514603682279993 | 0.8336973478939158 |  |  |  |  |  | R-B | M-H | W-H | M-H | W-H | M-H
TITAN | CONSUMER GOODS | NIFTY INDIA CONSUMPTION | 1.113199695437528 | 0.8222633415796569 | 0.7385849444672974 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
POWERGRID | POWER | NIFTY CPSE | 1.732771623686117 | 1.781305633586763 | 1.027985074626866 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
IOC | OIL & GAS | NIFTY PSE | 0.9273508002724332 | 1.27239343555781 | 1.372169931315187 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
DIVISLAB | PHARMA | NIFTY PHARMA | 1.008048898028334 | 1.163903703703704 | 1.154664686958674 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
ULTRACEMCO | CEMENT & CEMENT PRODUCTS | NIFTY COMMODITIES | 1.535696981894348 | 1.984372580894875 | 1.292056074766355 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
ICICIBANK | FINANCIAL SERVICES | NIFTY PRIVATE BANK | 0.7148819316111839 | 0.7642611306613841 | 1.069019302008189 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
BAJAJFINSV | FINANCIAL SERVICES | NIFTY FINANCIAL SERVICES | 1.188483757406117 | 1.954781697214983 | 1.645252716107699 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
UPL | FERTILISERS & PESTICIDES | NIFTY COMMODITIES | 2.092784274784717 | 1.866595662363421 | 0.891965389369592 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
TATASTEEL | METALS | NIFTY METAL | 0.9085134100144796 | 0.5062909453452461 | 0.5571538659131775 |  |  |  |  |  | W-H | R-B | W-H | M-H | W-H | M-H
HDFCLIFE | FINANCIAL SERVICES | NIFTY FINANCIAL SERVICES | 0.2042918493242356 | 0.2522032248906124 | 1.2344057780696 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
DRREDDY | PHARMA | NIFTY PHARMA | 1.847240293485876 | 3.344185970529618 | 1.810696095076401 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
TECHM | IT | NIFTY IT | 1.91444454525702 | 1.849755018887659 | 0.9662024949231216 |  |  |  |  |  | W-L | R-B | W-H | R-B | W-H | M-H
LT | CONSTRUCTION | NIFTY INFRASTRUCTURE | 0.8789432311775136 | 0.7693663373091223 | 0.8753241941459801 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
SUNPHARMA | PHARMA | NIFTY PHARMA | 1.551739813516037 | 1.874752118201366 | 1.20819630660258 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
WIPRO | IT | NIFTY IT | 1.452412322204241 | 1.383373293557552 | 0.9525371406521319 |  |  |  |  |  | R-B | R-B | W-H | R-B | W-H | M-H
TATACONSUM | CONSUMER GOODS | NIFTY FMCG | 1.860108031738874 | 2.300449281301701 | 1.236779560308972 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
RELIANCE | OIL & GAS | NIFTY ENERGY | 1.658418656865904 | 2.130710885745455 | 1.284674404879008 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
HDFC | FINANCIAL SERVICES | NIFTY FINANCIAL SERVICES | 0.1811037942544632 | 0.2076998201149333 | 1.146825396825397 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
SBILIFE | FINANCIAL SERVICES | NIFTY FINANCIAL SERVICES | 0.4291840325656732 | 0.3204890151856578 | 0.7467510259917921 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
BHARTIARTL | TELECOM | NIFTY INFRASTRUCTURE | 0.6900638813229437 | 0.6340146281475949 | 0.9188233103705084 |  |  |  |  |  | W-H | M-H | W-H | M-H | W-H | M-H
COALINDIA | METALS | NIFTY CPSE | 0.804780085589883 | 0.8095428601143013 | 1.005952380952381 |  |  |  |  |  | R-B | R-B | W-H | M-H | W-H | M-H
MTARTECH | 0 | 0