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 < (SELECT max(pDate) from PriceData))) h ON asx.symbol = h.symbol LEFT JOIN recommendationcalc rc ON asx.symbol = rc.symbol AND rc.calcdate = '2022/06/24' 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 $33.52 7 $43.11
2 ANZ AUSTRALIA AND NEW ZEALAND BANKING GROUP LIMITED Banks $21.91 7 $28.52
3 BHP BHP GROUP LIMITED Bulks $40.02 7 $46.05
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 METALS GROUP LIMITED Iron Ore xx.xx x xx.xx
8 GMG GOODMAN GROUP Infra & Property Developers xx.xx x xx.xx
9 JHX JAMES HARDIE INDUSTRIES PLC Building Products & Services xx.xx x xx.xx
10 MQG MACQUARIE GROUP LIMITED Wealth Management & Investments xx.xx x xx.xx
11 NAB NATIONAL AUSTRALIA BANK LIMITED Banks xx.xx x xx.xx
12 NCM NEWCREST MINING LIMITED Gold & Silver xx.xx x xx.xx
13 RIO RIO TINTO LIMITED Bulks 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 CORPORATION 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