CSV import from Fidelity US

English Import/export
1

Hi, I am trying to setup portfolio-performance for the 1st time. I tried importing csv from fidelity but running into many issues related to cash transactions, currency transactions and the fidelity automatic SPX investment.

Is there any quick guide to help import csv from fidelity; I was able to follow the guide to import interactive brokers and that works perfectly something similar for fidelity would be very helpful.

1 Like
2

Yes… me too here. It seems it gets complicated quickly because the “Cash Account” for Fidelity is actually automatically invested in the SPAXX fund and in the PP world you need:

  1. “Fidelity Cash” Account (for true cash coming in and moving, but SPAXX cannot be a part of this Cash Deposit account, securities cannot exist in a PP Cash Account)
  2. “Fidelity SPAXX-Brokerage” (for when the cash is auto-purchased into the SPAXX fund. And this must be a “Securities Account” in PP.
  3. “Fedlity Securities” (account for all securities owned)

So I have an IRA, Roth IRA and Brokerage account, so I have to stand up nine (9) accounts in PP to manage all of this properly it appears to me.

Additionally, I have to write complicated formulas to parse the Fidelity History export file into a properly prepared import file for PP.

Someone tell me they have done this and have a great setup and import method for Fidelity!

3

Yes, it sounds like this. I know that with other accounts, there was an idea to “collapse” them somehow (say for multi-currency accounts) but nothing is implemented so far.

Is it the process described here?

Can you share an (anonymized) “history export file”? Alternatively to portfolio dot performance dot help at gmail dot com? Just to get an understanding what kind of data wrangling would be needed.

4

With Fidelity having $6.4 trillion USD AUM and 3rd largest brokerage, this would surely be quite useful.

I’ve emailed a history export file to that address and a short script I use. But I did find an issue where the Type column in the CSV importer is severely limited in the Portfolio Transactions import vs the Account Transactions import. This even contradicts the documentation: Importing a CSV file - Portfolio Performance Manual

  1. Portfolio Transactions import

The acceptable values for the field Type are: Deposit, Removal, Interest, Interest Charge, Dividend, Fees, Fees Refund, Taxes, Tax Refund, Buy, Sell, Transfer (Inbound), and Transfer (Outbound). The default value of Type is Sell.

The types Mapped to Input available in the Portfolio Transactions view are only:
Buy, Delivery (Inbound), Delivery (Outbound), Sell, Transfer (Inbound), Transfer (Outbound)