Corporate Results Monitor

FNArena's All-Year Round Australian Corporate Results Monitor.

Currently monitoring post-August 2021.

Figures shown as at 30 November 2021

FNArena subscribers receive the most current information. Please login with your account details.

TOTAL STOCKS:

47

Beats

26

In Line

11

Misses

10

Total Rating Upgrades:

7

Total Rating Downgrades:

8

Total target price movement in aggregate:

5.87%

Average individual target price change:

2.34%

Beat/Miss Ratio:

2.60

Previous Corporate Results Updates

Company Result Upgrades Downgrades Buy/
Hold/Sell
Prev Target New Target Brokers Commentary
ALQ - ALS BEAT 0 0 2/3/0 13.25 13.86 5

First half earnings for ALS Ltd were a beat on forecasts in both the Commodities and Life Sciences divisions. Second half guidance nevertheless suggests a flat to lower second half result as cost pressures come to bear due to supply constraints, despite management highlighting continuing robust trading conditions and the addition of capacity where possible. More details are awaited on the Nuvisan part-acquisition with regard the revenue outlook. Management does have a history of under-promising and over-delivering.

AMC - Amcor BEAT 0 0 3/1/0 18.43 18.26 4

Amcor's quarterly earnings were largely better than expected in the face of raw material supply shortages and rising prices. Credit Suisse (Hold) suggests Amcor has been at the forefront of managing raw material inflation but is priced at the right premium to peers. In flexibles, the company has recovered costs with price increases while the rigids division is operating at full capacity because of high demand combined with supply constraints. While shortages will eventually end, Morgan Stanley (Buy) finds value in the defensive nature of the company, high single-digit earnings growth and the active buyback.

ANZ - ANZ Bank BEAT 0 0 2/4/0 29.18 29.46 6

It was a beat on the profit line for ANZ Bank thanks to strong markets trading and a write-back of provisions, but the result was tempered by the bank's inability to reduce costs as planned. ANZ needs to keep on investing to keep up with peers. That said, brokers note ANZ offers the best exposure among peers to rising bond yields, and there are signs institutional loan growth is returning. This has Citi upgrading to Hold. Macquarie (Buy) notes ANZ Bank shares are trading at a significant valuation discount to peers, hence is offering undemanding value at this level.

ALL - Aristocrat Leisure IN LINE 0 0 5/0/0 49.79 51.47 5

Aristocrat Leisure's FY21 result was in line with a recent trading update, featuring strong momentum to year-end supporting North American market share gains and digital upside. Adding capability and retaining staff has driven up costs, as previously flagged, but the addition of seven studios and increased digital staff offers hope for new product launches. Brokers also see the Playtech acquisition (if approved) as transformational, given limited business overlap and upside opportunity within the combined businesses. Demand in A&NZ remained strong despite venue closures in the period.

AST - AusNet Services BEAT 0 0 0/2/0 2.04 2.55 4

AusNet Services is subject to a takeover offer hence two of four covering brokers are restricted from offering a target or rating. Otherwise, first half profit was down -21% year on year but was a beat on expectations driven by stronger than expected revenue from gas distribution, while electricity distribution, transmission and Mondo were all in line with expectations for the half. That said, Macquarie (No Rating) sees the outlook in electricity as "exciting", but gas uncertain.

API - Australian Pharmaceutical Industries IN LINE 0 0 0/1/0 1.49 1.55 2

Australian Pharmaceutical Industries had already pre-released a result that was impacted heavily by lockdowns closing retail outlets. The FY22 outlook is more positive, Macquarie notes. Clear Skincare was a key driver, and the company is looking to increase the value of its digital assets. In particular the company is extracting the existing SisterClub Loyalty program to form a digital hub and separate reporting line. Credit Suisse expects additional investment will be required to unlock benefits. Both Wesfarmers and Sigma Healthcare are interested in a takeover, and Macquarie is under restriction on that basis.

BOQ - Bank of Queensland IN LINE 1 0 6/0/0 10.38 10.45 6

