A tracker built from your actual holdings
A portfolio spreadsheet needs more than a list of ticker symbols. It needs the accounts, quantities, and currencies behind those symbols. Brokerage Connect imports available account data through SnapTrade into ordinary Google Sheets tables, so you can build a dashboard without retyping positions.
Start with Accounts, Positions, and Balances. Select one account or combine available accounts from multiple connected brokerages. Keep the default tab names if you want to use the formulas below unchanged.
1. Import your source tables
ST_Accounts provides account names, institutions, and available reported totals. ST_Positions holds instruments and quantities. ST_Balances separates cash and buying power by currency. Preview each table before importing.
2. Create an analysis tab
Add a new tab called My portfolio. Put formulas and charts here, leaving the imported tabs for source data. A refresh replaces managed source ranges, so those ranges are not a good place for custom notes or formulas.
Show USD holdings without cash equivalents
=FILTER(ST_Positions!A2:X, ST_Positions!G2:G="USD", ST_Positions!N2:N<>TRUE)Keeps different instrument kinds visible. Do not infer option values with an assumed multiplier. A FILTER with no matching rows returns #N/A; check your imported currency values or wrap it in IFNA for an empty display.
List USD cash by account
=QUERY(ST_Balances!A1:J, "select B,D,E where D = 'USD'", 1)Returns account name, currency, and cash. Buying power is a separate column. Change USD to the currency you want to inspect.
3. Build a view across brokerages
Create a pivot table from your imported positions. Use institution and account_name as grouping fields, then inspect symbol, instrument_kind, currency, and units. This makes it easier to see which account holds each position before choosing how to summarize it.
Keep currency totals separate. Check cash_equivalent before combining positions and cash, and retain returned option multipliers when working with contracts. A simple units × price formula is not a universal valuation formula for every instrument.
4. Refresh your tables, keep your dashboard
Use Refresh selected or Refresh all configured imports in the sidebar. Your analysis reads the updated source tables. Check source timestamps: a new imported_at value only tells you when the import began, not when the brokerage last synced.
What this tracker does and does not calculate
You get source tables for your own analysis. The add-on does not automatically calculate investment returns, convert currencies, reconstruct tax lots, or provide live market prices. Optional balance history is experimental and depends on provider availability.