Text File Importer to Expand to Investment Transactions?

kieran.hanrahan's Avatar

kieran.hanrahan

20 Dec, 2018 12:46 AM

Hiya!

I would just like to say that I would love to see development of the text file importer to include investment transaction options. My Roth IRA is with T TRowe Price and they only have CSV download for transactions. Example file attached.

Thanks in advance for anyone's time!

  1. 1 Posted by dwg on 20 Dec, 2018 02:07 AM

    dwg's Avatar

    I'm fellow user.

    Many investment houses provide file like this, alas they are generally useless for importing into financial software as there are really just a type of tabular statement.

    Such files can be imported into Bank and similar types of accounts as their registers are very much a like a table and a CSV file can be mapped to a table, so with a little work against what column in the download file matches what column in the register the data can be imported.

    Investment registers do not work like this. It is not really a table rather it is a series of fields that make up a record with the Action field determining which other fields are active, the action field must match what is predefined, there are a defined number of action types with a specific mnemonic for each and these are the only valid ones.

    A human can read such a file and understand what needs to happen, but there are no standards for presentation, different institutions do what they like so there is no commonality across the industry, a parser that could process such a file would be quite complex, with no guarantees and could well be institution specific.

    When I migrated to Moneydance from Reckon I only had CSV files to work with, but these were relatively reasonable, but still the parsing code was fairly complicated

  2. 2 Posted by derekkent23 on 20 Dec, 2018 09:53 AM

    derekkent23's Avatar

    I am not support staff, just a user

    There is a third-party extension from Mike Bray which is intended for importing investments into the investment section of Moneydance, its wiki states :-

    “The extension loads a .csv file containing miscellaneous transactions such as dividends, interest and management fees from an investment account.”

    I have never used this extension so don’t know if it’s what you need, but worth a look, see
    https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transa...

    Although the page takes about 2015 its my understanding its good for 2017 as well.
    If you do try it make a backup first in case you get unexpected results. Use at your own risk.

    Hope this helped.

  3. System closed this discussion on 21 Mar, 2019 10:00 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

21 Jul, 2019 05:00 PM
21 Jul, 2019 01:55 PM
21 Jul, 2019 11:31 AM
21 Jul, 2019 07:56 AM
21 Jul, 2019 06:54 AM