Bank of Queensland's messy FY21 result, which incorporated the acquisition of ME Bank, was largely in line with forecasts. The outlook for FY22 exceeded expectations, featuring sector-leading profit growth guidance and leading Credit Suisse to join the party with an upgrade to Buy. The weak share price reaction on the day is put down to cost concerns and lower interest margin guidance, but brokers suggest the market is misreading the cost situation and note lower margins will be offset by loan growth.

BKW - Brickworks BEAT 0 0 2/2/0 24.96 27.34 4

Brickworks reported above consensus expectation on property revaluation and gains in various corporate investments, with underlying earnings increasing 86%. Covid-related disruptions in building, both here and in the US, nevertheless continue to weigh on a recovery. A recovery is nonetheless expected, albeit slower than assumed in the US and with Victoria remaining uncertain. But the company's property pipeline is solid, and the cross-investment in Soul Pattinson should remain supportive.

CHN - Chalice Mining MISS 0 0 1/0/0 9.70 9.70 1

Macquarie has updated its Chalice Mining estimates to incorporate the FY21 result. The loss was larger than the broker expected mostly because of increased costs associated with employee shares and higher exploration expenses. The maiden resource at Julimar is due at the end of the year and, subsequently, the Gonneville drilling is expected to be completed by early 2022. The near-term catalyst is securing access to the state forest.

CIA - Champion Iron BEAT 0 0 1/0/0 8.15 7.40 1

Champion Iron's September quarter shipments exceeded Macquarie's forecast and phase 1 nameplate capacity. While revenues and earnings also exceeded forecasts, realised pricing fell -39% from the June quarter on lower iron ore prices and higher freight costs. Freight headwinds will continue but the broker notes Champion Iron can still generate strong cash flows at current prices, and the Bloom Lake phase 2 expansion will see a doubling of production.

CLV - Clover MISS 0 0 2/0/0 2.19 1.88 2

Clover Corp posted a miss of forecasts but brokers are not concerned. While first half FY22 customer orders look promising, operating conditions remain impacted by covid disruptions to the Chinese diagou channel and via travel restrictions. Ord Minnett suggests Clover offers a compelling growth story over FY23-24 as the company builds sales and marketing presence after the Chinese minimum omega-3 fatty acids legislation has been approved. UBS agrees and further notes short-term upside on a reopening of borders.

CSR - CSR IN LINE 0 0 4/2/0 6.34 6.72 6

A solid result from CSR was in line with forecasts but "impressive" margins in the Building Products division and "excellent cost management" helped to overcome supply chain issues that management described as increasingly complex and constrained. Brokers expect these issues will catch up with the company in the second half, but Residential and Property earnings are expected to provide a solid boost to earnings and cash flow. FY22 guidance of $34m in earnings for the Property division is ahead of forecasts and some $50m is already contracted for FY23-25.

ECX - Eclipx Group BEAT 0 0 3/0/0 2.66 2.81 3

Eclipx Group posted a solid beat thanks to ongoing new car supply shortages. The strong performance was driven by yield, lease income and operating cost performance, while underlying growth drivers include a recovery in new business, investment in sales capabilities and digital, and cost control. While supply shortages will eventually end, the company's order backlog, at twice pre-pandemic levels, provides a tailwind when supply normalises. Hence three Buys retained.

ELD - Elders BEAT 0 0 3/1/0 13.19 13.60 4

The feature of Elders' runaway earnings beat and positive outlook was not just favourable weather conditions driving rural earnings and livestock prices, but the company's capacity to grow earnings outside of seasonal swings. Another 12-18 months of favourable conditions are expected, but brokers point to bolt-on acquisitions and expansion into new geographies as independent growth drivers. The only near term downside concern are cattle prices, expected to ease from record levels, keeping Morgans on Hold.

FPH - Fisher & Paykel Healthcare BEAT 1 0 1/1/0 33.00 34.00 2

