Investment account transaction loading

van_looveren's Avatar

van_looveren

15 Jan, 2021 06:34 PM

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?

@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 and tot_cost). Any plans to implement Buy Sell DivReinvest? 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).

Also, @Mike Bray, thanks for the amazing work, including your documentation, with nuggets like the following

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.

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.

  1. 1 Posted by dtd on 15 Jan, 2021 10:52 PM

    dtd's Avatar

    It's great to see folks wanting to extend MD capability, given the size of the company preventing Sean from doing enough.

    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.

    just an interested user (also 30 year I/T career....)

  2. 2 Posted by van_looveren on 16 Jan, 2021 03:30 AM

    van_looveren's Avatar

    Posted here. Thanks, @dtd.

  3. 3 Posted by hleofxquotes on 16 Jan, 2021 06:14 AM

    hleofxquotes's Avatar

    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?

    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.

    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.

    See:

  4. 4 Posted by dwg on 16 Jan, 2021 06:40 AM

    dwg's Avatar

    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.

  5. 5 Posted by van_looveren on 16 Jan, 2021 04:44 PM

    van_looveren's Avatar

    @dwg, thanks for sharing your experience.

    @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 loadsectrans) 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 that brings to development?

  6. 6 Posted by Stuart Beesley ... on 16 Jan, 2021 07:50 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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