Skip to main content


It's going to take some time for me to get my portfolios in order, but I feel good about this decision.  It's going to be more work, but these small portfolios are giving inaccurate results.

I thought it would be useful to remind myself why I'm doing this in the first place.  This started because I wanted to get an idea of whether my EP model was predictive.  I did a quick and dirty test against a somewhat current S&P 500 portfolio I had in my list.  We have to start somewhere right?  Seemed like a good choice.

The results were very encouraging.  Encouraging enough for me to go further with the testing.  Specifically to refine it, remove biases and isolate other factors that could be responsible for the results.

I purchased a list of S&P constituent members that went back years and years.  It was very well done, it shows all the ins and outs of members each quarter.  They're called Siblis Research, for anyone who's interested.  I used this to build S&P lists for each year.  I included every stock that was a member at some point in the year.  I then had to scrub the data including removing financials.  

This model doesn't work on financials.  I've been working on a version that will.  I've build it, but not tested it.  So much testing to do.

The results run from April 1st to March 31st.  I think that range is appropriate, given that 231/300 stocks in this group have a December 31st year end.  We're working on an enhancement to the software that will let the user sort by year end but this is good enough for now.  

As an aside, I'm a believer in good enough.  This will probably sound dreadful coming from an accountant and a financial analyst, but for me, making an estimate based on "close enough" or the best one can do is good enough.  Especially when there is already a lack of precision, which is always the case if you are trying to see into the future, which is what a model is trying to do.

Here's a couple of examples of models or calculations that make me scratch me head with their pointless attempt at being overly precise: the Sharpe Ratio and the standard deviation model.  In the former the numerator is supposed to have the risk free rate subtracted from it.  I think that is a big "who cares".  Does that step really add anything?  It feels arbitrary to me.  Also the standard deviation calculation - in one version you divide by N and another N-1.  I just don't think the "-1" is important.  Just leave it at N always, don't try to pretend that reducing the denominator by one makes it better.  It's elitist.  Keeps the masses away.

Ah, feels so good to admit that to the world.

Anyway, without further ado, here are the results for the EP model back-tested on Y-6 run on a portfolio of S&P constituents (x-financials) from Y-6.

One Year Return

Two Year Return Three Year Return Four Year Return Five Year Return Six Year Return Return for Year Two Return for Year Three Return for Year Four Return for Year Five Return for Year Six Observations: 
I think these are pretty dandy results. Not perfect, but geez, I hope no one reading this is actually expecting that.  Nobody bats 1,000 but one can improve.  My goal is to figure out the rules of this model.  For example, how long do the results persist?  Also, are there "size rules" - does it work better on large cap stocks than small cap stocks?  How does it perform during market stress?  Lots of questions.
I learned that if I work with too small a portfolio, outliers can take over the results and skew them.  So, I'm changing my strategy and moving to larger portfolios, but I am still categorizing by sector.  Perhaps that will fail too, and I might have to change my testing to categorize by market cap.  I'll probably have to do that anyway to determine if size plays a roll.
Tonnes of testing to do, kind of excited.  I feel like I'm chasing a true discovery.  
My goal is to get the testing done by year end.


Popular posts from this blog

11 Reasons Why INVRS is Better Than Excel Alone

If you work with your own investment models you likely use excel to build them, but excel isn’t ideal for many reasons and it costs you in other ways.   First, you need good data and it isn’t just lying around in an easy to import format.   You’re either keying it in yourself or paying money for excel downloads.   When you need data from numerous sources – price information, data from different statements and across multiple years - you must merge it from multiple sheets.   It's a n inefficient process which can lead to data corruption. After all this data is collected and merged, models built and tested, the net result is one statistic for one company.   A stand-alone number without context has limited use.   To be meaningful, you need to compare it to similar companies.       This is just a sample of the challenges.  You need software that overcomes these problems and is designed for investment model creation. Surprise!  This software exists,

NextEra - Good Dividend in the Renewable Energy Sector

NextEra had good results relative to a group of peers in a factor-based analysis. NextEra has an appealing profitability and income profile. Its price momentum looks decent, with a caveat. Its relatively small size (a small mid-cap) coupled with its industry (renewable energy) further weight the odds that this company could be a strong performer in the future. If you want in on renewable energy, we recommend NextEra. The Analysis Overview I created a portfolio of stocks in the alternative energy sector, looking specifically for companies with a market cap over $1B but less than $4B.  This is a sweet spot that offers strong potential for growth but is also substantial enough not to be too speculative. It's my believe that alternative energy is on the ascendance, where as fossil fuels will inevitably decline (NextEra isn't a pure play in this regard however, natural gas assets are part of its portfolio).  If you share this belief and you want exposure to this ma

Analyzing Results - 2013/Y-6

 There were eight companies in Group 8 (no 9) in 2013/Y-6: EW  STZ LRCX ALXN MU MCHP AME DE This is how they each fared from 2014 to 2020 - the year runs from April 1 to March 31st:   EW         92%, -58%, 5%, 48%, 41%, -1% STZ        36%, 31%, 7%, 42%, -22%, -18% LRCX     27%, 10%, 57%, 60%, -6%, 32% ALXN     12%, -18%, -15%, -7%, 24%, -34% MU         11%, -61%, 162%, 82%, -17%, 0 MCHP     5%, 3%, 56%, 27%, -4%, -21% AME        1%, -4%, 9%, 42%, 12%, -14% DE           -2%, -9%, 45%, 45%, 24%, -34% Six Year Return: EW  69% STZ  81% LRCX  355% ALXN  -42% MU  72% MCHP  60% AME  42% DE  68% What score did each of the above have in 2014/Y-5? EW - 6 STZ - 8 (no 9) LRCX - 4 ALXN - 8 (no 9) MU - 6 MCHP - 5 AME - 6 DE -5 What score did each have in 2015/Y-4? EW - 5 STZ -6 LRCX - 6 ALXN -5 MU - 6 MCHP - 2 AME - 3 DE - 1 What score did each have in 2016/Y-3? EW - 8 STZ - 7 LRCX - 7 ALXN - 6 MU - 7 MCHP - 5 AME - 1 DE - 2 What score did each have in 2017/Y-2? EW - 8 STZ - 4 LRCX - 8 ALXN - 6 MU -