Fisher & Paykel Healthcare's first half result comfortably beat forecasts. Demand for hospital hardware was particularly strong outside of North America and Europe in the period, thanks to covid's persistence, and costs were well managed. Credit Suisse (Hold) suggests the outlook remains favourable as covid cases continue to rise in the US and Europe heading into the northern winter. The broker expects demand for Fisher & Paykel Healthcare's products will remain above pre-covid levels despite vaccinations and treatments. Brokers are writing before omicron emerged. Macquarie upgrades to Buy, noting strong signs of Nasal High Flow therapy adoption.

FSF - Fonterra Shareholders Fund BEAT 1 0 1/1/0 0.00 0.00 2

Fonterra Shareholders Fund reported towards the top end of the guidance range and better than the last update implied. The last quarter was nevertheless slight loss-making, Macquarie notes, on lower milk prices. The company has revealed its long-term strategy, targeting 40-50% underlying earnings growth by FY30, which would drive around a 75% increase in earnings per share, the broker calculates. This is driven by increased focus on value-add, including “Active Living”, supported by higher capital investment and ramp up in R&D spending. On this positive outlook, and on current valuation, the broker double-upgrades to Outperform from Underperform.

GOR - Gold Road Resources BEAT 0 0 1/0/0 1.78 1.50 1

Gold Road's first half earnings were solid, Macquarie suggests, largely driven by hedging gains. The dividend of 0.5c missed the broker's 1c forecast but the broker assumed a payout above company policy. Delivering on Gruyere’s processing projects and optimisations to expand mill capacity is key to the outlook.

GNC - GrainCorp BEAT 0 0 3/1/0 6.91 7.32 4

GrainCorp posted an FY21 result at the top end of a recently upgraded guidance range and ahead of broker forecasts, and management offered an improved FY22 outlook. Credit Suisse (Hold) suggests the company's position as a competitive player in the east coast grain market has rarely been stronger. Agribusiness performed in line, but accelerated second half profitability for Processing was the positive surprise. The result benefited from a bumper winter crop and the ways things look from here, FY22 could be another record and even FY23 looks positive.

IPL - Incitec Pivot BEAT 0 1 5/2/0 3.24 3.60 7

After a first half Incitec Pivot would like to forget, the company posted a solid turnaround in the second half FY21 to materially beat broker forecasts. Strong fertiliser prices were the main driver, which brokers underestimated. Strength is set to continue in FY22 supported by high European gas costs and Chinese export curtailments. Explosives also beat, with the Moranbah facility back to full production and Louisiana back to name plate post Hurricane Ida. Ord Minnett downgrades to Accumulate from Buy on share price strength, which also keeps Citi and Credit Suisse on Hold.

IAP - Irongate Group BEAT 0 0 0/0/0 1.65 1.65 2

Irongate Group's funds from operations beat Macquarie and met Ord Minnett for a net beat. Ord Minnett highlighted management's proven track record, occupancy of 97%, positive re-leasing spreads, and net tangible asset growth of more than 8%. The REIT is subject to a takeover offer and as both brokers are advising, both are restricted from offering a rating or target.

JHX - James Hardie Industries BEAT 0 0 4/1/0 55.05 59.31 5

James Hardie's result beat expectations as it usually does, with FY22 guidance raised. Brokers were impressed by the company's ability to increase margins in the face of rising costs. While strength in the APAC regions offset weakness in North America, brokers see conditions as supportive in both regions. Solid execution has been maintained by the company's commitment to increase capacity and high-value, high-margin products. A structural change is arising from an increased exposure to the repair & remodel market.

JHG - Janus Henderson BEAT 0 0 1/3/0 58.83 59.58 4

Janus Henderson's quarterly earnings comfortably beat expectations thanks to lower costs, but Macquarie (Buy) believes these will catch up again in the current quarter. Assets under management were supported by a positive investment performance but the biggest issue for brokers concerns funds outflows, particularly from international funds. Management is seeking both organic and inorganic growth opportunities and is looking to diversify away from more traditional, mature products, but until flows improve, most brokers are sticking to Hold.

KAR - Karoon Energy IN LINE 0 0 3/0/0 1.78 1.80 3

