Agent skill

Portfolio Syncing

by AojdevStudio in AojdevStudio/Finance-Guru

Refresh positions and balances from SnapTrade into familyoffice.db, then validate the snapshot.

Custom licenceAuto-check: notesDocuments & Office

Install Portfolio Syncing

skills CLI
$ npx skills add AojdevStudio/Finance-Guru --skill portfolio-syncing -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install AojdevStudio/Finance-Guru portfolio-syncing --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/AojdevStudio/Finance-Guru.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/PortfolioSyncing .claude/skills/portfolio-syncing && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
portfolio-syncing
GitHub stars
322
Token cost
~1.5k tokens
SKILL.md length
673 words
Files
2
Skills in repo
18
Repo updated
First seen
Licence
Custom licence

At a glance

Refresh positions and balances from SnapTrade into familyoffice.db, then validate the snapshot.

  • Works in 5 steps: Fewer tickers than the previous snapshot… → Any quantity change > 10% → Any cost basis change > 20% → …
  • User mentions sync portfolio OR update positions OR portfolio-sync OR refresh positions OR downloaded from Fidelity
  • SKILL.md covers Step 0: Refresh (sync-first,…, Account Routing, Safety Gates and Cash Position Logic, plus 5 more sections
  • Calls uv and sqlite3

What it does

Portfolio Syncing is an agent skill from AojdevStudio/Finance-Guru. Refresh positions and balances from SnapTrade into familyoffice.db, then validate the snapshot. Reads live positions, cost basis, SPAXX, and margin from the DB (never a stale CSV). USE WHEN user mentions sync portfolio OR update positions OR portfolio-sync OR refresh positions OR downloaded from Fidelity.

Its SKILL.md is about 1.5k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `workflows/IngestPositions.md`).

It sits in Documents & Office, covering CSV and tabular files. The repository describes itself as: Self-hosted family office engine: typed Python calculators, a private SQLite ledger, and specialist agents for Claude Code and Codex. Agents propose. Typed code computes.

When your agent uses it

  • User mentions sync portfolio OR update positions OR portfolio-sync OR refresh positions OR downloaded from Fidelity
  • Tasks that involve CSV and tabular files

Example prompts

  • “/portfolio-syncing”

Requirements

  • Python 3

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Fewer tickers than the previous snapshot (possible sales)
  2. Any quantity change > 10%
  3. Any cost basis change > 20%
  4. Margin balance jumped > $5,000 (unintentional draw)
  5. SPAXX discrepancy > $100 against the balances row

What it can do on your machine

Read from SKILL.md and the folder at commit 90c235e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • uv
    • sqlite3

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use uv, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Portfolio Syncing loads about 1.5k tokens when it runs. Until then it costs about 81 tokens; SKILL.md has 673 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~81
When it runs · the whole SKILL.md, loaded when a task matches
~1.5k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:115
    - [ ] `SNAPTRADE_*` keys are present in `.env`
  • NoteMentions a .env fileSKILL.md:116
    - [ ] `DATABASE_URL` is set in `.env`

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 673 words (~1,511 tokens).

“Refresh positions and balances from SnapTrade into family_office.db, then validate the snapshot against safety thresholds before anyone reasons off it.”

— opening of SKILL.md by AojdevStudio, Custom licence
name
portfolio-syncing

Read the full SKILL.md on GitHub

Files

SKILL.md and 1 other file in .claude/skills/PortfolioSyncing of AojdevStudio/Finance-Guru.

  • SKILL.md
  • workflows/IngestPositions.md

Open the folder on GitHubat commit 90c235e

Compare with similar skills

Portfolio Syncing next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Portfolio Syncing compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Portfolio Syncing this skillAojdevStudio/Finance-Guru322—~1.5kAutomated safety check: NotesCustom licence
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences2742 repos~2.7kAutomated safety check: PassApache-2.0
Sector Analysttradermonty/claude-trading-skills3k1 repos~2.3kAutomated safety check: PassMIT
Cliare Artifact Reviewmodiqo/cliare469—~2.4kAutomated safety check: PassApache-2.0
Convert Fileduckdb/duckdb-skills5991 repos~720Automated safety check: NotesMIT
Research Integrity Auditxuzhougeng/wisp-science1k—~2.6kAutomated safety check: PassAGPL-3.0

