Spreadsheet: 776491d1649759768-based-on-adjacent-cell-value-extract-specific-cells-to-other-sheet-extract-only-seleted-stocks-copy
Sheet: Sheet2

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