One slight beat, one slight miss and an in-line from three covering brokers. Greater focus was on Karoon Energy's FY22 guidance, which featured better than expected production but also higher costs, although Morgan Stanley expects costs will ease as production rises from FY23. Macquarie notes strong cash flow at current oil prices. UBS sees potential acquisition opportunities that would complement the company’s Bauna operations.

KMD - Kathmandu MISS 0 0 2/1/0 1.58 1.65 3

As expected, FY21 results revealed pressure on Kathmandu sales due to store closures, although Oboz sales were ahead of expectations. Yet the result still fell short of the company's June update, ahead of the new round of lockdowns, due to higher sales expenses. The company has announced expansion into Europe and Canada in FY22, and Morgan Stanley (Buy) expects sales will rebound as A&NZ reopens and consumers spend more time outdoors. In the interim, the balance sheet is well-positioned and valuation is not demanding.

MQG - Macquarie Group BEAT 0 0 2/2/0 200.62 216.50 4

Financial markets trading is offering strong opportunities for Macquarie Group, leading to a beat on earnings and an assumption the second half could be better still given a positive outlook for Macquarie Capital, Commodities and Global Markets. Morgan Stanley also echoes general sentiment in highlighting "green" revenue growth, anticipating a less capital-intensive mix for Green Investment Group. This segment will move into Macquarie Asset Management from FY23, which is expected to lead to a multiple re-rate. The capital raising to provide for investment in new opportunities is also seen as positive.

NAB - National Australia Bank BEAT 0 0 2/4/0 28.19 29.47 6

While National Bank's results included slight misses to some broker forecasts on different metrics, the tone of appraisals from all brokers was positive. Operating performance improved over the second half and while weak markets income dragged on revenue, this was offset by low impairments. Divisional volumes and margins outpaced peers. Rising bond yields will provide strong relative support for the bank sector versus the broader market, but while brokers are positive, they do highlight specific risks of weak markets income and the impact of the AUSTRAC investigation.

NHC - New Hope IN LINE 0 0 4/0/0 2.27 2.48 4

New Hope Corp's result was in line with forecasts, featuring strong cash flow on the back of surging thermal coal prices. Assuming no M&A or major investment in the near-term, Morgans sees upside for shareholder returns. Macquarie agrees current prices remain a key catalyst, but is more cautious on coal in the longer term. The Bengalla operations are performing well, offsetting the expectation Acland stage 2 will likely go into care and maintenance while the future of stage 3 is unknown.

NWS - News Corp BEAT 0 0 3/0/0 40.00 38.67 3

News Corp's quarterly featured numbers ahead of consensus for all of Dow Jones, Real Estate, Books, Foxtel and News. Accelerating growth for Move particularly impressed, with Move now outpacing competitors. As usual, 47% year on year revenue growth for News Corp included 62% growth for REA Group. Dow Jones will benefit from the IBD acquisition and news media from the commencement of payments by Facebook/Google. The commencement of the US$1bn buyback should also be a positive catalyst.

NUF - Nufarm BEAT 0 0 4/3/0 5.71 5.55 7

Nufarm posted a beat on forecasts. The negative share price response on the day suggests the market had become overly excited following strong results from agri peers earlier in the week. Morgan Stanley (Hold) believes stronger cash flow and lower debt represent important milestones that should not be underappreciated, and which led to the first dividend since FY18. The company's post-drought turnaround is still evolving, with cost-outs supporting earnings growth and organic growth expected from ongoing favourable crop conditions. Morgans (Buy) notes current multiples imply a free option on omega-3 opportunities.

ORI - Orica BEAT 1 2 2/4/0 14.98 16.09 6

A decline in profit of -29% for Orica in FY21 in tough conditions was a better result than forecast. Morgan Stanley (Buy) predicts a new era of outperformance led by improved supply/demand dynamics and a favourable outlook for pricing. Brokers welcome a new focus on improving price and returns through security of supply, scale and technology, but as Macquarie (Hold) notes, these need to be realised. Credit Suisse upgrades to Buy while downgrades to Hold from Citi and Morgans reflect only a strong share price run and not anything negative.

