How to Get Real-Time Palladium Dec 2025 (PAZ25) Prices in Spreadsheet Applications with Metals-API

In the fast-paced world of commodities trading, having access to real-time data is crucial for making informed decisions. For those interested in palladium, specifically the Dec 2025 (PAZ25) futures, utilizing the Metals-API can provide you with the necessary tools to access real-time prices and historical data directly in your spreadsheet applications. This blog post will guide you through the process of accessing real-time palladium prices using the Metals-API, focusing on its features, capabilities, and practical applications.

About Palladium (XPD)

Palladium, represented by the symbol XPD, is a precious metal that plays a significant role in various industries, particularly in automotive technology. As the demand for cleaner automotive technologies increases, palladium has become essential in catalytic converters, which help reduce harmful emissions. Furthermore, the integration of digital supply chains and smart manufacturing processes has transformed how palladium is sourced and utilized, making real-time data access more critical than ever.

In addition to its automotive applications, palladium is also used in electronics, dentistry, and jewelry. As industries continue to innovate and seek environmental solutions, the demand for palladium is expected to rise, making it essential for traders and investors to stay updated on market trends and prices.

API Description

The Metals-API is a powerful tool that provides developers with access to real-time and historical data for various metals, including palladium. This API empowers developers to create next-generation applications that can analyze market trends, track price fluctuations, and convert currencies seamlessly. With its innovative features, the Metals-API is transforming how businesses and individuals interact with metal markets.

For more information, you can visit the Metals-API Website or refer to the Metals-API Documentation for detailed guidelines on implementation.

Key Features and Endpoints

The Metals-API offers a variety of endpoints that cater to different needs, allowing users to access real-time and historical data efficiently. Here are some of the key features:

Latest Rates Endpoint: This endpoint provides real-time exchange rate data for palladium and other metals. Depending on your subscription plan, you can receive updates every 60 minutes or even more frequently.
Historical Rates Endpoint: Access historical rates dating back to 2019. This feature allows you to analyze past market trends by appending a specific date to your query.
Bid and Ask Endpoint: Retrieve real-time bid and ask prices for palladium, helping traders make informed decisions based on current market conditions.
Convert Endpoint: Easily convert amounts from one metal to another or to/from USD, facilitating seamless transactions and calculations.
Time-Series Endpoint: Query daily historical rates between two dates, allowing for in-depth analysis of price movements over time.
Fluctuation Endpoint: Track how palladium prices fluctuate on a day-to-day basis, providing insights into market volatility.
Carat Endpoint: Retrieve information about gold rates by carat, which can be useful for those involved in jewelry trading.
Lowest/Highest Price Endpoint: Get the lowest and highest prices for palladium over a specified period, aiding in market analysis.
Open/High/Low/Close (OHLC) Price Endpoint: Access detailed OHLC data for palladium, essential for traders looking to analyze price trends.
Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008, providing a comprehensive view of market trends.
API Key: Your unique API key is required to access the API, ensuring secure and authorized usage.
API Response: All exchange rates are delivered relative to USD, with data returned in a structured JSON format.
Available Endpoints: The Metals-API includes 14 different endpoints, each designed to provide specific functionalities.
Supported Symbols Endpoint: Access a constantly updated list of all available currencies and metals.
News Endpoint: Retrieve the latest news articles related to various metals, keeping you informed about market developments.

List of Symbols

The Metals-API provides access to a comprehensive range of metal symbols, including palladium (XPD). For a complete list of all supported symbols and their specifications, refer to the Metals-API Supported Symbols page.

API Endpoint Examples and Responses

Understanding how to interact with the Metals-API is crucial for effective data retrieval. Below are examples of various API endpoints, showcasing their functionality and the structure of their responses.

Latest Rates Endpoint

Get real-time exchange rates for all available metals.

{
"success": true,
"timestamp": 1775694228,
"base": "USD",
"date": "2026-04-09",
"rates": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912,
"XPD": 0.000744,
"XCU": 0.294118,
"XAL": 0.434783,
"XNI": 0.142857,
"XZN": 0.344828
},
"unit": "per troy ounce"
}

The response includes a success status, a timestamp, the base currency (USD), the date of the rates, and a list of rates for various metals, including palladium.

Historical Rates Endpoint

Access historical exchange rates for any date since 1999.

