Friday allocation drift memos for every Addepar household
Every Friday at 3pm, catch households drifting from their target allocation, draft a Google Docs rebalancing memo for each, and post one Slack summary to your PM channel.
Addepar
Google Docs
SlackFinanceOperationsAI ReportsNotifications & AlertsEvery Friday at 3pm, run an allocation drift review across every household in Addepar and hand each portfolio manager a written rebalancing memo before they log off for the weekend.
Enumerate every household in Addepar with List Entities. For each household, pull current asset-class weights: prefer Get Portfolio View Results against a saved Addepar Analysis view that returns asset-class weights (the view id or name should be a configurable input), and fall back to Query Portfolio Data if no saved view is configured. Read each household's target allocation attribute from Addepar so you have both sides of the comparison.
Compare current weights to target weights per asset class. Flag any household where an asset class has drifted past the configurable threshold (default 3 percent, and allow per-sleeve overrides so tight-band assets like cash can trip earlier than long-horizon buckets like alternatives). For each drifted sleeve, compute the approximate dollar move needed to bring it back to target using the household's current market value.
For each drifted household, create a short memo with Google Docs Create Document, then populate it with Batch Update Document. The memo should list the household name, a two-line summary at the top, each over- or underweight sleeve with current versus target weight, the approximate dollar move needed to rebalance, and a plain-language recommendation the portfolio manager can act on Monday morning.
Post one summary to the portfolio management Slack channel with Send a Message. Include one bullet per drifted household with the household name, the largest drift, and a link to its memo. End the message with a count of households already in-line and call out any households missing a target allocation attribute so the team can backfill them.
Inputs the caller can configure: the drift threshold (default 3 percent), optional per-asset-class thresholds, the Addepar Analysis view id to use (leave blank to run a dynamic query), the Google Drive folder where memos should live, and the Slack channel for the summary.
Additional information
What does this prompt do?
- Pulls every household from Addepar and reads their current asset-class mix against each household's target allocation.
- Flags any household where a sleeve has drifted past your threshold (3% by default), and estimates the dollar move needed to bring it back.
- Writes a short Google Docs memo per drifted household with what's over or under, the approximate rebalance amount, and a plain-language recommendation.
- Posts one Slack summary to your portfolio management channel with a bullet per drifted household, links to the memos, and a count of households already in-line.
What do I need to use this?
- An Addepar login with access to entities and portfolio analysis.
- A target allocation attribute set on each household in Addepar (or a saved Addepar Analysis view that returns current asset-class weights).
- A Google account for creating and editing the memos.
- A Slack workspace and a channel where the Friday summary should land.
How can I customize it?
- Adjust the drift threshold from the 3% default, or set per-sleeve thresholds (e.g. 2% for cash, 5% for alternatives).
- Change the run time or day to match when your team wraps up before the weekend.
- Point the memos at a specific Google Drive folder and swap in whichever Slack channel your portfolio managers watch.
Frequently asked questions
Does this send trades or move money?
What if a household doesn't have a target allocation set in Addepar?
Can we use our own saved allocation view?
Does the 3% threshold apply to every asset class equally?
Where do the memos get saved?
Related templates
Hand your portfolio managers a rebalance plan before they log off Friday.
Let the workflow surface which households drifted this week, write the memos, and drop a single Slack summary in the PM channel.