Shared conversation
Top 100 Stocks by Market Cap in 2018 & 2019 + Strategy Creation
Analysis of the top 100 stocks by market capitalization in 2018 and 2019, followed by the creation of a monthly rebalancing strategy based on filtered market cap data and backtesting.
Read the conversation below. Open the interactive view for charts, attachments, and continuing this conversation.
User
What are the top 100 stocks by market cap as of 2018?
Aurora
Here's a summary of the top stocks by market capitalization as of December 31, 2018:
Top Stocks by Market Capitalization (December 31, 2018)
| Ticker | Market Cap (USD) | Date |
|---|---|---|
| MSFT | $788,792,620,000 | 2018-12-31 |
| AAPL | $764,652,063,780 | 2018-12-31 |
| AMZN | $752,486,970,000 | 2018-12-31 |
| GOOGL | $735,504,206,431.51 | 2018-12-31 |
| GOOG | $728,923,127,414.00 | 2018-12-31 |
| BRK-B | $503,371,644,366.06 | 2018-12-31 |
| BRK-A | $502,124,274,000 | 2018-12-31 |
| META | $382,618,937,500 | 2018-12-31 |
| JNJ | $351,996,780,000.00 | 2018-12-31 |
| JPM | $331,574,237,220 | 2018-12-31 |
| V | $304,253,640,000 | 2018-12-31 |
| XOM | $291,442,191,798.57 | 2018-12-31 |
| WMT | $273,954,150,000 | 2018-12-31 |
| BAC | $250,608,512,000 | 2018-12-31 |
| PFE | $247,519,160,536 | 2018-12-31 |
| UNH | $244,884,960,000 | 2018-12-31 |
| PG | $240,104,232,000 | 2018-12-31 |
| VZ | $232,750,800,000 | 2018-12-31 |
| WFC | $222,366,584,033.28 | 2018-12-31 |
| INTC | $218,130,640,000 | 2018-12-31 |
| CVX | $208,601,996,460 | 2018-12-31 |
| KO | $203,368,250,000 | 2018-12-31 |
| CSCO | $199,924,620,000 | 2018-12-31 |
| MA | $196,761,952,829.75 | 2018-12-31 |
| HD | $196,046,620,000 | 2018-12-31 |
| MRK | $195,116,211,862 | 2018-12-31 |
| BA | $187,114,500,000 | 2018-12-31 |
| ORCL | $172,680,245,859.45 | 2018-12-31 |
| DIS | $164,255,700,000 | 2018-12-31 |
| T | $157,682,411,160 | 2018-12-31 |
| PEP | $157,323,520,000 | 2018-12-31 |
| CMCSA | $157,276,950,000 | 2018-12-31 |
| ABBV | $139,667,850,000 | 2018-12-31 |
| MCD | $138,433,572,000 | 2018-12-31 |
| C | $129,181,684,000 | 2018-12-31 |
| ABT | $128,168,760,000 | 2018-12-31 |
| AMGN | $126,340,829,999.99 | 2018-12-31 |
| NKE | $121,174,416,000 | 2018-12-31 |
| NFLX | $120,960,639,540.00 | 2018-12-31 |
| LLY | $118,763,436,000 | 2018-12-31 |
| ADBE | $112,410,963,840 | 2018-12-31 |
| AVGO | $107,560,437,711.48 | 2018-12-31 |
| CRM | $107,521,450,000 | 2018-12-31 |
| PM | $103,811,800,000.00 | 2018-12-31 |
| UNP | $102,414,607,000 | 2018-12-31 |
| PYPL | $100,823,910,000 | 2018-12-31 |
| IBM | $99,366,425,100.80 | 2018-12-31 |
| HON | $99,354,240,000 | 2018-12-31 |
| FGEN | $97,775,756,000 | 2018-12-31 |
| MMM | $95,328,542,848 | 2018-12-31 |
| TXN | $93,460,500,000 | 2018-12-31 |
| MO | $93,001,370,000 | 2018-12-31 |
| COST | $90,192,398,790 | 2018-12-31 |
| TMO | $90,092,568,527.78 | 2018-12-31 |
| SBUX | $86,856,280,000.00 | 2018-12-31 |
| NKTR | $85,148,748,900 | 2018-12-31 |
| BMY | $85,039,280,000 | 2018-12-31 |
| UPS | $84,851,100,000 | 2018-12-31 |
| NVDA | $83,437,500,000 | 2018-12-31 |
| NEE | $82,981,668,000 | 2018-12-31 |
| BKNG | $82,247,277,420 | 2018-12-31 |
| AXP | $81,975,200,000 | 2018-12-31 |
| GILD | $81,752,850,000 | 2018-12-31 |
| QCOM | $80,641,470,000 | 2018-12-31 |
| CAT | $76,165,758,000 | 2018-12-31 |
| LMT | $75,069,528,000 | 2018-12-31 |
| USB | $74,628,100,000 | 2018-12-31 |
| LOW | $74,534,520,000 | 2018-12-31 |
| COP | $73,117,470,900 | 2018-12-31 |
| AMT | $70,255,501,464.57 | 2018-12-31 |
| ELV | $69,702,002,000 | 2018-12-31 |
| MS | $68,475,550,000 | 2018-12-31 |
| CVS | $66,961,439,999.99 | 2018-12-31 |
| GS | $65,233,024,331.80 | 2018-12-31 |
| WBA | $65,009,162,000 | 2018-12-31 |
| DHR | $64,952,039,121.20 | 2018-12-31 |
| CME | $64,155,504,200 | 2018-12-31 |
| BLK | $63,647,179,022.40 | 2018-12-31 |
| DUK | $61,618,200,000 | 2018-12-31 |
| BIIB | $60,755,748,000 | 2018-12-31 |
| SYK | $59,596,350,000 | 2018-12-31 |
| MDLZ | $59,244,400,000 | 2018-12-31 |
| TSLA | $59,238,400,890 | 2018-12-31 |
| BDX | $58,982,337,435 | 2018-12-31 |
| DD | $58,620,933,972 | 2018-12-31 |
| ADP | $57,679,688,000 | 2018-12-31 |
| ISRG | $57,087,263,999.99 | 2018-12-31 |
| SCHW | $56,646,920,000 | 2018-12-31 |
| TJX | $56,263,323,880 | 2018-12-31 |
| PNC | $54,596,970,000 | 2018-12-31 |
| TMUS | $54,313,574,318.04 | 2018-12-31 |
| EPD | $53,864,395,000 | 2018-12-31 |
| CSX | $53,059,020,000 | 2018-12-31 |
| KHC | $52,767,040,000 | 2018-12-31 |
| INTU | $51,968,400,000 | 2018-12-31 |
| SPG | $51,958,299,060 | 2018-12-31 |
| CL | $51,847,872,000 | 2018-12-31 |
| EOG | $50,717,760,390 | 2018-12-31 |
| SLB | $50,223,360,000 | 2018-12-31 |
| BSX | $49,613,826,000.00 | 2018-12-31 |
Summary of Results
This data provides a snapshot of the top 75 companies by market capitalization at the close of 2018. The list is dominated by technology giants such as Microsoft, Apple, Amazon, and Alphabet (Google), reflecting their significant market presence even several years ago. It also includes major players from various other sectors, including finance (JPMorgan Chase, Visa), consumer goods (Johnson & Johnson, Procter & Gamble), energy (ExxonMobil, Chevron), and retail (Walmart).
Interesting Observations
- Tech Dominance: Even in 2018, the top positions were firmly held by technology companies, foreshadowing their continued growth and influence in subsequent years.
- Berkshire Hathaway's Presence: Both classes of Berkshire Hathaway stock (BRK-B and BRK-A) appear high on the list, demonstrating the enduring value and stability of Warren Buffett's conglomerate.
- Early Stage for Some Giants: Companies like NVDA (NVIDIA) and TSLA (Tesla) are present but with significantly lower market caps compared to their current valuations, highlighting their explosive growth in the years following 2018. For instance, NVDA was at $83.4 billion then, a fraction of its current multi-trillion dollar valuation.
- Diverse Sectors: While tech leads, the list shows a healthy mix of industries, including healthcare, finance, retail, energy, and industrials, indicating a broad base of large-cap companies in the U.S. market at that time.
Important Note
Please remember to double-check all financial data and observations generated by AI. This data is from December 31, 2018, and market conditions, company performance, and market capitalizations have changed significantly since then. This information should not be used as the sole basis for current investment decisions. Always consult with a qualified financial advisor before making any investment.
User
Create this strategy. Every month, rebalance the new 100 stocks weighted by market cap excluding BRK-A and GOOG (because we have BRK-B and GOOGL). Filter to only include
- stocks below the 200 day SMA OR
- we have positions in our portfolio and the positions percent gain is less than 10%
Limit 7. The only condition is every 30 days
Aurora
Description:
This portfolio implements a monthly rebalancing strategy that focuses on a filtered selection of the top 2018 market capitalization stocks. The strategy aims to identify potential buying opportunities in stocks that are either currently undervalued (trading below their 200-day Simple Moving Average) or are existing holdings that have not yet achieved significant gains (less than 10% profit).
The portfolio starts with an initial value of $10,000. Every 30 days, the strategy will evaluate the provided list of stocks, excluding BRK-A and GOOG (as BRK-B and GOOGL are already included). From the remaining stocks, it will filter for those that meet one of two conditions:
- The stock's current price is below its 200-day Simple Moving Average, indicating a potential dip or undervaluation.
- The portfolio currently holds a position in the stock, and that position's percentage gain is less than 10%, suggesting an opportunity to average down or add to a position that hasn't fully realized its potential.
From the stocks that satisfy either of these conditions, the strategy will then select the top 7 stocks with the highest market capitalization and rebalance the portfolio to hold these 7 stocks, weighted proportionally by their market capitalization. This approach ensures that the portfolio is dynamically adjusted to focus on large-cap stocks that meet specific momentum or value-oriented criteria, while maintaining a disciplined monthly rebalancing schedule.
For clarity, the complete list of stocks from which the selection is made includes: MSFT, AAPL, AMZN, GOOGL, BRK-B, META, JNJ, JPM, V, XOM, WMT, BAC, PFE, UNH, PG, VZ, WFC, INTC, CVX, KO, CSCO, MA, HD, MRK, BA, ORCL, DIS, T, PEP, CMCSA, ABBV, MCD, C, ABT, AMGN, NKE, NFLX, LLY, ADBE, AVGO, CRM, PM, UNP, PYPL, IBM, HON, FGEN, MMM, TXN, MO, COST, TMO, SBUX, NKTR, BMY, UPS, NVDA, NEE, BKNG, AXP, GILD, QCOM, CAT, LMT, USB, LOW, COP, AMT, ELV, MS, CVS, GS, WBA, DHR, CME, BLK, DUK, BIIB, SYK, MDLZ, TSLA, BDX, DD, ADP, ISRG, SCHW, TJX, PNC, TMUS, EPD, CSX, KHC, INTU, SPG, CL, EOG, SLB, BSX.
JSON:
User
Create these backtests:
- 01/01/2018 to 01/01/2019
- 01/01/2018 to 01/01/2020
Aurora
I'll create backtest configurations for your "Monthly Filtered Market Cap Rebalance" strategy across the two specified time periods.
Here's the JSON configuration:
User
What are the top 100 stocks by market cap as of 2019?
Aurora
Here's a detailed summary of the top stocks by market capitalization as of December 31, 2019, based on the provided data:
Top Stocks by Market Capitalization (December 31, 2019)
| Ticker | Market Cap (USD) | Date |
|---|---|---|
| AAPL | $1,327,407,531,450 | 2019-12-31 |
| MSFT | $1,215,867,000,000 | 2019-12-31 |
| GOOGL | $935,160,384,518.37 | 2019-12-31 |
| GOOG | $933,505,653,550.31 | 2019-12-31 |
| AMZN | $931,311,360,000 | 2019-12-31 |
| META | $589,888,500,000 | 2019-12-31 |
| BRK-B | $554,812,152,037.50 | 2019-12-31 |
| BRK-A | $551,819,487,220 | 2019-12-31 |
| JPM | $447,640,443,600 | 2019-12-31 |
| V | $423,338,700,000 | 2019-12-31 |
| JNJ | $389,458,313,000 | 2019-12-31 |
| WMT | $340,001,237,139 | 2019-12-31 |
| PG | $330,672,750,000 | 2019-12-31 |
| BAC | $329,412,660,000 | 2019-12-31 |
| MA | $304,263,214,478.85 | 2019-12-31 |
| XOM | $298,030,380,000 | 2019-12-31 |
| UNH | $283,102,740,000 | 2019-12-31 |
| INTC | $265,315,050,000 | 2019-12-31 |
| DIS | $262,648,080,000 | 2019-12-31 |
| VZ | $254,196,000,000 | 2019-12-31 |
| KO | $239,167,350,000 | 2019-12-31 |
| HD | $238,907,720,000 | 2019-12-31 |
| WFC | $236,160,480,000 | 2019-12-31 |
| CVX | $228,237,263,280 | 2019-12-31 |
| MRK | $223,052,065,256 | 2019-12-31 |
| T | $216,977,394,180 | 2019-12-31 |
| PFE | $209,664,002,058 | 2019-12-31 |
| CMCSA | $207,716,430,000 | 2019-12-31 |
| CSCO | $204,933,080,000 | 2019-12-31 |
| PEP | $192,021,349,999.99 | 2019-12-31 |
| BA | $185,227,136,000 | 2019-12-31 |
| C | $178,721,919,000 | 2019-12-31 |
| QVCGB | $178,502,250,000 | 2019-12-31 |
| ORCL | $177,444,608,678.76 | 2019-12-31 |
| ADBE | $161,950,562,020 | 2019-12-31 |
| NKE | $161,842,725,000 | 2019-12-31 |
| ABT | $154,958,240,000 | 2019-12-31 |
| MCD | $150,954,279,000 | 2019-12-31 |
| NFLX | $146,108,680,640 | 2019-12-31 |
| NVDA | $145,415,400,000 | 2019-12-31 |
| AMGN | $145,124,140,000 | 2019-12-31 |
| CRM | $142,960,560,000 | 2019-12-31 |
| PM | $132,400,040,000 | 2019-12-31 |
| AVGO | $131,464,317,155.82 | 2019-12-31 |
| ABBV | $131,304,820,000.00 | 2019-12-31 |
| TMO | $131,247,480,000 | 2019-12-31 |
| COST | $130,406,425,600 | 2019-12-31 |
| HON | $128,625,900,000 | 2019-12-31 |
| PYPL | $128,505,960,000 | 2019-12-31 |
| UNP | $126,896,501,000 | 2019-12-31 |
| LLY | $126,178,845,780 | 2019-12-31 |
| TXN | $121,875,500,000 | 2019-12-31 |
| NEE | $118,361,972,670.48 | 2019-12-31 |
| IBM | $114,305,306,313.60 | 2019-12-31 |
| LMT | $110,544,982,000 | 2019-12-31 |
| QCOM | $106,846,530,000 | 2019-12-31 |
| SBUX | $105,996,352,000 | 2019-12-31 |
| BMY | $104,886,460,000 | 2019-12-31 |
| AXP | $102,953,230,000 | 2019-12-31 |
| AMT | $102,460,421,469.46 | 2019-12-31 |
| UPS | $101,842,200,000 | 2019-12-31 |
| DHR | $99,216,225,537 | 2019-12-31 |
| CVS | $96,948,450,000.00 | 2019-12-31 |
| USB | $93,559,620,000 | 2019-12-31 |
| FGEN | $93,293,255,750 | 2019-12-31 |
| MO | $93,231,880,000 | 2019-12-31 |
| LOW | $92,215,200,000 | 2019-12-31 |
| BKNG | $87,963,309,630 | 2019-12-31 |
| GS | $86,062,798,080.28 | 2019-12-31 |
| MMM | $85,992,698,220 | 2019-12-31 |
| MS | $83,172,240,000 | 2019-12-31 |
| CAT | $82,878,016,000 | 2019-12-31 |
| GILD | $82,329,660,000 | 2019-12-31 |
| MDLZ | $80,306,640,000 | 2019-12-31 |
| SYK | $79,840,182,000 | 2019-12-31 |
| BLK | $78,961,948,357.60 | 2019-12-31 |
| ELV | $78,527,800,000 | 2019-12-31 |
| TSLA | $77,140,052,922 | 2019-12-31 |
| EL | $76,130,644,000 | 2019-12-31 |
| TJX | $74,755,025,280 | 2019-12-31 |
| ADP | $74,235,700,000 | 2019-12-31 |
| BDX | $72,906,607,916.73 | 2019-12-31 |
| FIS | $72,883,160,000 | 2019-12-31 |
| COP | $72,394,647,500 | 2019-12-31 |
| CME | $71,931,825,680 | 2019-12-31 |
| PNC | $71,035,350,000 | 2019-12-31 |
| ISRG | $70,524,195,000 | 2019-12-31 |
| INTU | $69,149,520,000 | 2019-12-31 |
| FI | $69,019,547,000 | 2019-12-31 |
| TMUS | $67,652,208,693.42 | 2019-12-31 |
| D | $67,332,659,999.99 | 2019-12-31 |
| SO | $67,330,900,000 | 2019-12-31 |
| SPGI | $67,306,825,000 | 2019-12-31 |
| DUK | $66,492,089,999.99 | 2019-12-31 |
| TGT | $66,002,508,000.00 | 2019-12-31 |
| BSX | $63,859,684,000 | 2019-12-31 |
| ZTS | $63,726,525,000 | 2019-12-31 |
| SCHW | $62,208,480,000 | 2019-12-31 |
| EPD | $62,016,768,000 | 2019-12-31 |
| MU | $60,717,620,000 | 2019-12-31 |
Summary of Results
This data presents the top companies by market capitalization as of December 31, 2019. The list is heavily influenced by technology giants, with AAPL and MSFT leading the pack, both having surpassed the trillion-dollar market cap mark. Other prominent tech companies like GOOGL, GOOG, and AMZN also hold top positions. Beyond technology, the list includes major players from diverse sectors such as finance (JPM, V), healthcare (JNJ, UNH), retail (WMT, HD), and energy (XOM, CVX).
Interesting Observations
- Trillion-Dollar Club Expansion: 2019 marked a significant milestone with both AAPL and MSFT firmly establishing themselves in the exclusive trillion-dollar market capitalization club.
- Consistent Tech Dominance: The top positions continue to be dominated by the same technology companies seen in previous years, underscoring their sustained growth and market leadership.
- Growth in Payments: Companies like V (Visa) and MA (Mastercard) show substantial market cap increases, reflecting the rapid expansion of digital payment solutions.
- Tesla's Continued Ascent: TSLA (Tesla) is notably present on the list, continuing its upward trajectory and hinting at the explosive growth it would experience in the subsequent years.
- Diversified Large Caps: While technology leads, the overall list demonstrates a healthy mix of industries, indicating a broad base of strong large-cap companies across the U.S. market at the end of 2019.
- Data Precision: The market capitalization values provided in the final results are highly precise, including decimal places, which is a good indicator of detailed data capture.
Important Note
Please remember to double-check all financial data and observations generated by AI. This data is specifically from December 31, 2019. Market conditions, company performance, and market capitalizations have changed significantly since then. This information should not be used as the sole basis for current investment decisions. Always consult with a qualified financial advisor before making any investment.
User
Create this strategy. Every month, rebalance the 2019 list of 100 stocks weighted by market cap excluding BRK-A and GOOG (because we have BRK-B and GOOGL). Filter to only include
- stocks below the 200 day SMA OR
- we have positions in our portfolio and the positions percent gain is less than 10%
Limit 7. The only condition is every 30 days
Aurora
Description:
This portfolio implements a monthly rebalancing strategy that targets a specific subset of the top 2019 market capitalization stocks. The strategy aims to identify and invest in stocks that are either currently trading below their 200-day Simple Moving Average (SMA), indicating a potential value opportunity or a temporary dip, or existing positions in the portfolio that have not yet achieved a 10% gain, suggesting an opportunity to average down or add to underperforming but potentially strong assets.
The portfolio starts with an initial value of $10,000. Every 30 days, it will re-evaluate the provided list of 2019 top 100 stocks, explicitly excluding BRK-A and GOOG (as their counterparts, BRK-B and GOOGL, are included). From this refined list, the strategy will filter for stocks that meet the condition: Price(asset) < SimpleMovingAverage(asset, 200) OR (PositionValue(asset) > 0 AND PositionPercentChange(asset) < 10). Among the stocks that satisfy this filter, the strategy will then select the top 7 with the highest market capitalization and rebalance the portfolio to hold these 7 stocks, weighted proportionally by their market capitalization. This systematic approach ensures that the portfolio remains focused on large-cap stocks that align with the defined value/momentum criteria, while adhering to a disciplined monthly rebalancing schedule.
The full list of stocks considered for this strategy (excluding BRK-A and GOOG) includes: AAPL, MSFT, GOOGL, AMZN, META, BRK-B, JPM, V, JNJ, WMT, PG, BAC, MA, XOM, UNH, INTC, DIS, VZ, KO, HD, WFC, CVX, MRK, T, PFE, CMCSA, CSCO, PEP, BA, QVCGB, ORCL, ADBE, NKE, ABT, MCD, NFLX, NVDA, AMGN, CRM, PM, AVGO, ABBV, TMO, COST, HON, PYPL, UNP, LLY, TXN, NEE, IBM, LMT, QCOM, SBUX, BMY, AXP, AMT, UPS, DHR, CVS, USB, FGEN, MO, LOW, BKNG, GS, MMM, MS, CAT, GILD, MDLZ, SYK, BLK, ELV, TSLA, EL, TJX, ADP, BDX, FIS, COP, CME, PNC, ISRG, INTU, FI, TMUS, D, SO, SPGI, DUK, TGT, BSX, ZTS, SCHW, EPD, MU, NKTR.
JSON:
User
For this new portfolio, create these backtests:
- 01/01/2019 to 01/01/2020
- 01/01/2019 to 01/01/2021
Aurora
I'll create backtest configurations for your "Monthly Filtered Market Cap Rebalance 2019" strategy across the two specified time periods.