Ratios Between Gold, Platinum and Silver

Ratios Between Gold, Platinum and Silver

Ratios between Gold, Platinum and Silver show clear trends. Gold/Silver ratio shows big fluctuations. Platinum/Silver ratio shows a clear downward trend.





    import yfinance as yf
import matplotlib.pyplot as plt
import pandas as pd

dateStart = "2015-01-01"
dateEnd   = "2025-12-31"

tickers = ["GC=F", "SI=F", "PL=F"]  # Gold, Silver, Platinum futures

# yfinanceからまとめて取得（警告回避のため auto_adjust を明示）
df = yf.download(
    tickers,
    start=dateStart,
    end=dateEnd,
    auto_adjust=False,   # True/FalseどちらでもOK。とにかく明示する
    progress=False
)

# dfは MultiIndex columns になりやすい：['Close'] で3銘柄の終値DataFrameが取れる
close = df["Close"].copy()

# 月次平均（pandas警告対応：'M' -> 'ME'）
close_m = close.resample("ME").mean()

# 比率をDataFrameで計算（列名で参照）
ratio = pd.DataFrame({
    "Gold/Silver": close_m["GC=F"] / close_m["SI=F"],
    "Gold/Platinum": close_m["GC=F"] / close_m["PL=F"],
    "Platinum/Silver": close_m["PL=F"] / close_m["SI=F"],
}).dropna()

ax = ratio.plot(figsize=(12, 6))
ax.set_title("Monthly Price Ratios (Futures via Yahoo Finance)")
ax.set_xlabel("Month")
ax.set_ylabel("Ratio")
plt.show()
Location: 日本、東京都

Popular posts from this blog

Difference between Type Stack (S) and Type Queue (Q)

Image
Difference between Type Stack (S) and Type Queue (Q) In this post, I explore the relationship between two learning types—Stack (S) and Queue (Q)—and their outcomes. Here, “Stack” and “Queue” are programming-inspired metaphors: S-type persons learn in a stack-like way, relying on memory, while Q-type persons learn in a queue-like way, relying on an internal image generator. In terms of abstraction, Learning Type (S or Q) is a higher-level concept, Integrated Learning Result is a mid-level concept, and Learning Result is a lower-level concept. For example, we might consider trust as an integrated learning result (a form of social capital), while money can be seen as a measurable outcome derived from that trust. In my code, the parameter b = 0.9 is introduced as an initial-condition bias, reflecting the influence of family inheritance and economic background. The horizontal axis is scaled so that x = 1.0 corresponds to 10 years of life, a scale derived from empirical observation...
Read more

Sin Waves and Cos Waves

Image
 Sin Waves and Cos Waves I wrote some code about Sin waves and Cos waves. I hope you can enjoy this figures. import numpy as np import matplotlib.pyplot as plt # データ生成 x = np.linspace(-3.15, 3.15, 100) y1 = np.sin(x) y2 = -y1 y3 = y1 / 2 y4 = - y3 y5 = y3 / 2 y6 = -y5 y7 = y5 / 2 y8 = -y7 y9 = y7 / 2 y10 = -y9 # グラフ描画 plt.figure(figsize=(8, 6)) plt.plot(x, y1) plt.plot(x, y2) plt.plot(x, y3) plt.plot(x, y4) plt.plot(x, y5) plt.plot(x, y6) plt.plot(x, y7) plt.plot(x, y8) plt.plot(x, y9) plt.plot(x, y10) plt.xlabel("x") plt.ylabel("y") plt.title("Sin Waves") plt.legend() plt.grid(True) plt.show() # データ生成 x = np.linspace(-3.15, 3.15, 100) y1 = np.cos(x) y2 = -y1 y3 = y1 / 2 y4 = - y3 y5 = y3 / 2 y6 = -y5 y7 = y5 / 2 y8 = -y7 y9 = y7 / 2 y10 = -y9 ...
Read more