[GNC-dev] Import of prices in CSV files

Thomas tduellmann+gnucashdevel at gmail.com
Mon Jan 17 15:57:37 EST 2022


I think in general the proposed solution is quite close to what I would 
like to achieve.

I have a follow-up question though:
Is it possible to use something else than the "Symbol" for matching the 
security? For example the cusip (ISIN, WKN, identifier..) would be a 
great thing.

Best,
Thomas

On 1/17/22 01:10, Thomas wrote:
> Thanks a lot!
> 
> I think I'm getting closer to what I want to achieve.
> 
> Best,
> Thomas
> 
> 
> [1] https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
> 
> On 1/16/22 23:02, D. wrote:
>> All you need is a csv file with four columns:
>>
>> Stock (i.e., ticker), Namespace (from Gnucash) , Date, Price
>>
>> Follow the Importer prompts.
>>
>> I imagine you could figure out how to map your bank's file based on this.
>>
>>
>>
>>
>> -------- Original Message --------
>> From: Thomas <tduellmann+gnucashdevel at gmail.com>
>> Sent: Sun Jan 16 16:19:38 EST 2022
>> To: gnucash-devel at gnucash.org
>> Subject: [GNC-dev] Import of prices in CSV files
>>
>> Hello,
>>
>> I would like to use a custom (bank-provided) CSV-file containing the
>> prices for some of my securities to fill the price database.
>> Unfortunately, I couldn't find a good source of information to do that
>> with GnuCash itself (yet). If there's a proper way to do so, I'd be
>> grateful for any advice.
>> If that is not possible out-of-the-box, I had a first draft for using
>> the 'piecash' module for doing so (which seems not to handle the source
>> definition of the price properly, and reports 'invalid' though).
>>
>> What I am looking for is either a recommended approach for this or maybe
>> hints on how to make sure that I don't break anything with it and keep
>> my book and overall data intact.
>>
>> Thanks a lot in advance!
>>
>> Best regards,
>> Thomas
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>


More information about the gnucash-devel mailing list