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
(
)
NSE (NIFTY) 7 Days Gainers
Company
Latest Close
Compared To
Absolute Change
% Change
no record found
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] => NAHEXPOR
[COMPANY_NAME] => NAHAR EXP
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 248.00
[ENCL] => 258.04
[DIFF] => 10.04
[PERC] => 4.05
)
[1] => Array
(
[IRISCODE] => MADCEMEN
[COMPANY_NAME] => MADRAS CEM
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 876.40
[ENCL] => 902.35
[DIFF] => 25.95
[PERC] => 2.96
)
[2] => Array
(
[IRISCODE] => VIDDYEMA
[COMPANY_NAME] => VIDHI DYESTU
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 481.65
[ENCL] => 494.50
[DIFF] => 12.85
[PERC] => 2.67
)
[3] => Array
(
[IRISCODE] => PALHEIHO
[COMPANY_NAME] => VICEROY HOTEL
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 136.33
[ENCL] => 139.64
[DIFF] => 3.31
[PERC] => 2.43
)
[4] => Array
(
[IRISCODE] => CARUNIVE
[COMPANY_NAME] => CARBORUNDUM
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 1429.25
[ENCL] => 1461.65
[DIFF] => 32.40
[PERC] => 2.27
)
[5] => Array
(
[IRISCODE] => MAHRUBTE
[COMPANY_NAME] => MAHA RUBTECH
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 155.01
[ENCL] => 157.97
[DIFF] => 2.96
[PERC] => 1.91
)
[6] => Array
(
[IRISCODE] => AEGCHEIN
[COMPANY_NAME] => AEGIS LOGIS
[STDT] => 07-Nov-2024
[ENDT] => 14-Nov-2024
[STCL] => 800.50
[ENCL] => 805.05
[DIFF] => 4.55
[PERC] => 0.57
)
)
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] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 2808.70
[ENCL] => 2895.30
[DIFF] => 86.60
[PERC] => 3.08
)
[1] => Array
(
[IRISCODE] => ICICIBCO
[COMPANY_NAME] => ICICI BANK
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 1255.25
[ENCL] => 1270.50
[DIFF] => 15.25
[PERC] => 1.21
)
[2] => Array
(
[IRISCODE] => HCLTECHN
[COMPANY_NAME] => H C L TECH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 1859.35
[ENCL] => 1870.00
[DIFF] => 10.65
[PERC] => 0.57
)
)
BSE (SENSEX) 7 Days Gainers
11-Dec-2024
Company
Latest Close
Compared To
Absolute Change
% Change
MAH & MAH
2895.30
2808.70
86.60
3.08
ICICI BANK
1270.50
1255.25
15.25
1.21
H C L TECH
1870.00
1859.35
10.65
0.57
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] => GUJNARVF
[COMPANY_NAME] => GUJ NARMADA
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 553.75
[ENCL] => 589.80
[DIFF] => 36.05
[PERC] => 6.51
)
[1] => Array
(
[IRISCODE] => CASINDIA
[COMPANY_NAME] => CASTROL IND
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 190.80
[ENCL] => 199.85
[DIFF] => 9.05
[PERC] => 4.74
)
[2] => Array
(
[IRISCODE] => BANOF
[COMPANY_NAME] => BANK OF INDIA
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 104.30
[ENCL] => 108.80
[DIFF] => 4.50
[PERC] => 4.31
)
[3] => Array
(
[IRISCODE] => BHAPETCO
[COMPANY_NAME] => BHARAT PETRO
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 298.40
[ENCL] => 309.60
[DIFF] => 11.20
[PERC] => 3.75
)
[4] => Array
(
[IRISCODE] => GLAINDIA
[COMPANY_NAME] => GLAXO SMITHKLINE
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 2456.70
[ENCL] => 2547.00
[DIFF] => 90.30
[PERC] => 3.68
)
[5] => Array
(
[IRISCODE] => MAHMAHIN
[COMPANY_NAME] => MAH & MAH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 2808.70
[ENCL] => 2895.30
[DIFF] => 86.60
[PERC] => 3.08
)
[6] => Array
(
[IRISCODE] => NIIT
[COMPANY_NAME] => N I I T TECH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 182.95
[ENCL] => 187.45
[DIFF] => 4.50
[PERC] => 2.46
)
[7] => Array
(
[IRISCODE] => ASHLEYLA
[COMPANY_NAME] => ASHOK LEYLAND
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 217.65
[ENCL] => 221.30
[DIFF] => 3.65
[PERC] => 1.68
)
[8] => Array
(
[IRISCODE] => ADAEXPOR
[COMPANY_NAME] => ADANI EXPORTS
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 2825.90
[ENCL] => 2866.65
[DIFF] => 40.75
[PERC] => 1.44
)
[9] => Array
(
[IRISCODE] => LICHFINA
[COMPANY_NAME] => L I C HOUSING FIN
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 608.10
[ENCL] => 616.75
[DIFF] => 8.65
[PERC] => 1.42
)
)
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] => IVP
[COMPANY_NAME] => I V P LTD
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 200.35
[ENCL] => 218.95
[DIFF] => 18.60
[PERC] => 9.28
)
[1] => Array
(
[IRISCODE] => LEAEDGSY
[COMPANY_NAME] => TRIGYN TECH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 104.35
[ENCL] => 112.90
[DIFF] => 8.55
[PERC] => 8.19
)
[2] => Array
(
[IRISCODE] => ETEEVERE
[COMPANY_NAME] => EVEREST IND
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 863.35
[ENCL] => 932.15
[DIFF] => 68.80
[PERC] => 7.97
)
[3] => Array
(
[IRISCODE] => PLASTIBL
[COMPANY_NAME] => PLASTIBLEND
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 242.05
[ENCL] => 260.90
[DIFF] => 18.85
[PERC] => 7.79
)
[4] => Array
(
[IRISCODE] => DATSYSTE
[COMPANY_NAME] => DATANET SYSTEMS
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 32.08
[ENCL] => 34.51
[DIFF] => 2.43
[PERC] => 7.57
)
[5] => Array
(
[IRISCODE] => RAJSPIWM
[COMPANY_NAME] => RAJ.SPG.
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 174.05
[ENCL] => 187.20
[DIFF] => 13.15
[PERC] => 7.56
)
[6] => Array
(
[IRISCODE] => ALECHEWC
[COMPANY_NAME] => ALEMBIC
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 126.50
[ENCL] => 135.60
[DIFF] => 9.10
[PERC] => 7.19
)
[7] => Array
(
[IRISCODE] => ONWTECHN
[COMPANY_NAME] => ONWARD TECH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 312.75
[ENCL] => 331.15
[DIFF] => 18.40
[PERC] => 5.88
)
[8] => Array
(
[IRISCODE] => CRERATIS
[COMPANY_NAME] => CRISIL
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 5188.65
[ENCL] => 5462.25
[DIFF] => 273.60
[PERC] => 5.27
)
[9] => Array
(
[IRISCODE] => IPRINGS
[COMPANY_NAME] => I P RINGS
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 198.80
[ENCL] => 207.30
[DIFF] => 8.50
[PERC] => 4.28
)
)
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] => PANJON
[COMPANY_NAME] => PANJON
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 20.35
[ENCL] => 22.45
[DIFF] => 2.10
[PERC] => 10.32
)
[1] => Array
(
[IRISCODE] => CRANEX
[COMPANY_NAME] => CRANEX LTD
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 143.70
[ENCL] => 158.35
[DIFF] => 14.65
[PERC] => 10.19
)
[2] => Array
(
[IRISCODE] => INNSECUR
[COMPANY_NAME] => ISL CONSUL
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 28.20
[ENCL] => 31.06
[DIFF] => 2.86
[PERC] => 10.14
)
[3] => Array
(
[IRISCODE] => BCCFUBA
[COMPANY_NAME] => B C C FUBA
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 83.89
[ENCL] => 92.01
[DIFF] => 8.12
[PERC] => 9.68
)
[4] => Array
(
[IRISCODE] => ABC
[COMPANY_NAME] => A B C INDIA
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 115.55
[ENCL] => 124.90
[DIFF] => 9.35
[PERC] => 8.09
)
[5] => Array
(
[IRISCODE] => LINPHARM
[COMPANY_NAME] => LINCOLN PHAR
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 614.35
[ENCL] => 656.25
[DIFF] => 41.90
[PERC] => 6.82
)
[6] => Array
(
[IRISCODE] => MAFINDUS
[COMPANY_NAME] => MAFATLAL IND
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 143.95
[ENCL] => 153.35
[DIFF] => 9.40
[PERC] => 6.53
)
[7] => Array
(
[IRISCODE] => EVECAPIT
[COMPANY_NAME] => ABM KNOW
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 125.15
[ENCL] => 131.15
[DIFF] => 6.00
[PERC] => 4.79
)
[8] => Array
(
[IRISCODE] => ADAPLAPR
[COMPANY_NAME] => ADARSH PLANT
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 27.57
[ENCL] => 28.86
[DIFF] => 1.29
[PERC] => 4.68
)
[9] => Array
(
[IRISCODE] => INCAP
[COMPANY_NAME] => INCAP LTD
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 100.85
[ENCL] => 105.00
[DIFF] => 4.15
[PERC] => 4.12
)
)
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] => HBESTDEV
[COMPANY_NAME] => H B ESTATE DEV
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 93.60
[ENCL] => 105.55
[DIFF] => 11.95
[PERC] => 12.77
)
[1] => Array
(
[IRISCODE] => ASHISPAT
[COMPANY_NAME] => ASHIANA ISPAT
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 43.91
[ENCL] => 48.91
[DIFF] => 5.00
[PERC] => 11.39
)
[2] => Array
(
[IRISCODE] => ELCINVES
[COMPANY_NAME] => ELCID INVESTMENT
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 269172.70
[ENCL] => #########
[DIFF] => 29079.55
[PERC] => 10.80
)
[3] => Array
(
[IRISCODE] => PIOINVES
[COMPANY_NAME] => PIONEER INV
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 62.17
[ENCL] => 68.77
[DIFF] => 6.60
[PERC] => 10.62
)
[4] => Array
(
[IRISCODE] => BALTRACO
[COMPANY_NAME] => BALURGHAT TECHNO
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 30.35
[ENCL] => 32.94
[DIFF] => 2.59
[PERC] => 8.53
)
[5] => Array
(
[IRISCODE] => CYBSYSSO
[COMPANY_NAME] => CYBERTECH
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 194.10
[ENCL] => 209.00
[DIFF] => 14.90
[PERC] => 7.68
)
[6] => Array
(
[IRISCODE] => AAMTOOLS
[COMPANY_NAME] => AAMCOL TOOLS
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 183.40
[ENCL] => 197.00
[DIFF] => 13.60
[PERC] => 7.42
)
[7] => Array
(
[IRISCODE] => KATUDYOG
[COMPANY_NAME] => KATWA UDYOG
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 187.80
[ENCL] => 201.15
[DIFF] => 13.35
[PERC] => 7.11
)
[8] => Array
(
[IRISCODE] => PEEABAFI
[COMPANY_NAME] => PEERLESS ABA
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 49.50
[ENCL] => 53.00
[DIFF] => 3.50
[PERC] => 7.07
)
[9] => Array
(
[IRISCODE] => RITINDUS
[COMPANY_NAME] => RITESH INDUS
[STDT] => 14-Nov-2024
[ENDT] => 11-Dec-2024
[STCL] => 24.90
[ENCL] => 26.65
[DIFF] => 1.75
[PERC] => 7.03
)
)