import pandas as pd

gold = pd.read_csv(
    "gold.txt",
    delim_whitespace=True,
    index_col=0,
    usecols=[0, 1],
    parse_dates=True,
)
snp = pd.read_csv("SNP.csv", parse_dates=True, index_col=0)
btc = pd.read_csv("BTC.csv", parse_dates=True, index_col=0)

gold["holding"] = 100 / gold["Price"]
snp["holding"] = 100 / snp["Open"]
btc["holding"] = 100 / btc["BTC-USD"]

final_date = "2020-07-01"
total_btc = btc["holding"][:final_date].sum()
total_gold = gold["holding"][:final_date].sum()
total_snp = snp["holding"][:final_date].sum()

gold = total_gold * gold.loc[final_date]["Price"]
print(f"Gold investment: USD {gold:,.2f}")
sandp = total_snp * snp.loc[final_date]["Open"]
print(f"S&P investment: USD {sandp:,.2f}")
btc = total_btc * btc.loc[final_date]["BTC-USD"]
print(f"BTC investment: USD {btc:,.2f}")