Home → Investments →

Downloading investments from Morgan Stanley

• Edit

Phil

16 Oct, 2015 09:10 PM

I updated to Moneydance 2015 and downloaded my transaction history for a Morgan Stanley account. It downloaded everything from April 2014 and on but did not download the earlier history. I am missing something?

1. 1 Posted by dwg on 16 Oct, 2015 09:34 PM

   

   If you are using direct connect then you are probably not missing anything.

   The institutions usually only maintain a limited history, often only 30-90 days back, in these systems. To go back further you will generally have to manually download and import the older transactions.

   • Edit

2. 2 Posted by Philip Civins on 17 Oct, 2015 12:15 AM

   

   Is it possible to import a CSV or Excel file? I am only seeing OFX, QFX and QIF.
   Thanks,
   Phil

   • Edit

3. 3 Posted by dwg on 17 Oct, 2015 08:18 PM

   

   It is possible, but not necessarily straightforward, using the text file importer or the user developed CSV importer.

   The Text file importer is installed using the normal method the CSV importer for MD2015 can be downloaded from:

   https://github.com/stant/mdcsvimporter2015/releases/tag/v19

   • Edit

4. 4 Posted by Tom Freeman on 18 Oct, 2015 11:06 PM

   

   I would also log in to the Morgan Stanley site and see if they allow older account history downloads in either ofx or qif. Their site says "View and download current and historical
   statements, trade confirmations, tax documents, general correspondence, reports, and agreements" Not having a Morgan Stanley account I am not sure what exactly they have made available.

   Tom Freeman
   Infinite Kind Support

   • Edit

5. 5 Posted by Philip Civins on 19 Oct, 2015 12:01 AM

   

   Thanks Tom. I called Morgan Stanley support after not being able to find a way to download the information. They did not give me a solution. I am able to copy and paste transactions into Numbers (Apple) but have not tried to use the text file importer yet. My initial thoughts are it looks difficult.
   Phil

   • Edit

6. 6 Posted by dwg on 19 Oct, 2015 07:49 AM

   

   I've seen here some FI when you are displaying transactions have an "export" option, in the case of the one I was looking at electing this gave me options like download a QIF file of these transactions

   • Edit

7. 7 Posted by -Kevin N. on 19 Oct, 2015 01:53 PM

   

   Hi Philip,

   Unfortunately, neither the Text File Importer nor the CSV importer are designed to import Investment type account data.

   They're designed for Bank and Credit Card type accounts.

   -Kevin N.

   • Edit

8. 8 Posted by Philip Civins on 19 Oct, 2015 01:56 PM

   

   Thanks for the info.
   Phil

   • Edit

9. 9 Posted by Tom Freeman on 20 Oct, 2015 11:46 PM

   

   I am sorry I don't think there is an easy way to get you transaction history for your investment account beyond what Morgan Stanley makes available.

   There are csv to qif/qfx converters, but i have found them difficult to use and the results less than accurate.

   Tom Freeman
   Infinite Kind Support

   • Edit

10. 10 Posted by dwg on 21 Oct, 2015 06:16 AM

    

    I've used a CSV to QIF converter inside of Excel, it worked well enough but the data had to be in a consistent format. It was a fair amount of work to use, but in my case it was a once off in performing the initial data load. The only real issue I found was that MD would place any transaction with an action of "DIV" into the Category dividend, even if a specific category was given in the QIF file.

    • Edit

11. System closed this discussion on 19 Mar, 2016 05:02 AM.