Sample Report: Australian Exchange Traded Funds Returns

Demonstrates using NLG Studio to create a report on Australian exchange traded funds (ETFs).

Click Access Download above to get this ETF returns sample project for use within NLG Studio. Scroll down for the sample’s documentation — including a sample report and sample data.

This documentation is organized as follows:

• Introduction
• Sample Report
• Example Data

Introduction

This sample project produces a report that identifies greatest returns over time for investment items, relative to a median return, over a large data set.

Sample Report

This report is generated from the sample data that comes with the sample ETFs project.

Morningstar, Inc. in the USA provides free market data on stocks, LICs (Listed Investment Companies), Managed Funds, and ETFs (Exchange Traded Funds) – plus news and investment portfolio information.

Within the 203 ETFs listed in Morningstar’s Australia Reporting, the top-three performing funds by year-to-date (YTD) returns are identified, as well as the best three funds by one-year and three-year returns, as at 26 June 2018.

YEAR-TO-DATE % RETURNS:
The median YTD return out of all 203 ETFs is 1.0%.

Betashares Global Cybersecurity ETF (ASXcode: HACK) had the highest year-to-date return with 18.4%, followed by ETFS Morningstar Global Technology ETF (ASXcode: TECH) with 15.9%, and by BetaShares NASDAQ 100 ETF (ASXcode: NDQ) with 12.9%.

These top-3 funds (by YTD returns) above had:

• 1-year returns of 19.5%, 26.2%, and 18.9% respectively
• 3-year-returns of 0%, 0%, and 16.7% respectively
• Change by -0.7%, -0.4%, and -0.9% respectively compared with the day before

ONE-YEAR % RETURNS:
The median 1-year return out of all 203 ETFs is 6.8%.

1-year returns were the greatest for BetaShares Crude Oil ETF Ccy Hgd(Synth) (ASXcode: OOO), BetaShares S&P/ASX200 Res Sect ETF (ASXcode: QRE), and SPDR® S&P/ASX 200 Resources ETF (ASXcode: OZR) with 34.9%, 32.8%, and 32.7% respectively.

These top-3 funds (by 1-year returns) above had:

• 3-year returns of -13.2%, 9.8%, and 9.7% respectively
• YTD returns of 11.6%, 7.7%, and 7.6% respectively
• Change by -4.8%, -1.3%, and -1.2% respectively compared with the day before

THREE-YEAR % RETURNS:

The median 3-year return out of all 203 ETFs is 4.9%.

3-year returns were the greatest for BetaShares NASDAQ 100 ETF (ASXcode: NDQ), iShares S&P Small-Cap ETF (ASXcode: IJR) , and Smartshares NZ Mid Cap (ASXcode: MDZ-NZ) with 16.7%, 14.2%, and 13.8% respectively.

These top-3 funds (by 3-year returns) above had:

• 1-year returns of 18.9%, 20.7%, and 14.8% respectively
• YTD returns of 12.9%, 11.8%, and -0.9% respectively
• Change by -0.9%, -0.2%, and 0.8% respectively compared with the day before

Past performance is no guarantee of future returns.

Example Data

The example that follows shows the data structure. (This is an excerpt; it does not represent the full sample report.)