FINANCE

Weekly FX Hedge-Coverage Brief

Compiles a weekly hedge-coverage report from Snowflake exposure and hedge data, calculates coverage ratios per currency.

CategoryFinance
Enginesim
Difficultybeginner
Triggerschedule
Steps6
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule before treasury review
  • ActionJoin exposure and hedges for coverage ratiosSnowflakeSnowflake
  • LogicClassify currencies by coverage status
  • ActionRender formatted coverage brief
  • OutputPublish brief to Notion treasury pageNotionNotion
  • OutputPost headline summary to SlackSlack

What it does

Once a week this workflow joins open receivables exposure with active hedge contracts in Snowflake, computes the hedge-coverage ratio for each currency, and flags any currency falling below its target coverage. It publishes a formatted brief to a Notion treasury page and drops a one-line summary in Slack so the team sees the headline without opening the doc.

When to use it

Use this for the recurring treasury review where leadership wants a clean coverage snapshot rather than per-event alerts. It standardizes the weekly report so nobody hand-builds it, and keeps a dated archive of coverage history in Notion.

How it works

  1. 1A weekly schedule fires ahead of the treasury review.
  2. 2Snowflake joins exposure and active hedges, returning coverage per currency.
  3. 3A logic step classifies each currency as on-target, under-covered, or over-hedged.
  4. 4An action renders the brief with ratios, deltas, and flagged currencies.
  5. 5Notion receives the formatted page in the treasury workspace.
  6. 6Slack posts a headline summary linking to the new Notion page.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SnowflakeWarehouses, queries, shares.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.