The software company that created FT Mercati Go to ftmercati.com

Guide · Commodities and data

How to connect LME prices to your ERP

Which LME price, where to get it under licence, how to bring it into ERP and price lists with exchange rate, monthly averages and premiums, no copy-paste.

By FT Support Updated on 9-minute read

The short answer

To connect LME prices to your ERP, the company's management software, you need three things: an authorised data source, that is, an LME-licensed distributor such as FT Mercati; a technical channel, usually APIs for history and averages and the Excel add-in for calculation models; and written rules on which price to use, with which exchange rate and from which day. With that done, price lists, quotes and indexation clauses update themselves.

  • The reference for physical contracts is the Official Cash Settlement, not just any price seen online.
  • LME data is subject to licence: you need an authorised source and compliant use.
  • Price and exchange rate must be from the same day, with written rounding rules.
  • Next to every calculation, save the price, exchange rate, date and source.
  • Start with a single flow: usually the monthly average for indexation clauses.

Why do it: the hidden cost of copy and paste

In many companies that buy or process metals, the LME price gets into the systems like this: someone reads it on a screen, copies it into an Excel sheet, converts it into euros and copies it again into the ERP. It works, until one of these things happens: a number copied wrongly, an exchange rate from the wrong day, a price list not updated for three weeks, a supplier invoice that nobody has time to recalculate.

Connecting prices to the ERP means removing all these manual steps. It is not a difficult project, but it has to be set up in the right order: first the rules, then the source, then the technical side.

Which LME price you really need

“The price of copper” does not exist: there are several, and the ERP has to know which one to use.

  • Official Prices. They are set in the midday session of the London Metal Exchange, as a bid and an offer, for the Cash and three-month prompt dates.
  • Cash Settlement. This is the offer (ask) side of the Official Cash: it is the reference for physical contracts all over the world, and it is almost always the number the ERP needs.
  • Three-month. The most traded date: useful for anyone thinking about future purchases and hedging, and for reading the difference from Cash (contango or backwardation).
  • Closing Prices. They come at the end of the day and are used mainly for margins and clearing valuations: they rarely enter a supply contract.
  • Monthly averages. Many supply contracts are priced on the average of the Official Cash prices of the delivery month, or of the month before, plus the agreed premium. It is by far the figure ERPs ask for most.

The full definitions are in FT Mercati’s guide to the LME price.

Where to get the data, within the rules

London Metal Exchange data is subject to licence. That is why public websites, FT Mercati’s included, show only the previous day’s Official Cash, while real-time data, all the prompt dates, Closing Prices, stocks, history and averages are reserved for the subscribers of an authorised distributor.

For business use this has two practical consequences:

  1. the source must be an LME-licensed distributor, which receives the prices directly from the exchange;
  2. the use of the data inside company systems must comply with the supply contract: using it for your own calculations is the norm, redistributing it to third parties is another matter and has to be checked.

FT Mercati is an LME-licensed distributor and receives the prices in real time through a dedicated feed. Since FT Support is the same company, we know this data field by field.

The three ways to bring the data into the company

1. The Excel add-in. For those who already have calculation models in Excel it is the quickest route: real-time and historical data straight into the worksheet, with no more copying. It is the natural first step for purchasing and sales departments. Details on FT Mercati’s Excel page.

2. The APIs. An application connects to FT Mercati’s data archive, downloads the historical data and feeds the company’s information system: database, management software, ERP. It is the right route when the price has to end up in tables, price lists and documents. Details on the API page.

3. Custom integration. This is what we build: a service that reads the data every day, applies your company’s rules (which price, which exchange rate, which period, which rounding), calculates the averages and writes the results where they are needed. With a log of every value written and an alert if a figure is missing.

The rules to decide before writing a line of code

