The Missing Link between Fundamental and Technical Equity Analysis

(Click on the image to enlarge)

The missing link between the fundamental and technical equity analysis is a market-based statistical Correlation Matrix.

Analysis of the above Correlation Matrix

1. The correlation among Apple (AAPL), Amazon (AMZN), Facebook (FB) and Google (GOOG) is very (positively) high (> 0.80), meaning they will move in tandem. A portfolio comprising exclusively of such highly correlated stocks would be considered an 'Ultra Aggressive' portfolio.

2. Twitter (TWTR) however adds a low-to-moderate positive correlation to the aforesaid four, meaning there are days TWTR will not necessarily move in lockstep with the other four stocks. A portfolio constructed as such would, nonetheless, be 'Very Aggressive.'

3. IBM, on the other hand, shows negative correlations with all five and obviously very high negative correlations with the first four, thus providing an excellent hedge. The inclusion of the IBM hedge would lower the overall risk, paving the way for an 'Aggressive' portfolio.

Ideally, in order to capture any meaningful shifts in relationships, researchers should run this matrix in three phases: short-term (recent 30 days), medium-term (6 months) and long-term (9-12 months). 

Disclaimer - The author is not advocating any of the stocks listed here; instead, this is just a research piece  - often overlooked - connecting fundamental and technical analyses. Consult your Registered Rep, RIA or Financial Planner for an appropriate asset allocation model and the holdings therein.  

-Sid Som, MBA, MIM
President, Homequant, Inc.
homequant@gmail.com
  

Link to the Book

Can Dow Jones Industrial Average (DJIA) Predict the Housing Market and vice versa?

(Click on the image to enlarge)

Suraj, a Harvard graduate with two years of experience as market strategist, is interviewing for Senior Quantitative Strategist.

Question # 1

Interviewer: Would you consider these two market segments predictive of each other?

Suraj: Absolutely. The Correlation Coefficient and Regression R-squared are showing they move in lockstep and in the same direction.

Question # 2

Interviewer: Is the linear trendline the best fit? Eyeball the scatter and use your best quantitative judgment.

Suraj: For a management presentation, the linear trendline is fine. For a technical presentation, I would use Polynomial trendline with 3rd order which would reduce the noise on the outer end of the curve.

Question # 3

Interviewer: By doing so, how much improvement do you expect to see? 

Suraj: I would expect the R-squared to move up in the vicinity of 0.96.

Interviewer: Okay, please give me a minute and let me find out. Yes, you are right. It's 0.956, so it's actually 0.96 rounded. I must say, you have developed an excellent eye for the data distribution.

Question # 4

Interviewer: Let's assume we are trying to hang our hat on this solution. Would you recommend this to our clients who enjoy short-term trading?

Suraj: No. This analysis is developed off the monthly data so it is not viable for the short-term traders. For the short-term housing traders, the analysis must be based off the local home sales data and for the short-term equity traders, it must be developed off the most recent 3-months of daily closing data or most recent 6-months of weekly closing data.  

Question # 5

Interviewer: Agreed, this is an analysis, not a solution. Either way, who would you recommend this analysis to? 

Suraj: Those who have much longer time horizon, like the Mutual and Pension Fund Managers, and other long-term investors.  

Question # 6

Interviewer: How would you improve upon this analysis in a very short period of time?

Suraj: I would try to study and isolate the seasonality in both data. For example, for the residential investors, Q1 might be better than Q3. Likewise, Q3 might be the best quarter to sell stocks to book profit. Analysis of seasonality is part and parcel of any long-term trend analysis.  

Question # 7

Interviewer: Would you stick to this data and time series to study the seasonality?

Suraj: No. The study of seasonality requires at least one full cycle of data, preferably more, so I would go back a few more years. Of course, this is a large enough sample to study the basic collinearity so I would expect the collinearity would still remain in the ballpark.

Question # 8

Interviewer: Don't you think the impact of new economic and fiscal policies and other major economic events would distort the seasonality analysis?

Suraj: No. Those impacts can be separated out. For instance, the new cap on SALT has been impacting the high-end residential market in high tax areas so the co-mingling of that sort of data would be imprudent. 

Question # 9

Interviewer: How would you (physically) separate out that data? Give me examples from both data series.

Suraj: In terms of the housing data, you are using the Case-Shiller Composite 20, meaning the largest 20 MSAs in the country. We know the pockets hit hardest by the SALT cap so they must be removed from the data. Similarly, I would not use the stretch of Dow Jones data post 9/11.     

  

* Case Shiller is a registered trademark of S&P CoreLogic.

-Sid Som, MBA, MIM
President, Homequant, Inc.

homequant@gmail.com

Link to the Book

Consider these Additional Factors while Choosing High Dividend Stocks - for Long Haul

