"Evan Platt" wrote
Quicken 2019 R.18.16.
I've download a QIF and a CSV from fidelity netbenefits.
When trying to import either into Quicken, I get "File not found or unreadable." The QIF looks fine, to my untrained eye.....: !Type:Invst D10/04/2018 NBuy YVANG INST TR 2040(OV6T) I24.32000 Q6.149 U149.55 T149.55 MContribution ^ D10/17/2018 NBuy YVANG INST TR 2040(OV6T) I23.65000 Q6.327 U149.64 T149.64 MContribution ^ <Etc>
The CSV file says no valid prices found to import:
Plan name:,<NAME>
Date Range,04/17/2017 - 04/18/2019,,,,
Date,Investment,Transaction Type,Amount,Shares/Unit
04/16/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.173"
04/03/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.227"
---------------------------------------------------------- If you get "file not found", that can't be a problem with the contents of the file.
I was able to import your QIF file into Q2019 R18.15 with no change to the QIF file. During the import, Quicken asked if I wanted it to create a new security for the one in the QIF file; after I answered Yes, the import completed and the two transactions were in the investment account I had selected in my test file.
Your .CSV file isn't close.
First get rid of everything before the "Date,Investment,Transaction ...." heading text.
Once I did that and tried to import the resulting file, I got: "No valid prices to import".
As Sherlock suggested, your format still seems wrong.
To get an idea what Quicken expects, you can try a couple of things.
1.) Quicken Help has info on the format of a .CSV price import file. Check that and try adjusting your .CSV file accordingly.
2.) Create a (test) portfolio/watchlist at Yahoo - you only need one security. Then Export that portfolio/watchlist which will create a .CSV file. While there will be many more fields in that file than in yours, Quicken can import the data from that file, so you should be able to get an idea where your problem lies.
I believe the first thing to look at is the ticker symbol, which I do not see in your .CSV data.