How to Get Real-Time Gold Ask (XAU-ASK) Prices in Excel with Metals-API

In today's fast-paced financial markets, having access to real-time data is crucial for making informed trading decisions. For those interested in precious metals, particularly gold, the Metals-API offers a powerful solution to retrieve real-time Gold Ask (XAU-ASK) prices directly into Excel. This blog post will guide you through the process of accessing these prices using the Metals-API, detailing its features, capabilities, and practical applications.

Metals-API Information

About Gold (XAU)

Gold, represented by the symbol XAU, has long been a cornerstone of financial markets and investment portfolios. As digital transformation sweeps through the financial sector, the integration of data analytics and technology in trading has become paramount. The Metals-API stands at the forefront of this innovation, providing developers with the tools needed to access real-time market data and insights.

With the rise of digital asset solutions, the ability to analyze gold prices in real-time allows traders to make quicker decisions based on market fluctuations. By leveraging data analytics, traders can uncover market trends, optimize their trading strategies, and enhance their overall investment performance. The Metals-API empowers developers to build next-generation applications that facilitate these processes.

API Description

The Metals-API is a comprehensive JSON API that provides real-time and historical data for various metals, including gold, silver, platinum, and palladium. This API is designed to empower developers by offering a robust set of features that enable seamless integration into applications, whether for personal use or commercial purposes.

With the Metals-API, you can access a wide range of functionalities, including the latest rates, historical data, and conversion capabilities. The API's innovative design allows for easy integration into various platforms, including Excel, making it an ideal choice for traders and analysts seeking to enhance their data-driven decision-making processes.

For more information, visit the Metals-API Website or check out the Metals-API Documentation.

Key Features and Endpoints

The Metals-API offers a variety of endpoints that cater to different data needs. Below are some of the key features and their potential applications:

Latest Rates Endpoint: This endpoint provides real-time exchange rate data for metals, updated based on your subscription plan. Depending on your plan, you can receive updates every 60 minutes, every 10 minutes, or even more frequently. This feature is essential for traders who need the most current pricing information to make timely decisions.
Historical Rates Endpoint: Access historical rates dating back to 2019 by appending a specific date to your API call. This feature allows users to analyze past market trends and make informed predictions about future movements.
Bid And Ask Endpoint: Retrieve real-time bid and ask prices for metals. This endpoint is particularly useful for traders looking to understand market depth and make informed trading decisions based on current market conditions.
Convert Endpoint: The Metals-API includes a currency conversion endpoint, allowing users to convert amounts from one metal to another or to/from USD. This feature is invaluable for traders dealing with multiple currencies and metals.
Time-Series Endpoint: Query daily historical rates between two dates of your choice. This endpoint is useful for analyzing trends over specific periods, helping traders identify patterns and make strategic decisions.
Fluctuation Endpoint: Track how currencies fluctuate on a day-to-day basis. This endpoint provides insights into market volatility, allowing traders to adjust their strategies accordingly.
Carat Endpoint: Retrieve gold rates by carat. This feature is particularly useful for jewelers and those in the jewelry industry who need precise pricing based on carat weight.
Lowest/Highest Price Endpoint: Query the API to get the lowest and highest prices for a specified date. This data can help traders identify price extremes and make informed trading decisions.
Open/High/Low/Close (OHLC) Price Endpoint: Get OHLC data for a specific time period. This endpoint is crucial for technical analysis, allowing traders to assess market performance over time.
Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008. This endpoint is beneficial for those analyzing long-term trends in the metals market.
API Key: Your unique API key is required to access the API. This key is passed into the API base URL's access_key parameter to authenticate your requests.
API Response: The Metals-API delivers exchange rates relative to USD by default, with all data returned in a structured JSON format.
Available Endpoints: The Metals-API features 14 different endpoints, each providing distinct functionalities tailored to various user needs.
Supported Symbols Endpoint: Access a constantly updated list of all available currencies and metals through this endpoint. This feature ensures that users are aware of all the symbols they can query.
News Endpoint: Retrieve the latest news articles related to various metals, keeping traders informed about market developments and trends.

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

To get real-time exchange rates for all available metals, you can use the Latest Rates Endpoint. Below is an example response:

{
"success": true,
"timestamp": 1778977244,
"base": "USD",
"date": "2026-05-17",
"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 gold (XAU). The "unit" indicates that these prices are quoted per troy ounce.

Historical Rates Endpoint

Access historical exchange rates for any date since 1999 using the Historical Rates Endpoint. Here’s an example response:

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

This response provides historical rates for gold and other metals, allowing users to analyze past market performance.

Time-series Endpoint

To get exchange rates for a specific time period, you can use the Time-series Endpoint. Below is an example response:

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

This response shows the historical rates for gold over a specified period, enabling users to identify trends and fluctuations.

Convert Endpoint

The Convert Endpoint allows you 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": 1778977244,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}

This response indicates that 1000 USD is equivalent to 0.482 troy ounces of gold at the current exchange rate.

Fluctuation Endpoint

Track rate fluctuations between two dates using the Fluctuation Endpoint. Below is an example response:

{
"success": true,
"fluctuation": true,
"start_date": "2026-05-10",
"end_date": "2026-05-17",
"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 response provides insights into how gold and other metals have fluctuated over the specified period, helping traders assess market volatility.

OHLC (Open/High/Low/Close) Endpoint

To get OHLC data for a specific time period, you can use the OHLC Endpoint. Here’s an example response:

{
"success": true,
"timestamp": 1778977244,
"base": "USD",
"date": "2026-05-17",
"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 response provides a comprehensive view of the market performance for gold and other metals over the specified date, essential for technical analysis.

Bid/Ask Endpoint

To get current bid and ask prices for metals, you can use the Bid/Ask Endpoint. Below is an example response:

{
"success": true,
"timestamp": 1778977244,
"base": "USD",
"date": "2026-05-17",
"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 response provides the current bid and ask prices for gold, allowing traders to understand market conditions and make informed decisions.

Conclusion

Accessing real-time Gold Ask (XAU-ASK) prices in Excel using the Metals-API is a straightforward process that can significantly enhance your trading strategies. By leveraging the various endpoints offered by the Metals-API, you can obtain real-time data, historical insights, and conversion capabilities that are essential for informed decision-making.

With features like the Latest Rates, Historical Rates, and Bid/Ask endpoints, the Metals-API provides a comprehensive toolkit for traders and analysts alike. By integrating this API into your applications, you can harness the power of real-time data to optimize your trading strategies and stay ahead of market trends.

For further exploration, refer to the Metals-API Documentation for detailed information on each endpoint and its capabilities. Additionally, keep an eye on the Metals-API Supported Symbols page to stay updated on the available metal symbols.

In conclusion, the Metals-API is an invaluable resource for anyone looking to access real-time gold prices and other metal data. By utilizing this API, you can enhance your trading experience and make more informed decisions in the dynamic world of precious metals.

Ready to use Metals-API?

Try it now!

How to Get Real-Time Gold Ask (XAU-ASK) Prices in Excel with Metals-API