GnuCash
Contact   Instructions
Bug 793306 - Price is not imported from CSV
Summary: Price is not imported from CSV
Status: NEW
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Import - CSV (show other bugs)
Version: 2.7.x
Hardware: Other Mac OS
: Normal normal
Target Milestone: ---
Assignee: import
QA Contact: import
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-02-08 11:19 EST by Dawid Wrobel
Modified: 2021-07-04 21:26 EDT (History)
5 users (show)

See Also:


Attachments

Description Dawid Wrobel 2018-02-08 11:19:37 EST
I am trying to import my retirement fund transactions using CSV file, that has following structure:

Description,Date,Total,Price of a share,Number of shares
Transaction 1,31-07-2009,213.85,27.45,7.7905

In the CSV Import window, I assigned the column names as follows:
Description,Date,None,Price,Deposit

After the import, the price for each transaction is 1 or close to 1 and the "Buy" and "Sell" columns have the exact same 7.7905 value as the 'Shares" column. 

My understanding here is that Price value should be 27.45 as in CSV's "Price of share" column, and the "Buy" and "Sell" should be a result of Price x Shares and be the exact same 213.85 amount as CSV's "Total" column.
Comment 1 anrp.gnucash 2018-09-07 10:54:10 EDT
Passing by note: the price appears to be ignored in gnc-imp-props-tx.cpp:trans_add_split if the transaction commodity matches the account commodity. A workaround (feels wrong to me, but...) is to set the transaction commodity in CSV import to be the currency of the price, which then appears to record correctly in the stock register.

Note You need to log in before you can comment on or make changes to this bug.