Commodity Market

Palm oil does not trade in isolation - soybean oil is its closest substitute, so the palm-vs-soy spread drives buyer switching, and the USD/IDR rate decides what a USD-quoted price is actually worth to an Indonesian estate.

Palm vs soybean oil (USD/tonne)

Palm − soybean substitution spread

A negative spread means palm trades at a discount to soybean oil (palm looks attractive to buyers).

USD/IDR exchange rate

Governed metrics (dbt Semantic Layer)

These series are not hand-written SQL - they come from one canonical definition in the dbt metric registry (_marts__semantic.yml), compiled to the sl_metrics_daily view by semantic/compile_metrics.py. Dashboard, docs, and any future consumer must agree because there is only one place the math lives.

Pricing, FX, operations value, and the harvest-day share all resolve to the same governed definitions - see the Methodology for the registry → compiler → view pipeline.