agentskills.codes
FO

formula-protection

by AojdevStudioData & AnalyticsSource

Prevents accidental modification of financial formulas in your Google Sheets tracker.

Data AnalysisFinance

Install

mkdir -p .claude/skills/formula-protection && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/5148" && unzip -o skill.zip -d .claude/skills/formula-protection && rm skill.zip

Installs to .claude/skills/formula-protection

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

Prevent accidental modification of sacred spreadsheet formulas in Google Sheets Portfolio Tracker. Blocks edits to GOOGLEFINANCE formulas, calculated columns, and total rows. Allows only IFERROR wrappers, fixing broken references, and expanding ranges. Triggers on update formula, modify column, fix errors, or any attempt to edit formula-based cells.
351 charsno explicit “when” triggerlonger than Claude Code's old 250-char listing cap (fine on current versions)
Advanced

Key capabilities

  • →Block unauthorized edits to protected formulas
  • →Validate column edits in Google Sheets
  • →Permit safe operations like IFERROR wrapping
  • →Expand formula ranges for new data

How it works

The skill acts as a guardrail by intercepting edit requests and validating them against a list of protected 'sacred' formulas.

Inputs & outputs

You give it
Attempt to modify a protected formula cell
You get back
Blocked edit or validated safe formula update

When to use formula-protection

  • →Fix formula error
  • →Update column range
  • →Prevent manual overwrite of prices

About formula-protection

Blocks manual changes to predefined 'sacred' spreadsheet formulas. It validates column edits and only permits authorized changes like IFERROR wrapping or repairing broken references.

Prevent accidental modification of sacred spreadsheet formulas in Google Sheets Portfolio Tracker. Blocks edits to GOOGLEFINANCE formulas, calculated columns, and total rows. Allows only IFERROR wrappers, fixing broken references, and expanding ranges. Triggers on update formula, modify column, fix errors, or any attempt to edit formula-based cells.

When not to use it

  • →When performing legitimate architectural changes to the spreadsheet
  • →When the user intends to replace dynamic formulas with static values

Prerequisites

Access to Google Sheets Portfolio TrackerSpreadsheet ID from user-profile.yaml

Limitations

  • →Cannot modify formula logic
  • →Restricted to specific allowed repair operations

How it compares

It enforces strict spreadsheet integrity by blocking manual changes to critical formulas, unlike standard spreadsheet editing.

Compared to similar skills

formula-protection side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
formula-protection (this skill)19moNo flagsAdvanced
quant-analyst1032moNo flagsAdvanced
stock-analyzer712moReviewBeginner
creating-financial-models368moReviewAdvanced

Try saying

Example prompts that trigger this skill in your AI assistant.

More by AojdevStudio

View all by AojdevStudio →

financereport

AojdevStudio

Generate institutional-quality PDF analysis reports for stocks and ETFs. USE WHEN user mentions generate report, create pdf, stock analysis, ticker report, watchlist analysis, OR regenerate reports. Includes VGT-style headers, embedded charts, portfolio sizing, and Perplexity sentiment integration.

636

portfoliosyncing

AojdevStudio

Import and sync broker CSV portfolio data to Google Sheets DataHub. Supports multiple brokers (Fidelity, Schwab, Vanguard, etc.). USE WHEN user mentions import broker data OR sync portfolio OR update positions OR CSV import OR portfolio-sync OR working with Portfolio_Positions CSVs. Handles position updates, SPAXX/margin validation, safety checks, and formula protection.

333

margin-management

AojdevStudio

Update Margin Dashboard with Fidelity balance data and calculate margin-living strategy metrics. Monitors margin balance, interest costs, coverage ratios, and scaling thresholds. Triggers safety alerts for large draws and provides time-based scaling recommendations. Use when updating margin, balances, coverage ratio, or margin strategy analysis.

17

montecarlo

AojdevStudio

Run Monte Carlo simulations for Finance Guru portfolio strategy. USE WHEN user mentions monte carlo OR run simulation OR stress test portfolio OR probability analysis OR income projections OR margin safety analysis. Supports 4-layer portfolio (Growth, Income, Hedge, GOOGL) with auto-detection of current values from Fidelity CSV.

15

retirement-syncing

AojdevStudio

Sync retirement account data from Vanguard and Fidelity CSV exports to Google Sheets DataHub. Handles multiple accounts, aggregates holdings by ticker, and updates quantities in retirement section (rows 46-62). Triggers on sync retirement, update retirement, vanguard sync, 401k update, IRA sync, or working with notebooks/retirement-accounts/ files.

15

transactionsyncing

AojdevStudio

Import Fidelity transaction history CSV into Google Sheets with smart categorization. USE WHEN user mentions "sync transactions", "import transactions", "transaction history", OR wants to import Fidelity History CSV. Routes debit card purchases to Expense Tracker with auto-categorization.

110

You might also like

quant-analyst

zenobi-us

Expert quantitative analyst specializing in financial modeling, algorithmic trading, and risk analytics. Masters statistical methods, derivatives pricing, and high-frequency trading with focus on mathematical rigor, performance optimization, and profitable strategy development.

103355

stock-analyzer

FrancyJGLisboa

Provides comprehensive technical analysis for stocks and ETFs using RSI, MACD, Bollinger Bands, and other indicators. Activates when user requests stock analysis, technical indicators, trading signals, or market data for specific ticker symbols.

71214

creating-financial-models

anthropics

This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

36161

reconciliation

anthropics

Reconcile accounts by comparing GL balances to subledgers, bank statements, or third-party data. Use when performing bank reconciliations, GL-to-subledger recs, intercompany reconciliations, or identifying and categorizing reconciling items.

30139

analyzing-financial-statements

anthropics

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

32134

us-stock-analysis

tradermonty

Comprehensive US stock analysis including fundamental analysis (financial metrics, business quality, valuation), technical analysis (indicators, chart patterns, support/resistance), stock comparisons, and investment report generation. Use when user requests analysis of US stock tickers (e.g., "analyze AAPL", "compare TSLA vs NVDA", "give me a report on Microsoft"), evaluation of financial metrics, technical chart analysis, or investment recommendations for American stocks.

24137

Search skills

Search the agent skills registry