|
|
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from NSE_NIFTY a, eod_gl_NSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_NSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => SEACHEIN
[COMPANY_NAME] => UPL
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 538.65
[ENCL] => 636.90
[DIFF] => 98.25
[PERC] => 18.24
)
[1] => Array
(
[IRISCODE] => ZEETELEF
[COMPANY_NAME] => ZEEL
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 103.66
[ENCL] => 107.80
[DIFF] => 4.14
[PERC] => 3.99
)
[2] => Array
(
[IRISCODE] => NATALUCO
[COMPANY_NAME] => NAT ALUM CO
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 189.53
[ENCL] => 195.88
[DIFF] => 6.35
[PERC] => 3.35
)
[3] => Array
(
[IRISCODE] => INDOILCO
[COMPANY_NAME] => INDIAN OIL C
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 122.58
[ENCL] => 124.46
[DIFF] => 1.88
[PERC] => 1.53
)
)
NSE (NIFTY) 7 Days Gainers |
04-Feb-2025 |
Company |
Latest Close |
Compared To |
Absolute Change |
% Change |
UPL |
636.90 |
538.65 |
98.25 |
18.24 |
ZEEL |
107.80 |
103.66 |
4.14 |
3.99 |
NAT ALUM CO |
195.88 |
189.53 |
6.35 |
3.35 |
INDIAN OIL C |
124.46 |
122.58 |
1.88 |
1.53 |
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from NSE_OTHERS a, eod_gl_NSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_NSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => CAPTRUST
[COMPANY_NAME] => CAPITAL TRUST
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 84.00
[ENCL] => 112.51
[DIFF] => 28.51
[PERC] => 33.94
)
[1] => Array
(
[IRISCODE] => MOTGENFI
[COMPANY_NAME] => MOT&GEN FIN
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 26.24
[ENCL] => 32.04
[DIFF] => 5.80
[PERC] => 22.10
)
[2] => Array
(
[IRISCODE] => AEGCHEIN
[COMPANY_NAME] => AEGIS LOGIS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 635.85
[ENCL] => 758.75
[DIFF] => 122.90
[PERC] => 19.33
)
[3] => Array
(
[IRISCODE] => BHACONFI
[COMPANY_NAME] => BHANDARI CONS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 17.06
[ENCL] => 20.25
[DIFF] => 3.19
[PERC] => 18.70
)
[4] => Array
(
[IRISCODE] => SEACHEIN
[COMPANY_NAME] => SEARCH CHEM
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 538.65
[ENCL] => 636.90
[DIFF] => 98.25
[PERC] => 18.24
)
[5] => Array
(
[IRISCODE] => BHABIJLE
[COMPANY_NAME] => BHARAT BIJLE
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 2899.05
[ENCL] => 3378.15
[DIFF] => 479.10
[PERC] => 16.53
)
[6] => Array
(
[IRISCODE] => PANBIOTE
[COMPANY_NAME] => PANACEA BIO
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 327.95
[ENCL] => 372.45
[DIFF] => 44.50
[PERC] => 13.57
)
[7] => Array
(
[IRISCODE] => FUJICIM
[COMPANY_NAME] => ZENSAR TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 786.25
[ENCL] => 885.10
[DIFF] => 98.85
[PERC] => 12.57
)
[8] => Array
(
[IRISCODE] => MORHOTEL
[COMPANY_NAME] => BLUE COAST
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 27.97
[ENCL] => 31.47
[DIFF] => 3.50
[PERC] => 12.51
)
[9] => Array
(
[IRISCODE] => MAHRUBTE
[COMPANY_NAME] => MAHA RUBTECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 213.87
[ENCL] => 240.48
[DIFF] => 26.61
[PERC] => 12.44
)
)
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from BSE_BSE30 a, eod_gl_BSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_BSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => MAHMAHIN
[COMPANY_NAME] => MAH & MAH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 2868.05
[ENCL] => 3190.35
[DIFF] => 322.30
[PERC] => 11.24
)
[1] => Array
(
[IRISCODE] => HCLTECHN
[COMPANY_NAME] => H C L TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1693.80
[ENCL] => 1733.60
[DIFF] => 39.80
[PERC] => 2.35
)
[2] => Array
(
[IRISCODE] => ICICIBCO
[COMPANY_NAME] => ICICI BANK
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1246.95
[ENCL] => 1268.45
[DIFF] => 21.50
[PERC] => 1.72
)
)
BSE (SENSEX) 7 Days Gainers |
04-Feb-2025 |
Company |
Latest Close |
Compared To |
Absolute Change |
% Change |
MAH & MAH |
3190.35 |
2868.05 |
322.30 |
11.24 |
H C L TECH |
1733.60 |
1693.80 |
39.80 |
2.35 |
ICICI BANK |
1268.45 |
1246.95 |
21.50 |
1.72 |
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from BSE_AGROUP a, eod_gl_BSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_BSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => MAHMAHIN
[COMPANY_NAME] => MAH & MAH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 2868.05
[ENCL] => 3190.35
[DIFF] => 322.30
[PERC] => 11.24
)
[1] => Array
(
[IRISCODE] => CASINDIA
[COMPANY_NAME] => CASTROL IND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 169.25
[ENCL] => 187.95
[DIFF] => 18.70
[PERC] => 11.05
)
[2] => Array
(
[IRISCODE] => GUJNARVF
[COMPANY_NAME] => GUJ NARMADA
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 524.55
[ENCL] => 576.90
[DIFF] => 52.35
[PERC] => 9.98
)
[3] => Array
(
[IRISCODE] => LAKME
[COMPANY_NAME] => TRENT
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 5447.90
[ENCL] => 5754.50
[DIFF] => 306.60
[PERC] => 5.63
)
[4] => Array
(
[IRISCODE] => NIIT
[COMPANY_NAME] => N I I T TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 142.15
[ENCL] => 148.80
[DIFF] => 6.65
[PERC] => 4.68
)
[5] => Array
(
[IRISCODE] => ASHLEYLA
[COMPANY_NAME] => ASHOK LEYLAND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 205.00
[ENCL] => 211.40
[DIFF] => 6.40
[PERC] => 3.12
)
[6] => Array
(
[IRISCODE] => HCLTECHN
[COMPANY_NAME] => H C L TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1693.80
[ENCL] => 1733.60
[DIFF] => 39.80
[PERC] => 2.35
)
[7] => Array
(
[IRISCODE] => ICICIBCO
[COMPANY_NAME] => ICICI BANK
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1246.95
[ENCL] => 1268.45
[DIFF] => 21.50
[PERC] => 1.72
)
[8] => Array
(
[IRISCODE] => LICHFINA
[COMPANY_NAME] => L I C HOUSING FIN
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 570.50
[ENCL] => 576.35
[DIFF] => 5.85
[PERC] => 1.03
)
[9] => Array
(
[IRISCODE] => ADAEXPOR
[COMPANY_NAME] => ADANI EXPORTS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 2286.85
[ENCL] => 2302.50
[DIFF] => 15.65
[PERC] => 0.68
)
)
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from BSE_B1GROUP a, eod_gl_BSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_BSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => GABINDIA
[COMPANY_NAME] => GABRIEL
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 397.10
[ENCL] => 487.50
[DIFF] => 90.40
[PERC] => 22.77
)
[1] => Array
(
[IRISCODE] => EXCINDUS
[COMPANY_NAME] => EXCEL IND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1149.45
[ENCL] => 1321.40
[DIFF] => 171.95
[PERC] => 14.96
)
[2] => Array
(
[IRISCODE] => ETEEVERE
[COMPANY_NAME] => EVEREST IND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 586.00
[ENCL] => 655.95
[DIFF] => 69.95
[PERC] => 11.94
)
[3] => Array
(
[IRISCODE] => BANPROIA
[COMPANY_NAME] => BANCO PROD
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 413.25
[ENCL] => 449.50
[DIFF] => 36.25
[PERC] => 8.77
)
[4] => Array
(
[IRISCODE] => MACMILLA
[COMPANY_NAME] => MACMILAN IND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 2498.15
[ENCL] => 2666.15
[DIFF] => 168.00
[PERC] => 6.72
)
[5] => Array
(
[IRISCODE] => FAGPREBE
[COMPANY_NAME] => F A G BRGS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 3116.40
[ENCL] => 3324.85
[DIFF] => 208.45
[PERC] => 6.69
)
[6] => Array
(
[IRISCODE] => ONWTECHN
[COMPANY_NAME] => ONWARD TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 252.65
[ENCL] => 268.85
[DIFF] => 16.20
[PERC] => 6.41
)
[7] => Array
(
[IRISCODE] => AARDRUGS
[COMPANY_NAME] => AARTI DRUGS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 390.15
[ENCL] => 414.90
[DIFF] => 24.75
[PERC] => 6.34
)
[8] => Array
(
[IRISCODE] => GUJSTAFC
[COMPANY_NAME] => GUJARAT STAT FERT
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 195.40
[ENCL] => 207.45
[DIFF] => 12.05
[PERC] => 6.17
)
[9] => Array
(
[IRISCODE] => FORINFOR
[COMPANY_NAME] => FORTUNE INFO
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 107.05
[ENCL] => 113.45
[DIFF] => 6.40
[PERC] => 5.98
)
)
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from BSE_B2GROUP a, eod_gl_BSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_BSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => BCCFUBA
[COMPANY_NAME] => B C C FUBA
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 119.95
[ENCL] => 139.90
[DIFF] => 19.95
[PERC] => 16.63
)
[1] => Array
(
[IRISCODE] => DATAPPSN
[COMPANY_NAME] => DATASOFT APP
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 210.55
[ENCL] => 239.20
[DIFF] => 28.65
[PERC] => 13.61
)
[2] => Array
(
[IRISCODE] => BHAWOODP
[COMPANY_NAME] => BHAGYA WOOD
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 27.19
[ENCL] => 30.61
[DIFF] => 3.42
[PERC] => 12.58
)
[3] => Array
(
[IRISCODE] => INCAP
[COMPANY_NAME] => INCAP LTD
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 87.00
[ENCL] => 97.39
[DIFF] => 10.39
[PERC] => 11.94
)
[4] => Array
(
[IRISCODE] => BANSYNTE
[COMPANY_NAME] => BANSW SYNTEX
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 124.50
[ENCL] => 134.25
[DIFF] => 9.75
[PERC] => 7.83
)
[5] => Array
(
[IRISCODE] => KHAINDIA
[COMPANY_NAME] => KHAITAN IND
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 95.13
[ENCL] => 100.49
[DIFF] => 5.36
[PERC] => 5.63
)
[6] => Array
(
[IRISCODE] => ADAPLAPR
[COMPANY_NAME] => ADARSH PLANT
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 29.88
[ENCL] => 31.50
[DIFF] => 1.62
[PERC] => 5.42
)
[7] => Array
(
[IRISCODE] => IST
[COMPANY_NAME] => I S T LIMITED
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 824.50
[ENCL] => 865.60
[DIFF] => 41.10
[PERC] => 4.98
)
[8] => Array
(
[IRISCODE] => BHISPINN
[COMPANY_NAME] => BHILWARA SPIN
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 145.45
[ENCL] => 152.50
[DIFF] => 7.05
[PERC] => 4.85
)
[9] => Array
(
[IRISCODE] => INTTECHN
[COMPANY_NAME] => INTEG TECH
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 25.65
[ENCL] => 26.80
[DIFF] => 1.15
[PERC] => 4.48
)
)
|
select a.iriscode, a.company_name, to_char(b.startdate,'dd-Mon-yyyy') as stdt, to_char(b.enddate,'dd-Mon-yyyy') as endt, to_char(b.startclose,'999990.99') as stcl, to_char(b.endclose,'99990.99') as encl, to_char(b.difference,'99990.99') as diff, to_char(b.chg,'9990.99') as perc from BSE_ZGROUP a, eod_gl_BSE_7 b where a.iriscode = b.iriscode and b.enddate = (select max(enddate) from eod_gl_BSE_7 ) and (b.startclose > 20.00 or b.endclose > 20.0) and b.chg > 0.0 order by b.chg descArray
(
[0] => Array
(
[IRISCODE] => DESRAKAU
[COMPANY_NAME] => DESH RAKSHAK
[STDT] => 31-Dec-2024
[ENDT] => 04-Feb-2025
[STCL] => 16.57
[ENCL] => 21.11
[DIFF] => 4.54
[PERC] => 27.40
)
[1] => Array
(
[IRISCODE] => ELCINVES
[COMPANY_NAME] => ELCID INVESTMENT
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 132465.90
[ENCL] => #########
[DIFF] => 26984.45
[PERC] => 20.37
)
[2] => Array
(
[IRISCODE] => IFBAGRIN
[COMPANY_NAME] => I F B AGRO
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 536.00
[ENCL] => 602.90
[DIFF] => 66.90
[PERC] => 12.48
)
[3] => Array
(
[IRISCODE] => SEAHOSPI
[COMPANY_NAME] => SEAHORSE HOSP
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 70.80
[ENCL] => 77.84
[DIFF] => 7.04
[PERC] => 9.94
)
[4] => Array
(
[IRISCODE] => KAJIROCA
[COMPANY_NAME] => KAJARIA IRON
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 38.98
[ENCL] => 42.71
[DIFF] => 3.73
[PERC] => 9.57
)
[5] => Array
(
[IRISCODE] => BRAMOREN
[COMPANY_NAME] => BRADY & MORRIS
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 1173.65
[ENCL] => 1285.15
[DIFF] => 111.50
[PERC] => 9.50
)
[6] => Array
(
[IRISCODE] => INTTECPR
[COMPANY_NAME] => INTERFIT TEC
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 125.20
[ENCL] => 137.05
[DIFF] => 11.85
[PERC] => 9.46
)
[7] => Array
(
[IRISCODE] => PARHOUFC
[COMPANY_NAME] => PARSH HOUSING
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 120.90
[ENCL] => 130.10
[DIFF] => 9.20
[PERC] => 7.61
)
[8] => Array
(
[IRISCODE] => SAGCEMEN
[COMPANY_NAME] => SAGAR CEM.
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 197.30
[ENCL] => 211.35
[DIFF] => 14.05
[PERC] => 7.12
)
[9] => Array
(
[IRISCODE] => FILATEX
[COMPANY_NAME] => FILATEX INDI
[STDT] => 28-Jan-2025
[ENDT] => 04-Feb-2025
[STCL] => 46.65
[ENCL] => 49.94
[DIFF] => 3.29
[PERC] => 7.05
)
)
|
|
|
|