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.