2 ms·
Dropped my CSV into ChatGPT with the following prompt and the output file worked: ``` Modify this csv to match this format: Follow these steps to import your
by Ninjinka 2y ago
Dropped my CSV into ChatGPT with the following prompt and the output file worked:
```
Modify this csv to match this format:
Follow these steps to import your account activities from a CSV file:
Ensure your CSV file is in the correct format.
Columns should include Date, Symbol, Quantity, Activity Type, Unit Price, Currency, and Fee.
Click the 'Import' button and select your CSV file.
Review the imported activities before confirming.
Supported Activity Types:
BUY
SELL
DIVIDEND
INTEREST
DEPOSIT
WITHDRAWAL
TRANSFER_IN
TRANSFER_OUT
CONVERSION_IN
CONVERSION_OUT
FEE
TAX
Example CSV format:
date,symbol,quantity,activityType,unitPrice,currency,fee
2024-01-01T15:02:36.329Z,MSFT,1,DIVIDEND,57.5,USD,0
2023-12-15T15:02:36.329Z,MSFT,30,BUY,368.6046511627907,USD,0
2023-08-11T14:55:30.863Z,$CASH-USD,600.03,DEPOSIT,1,USD,0
```
Except it couldn't find the symbol `BRK/B`, `BRK.B` or `BRKB`.