Skip to content

Accounts & holdings

Track brokerage accounts, their holdings, and a transaction ledger. What each stores, how positions relate to accounts, and the private-by-owner access model.

The Accounts page lets you record brokerage accounts and the positions inside them, for portfolio tracking. This is bookkeeping, not live trading — TradePilot places no real orders.

Accounts

An account is a container you own:

  • name — your label.
  • broker — optional broker name.
  • currency — defaults to USD.
  • type — defaults to brokerage.

Accounts are strictly private: only the owner can read or modify them.

Holdings

Each holding is a position that belongs to one account:

  • symbol · qty (quantity held) · cost_basis (optional).

Holdings authorize through their account — you can see a holding only if you own the account it belongs to. Deleting an account cascades to its holdings.

Transactions

The transaction ledger records activity against an account:

  • symbol · qty · price · executed_at
  • side — one of buy, sell, dividend, deposit, withdrawal.

Like holdings, transactions are authorized through the owning account.

The orders table

The data model also includes an orders table, but it is schema-only — reserved for future live-trading and not wired to any broker in the current app. See the data model.