問與答和使用教學(Chinese)

常見問題

Q: 如何下傳交易紀錄?

官方網站，手機或是 iPad app 無法下傳

  1. 先登入，左上角選擇 Menu -> Accounts -> Transaction History Transaction History
  2. 左上角點選下傳的圖示，之後選擇 csv 格式 Download

Q: 歷史交易紀錄只剩下最近四年或有多個歷史交易數據，可以使用嗎？

A. 只有近四年的歷史資料 可以直接使用，但是轉換後的數據會不一定正確，如何修改數據請看這裡

B. 多個歷史交易數據 Schwab 只能提供最近四年的歷史資料，超過四年的歷史數據需要分開多個檔案，假設已經下傳兩個檔案分別是

  1. 2021-01-01到2023-06-30
  2. 2021-07-01到2025-07-02

可以直接使用兩個檔案，不需要做任何修改，在轉換的時候系統會自動判斷重複交易數據。 只有一種情況可能會導致交易數據被刪除，交易日期、交易股票、交易類別、交易金額、交易數量，以上五個數據全部相同的時候，有多筆的數據會被刪除。

Q: 當只有部分交易紀錄時該如何處理？

找個時間點將數據整理過！數據需要符合以下規則，

  1. 提供的歷史交易數據，需要每支股票都有買賣數據
  2. 起始金額（沒有提供會自己估算）

假設歷史交易數據如下

"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"07/27/2021","Sell","X","TDA TRAN - Sold 10 (X) @23.4500","10","$23.45","","$234.50"
"07/23/2021","Sell","X","TDA TRAN - Sold 20 (X) @22.9000","20","$22.90","","$458.00"

A. 方法一：刪除法

  1. 刪除缺少的交易紀錄 X 股票只有賣出，缺少了買入紀錄所以將賣出的記錄全部刪除。
  2. 加入一筆餘額紀錄，餘額紀錄就是日期為 01/25/2021 這筆數據，交易類別 Action 填寫 Wire Received, Amount 填寫當天的餘額
"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"01/25/2021","Wire Received","","TDA TRAN - WIRE INCOMING","","","","$10000.00"

B. 方法二：加入法

自己加入買賣紀錄，股票代碼、數量、價格、總金額

  1. X 股票賣出 30 股，所以加入一個買入紀錄 X 股票買入 30 股, 價格 $20.00, 總金額 $600.00。
  2. 加入一筆餘額紀錄，餘額紀錄就是日期為 01/25/2021 這筆數據，交易類別 Action 填寫 Wire Received, Amount 填寫當天的餘額
"Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"
"03/04/2022","Buy","TSM","TDA TRAN - Bought 3 (TSM) @104.0000","3","$104.00","","-$312.00"
"07/27/2021","Sell","X","TDA TRAN - Sold 10 (X) @23.4500","10","$23.45","","$234.50"
"07/23/2021","Sell","X","TDA TRAN - Sold 20 (X) @22.9000","20","$22.90","","$458.00"
"06/01/2021","Buy","X","TDA TRAN - Bought 30 (X)","30","$20.00","","$600.00"
"01/25/2021","Wire Received","","TDA TRAN - WIRE INCOMING","","","","$10000.00"