Home
Blog
Get Comprehensive abrdn Physical Gold Shares ETF (SGOL) Historical Prices using this API

Get Comprehensive abrdn Physical Gold Shares ETF (SGOL) Historical Prices using this API

Get Comprehensive abrdn Physical Gold Shares ETF (SGOL) Historical Prices using this API

Get Comprehensive abrdn Physical Gold Shares ETF (SGOL) Historical Prices using this API

In the ever-evolving landscape of financial technology, the ability to access real-time and historical data is paramount for developers and investors alike. The abrdn Physical Gold Shares ETF (SGOL) is a popular investment vehicle for those looking to gain exposure to gold without the complexities of physical ownership. To effectively analyze the performance of SGOL, one must have access to comprehensive historical prices. This is where the Metals-API comes into play, offering a robust solution for retrieving gold prices and other precious metals data.

Metals-API Information

About Gold (XAU)

Gold, represented by the symbol XAU, has long been regarded as a safe haven asset and a hedge against inflation. In recent years, the digital transformation in precious metals trading has opened new avenues for investors and developers. The integration of data analytics and market insights has enabled a more informed approach to trading gold. With the advent of technology, price discovery has become more efficient, allowing for real-time updates and historical data analysis.

As the market for digital assets continues to grow, the Metals-API stands out by providing developers with the tools necessary to build next-generation applications that leverage real-time metals data. This API empowers users to access vital information about gold and other precious metals, facilitating informed decision-making in trading and investment strategies.

API Description

The Metals-API is a powerful tool designed for developers seeking to integrate precious metals data into their applications. With its innovative capabilities, the API allows users to access real-time and historical data, enabling a comprehensive analysis of market trends. The API's transformative potential lies in its ability to provide developers with the necessary resources to create applications that can respond to market changes in real-time.

For detailed information on how to utilize the API, developers can refer to the Metals-API Documentation. This resource provides comprehensive guidance on the various endpoints available, along with examples and best practices for implementation.

Key Features and Endpoints

The Metals-API offers a range of endpoints that cater to different needs, allowing developers to access a wealth of information about precious metals. Here are some of the key features:

  • Latest Rates Endpoint: This endpoint provides real-time exchange rate data for precious metals, updated based on the user's subscription plan. Depending on the plan, updates can occur every 60 minutes or every 10 minutes, ensuring that users have access to the most current market data.
  • Historical Rates Endpoint: Users can access historical rates for most currencies dating back to 2019. By appending a specific date in the format YYYY-MM-DD, developers can query the API for historical rates, allowing for in-depth analysis of price movements over time.
  • Bid And Ask Endpoint: This powerful feature enables users to retrieve real-time bid and ask prices for various metals. Understanding the bid-ask spread is crucial for traders looking to optimize their entry and exit points.
  • Convert Endpoint: The Metals-API includes a currency conversion endpoint that allows users to convert amounts between different metals or to/from USD. This feature is particularly useful for traders who need to quickly assess the value of their holdings in different currencies.
  • Time-Series Endpoint: This endpoint allows users to query daily historical rates between two specified dates. By analyzing time-series data, developers can identify trends and patterns that inform trading strategies.
  • Fluctuation Endpoint: Users can track how metal prices fluctuate on a day-to-day basis. This endpoint provides insights into market volatility, which is essential for risk management.
  • Carat Endpoint: This feature enables users to retrieve gold rates based on carat values. By appending a base to the endpoint, developers can access specific carat pricing, which is vital for jewelers and gold traders.
  • Lowest/Highest Price Endpoint: This endpoint allows users to query the API for the lowest and highest prices of metals over a specified period, providing insights into market extremes.
  • Open/High/Low/Close (OHLC) Price Endpoint: Users can access OHLC data for specific time periods, which is crucial for technical analysis and understanding market behavior.
  • Historical LME Endpoint: This endpoint provides access to historical rates for LME symbols dating back to 2008, allowing for comprehensive analysis of metal prices over an extended period.
  • API Key: Each user is assigned a unique API key that must be included in requests to authenticate access to the API.
  • API Response: The exchange rates delivered by the Metals-API are relative to USD by default, ensuring consistency in data interpretation.
  • Available Endpoints: The Metals-API comprises 14 endpoints, each offering distinct functionalities to cater to various user needs.
  • Supported Symbols Endpoint: This endpoint provides a constantly updated list of all available currencies and metals, ensuring users have access to the latest information.

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. This resource is invaluable for developers looking to integrate specific metals into their applications.

API Endpoint Examples and Responses

Latest Rates Endpoint

Get real-time exchange rates for all available metals:

{
"success": true,
"timestamp": 1784592816,
"base": "USD",
"date": "2026-07-21",
"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"
}

Historical Rates Endpoint

Access historical exchange rates for any date since 1999:

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

Time-series Endpoint

Get exchange rates for a specific time period:

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

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": 1784592816,
"rate": 0.000482
},
"result": 0.482,
"unit": "troy ounces"
}

Fluctuation Endpoint

Track rate fluctuations between two dates:

{
"success": true,
"fluctuation": true,
"start_date": "2026-07-14",
"end_date": "2026-07-21",
"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"
}

OHLC (Open/High/Low/Close) Endpoint

Get OHLC data for a specific time period:

{
"success": true,
"timestamp": 1784592816,
"base": "USD",
"date": "2026-07-21",
"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"
}

Bid/Ask Endpoint

Get current bid and ask prices for metals:

{
"success": true,
"timestamp": 1784592816,
"base": "USD",
"date": "2026-07-21",
"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"
}

Conclusion

In conclusion, the Metals-API provides a comprehensive suite of tools for developers looking to access historical prices and real-time data for the abrdn Physical Gold Shares ETF (SGOL) and other precious metals. By leveraging the API's various endpoints, developers can create applications that offer valuable insights into market trends and price movements. The ability to access detailed historical data, real-time rates, and fluctuations empowers users to make informed trading decisions.

For those interested in exploring the capabilities of the Metals-API further, the Metals-API Documentation is an essential resource. Additionally, the Metals-API Supported Symbols page provides a comprehensive list of available metals and currencies. By integrating these tools into their applications, developers can harness the power of real-time metals data to enhance their trading strategies and investment analyses.

Ready to use Metals-API?

Try it now!

Search

Related Posts

Recent Posts