How to Import Stock Transactions
Derek Atkins
warlord at MIT.EDU
Wed Feb 8 11:54:41 EST 2017
Hi,
Craig Huff <huffcslists at gmail.com> writes:
> I've tried researching in the GC manual and googling the web, but I keep
> finding outdated solutions or references to webpages that are no more. I
> haven't been able to get QIF exports from my broker (Edward Jones) to work,
> despite trying different things off and on for several months. It appears
> that they export using a two-factor scheme that requires a verification
> message from the Intuit web server in response to a message from a valid
I'm not sure why QIF export would require two-factor auth. QIF is
generally a download-based file format. Do you, perhaps, mean OFX or
QFX?
> copy of Quicken. I have resigned myself to having to manually log in to the
> Edward Jones website and downloading transaction data in an Excel file
> export.
Are you sure you can't download a QIF or OFX file?
> I have not had any success figuring out how to convert the Excel data into
> a format suitable for importing into GC and how to import A) the pure stock
> transactions (e.g. dividends) into their separate accounts and the
> conversions between stock shares and cash (e.g. buy and sell) into the
> parent account (or do these go into both?).
Maybe write a script to convert the CSV to QIF?
> I'm still not clear on what goes where when it comes to the investment
> accounts, even though I thought I'd be able to make sense of the data I
> imported from my Quicken file when I started the transition.
>
> There's way too much to manually enter and keep up with. I need some way
> to take the Excel file and load it into GC without having to manually
> monitor/edit each entry during the import process.
>
> I would really appreciate it if anyone could give me a clue how to do this.
>
> --
> Craig.
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list