Weekly palladium price report

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()
DateUSD AMEUR AMGBP AMUSD PMEUR PMGBP PM
76202020-06-081950.01725.661536.041995.01765.491573.96
76212020-06-091968.01748.561556.961960.01734.511547.57
76222020-06-101925.01693.051508.031970.01731.871540.27
76232020-06-111927.01693.321518.521915.01685.741514.43
76242020-06-121945.01716.681538.771935.01712.391538.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')
Close

Meta