Top12/Bottom88 Weighted Ratio

Invesco QQQ Trust, Series 1NASDAQ

الوصف

⋅ ٣ أيار مايو ٢٠٢٣ ٠٢:٣٧

I multiplied the price of each of the top QQQ holdings by their percentage weight, and the bottom 88 holdings for a total of 100. I divide the top 12 weighted price by the bottom 88 weighted price. So I can see when money is flowing in and out of the megacaps. It needs to be updated every quarter, which I may need to do now....

Fundamental Analysis QQQ

التعليقات

MarlosClock

⋅ ٣ أيار مايو ٢٠٢٣ ٠٣:٠٢

I updated the code here

//https://ycharts.com/companies/QQQ/holdings //weightings are multiplied by the percentage currently. May need to be updated periodically FBw = 3.66 * FBclose MSFTw = 12.63* MSFTclose AAPLw = 12.63 * AAPLclose AMZNw = 6.34 * AMZNclose NFLXw = 1.12 * NFLXclose GOOGw = 3.76 * GOOGclose GOOGLw = 3.81 * GOOGLclose TSLAw = 3.07 * TSLAclose NVDAw = 5.17 * NVDAclose //ADBEw = 1.35 * ADBEclose PEPw = 1.97 * PEPclose AVGOw = 2.04 * AVGOclose COSTw = 1.73 * COSTclose CSCOw = 1.47 * CSCOclose //Adding them together TotW12 = FBw + AAPLw + AMZNw + NFLXw + GOOGw + GOOGLw + MSFTw + TSLAw + NVDAw + AVGOw + CSCOw + COSTw + PEPw // + ADBEw

المزيد