(Click on the image to enlarge)

In choosing a set of high dividend stocks for the long haul, data savvy investors need to additionally consider, at a minimum, price-earnings ratio and volatility. Of course, equity research analysts would consider a slew of other factors including book, cash, reserve, growth, liquidity, debt, etc.  

A composite combining PE and Beta (or V-factor) is critical. The two composites - Beta-adj and Vfact-adj - have been used (the graphic above) to make the case. While the Beta-adj composite points to Verizon (VZ), P & G (PG), IBM (IBM Corp.), XOM (Exxon Mobil), GE and JNJ (J & J) as the best (< 50 as acceptable scale value) high dividend stocks, Vfact-adj picks PG, VZ, XOM, IBM and MRK (Merck). 

Despite high dividend yields, CVX (Chevron) and KO (Coca Cola) didn't make either cut due to high PEs. Likewise, BA (Boeing) didn't fare well either due to the high volatility.

Disclaimer - The author is not advocating any of the stocks listed here; instead, this is promoted as an alternative research in creating a statistically significant and more predictive volatility factor for individual stocks. Consult your Registered Rep, RIA or Financial Planner for an appropriate asset allocation model and the suitability of stocks and other holdings.  

-Sid Som, MBA, MIM
President, Homequant, Inc.

homequant@gmail.com

Link to the Book

High-Low Ratio is a Good Way to Measure Volatility of Stock Market Averages and Indices

-- Intended for New Analysts and Researchers --

(Click on the image to enlarge)

Stock market Volatility, particularly highly liquid individual stocks, averages and indices can be defined by the ratio of their Daily Highs and Lows. Simply put, the higher ratio represents higher volatility and vice versa. 

The Daily Volatility chart shows an elevated volatility in February through early April, gradually tapering in May, June and July. While the median ratio during this 7-month period was 1.01, it exceeded 1.04 on four occasions in February and 1.03 on five occasions thereafter. Obviously, the February standard deviation was significantly higher than the overall (Feb 0.0158 vs. Overall 0.0093).

As expected, the Weekly Volatility chart shows more extreme volatility as it depicts the weekly highs and lows. For instance, the median ratio and standard deviation were 1.0244 and 0.0180, respectively. The volatility peaked at 1.0925 (week of February 5th), keying off the weekly high of 25,521 and low of 23,360. Additionally, it exceeded 1.04 on six occasions - a wow feat indeed! The volatility waned in May-July.

If you decide to present one chart, the Weekly one is more meaningful as it cuts through the daily noise and hones in on true extremes. In that case, add the trendline. You may also normalize it by Closing Prices, making it more predictive.

Good Luck! 

Sid Som, MBA, MIM
President, Homequant, Inc.
homequant@gmail.com

Link to the Book

To Evaluate Performance of a Major Stock, Compare it with the Average/Index it Belongs to

(Click on the image to enlarge)

-- Intended for New Graduates & Analysts --

To understand the performance of a major stock, compare it with the primary index/average it belongs to. Since Goldman Sachs (GS) is one of the 30 stocks that comprise the Dow Jones Industrial Average (DJIA), its performance should be compared with the DJIA, a priori.

The top chart shows the weekly closing prices of both between 7/01/17 and 6/30/18. Though GS outperformed the DJIA through 3/10/18, it completely fell apart ever since, leading to the retesting of the 7/3/17 price. The DJIA, on the other hand, registered a solid 13.34% price appreciation during this one-year period.

The DJIA (middle chart) shows the meteoric rise from 21,400 to 26,600 (24.30% gain) through 1/22/18, but gave back 11% since then. Nonetheless, the remaining annual gain was noteworthy.

GS (bottom chart) performed equally well through 3/5/18, moving up from 222 to 270, with a gain of 21.32%. Unfortunately, that was also the tipping point leading to a linear decline. The trendline confirms the continued awful decline.

FYI - since the weekly closing prices are already smooth, you do not need to add the moving average trendline. When you use the daily closing prices, you do. 

Disclaimer - The author is not advocating any of the stocks/indices listed here. Consult your Registered Rep, RIA or Financial Planner for an appropriate asset allocation model and the suitability of stocks and other holdings for you.

- Sid Som, MBA, MIM

President, Homequant, Inc.

homequant@gmail.com

Link to the Book

A Scatter Plot of Weekly Closing Prices is a Good Starting Point to Analyze Stocks and Indices

(Click on the image to enlarge)

               -- Intended for New Analysts --

While there are many ways to learn to analyze stocks or the stock market as a whole, here is one simple way I generally propose:

1. Instead of starting with a Stock or ETF, consider a liquid Index/Average like Dow Jones Industrial Average (DJIA), which comprises the 30 largest cap stocks. You may look at it as the front-end of the stock market. This type of analysis is known as the top-down approach (analysis of individual stocks represents the bottom-up approach). Alternatively, you may use the S&P 500, a.k.a. the broader market.

