etf/etf.py

# pip install pykrx
# doc https://github.com/sharebook-kr/pykrx?tab=readme-ov-file#22-etx-api
import pykrx
import pandas as pd
from datetime import datetime, timedelta

input_df = pd.read_csv('etf_1.tsv', sep='\t')
# output_df = pd.read_csv('ETF.csv', sep='\t')

for row in input_df.to_dict('records'):

    ticker = row['종목코드']
    today_dt = datetime.now()

    # etf 주가정보
    # df = pykrx.stock.get_etf_ohlcv_by_date(
    #     (today_dt - timedelta(days=30)).strftime('%Y%m%d'),
    #     today_dt.strftime('%Y%m%d'),
    #     ticker
    # )
    # print(df)

    # pdf 정보 -
    df = pykrx.stock.get_etf_portfolio_deposit_file(ticker, today_dt.strftime('%Y%m%d'))
    print(df)

    # etf 투자주체 매매동향
    # df = pykrx.stock.get_etf_trading_volume_and_value(
    #     (today_dt - timedelta(days=30)).strftime('%Y%m%d'),
    #     today_dt.strftime('%Y%m%d'),
    #     ticker
    # )
    # print(df)

    # 저장 필요

    # break