tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/2261-text-file-importer-to-expand-to-investment-transactionsInfinite Kind: Discussion 2019-03-21T10:00:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/466924662018-12-20T02:07:18Z2018-12-20T02:07:18ZText File Importer to Expand to Investment Transactions?<div><p>I'm fellow user.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>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</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/466924662018-12-20T09:53:35Z2018-12-20T09:53:35ZText File Importer to Expand to Investment Transactions?<div><p>I am not support staff, just a user</p>
<p>There is a third-party extension from Mike Bray which is intended for importing investments into the investment section of Moneydance, its wiki states :-</p>
<p>“The extension loads a .csv file containing miscellaneous transactions such as dividends, interest and management fees from an investment account.”</p>
<p>I have never used this extension so don’t know if it’s what you need, but worth a look, see<br>
<a href="https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transaction%20Load">https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transa...</a></p>
<p>Although the page takes about 2015 its my understanding its good for 2017 as well.<br>
If you do try it make a backup first in case you get unexpected results. Use at your own risk.</p>
<p>Hope this helped.</p></div>derekkent23