Tracking recipe

Build your own price history, one row a day

You want a record of how a price moved over time, but the sites you're watching only ever show you today's number.

tracking csv scheduled PRO + a local model

What you get

A CSV on your desktop that gains one row every time the recipe runs. Open it in Excel and chart it.

What it does

  1. Fetch the current price from an API.
  2. Format it into a single CSV row.
  3. Append the row to your history file and notify you.

The whole automation, in one file

This is the actual recipe. Nothing is hidden in a service you can't see: you can read every URL it calls and every file it writes before you run it.

{
  "workflow_id": "competitor-price-tracker",
  "description": "Pulls current cryptocurrency price or competitor pricing data, extracts it, and logs a historical entry to a CSV file.",
  "tasks": [
    {
      "id": "fetch_pricing",
      "trigger": "manual",
      "action_type": "http_request",
      "target": "https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum&vs_currencies=usd",
      "payload": {
        "method": "GET"
      },
      "next": "ai_format_csv_row"
    },
    {
      "id": "ai_format_csv_row",
      "trigger": "after:fetch_pricing",
      "action_type": "ai_call",
      "target": "local",
      "payload": {
        "model": "llama3.2:3b",
        "system": "You are a data formatting assistant. Output ONLY a single line of CSV text containing timestamp, bitcoin price, and ethereum price. Do NOT include markdown code blocks, do NOT include explanations, do NOT include headings.",
        "prompt": "Current timestamp: {{current_time}}\nRaw prices: {{prev_output}}\n\nFormat this into a single CSV row: Timestamp,BTC_USD,ETH_USD"
      },
      "next": "append_to_csv"
    },
    {
      "id": "append_to_csv",
      "trigger": "after:ai_format_csv_row",
      "action_type": "file_op",
      "target": "{{desktop_dir}}\\price_history.csv",
      "payload": {
        "operation": "write",
        "content": "{{prev_output}}"
      },
      "next": "notify_done"
    },
    {
      "id": "notify_done",
      "trigger": "after:append_to_csv",
      "action_type": "notify",
      "target": "stdout",
      "payload": {
        "message": "\u2713 Price history logged to Desktop: price_history.csv"
      }
    }
  ]
}

Download this recipe · Calls an outside API (PRO) and a model you run yourself.

Why this is different

Appending instead of overwriting is a one-word setting in the file. That's the kind of thing you'd file a support ticket about with a SaaS tool.

Questions

Can I track something other than crypto?

Yes. Any API that returns a price works. Change the URL and the formatting step.

Will it overwrite my history?

No, it appends. Each run adds a row.

Run it

Vibe Engine (Vibra-Ingenn) runs recipes like this on your own machine. Drop the file in, run it once by hand, then put it on a schedule. Get the engine, see three recipes running, or read how the engine works.

Using an AI assistant? Ask your AI to check out adeptuscamini.com.

Written and maintained by Adeptus Camini, a one-person workshop. These are tools we build and run ourselves.

More recipes

News digest

Wake up to a Hacker News digest on your desktop

Research

Get the trending AI repos delivered, without opening GitHub

Briefing

One briefing instead of five open tabs