Get Vijayawada Gold 18k (VIJA-18k) Historical Prices to analyze trends using this API

Introduction

In the world of finance and investment, gold (XAU) has always held a significant position as a safe haven asset. Understanding the historical prices of gold is crucial for investors and traders looking to analyze trends and make informed decisions. With the advent of technology, accessing this data has become easier than ever, thanks to APIs like Metals-API. This blog post will delve into the capabilities of Metals-API, focusing on how to retrieve historical prices for 18k gold (VIJA-18k) and analyze trends effectively.

About Gold (XAU)

Gold has been a symbol of wealth and prosperity for centuries. 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 prices. The integration of data analytics and technology has paved the way for innovative solutions in price discovery and trading.

With the rise of digital asset solutions, investors can now leverage real-time data to make informed decisions. The Metals-API provides developers with the tools necessary to build next-generation applications that can analyze gold trends, track price fluctuations, and convert currencies seamlessly.

Metals-API Overview

The Metals-API is a powerful tool that offers real-time and historical data for various metals, including gold. It empowers developers to create applications that can access comprehensive market insights and analytics. The API supports multiple endpoints, each designed to provide specific functionalities that cater to different needs.

For instance, the Latest Rates Endpoint allows users to retrieve real-time exchange rate data for gold and other metals. Depending on the subscription plan, this data can be updated every 60 minutes or even every 10 minutes. This feature is particularly useful for traders who require up-to-the-minute information to make quick decisions.

Another significant feature is the Historical Rates Endpoint, which provides access to historical rates dating back to 2019. By appending a specific date to the API request, users can obtain historical price data for gold, enabling them to analyze trends over time.

Key Features and Endpoints

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

Latest Rates Endpoint

The Latest Rates Endpoint returns real-time exchange rate data for metals, including gold. This endpoint is essential for traders who need immediate access to current market prices. The response includes a timestamp, base currency, and rates for various metals.

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

The Historical Rates Endpoint allows users to access historical exchange rates for any date since 1999. This feature is invaluable for conducting trend analysis and understanding how gold prices have fluctuated over time.

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

Bid And Ask Endpoint

The Bid and Ask Endpoint provides real-time bid and ask prices for metals. This feature is crucial for traders who need to understand the market spread and make informed trading decisions.

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

Convert Endpoint

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

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

Time-Series Endpoint

The Time-Series Endpoint allows users to query the API for daily historical rates between two dates of their choice. This feature is essential for analyzing trends over specific periods.

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

Fluctuation Endpoint

The Fluctuation Endpoint provides information about how currencies fluctuate on a day-to-day basis. This feature is crucial for understanding market volatility and making informed trading decisions.

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

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

The OHLC Price Endpoint allows users to query the API for the open, high, low, and close prices for a specific time period. This data is essential for technical analysis and understanding market trends.

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

Lowest/Highest Price Endpoint

The Lowest/Highest Price Endpoint allows users to query the API to get the lowest and highest price for a specified date. This feature is particularly useful for identifying price extremes and making strategic trading decisions.

{
"success": true,
"timestamp": 1784852093,
"base": "USD",
"date": "2026-07-24",
"rates": {
"XAU": {
"lowest": 0.000481,
"highest": 0.000487
}
},
"unit": "per troy ounce"
}

Authentication and API Key

To access the Metals-API, users must obtain an API key, which is a unique identifier passed into the API base URL's access_key parameter. This key is essential for authenticating requests and ensuring secure access to the API's features.

Practical Use Cases

Developers can leverage the Metals-API in various applications, ranging from trading platforms to financial analysis tools. For instance, a trading application could utilize the Latest Rates Endpoint to display real-time gold prices, while the Historical Rates Endpoint could be used to generate reports on price trends over specific periods.

Additionally, financial analysts can use the Time-Series Endpoint to analyze price movements and make predictions based on historical data. The ability to convert currencies seamlessly allows users to assess their investments in different markets, enhancing their decision-making capabilities.

Conclusion

In conclusion, the Metals-API offers a comprehensive suite of tools for accessing and analyzing gold prices. With features like real-time rates, historical data, and various endpoints for specific functionalities, developers can create powerful applications that cater to the needs of investors and traders. By utilizing the API effectively, users can gain valuable insights into market trends and make informed decisions based on accurate data.

For more information on how to utilize the Metals-API, refer to the Metals-API Documentation and explore the Metals-API Supported Symbols for a complete list of available metals. The transformative potential of real-time metals data is at your fingertips, enabling you to stay ahead in the dynamic world of precious metals trading.