What I Saw ( Week of 12.1.14 )

1. Do the airline stocks and oil continue to trend strongly in opposite directions?

ANSWER: Simply put, mostly yes. The below chart shows the following stocks  ( OIL, AAL, ALK, JBLU, UAL ) relative to the broader market ( SPY ) over the last 5 days. Out of the 4 airline stocks chosen here, only ALK underperformed the market. Using OIL as a proxy for oil, investor sentiment is still negative, and some airlines stocks are continuing to benefit from the plunging price. 

2. Do we see a continuation of last week's sell off in small caps and does that translate to a mini correction?

ANSWER: No. Overall equity risk ( SPY, IWM ) had a bid throughout the week. However I think another trend is more important to note. The strength of the  ( $USD ) relative to other assets is clear. This is a trend that needs to be incorporated into every investment thesis moving forward if it has not already. 

3. When risk (high beta small caps/high yield) is sold do we see a continued bid in Utilities and Consumer Staples?

ANSWER: Not yet. The below chart is confirmation of the previous observation that higher beta stocks were bought more aggressively. Both utilities ( XLU ) and consumer staples ( XLP ) underperformed both ( SPY, IWM ).

Overall a somewhat mixed week with the only clear dominant trend being $USD strength, and a somewhat mixed appetite for stock risk... to be continued...

What I'm Watching ( Week of 12.1.2014 )

1. Do the airline stocks and oil continue to trend strongly in opposite directions?

2. Do we see a continuation of last week's sell off in small caps and does that translate to a mini correction?

3. When risk (high beta small caps/high yield) is sold do we see a continued bid in Utilities and Consumer Staples?

4. Keeping an eye out on high yield bonds ( HYG ) and Investment grade corporate bonds ( LQD ) for clues...

What are you watching this week?

Project Update_iVC Reporting Engine

Still working industriously behind the scenes I thought to take some time and give a progress report. Good news is the iVC Reporting Engine is almost fully operational. I've been able to automate the following processes:

Data Collection: I have two methods to obtain public company filings from the SEC via Python scripts.

  • The primary method I use leverages the excellent services of the free (for now) data provider, Quandl.com. They aggregate and distribute data from several primary sources including the SEC and normalize as best as possible given whatever business constraints they have as a young riser. In congruence with their mission statement to improve data accessibility for all, they have also provided a Python module and general API for the motivated entities out there to automate data queries. 
  • Additionally I have a backup database of every public company filing since 2012, which leverages Arelle's open-source efforts to standardize and improve the XBRL standard for finance-IT adoption. My db is configured to use the PostgreSQL standard with Arelle's schema. This still requires more examination of the XBRL format, and/or command line interfaces to return the data I require. Marked: in Development for production purposes.
  • Data Processing: There is overlap with the above, however this includes organizing/filing of the data returned by the collection process. Not a lot to say here other than the files are self-organizing and allow for flexible structures during continued operational development. 

Calculation Engine: This is pretty much the final major component before large scale testing can begin. It is broken down as follows. 

  • I've been able to transition ~99% of my previous Excel and Python calculations into this component. It accesses the processed data, and strips it down to run the calculations as efficiently as possible currently averaging ~15.5 secs per cycle. 

Under Construction: All that's left really is to incorporate the plotting/charting functions and final production output format. Once that is complete live production testing can begin.

You better tell somebody, Blackarbs LLC is coming. 


Walking the Path takes time...

Readers, 

I have been away somewhat after my declaration of providing more useful and interesting content. Why is that? Am I being hypocritical or something worse?

The answer is neither. The essence of the Blackarbs mission is to continuously find ways to add value to investors anywhere and everywhere they may be. Born out of that mission is the iVC report which has helped a few portfolio managers, and private investors (including myself) make prudent well timed investments in value creating stocks (Details to come in a future post). 

To better help current and prospective clients I relentlessly evaluate the current reports, the report creation process and its efficacy as a research tool. I've concluded that the stock reports are incredibly effective at identifying value creators and destroyers within the public equity space but the current, report creation process is NOT SCALABLE. 

Unfortunately I am unable to produce these reports on a massive scale because it takes to long to generate one. When I first began production it took ~4-5 hours to produce a single report. Now it can be done in ~1-1.5 hours which is a dramatic improvement but not nearly fast enough. If there are roughly 3000-5000 stocks in our potential investment universe we can see the time investment needed to evaluate even a subsection of stocks is too great.

THE SOLUTION:

