Importing from Your Broker
1ndexed supports importing transactions from several popular brokers and formats. The goal is to make data entry as effortless as possible — in most cases, you can go from broker export to fully tracked portfolio in under a minute.
MyInvestor users can export their transaction history as an Excel file from the Inversis platform. Navigate to your transaction history, select the date range (we recommend choosing the maximum range to capture your full history), and export to Excel. Then upload the file in 1ndexed and the importer will parse all supported operation types automatically.
Interactive Brokers users should use the Flex Query system to generate a CSV Activity Report. Create a Flex Query in Account Management, select the trade columns (including Symbol, Date/Time, Quantity, Price, and others), and export to CSV. Upload this file and 1ndexed handles the rest.
Indexa Capital users can connect directly via API. Generate an API token from your Indexa settings page, enter it in 1ndexed, and select which accounts to synchronize. Transactions will be imported automatically.
For other brokers, you can use the Generic CSV import format. Prepare a CSV file with columns for date, ISIN, operation type, shares, price, and optionally market (MIC code) and name. This flexible format works with any broker as long as you can export or compile your transaction data.
Supported Operation Types
Different brokers use different terminology for the same operations. 1ndexed normalizes all transaction types into a consistent set of operations so your portfolio analytics work correctly regardless of the data source.
The core operation types are Buy and Sell, which represent standard market purchases and sales of assets. These are the most common transaction types and are supported across all import formats.
Fund-specific operations include Subscription (buying fund units) and Refund (redeeming fund units). These are common in Spanish and European fund platforms. Switch In and Switch Out represent fund-to-fund transfers where you move money between funds within the same platform.
Transfer In and Transfer Out cover asset movements between different accounts or brokers. These are important for tracking cost basis correctly when you move holdings between institutions.
Pension-specific contributions (such as MyInvestor's "Aportacion PP") are also supported for tracking pension plan investments.
Certain broker line items are intentionally skipped during import, including dividends, interest payments, cash movements, fees, and corporate actions. These do not represent portfolio position changes and are excluded to keep your transaction history clean and focused on actual investment decisions.
Managing Your Transaction History
After importing or manually entering transactions, you have full control to edit, delete, or clone any transaction in your history.
To edit a transaction, find it in your transaction list and click the edit icon. You can modify any field including the date, number of shares, price, or operation type. This is useful for correcting data entry errors or adjusting values that were not parsed correctly from a broker export.
Cloning a transaction creates a copy with the same details, which you can then modify. This is handy when you have recurring investments — clone a previous transaction, update the date and price, and save.
Deleting transactions removes them permanently from your portfolio history. All dependent calculations (performance, allocation, cost basis) are recalculated automatically. You can delete individual transactions or select multiple transactions for bulk deletion.
You can also export your complete transaction history as a CSV file for backup purposes or for use in other tools and spreadsheets.
Stock Splits and Reverse Splits
When a company performs a stock split, the number of shares you own increases proportionally without changing your total cost basis. A 10-for-1 split, for example, turns 40 shares at €5,000 each into 400 shares at €500 each — total invested stays the same.
To record a split manually, choose "Stock Split" as the operation type, pick the affected security, and enter the ratio. For a 10-for-1 forward split enter 10; for a 1-for-10 reverse split enter 10 as the consolidation ratio with "Reverse Stock Split". 1ndexed will compute the share delta from your holdings as of the split date.
Splits do not move money in or out of your portfolio, so MWR and TWR are unaffected. Average cost per share is recomputed automatically because total cost stays constant while share count changes.
When importing from Interactive Brokers, configure your Flex Query to include the Corporate Actions section. Forward splits (Type=FS) and reverse splits (Type=RS) are imported automatically; other corporate-action types (dividends, spin-offs, mergers) are not yet supported and appear as discarded rows so nothing is silently dropped.
P/L per transaction
The P/L column shows different information depending on the row type. The figure always means something concrete, and when it cannot be computed meaningfully, "—" appears instead.
Price, total, and P/L are all expressed in your reporting currency, converted at the historical FX rate of each transaction's date. For non-EUR holdings (US stocks, UK ETFs, etc.) this means a trade that was a gain in the source currency can still show a loss in your reporting currency if FX moved against you between buy and sell — the displayed numbers reconcile with each other and with the position summary above.
On sell rows, P/L reflects the gain or loss you actually realized: the sale proceeds minus what those shares cost you, using your average price at the time of the sale. For example, if you sell ten shares at €120 with an average cost of €100, the row shows +€200. The sum of realized P/L across every sell of a position matches the position's total realized P/L exactly.
On buy rows, P/L reflects how those shares have appreciated since the purchase: the current price minus what you paid, multiplied by the shares bought. This figure is only shown while no later sale has reduced your holdings — those shares are still untouched in the position, so the number maps directly to the difference between what you paid and what they are worth today.
Once you make a sale, that direct attribution stops being possible. Your remaining shares share a pooled average cost, and assigning a specific gain to a single purchase no longer makes sense. We leave those rows blank ("—") rather than show a figure we could not justify.
If you fully close a position and start buying it again later, the new buys begin afresh: they show their P/L until your next sale. And whenever per-row figures are blank, the position summary above carries the full picture — realized P/L from past sells plus unrealized P/L on the shares you still hold.