I do a lot of analysis in Excel using the data from Yahoo Finance since 1984, which covers the period of the rally to and crash from September 1987.
I use Excel functions to do charts from the data, to do calculations of performance and to calculate percentiles of performance so I can put current performance in a quantitative perspective.
I summarise the recent performance and the trends into a "Dashboard" which I colour to provide me with a quick overview of the market for buy/sell analysis.
One of the charts I maintain compares the current recovery with past recoveries and 2 averages, one of all recoveries since 1987 and one not including the 2003 to 2007 bubble recovery.
Here then are the Dashboard and a Recoveries Chart.
The Dashboard shows that while on virtually all measures the All Ords is trending down, the 10 day SMA (using 6 days data) has turned up. It also shows that volatility, overbought/sold and recent growth are in the area where buying should be considered. It also shows that growth over all periods I monitor from 2 months to 5 years is well below median. Further we remain well below both the recent and the historical high. But do note that we are up substantially since the bottom. That brings us to the Recoveries Chart.
The Recoveries Chart shows that until the last 25 days this recovery was well above average - "too far, too fast". It is now a below average recovery and since 1987 only one recovery has been lower for any significant length of time looking forward, the 1987 recovery. The chart looking forward from today also shows us a "cone of possibilities" and on balance the previous patterns would indicate that there is a lot of historical precedent for the market being higher over the next year or so, but this is tempered by the knowledge that 1987 was also a >50% fall like 2007-9 and there are fundamentals that will provide a strong headwind. Based on an eyeball estimate the area within the "cone" (ie looking forward from today within the upper and lower bounds of previous recoveries) above the current recovery level is about twice as much as the area below the the current level - odd of 2 to 1 in favour of an upswing to higher levels over the next 10 months you could say.
Being armed with the information from the Dashboard and Recovery Chart will help in understanding the basis for my previous article.
Thoughts on investing of a recently retired Australian who is a self funded retiree living off his superannuation.
Showing posts with label stocks. Show all posts
Showing posts with label stocks. Show all posts
Friday, August 26, 2011
Thursday, August 25, 2011
Five Questions Regarding the Australian Share Market for Australian Based Investors.
Five Questions Regarding the Australian Share Market for Australian Based Investors.
(This does not examine comparative investments in other markets, commodities or currencies)
1. Is there a possible buying opportunity?
2. Should I buy some now?
3. Can I lose by buying now?
4. Is my reliance on these indicators appropriate for the market we are in?
5. Is the 12 month macro environment/outlook positive or negative?
Is there a possible buying opportunity?
Yes!
Should I buy some shares now?
Yes! The 10 day simple moving average has turned up after a fall of 20% (using the intraday low).
Can I lose by buying now?
Yes! The 10 day SMA is volatile and gets whipsawn, but no market recovery starts without the 10 day SMA turning up. Based on the price pattern after the 1987 crash, you can expect to make a loss from whipsawing until there is a significant major uptrend. That major uptrend might start now in which case you will have no drawdown or there may be say 10 false signals, many involving a loss on the round trip trades, until a major uptrend starts. But, you will not be caught in a future major downtrend if you follow a moving average strategy. You may, however, not do as well as if you just bought in 100% now and held as long as possible.
Is my reliance on these indicators appropriate for the market we are in?
This depends on your age/recovery time, other assets, income outlook but if you are highly concerned about major losses (the Japanese scenario where their market is now down 78% from its all time high in 1990) but also want to participate in any upside, a moving average strategy will protect you from a Japanese scenario but at the likely cost of reduced returns in a sideways or uptrending market (This statement based on analysis by Doug Short: www.dshort.com).
Is the 12 month macro environment/outlook positive or negative?
My opinion is that it is negative. This is based on the unresolved PIIGS debt problems, the introduction of fiscal austerity in US, UK and Australia as well as in the PIIGS and the current trailing earnings in the US being at a never sustained multiple of the 10 year average real earnings. The abandonment of mark-to-market also causes concern. However, central banks are taking extraordinary measures to ensure financial stability and to destroy incentives to hold cash and short and even long term securities. The US 10 year rate is about 2.2% and the S&P 500 earnings yield is about 5%, a ratio rarely sustained for long since 1960, so stocks are quite attractive if earnings merely hold up at current levels. I follow the hypothesis of Richard Koo that this is a balance sheet recession and that to avoid GDP falls the government must take the savings of the private sector and spend them.
Detailed explanation.
I analyse the relative performance of the Australian All Ordinaries Index since 1984 including:
1. returns over 2 mnths and 1, 2, 3, 4 and 5 years
2. whether it is overbought/sold against its 200 day SMA
3. its position against its all time and most recent tops
4. the length and size of its most recent rise or fall against all rises and falls of more than 8% since 1984. (8% is a not quite arbitrary number to eliminate the noise of minor, short term fluctuations).
5. its volatility (persistent high volatility is correlated with major bear markets)
6. the comparative percentage recovery over time from major bottoms
7. the rises and falls between major tops and bottoms and between tops and bottom 3 years apart. (to smooth numbers and avoid comparison only to some extraordinary crash or bubble)
8. What gains/losses have been for 1,2,3,4 and 5 years since the previous tops and bottoms to assist in identifying whether based on past growth rates for those periods at prior tops and bottoms we are likely near a top or bottom (but this analysis will not assist in a long term secular downtrend like Japan as each cyclical top is often lower than the previous cyclical top).
Buy indicators
Present indicators of now being a likely buying opportunity include (based on prices since 1984):
1. The Australian market has only been below its highest point previously by the current 37% for 8% of the trading days since 1984, it has been closer to its previous all time high 92% of trading days since 1984 and has always reached new highs.
2. The length of the current fall to its recent bottom is above both average and median duration of all falls of greater than 8% since 1984
3. The size of the current fall to its recent bottom is above both average and median duration of all falls of greater than 8% since 1984
4. My measure of volatility is in the 96th percentile, so near all time highs
5. Growth over 2 months and 1, 2, 3, 4, and 5 years is at significantly lower than median points being in the bottom 10th, 18th, 18th, 10th, absolute bottom and 2nd percentiles.
6. The market has, since 1984, hit a new record high within 5.5 years, so we might expect to be at 6850 by April 2013, which would be a rise of 60% over the next 20 months (personally I doubt it very much, but the September 1987 high was exceeded in January 2004 in spite of the fall of over 50% which took place in September 1987.
7. The percentage recovery of 37.7% at trading day 625 since the bottom is below average and below all but the 1987 recovery at day 625. Until this recent fall the current recovery had never been below average since day 20. But the 1987 recovery had a sustained period of relapse lower than the current 37.7% recovery after day 625. The 1987 recovery went through a further major downturn and spent only 170 of the next 586 days (the limit of my analysis) above the present level. So there is risk of being whipsawn for a loss if you buy now and get a sell signal later.
8. After the recent falls the market is significantly below its linear trend line on a simple scale and its logarithmic trend line on a logarithmic scale so mean reversion would indicate a likely future uptrend, although timing is always uncertain.
Risk indicators
1. the 30, 50, 100 and 200 smas are all still trending down.
2. there have been no bullish crosses of the 10/30, 10/50, 30/50, 30/100, 50/100 or 50/200 moving averages, so there is a real possibility that you will get whipsawn for a loss if you buy now. It may be too early.
3. You can't totally rule out a Japanese style situation of cyclical losses for another 10 years.
4. The 1987 situation went to a lower level of recovery for about 76% of the next 586 days
5. Periods earlier than 1984 (particularly the post 1929 years) will likely have worse results but are not included in my analysis.
My record
As for my record of profit, I only became an active manager of my funds since the peak of 2007 and I got in too early after missing some parts of the fall and from the top in 2007 I am now slightly ahead of the market in nominal terms.Measurement is complicated by withdrawals to fund retirement. When I add back my cash withdrawals for living expensesI am down approximately 12% from October 2007 compared to the market being down 37%.
My future strategy
I will sell again if there are falls resulting in a downturn of the 10 day moving SMA but not necessarily on the day of the downturn. I will buy more if more trend lines turn up and there are bullish crosses of some of the trendlines I monitor. I have not yet decided exactly what my buy actions will be based on.
Disclosure
I have a significant exposure to the All Ords established within the last 2 weeks (before the 10 day sma turned up but based upon the size of the fall and the percentiles of volatility and growth), but less than 50% of my investment pool, so at present I am almost ambivalent about the direction of the market. I have locked in some outperformace against the All Ords but can take advantage of any major falls to buy in at lower prices, but will regret not having bought more if prices rise and my 10 day SMA remains in an uptrend.
My 10 day SMA is based on the sum of the last 3 days minus the sum of the previous 3 days
(This does not examine comparative investments in other markets, commodities or currencies)
1. Is there a possible buying opportunity?
2. Should I buy some now?
3. Can I lose by buying now?
4. Is my reliance on these indicators appropriate for the market we are in?
5. Is the 12 month macro environment/outlook positive or negative?
Is there a possible buying opportunity?
Yes!
Should I buy some shares now?
Yes! The 10 day simple moving average has turned up after a fall of 20% (using the intraday low).
Can I lose by buying now?
Yes! The 10 day SMA is volatile and gets whipsawn, but no market recovery starts without the 10 day SMA turning up. Based on the price pattern after the 1987 crash, you can expect to make a loss from whipsawing until there is a significant major uptrend. That major uptrend might start now in which case you will have no drawdown or there may be say 10 false signals, many involving a loss on the round trip trades, until a major uptrend starts. But, you will not be caught in a future major downtrend if you follow a moving average strategy. You may, however, not do as well as if you just bought in 100% now and held as long as possible.
Is my reliance on these indicators appropriate for the market we are in?
This depends on your age/recovery time, other assets, income outlook but if you are highly concerned about major losses (the Japanese scenario where their market is now down 78% from its all time high in 1990) but also want to participate in any upside, a moving average strategy will protect you from a Japanese scenario but at the likely cost of reduced returns in a sideways or uptrending market (This statement based on analysis by Doug Short: www.dshort.com).
Is the 12 month macro environment/outlook positive or negative?
My opinion is that it is negative. This is based on the unresolved PIIGS debt problems, the introduction of fiscal austerity in US, UK and Australia as well as in the PIIGS and the current trailing earnings in the US being at a never sustained multiple of the 10 year average real earnings. The abandonment of mark-to-market also causes concern. However, central banks are taking extraordinary measures to ensure financial stability and to destroy incentives to hold cash and short and even long term securities. The US 10 year rate is about 2.2% and the S&P 500 earnings yield is about 5%, a ratio rarely sustained for long since 1960, so stocks are quite attractive if earnings merely hold up at current levels. I follow the hypothesis of Richard Koo that this is a balance sheet recession and that to avoid GDP falls the government must take the savings of the private sector and spend them.
Detailed explanation.
I analyse the relative performance of the Australian All Ordinaries Index since 1984 including:
1. returns over 2 mnths and 1, 2, 3, 4 and 5 years
2. whether it is overbought/sold against its 200 day SMA
3. its position against its all time and most recent tops
4. the length and size of its most recent rise or fall against all rises and falls of more than 8% since 1984. (8% is a not quite arbitrary number to eliminate the noise of minor, short term fluctuations).
5. its volatility (persistent high volatility is correlated with major bear markets)
6. the comparative percentage recovery over time from major bottoms
7. the rises and falls between major tops and bottoms and between tops and bottom 3 years apart. (to smooth numbers and avoid comparison only to some extraordinary crash or bubble)
8. What gains/losses have been for 1,2,3,4 and 5 years since the previous tops and bottoms to assist in identifying whether based on past growth rates for those periods at prior tops and bottoms we are likely near a top or bottom (but this analysis will not assist in a long term secular downtrend like Japan as each cyclical top is often lower than the previous cyclical top).
Buy indicators
Present indicators of now being a likely buying opportunity include (based on prices since 1984):
1. The Australian market has only been below its highest point previously by the current 37% for 8% of the trading days since 1984, it has been closer to its previous all time high 92% of trading days since 1984 and has always reached new highs.
2. The length of the current fall to its recent bottom is above both average and median duration of all falls of greater than 8% since 1984
3. The size of the current fall to its recent bottom is above both average and median duration of all falls of greater than 8% since 1984
4. My measure of volatility is in the 96th percentile, so near all time highs
5. Growth over 2 months and 1, 2, 3, 4, and 5 years is at significantly lower than median points being in the bottom 10th, 18th, 18th, 10th, absolute bottom and 2nd percentiles.
6. The market has, since 1984, hit a new record high within 5.5 years, so we might expect to be at 6850 by April 2013, which would be a rise of 60% over the next 20 months (personally I doubt it very much, but the September 1987 high was exceeded in January 2004 in spite of the fall of over 50% which took place in September 1987.
7. The percentage recovery of 37.7% at trading day 625 since the bottom is below average and below all but the 1987 recovery at day 625. Until this recent fall the current recovery had never been below average since day 20. But the 1987 recovery had a sustained period of relapse lower than the current 37.7% recovery after day 625. The 1987 recovery went through a further major downturn and spent only 170 of the next 586 days (the limit of my analysis) above the present level. So there is risk of being whipsawn for a loss if you buy now and get a sell signal later.
8. After the recent falls the market is significantly below its linear trend line on a simple scale and its logarithmic trend line on a logarithmic scale so mean reversion would indicate a likely future uptrend, although timing is always uncertain.
Risk indicators
1. the 30, 50, 100 and 200 smas are all still trending down.
2. there have been no bullish crosses of the 10/30, 10/50, 30/50, 30/100, 50/100 or 50/200 moving averages, so there is a real possibility that you will get whipsawn for a loss if you buy now. It may be too early.
3. You can't totally rule out a Japanese style situation of cyclical losses for another 10 years.
4. The 1987 situation went to a lower level of recovery for about 76% of the next 586 days
5. Periods earlier than 1984 (particularly the post 1929 years) will likely have worse results but are not included in my analysis.
My record
As for my record of profit, I only became an active manager of my funds since the peak of 2007 and I got in too early after missing some parts of the fall and from the top in 2007 I am now slightly ahead of the market in nominal terms.Measurement is complicated by withdrawals to fund retirement. When I add back my cash withdrawals for living expensesI am down approximately 12% from October 2007 compared to the market being down 37%.
My future strategy
I will sell again if there are falls resulting in a downturn of the 10 day moving SMA but not necessarily on the day of the downturn. I will buy more if more trend lines turn up and there are bullish crosses of some of the trendlines I monitor. I have not yet decided exactly what my buy actions will be based on.
Disclosure
I have a significant exposure to the All Ords established within the last 2 weeks (before the 10 day sma turned up but based upon the size of the fall and the percentiles of volatility and growth), but less than 50% of my investment pool, so at present I am almost ambivalent about the direction of the market. I have locked in some outperformace against the All Ords but can take advantage of any major falls to buy in at lower prices, but will regret not having bought more if prices rise and my 10 day SMA remains in an uptrend.
My 10 day SMA is based on the sum of the last 3 days minus the sum of the previous 3 days
Labels:
All Ordinaries,
buy signals,
moving averages,
stocks
Location:
Sydney NSW, Australia
Saturday, May 29, 2010
Into and out of Australian Bear Markets since 1984
Using data from Yahoo Finance I have constructed a series of charts which show the lead into the various bear markets in the Australian All Ordinaries and the recovery .
I have also constructed an average of the 5 major bear markets prior to the 2007 bear. This average has then been incorporated in each chart in an arbitrary manner to most closely, in my view, approximate the relevant bear market. The timing of the bottoms has been aligned, but not the actual lowest points. There is also a small amount of vertical compression or expansion in most charts. A green linear trend line for the average recovery is also shown.
This approach makes it easy to see an estimate of the dramatic out or underperformance during different periods. For example, look at the dramatic peaking of the market in 1987 compared to the general trend of the average market leading into a peak and trough.
All charts have the peak before the trough scaled to 1 (100%) so the amount of fall to the bottom can be read from the scale.
Please be aware that in some instances the end of the recovery in one chart may overlap with the period before the trough on another chart eg 1991 trough overlaps on 1992 chart and vice versa.
Click the chart images for a larger image. (Use right click > open in new tab.)
1987
Dramatic bull rally to peak was clearly unsustainable.

1991
The second trough is 1992.

1992
First trough is 1991. 1992 trough is at centre. Note excessively fast recovery to new highs was not sustainable.

1995
Very closely approximates the Average peak, trough and recovery.

2003
The start of the unsustainable rally towards the 2007 peak can be seen towards the end of the recovery from the 2003 trough.

2009
The scale of the fall from 2007 to 2009 makes it very arbitrary as to where the Average recovery is shown. I have chosen to align to the recovery side of the chart. I have also added the graph of the recovery from 1991, also adjusted to align to the recovery side of the chart. Last date is 1 June 2010, day 312, and the correction at the bottom was minus 14.9%. There has been a small rebound since to but is now only minus 11.85%.. The fall may well resume as most countries have broken below their 200 day simple moving average which in some markets is about 65% reliable as an indicator of a major change in trend. This possibility is supported by such fundamentals as:
* a possible second wave of real estate defaults in the US,
* the EUR crisis of sovereign debt owed by the PIIGS (Portugal, Ireland, Italy, Spain)
* the austerity being imposed on those countries
* the continuing possibility that default and withdrawal from the Euro by those countries will be more politically acceptable to voters
* the apparent end of a possible bubble and general slowing of the economy in China, a prime buyer of Australian resource exports.

If the 1992 trough is considered as a "double dip" of the 1991 trough, it started from the peak reached on 22 May 1992, day 341 of the 1991 recovery. In today's timing terms the equivalent high would be in about 6 weeks from now. As can be seen from the graphs, the recoveries vary widely in amount and duration so this is not a forecast.
See the recent post comparing recoveries for more information on the corrections that have occurred during the recovery phase.
Hat tip to Doug Short for his more sophisticated series of charts showing Dow falls and recoveries:
http://dshort.com/charts/bear-recoveries.html?current-bear
Subscribe to:
Posts (Atom)