{
"success": true,
"timestamp": 1775607828,
"base": "USD",
"date": "2026-04-08",
"rates": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915,
"XPD": 0.000748
},
"unit": "per troy ounce"
}

This endpoint allows you to retrieve past rates, which can be essential for analyzing market trends and making informed trading decisions.

Time-series Endpoint

Get exchange rates for a specific time period.

{
"success": true,
"timeseries": true,
"start_date": "2026-04-02",
"end_date": "2026-04-09",
"base": "USD",
"rates": {
"2026-04-02": {
"XAU": 0.000485,
"XAG": 0.03825,
"XPT": 0.000915
},
"2026-04-04": {
"XAU": 0.000483,
"XAG": 0.0382,
"XPT": 0.000913
},
"2026-04-09": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912
}
},
"unit": "per troy ounce"
}

This endpoint is particularly useful for traders looking to analyze price movements over a specific period, allowing for a more comprehensive understanding of market dynamics.

Convert Endpoint

Convert any amount from one metal to another or to/from USD.

{
"success": true,
"query": {
"from": "USD",
"to": "XAU",
"amount": 1000
},
"info": {
"timestamp": 1775694228,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}

This endpoint simplifies the process of converting between different metals and currencies, making it easier for traders to calculate their positions and potential profits.

Fluctuation Endpoint

Track rate fluctuations between two dates.

{
"success": true,
"fluctuation": true,
"start_date": "2026-04-02",
"end_date": "2026-04-09",
"base": "USD",
"rates": {
"XAU": {
"start_rate": 0.000485,
"end_rate": 0.000482,
"change": -3.0e-6,
"change_pct": -0.62
},
"XAG": {
"start_rate": 0.03825,
"end_rate": 0.03815,
"change": -0.0001,
"change_pct": -0.26
},
"XPT": {
"start_rate": 0.000915,
"end_rate": 0.000912,
"change": -3.0e-6,
"change_pct": -0.33
}
},
"unit": "per troy ounce"
}

This endpoint provides insights into how prices have changed over time, which can be invaluable for traders looking to capitalize on market movements.

OHLC (Open/High/Low/Close) Endpoint

Get OHLC data for a specific time period.

{
"success": true,
"timestamp": 1775694228,
"base": "USD",
"date": "2026-04-09",
"rates": {
"XAU": {
"open": 0.000485,
"high": 0.000487,
"low": 0.000481,
"close": 0.000482
},
"XAG": {
"open": 0.03825,
"high": 0.0383,
"low": 0.0381,
"close": 0.03815
},
"XPT": {
"open": 0.000915,
"high": 0.000918,
"low": 0.00091,
"close": 0.000912
}
},
"unit": "per troy ounce"
}

This endpoint is essential for traders who need to analyze the price range and closing values over a specific period, allowing for better decision-making.

Bid/Ask Endpoint

Get current bid and ask prices for metals.

{
"success": true,
"timestamp": 1775694228,
"base": "USD",
"date": "2026-04-09",
"rates": {
"XAU": {
"bid": 0.000481,
"ask": 0.000483,
"spread": 2.0e-6
},
"XAG": {
"bid": 0.0381,
"ask": 0.0382,
"spread": 0.0001
},
"XPT": {
"bid": 0.000911,
"ask": 0.000913,
"spread": 2.0e-6
}
},
"unit": "per troy ounce"
}

This endpoint is crucial for traders looking to understand the current market conditions and make informed trading decisions based on the bid-ask spread.

Conclusion

Accessing real-time palladium prices using the Metals-API is a straightforward process that can significantly enhance your trading strategies. By leveraging the various endpoints offered by the API, you can obtain real-time data, historical trends, and essential market insights that are crucial for making informed decisions in the commodities market.

Whether you are a seasoned trader or just starting, understanding how to utilize the Metals-API effectively can provide you with a competitive edge. For further information on the API's capabilities, visit the Metals-API Documentation and explore the Metals-API Supported Symbols page to familiarize yourself with the available data.

In summary, the Metals-API is a powerful tool for anyone looking to stay ahead in the precious metals market. By integrating real-time data into your applications, you can optimize your trading strategies and make more informed decisions based on accurate and timely information.

Ready to use Metals-API?

Try it now!

How to Get Real-Time Palladium Dec 2025 (PAZ25) Prices in Spreadsheet Applications with Metals-API