I wish you folks would re-consider allowing csv imports to investment registers
My companies 401k administrator only allows "screen scraping" from an html table then copy/paste into Excel. That's the only way I can "download" data. I'm perfectly capable of formatting and moving columns around to however you design the import. The investment transaction register is not unlike any other checking, savings or credit card register why not let us import to it?
Regards,
Clare
BTW, yes, for the 6 years I have worked for this company I have complained about it. :)
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 dwg on 15 Jul, 2017 10:29 PM
Hi Clare,
The registers look similar but they work quite differently, The Bank and Credit card registers are strictly column based.
The Investment register on the other hand is based on a few variable factors. firstly the Action type, this to start with determines what fields are active for the following transaction, the action types must be one of the pre-defined types, so your download would have to have a field like this that also meets the rules, the types were defined by Intuit many years ago. Depending on action type some fields become mandatory others optional, Transactions like Transfers need to have a sign to indicate which direction the transfer it in.
I have a Managed fund that only provides CSV data and while the data is all there I would have to write a program that does some heavy duty data parsing to structure it into something that could be imported.
If you data really does meet the rules there is an add on for excel that will create a QIF file that Moneydance can import
FWIW this tool can be found at:
http://xl2qif.chez-alice.fr/xl2qif_en.php
System closed this discussion on 14 Oct, 2017 10:30 PM.