IBKR Yield Farming

Step 1: Create a Flex Query

1. Go to Reports → Flex Queries
2. Click Create (Activity Flex Query)
3. Give it a name like “MTD interest accrual by day”
4. Under sections, find Interest Accruals and click it
5. Select these fields: Currency, From Date, To Date, Interest Accrued, Ending Accrual Balance
6. Save and go back to the main Flex Query config
7. Set Format to CSV
8. Set Period to Month to Date
9. Turn Breakout by Day to Yes
10. Turn Include column headers to Yes
11. Save the query

Step 2: Download the CSV

1. Go to Reports → Flex Queries
2. Find the query you just created and click Run
3. Download the CSV and drop it above