Trading Risk Management: Stop Loss, Targets and R-Multiples
A trade is a plan before it is a result. tradeGIST lets you record that plan in your Google Sheets™ portfolio — where you would cut the loss and where you would take the profit — on the transaction that opens a position. The Trades sheet then measures every lot against it: how far the price has travelled toward your target, how many times your initial risk you made or lost, what an open position still has to give back, and the reward you planned per unit of risk. When the plan changes, you move the stops and targets in force from the tradeGIST panel, without touching the transaction.
tradeGIST does not place orders with your broker and does not send alerts. The stops and targets you record here are your plan: place them with your broker yourself, and when you move or cancel one there, do the same here. Open risk and Portfolio at risk are only as accurate as that record.
Entering your stop loss and exit target
Fill Stop loss and Exit target on the Transactions sheet, on the transaction that opens the position. Both are optional: a stop alone gives you R-multiple and Open risk, a target alone gives you Target progress, and both together give you Planned R:R.
- Which row. The one that opens the position. On a row that only closes a position the levels are ignored. On an exercise or assignment row they are the plan for the shares delivered. A sale larger than what you hold closes the shares and opens a short, and its levels are the short's.
- Which side. The stop sits on the losing side of the price and the target on the winning side: below and above for a buy, above and below for a short sale or a written option. A level on the wrong side, or equal to the price, is rejected when you generate trades.
- Which unit. The asset's price. For options, the premium, like the price you enter on the row.
Stock splits scale the levels like the price, so they stay comparable with the opening price.
Reading the risk columns on the Trades sheet
| Column | What it shows |
|---|---|
| Stop loss | The stop from the opening transaction. |
| Exit target | The target from the opening transaction. |
| Target progress | How far the price has travelled from the entry toward the target in force: 0% at the entry, 100% at the target, above 100% past it, negative when the price moves the other way. |
| R-multiple | Net P&L in the asset's currency, fees included, per unit of initial risk. The initial risk is the distance from the entry to the stop times the volume. 2R means you made twice what you were risking. |
| Open risk | What an open position gives back if every stop in force is hit now: the drop to each stop times the units it covers, in your base currency at today's exchange rate. Blank on closed trades. |
| Planned R:R | The reward-to-risk ratio of the plan at entry: the distance to the target divided by the distance to the stop. |
Open positions use the live price, closed trades the exit price.
A worked R-multiple example
You buy 10 shares at 100 with a stop at 90 and a target at 130. Your initial risk is 10 per share, 100 in total, and the plan promises 30 per share, so Planned R:R reads 3. With no fees, the columns read as follows while the position is open:
| Price | Target progress | R-multiple | Open risk |
|---|---|---|---|
| 95 | −17% | −0.5R | 50 |
| 115 | 50% | 1.5R | 250 |
| 130 | 100% | 3R | 400 |
| 85 | −50% | −1.5R | 0 |
The last row is the one to read carefully: at 85 the price is through the stop, and Open risk reads 0 because there is nothing left to lose to the stop. An open position past its stop means the stop did not fire, so a 0 there says "check the position", not "no risk". The position does not drop out of your risk figures: its units count as Unprotected, at their value at the current price (850 here), until you record the sale. See When the price is past a stop.
Portfolio at risk
The Dashboard adds it up for the whole portfolio: Portfolio at risk is what your open positions give back if every stop in force is hit now, plus the value of the units no stop covers, as a percentage of your portfolio's total value. Traders call it portfolio heat. A position without a stop counts in full, at its value at the current price, and so does one whose stop the price has crossed with no sale recorded. The figure therefore also tells you how much of your portfolio has no exit plan.
The total it is measured against is the one in the Dashboard's header: your open positions at market value plus your cash. Two readings follow from that:
- Above 100%. The figure passes 100% when the positions counted are worth more than the portfolio's total: you trade on margin, or the cash that paid for them is not recorded, so the cash balance is negative. Record your deposits to keep the total right.
- Blank. When the portfolio's total is zero or negative, there is nothing to measure against and the cell stays empty.
When the price is past a stop
When the price crosses a stop and you have not recorded a sale, tradeGIST cannot tell whether your broker filled the stop or not: a mental stop you did not act on, a stop-limit the price left behind and a level you never placed all look the same. It takes the cautious reading, that the stop did not sell. The units leave Stop coverage and Locked-in P&L and count as Unprotected at the current price, so the position stays in Portfolio at risk; Stop breached flags it and the panel warns under the lot. The stop itself stays in force.
If the stop did fill, record the sale. Until you do, the position reads as unprotected; once the sale is in and you run Generate Trades, the figures settle.
Stops and targets in force PRO
The levels on the transaction are your plan at entry, and they stay that way: R-multiple and Planned R:R always measure against them. As the trade develops you move the stops and targets in force from the Stops & targets view of the tradeGIST panel, without editing the Transactions sheet. The Trades sheet, the panel and Open risk follow the levels in force. Managing them needs a Pro license and template 2.0.0 or later; below Pro the view shows the initial levels read-only.
How they work, in short:
- One lot, or part of a position. An order moves the stop or target of a single lot, or covers a number of units of an asset across its lots, in one account or in all. The two combine: a position order covers first the units that have no level of their own.
- The same lots as your cost basis. Orders sit on the lots Generate Trades matches, so they follow your Matching method (FIFO or LIFO) and the way your accounts are matched, pooled together or kept separate.
- Set once. Every Generate Trades keeps your orders in step with your trades: your sales, your stock splits and your corrections. You do not enter them again.
Moving a lot's stop or target
Click a lot's stop or target in the panel (Set when it has none), type the new level and save. The level applies to the whole open remainder of the lot. Use initial puts the transaction's level back; the trash icon removes the level, so the lot has no stop (or no target) until you set one. A stop above your entry is fine: it locks in a gain. A level the price has already crossed is accepted with a warning, since your broker may already have filled it.
Position orders
A position order covers part of an asset rather than one lot. Add one with its kind (stop or target), the account when the order is for one account only, the price, and the quantity, typed in units or as a percentage of the open units, with a note if you like. For options the level is a premium and the quantity a number of contracts. Several position orders on one asset make a ladder. The quantity is fixed in units, so units you buy later are not covered until you raise it or add another order. An order for one account needs that account to be matched on its own (Isolated, or alone in its tax group): when accounts share a matching queue, the lots cannot tell in which account the shares sit, and the panel names the accounts that share.
Brackets
A lot's stop and target are one plan: when a sale fills one, the other ends with it. Two position orders become one the same way: choose Pair with when you add or edit a stop or target, and the order of the other kind on the same account becomes its pair. A bracket's two orders cover the same units, so resizing one resizes the other; cancelling one leaves the other in force. The panel shows a bracket as one row.
How coverage adds up
A position order covers first the units that have no stop (or target) of their own, and only its excess replaces the lots' own levels, pro rata. Adding an order never lowers your coverage. When position orders add up to more than the position — after a sale, say — they are scaled down together and the panel warns; nothing is cancelled for you.
Reading the figures
The panel sums the open lots: Coverage, the percentage of the units under a stop the price has not crossed; Open risk; If stopped, what the lots keep or lose if every stop in force is hit now; and Unprotected, the value of the units no stop covers or whose stop the price has crossed. The Trades sheet carries the same figures per lot:
| Column | What it shows |
|---|---|
| Active stop | The stop in force for the lot. When several stops cover parts of it, the quantity-weighted level. Blank when nothing applies. |
| Stop coverage | The percentage of the lot under a stop the price has not crossed. |
| Locked-in P&L (base curr.) | What the lot keeps if every stop the price has not crossed is hit: the distance from the entry to the stop times the units it covers, in your base currency. Negative when hitting the stop loses money, positive when it locks in a gain. |
| Active target | The target in force for the lot, the same way. |
| Stop breached | The percentage of the lot whose stop the price has crossed with no sale recorded. Those units no longer count as covered: they move to Unprotected until you record the sale, or move or cancel the stop. |
| Unprotected (base curr.) | The value of the lot's units with no stop, or whose stop the price has crossed, at the current price — what Open risk leaves out of your exposure. |
Target progress measures toward the target in force; R-multiple and Planned R:R keep the plan at entry.
Kept in step with your trades
Every Generate Trades brings your orders in line with your trades. An order ends as filled when the sales you record after setting it cross its level for about its quantity, on the day of the sale that completed it, and the other order of its bracket ends with it. An order closes when its lot is sold out, when its position is flat or was sold out and bought again after the order was set, or when its contract expires; it comes back if the position does; it is carried over the stock splits you add to the Configuration sheet; and a lot's stop follows the lot when you correct the price or volume of the buy that opened it, or waits under Detached orders for you to cancel it when it cannot. The panel warns under an order of what the next generation will do to it, and of a stop the price has crossed. Cancel what no longer applies.
When you close a position and open it again on the same day, enter the time on those transactions. Without it, an order set that day cannot tell the position it was set on from the one that followed, and may stay in force on the new one.
The order history
Every change writes a new version of the order, and the earlier ones are kept: History under an order shows its versions, and Ended orders at the bottom of the view lists the orders that were replaced, cancelled, closed or filled, each with how and when it ended. The versions live on two hidden sheets managed by the add-on, PositionOrders (the orders in force) and PositionOrdersHistory (the ended versions, moved there at each Generate Trades). Don't edit them by hand.
Good to know
- Blank cells. R-multiple needs the initial stop, Open risk a stop in force, Target progress a target, Planned R:R both. When a position opens and closes in different currencies, only Planned R:R stays, since its three inputs share the opening currency.
- Partial exits. Each closed slice is measured on its own volume, so two sales from one lot read two R-multiples. The trade's overall R is the sum of the net P&L divided by the sum of the initial risk, not the average of the rows.
- Fees. R-multiple is net of fees, so a trade closed exactly at its stop reads slightly below −1R.
- Short sales and written options. The same columns apply; the sign of the volume takes care of the direction.
- Options. Levels and prices are per contract, like the premium you enter. An option closed by exercise or assignment reads an R-multiple of 0: it closes at its own opening price, with the premium rolled into the shares. An expired option reads from a closing price of 0.