[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