2. Whether you decide to experiment with stocks or indices, the most common database will consist of these variables: Date, Open, High, Low, Close, Adj Close and Volume. In terms of frequency (time interval), the common choices are: daily, weekly and monthly. Some sites may offer yearly roll-up as well (yearly prices are used to study historical trends like Laureate Shiller's CAPE ratio, etc.).

3. Though the Daily Adj Closing Price is the most frequently used data (along with other variables) in defining trend and strategy, use the Weekly/Adj Price as part of your first attempt. As you can imagine, weekly prices are less noisy and much smoother (than the daily prices), leading to easier data visualization. Once you get into more advanced analysis and modeling, you will use the other variables either as ratios or as independent variables. 

4. The best way to get a good feel for the data, trend and outliers is to create a scatter plot. Eyeball the scatter and fit your trendline. Since you are dealing with weekly averages here, leave out the moving averages. As you learn to analyze the daily data, you will see the utility of 60 to 200-day moving averages which are standard metrics in this business. If you are unsure of the differences amongst linear, logarithmic, exponential, polynomial, power, etc. trendlines, go back to your text books and brush up your knowledge. 

5. One of the skills you must develop is to quickly identify the outliers (noise). If you are working on defining trends leading to business strategy, it is absolutely imperative to work with the data as outlier-free as possible. Look at the two scatter graphs above. The only difference between the top and the bottom is that the latter has three fewer data points (week of 1/7/18, 1/14/18 and 1/21/18), resulting in a much cleaner dataset with higher r-squared. If you remove two more data points (12/31/17 and 1/28/18), the r-squared jumps to 0.923 (not shown). Again, one of the skills (perhaps habits) you must develop is to be able to identify the outliers quickly; otherwise you will end up fitting wrong trendlines.

6. Once you have the data and trendlines under control, the first thing you will look for is the formation of supports. If the stock/index bounces off a price level repeatedly, a support is being buoyed. When the support extends out to form a double bottom (like W), any reversal tends to be bullish.

7. The next thing you need to learn is to identify the congestion level. If the stock/index makes an extended sideways move within a band, it is considered "stuck" within a congestion zone. For instance, if it remains range-bound between $40 and $45 for several weeks, it has developed a short-term congestion. Many professional traders take advantage of the congestion by "channeling" those stocks/indices.

8. Often, a stock/index makes a rally but falls apart quickly at a particular price point. For example, if the stock makes multiple attempts to cut through the $45 area but fails, it has developed a short-term resistance there. Traders who buy on strength tend to develop a watch list of such stocks/indices. Professional traders generally write covered calls when the stock fails to break out.

9. When a stock/index eclipses past the resistance and maintains the upward move, it is considered a breakout. Traders who buy on strength wait for a breakout to occur. As soon as the breakout is confirmed (closes above the breakout price), they start to initiate long positions (or buy calls, sell puts, etc.).

As you get started, these are some of the market basics you must be very comfortable with.

Good Luck!

- Sid Som, MBA, MIM

President, Homequant, Inc.

homequant@gmail.com

Link to the Book

How to Define, Compute and Manage True Volatility of Major Stocks

(Click on the image to enlarge)

The most widely-used metric to determine the volatility of a given stock is known as the Beta which shows the volatility of a stock relative to the overall market (generally S&P 500). When the stock moves in perfect tandem with the market, the Beta is 1. Likewise, when the stock is more volatile, Beta > 1 and vice versa. In the above example, Cisco (CSCO) an Intel (INTC) are the two most volatile stocks while Procter & Gamble (PG) and Coca-Cola (KO) are the least volatile ones.

While Beta is an external metric, an internal metric in the form of a Coefficient of Variation (COV=Std Dev/Mean) may be computed using the daily closing prices. Then, the combination of the external and internal metrics would help create a more efficient and predictive volatility factor (V-factor). FYI - COV is a better metric than Std Dev as it is normalized.

Here is why the aforesaid V-factor is more efficient and predictive than the Beta: Though CSCO has the highest Beta, it has low internal volatility (daily movement of prices) as reflected in the low COV, thus lowering the overall V-factor significantly (down to 6.21), even lower than GE's which tends to move almost in lockstep with the market.

Of course, there are other methods to capture the volatility including modeling the daily swings. 

Disclaimer - The author is not advocating any of the stocks listed here; instead, this is promoted as an alternative research in creating a statistically significant and more predictive volatility factor for individual stocks. Consult your Registered Rep, RIA or Financial Planner for an appropriate asset allocation model and the suitability of stocks and other holdings.  

--Sid Som, MBA, MIM
President, Homequant, Inc.

homequant@gmail.com

Link to the Book