{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2024"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2024","index":0,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["투자일자","종목명","현재가(달러)","환율","현재가(원)",null,"가상투자금액","매수갯수","실구매갯수",null,null,"종목명",null,"가격조회 클릭"]
["2024-02-07","SCHD",77.28,1334,{"$f":"C2*D2","v":103091.52},null,500000,{"$f":"G2/E2","v":4.8500594423285248},5,null,null,"SCHD",null,"A열 마지막 행 다음행에 오늘일자 2행 넣기"]
["2024-02-07","QQQM",175.18,1334,{"$f":"C3*D3","v":233690.12},null,500000,{"$f":"G3/E3","v":2.1395855331838591},2,null,null,"QQQM",null,"B열에 지정한 종목 넣기(2개)"]
["2024-02-07","SCHD",77.28,1334,103091.52,null,{"$f":"G2*2","v":1000000},{"$f":"G4/E4","v":9.7001188846570496},5,null,null,null,null,"C열에 종목의 현재가(달러) 넣기(크롤링)","함수"]
["2024-02-07","QQQM",175.18,1334,233690.12,null,{"$f":"G3*2","v":1000000},4.2791710663677183,2,null,null,null,null,"D열에 현재 환율 넣기(크롤링)","함수"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E열에 현재가(원화) 넣기(엑셀함수)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"G열에 가상투자금액 넣기\n 앞전 투자금액이 있다면\n   앞전 투자금액 + 맨앞 투자금액으로 세팅","함수"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"H열에 매수갯수 넣기(엑셀함수)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I열에 실구매갯수 넣기\n 매수갯수 - 누적갯수(앞전 실구매갯수 총합)","함수"]