The tradeGIST panel
The tradeGIST panel is the side panel of your Google Sheets™ portfolio tracker; it shows one asset at a time: what it has made, the lots you hold, the options on it, and the stops and targets in force. Open it from the tradeGIST menu (Open panel) and it opens on the asset of the row you have selected — on the Transactions sheet the row's ticker, on the Open positions summary and Closed positions summary sheets the row's ticker, and on the Configuration sheet the asset of a row in the Asset Configuration section. To move to another row's asset, select the row and press Refresh. A row without a ticker, or a sheet it does not read, leaves the current asset on screen.
Choosing the asset
- The picker at the top lists every asset you have traded, open positions first, so you can look at one that is not on screen.
- Refresh reads the row you have selected and shows its asset; when that row is the one already shown, or has no ticker, it reads the asset on screen again.
- Pin keeps the asset on screen: Refresh then reads it again whatever row you have selected.
- A stock or crypto asset shows its own trades and, separately, the option contracts on it. A contract shows on its own, with a link to its underlying.
- Figures are in your base currency. Switch to the asset's own currency from the settings menu (the gear icon).
Overview
The asset's facts (type, currency, last price), then Unrealized P&L and Realized P&L with their return, the Position and the number of Trades, and the Open risk of its open lots with the value no stop protects.
Accounts lists what each of your accounts holds of the asset, from two accounts on: the quantity, its average cost including fees, and its P&L against the last price. It is an average-cost view, so it does not add up to the lot-based unrealized figure above it.
Options rolls up the open contracts on the asset — long and short, what they have made — and lists each contract with its days to expiry, whether it is in the money and the accounts holding it. Click one to open it.
Open lots and closed trades
Open lots, newest first (the arrows switch the order), each with its quantity, entry and account, the stop and target in force and, under them, the plan you entered on the transaction when an order moved it, plus its target progress, R-multiple and risk. Closed trades fold beneath: what was bought and sold at, how long it ran, what it made and its R, with a wash-sale tag when one applies.
Stops & targets PRO
Where you set, move and remove the stops and targets in force — on one lot or over part of a position — pair a stop and a target as a bracket, and read how much of the position they cover, the open risk, what every stop would lock in and the value left unprotected. How the levels work, what the figures mean and how orders follow your trades is in Risk Management → Stops and targets in force. Below Pro the view shows the initial levels read-only; it needs template 2.0.0 or later.
Good to know
- The figures come from your transactions as of the last Generate Trades, valued at the prices on your Configuration sheet (Update prices). When you have edited transactions since, the panel says so: run Generate Trades to bring it up to date.
- The panel never writes to the Transactions sheet. The stop and target you entered on a transaction stay your plan at entry; the levels you set from the panel are kept on their own sheets.