×
Process Account Statement with ChatGPT
Use the following optimized prompt with ChatGPT to convert your broker account statement into the journal-friendly format:
**Optimized Prompt for ChatGPT:**
I have a broker account statement containing my trading activities. Please extract each completed trade, calculate the profits and losses, and format them in the following structure with fields separated by |:
Status | Stock | Position | Strategy | Entry Date | Exit Date | Entry Price | Position Size | Stop Loss | Exit Price | Commissions | Buy Amount | Sell Amount | Gross P&L | Net P&L | Net % | Comments
**Instructions:**
1. Copy the above prompt.
2. Open ChatGPT and paste the prompt.
3. Replace `[Insert your account statement here]` with your actual account statement.
4. Execute the prompt to receive the formatted trade data.
5. Copy the resulting data and paste it into the "Add Trade(s) via ChatGPT Format" textarea in your Trade Journal.
6. Click "Add Trade(s)" to import the trades into your journal.
**Example:**
**Input Account Statement:**
Date | Stock | Action | Quantity | Price | Commission | Total
01/01/2024 | AAPL | Buy | 100 | 150 | 10 | 15010
05/01/2024 | AAPL | Sell | 100 | 170 | 10 | 17010
02/01/2024 | AAPL | Short | 50 | 150 | 3 | 7503
06/01/2024 | AAPL | Cover | 50 | 140 | 3 | 7003
**Expected ChatGPT Output:**
WIN | AAPL | Long | Buy/Sell | 1 Jan 2024 | 5 Jan 2024 | 150.00 | 100 | 145.00 | 170.00 | 10.00 | 15000.00 | 17000.00 | 2000.00 | 1990.00 | 13.27% | Profitable trade due to price increase.
LOSS | AAPL | Short | Cover | 2 Jan 2024 | 6 Jan 2024 | 150.00 | 50 | 155.00 | 140.00 | 3.00 | 7500.00 | 7000.00 | -500.00 | -503.00 | -6.73% | Loss incurred from price decline.
Once you have the formatted data, paste it into the textarea and click "Add Trade(s)" to import the trades into your journal.
After obtaining the formatted data, paste it into the textarea above and click "Add Trade(s)" to import the trades into your journal.