FINANCE

FX Hedge-Gap Ticket Creator in Linear

Identifies currencies whose unhedged exposure has stayed above target for several consecutive days in BigQuery and opens a tracked Linear issue per persistent gap so treasury…

CategoryFinance
Enginesim
Difficultyintermediate
Triggerschedule
Steps4
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily persistence-check schedule
  • ActionQuery trailing-N-day exposure from BigQueryGoogle BigQueryBigQuery
  • LogicKeep only persistent, un-ticketed gaps
  • OutputOpen a Linear issue per persistent gapLinearLinear

What it does

It turns persistent FX risk into accountable work: when a currency stays over-exposed for multiple days running, it files a Linear issue assigned to treasury to close the hedge gap.

When to use it

When one-off alerts get acknowledged and forgotten. This creates durable, trackable tasks only for risks that persist, so the team actually hedges rather than just noticing.

How it works

  1. 1A daily schedule kicks off the persistence check.
  2. 2A BigQuery action queries each currency's unhedged exposure across the trailing N days from the snapshot history.
  3. 3A logic step keeps only currencies that have exceeded target on every one of the last N days and that do not already have an open ticket.
  4. 4For each qualifying currency, a Linear action creates an issue describing the gap, the trend, and the suggested hedge size, assigned to the treasury owner.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect LinearIssues, projects, cycles, triage.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    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.