Using Metals-API to Get NAGP-22k Historical Prices for Financial Models

Introduction

Metals-API. This powerful API allows developers to integrate comprehensive metal pricing data into their applications, enabling them to build advanced financial models and analytics tools. In this blog post, we will explore how to use Metals-API to get historical prices for NAGP-22k, focusing on Molybdenum (MO) and its significance in the market.

Metals-API Information

About Molybdenum (MO)

API Description

Metals-API Documentation. This resource provides comprehensive guidance on the various endpoints, their functionalities, and how to implement them effectively.

Key Features and Endpoints

• Latest Rates Endpoint: This endpoint provides real-time exchange rate data for metals, updated every 60 minutes, every 10 minutes, or more frequently, depending on your subscription plan. This feature is essential for applications that require up-to-the-minute pricing information.
• Historical Rates Endpoint: Access historical rates for most metals dating back to 2019. By appending a specific date to the API request, developers can retrieve historical price data, which is crucial for financial modeling and analysis.
• 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 API includes a currency conversion endpoint, enabling users to convert amounts between different metals or to/from USD. This is particularly useful for applications that require multi-metal pricing.
• Time-Series Endpoint: Developers can query the API for daily historical rates between two dates of their choice, allowing for in-depth analysis of price trends over specific periods.
• Fluctuation Endpoint: This endpoint provides information on how metal prices fluctuate on a day-to-day basis, helping users understand market volatility.
• Carat Endpoint: Retrieve information about gold rates by carat, which is essential for jewelers and gold traders.
• Lowest/Highest Price Endpoint: This feature allows users to query the API to get the lowest and highest prices for a specific metal over a defined period.
• Open/High/Low/Close (OHLC) Price Endpoint: This endpoint provides open, high, low, and close prices for a specific time period, which is vital for technical analysis.
• Historical LME Endpoint: Access historical rates for LME symbols dating back to 2008, which is crucial for traders and analysts focusing on LME metals.
• API Key: Each user is provided with a unique API key that must be included in API requests to authenticate and authorize access.
• API Response: The API delivers exchange rates relative to USD by default, with all data returned in a structured JSON format.
• Available Endpoints: The Metals-API offers numerous endpoints, each providing different functionalities tailored to user needs.
• Supported Symbols Endpoint: This endpoint returns a constantly updated list of all available metal symbols, ensuring users have access to the most current information.
• Gold Price India Endpoint: Retrieve the latest gold price in India using this dedicated endpoint, which is particularly useful for regional traders.
• News Endpoint: Access the latest news articles related to various metals, keeping users informed about market developments.

List of Symbols

Metals-API Supported Symbols page.

API Endpoint Examples and Responses

Latest Rates Endpoint

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

{
    "success": true,
    "timestamp": 1742170258,
    "base": "USD",
    "date": "2025-03-17",
    "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-11",
    "end_date": "2025-03-18",
    "base": "USD",
    "rates": {
        "2025-03-11": {
            "XAU": 0.000485,
            "XAG": 0.03825,
            "XPT": 0.000915
        },
        "2025-03-13": {
            "XAU": 0.000483,
            "XAG": 0.0382,
            "XPT": 0.000913
        },
        "2025-03-18": {
            "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": 1742256658,
        "rate": 0.000482
    },
    "result": 0.482,
    "unit": "troy ounces"
}

Fluctuation Endpoint

{
    "success": true,
    "fluctuation": true,
    "start_date": "2025-03-11",
    "end_date": "2025-03-18",
    "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

{
    "success": true,
    "timestamp": 1742256658,
    "base": "USD",
    "date": "2025-03-18",
    "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": 1742256658,
    "base": "USD",
    "date": "2025-03-18",
    "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 guidance on implementation and usage. Additionally, the Metals-API Supported Symbols page provides a complete list of available metal symbols, ensuring you have the information you need at your fingertips.