Wrote this in Tesla thread - I'll put here instead and remove spoiler tags
Cross link to SpaceX investors - SpaceX investor's thread
Google Sheets headings (comma separated)
Ticker,Exchange,Manual name,Name lookup,%SpaceX,Currency,income dividend,expense ratio,Fee (manual),,UK Invest,Cost/share,Link
Some Formulas
= GOOGLEFINANCE($A3,"name")
= GOOGLEFINANCE($A3,"currency")
= GOOGLEFINANCE($A3,"incomedividend")
= GOOGLEFINANCE($A3,"expenseratio")
Sorry if regarded as off-topic, but The Boring Company has been mentioned a lot and I think it is a key enabler of Tesla and EVs in general. [Now You Know videos show build a tunnel, sell more Teslas]
I'm trying to get a list of securities as proxy for SpaceX that I (UK) and others (USA, EU, RoW) can buy
I've got a list below, but percentages of fund in SpaceX for only a few. It's in a google spreadsheet that I cannot share, but I can post formulas when complete.
I'm hoping someone has already done this or similar work. I want to buy SpaceX - with as high a % of fund as possible in the UK. Any help appreciated.
Funds in spoiler to save space.
Ticker Exchange Manual name Name lookup %SpaceX
_ Space Exploration Technologies Corp _Space Exploration Technologies Corp
BATS: PRNT ARK ETF TR/3D PRTG ETF
NYSEARCA:ARKF ARK ETF TR/FINTECH INNOVATION ETF
BATS:ARKG ARK ETF TR/GENOMIC REVOLUTION
BATS:ARKG ARK ETF TR/GENOMIC REVOLUTION
BATS:ARKQ ARK ETF TR/INDL INNOVATION ETF
BATS:ARKQ ARK ETF TR/INDL INNOVATION ETF
NYSEARCA:ARKK ARK ETF TR/INNOVATION ETF
NYSEARCA:ARKK ARK ETF TR/INNOVATION ETF
BATS:IZRL ARK ETF TR/ISRAEL INNOVATIVE T
NYSEARCA:ARKW ARK ETF TR/WEB X.0 ETF
NYSEARCA:ARKW ARK ETF TR/WEB X.0 ETF
LON:USA Baillie Gifford US Growth Baillie Gifford US Growth Trust PLC
MUTF:BFTUX Baron Fifth Avenue Growth Fund Class R6
MUTF:BFTHX Baron Fifth Avenue Growth Fund Retail Class
MUTF:BFGIX Baron Focused Growth Fund Institutional Shares 3.90%
MUTF:BFGUX Baron Focused Growth Fund R6 Shares
MUTF:BFGFX Baron Focused Growth Fund Retail Shares
MUTF:BPTIX Baron Partners Fund Institutional Shares 4.00%
MUTF:BPTRX Baron Partners Fund Retail Shares 4%
LON:EWI Edinburgh Worldwide (EWI) Edinburgh Worldwide Investment Trust plc
MUTF:FBGRX Fidelity® Blue Chip Growth Fund
MUTF:FCNTX Fidelity® Contrafund® Fund
MUTF:FOCPX Fidelity® OTC Portfolio
LON:SMT Scottish Mortgage (SMT) Scottish Mortgage Investment Trust PLC