Compute the p25, median, and p75 of declared clearance pricing on any API lane. The empirical benchmark for procurement negotiation.
Cefixime into Bangladesh prices at $124.75/kg median with a tight $115 to $130 interquartile band. The distribution sits within ±6% of the median because the lane carries 162 declared shipments across seven active exporters with a benchmark anchor at the largest tenders. Procurement leverage on this lane comes from volume commitment, not from price discovery.
Molecule INN + origin country + destination country. Defaults to last 12 months; configurable to any window.
Trimmed-mean filter on declared USD/kg, then p25 / median / p75 across all shipments. Outliers above 5x median are flagged separately.
Citation-anchored brief with the percentile band, histogram, number of shipments, and number of active exporters.
Same molecule clears at different price bands into different destinations. The benchmark reflects the lane you're actually buying on.
Tight p25-to-p75 means little price discovery. Wide spread means leverage. Both signals show on the histogram.
Percentiles aggregate across exporters. Never a named transaction list. Trade-data disclaimer respected at the query layer.
Trade aggregates flow in weekly. The percentile band moves with the market; the brief carries the exact computation timestamp.
A real chat thread in PharmaDB. Type a question, the AI agent runs the tools, the answer lands as a saveable note.
pharmagraph_query Eighteen molecules · global API price percentile band, 2024 · USD/kg from molecule_api_prices.
API price percentiles are the empirical anchor for procurement negotiation. PharmaDB joins trade declarations to the molecule catalog, trims unit-mismatched rows, and returns the p25 / median / p75 band per molecule-lane. The view is molecule_country_flow; the global aggregate is molecule_api_prices. Refresh cadence is weekly.
Declared USD/kg from every shipment on the molecule-lane is collected, outliers above 5x median are trimmed, and the p25 / median / p75 are computed across the remaining set. The view that backs the page is `molecule_country_flow` joined to the molecule catalog.
Bangladesh runs the largest single tender market for cefixime, with multi-exporter participation anchored to a published reference price. When a lane has a strong tender anchor, the price distribution collapses around it.
Domain dependent. A specialty API like dapagliflozin shows p25-to-p75 spread of 3-4x, reflecting active price discovery. A high-volume commodity API like cefixime shows ~1.1x. Width is a direct measure of how much room a buyer has at the table.
Trade declarations occasionally label pack-level prices as per-kg. PharmaDB flags rows whose USD/kg sits more than 100x off the molecule's global median and excludes them from the percentile compute. The original row is retained in the audit log.
Yes. The `molecule_fdf_prices` view applies the same methodology to finished-dosage shipments, with form and pack-size normalisation. FDF percentile bands surface as a separate analysis.
Trade aggregates refresh weekly. The percentile compute reruns on every refresh; the catalog row carries the exact timestamp surfaced on the result page.
Bring the molecule, the lane, or the supplier you're sourcing this week. The AI agent runs it on PharmaDB in 30 minutes. You keep the brief.