ASX and S&P500 Sector Workbooks – UPDATED

by Apr 1, 2021All Articles, Technical Analysis, Education

If you are interested in a top-down analysis of sectors then you may find the attached workbooks for both the Australian and US markets useful. Each tab in the workbook contains the members of the sector in a watchlist, and includes examples of watchlist columns, charts, and indicators. These updated versions also include ratio charts and a new high / low scan, with the Australian workbook including the members of the new ASX All Tech Index ($XTX).

The first page is a sector overview,  which includes a watchlist of the sector performance along with a weekly Relative Rotation Graph® and weekly candlestick chart (click on any symbol in the watchlist to change the chart).

If you find a particular layout useful remember that you can save it as a Page Layout and apply it to your own charts (delete the watchlist first if you only want the Page Layout to include the chart).

For more information on Page Layouts click here.

Here’s an example of the US Energy sector, which includes a daily chart with three moving averages and an RSI, with a weekly line chart and long term monthly Gann Swing chart to the right:

Here’s a screenshot of the Relative Strength Ratios tab from the ASX workbook. This automatically displays a chart relative to the ASX200 Index $XJO using the Relative Index property. As you scroll down the chart will update without the need to create a custom code or Division Spread chart.

The Show View below the chart shows the performance against the index over the last quarter, ie Westpac out-performed the index by 22% over the last 3 months.

This last example shows a watchlist of the ASX 200 companies with a true/false column for new 6 month highs and another for 6 month lows (right-click on the column headings and select Edit Column to see the underlying script formulas). At time of writing there were 17 new highs and 1 new low on that particular day. The chart on the right highlights the new 6 month highs and lows with a Show Bar arrow, with the last 6 months highlighted in blue using a custom bar colour scheme:

Optuma clients can click the buttons below to save the workbook files, and once saved – usually to your Downloads folder – double-click on the file to open. When prompted to  move them from the download location to your default Workbooks folder click yes.

Please contact us if you have any questions.

Not a client? Click here to register for a free trial account:

Share Link
Darren Hawkins, MSTA

Darren Hawkins, MSTA

Senior Software Specialist at Optuma

Darren is the senior Software Specialist at Optuma. He joined the company in 2009 after attending an introductory technical analysis course. Darren now instructs users all over the world, from experienced Wall Street traders and professional money managers to individual traders drawing their first trendlines.

Darren grew up in the UK and attended college in the USA where he earned a BA in Economics from St Mary's College of Maryland. He went on to spend a few years working at the Nasdaq Stock Market in Washington DC. Going on to live and work in Australia, the US and currently the UK, Darren has a broad understanding of the individual needs of traders, portfolio managers and investors utilising a wide range of methodologies.

In 2014 Darren passed the UK-based Society of Technical Analysts diploma course, and when not looking at charts he keeps a keen eye on England's cricket team - especially if they are playing against Australia. He lives in the Essex countryside in England, with wife Wendy and their labrador, Gabba.

5 Comments

  1. DARREN JOHN WILSON

    Thanks to Daz and all at Market Analysts, as someone who presents monthly to ATAA members this is a God send! WOuld you happen to have something similar for the NASDAQ? Would even pay to get something similar to this for that index…

    Reply
    • Darren Hawkins, MSTA

      Thanks. We have Nasdaq Composite index members in our Symbol List, plus Sector Name in our Fundamental data but this is not a GICs classification. Contact support with your specific requirements and we’ll give you quote for us to build it for you.

      Reply
  2. Michael Little

    Thanks again Darren and Team, these work books just keep getting better with each new edition, much appreciated.

    Reply
  3. Peter Fam

    Ah wow this is amazing, it has saved me hours of prep work thanks Darren

    Reply
  4. Matt

    Outstanding work Darren, Thanks.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Blog Signup

Pin It on Pinterest

Share This