How to Freeze Share holdings (Quantity) as per debit balance

stahil

New Member
Joined
Apr 28, 2018
Messages
1
Hi
It would be grateful if anyone can tell how to calculate QUANTITY to be freeze depend on the Debit Amt. How can we automate in Excel for repeat client code basis as shown in sample column for Freeze Qty & Freeze Value (should be as per debit amount). If holding value is more than Debit amount than partial quantity in excess of debit can be released.



Client CodeISINScriptQuantityRateHolding ValueDebit Amt.MapFreeze QtyFreeze Value
2902INE170V01019Salasar Techno Engineering Limited500308.86154430106427N345106557
2902INE778B01029Ester Industries Limited500043.99219950106427N00
2950INE426D01013Goa Carbon Limited200571.4911429857680Y10157720
3051INE160A01022PUNJAB NATIONAL BANK20060.7212144241Y4243
6021INE371A01025Graphite India Limited40548.62194421850Y4021944
A0330INE029A01011BHARAT PETROLEUM CORP LT50308.341541714934Y4915109
A0330INE775B01025KWALITY LIMITED10012.74127414934Y00
A0330INE209L01016COMMERCIAL ENG & CO. LTD2000021.9143820014934Y00
A0447INE711A01022Walchandnagar Industries Limited200138.072761427212Y19827338
A08022INE140A01024Piramal Enterprises Limited102234.1322341214Y12234
A0817INE750C01026Marksans Pharma Limited40017.2468962010Y1172017
A0817INE694A01020Unitech Limited50014.1270602010Y00
A0817INE775B01025KWALITY LIMITED15012.7419112010Y00
A0817INE754A01014SUBEX LIMITED12006.1573802010Y00
A0817INE776C01039GMR INFRASTRUCTURE LTD.3001.344022010Y00
A0817INE549A01026Hindustan Construction Company Limited5000.94502010Y00
A0817INE550C01020Urja Global Limited200002010Y00
A0858INE855B01025RAIN INDUSTRIES LIMITED220269.935938536205Y13536441
A0862INE692A01016UNION BANK OF INDIA63461.83918126520Y43026574
A7000INE338A01016THIRUMALAI CHEMICALS LTD1001925.79192579258952Y100192579
A7000INE192R01011AVENUE SUPERMARTS LIMITED2501278.28319570258952Y5266471
A7000INE878B01027KEI INDUSTRIES LTD.500361.7180850258952Y00
AA2014INE423A01024Adani Enterprises Limited10096.0596053935Y413938
AK402INE243D01012BF UTILITIES LIMITED50336.53168279464N299759
AK402INE775B01025kwality limited40012.7450969464N00
AK408INE208A01029ASHOK LEYLAND LTD11126.1713881358Y111388
AKJ1INE614G01033Reliance Power Limited40014.7659043826N2603838
AM11INE092T01019IDFC BANK LIMITED20028.8357664834Y1684843
B03200INE908D01010SHAKTI PUMPS (I) LTD10546.59546678954Y105466
B03200INE081A01012Tata Steel Limited25509.861274778954Y2512747
B03200INE276C01014EIH Associated Hotels Limited10447.32447378954Y104473
B03200INE264T01014CAPACITE INFRAPROJECT LTD75304.412283178954Y7522831
B03200INE283H01019Royal Orchid Hotels Limited25143.85359678954Y253596
B03200INE686A01026ITD Cementation India Limited50132.47662478954Y506624
B03200INE643A01035JTEKT INDIA LIMITED5085.53427778954Y504277
B03200INE087A01019Kesoram Industries Limited5084.98424978954Y504249
B03200INE684F01012Firstsource Solutions Limited10037.82378278954Y1003782
B03200INE426A01027ALEMBIC LIMITED2535.6389178954Y25891
B03200INE878E01021Setco Automotive Limited10033.39333978954Y1003339
B03200INE172N01012ADLABS ENTERTAINMENT LTD.10031.18311878954Y1003118
B03200INE414A01015Madras Fertilizers Limited20010.97219478954Y2002194
B03200INE294A01037Ballarpur Industries Limited2003.5270478954Y200704
B1547INE062A01020State Bank of India10197.531975954Y5988
B20INE358A01014Abbott India Limited105433.1854332163468Y1054332
B20INE797F01012Jubilant Foodworks Limited102129.3121293163468Y1021293
B20INE702C01019APL Apollo Tubes Limited11893.581894163468Y11894
B20INE192R01011AVENUE SUPERMARTS LIMITED101278.2812783163468Y1012783
B20INE031B01049Ajanta Pharma Limited101192.2311922163468Y1011922
B20INE674A01014Tata Sponge Iron Limited10921.279213163468Y109213
B20INE844O01022Gujarat Gas Limited50742.5237126163468Y5037126
B20INE176A01028Bata India Limited62673.0941732163468Y2315481
B20INE774D01024Mahindra & Mahindra Financial Services Limited10433.084331163468Y00
B20INE196A01026MARICO LIMITED30263.687910163468Y00
B20INE736A01011CENTRAL DEPO SER (I) LTD30254.237627163468Y00
B20INE094A01015Hindustan Petroleum Corporation Limited30245.837375163468Y00
B20INE095N01023NBCC (India) Limited500167.9583975163468Y00
B20INE172A01027Castrol India Limited100161.0816108163468Y00
B20INE421A01028ABAN OFFSHORE LTD.10137.81378163468Y00
B20INE028A01039BANK OF BARODA300107.1732151163468Y00
B20INE263A01024BHARAT ELECTRONICS LTD80105.838466163468Y00
B20INE026A01025Gujarat State Fertilizers & Chemicals Limited60101.566094163468Y00
B20INE615H01020TITAGARH WAGONS LTD.2090.241805163468Y00
B20INE250B01029VINYL CHEMICALS (I) LTD.2982.382389163468Y00
B20INE171A01029The Federal Bank Limited10072.277227163468Y00
B20INE084A01016BANK OF INDIA45067.5330389163468Y00
B226INE830Q01018Manaksia Coated Metals & Industries Limited70222.98161325063Y2215079
G0844INE029A01011Bharat Petroleum Corporation Limited25308.3477094075Y144317
G0844INE094A01015Hindustan Petroleum Corporation Limited25245.8361464075Y00
H55INE391D01019TRF LIMITED100195.021950220291Y10019502
I003INE572E01012PNB HOUSING FIN LTD.291172.843401253960Y2934012
I003INE484J01027Godrej Properties Limited1178700.2182484753960Y2920306
I003INE265F01028ENTERTAIN NET. IND. LTD.454590.2326796453960Y00
I003INE461B01014Repro India Limited512578.2829607953960Y00
I003INE765D01014WPIL LTD.2000569.2113840053960Y00
I003INE908D01010Shakti Pumps (India) Limited225546.5912298353960Y00
I003INE193E01025BAJAJ ELECT.LTD4574544.9249237353960Y00
I003INE934S01014GNA AXLES LIMITED471465.7921938753960Y00
I003INE898S01029Majesco Limited79463.643662853960Y00
I003INE671H01015Sobha Limited424459.6619489653960Y00
I003INE795G01014HDFC STAND LIFE IN CO LTD910424.1138594053960Y00
I003INE545U01014Bandhan Bank Limited4958415.62206064453960Y00
I003INE790G01031Shilpa Medicare Limited15393.86590853960Y00
I003INE274F01020WESTLIFE DEVELOPMENT LTD.2000373.5574710053960Y00
I003INE335A01012Surya Roshni Limited155353.465478653960Y00
I003INE054A01027VIP Industries Limited2359327.1577174753960Y00
I003INE485A01015CENTURY ENKA LTD1318311.3141030753960Y00
I003INE863B01011Premier Explosives Limited233301.617027553960Y00
I003INE849A01020TRENT LTD4682293.69137505753960Y00
I003INE435A01028International Paper APPM Limited2980269.8980427253960Y00
I003INE306L01010Quick Heal Technologies Limited5013269.47135085353960Y00
I003INE270I01014VISHNU CHEMICALS LIMITED78243.31897753960Y00
I003INE192A01025Tata Global Beverages Limited915234.7621480553960Y00
I003INE032A01023BOMBAY DYEING & MFG. CO L9140221201994053960Y00
I003INE298G01027Ajmera Realty & Infra India Limited546220.8512058453960Y00
I003INE062A01020State Bank of India1000197.5319753053960Y00
I003INE597J01018Shalby Limited346180.296238053960Y00
I003INE164A01016Balmer Lawrie & Company Limited930178.5416604253960Y00
I003INE034S01021Arvind SmartSpaces Limited903153.0713822253960Y00
I003INE085A01013Chambal Fertilizers & Chemicals Limited3981141.4856323253960Y00
I003INE305A01015TOURISM FINANCE CORP. OF1795126.2122654753960Y00
I003INE323I01011Puravankara Limited6554115.0975430053960Y00
I003INE643K01018ARIHANT SUPERSTRUCT LTD469102.634813353960Y00
I003INE993A01026MAN INDUSTRIES (I) LTD.1958100.6319703453960Y00
I003INE338D01028BODAL CHEMICALS LTD702792.8465238753960Y00
I003INE522D01027Manappuram Finance Limited365890.9133254953960Y00
I003INE007B01023Geojit Financial Services Limited87379.346926453960Y00
I003INE229H01012Nitin Spinners Limited182174.3313535553960Y00
I003INE364A01020Jayshree Tea & Industries Limited389773.128487153960Y00
I003INE818H01020LT Foods Limited321065.7821115453960Y00
I003INE386C01029Astra Microwave Products Limited34064.042177453960Y00
I003INE812G01025SMS Pharmaceuticals Limited556755.5630930353960Y00
I003INE080B01012KOHINOOR FOODS LIMITED91143.043920953960Y00
I003INE531E01026HINDUSTAN COPPER LTD727341.4530146653960Y00
I003INE082A01010Kopran Limited9239.88366953960Y00
I003INE684F01012Firstsource Solutions Limited1355737.8251272653960Y00
I003INE148A01019TAMILNADU PETROPRODUCTS L1027833.8134749953960Y00
I003INE195N01013PROZONE INTU PROPRTIS LTD1011225.5825866553960Y00
I003INE185H01016Celebrity Fashions Limited91020.141832753960Y00

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,089,202
Messages
5,406,814
Members
403,107
Latest member
kyriakos kyriakou

This Week's Hot Topics

Top