Steps to Fetch abrdn Physical Gold Shares ETF (SGOL) Historical Prices with this API

Introduction

In the world of finance, tracking the historical prices of assets like the abrdn Physical Gold Shares ETF (SGOL) is crucial for investors and analysts alike. With the advent of APIs, fetching this data has become more streamlined and efficient. One such powerful tool is the Metals-API, which provides real-time and historical data on precious metals, including gold. This blog post will guide you through the steps to fetch SGOL historical prices using the Metals-API, while also exploring the innovative features and capabilities of this API.

Understanding Gold and Its Market Dynamics

Gold, represented as XAU in trading, has long been a safe haven for investors. Its value is influenced by various factors including market demand, geopolitical stability, and economic indicators. In recent years, the digital transformation in precious metals trading has revolutionized how investors access and analyze gold data. This transformation is powered by data analytics and market insights, enabling traders to make informed decisions based on real-time information.

Moreover, technology integration in trading platforms has enhanced the price discovery process, allowing for more accurate valuations. The Metals-API plays a pivotal role in this ecosystem by providing developers with the tools necessary to build next-generation applications that can leverage real-time metals data for innovative solutions.

API Overview

The Metals-API is designed to deliver comprehensive and accurate data on various metals, including gold, silver, platinum, and palladium. It empowers developers to create applications that can fetch real-time rates, historical prices, and other essential metrics. The API is equipped with multiple endpoints, each serving a unique purpose, making it a versatile tool for financial analysis.

For detailed information on how to implement the API, refer to the Metals-API Documentation. This resource provides in-depth guidance on the various features and functionalities available.

Key Features of Metals-API

The Metals-API offers a range of endpoints that cater to different data needs. Here are some of the key features:

Latest Rates Endpoint

The Latest Rates Endpoint provides real-time exchange rate data for metals. Depending on your subscription plan, this endpoint can return data updated every 60 minutes or even more frequently. This feature is essential for traders who need to make quick decisions based on the latest market conditions.

{
"success": true,
"timestamp": 1775261940,
"base": "USD",
"date": "2026-04-04",
"rates": {
"XAU": 0.000482,
"XAG": 0.03815,
"XPT": 0.000912,
"XPD": 0.000744
},
"unit": "per troy ounce"
}

Historical Rates Endpoint

Accessing historical rates is crucial for analyzing trends over time. The Historical Rates Endpoint allows users to retrieve data dating back to 2019. By appending a specific date to the API request, you can obtain historical prices for SGOL and other metals.

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

Bid and Ask Endpoint

The Bid and Ask Endpoint provides real-time bid and ask prices for metals, which is vital for traders looking to execute buy or sell orders. This feature allows users to gauge market sentiment and make informed trading decisions.

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

Convert Endpoint

The Convert Endpoint allows users to convert amounts from one metal to another or to/from USD. This feature is particularly useful for investors who want to understand the value of their holdings in different currencies.

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

Time-Series Endpoint

The Time-Series Endpoint enables users to query daily historical rates between two specified dates. This is particularly useful for analyzing price movements over a defined period, allowing traders to identify trends and make predictions.

{
"success": true,
"timeseries": true,
"start_date": "2026-03-28",
"end_date": "2026-04-04",
"base": "USD",
"rates": {
"2026-03-28": {
"XAU": 0.000485,
"XAG": 0.03825
},
"2026-04-04": {
"XAU": 0.000482,
"XAG": 0.03815
}
},
"unit": "per troy ounce"
}

Fluctuation Endpoint

The Fluctuation Endpoint allows users to track how metal prices fluctuate between two dates. This feature is essential for understanding market volatility and making informed trading decisions.

{
"success": true,
"fluctuation": true,
"start_date": "2026-03-28",
"end_date": "2026-04-04",
"base": "USD",
"rates": {
"XAU": {
"start_rate": 0.000485,
"end_rate": 0.000482,
"change": -3.0e-6,
"change_pct": -0.62
}
},
"unit": "per troy ounce"
}

Open/High/Low/Close (OHLC) Price Endpoint

The OHLC Price Endpoint provides open, high, low, and close prices for a specific time period. This data is crucial for technical analysis and helps traders understand market trends.

{
"success": true,
"timestamp": 1775261940,
"base": "USD",
"date": "2026-04-04",
"rates": {
"XAU": {
"open": 0.000485,
"high": 0.000487,
"low": 0.000481,
"close": 0.000482
}
},
"unit": "per troy ounce"
}

Security and Best Practices

When using the Metals-API, it is essential to follow best practices for security and performance. Ensure that your API key is kept confidential and not exposed in public repositories. Implement rate limiting to avoid exceeding your quota and causing service interruptions. Additionally, consider caching frequently accessed data to improve performance and reduce the number of API calls.

Practical Use Cases

Developers can leverage the Metals-API for various applications, including:

• Investment Analysis: Use historical data to analyze trends and make informed investment decisions regarding SGOL.
• Market Research: Integrate real-time data into research platforms to provide users with up-to-date information on precious metals.
• Trading Bots: Create automated trading systems that utilize real-time and historical data to execute trades based on predefined strategies.

Conclusion

Fetching historical prices for the abrdn Physical Gold Shares ETF (SGOL) has never been easier, thanks to the capabilities of the Metals-API. By utilizing its various endpoints, developers can access real-time and historical data, enabling them to make informed decisions in the precious metals market. The API's innovative features, such as the Latest Rates, Historical Rates, and OHLC Price endpoints, provide a comprehensive toolkit for financial analysis.

For more information on the API's features, visit the Metals-API Supported Symbols page, and explore the extensive Metals-API Documentation for detailed implementation guidance. With the right tools and knowledge, you can harness the power of real-time metals data to enhance your trading strategies and investment decisions.