Get Franklin Responsibly Sourced Gold ETF (FGDL) Historical Prices with Metals-API

Metals-API, a powerful tool designed to provide real-time and historical data on various metals, including gold. In this blog post, we will explore the capabilities of Metals-API, particularly focusing on how to retrieve historical prices for gold (XAU) and the innovative features that make this API a valuable resource for developers.

About Gold (XAU)

Metals-API Overview

Metals-API is a comprehensive JSON API that provides access to real-time and historical prices for various metals, including gold, silver, platinum, and palladium. The API is designed to empower developers by offering a wide range of endpoints that cater to different data needs. With a focus on innovation and technological advancement, Metals-API enables users to harness the power of real-time metals data for various applications.

Key Features and Endpoints

Latest Rates Endpoint: Depending on your subscription plan, this endpoint returns real-time exchange rate data updated every 60 minutes, every 10 minutes, or even more frequently. This feature is essential for traders who need to stay updated on market conditions.
Historical Rates Endpoint: Users can access historical rates for most currencies dating back to 2019. By appending a specific date to the API request, developers can retrieve historical prices for gold (XAU) and other metals.
Bid And Ask Endpoint: This powerful feature allows users to retrieve real-time bid and ask prices for metals, providing insights into market liquidity and pricing dynamics.
Convert Endpoint: The Metals-API includes a currency conversion endpoint, enabling users to convert any amount from one currency to another. This is particularly useful for investors dealing with multiple currencies.
Time-Series Endpoint: This endpoint allows users to query the API for daily historical rates between two dates of their choice, making it easier to analyze trends over specific periods.
Fluctuation Endpoint: Users can retrieve information about how currencies fluctuate on a day-to-day basis, which is crucial for understanding market volatility.
Carat Endpoint: This feature provides information about gold rates by carat, allowing users to access detailed pricing based on purity.
Lowest/Highest Price Endpoint: Users can query the API to get the lowest and highest prices for a specified date, helping investors identify price extremes.
Open/High/Low/Close (OHLC) Price Endpoint: This endpoint provides open, high, low, and close prices for a specific date, offering a comprehensive view of market performance.
Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008, which is beneficial for users interested in long-term trends.
API Key: Each user is assigned a unique API key that must be included in API requests to authenticate access.
API Response: The exchange rates delivered by Metals-API are relative to USD by default, ensuring consistency in data interpretation.
Supported Symbols Endpoint: This endpoint provides a constantly updated list of all available currencies and metals, ensuring users have access to the latest information.
Gold Price India Endpoint: Retrieve the latest gold price in India using this dedicated endpoint, which is particularly useful for investors in the Indian market.
News Endpoint: Stay updated with the latest news articles related to various metals, providing context to market movements.

API Endpoint Examples and Responses

Latest Rates Endpoint

{
    "success": true,
    "timestamp": 1742083666,
    "base": "USD",
    "date": "2025-03-16",
    "rates": {
        "XAU": 0.000482,
        "XAG": 0.03815,
        "XPT": 0.000912,
        "XPD": 0.000744
    },
    "unit": "per troy ounce"
}

Historical Rates Endpoint

{
    "success": true,
    "timestamp": 1741997266,
    "base": "USD",
    "date": "2025-03-15",
    "rates": {
        "XAU": 0.000485,
        "XAG": 0.03825,
        "XPT": 0.000915,
        "XPD": 0.000748
    },
    "unit": "per troy ounce"
}

Time-Series Endpoint

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

Convert Endpoint

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

Fluctuation Endpoint

{
    "success": true,
    "fluctuation": true,
    "start_date": "2025-03-09",
    "end_date": "2025-03-16",
    "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) Price Endpoint

{
    "success": true,
    "timestamp": 1742083666,
    "base": "USD",
    "date": "2025-03-16",
    "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

{
    "success": true,
    "timestamp": 1742083666,
    "base": "USD",
    "date": "2025-03-16",
    "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

Metals-API Documentation for detailed information on each endpoint and its functionalities. Additionally, you can find a complete list of supported symbols at the Metals-API Supported Symbols page. By harnessing the power of Metals-API, developers can unlock new possibilities in the world of precious metals trading and investment.

Ready to use Metals-API?

Try it now!

Get Franklin Responsibly Sourced Gold ETF (FGDL) Historical Prices with Metals-API