It's simple, the report creation process needs to be automated as much as possible. As a result I've spent the last 12 days working on this programmatically having experimented with solutions based primarily in Python. After building 2 different web scrapers and a calculation engine I realized each 'free' fundamental data source I found presented unique challenges due to their html/javascript structure or some strange reporting convention they use.

Me in the lab 


Enter XBRL. If you are not familiar XBRL is the cutting edge financial reporting standard based on the XML documentation 'language' that the SEC has mandated public companies adhere to. Essentially publicly traded firms have a mandate to provide all their fundamental SEC/financial data in this semi consistent format which is ..."easily"... accessed  by software. 

Make no mistake as a result of being 'cutting edge' and in development, the XBRL standard is not simple or easy, yet. However, it is the best solution in that the calculation engine I use to analyze the companies and output grades will be based on data provided directly to and by the SEC! This is a massive upgrade IMHO to third party data providers. This project is ongoing and Blackarbs' progress in developing and implementing this solution is fast-paced. 

So please forgive the sporadic posts until the report generation engine is completed hopefully within the next two weeks. 

Stocks - Post Earnings UPDATE (week of July 21, 2014)

Let's take a look at how the previously graded stocks have performed over the last ~10 days.

Please note this is a raw analysis in that these stocks reported at different times last week, so cumulative performance may be affected by the date they reported in addition to other factors. 

returns comparisons

returns comparisons

The key take away for me regarding this chart is that most of the returns on this extremely short time scale cluster between +/- 5%.  There are a couple relatively 'extreme' movements by this collection of stocks. Let's look at the next chart which allows for more detailed analysis.

returns comparison_facet

returns comparison_facet

First, for context the cumulative return for 'risky' assets is negative over the last 10 days. We can see this when using 'SPY' and 'HYG' as proxies for investors' risk appetite. 

For reference the stocks with an 'Investment Prospect' grade ( iVC score > 60% ) included: AAPL, ABBV, ALB, ALGN,  DRC, FB, HOG, INFA, LO, NDAQ;

Stocks with a 'Neutral' grade (  45% <= iVC score <= 60% ) included: DNKN, KO, RFMD, RVBD;

Stocks with a 'Sell / Short Target' grade ( iVC score < 45% ) included: TQNT

Of  the 10 stocks with an Investment Prospect grade only 5 have positive cumulative returns over this timespan. Admittedly I haven't updated all the grades (post earnings) for these firms yet but will be doing so over the next quarter. So, without knowing each of these firm's current guidance does the fact that the other 5 investment prospects have under performed mean they are now terrible stocks and my scoring process is garbage? Only time will tell. BUT...

...lets be clear only DRC, and INFA would have a blown a hole in your portfolio if you were long these stocks going into earnings. Surprisingly ALL of the other investment prospects have outperformed or remained within an approximate 1% cumulative decline which happens to mirror the returns of the broader market and other risky assets (SPY, HYG) during the same time frame. I'll chalk this up to a win for the preliminary Blackarbs 'iVC' grading process.  

Now looking at the stock returns of the equities with a neutral grade we see the results are split! DNKN, and KO have declined while RFMD and RVBD have appreciated. This is actually a desired result and exactly what I would expect and hope to see in this context. Neutral grades mean we see no 'obvious' asymmetric risk:reward setups; or in other words, these stocks are or should be equally likely to appreciate or decline in value over some time span. Score another win for Blackarbs grading process.

Now let's look at TQNT which is the only equity with a failing or short target grade. Thus far TQNT has appreciated ~2% over this time period. This could be a function of two important factors one needs to consider during the investment process especially during earnings periods.

Investor expectations, and Industry.

Simply put a great company with a great stock could report stellar earnings but if the company fails to meet investor expectations the stock is likely to decline in the immediate aftermath. The same is true in reverse. TQNT registered one of the worst equity grades (18%) Blackarbs has recorded thus far which could be an indicator that, while the company is clearly struggling, investor expectations are (could be) at their lowest. Therefore ANY positive results from the earnings report could act as a catalyst for the stock to appreciate. The second factor of importance is the industry the firm operates in. TQNT is a semiconductor company. If you have been following the markets you know that this is one of the *hottest* and strongest performing sub-industries of the Technology sector this year. The expression 'a rising tide lifts all boats' is applicable here. In the short term both of these factors could be contributing to the TQNT's short term outperformance. Only time will tell with this one. So far this is a loss for the grading scale with an opportunity to become a win. 

Preliminary Blackarbs IVC grades are 2/3 thus far. I like the start and will look to continue this feature moving forward.