tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/3256-create-brokerage-transactions-from-csvInfinite Kind: Discussion 2018-05-25T16:20:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-22T17:44:06Z2018-02-22T17:44:06ZCreate brokerage transactions from CSV<div><p>Hi Bri,</p>
<p>You might want to look into a CSV converter. e.g. XL2QIF</p>
<p>You may be able to convert your CSV file to QIF thus enabling you to import the QIF file.</p>
<p>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.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-22T18:05:24Z2018-02-22T18:05:25ZCreate brokerage transactions from CSV<div><p>@Kevin - thank you for that XL2QIF hint. I was looking for a QIF builder the other night, but my Google-fu was failing me.</p></div>BrianStag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-22T19:11:52Z2018-02-22T19:11:52ZCreate brokerage transactions from CSV<div><p>Hi Bri,</p>
<p>You're welcome. Let us know how it works out. OK?</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-22T21:19:01Z2018-02-22T21:19:01ZCreate brokerage transactions from CSV<div><p>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</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-23T03:33:52Z2018-02-23T03:33:53ZCreate brokerage transactions from CSV<div><p>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.</p></div>BrianStag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-23T04:40:18Z2018-02-23T04:40:18ZCreate brokerage transactions from CSV<div><p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-23T08:46:31Z2018-02-23T08:46:31ZCreate brokerage transactions from CSV<div><p>I am not support staff, just a user.</p>
<p>There is a third party extension by Mike Bray called “Security Transaction Load” with imports CSV into the investment section of Moneydance. See <a href="https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transaction%20Load%20Introduction">https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Transa...</a></p>
<p>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.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/447780952018-02-23T16:14:15Z2018-02-23T16:14:15ZCreate brokerage transactions from CSV<div><p>@derek</p>
<p>That looks very interesting. It seems focused on creating income/fee transactions.</p>
<p>I don’t immediately see how to create plain buy/sell transactions. I welcome guidance if anyone has set it up to do that.</p>
<p>I’ll play with it more in the next day or so.</p>
<p>Continued thanks to all of you!</p></div>BrianS