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
Month: August 2023
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