Investment Handling in Master Branch

[Brendan Coupe]

I've been running the master branch on Fedora 41 for several months. I 
compile it on my system.

When I import my CD transactions from my broker via a downloaded ofx 
file, the price is listed as $100 when is should be $1. This has been an 
issue in 5.1 for several years and I think it started when I switched 
brokers. I have not asked about it since the developers are busy working 
on 5.2 and it was easy to correct in 5.1.

Since I switched to the master branch, the problem appears to be much 
deeper. The $100 price appears to be stored and used for some of the 
value calculations. As I bought new CDs, they were all valued at 100 
times their actual price. I corrected this by doing a manual price 
update in the investment section and changing it from 100 to 1. The 
dialog that opens says I'm adjusting the exchange rate for the stock xxx 
to USD which seems odd. I leave the date alone but it appears to be the 
purchase date. This is far from ideal since i have more than 100 
securities / CDs in several investment accounts so it's hard to find the 
ones that need to be fixed.

Ideally KMM would recognize the discrepancy and adjust the price from 
$100 to $1 when importing the OFX file. I'm guessing this is due to the 
broker not following the OFX standard.

I think these are the relevant lines in the OFX file when I purchase a CD.

<UNITS>12345
<UNITPRICE>100
<MKTVAL>12345

The UNITPRICE should be 1 and it's obvious the math does not work if you 
assume 100 is correct.

Oddly enough, the Quantity, Value and Balance columns in the ledger for 
the investment account are all correct and the Price column is wrong. 
When I update the price in the transaction from 100 to 1, all of the 
columns are correct. The Investment Value at the bottom of the ledger is 
clearly not based on the total of the Balance column since it appears to 
be using the 100 imported from the OFX file. The only way I can fix this 
is to find the CD in the investment section and manually change the 
price (exchange rate?) from 100 top 1.

This extra step was not required in 5.1. When I adjusted the price in 
the transaction, the Investment Value at the bottom of the ledger was 
correct.

I'm also having a problem when I sell CDs. The transaction only shows in 
the Brokerage account, not the investment account. I have to find the 
original purchase in the Investment account, duplicate it, switch it 
from buy to sell and correct the date. Then I match the newly created 
transaction in the brokerage account to the imported one. Unless this 
triggers a quick fix, lets figure out the first problem and I will come 
back to CD sales later since this is not a new problem in the master branch.

-- 

*Brendan Coupe*
*3 at Coupe7.com*