For those of you interested in looking at the performance of the new IPO listings on the Australian and US markets here’s a watchlist showing various measures, such as percentage change, IPO date, and drawdown from the high. (Note: Optuma clients can download the watchlists at the end of the article.)
The lists were created from these sources, and can be referenced to manually update the lists:
To date there have been 21 new listings on the ASX this year, with the best performer – based on the opening trading price and not the offering price – being AML3D Ltd (AL3) which is up over 200% from its April debut, followed by Manuka Resources (MKR) at 123%. However, both are down significantly from their highs, as seen in the ‘% from ATH’ watchlist column and the red plot on the chart:
Of the new listings in the US, Keros Therapeutics (KROS) is up the most from it’s opening traded price of $28.85 on April 8th, closely followed by I-Mab, another biotech company.
If you are interested in seeing the scripting formulas used to calculate the columns, right-click on the column header and select Edit Column to open the Script Editor window. For example, the IPO Open price is simply FIRST(OPEN()), and the IPO Date is FIRST(BARDATE()) with the Column Type set to Date and the Date Display Style set to Date. Note the Days Since IPO column is the same script as the IPO Date column but the Date Display Style has been set to Day Count:
Of course, the page can be saved as a layout which can then be applied to any list. For example, the major US tech stocks show that Microsoft has gained an incredible 241,000% since its debut in March 1986 at a split-adjusted $0.09, compared to ‘only’ 172,000% for Amazon and 82,000% for Apple!
Optuma clients with Australian or US data can save and open the workbooks by clicking the buttons below.
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.