How to Get Real-Time Palladium Sep 2025 (PAU25) Prices with Metals-API and Excel Integration

In today's fast-paced financial landscape, accessing real-time data is crucial for making informed decisions. For those interested in precious metals, particularly palladium, the Metals-API offers a robust solution for obtaining real-time prices, including the Palladium Sep 2025 (PAU25) futures. This blog post will guide you through the process of accessing real-time palladium prices using the Metals-API, integrating this data into Excel, and exploring the transformative potential of real-time metals data.

Metals-API Information

About Palladium (XPD)

Palladium, represented by the symbol XPD, is a precious metal that has gained significant attention due to its critical role in automotive technology innovation, particularly in catalytic converters. As the automotive industry shifts towards greener technologies, palladium's importance in environmental solutions cannot be overstated. Furthermore, the integration of digital supply chains and smart manufacturing processes has made palladium trading more efficient and accessible.

With the rise of technology integration in the financial sector, the demand for real-time data has surged. The Metals-API provides developers with the tools necessary to build next-generation applications that can leverage real-time palladium prices, enabling businesses to make data-driven decisions swiftly.

API Description

The Metals-API is a powerful tool that allows users to access real-time and historical data for various metals, including palladium. It empowers developers to create applications that can track price fluctuations, analyze trends, and convert currencies seamlessly. The API is designed with innovation in mind, providing a comprehensive suite of features that cater to the needs of modern developers.

For more information, visit the Metals-API Website or check out the Metals-API Documentation for detailed guidance on implementation.

Key Features and Endpoints

The Metals-API offers a variety of endpoints that provide different functionalities. 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, updates can occur every 60 minutes or even more frequently.
Historical Rates Endpoint: Users can access historical rates dating back to 2019 by appending a specific date to the API request. This feature is invaluable for trend analysis and forecasting.
Bid And Ask Endpoint: This endpoint allows users to retrieve real-time bid and ask prices, which are essential for traders looking to execute transactions at optimal prices.
Convert Endpoint: The Metals-API includes a currency conversion feature, enabling users to convert amounts from one metal to another or to/from USD.
Time-Series Endpoint: Users can query the API for daily historical rates between two specified dates, facilitating in-depth analysis of price movements over time.
Fluctuation Endpoint: This feature provides insights into how prices fluctuate on a day-to-day basis, helping traders understand market volatility.
Carat Endpoint: Users can retrieve gold rates by carat, which is particularly useful for jewelers and investors in the gold market.
Lowest/Highest Price Endpoint: This endpoint allows users to query the API for the lowest and highest prices within a specified timeframe.
Open/High/Low/Close (OHLC) Price Endpoint: Users can access open, high, low, and close prices for specific dates, which are crucial for technical analysis.
Historical LME Endpoint: This endpoint provides access to historical rates for LME symbols dating back to 2008, offering a wealth of data for analysis.
API Key: Each user is assigned a unique API key that must be included in API requests to authenticate access.
API Response: The API delivers exchange rates relative to USD by default, ensuring consistency in data presentation.
Available Endpoints: The Metals-API features 14 endpoints, each designed to provide specific functionalities tailored to user needs.
Supported Symbols Endpoint: This endpoint returns a constantly updated list of all available currencies and metals supported by the API.

List of Symbols

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

API Endpoint Examples and Responses

Latest Rates Endpoint

The Latest Rates Endpoint allows users to get real-time exchange rates for all available metals. Here’s an example response:

{
"success": true,
"timestamp": 1782087564,
"base": "USD",
"date": "2026-06-22",
"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"
}

In this response, the "rates" object contains the current prices for various metals, including palladium (XPD).

Historical Rates Endpoint

The Historical Rates Endpoint provides access to historical exchange rates for any date since 1999. Here’s an example response:

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

This response allows users to analyze historical data, which is essential for understanding market trends and making informed trading decisions.

Time-Series Endpoint

The Time-Series Endpoint enables users to get exchange rates for a specific time period. Here’s an example response:

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

This endpoint is particularly useful for analyzing trends over time, allowing users to visualize price movements and make predictions based on historical data.

Convert Endpoint

The Convert Endpoint allows users to convert any amount from one metal to another or to/from USD. Here’s an example response:

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

This feature is invaluable for traders and investors who need to quickly assess the value of their holdings in different metals.

Fluctuation Endpoint

The Fluctuation Endpoint tracks rate fluctuations between two dates. Here’s an example response:

{
"success": true,
"fluctuation": true,
"start_date": "2026-06-15",
"end_date": "2026-06-22",
"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 market volatility, allowing traders to adjust their strategies based on recent price movements.

OHLC (Open/High/Low/Close) Endpoint

The OHLC Endpoint provides open, high, low, and close prices for a specific time period. Here’s an example response:

{
"success": true,
"timestamp": 1782087564,
"base": "USD",
"date": "2026-06-22",
"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 data is essential for traders who rely on technical analysis to make informed decisions.

Bid/Ask Endpoint

The Bid/Ask Endpoint provides current bid and ask prices for metals. Here’s an example response:

{
"success": true,
"timestamp": 1782087564,
"base": "USD",
"date": "2026-06-22",
"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 execute transactions at the best possible prices.

Integrating Metals-API with Excel

Integrating the Metals-API with Excel allows users to create dynamic spreadsheets that automatically update with real-time palladium prices. Here’s how to do it:

Obtain Your API Key: Sign up for an account on the Metals-API website and retrieve your unique API key.
Open Excel: Launch Microsoft Excel and create a new spreadsheet.
Use Excel's Web Query Feature: Go to the "Data" tab, select "Get Data," and then choose "From Other Sources" followed by "From Web."
Enter the API URL: Input the API endpoint URL for the latest rates, including your API key. For example: https://metals-api.com/api/latest?access_key=YOUR_API_KEY.
Load Data: Click "OK" to load the data into your spreadsheet. Excel will fetch the latest rates and display them in a table format.
Set Up Automatic Refresh: To keep your data updated, go to "Data" > "Queries & Connections," right-click your query, and select "Properties." Set the refresh rate according to your needs.

This integration allows you to monitor palladium prices in real-time, making it easier to analyze trends and make informed trading decisions.

Conclusion

Accessing real-time palladium prices through the Metals-API is a powerful way to stay informed in the dynamic world of precious metals trading. With a variety of endpoints offering real-time data, historical analysis, and conversion capabilities, the Metals-API empowers developers to create innovative applications that can leverage this data effectively.

By integrating the Metals-API with Excel, users can create dynamic spreadsheets that automatically update with the latest prices, enhancing their ability to analyze market trends and make informed decisions. Whether you are a trader, investor, or developer, the Metals-API provides the tools you need to succeed in the precious metals market.

For more information on how to get started, visit the Metals-API Documentation and explore the Metals-API Supported Symbols page for a comprehensive list of available metals and their specifications.

Ready to use Metals-API?

Try it now!

How to Get Real-Time Palladium Sep 2025 (PAU25) Prices with Metals-API and Excel Integration