Individual skill

evo-excel-financial-formulas

Utilities for writing financial Excel formulas (log returns, rolling volatility, annualized volatility, XLOOKUP/INDEX+MATCH, RaR calculations) into openpyxl workbooks and triggering LibreOffice headless recalculation.

tasks-evolved/reserves-at-risk-calc/environment/skills/evo-excel-financial-formulas/SKILL.md

Read pinned source

Source commit 84ca182da055fafb6453dcec4a6defdbbfd987c1

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: No
Observed behavior: Local scripts
Last checked: Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 97
Repository last updated: Sep 10, 2026
License: Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

agent-skills Repository topic
ai-agents Repository topic
llm-agents Repository topic
open-world Repository topic
self-evolving-agents Repository topic
finance Derived category
writing Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

SKILL.mdcore · 2,004 bytes
SKILL.mdcore · 2,004 bytes
scripts/utils.pyruns · 2,432 bytes

Read excerpt


# evo-excel-financial-formulas

Write financial formulas into Excel workbooks and recalculate with LibreOffice.

## Key Functions

- `write_gold_price_sheet(wb, gold_series)` - Populate gold prices into Gold price sheet col B
- `write_log_return_formulas(wb, start_row, end_row)` - Write =LN(Bn/Bn-1)*100 in col C
- `write_volatility_formulas(wb, start_row, end_row)` - Write STDEV.S formulas in cols D (3-month) and E (12-month)
- `write_answer_sheet_step1(wb)` - Fill z-score, volatilities in Answer sheet
- `write_answer_sheet_step2(wb, value_countries, volume_countries, gold_avg_price)` - Fill country reserves and exposure
- `write_answer_sheet_step3(wb, step2_countries, total_reserves_data)` - Fill RaR calculations
- `recalculate_with_libreoffice(filepath)` - Force formula recalculation
- `create_output_workbook(template_path, output_path, ...)` - Main orchestrator function