SpaceX IPO Is Here — How to Track SPCX in Google Sheets Alongside Your Full Portfolio

SPCX by the Numbers: The Largest IPO in History

More than $250 billion in orders poured in before pricing, making this the most oversubscribed IPO on record. Retail investors gained access through all major brokerages — Fidelity, Schwab, Robinhood, Vanguard, and E*TRADE — with some platforms reporting over $5 billion in retail orders before the opening bell.

You Bought SPCX. Now What?

If you participated in the SpaceX IPO or bought shares on the open market today, you now have at least one new position to track. The challenge: SPCX is just one entry in a portfolio that might also include AAPL, NVDA, index funds, bonds, and crypto across three different brokerage apps.

A stock like SPCX — with its 19% first-day pop and multi-trillion-dollar swings — demands attention. But checking it in isolation, logging into one brokerage app, gives you an incomplete picture. What matters is how SPCX fits into your total portfolio allocation.

Here is what automated tracking looks like for a SpaceX investor:

Why Spreadsheet Tracking Wins for IPO Positions

IPO stocks are uniquely volatile in their first weeks. SPCX swung intraday and many retail investors may have bought at different price points. Tracking cost basis accurately is critical — especially for tax-loss harvesting later.

With InvestSheet, your SPCX cost basis comes directly from your brokerage. The formula =IVS_BROKERAGE("gainLoss", "SPCX") automatically calculates your P&L using actual purchase prices — no manual entry, no spreadsheet errors.

More importantly, you can see SPCX in the context of your full portfolio. Did your new SpaceX position push your tech allocation above your target? Are you now overexposed to a single sector? These questions are impossible to answer when you check accounts one at a time.

Tracking SPCX Across Multiple Brokerages

Many investors bought SPCX through multiple brokerages — some shares at Fidelity, some at Robinhood, some at Schwab. InvestSheet aggregates them automatically:

Want to see SPCX in your Fidelity Roth IRA specifically? Add the account nickname: =IVS_BROKERAGE("value", "SPCX", "Fidelity", "Roth IRA")

SpaceX Is a Portfolio Event, Not a Stock Picker

The SpaceX IPO is a milestone for individual investors — the first opportunity to own a piece of the company that revolutionized spaceflight and built Starlink, the world's largest satellite internet network. But the real question isn't whether SPCX goes up or down tomorrow. It's whether your overall portfolio is positioned correctly for the long term.

When you track your portfolio in a single Google Sheet — with automated data from every brokerage and custom formulas for instant calculation — you stop obsessing over individual tickers and start seeing the whole board. SPCX is just one piece. Make sure you can see all of them.

Frequently Asked Questions