PDL - Pendal Group IN LINE 1 1 4/1/0 8.43 8.19 5

Pendal Group's result slightly beat or slightly missed forecasts which nets out to in-line. Brokers acknowledge funds outflows are likely to be ongoing but this is balanced against an undemanding valuation post share price fall and the synergy benefits expected from the TSW acquisition. ESG options are also growing. A downgrade to Hold from Credit Suisse is matched by an upgrade to Buy from Ord Minnett, but the general expectation is funds flows will eventually reverse.

PX1 - Plexure Group MISS 0 0 0/1/0 0.80 0.50 1

A disappointing first half result from Plexure Group due to higher costs and lack of results from its growth strategy drove a miss of Ord Minnet's revenue forecast by -5% and underlying earnings forecast by -28%. The acquisition of transaction management software services provider Task could offer strategic benefit, including point of sale functionality and cross-selling opportunity. Despite the disappointing result, the broker sees opportunity for Plexure Group to capture cost efficiencies in the second half.

PMV - Premier Investments IN LINE 0 0 3/3/0 27.61 30.62 6

Premier Investments reported an 88% year on year increase in earnings, in line with guidance, driven by increased sales and gross margins on a favourable cost of doing business. But given rent and other concessions in FY21, the question is to whether margins will normalise from here. Macquarie (Buy) says yes, while Citi (Hold) believes further growth in on-line without heavy investment will keep margins supported. Brokers are not too concerned about a weak start to FY22 thanks to lockdowns, assuming a rapid rebound. The decision to invest in inventory ahead of reopening paid off in FY21, and the company has pursued the same strategy for FY22.

PPH - Pushpay Holdings MISS 0 0 0/1/0 1.90 1.90 1

Pushpay Holdings' interim result fell short of Macquarie's forecasts across all three product categories as customer growth and total processing volumes lost momentum, although churn rates fell. The broker suspects the volume slowdown may mean donations are still normalising, while Resi's metrics suggest customer growth is slowing faster than expected, causing Macquarie to downgrade FY22 customer and revenue forecasts. The broker sees undemanding valuation on potential second half growth of 24%, but is reluctant to jump in until the customer growth picture becomes clearer.

REA - REA Group BEAT 0 0 2/4/0 165.40 169.03 6

REA Group's results for the first quarter were ahead of estimates, particularly for growth in residential depth listings. Management is guiding to a slight improvement for the full year although brokers acknowledge a number of headwinds, including tougher comparables, potential regulatory action to curb house prices and the looming federal election. But these can be offset by increased activity post NSW and Victoria re-openings. Morgan Stanley (Buy) suggests tailwinds include higher rates of churn, as Australians rethink their work and living priorities, as well as rising listings post lockdowns.

RMD - ResMed BEAT 0 0 2/4/0 38.59 38.93 6

ResMed reported quarterly earnings ahead of forecasts. Mask sales were below expectation and SaaS was in-line but device sales were higher than estimated. It's a case of schadenfreude as ResMed continues to benefit from the mask recall from rival Philips, enjoying increased market share as a result which will help to offset short-term pressure on margins from higher input costs due to supply shortages. That market share gain is expected to be sticky. Most brokers see the stock as fully valued.

SHV - Select Harvests BEAT 0 0 2/0/0 9.68 8.80 2

Select Harvests' FY21 profit was down on what was a record FY20 but well ahead of estimates. Lower almond pricing and supply chain challenges impacted on FY21, but both UBS and Citi expect a price recovery on improving demand and the ongoing drought in California. The company is also expecting improved pricing and as such will wait to commit on sales of the FY22 crop. That said, brokers still see almond prices recovering to a lower average than FY20 and thus have cut their target prices, while retaining Buy.

SKO - Serko IN LINE 0 0 2/0/0 7.38 8.10 2

Serko's first half result indicated the de-risking of its Booking.com joint venture is proceeding, but at a slower pace than hoped due to covid's persistence. Noting brokers updated before omicron emerged, Macquarie's assumption is a travel recovery from the June quarter 2022 but warns exact timing remains unclear. Both Macquarie and Ord Minnett retain faith in the upside offered by the joint venture, and on this first half performance have increased targets and retained Buy ratings.

