tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5661-investment-account-transaction-loadingInfinite Kind: Discussion 2021-04-17T20:00:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-15T18:34:27Z2021-01-15T18:34:28ZInvestment account transaction loading<div><p>The only extension that I've found for <strong>importing CSV into an investment account</strong> is Mike Bray's <code>loadsectrans</code> extension. It took about an hour for me to uncover <a href="https://infinitekind.tenderapp.com/discussions/general-questions/66779-loadsectrans-extension#comment_45907855">this comment</a> (which I think still holds true) which says that Buy and Sell transactions are not supported. Unfortunately, that's what I need. <strong>Anyone have a solution?</strong></p>
<p>@Mike Bray, it seems that your so close to perfection on this extension. I mean, I kept struggling to find how the single provided input field mapping "Value" was going to get my cost basis right (requiring num_shares <em>and</em> tot_cost). <strong>Any plans to implement Buy Sell DivReinvest?</strong> Thoughts on my taking a stab? Open to pull requests? FWIW, I am a s/w developer by day, and mean to get into development to extend MD anyway (part of what ultimately attracted me to MD was the extensibility).</p>
<p>Also, @Mike Bray, thanks for the amazing work, <em>including</em> your documentation, with <a href="https://bitbucket.org/mikerb/moneydance-2019/wiki/Security%20Transaction%20Load%20Introduction">nuggets</a> like the following</p>
<blockquote>
<p>Investment accounts in Moneydance have two types of accounts, the Investment Account itself which manages the cash balance and individual Security Accounts which handle an individual Security holdings.</p>
</blockquote>
<p>So the security accounts are parented by the investment account (hierarchical). Brilliant! I'd venture a guess that this is probably why other CSV loaders don't automatically work beyond the Bank type (money in money out) accounts. More complex.</p></div>van_looverentag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-15T22:52:09Z2021-01-15T22:52:09ZInvestment account transaction loading<div><p>It's great to see folks wanting to extend MD capability, given the size of the company preventing Sean from doing enough.</p>
<p>You might want to repost this in "Extension Development" section (you can't delete it here in Investments, but this is imo pertinent enough to have in the Extension Development area as well.</p>
<p>just an interested user (also 30 year I/T career....)</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-16T03:30:06Z2021-01-16T03:30:07ZInvestment account transaction loading<div><p>Posted <a href="https://infinitekind.tenderapp.com/discussions/moneydance-development/4485-loadsectrans-or-similar">here</a>. Thanks, @dtd.</p></div>van_looverentag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-16T06:14:57Z2021-01-16T06:14:57ZInvestment account transaction loading<div><blockquote>
<p>The only extension that I've found for importing CSV into an investment account is Mike Bray's loadsectrans extension. It took about an hour for me to uncover this comment (which I think still holds true) which says that Buy and Sell transactions are not supported. Unfortunately, that's what I need. Anyone have a solution?</p>
</blockquote>
<p>If you just want something to work quick, you can try to convert the CVS input into OFX then use existing import functionality to import the OFX file.</p>
<p>The advantage of this approach is that you can do it as a stand-alone tool and you can choose whatever tool/language you want. Getting started with extension dev is quite a challenge.</p>
<p>See:</p>
<ul>
<li>Mike's excellent write up: <a href="https://bitbucket.org/mikerb/moneydance-2019/wiki/Moneydance%20Information">https://bitbucket.org/mikerb/moneydance-2019/wiki/Moneydance%20Info...</a></li>
<li>If you are more comfortable in a dev env with Maven/Eclipse, I have some notes: <a href="https://bitbucket.org/hleofxquotesteam/md-maven/wiki/Home">https://bitbucket.org/hleofxquotesteam/md-maven/wiki/Home</a></li>
</ul></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-16T06:40:30Z2021-01-16T06:40:30ZInvestment account transaction loading<div><p>I've converted CSV files into QIF to import the transactions into Investment accounts, it needs to be noted that OFX does not support categories so is not great if the data is coming from another finance program, using external tools. The CSV had to be pristine and the actions had to be just right for it to work.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-16T16:44:30Z2021-01-16T16:44:31ZInvestment account transaction loading<div><p>@dwg, thanks for sharing your experience.</p>
<p>@hleofxquotes, I'm not sure how involved the OFX format is, but as a developer myself (mostly Maven and IntelliJ in recent years), I'd rather build (on) something that is more flexible (like Mike's configurable <code>loadsectrans</code>) and can be used by others. I'll check out your notes soon, but a question I have: having not used Python and Java together before (each separately) are there any good primers or pointers on what complication <em>that</em> brings to development?</p></div>van_looverentag:infinitekind.tenderapp.com,2009-01-14:Comment/489740712021-01-16T19:50:26Z2021-01-16T19:50:26ZInvestment account transaction loading<div><p>Well, in MD, it's not Python, it's Jython.... Thus, you have access to all Java stuff whilst actually coding in Python format... Python is quick and easy. Java is more formal and requires compiling.... BUT if you are making a permanent extension, then probably Java is the way to go.... A bigger challenging is learning the MD dataset formats and how to call the APIs - same challenge with both...</p></div>Stuart Beesley (Mr Toolbox)