Investment account transaction loading
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.
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
1 Posted by dtd on 15 Jan, 2021 10:52 PM
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 Posted by van_looveren on 16 Jan, 2021 03:30 AM
Posted here. Thanks, @dtd.
3 Posted by hleofxquotes on 16 Jan, 2021 06:14 AM
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 Posted by dwg on 16 Jan, 2021 06:40 AM
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 Posted by van_looveren on 16 Jan, 2021 04:44 PM
@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 Posted by Stuart Beesley ... on 16 Jan, 2021 07:50 PM
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...
System closed this discussion on 17 Apr, 2021 08:00 PM.