Similar skills

  • Instrument Data To Allotrope

    aws-samples/amazon-bedrock-agents-healthcare-lifesciences

    Official

    Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.

    274 GitHub starsUsed in 2 repos~2.7k tokens
    Documents & OfficeAuto-check passed
  • Sector Analyst

    tradermonty/claude-trading-skills

    This skill should be used when analyzing sector rotation patterns and market cycle positioning.

    3k GitHub starsUsed in 1 repo~2.3k tokens
    Documents & OfficeAuto-check passed
  • A skill your agent uses when reviewing a CLIARE measurement artifact directory, explaining score changes, triaging issues, finding evidence, or proposing CLI remediation work from artifact-map.json…

    469 GitHub stars~2.4k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Convert File

    duckdb/duckdb-skills

    Official

    Convert any data file to another format: CSV, Parquet, JSON, Excel, GeoJSON, and more.

    599 GitHub starsUsed in 1 repo~720 tokens
    Documents & OfficeAuto-check: notes
  • Research Integrity Audit

    xuzhougeng/wisp-science

    学术审查 / research-integrity screening of a manuscript's figures and reported numbers.

    1k GitHub stars~2.6k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Best Skills

    LinklyAI/best-skills

    Daily cross-platform rankings of AI agent skills (skills.sh, ClawHub, Tencent SkillHub, GitHub, X/HN/Bluesky).

    630 GitHub stars~575 tokensUpdated yesterday
    Documents & OfficeAuto-check passed

More from AojdevStudio/Finance-Guru

All 18 skills in this repo
  • Compliance Scan

    AojdevStudio/Finance-Guru

    Privacy and security compliance scanner for the Finance Guru repo.

    322 GitHub stars~2.6k tokensUpdated yesterday
    Auto-check: notes
  • Dividend Tracking

    AojdevStudio/Finance-Guru

    Refresh the local DB, then read and analyze DIVIDEND rows from familyoffice.db for Layer 2 income tracking.

    322 GitHub stars~1.2k tokensUpdated yesterday
    Auto-check passed
  • Fin Guru Compliance Review

    AojdevStudio/Finance-Guru

    Compliance review of a Finance Guru deliverable or a proposed position.

    322 GitHub stars~801 tokensUpdated yesterday
    Auto-check passed
  • Fin Guru Output Contract

    AojdevStudio/Finance-Guru

    The six-part shape of every Finance Guru analysis answer: bottom line, a numbers table that names the source command, assumptions and gaps, confidence, evidence, and the disclaimer.

    322 GitHub stars~529 tokensUpdated yesterday
    Auto-check passed
  • Fin Guru Quant Analysis

    AojdevStudio/Finance-Guru

    Quantitative analysis of tickers or the portfolio through the engine's calculators.

    322 GitHub stars~838 tokensUpdated yesterday
    Auto-check passed
  • Fin Guru Strategize

    AojdevStudio/Finance-Guru

    Turn research and quantitative results into a portfolio strategy with allocation changes, entry timing, position sizing, margin and dividend tactics, and an implementation plan with triggers.

    322 GitHub stars~825 tokensUpdated yesterday
    Auto-check passed

Questions about Portfolio Syncing

What does Portfolio Syncing do?

Refresh positions and balances from SnapTrade into familyoffice.db, then validate the snapshot. Portfolio Syncing is an agent skill from AojdevStudio/Finance-Guru.db, then validate the snapshot.

When should I use Portfolio Syncing?

Portfolio Syncing fits situations like: user mentions sync portfolio OR update positions OR portfolio-sync OR refresh positions OR downloaded from Fidelity; tasks that involve CSV and tabular files.

How do I install Portfolio Syncing in Claude Code?

Run `npx skills add AojdevStudio/Finance-Guru --skill portfolio-syncing -a claude-code`. Or copy the skill folder (.claude/skills/PortfolioSyncing in AojdevStudio/Finance-Guru) into .claude/skills/portfolio-syncing in your project. Claude Code loads it when a task matches its description.

How do I install Portfolio Syncing in Codex?

Run `npx skills add AojdevStudio/Finance-Guru --skill portfolio-syncing -a codex`. Or copy the skill folder (.claude/skills/PortfolioSyncing in AojdevStudio/Finance-Guru) into .agents/skills/portfolio-syncing in your project. Codex loads it when a task matches its description.

Can I use Portfolio Syncing in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add AojdevStudio/Finance-Guru --skill portfolio-syncing -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/portfolio-syncing, .gemini/skills/portfolio-syncing, .github/skills/portfolio-syncing and .opencode/skills/portfolio-syncing in your project.

What does Portfolio Syncing need to run?

Going by SKILL.md and its folder, Portfolio Syncing needs the command-line tools its instructions call (uv and sqlite3). Our summary lists: Python 3.

Does Portfolio Syncing access the network?

SKILL.md contains no URLs. Its commands use uv, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Portfolio Syncing safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Portfolio Syncing use?

Portfolio Syncing has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Portfolio Syncing use?

About 1.5k tokens (SKILL.md is roughly 6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Portfolio Syncing?

Skills that share tags, products or a category with Portfolio Syncing: Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars), Sector Analyst (tradermonty/claude-trading-skills, 3k stars), Cliare Artifact Review (modiqo/cliare, 469 stars) and Convert File (duckdb/duckdb-skills, 599 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Portfolio Syncing?

AojdevStudio (a GitHub user) maintains it in AojdevStudio/Finance-Guru, which has 322 GitHub stars. The repository holds 18 skills in this directory. The repository was last updated on October 6, 2026.

Source: AojdevStudio/Finance-Guru on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.