Import guides / E*TRADE
E*TRADE's export lives under the transactions view rather than the portfolio view. Since the Morgan Stanley merger the newer exports may arrive as XLSX rather than CSV — if you are offered both, take CSV; if not, save the spreadsheet as CSV before importing.
Export your transaction history
Start here rather than with the positions file. A list of holdings tells FolioBright what you own today; the transaction history tells it what you paid and when, which is what real cost basis, time-weighted return and money-weighted return are built from.
- Sign in at etrade.com.
- Open the Accounts tab, then Transactions.
- Set the time period to Custom and enter a from and to date covering everything.
- Click Apply.
- Click the download icon at the top right and choose the spreadsheet option.
- If you trade heavily, pull it in shorter stretches — a year at a time — rather than one huge range.
Export your current positions
Optional, and useful mainly as a check: import the transactions first, then compare the share counts FolioBright shows against this file to confirm nothing was missed.
- From the Accounts tab, open Portfolio.
- Use the download or export control above the positions table.
- The file carries symbol, quantity, price paid and market value.
What FolioBright reads
The importer matches your header row automatically, so normally you do not have to think about this. These are the columns it looks for in a E*TRADE export.
| Column in your export | What FolioBright does with it |
|---|---|
TransactionDate | the date, written without a space in E*TRADE's header |
TransactionType | bought, sold, dividend, interest, and the option open/close wording |
Symbol | ticker — often just the underlying when the row is an option |
Quantity | shares or contracts |
Price | execution price |
Amount | net cash |
Things it handles for you
The symbol column is not always the whole story. On option rows E*TRADE tends to leave the underlying in the symbol column and describe the actual contract elsewhere. FolioBright looks in both places, so a contract is booked as a contract.
Buy to Open and Sell to Close are read as opening and closing actions, which is what keeps a round-trip option trade from looking like two unrelated positions.
Headers without spaces — TransactionDate, TransactionType — are matched automatically. You should not need to map anything by hand.
If your export is XLSX, open it once and save a copy as CSV. Everything else works the same.
Bringing it into FolioBright
- Open FolioBright and choose the account the file belongs to, or create one with Add account.
- Click Import transactions and drop the CSV in.
- Check the column mapping. FolioBright reads the header row and fills it in for you; the preset for this broker is below if you ever need to set it by hand.
- Review the preview. Anything it could not read is listed separately rather than imported quietly.
- Import. Prices, returns and allocation update as soon as it lands.
Other brokerages
Nothing to install
FolioBright reads the file in your browser and stores the result in your own account. There is no brokerage login to hand over, no read-only credential, and no third-party aggregator sitting between you and your holdings.