GnuCash
Contact   Instructions
Bug 797368 - Cannot download Quantity information from a CSV to a mutual
Summary: Cannot download Quantity information from a CSV to a mutual
Status: NEW
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Import - CSV (show other bugs)
Version: 3.5
Hardware: PC Windows
: Normal normal
Target Milestone: ---
Assignee: import
QA Contact: import
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-20 21:16 EDT by Steven Bruniges
Modified: 2021-07-04 21:29 EDT (History)
3 users (show)

See Also:


Attachments

Description Steven Bruniges 2019-08-20 21:16:26 EDT
The profile for to download a transaction download inthe CSV assistant does not support a quantity/shares column, and likely the underlying CSV model does not support it either.  This makes it impossible to process records of non-standard transactions (etc.), which only list the quantity and value (aka Amount in gnucash) in the CSV (where the price is null  for the relevant transaction).

The importer currently supports:

The amount, which works
The price, which is supported in the assistant only
The quantity, which is not supported

See also bug 797359

Additional information.  
the information reported by brokers about mutuals, and shares doesn't always fit the model used for importing bank accounts as neatly as could be hoped.

In some transactions, where the price and amount is known, the quantity/shares can be calculated.  But if the CSV file contains only the quantity and amount, then the price has to be calculated instead.  Unfortunately, depending on the nature of the transaction, some rows may have a price and some may have a quantity, meaning the choice needs to be made on a row by row basis.

This may be because there isn't a single "price" (there are buy prices, sell prices, and by the looks of it fund migration prices.  The CSV appears to contain a choice of buy or sell price, but those transactions that use a different price gets a blank field.  But then all I really know is that the column is blank on some transaction types!

However the quantity is always present in the CSV I want to import.  Maybe a better strategy is to process this, and calculate the price, contrary to the design of the current assistant, noting that is also broken.

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