How to create the Mansfield Relative Performance Indicator
#1
One of the core components of Stan Weinstein's method is the use of Relative Performance compared to an index such as the S&P 500, to a sector or to another stock. Which was referred to in his book as Relative Strength.

However, this should not to be confused with the popular RSI (Relative Strength Index developed J. Welles Wilder), which is a momentum oscillator that measures the speed and change of price movements on a single stock. And so, to avoid any confusion when talking about the kind of Relative Strength we are interested in, I've renamed to be "Relative Performance" on the Stage Analysis website.

Weinstein defines it as the following on page 18 of the book:

Quote:"How a given stock (or group) acts in relation to the overall market. For instance, if stock XYZ rallies 10 percent while the market moves ahead 20 percent, that's poor relative strength even though the stock has advanced. On the other hand, if stock XYZ declines 10 percent while the market averages decline 20 percent, that's favorable relative strength even though the stock has moved lower. The formula for measuring relative strength is simply the price of a stock ( or group average) divided by the price of a market average."

Relative Performance Indicators

On the Stage Analysis website I have two ways of representing the Relative Performance on a chart. The first version I show is the representation that people are used to from the book (#1 on the below chart) which is the Mansfield Relative Strength Indicator. The second version that I show immediately below (#2 on the below chart) is the standard relative performance line that you get if you divide the closing price of the stock by the index that you want to reference, which in the majority of cases on the Stage Analysis website will be the S&P 500 Index unless otherwise stated.

So as you can see, these two indicators are identical, however, they show the Relative Performance data in slightly different ways, which I personally find useful to see. For example, the "zero line" on the Mansfield version is a flattened 52 week moving average which shows the data more like an oscillator and so is easier to see when it reaches extremes. However, on the standard relative performance line the slope of the 52 week moving average (zero line) can be seen, which can give further clues to the relative performance of the stock versus the index on a longer term basis.

Below is a weekly chart of Apple (AAPL) showing the two versions of the Relative Performance Indicator versus the S&P 500 Index.

[Image: attachment.php?aid=1362]

Standard Relative Performance indicator

The formula for calculating standard relative performance indicator is quite simple:

Code:
RP = ( stock_close / index_close ) * 100

And then a 52 week moving average is added to the indicator to show the zero line.

So the longer version is:

Standard Relative Performance = (today's close of the stock divided by today's close of the index) * 100


Mansfield Relative Performance indicator

The formula of this indicator is a bit more difficult than the regular Standard Relative Performance indicator:

Code:
MRP = (( RP(today) / sma(RP(today), n)) - 1 ) * 100

Where:
RP = Standard Relative Performance indicator (see above)
SMA = Simple moving average over n days.
n = 52 for weekly charts, and n = 200 on daily charts

So to make it a bit clearer:

Mansfield Relative Performance = (( Today's Standard Relative Performance divided by Today's Standard Relative Performance 52 Week Moving Average )) - 1) * 100

I hope the above calculations all make sense, but if you need further assistance then chartmill.com did a good article on it which you can find here: https://www.chartmill.com/documentation....Mansfield)


Attached Files Thumbnail(s)
   
isatrader

Fate does not always let you fix the tuition fee. She delivers the educational wallop and presents her own bill – Reminiscences of a Stock Operator.
Reply
#2
A great post - very useful explanation. Thanks
Reply
#3
You mention that n=52 for weekly and n=200 for daily.
This is also using weekly and daily chart data respectively for each price bar/candle?

I am currently trying to code this up in Sharescope (and will share it on this forum when done) but struggling a bit.
Reply
#4
(06-04-2013, 09:21 AM)bluemosaic Wrote: You mention that n=52 for weekly and n=200 for daily.
This is also using weekly and daily chart data respectively for each price bar/candle?

I am currently trying to code this up in Sharescope (and will share it on this forum when done) but struggling a bit.

When coding it, remember that you are creating a 52 week moving average of the stock divided by the index to get the zero line on the weekly chart, and 200 day moving average of the stock divided by the index to get the zero line on the daily chart. So first off create number 2 from the AAPL example in the first post, as that's just adding a moving average to the relative performance indicator, as that will give you have a reference to create the flattened version.

I can't speak to how Sharescope handles the data, but my software just looks at each bar.

There seems to be a current thread on the Sharescope forum on this here: http://forums.sharescope.co.uk/viewtopic...+indicator which looks to have copied part of my post, and someones had a go at it, but it looks to not be quite right yet. But it might help you get started.

Cheers
isatrader

Fate does not always let you fix the tuition fee. She delivers the educational wallop and presents her own bill – Reminiscences of a Stock Operator.
Reply
#5
David,

thanks for the great post. I was always wondering how the Mansfield Relative Strength Indicator was built.

Where did you find out how it is built? I thought it wasnt in the book or did I skip it?

Best,
Christian
Reply
#6
(01-22-2014, 01:38 PM)ikeaboy Wrote: Where did you find out how it is built? I thought it wasnt in the book or did I skip it?

No, it wasn't in the book. Chartmill.com did a really good write up on it, as they have it available to screen for in their free scanner, which helped me to understand how to create it. Here's the link to their article: http://www.chartmill.com/documentation.p...20Strength and I read about it in a few other places as well, but I can't remember off the top of my head now. But took a lot of time searching Google for any reference of it.
isatrader

Fate does not always let you fix the tuition fee. She delivers the educational wallop and presents her own bill – Reminiscences of a Stock Operator.
Reply
#7
@isatrader thanks a lot!
Reply
#8
Today, 2 May you created posted a plot of IRDM on the watchlist. What settings did you use to create this chart in stockcharts? Specifically the relative performance versus the S&P.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)