The GICS logical structure is remarkably good and amendable to simple but powerful customized lower level logic. This post continues the discussion from S&P 1500 GICS Codes. IT is not considered research and development by either Wall Street Broker Dealers or the myriad small financial data firms on the web catering to amateurs. Consequently, the… Continue reading Moving Through The GICS Structure With Excel VBA
S&P 1500 GICS Codes
Using the xlq2 Com interface to Norgate Data and VBA, a spreadsheet showing current S&P 1500 components can be built in 3 to 5 seconds. MV$B - Market value in billions = shares outstanding * closing price. Most of the time market value of a common stock is the same as market capitalization. MV is… Continue reading S&P 1500 GICS Codes
Using GICS With Excel VBA
All serious investors and traders are vitally interested in creating lists of stocks that have something in common. Industry classification or taxonomy is a major concern of the major financial data players who have invested a lot of money in these things over the years. The Global Industry Classification Standard (GICS) was developed in 1999… Continue reading Using GICS With Excel VBA
Basics Of Stock Return Analysis
For the last several years, I've been developing the concept of finite state stock return analysis. There are a bunch of excellent ways to implement this type of methodology. I've been specifically looking at dividing the market day into two finite states.
SPY and QQQ Charts, March 2023
Simple Moving Averages I think this is the best daily chart to look at. The idea is to include maximum information in as simple a structure as possible to facilitate understanding. The conventional two SMA choices are the 20 day and 50 day, which are fine of course. I use the 18 day and and… Continue reading SPY and QQQ Charts, March 2023
Stock Charts With Excel
I'm hoping to start regular commentary again, and thinking about ways to share my VBA code. SPY began the day in the pocket formed by the 20 and 50 day SMA. This would a nice time for a move to challenge those two topping tails. Recently, I've been working with the Excel chart object, which… Continue reading Stock Charts With Excel
2/10/22 – The Homestretch
SPY Daily Fib Retracement The view that the bottom was put in on Jan 24, was optimistic, but not ridiculous. SPY made a recovery to 61.8 Fib line which is close to the 54 day moving average and is encountering resistance. The recent pattern with the gaps to minor highs is not very reassuring. This… Continue reading 2/10/22 – The Homestretch
11/19/21 The Homestretch
The consecutive weekly white candle streak ended at five. All of the candles were shaped about as good as they get. The more recent two week period looks more like a consolidation than a topping pattern. The November low of 458 is probably important because it was probed last week. Any minor weakness should be… Continue reading 11/19/21 The Homestretch
11/5/21 SOXL and Other Leveraged Bulls
The widely expected September weakness and turnaround in October actually happened. The weakness was quite mild while the strength was extraordinary. SOXL made a double bottom, consolidated for a week or so on the sunny side of the 54 day SMA, and then almost doubled from October lows.. Seems like the imbeciles that bought Evergrande… Continue reading 11/5/21 SOXL and Other Leveraged Bulls
11/2/21 The Homestretch
The little guys are breaking out to the upside from a ten month base. The bottoming pattern is pretty, especially from July. Note how the 52 week is rising at a steeper angle than the 13 week. IWM and associates are usually heart breakers on breakouts, but both the 13 and 52 week levels look… Continue reading 11/2/21 The Homestretch