How to correct multiple errors in a file from .qif downloads
I have a 401k that will only download in .qif format. I used that to download approximately 3 years of transactions. Unfortunately, many of the transactions did not download a share price for the mutual funds and therefore assumed it to be $1 a share (some actually have no share price, but most are $1). Hundreds of these errors occurred and will take a very long time to manually correct. Is there a way to export the data to Excel, manipulate it to include the correct share price and re-import it? It is not an issue with the share price history, since some transactions on the same day have the correct share price and others have the $1 per share. Looking for a faster way to correct this than fixing each entry by hand. Thanks.