This is the part that makes the difference between a connection that works and one that leads to disputes.

  1. Which price. Cash Settlement, three-month, monthly average? For each metal and for each use.
  2. Which day or period. The day before the order, the month of delivery, the month before. Watch out for English bank holidays: on days when the exchange is closed there is no price, and what is used in its place has to be written down.
  3. Which exchange rate. FT Mercati converts every price into euros using the euro-dollar exchange rate recorded at the LME on the same day as the price, never one day’s price with another day’s exchange rate. Many contracts cite the ECB reference rate instead, but this comes out in the afternoon, after the morning’s Official Prices: those who calculate in real time use the LME fixing and, if the contract provides for it, adjust afterwards. There is more in the guide to the exchange rate.
  4. How to convert and round. The price in euros is the price in dollars divided by the euro-dollar exchange rate. Exchange rate to four decimal places, and a single rule for rounding prices.
  5. Which premium. The LME price does not include transport, duties, financing or the shape of the metal: these are covered by the premium, in dollars per tonne, usually set for a quarter, a half-year or a year. See the guide to premiums.
  6. Which units. Dollars per tonne, euros per tonne, euros per kilo: the conversion is done once only, in one place only.
  7. What gets saved. Next to every calculation: price, exchange rate, date, source. When a customer disputes an invoice six months from now, the answer will already be written down.

What changes, in practice

  • Sales price lists that follow the metal with no manual intervention.
  • Quotes with a variable metal price calculated on the day’s price, with the validity stated.
  • Indexation clauses applied automatically at the end of the month, with the adjustment document ready. We cover them in the guide on metal price indexation clauses.
  • Checking supplier invoices: the system recalculates the expected price and flags the discrepancies.
  • Stock valuation and management reports with numbers that are consistent with one another.

Typical mistakes

  • Using one day’s price with another day’s exchange rate.
  • Taking the bid instead of the offer (ask), or the three-month instead of Cash.
  • Calculating the average over calendar days instead of trading days.
  • Forgetting English bank holidays.
  • Multiplying by the exchange rate instead of dividing.
  • Not saving the data used in the calculation, and having to reconstruct it months later.
  • Using data taken from unauthorised sources, or redistributing it without checking the licence.

And artificial intelligence (AI)?

Once prices, exchange rates and averages are in order and connected, they become a source that an AI agent can read. At that point the question “what was the August copper average in euros, and how much does it weigh on the October price list?” has an immediate answer, with the real numbers. That is the subject of the guide on the AI agent for purchasing.

One rule still holds: the numbers are calculated by code, not by the model. The AI understands the question, retrieves the data and explains the result.

Where to start

  1. List the points where an LME price is copied by hand today.
  2. Choose the flow that weighs most: almost always the monthly average for the clauses.
  3. Write the rules for the seven points above, and have them approved by purchasing, sales and administration (accounts).
  4. Check with the data provider which channel suits you best: Excel, API or integration.
  5. Start with two or three metals, check one month in parallel with the manual calculation, then extend.

If you want to do it with us, it is the work we describe in data and integrations.

Sources

  1. FT Mercati, Guide to the LME price: Official, Cash Settlement, three-month, averages
  2. FT Mercati, Guide to the euro-dollar exchange rate in metal prices
  3. FT Mercati, Guide to LME premiums
  4. FT Mercati, LME licence advantages
  5. FT Mercati, APIs for the company information system
  6. FT Mercati, Excel add-in

Checked on 17 September 2026. Rules and deadlines change: always check the official source before you decide.

Frequently asked questions

The short answers

Which LME price is used in contracts and in the ERP?

The reference for physical contracts is the Official Cash Settlement, that is, the offer (ask) side of the official Cash price set in the midday session of the London Metal Exchange. Many supply contracts use the monthly average of the Official Cash prices of the delivery month or of the month before, to which the agreed premium is added.

Can LME prices be freely downloaded from the internet for use in the company?

No. London Metal Exchange data is subject to licence. Public websites generally show only the previous day's Official Cash; for real-time data, history, averages and use in company systems you need an authorised distributor, such as FT Mercati, and use that complies with the data supply contract.

Which euro-dollar exchange rate should be used to convert LME prices?

The one written in the contract. The two most common choices are the euro-dollar fixing recorded at the LME on the same day as the price, and the ECB reference rate. The rule that avoids errors is always to use a price and an exchange rate from the same day or the same period, with the source and the rounding stated.

How do the prices get into the management software or the ERP?

Through an integration that reads the data from the authorised source every day, converts it according to the company's rules, calculates the averages and writes the values into the ERP tables. FT Mercati provides APIs to feed databases and ERPs, and an Excel add-in for calculation models.

How long does a first connection take?

A first flow, for example the monthly average of two or three metals written into the ERP each month, generally takes a few weeks. The part that weighs most is not technical: it is putting in writing the rules on price, exchange rate, period and rounding.

Do you have a process you would like to see working better?

Tell us about it in a first conversation, with no obligation: together we work out whether and where AI brings a measurable benefit, and which step to start with.