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