skills/coingecko-historical/SKILL.md
Use to open CoinGecko historical-data pages in the default browser for a coin/date or to show historical price on date X.
npx skillsauth add paulrberg/dot-agents coingecko-historicalInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Open the CoinGecko historical-data page for a coin in the user's default browser, centered on a one-day window around a target date.
bitcoin, ethereum, solana). This is the same ID used by the CoinGecko API and the cg CLI — not the ticker symbol. If the user provides only a symbol or name, resolve it first (e.g., cg search <term> -o json or https://api.coingecko.com/api/v3/search?query=<term>).YYYY-MM-DD format.Compute DATE-1 (the day before date) and DATE+1 (the day after date), then open:
https://coingecko.com/en/coins/<coin-id>/historical_data?start=<DATE-1>&end=<DATE+1>
Use the macOS open command:
open "https://coingecko.com/en/coins/<coin-id>/historical_data?start=<DATE-1>&end=<DATE+1>"
Use GNU/BSD date to compute the surrounding days. BSD date (default on macOS) syntax:
start=$(date -j -v-1d -f "%Y-%m-%d" "$DATE" +%Y-%m-%d)
end=$(date -j -v+1d -f "%Y-%m-%d" "$DATE" +%Y-%m-%d)
User invokes: /coingecko-historical bitcoin 2024-03-14
Run:
open "https://coingecko.com/en/coins/bitcoin/historical_data?start=2024-03-13&end=2024-03-15"
open is macOS-only. On Linux substitute xdg-open; on Windows use start.date is missing or malformed.testing
Use ONLY to check or update the project-scoped agent skills installed under .agents/skills so they match the current state of the repo. Do not trigger for creating, finding, or installing skills, or for README/AGENTS.md updates.
testing
Use when CSV, TSV, or Excel (.xlsx) is the primary input/output: inspect, clean, transform, dedupe, merge, validate, convert, recalc formulas, or create/fix spreadsheets. Do not trigger when tabular data is incidental.
testing
Use only when explicitly asked to archive/prune/compact/roll over checked tasks from TODO.md into `.ai/todos/TODO_UNTIL_YYYY_MM_DD.md`, leaving unchecked tasks.
development
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.