Querying 13F Data via MCP: Three Traps in 'Who Bought and Sold SpaceX'
EquiblesAI · reddit · 2026-11-20
The author of Equibles, a financial-data MCP server, used it for a Q3 13F roundup and walked through three traps that decide whether an answer to 'who bought and sold SpaceX in Q3?' is right:
- A missing filing is not a sale. Some funds hadn't filed for Sept 30, some filed for the first time, and Norges Bank withheld positions under confidential treatment. Naive quarter-over-quarter comparison reads each as a full exit or new buy. The buyers-and-sellers tool ranks only filers present in both quarters and lists who it left out: 80 SpaceX holders, the largest with about 11.6 million shares.
- A value change is not trading. FMR's SpaceX position fell $14.2B in published value but it cut 54.3 million shares, about $8.2B at the Sept 30 close of $150.86; the rest is price (June 30 close: $170.86). Rank by share change.
- Raw exit lists catch events nobody chose. Electronic Arts showed 990 exits, the most of any stock, because it was taken private on Aug 4; Paramount Skydance showed 430 exit-plus-new-position pairs from a ticker change. The author set these aside by hand using the underlying 8-Ks before ranking.
Prompts that worked: 'top buyers and sellers of SPCX for the quarter ended 2026-09-30, by share change', then 'which holders did you leave out, and why' — the second is the one people skip. He asks how others treat confidential-treatment filers: drop them or carry the last quarter forward?
More from coding & agent
- Agent memory needs business ontologies, not smarter LLMs, argues founder — _AustinCalvert_ · 2026-11-21
- MCP Events extension finalized in beta, ready for client and server adoption — dsp_ · 2026-11-21
- Using Notion as an AI context layer with an external Claude skills-db — ivanhzhao · 2026-11-21
- Gaussian splats in Godot: full tutorial plus using Fable agent to plan a pixel apartment layout — XRarchitect · 2026-11-21
- Skip agent memory: a folder structure and index beats it — NewsLewis · 2026-11-21
- DevFest Pakistan 2026: deconstructing Gemini Deep Research with Antigravity 2.0 and Gemini 4 Neon — gerardsans · 2026-11-21