Bug 423999 - Stock prices: update impossible due to wrong ID
Summary: Stock prices: update impossible due to wrong ID
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 5.0.8
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-08 15:07 UTC by firefox-112
Modified: 2020-07-21 08:16 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screenshot (92.57 KB, image/png)
2020-07-08 15:07 UTC, firefox-112
Details
details view (131.43 KB, image/png)
2020-07-09 14:58 UTC, firefox-112
Details

Note You need to log in before you can comment on or make changes to this bug.
Description firefox-112 2020-07-08 15:07:17 UTC
Created attachment 129978 [details]
Screenshot

SUMMARY

I am not able to update the current stock prices as the column "ID" contains the name of the investment, not its ID. See screenshot attached.
This value is then passed as argument "%1" to the source I've selected, which in my example leads to a call to "<myscript> Adidas ".


OBSERVED RESULT


EXPECTED RESULT

ID column shall contain the ID, not the name


SOFTWARE/OS VERSIONS
KMyMoney 5.0.8 on KUbuntu 20.04


Regards Christian
Comment 1 Jack 2020-07-08 17:30:51 UTC
Is there a reason you can't edit the security and change the ID to the proper symbol?
Comment 2 firefox-112 2020-07-09 13:03:36 UTC
Yes, I have set it up properly I think. 
Name is "Adidas" and ID is its ISIN "DE000A1EWWW0". (please also see screenshot attached)

I know that an older version (I can't tell which one) wsa working fine regarding updating the prices, so I would state it is broken now.
Comment 3 Jack 2020-07-09 14:18:00 UTC
Your screenshot shows Adidas in both the NAME and ID columns.  I do not see DE000A1EWWW0 anywhere.
Comment 4 firefox-112 2020-07-09 14:48:28 UTC
In the foreground it is the modal "Online Update" dialog where i cannot edit anything, it contains Adidas for both Name and ID.

The background is the "Overview" of the securities which contains correct data.

I can't edit the Data in the online dialog, I guess it shall just copy them.
Comment 5 Jack 2020-07-09 14:56:09 UTC
You have to edit the security, you can't change it as part of the price update process.  Open the Investments View, select an account which contains shares of Adidas, and double click on the entry for Adidas.  The next screen has entries for both the ID and the Trading Symbol (stock ticker).  I believe it is actually the content of the Trading Symbol field which is used to fetch prices.   Try that.
Comment 6 firefox-112 2020-07-09 14:58:25 UTC
Created attachment 129999 [details]
details view
Comment 7 firefox-112 2020-07-09 14:59:16 UTC
No, the details view is correct, just like the overview (see "details view" attachment).
But the "online update" dialog is wrong.
Comment 8 Jack 2020-07-09 15:13:50 UTC
OK, I finally see.  I'm using 5.08 on Artix Linux, and it works fine for me.  Please look in the other tab of the Investments view, just to confirm the data for Adidas is the saem.
Is the problem the same for any other stock?  You can try adding one just to test.
Comment 9 firefox-112 2020-07-09 15:28:42 UTC
Strange thing, you are using the released 5.08 or some nightly stuff?

I've checked the following:
- edited investment
- created investment
- changed online source
- created new and empty workspace and created investments
- changed language to US english

--> leads to the same issue, it uses the Name instead of the ID.
Comment 10 Jack 2020-07-09 15:44:50 UTC
I just tested on 5.0.8 official release for Artix Linux, and it works correctly.  Are you also using the official Kubuntu release of KMM?

Do you get the same problem with other stocks?  If you can create a new kmy file with just the one account and one stock, and it shows the problem, you can attach it to the bug, so someone can check if there is a problem in the file.
Comment 11 Thomas Baumgart 2020-07-11 05:05:15 UTC
I doubt this is related to the KMyMoney version both of you are using. I could imagine though, that the cause is burried in the data.

What is the output if you run the following command:

  zgrep Adidas "your-file-name-here" | grep SECURITY

This should provide lines that do not contain sensitive information but rather show us the raw base data for the investments.

BTW: "Bankleitzahl" in the details dialog is the wrong translation, it should rather be "Identifikationsnummer", but that is a different story.
Comment 12 firefox-112 2020-07-12 11:45:36 UTC
It returns:
  <SECURITY id="E000021" name="Adidas" trading-market="AMEX" type="0" rounding-method="7" symbol="DE000A1EWWW0" saf="100" pp="4" trading-currency="EUR">


I guess I might have figured it out.
When setting the very global option "Online Quotes -> Identify by = Name" it seems to copy the Name into the ID field, which is unexpected but another 'issue'.
When setting this option to "Symbol", it fills the table with both Symbol and name.
This also explains why creating a new worksheet has shown the same behaviour.

ALthough the behaviour is confusing, I guess this issue is a non-issue then.
Comment 13 Jack 2020-07-12 14:16:27 UTC
If you can make any suggestions for improved wording in the handbook, I'll be glad to work with it.
Comment 14 Jack 2020-07-19 15:50:26 UTC
I'm going to close this, but I'm still willing to consider any specific suggestions for the documentation.
Comment 15 firefox-112 2020-07-21 08:16:25 UTC
I am not Sure if it is about the docs, I think it is more a slightly unexpected behaviour.

But if you do not want to 'fix' copying the Name into the ID column, maybe you could mention my issue aƟ a caveat, something like 'check the global Option'identify by Name. This Option is a System wide Option and applies to all worksheets'.
Maybe this could help the next user stumbling over  this behaviour.