SIG - Sigma Healthcare MISS 0 0 1/2/0 0.70 0.65 3

Normalisation of Sigma Healthcare's sales mix led to lower than expected margins in FY21, while management has cut FY22 earnings growth guidance to 5% from 10% as lockdowns persist. Citi downgrades to Hold. Wesfarmers' bid for rival Australian Pharmaceuticals does not bode well for competition on the one hand, but does suggest to Credit Suisse (Buy) Sigma is undervalued. Macquarie (Hold) considers valuation appealing, but remains cautious because of the risks over the short term and the uncertainty around the competitive landscape.

SM1 - Synlait Milk MISS 0 0 1/0/1 2.55 2.55 2

Brokers are split in the wake of Synlait Milk's weak result, affected by a sharp decline in a2 Milk volumes. Macquarie (Sell) was encouraged by better than expected debt levels and more certainty around the balance sheet, but otherwise expects FY22 will be a challenging year with limited improvement in high-value nutritional volumes. UBS (Buy), on the other hand, expects a recovery in a2 Milk's manufacturing requirements will underpin the business over the next three years, and adult nutritional volume expansion should also help offset the fact that a2 Milk is taking some of its manufacturing in house.

TNE - TechnologyOne BEAT 0 2 1/1/2 10.10 12.16 4

TechnologyOne's profit result came in at the top end of the guidance range and either met or beat forecasts. Revenues and expenses were both lower than forecast but tight cost controls supported earnings. The transition of customers to the cloud-based SaaS platform continues with SaaS annual recurring revenues up 43% year on year. The legacy on-premise business will be discontinued in 2024 and management remains comfortable with its $500m SaaS ARR target for 2026. But for Macquarie and UBS, the share price rally into the result has left the stock overvalued, even after target price increases. Hence two downgrades to Sell.

URW - Unibail-Rodamco-Westfield MISS 0 0 0/0/1 4.00 4.00 1

Following Unibail-Rodamco-Westfield's September quarter results, Ord Minnett notes tenant sales surpassed 2019 levels in the US, while leasing activity went up and vacancies fell. However, 2021 earnings guidance was a -6% miss versus the analyst's estimate. The broker retains its target price and awaits further deleveraging (potential US shopping centre disposals) before becoming more positive. The Sell rating is unchanged.

UMG - United Malt MISS 0 0 4/1/0 4.75 4.83 5

United Malt Group's earnings missed forecasts and came in at the low end of guidance due to ongoing global covid restrictions, higher supply chain costs and a delay to the expansion of a Scottish whiskey distilling facility. Brokers are not overly disappointed, seeing United Malt's as a re-opening story that has been delayed. Expectations for a recovery in UK whiskey exports and US on-premises beer sales in FY22 are keeping all bar one broker on Buy.

VHT - Volpara Health Technologies IN LINE 0 0 1/0/0 1.87 1.87 1

Volpara Health Technologies posted half-yearly earnings in line with expectation. Morgans highlights the importance and significance of the data that are being collected and moved into the cloud, being some 50m images. This aids further development work in the early detection/prediction of breast cancer as well as monitoring changes over time, the broker notes, and the value of these data is ever-increasing. Volpara remains on track to meet its FY22 revenue guidance.

WBC - Westpac Banking MISS 0 2 2/4/0 28.47 26.33 6

A larger than expected provision release and a fully expected buyback failed to overcome a significant and surprise miss on the net interest margin (NIM) for Westpac. Greater than expected costs only made the result worse. It appears in margin re-basing the bank is trying to win back volume growth through lower rates ahead of an assumed steepening of the yield curve, but brokers see the impact on margins continuing into FY22. This leads to two downgrades to Hold, and net cuts to targets. Citi cut its target but retains Buy on what is believed is still a cheap valuation. Macquarie (Hold) agrees, but suggests the discount to peers will remain for a while yet.

