AgentSkillsCN

multi-currency-expense-aggregator

当用户需要将不同币种计价的多笔支出汇总，并基于历史汇率换算成目标币种时，该技能会读取包含支出数据的多个CSV/JSON文件，从金融API中获取指定日期的汇率，完成货币兑换，按人统计总支出，并生成结构化的JSON报告，其中囊括计算结果。关键触发条件包括“行程总费用”“带汇率的支出计算”“将多种货币兑换为[目标币种]”，或当用户需读取包含美元、欧元、土耳其里拉、人民币等金额的多份支出文件时。

SKILL.md
--- frontmatter
name: multi-currency-expense-aggregator
description: When the user needs to calculate total expenses across multiple individuals with costs in different currencies and convert them to a target currency using historical exchange rates. This skill handles reading multiple CSV/JSON files containing expense data, fetching exchange rates from financial APIs for specific dates, performing currency conversions, aggregating totals per person, and generating structured JSON reports with calculated results. Key triggers include requests for 'total trip cost', 'expense calculation with exchange rates', 'convert multiple currencies to [target currency]', or tasks involving reading multiple expense files with USD, EUR, TRY, CNY amounts.

Instructions

Objective

Calculate the total expenses for a group of individuals from multiple files, convert all amounts to a target currency (e.g., CNY) using historical exchange rates from a specific date, and output a structured JSON report.

Core Workflow

  1. •Identify Inputs: Determine the target currency, the historical date for exchange rates, the list of individuals, and the location of their expense files (CSV/JSON). The user may provide this explicitly or it may need to be inferred from the workspace.
  2. •Read Data: List and read all relevant expense files from the workspace. Files are typically CSVs with columns for Date, Activity/Description, Cost/Amount, and Currency, or similar variations.
  3. •Fetch Exchange Rates: Use the Yahoo Finance tool (yahoo-finance-get_stock_price_by_date) to get the closing exchange rates for the required currency pairs (e.g., USDCNY=X, EURCNY=X) on the specified historical date. For indirect pairs (e.g., TRY/CNY), you may need to fetch a cross-rate (e.g., TRYUSD=X) and calculate the target rate.
  4. •Parse & Aggregate: For each individual's file:
    • •Parse the data, summing amounts by currency (USD, EUR, TRY, CNY, etc.).
    • •Convert each currency sum to the target currency using the fetched rates.
    • •Calculate the individual's total in the target currency.
  5. •Calculate Grand Total: Sum all individual totals.
  6. •Generate Output: Create or update a specified JSON file (e.g., calculation.json) with the exchange rates used and each individual's total in the target currency, along with the grand total. Format numbers appropriately (e.g., rounded to 2 decimal places).

Key Considerations & Edge Cases

  • •File Format Variability: Expense files may have different column names, structures, or delimiters. Be prepared to handle variations like Cost vs Amount, or files where costs are spread across multiple currency columns.
  • •Missing Direct Rates: If a direct exchange rate pair (e.g., TRYCNY=X) is not available, you must calculate it using a common intermediary (e.g., TRYUSD=X and USDCNY=X).
  • •Date Handling: The exchange rate date is critical. Ensure the correct date is used for the yahoo-finance-get_stock_price_by_date call. Use the close price for conversion.
  • •Error Handling: If a file cannot be read or a rate cannot be fetched, note the issue and proceed if possible, or ask for clarification.
  • •Calculation Verification: For complex sums, consider writing a temporary Python script to perform the arithmetic and verify totals, then clean it up.

Typical Tool Sequence

  1. •filesystem-list_directory - Explore the workspace.
  2. •filesystem-read_multiple_files / filesystem-read_file - Load expense data.
  3. •yahoo-finance-get_stock_price_by_date - Fetch historical FX rates.
  4. •terminal-run_command - Optionally run a Python script for accurate bulk calculations.
  5. •filesystem-write_file - Write the final JSON report.

Output

The primary output is a JSON file (e.g., calculation.json) populated with keys for exchange rates and individual/group totals in the target currency. Provide a concise summary to the user.