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 | |
|---|---|---|---|---|---|---|---|
| 7620 | 2020-06-08 | 1950.0 | 1725.66 | 1536.04 | 1995.0 | 1765.49 | 1573.96 |
| 7621 | 2020-06-09 | 1968.0 | 1748.56 | 1556.96 | 1960.0 | 1734.51 | 1547.57 |
| 7622 | 2020-06-10 | 1925.0 | 1693.05 | 1508.03 | 1970.0 | 1731.87 | 1540.27 |
| 7623 | 2020-06-11 | 1927.0 | 1693.32 | 1518.52 | 1915.0 | 1685.74 | 1514.43 |
| 7624 | 2020-06-12 | 1945.0 | 1716.68 | 1538.77 | 1935.0 | 1712.39 | 1538.77 |
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')