SOL - WH Soul Pattinson BEAT 0 0 0/1/0 28.84 36.78 1

Morgans saw a broadly solid FY21 result for Washington H Soul Pattinson. Strong contributions from some core investments highlight the earnings cyclicality of these businesses. The 36cps fully franked final dividend was in line with expectation. Group profit rose 93% year on year, largely due to Brickworks' solid performance from both its building products Australia and Property divisions, while New Hope Corp also contributed strongly due to a thermal coal price recovery. Soul Pattinson has investments in both.

XRO - Xero IN LINE 2 0 3/1/0 124.45 146.75 4

Xero's result was broadly in line after lower than expected subscriber growth, attributed to lockdowns, was offset by higher than forecast average revenue per user. Two upgrades (one to Hold, one to Buy) reflect expectations of ongoing momentum in ARPU growth and penetration into new international markets. Two Sell ratings reflect perceived overvaluation, with costs expected to increase in the second half as the company reinvests in product design and development and international sales and marketing.

Total: 47

ASX50 TOTAL STOCKS:

9

Beats

6

 66.7% 

In Line

2

 22.2% 

Misses

1

 11.1% 

Total Rating Upgrades:

2

Total Rating Downgrades:

2

Total target price movement in aggregate:

7.63%

Average individual target price change:

3.88%

Beat/Miss Ratio:

6.00

ASX200 TOTAL STOCKS:

32

Beats

22

 68.8% 

In Line

6

 18.8% 

Misses

4

 12.5% 

Total Rating Upgrades:

6

Total Rating Downgrades:

8

Total target price movement in aggregate:

6.11%

Average individual target price change:

4.42%

Beat/Miss Ratio:

5.50

Yet to Report

Indicates that the company is also found on your portfolio

SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/11/29'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/11/29'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Monday
29 November
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/11/30'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/11/30'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Tuesday
30 November
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/01'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/01'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Wednesday
1 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/02'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/02'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Thursday
2 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/03'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/03'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Friday
3 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/06'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/06'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Monday
6 December

earnings result


SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/07'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/07'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Tuesday
7 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/08'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/08'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Wednesday
8 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/09'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/09'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Thursday
9 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/10'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/10'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Friday
10 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/13'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/13'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Monday
13 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/14'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/14'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Tuesday
14 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/15'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/15'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Wednesday
15 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/16'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/16'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Thursday
16 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/17'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/17'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Friday
17 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/20'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/20'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Monday
20 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/21'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/21'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Tuesday
21 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/22'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/22'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Wednesday
22 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/23'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/23'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Thursday
23 December
SELECT calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone, max(p.portfolioID) as portfolioID,
					sec.sector,CASE WHEN (sec.sectorurl IS NULL OR sec.sectorurl = '')
                        THEN 'sector'
                        ELSE sec.sectorurl
                    END as SectorURL   
					FROM (
					select seasonReport,calendarID, source, externalID, title, symbol, itemdate, isDisplayed, 1 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/24'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol != '')
					
					UNION
					
					select seasonReport,calendarID, source, externalID, title, type AS symbol, itemdate, isDisplayed, 0 as display, timezone
					from calendar c left join countrycode cc on c.type = cc.code
					where convert(varchar(10),itemDate,111) = '2021/12/24'
					AND isDisplayed = 1
					AND seasonReport = 1
					AND (symbol = '') 
				) AS calendar
				left join (select p.* from portfolio p inner join customerportfolio cp on p.CustomerPortfolioID = cp.CustomerPortfolioID where cp.customerid = '' and cp.archived is NULL) 
				p on calendar.symbol = p.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 calendar.symbol = sec.symbol
				GROUP BY calendar.calendarID,calendar.source,calendar.externalID,
					calendar.title,calendar.symbol,calendar.itemdate,calendar.isDisplayed,
					calendar.display,calendar.timezone,sec.Sector,sec.sectorurl
				ORDER BY calendar.display, calendar.timezone desc, calendar.symbol, calendar.title 
Friday
24 December

Listed Companies on the Calendar

Date Code
06/12/2021MTSearnings result