##


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 < '2026/05/01')) 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, STRING_AGG(s.sector, ', ') AS sector, STRING_AGG(CAST(s.sectorID AS VARCHAR), ',') AS sectorID, STRING_AGG(dbo.RemoveNonAlphaCharacters(s.sector), ',') AS sectorurl FROM sector s INNER JOIN SectorRelationship sr ON s.sectorID = sr.sectorID GROUP BY sr.symbol ) AS sec ON ci.Symbol = sec.symbol WHERE asx.indexCode = '' AND archived IS NULL ORDER BY asx.symbol
# SYMBOL COMPANY NAME SECTOR (FNARENA) PRICE RECS CONSENSUS
TARGET
No Records
{"id":89145,"date":"2020-10-07T12:10:41","date_gmt":"2020-10-07T01:10:41","guid":{"rendered":"https:\/\/www.fnarena.com\/?page_id=89145"},"modified":"2020-11-20T10:27:53","modified_gmt":"2020-11-19T23:27:53","slug":"index-list","status":"publish","type":"page","link":"https:\/\/staging.fnarena.com\/index.php\/index-list\/","title":{"rendered":"Index List"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text][\/vc_column_text][vc_raw_html]JTNDc2NyaXB0JTIwdHlwZSUzRCUyMnRleHQlMkZqYXZhc2NyaXB0JTIyJTIwaWQlM0QlMjJkaWFub21pX2NvbnRleHRfc2NyaXB0JTIyJTIwc3JjJTNEJTIyaHR0cHMlM0ElMkYlMkZ3d3cuZGlhbm9taS5jb20lMkZqcyUyRmNvbnRleHRmZWVkLmpzJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTBBJTNDZGl2JTIwY2xhc3MlM0QlMjJkaWFub21pX2NvbnRleHQlMjIlMjBkYXRhLWRpYW5vbWktY29udGV4dC1pZCUzRCUyMjI3MyUyMiUzRSUzQyUyRmRpdiUzRQ==[\/vc_raw_html][vc_raw_html]JTNDcCUzRSUyNm5ic3AlM0IlM0MlMkZwJTNFJTBBJTNDZGl2JTIwY2xhc3MlM0QlMjJ0ZXh0LWNlbnRlciUyMiUzRSUzQyUzRnBocCUyMCUyRiUyRmVjaG8lMjBkb19zaG9ydGNvZGUlMjglMjclNUJhZHNfbGFyZ2VfZGVza3RvcF9zbWFsbF9tb2JpbGUlNUQlMjclMjklM0IlMjAlM0YlM0UlM0MlMkZkaXYlM0UlMEElM0NzY3JpcHQlMjB0eXBlJTNEJTIydGV4dCUyRmphdmFzY3JpcHQlMjIlMjBpZCUzRCUyMmRpYW5vbWlfY29udGV4dF9zY3JpcHQlMjIlMjBzcmMlM0QlMjJodHRwcyUzQSUyRiUyRnd3dy5kaWFub21pLmNvbSUyRmpzJTJGY29udGV4dGZlZWQuanMlMjIlM0UlM0MlMkZzY3JpcHQlM0UlMEElM0NkaXYlMjBjbGFzcyUzRCUyMmRpYW5vbWlfY29udGV4dCUyMiUyMGRhdGEtZGlhbm9taS1jb250ZXh0LWlkJTNEJTIyMjYxJTIyJTNFJTNDJTJGZGl2JTNF[\/vc_raw_html][vc_empty_space][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

[vc_row][vc_column][vc_column_text][\/vc_column_text][vc_raw_html]JTNDc2NyaXB0JTIwdHlwZSUzRCUyMnRleHQlMkZqYXZhc2NyaXB0JTIyJTIwaWQlM0QlMjJkaWFub21pX2NvbnRleHRfc2NyaXB0JTIyJTIwc3JjJTNEJTIyaHR0cHMlM0ElMkYlMkZ3d3cuZGlhbm9taS5jb20lMkZqcyUyRmNvbnRleHRmZWVkLmpzJTIyJTNFJTNDJTJGc2NyaXB0JTNFJTBBJTNDZGl2JTIwY2xhc3MlM0QlMjJkaWFub21pX2NvbnRleHQlMjIlMjBkYXRhLWRpYW5vbWktY29udGV4dC1pZCUzRCUyMjI3MyUyMiUzRSUzQyUyRmRpdiUzRQ==[\/vc_raw_html][vc_raw_html]JTNDcCUzRSUyNm5ic3AlM0IlM0MlMkZwJTNFJTBBJTNDZGl2JTIwY2xhc3MlM0QlMjJ0ZXh0LWNlbnRlciUyMiUzRSUzQyUzRnBocCUyMCUyRiUyRmVjaG8lMjBkb19zaG9ydGNvZGUlMjglMjclNUJhZHNfbGFyZ2VfZGVza3RvcF9zbWFsbF9tb2JpbGUlNUQlMjclMjklM0IlMjAlM0YlM0UlM0MlMkZkaXYlM0UlMEElM0NzY3JpcHQlMjB0eXBlJTNEJTIydGV4dCUyRmphdmFzY3JpcHQlMjIlMjBpZCUzRCUyMmRpYW5vbWlfY29udGV4dF9zY3JpcHQlMjIlMjBzcmMlM0QlMjJodHRwcyUzQSUyRiUyRnd3dy5kaWFub21pLmNvbSUyRmpzJTJGY29udGV4dGZlZWQuanMlMjIlM0UlM0MlMkZzY3JpcHQlM0UlMEElM0NkaXYlMjBjbGFzcyUzRCUyMmRpYW5vbWlfY29udGV4dCUyMiUyMGRhdGEtZGlhbm9taS1jb250ZXh0LWlkJTNEJTIyMjYxJTIyJTNFJTNDJTJGZGl2JTNF[\/vc_raw_html][vc_empty_space][\/vc_column][\/vc_row]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"acf":[],"_links":{"self":[{"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/pages\/89145"}],"collection":[{"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/comments?post=89145"}],"version-history":[{"count":0,"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/pages\/89145\/revisions"}],"wp:attachment":[{"href":"https:\/\/staging.fnarena.com\/index.php\/wp-json\/wp\/v2\/media?parent=89145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}