Automatically import transactions involving mutual fund

Frank H. Ellenberger f.ellenberger at online.de
Sat Sep 3 10:43:11 EDT 2011


Am Mittwoch, 3. August 2011 um 10:15:02 schrieb Fredrik Persson:
> Hello!
>
> I'm looking for a way to automatically import buying/selling of shares in a
> fund.
>
> From the "broker", I've downloaded a CSV file that looks like this
> (excerpt):
:
> A have a LOT of these transactions, so to enter them all manually is really
> not an option. I'm looking into converting the CSV into OFX. Is that a
> possible solution?

Did you see 
http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_convert_from_CSV.2C_TSV.2C_XLS_.28Excel.29.2C_or_SXC_.28OpenOffice.org_Calc.29_to_a_QIF.3F 
ff? E.g. having a spreadsheet with sheet1 for importing the csv and in sheet2 
the formated references for calc2qif.

> I can do some perl/python/java programming if that would help in any way.
>
> TIA
>
> Fredrik Persson

HTH
Frank


More information about the gnucash-user mailing list