014: Data Import (Part 2)
Below are header samples with a few lines of the raw (Account field was added) .csv file to give you guidance. Each header used here worked at the time of document creation. Try using the headers below as a starting point, remember to test it by replacing the account number with your test account (9999)
FIDELITY:
account,Run Date,Action,Symbol,Description,Type,Quantity,Price ($),Commission ($),Fees ($),Accrued Interest ($),Amount ($),Cash Balance ($),Settlement Date
FID789,Dec-31-2021," REINVESTMENT FIDELITY GOVERNMENT MONEY MARKET (SPAXX) (Cash)", SPAXX," FIDELITY GOVERNMENT MONEY MARKET",Cash,0.09,1,,,,-0.09,14775.10,
FID789,Dec-31-2021," DIVIDEND RECEIVED FIDELITY GOVERNMENT MONEY MARKET (SPAXX) (Cash)", SPAXX," FIDELITY GOVERNMENT MONEY MARKET",Cash,0.000,,,,,0.09,14775.10,
FID789,Dec-31-2021," YOU SOLD MARATHON DIGITAL HOLDINGS INC COM (MARA) (Cash)", MARA," MARATHON DIGITAL HOLDINGS INC COM",Cash,-200,32.92,,0.04,,6584.02,14775.01,Jan-04-2022
FID789,Dec-27-2021," EXPIRED CALL (AAPL) APPLE INC DEC 23 21 $182.5 as of Dec-23-2021 CALL (AAPL) APPLE INC DEC 23 21 $182.5 (100 SHS) (Cash)", -AAPL211223C182.5," CALL (AAPL) APPLE INC DEC 23 21 $182.5 (100 SHS)",Cash,2,,,,,0.00,8190.99,
FID789,Dec-23-2021," DIVIDEND RECEIVED NVIDIA CORPORATION COM (NVDA) (Cash)", NVDA," NVIDIA CORPORATION COM",Cash,0.000,,,,,8,8190.99,
FID789,Dec-15-2021," YOU SOLD OPENING TRANSACTION CALL (AAPL) APPLE INC DEC 23 21 $182.5 (100 SHS) (Cash)", -AAPL211223C182.5," CALL (AAPL) APPLE INC DEC 23 21 $182.5 (100 SHS)",Cash,-2,1.2,1.FID789,0.05,,238.65,8182.99,Dec-16-2021
ROBINHOOD:
"Account","Activity Date","Process Date","Settle Date","Instrument","Description","Trans Code","Quantity","Price","Amount"
"2222","7/31/2020","7/31/2020","8/4/2020","HOME","At Home CUSIP: 04650Y100","Buy","200","$12.35","($2,470.00)"
"2222","7/31/2020","7/31/2020","8/4/2020","PDD","PDD Holdings CUSIP: 722304102","Buy","100","$90.26","($9,026.45)"
"2222","7/31/2020","7/31/2020","8/4/2020","XLK","Technology Select Sector SPDR CUSIP: 81369Y803","Sell","100","$109.06","$10,905.74"
E-TRADE:
account,Trade Date,Order Type,Security,Cusip,Transaction Description,Quantity,Executed Price,Commission,Net Amount
1234,4/18/2023,Sell,BROS,097023105,dutch brothers CO UNSOLICITED TRADE,60,260.5,0.01,1177.49
1234,4/18/2023,Sell,C,172967424,CITIGROUP INC NEW UNSOLICITED TRADE,260,49,0.01,734.99
1234,10/2/2023,Buy,BROS,097023105,dutch brothers CO UNSOLICITED TRADE,60,290,0.0000,950
1234,6/13/2023,Sell,F,097023105,ford CO UNSOLICITED TRADE,48,248.5,0.01,1177.49
1234,6/13/2023,Sell,C,172967424,CITIGROUP INC NEW UNSOLICITED TRADE,248,49,0.01,734.99
WEBULL:
account,Name,Symbol,Side,Status,Filled,Total Qty,Price,Avg Price,Time-in-Force,Placed Time,Filled Time
WB343434,CRWD 08/30/2024 00:00:00 EDT Call $290.00,CRWD240830C00290000,Sell,Cancelled,0,2,@10.00,,DAY,08/23/2024 10:14:30 EDT,
WB343434,ARM 08/30/2024 00:00:00 EDT Call $140.00,ARM240830C00140000,Sell,Filled,1,1,@3.50,3.50,DAY,08/23/2024 10:12:21 EDT,08/23/2024 10:24:04 EDT
WB343434,PLTR 08/16/2024 00:00:00 EDT $0.00,PLTR 08/16/2024 00:00:00 EDT $0.00,Sell,Filled,20,20,@0.050,0.050,DAY,08/13/2024 09:44:08 EDT,08/13/2024 12:55:51 EDT
WB343434,PLTR 09/20/2024 00:00:00 EDT Call $9.00,PLTR 09/20/2024 00:00:00 EDT Call $9.00,Sell,Filled,20,20,@21.55,21.55,DAY,08/13/2024 09:44:08 EDT,08/13/2024 12:55:51 EDT
WB343434,PLTR 08/16/2024 00:00:00 EDT Call $9.00,PLTR 08/16/2024 00:00:00 EDT Call $9.00,Buy,Filled,20,20,@21.50,21.50,DAY,08/13/2024 09:44:08 EDT,08/13/2024 12:55:51 EDT
WB343434,PLTR 08/16/2024 00:00:00 EDT Call $9.00,PLTR 08/16/2024 00:00:00 EDT Call $9.00,Sell,Filled,20,20,@15.83,15.83,DAY,06/17/2024 13:30:31 EDT,06/17/2024 13:30:31 EDT
WB343434,PLTR 06/21/2024 00:00:00 EDT Call $9.00,PLTR 06/21/2024 00:00:00 EDT Call $9.00,Buy,Filled,20,20,@15.83,15.83,DAY,06/17/2024 13:30:31 EDT,06/17/2024 13:30:31 EDT
Related Articles
013: Data Import (Part 1)
Data import is one of the Stocklog+ superpowers! Brokers may provide CSV files, but no one said they had to be perfectly formatted - and most of them are not! This is why very few brokers or journal applications attempt to import multiple company CSV ...015: Data Import Management Engine (D.I.M.E.)
The absolute best way to achieve nearly perfect imports is to use D.I.M.E. for each broker you import data. Brokers rarely change the format of their CSV files, this gives us a chance to take advantage of having YOU visually inspect the columns to ...008: Trade Details (Part 1)
Using the input from the previous input from 007: Manually Adding Trades, with addition of adding 1 share, we now have three trades. Lets go over the Trading pane details: Info: Multi-use column, can be used to show different statuses of a trade. See ...001: Where to download Stocklog+
Always download files from https://www.xenminds.com to make sure you're receiving the most up-to-date version. Once you're on the download page, choose any location to download the application. All versions are the same, the difference in file size ...010: Trade Details (Part 3)
See 008: Trade Details (Part 1) for the start of this series Using the existing previous trades in Trade Details (007-009), we add the following on 2024-12-05: -1 2024-07-03 TSLA CSP @290 (Sell Cash Secured Put) - Expires Worthless 100 2024-08-01 ...