Create brokerage transactions from CSV

BrianS's Avatar

BrianS

22 Feb, 2018 02:30 PM

Is it possible to create brokerage transactions from a CSV? The initial research I've done seems limited to posting transactions to banking accounts and does not seem to support buys/sells, etc. I can download a CSV of transaction details and could infer buy/sell by the sign of the transaction, but I'm not seeing a path where I can expect success with this.

Can anyone help?

For background, and in case someone has experience with this specific source: my wife recently started a new job where they use Ubiquity as their 401k provider. There is no support for automatic downloading of transactions. For a year I've been entering them manually, but they are VERY chatty transactions (with individuals transactions per security for both personal contributions and company match, monthly sells per transaction by contribution source to cover fees, etc. But the straw that broke the camel's back was an annual rebalancing which triggered 100+ buy/sell transactions.

I think I'm just going to stop tracking this account in MD and just update equity holdings quarterly or so, ignoring cost basis and performance.But I can't help thinking that there must be a better way...

  1. 1 Posted by -Kevin N. on 22 Feb, 2018 05:44 PM

    -Kevin N.'s Avatar

    Hi Bri,

    You might want to look into a CSV converter. e.g. XL2QIF

    You may be able to convert your CSV file to QIF thus enabling you to import the QIF file.

    Safe computing 101 dictates that you make sure to have a working backup or copy of your data before attempting any such import. You may even want to try it out on a separate data file altogether.

    -Kevin N. (not a member of MD support)

  2. 2 Posted by BrianS on 22 Feb, 2018 06:05 PM

    BrianS's Avatar

    @Kevin - thank you for that XL2QIF hint. I was looking for a QIF builder the other night, but my Google-fu was failing me.

  3. 3 Posted by -Kevin N. on 22 Feb, 2018 07:11 PM

    -Kevin N.'s Avatar

    Hi Bri,

    You're welcome. Let us know how it works out. OK?

    -Kevin N. (not a member of MD support)

  4. 4 Posted by dwg on 22 Feb, 2018 09:19 PM

    dwg's Avatar

    The Excel (or Open Office) to QIF converter requires fairly strict requirements on the CSV file, the most important is that you must have and action column that uses the accepted action abbreviations, as they were defined by Quicken back in the 1980/90's

  5. 5 Posted by BrianS on 23 Feb, 2018 03:33 AM

    BrianS's Avatar

    Unsuccessful so far just getting the XL2QIF macro to load. I'm probably complicating things by having modern Excel on a Mac. But when I try to browse to the AddIn file I get compile errors, etc. I'll mess with it more this weekend, but welcome tips/tricks/suggestions if anyone has any. I'm basically Excel custom Add-In ignorant at this point.

  6. 6 Posted by dwg on 23 Feb, 2018 04:40 AM

    dwg's Avatar

    I've only used the macro on Windows, do not recall if the last version I tried it on was 2010 or 2013. It is always possible it is not compatible with the Mac.

  7. 7 Posted by derekkent23 on 23 Feb, 2018 08:46 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    There is a third party extension by Mike Bray called “Security Transaction Load” with imports CSV into the investment section of Moneydance. See https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transa...

    I have never used this extension and it could be totally inappropriate to the issue being discussed in this thread but for what is worth take a look.

    Hope this helps.

  8. 8 Posted by BrianS on 23 Feb, 2018 04:14 PM

    BrianS's Avatar

    @derek

    That looks very interesting. It seems focused on creating income/fee transactions.

    I don’t immediately see how to create plain buy/sell transactions. I welcome guidance if anyone has set it up to do that.

    I’ll play with it more in the next day or so.

    Continued thanks to all of you!

  9. System closed this discussion on 25 May, 2018 04:20 PM.

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