【コインチェック】確定申告を効率的に！Pythonで仮想通貨収益を自動計算

pip install pandas

# =====================================================================================
# データ読込
# =====================================================================================

import pandas as pd

# コインチェックの取引明細取得
data = pd.read_csv("./Coincheck.csv")

# =====================================================================================
# データ加工
# =====================================================================================

# データ加工
df = pd.DataFrame()

BuySellList = []  # 売買区分
RateList    = []  # 約定レート

for i in range(len(data)):
    
    # 売買区分の算出
    if data["trading_currency"][i] == "JPY" and data["amount"][i] < 0:
        BuySellList.append("買")
    elif data["trading_currency"][i] != "JPY" and data["amount"][i] > 0:
        BuySellList.append("買")
    else:
        BuySellList.append("売")
        
    # 約定レートの算出
    try:
        Rate = float(data["comment"][i].split(",")[0].replace("Rate: ",""))
        RateList.append(Rate)
    except AttributeError:
        RateList.append(0)


# =====================================================================================
# データ加工（レコード）
# =====================================================================================

# カラム
df["日付"]      = data["time"]
df["注文タイプ"] = data["operation"].replace("Limit Order","指値注文").replace("Market Order","成行注文").replace("Completed trading contracts","約定")    
df["取引通貨"] = data["trading_currency"]
df["売買区分"] = BuySellList         
df["数量"] = data["amount"]
df["取引金額[円]"] = data["amount"]
df["約定レート"] = RateList

# 数量・合計金額の加工
for i in range(len(df)):
    if df["取引通貨"][i] == "JPY":
        df["取引金額[円]"][i] = df["数量"][i]
        df["数量"][i] = df["数量"][i] / df["約定レート"][i]
    else:
        df["取引金額[円]"][i]  = df["数量"][i] * df["約定レート"][i]

# レコード抽出
df = df[df["注文タイプ"] == "約定"].reset_index()
del df["注文タイプ"]
del df["index"]

# レコード日付の昇順でソート
df.sort_values("日付", ascending=True, inplace=True)

# 出力イメージ
#    日付                          注文タイプ 売買区分    通貨ペア 取引通貨     数量   約定レート
# 0  2022-05-05 19:49:01 +0900    約定        買      btc_jpy    BTC      0.005  5130798.0
# 1  2022-05-05 19:49:01 +0900    約定        買      btc_jpy    BTC      0.005  5130807.0
# 2  2022-05-05 23:40:12 +0900    約定        売      btc_jpy    JPY  49981.320  4998132.0
# 3  2022-05-11 21:19:54 +0900    約定        買      btc_jpy    BTC      0.005  4094000.0
# 4  2022-05-11 21:20:01 +0900    約定        買      btc_jpy    BTC      0.015  4094000.0
# 5  2022-09-19 10:44:51 +0900    約定        売      btc_jpy    JPY  13913.340  2782668.0

# 購入したBTCから平均単価を算出
buy_mean_yen = df["取引金額[円]"][df["売買区分"]=="買"].sum() / len(df["取引金額[円]"][df["売買区分"]=="買"])

# 売却したBTCの収益計算[円]
sell_sum_yen = df["取引金額[円]"][df["売買区分"]=="売"].sum()   # 売却金額合計[円]
sell_sum_btc = df["数量"][df["売買区分"]=="売"].sum()          # 取引数量[BTC]
profit       = sell_sum_yen - (buy_mean_yen * sell_sum_btc)  # 損益

# 出力
print(f'通年収益：{profit} 円')

# 出力イメージ
# 通年収益：63,395 円