# EU Food Commodity Prices

The EU Food Commodity Prices connection gives your assignments direct access to agricultural commodity prices published by the European Commission. It covers 19 commodity categories including beef, cereals, dairy, pigmeat, poultry, eggs, sheep and goat, rice, oilseeds, sugar, olive oil, wine, fruit and vegetables, fertiliser, and organic products. Use it to automate price monitoring, cost benchmarking, and market reporting without manual data downloads.

## Setup

No setup is needed. The EU Food Commodity Prices connection is automatically available to all assignments.

## Capabilities

* **Retrieve current commodity prices** — Access up-to-date EU market prices across 19 categories sourced from the European Commission's Agridata API.
* **Query historical price data** — Look up price trends over time by specifying date ranges or years for specific commodities.
* **Discover available filters** — List available products, categories, regions, farming methods, and other filter values for any commodity before querying prices.
* **Filter by commodity and product** — Narrow results by commodity category, EU member state, product code, and time period.
* **Export results as CSV** — Price data is automatically saved as CSV files for further analysis in the sandbox.

## Key Benefits

* **Official EU data source** — Prices come directly from the European Commission, a recognized and authoritative reference for European agricultural markets.
* **No manual lookups** — Assignments retrieve price data automatically, removing the need to visit government websites or download datasets.
* **Broad commodity coverage** — Access prices across 19 categories including meat, cereals, dairy, oilseeds, sugar, wine, fertiliser, and more in a single connection.
* **Historical context** — Retrieve trend data to understand price movements and inform procurement or pricing decisions over time.

## Works Well With

* **Google Sheets or Microsoft Excel** — Export commodity price data into spreadsheets for cost modeling, budgeting, or trend analysis.
* **Slack or Microsoft Teams** — Post price alerts or weekly market summaries to procurement or finance channels.
* **Snowflake or Google BigQuery** — Feed commodity price data into your data warehouse alongside internal cost and sales data for integrated analysis.