[GNC] Example of importing Stock transactions from CSV

Jack Frillman jcf_m_lists at me.com
Sun Aug 21 10:16:32 EDT 2022


I’m importing prices

——
I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
— Yosemite Sam

> On Aug 21, 2022, at 9:34 AM, Jon Schewe <jpschewe at mtu.net> wrote:
> 
> 
> Jack,
> 
> I have tried using this configuration multiple times to get the import to work. I have a list of column assignments, none of which have worked correctly. Thus the python script that does in fact work. In your screenshot I see column options that don't exist for me. Are you importing transactions or prices? I'm trying to import transactions.
> 
> Jon
> 
> 
>> On Sat, 2022-08-20 at 11:54 -0400, Jack Frillman via gnucash-user wrote:
>> I use CSV import almost every day and it works just fine.
>> You do have to setup a configuration file that tells the importer how to 
>> interpret your CSV data. I suspect you did not do that.
>> Here is an example of my CSV data:
>> 
>> ARSIX,14.82,Ray Jay,2022/08/20,USD
>> BAFGX,26.47,Ray Jay,2022/08/20,USD
>> BAGIX,10.07,Ray Jay,2022/08/20,USD
>> CISMX,16.75,Ray Jay,2022/08/20,USD
>> GSFTX,29.98,Ray Jay,2022/08/20,USD
>> 
>> Each column of the separated values above are defined when you set the 
>> importer up.
>> I saved this in a file called "ira quotes" and it's selected in the 
>> attached screen shot.  The bottom window is the result of mapping of the 
>> "irs quotes" file to the CSV data above.
>> 
>> As for your Python script I have no idea what it's supposed to do.
>> I have a much smaller Python script that scrapes the closing day prices 
>> off a web page and creates the CSV file I import.
>> 
>> Jack
>> 
>>> On 8/19/22 10:33 PM, Jon Schewe wrote:
>>> So I didn't get the CSV import tool to work. However I was able to
>>> write a python script to do the import. I would think that this would
>>> be possible with the CSV import, but I can't seem to figure out how to
>>> do the right column assignments to make it work. I have attached the
>>> python script and a sample input CSV file.
>>> 
>>> If someone that knows how the CSV import code works and can compare
>>> with my script and tell me how to use the CSV import tool for this,
>>> that would be great.
>>> 
>>> Thanks,
>>> 
>>> Jon
>>> 
>>> 
>>>> On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote:
>>>> That looks similar to what I'm doing, except all of my data is on a
>>>> single line in the CSV file. The biggest problem seems to be how to
>>>> convince GnuCash to use 2 different commodities for the transaction
>>>> when importing from CSV.
>>>> 
>>>> 
>>>>> On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote:
>>>>> Hi Jon
>>>>> 
>>>>> This isn't exactly what you are asking for, but it may give you
>>>>> some
>>>>> clues.  Importing Dividends from CSV:-
>>>>> 
>>>>> https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html
>>>>> 
>>>>> 
>>>>> Good luck!
>>>>> 
>>>>> Geoff
>>>>> =====
>>>>> 
>>>>>> On 12/07/2022 12:35 pm, Jon Schewe wrote:
>>>>>> Does anyone have an example of importing stock transactions from
>>>>>> CSV?
>>>>>> 
>>>>>> I have matched columns to Date, Description, Account, Price,
>>>>>> Deposit,
>>>>>> Transfer Account.
>>>>>> The "Account" column is the mutual fund account.
>>>>>> The "Transfer Account" column is the currency account.
>>>>>> 
>>>>>> When I start the import process all of my transactions need an
>>>>>> account
>>>>>> to transfer from, despite specifying the Transfer Account. When I
>>>>>> try
>>>>>> and select my currency account I'm told that it has the wrong
>>>>>> commodity.
>>>>>> 
>>>>>> I have another column for the currency amount, but I don't know
>>>>>> what to
>>>>>> map that to in the importer.
>>>>>> 
>>>>>> I tried checkout out
>>>>>> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
>>>>>> 
>>>>>>    but it doesn't seem to address this.
>>>>>> Suggestions on where I'm going wrong.
>>>>>> 
>>>>>> Jon
>>>>>> 
>>>>>> 
>>>>>> _______________________________________________
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> 
>>>>>> To update your subscription preferences or to unsubscribe:
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>> 
>>>>>> If you are using Nabble or Gmane, please see
>>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists
>>>>>>   for more information.
>>>>>> -----
>>>>>> Please remember to CC this list on all your replies.
>>>>>> You can do this by using Reply-To-List or Reply-All.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 


More information about the gnucash-user mailing list