This weekly palladium price report is based on public Quandl data, provided by http://www.lppm.com
Below table shows opening and closing prices for palladium in the most recent days, considering EUR, USD and GBP currency.
import quandl # setting up API key quandl.ApiConfig.api_key = "wndP9GxCfs2gjAohXsk3" import numpy import pandas # retrieving data from quandl in numpy format, then converting into pandas DataFrame data = pandas.DataFrame(quandl.get('LPPM/PALL', returns="numpy")) data.tail()
| Date | USD AM | EUR AM | GBP AM | USD PM | EUR PM | GBP PM | |
|---|---|---|---|---|---|---|---|
| 7721 | 2020-10-29 | 2233.0 | 1904.48 | 1716.37 | 2206.0 | 1886.28 | 1706.11 |
| 7722 | 2020-10-30 | 2226.0 | 1905.82 | 1718.92 | 2228.0 | 1907.53 | 1718.47 |
| 7723 | 2020-11-02 | 2234.0 | 1919.24 | 1733.13 | 2203.0 | 1894.24 | 1703.79 |
| 7724 | 2020-11-03 | 2251.0 | 1924.75 | 1732.87 | 2301.0 | 1964.99 | 1769.32 |
| 7725 | 2020-11-04 | 2263.0 | 1936.67 | 1744.80 | 2296.0 | 1960.72 | 1767.51 |
Below chart shows palladium daily opening and closing prices during the 5 most recent trading days:
import matplotlib.pyplot as plt plt.figure(figsize = (10,10)) plt.plot(data["Date"].tail(5), data["USD PM"].tail(5),color = "red") plt.plot(data["Date"].tail(5),data["USD AM"].tail(5),color = "blue") plt.title("Daily palladium opening (blue) and closing (red) prices, last 5 trading days",size=22) plt.ylabel("closing price [USD]",size = 16) plt.xlabel("date", size = 16)
Text(0.5, 0, 'date')
Below chart displays a time series plot of palladium closing prices in USD, for the past 300 trading days:
plt.figure(figsize = (10,10))
plt.scatter(data["Date"].tail(300), data["USD PM"].tail(300),color = "red")
plt.plot(data["Date"].tail(300), data["USD PM"].tail(300),color = "blue")
plt.title("Daily palladium closing prices, last 300 trading days",size=22)
plt.ylabel("closing price [USD]",size = 16)
plt.xlabel("date", size = 16)
Text(0.5, 0, 'date')
Below is a time series of palladium closing prices since registered in the LPPM database:
plt.figure(figsize = (10,10))
plt.scatter(data["Date"],data["USD PM"],color="red")
plt.plot(data["Date"], data["USD PM"],color = "blue")
plt.title("Daily palladium closing prices",size=22)
plt.ylabel("closing price [USD]",size = 16)
plt.xlabel("date", size = 16)
Text(0.5, 0, 'date')
