ASX20
Index Constituents & Latest News

More Indices: ASX20 | ASX50 | ASX100 | ASX200 | ASX300 | ALL-ORDS | ALL-TECH
select asx.indexCode,asx.symbol as displaySymbol,rc.*,ci.companyname,ci.companyname2,sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '') THEN 'sector' ELSE sec.sectorurl END as SectorURL,ci.lastprice, cast(AvgRating as decimal(10,1)) as AvgRating2 ,targetGainLoss = case when ci.lastPrice = 0 then 0 when targetAvg = 0 then 0 else ((targetAvg-ci.lastPrice)/ci.lastPrice)*100 end ,dividendForecast = case when ci.lastPrice = 0 then 0 else (DividendForecastAvg/ci.lastprice) end ,(countsbuy+countbuy+counthold+countsell+countssell) AS numofrecs ,h.pDate,h.pOpen,h.pHigh,h.pLow,h.pClose,h.pVolume FROM ASXData asx LEFT JOIN companyinfo ci ON asx.symbol = ci.symbol LEFT JOIN (select symbol,pDate,pOpen,pHigh,pLow,pClose,pVolume from priceData where pDate = (select max(pDate) from priceData where pDate < '2024/04/12')) h ON asx.symbol = h.symbol LEFT JOIN ( select r1.* from recommendationcalc r1 INNER JOIN ( select symbol,max(calcDate) as maxDate from recommendationcalc where calcDate > DATEADD(MONTH, -1, getdate()) group by symbol) r2 ON r1.symbol = r2.symbol AND r1.CalcDate = r2.maxDate ) rc ON asx.symbol = rc.symbol LEFT JOIN (SELECT sr.symbol, s.sector,s.sectorID,dbo.RemoveNonAlphaCharacters(s.sector) as sectorurl FROM sector s INNER JOIN SectorRelationship sr on s.sectorID = sr.sectorID WHERE isPriority = 1) AS sec on ci.Symbol = sec.symbol WHERE asx.indexCode = 'ASX20' AND archived IS NULL ORDER BY asx.symbol
# SYMBOL COMPANY NAME SECTOR (FNARENA) PRICE RECS CONSENSUS
TARGET
1 ALL ARISTOCRAT LEISURE LIMITED Gaming $41.23 5 $47.60
2 ANZ ANZ GROUP HOLDINGS LIMITED Banks $28.96 6 $28.02
3 BHP BHP GROUP LIMITED Bulks $45.94 6 $45.02
4 CBA COMMONWEALTH BANK OF AUSTRALIA Banks xx.xx x xx.xx
5 COL COLES GROUP LIMITED Food, Beverages & Tobacco xx.xx x xx.xx
6 CSL CSL LIMITED Pharmaceuticals & Biotech/Lifesciences xx.xx x xx.xx
7 FMG FORTESCUE LIMITED Iron Ore xx.xx x xx.xx
8 GMG GOODMAN GROUP Infra & Property Developers xx.xx x xx.xx
9 MQG MACQUARIE GROUP LIMITED Wealth Management & Investments xx.xx x xx.xx
10 NAB NATIONAL AUSTRALIA BANK LIMITED Banks xx.xx x xx.xx
11 QBE QBE INSURANCE GROUP LIMITED Insurance xx.xx x xx.xx
12 RIO RIO TINTO LIMITED Bulks xx.xx x xx.xx
13 S32 SOUTH32 LIMITED Mining xx.xx x xx.xx
14 STO SANTOS LIMITED NatGas xx.xx x xx.xx
15 TCL TRANSURBAN GROUP LIMITED Infrastructure & Utilities xx.xx x xx.xx
16 TLS TELSTRA GROUP LIMITED Telecommunication xx.xx x xx.xx
17 WBC WESTPAC BANKING CORPORATION Banks xx.xx x xx.xx
18 WDS WOODSIDE ENERGY GROUP LIMITED NatGas xx.xx x xx.xx
19 WES WESFARMERS LIMITED Consumer Products & Services xx.xx x xx.xx
20 WOW WOOLWORTHS GROUP LIMITED Food, Beverages & Tobacco xx.xx x xx.xx