<html><head><style>pre,code,address {
margin: 0px;
}
h1,h2,h3,h4,h5,h6 {
margin-top: 0.2em;
margin-bottom: 0.2em;
}
ol,ul {
margin-top: 0em;
margin-bottom: 0em;
}
blockquote {
margin-top: 0em;
margin-bottom: 0em;
}
</style></head><body><div><div><span style="caret-color: rgb(46, 52, 54); color: rgb(46, 52, 54); font-family: monospace; font-size: 13.333333px; white-space: pre-wrap;"><br></span></div><div><span style="caret-color: rgb(46, 52, 54); color: rgb(46, 52, 54); font-family: monospace; font-size: 13.333333px; white-space: pre-wrap;">Do you all know when the investment portion will be upgraded? </span></div></div><div><br></div><div>thanks</div><div><br></div><div>JV</div><div><br></div><div><br></div><div><br></div><div><br></div><div>On Wed, 2025-02-05 at 14:58 -0700, Brendan Coupe via KMyMoney-devel wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div>On 2025-02-05 1:35 PM, Jack via KMyMoney-devel wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div>On 2025.02.05 14:56, Brendan Coupe via KMyMoney-devel wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div>I've been running the master branch on Fedora 41 for several months. </div><div>I compile it on my system.</div><div><br></div><div>When I import my CD transactions from my broker via a downloaded ofx </div><div>file, the price is listed as $100 when is should be $1. This has been </div><div>an issue in 5.1 for several years and I think it started when I </div><div>switched brokers. I have not asked about it since the developers are </div><div>busy working on 5.2 and it was easy to correct in 5.1.</div><div><br></div><div>Since I switched to the master branch, the problem appears to be much </div><div>deeper. The $100 price appears to be stored and used for some of the </div><div>value calculations. As I bought new CDs, they were all valued at 100 </div><div>times their actual price. I corrected this by doing a manual price </div><div>update in the investment section and changing it from 100 to 1. The </div><div>dialog that opens says I'm adjusting the exchange rate for the stock </div><div>xxx to USD which seems odd. I leave the date alone but it appears to </div><div>be the purchase date. This is far from ideal since i have more than </div><div>100 securities / CDs in several investment accounts so it's hard to </div><div>find the ones that need to be fixed.</div><div><br></div><div>Ideally KMM would recognize the discrepancy and adjust the price from </div><div>$100 to $1 when importing the OFX file. I'm guessing this is due to </div><div>the broker not following the OFX standard.</div><div><br></div><div>I think these are the relevant lines in the OFX file when I purchase </div><div>a CD.</div><div><br></div><div><UNITS>12345</div><div><UNITPRICE>100</div><div><MKTVAL>12345</div><div><br></div><div>The UNITPRICE should be 1 and it's obvious the math does not work if </div><div>you assume 100 is correct.</div><div><br></div><div>Oddly enough, the Quantity, Value and Balance columns in the ledger </div><div>for the investment account are all correct and the Price column is </div><div>wrong. When I update the price in the transaction from 100 to 1, all </div><div>of the columns are correct. The Investment Value at the bottom of the </div><div>ledger is clearly not based on the total of the Balance column since </div><div>it appears to be using the 100 imported from the OFX file. The only </div><div>way I can fix this is to find the CD in the investment section and </div><div>manually change the price (exchange rate?) from 100 top 1.</div><div><br></div><div>This extra step was not required in 5.1. When I adjusted the price in </div><div>the transaction, the Investment Value at the bottom of the ledger was </div><div>correct.</div><div><br></div><div>I'm also having a problem when I sell CDs. The transaction only shows </div><div>in the Brokerage account, not the investment account. I have to find </div><div>the original purchase in the Investment account, duplicate it, switch </div><div>it from buy to sell and correct the date. Then I match the newly </div><div>created transaction in the brokerage account to the imported one.</div><div>Unless this triggers a quick fix, lets figure out the first problem </div><div>and I will come back to CD sales later since this is not a new </div><div>problem in the master branch.</div></blockquote><div>Brendan,</div><div><br></div><div>This is only a superficial response, as anything more involved will</div><div>require my digging a bit into the internals.</div><div><br></div><div>In terms of the brokerage setting the price at 100 instead of 1, I'm </div><div>guessing it's sort of a unit issue - it's 100 cents even though all</div><div>other amounts are in dollars. I have a very vague memory of this </div><div>being adjustable under some import scenario, but I can't remember </div><div>where. Again, I'll have to dig, but perhaps it gives something to </div><div>hunt for in the configuration or security definition.</div></blockquote><div>This makes sense but I don't see any way to set the units.</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div><br></div><div>In terms of transactions for CDs only showing up in the brokerage </div><div>account, what is the transaction type as provided by the bank? It </div><div>seems you have created a CD as an investment, which is perfectly </div><div>reasonable, but if the bonk considers the sale as simply a deposit of </div><div>cash, there is no way OFX or KMM will recognize it as an investment</div><div>transaction.</div></blockquote><div><br></div><div>KMM doesn't really have a good way to handle CDs. I've always imported </div><div>them to the Investment account and the appropriate transactions were </div><div>added to it and the brokerage account. This has worked with several </div><div>different brokers. The broker I am using now is the first one to have</div><div>any issues importing via OFX. Hopefully CDs will be handled better when </div><div>the investment portion of KMM is upgraded.</div><div><br></div><div>The OFX file is tough to read but I think the CD sales are simply cash </div><div>deposits. There isn't much info provided so this probably isn't fixable.</div><div><br></div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div><br></div><div>At this point - meant only as food for thought.</div><div><br></div><div>Jack</div></blockquote></blockquote><div><br></div><div><span></span></div></body></html>