[GNC] Set up a security, what now?

Thu Oct 17 11:26:46 EDT 2024

Yes namespaces are free float and are not used in the fetch. I did a quick testing now and i am able to get quotes with different namespaces.  Alphavantage gives you one day old quote, while yahoojson is fetching recent one. i think the issue may not be the name space
Flavio please run a test with the same security under two namespace and see if there is any issue

Saludos Cordiales

Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of sunfish62--- via gnucash-user <gnucash-user at gnucash.org>
Sent: 17 October 2024 12:03
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: 'sunfish62--- via gnucash-user' <gnucash-user at gnucash.org>
Subject: Re: [GNC] Set up a security, what now?

There does seem to be a disconnect between the two. I know John Ralls says the former, but I've long observed the latter. Personally, I'd prefer not to be bound by the namespace; every time there's a new commodity to add, I end up going online to figure out what exchange that stock is traded on, so that price retrieval works.

⁣David T. 

On Oct 17, 2024, 5:51 PM, at 5:51 PM, Kalpesh Patel <kalpesh.patel at usa.net> wrote:
>Hmmmm.... I thought the namespace was just a free format text that
>wasn't tied to anything for commodity pricing other than a nice way to
>tidy up commodities into groups.
>
>I must have misunderstood its purpose ... if it is indeed tied up like
>that then the source of pricing dictates the name set in the namespace?
>
>-----Original Message-----
>From: Boniforti Flavio <boniforti.f at gmail.com>
>Sent: Wednesday, October 16, 2024 4:40 PM
>To: sunfish62 at yahoo.com
>Cc: John Ralls <jralls at ceridwen.us>; sunfish62--- via gnucash-user
><gnucash-user at gnucash.org>
>Subject: Re: [GNC] Set up a security, what now?
>
>That's it, David! :-)
>You were right, here it works now:
>[image: image.png]
>
>Many thanks,
>F.
>https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216062385%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=nGDSTNxI0mCZFE0jwpZCxYW2mcTkEqvY7Opl3Vu0CV8%3D&reserved=0<https://www.instagram.com/boniforti_music>
>https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216085462%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=pheaslrfiKPKceCtH5mTST%2Fmyzd8UTfWgJLA%2BNpJ%2BhM%3D&reserved=0<https://soundcloud.com/boniforti_music>
>https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216096791%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=IHNFEZIm2BfEOqHjQfnzj2MU%2Fh9qj1w1AkNgztFU9XI%3D&reserved=0<https://bonny-j.bandcamp.com/>
>
>
>Am Mi., 16. Okt. 2024 um 22:07 Uhr schrieb sunfish62 at yahoo.com <
>sunfish62 at yahoo.com>:
>
>> I am no expert, but I see that you have the namespace as ARCA. What
>> happens if you change it to NYSEARCA? I've seen quotes fail when this
>
>> is entered incorrectly, although it may not change anything.
>>
>> David T.
>> On Oct 16, 2024, at 10:52 PM, Boniforti Flavio
><boniforti.f at gmail.com>
>> wrote:
>>>
>>> I think it's not updating, as the "price" is stil 0:
>>> [image: image.png]
>>> How can I troubleshoot?
>>> The Security has been added like this:
>>> [image: image.png]
>>>
>>> Thanks,
>>> F.
>>>
>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216107117%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=GfmLN8pNra2nB9MHDa7jfC4vj0s37QSE6r692VEaUcI%3D&reserved=0<https://www.instagram.com/boniforti_music>
>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216117479%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=hhqDHK1ane%2BZeqOHmqozSIWgDhsOE6ffjbvctfZSAXQ%3D&reserved=0<https://soundcloud.com/boniforti_music>
>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216129334%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=1S7IJflNPfP9R7NpGJaEbyFDQdOZSe%2B6JP%2BaQU4KmQ4%3D&reserved=0<https://bonny-j.bandcamp.com/>
>>>
>>>
>>> Am Mi., 16. Okt. 2024 um 19:38 Uhr schrieb sunfish62 at yahoo.com <
>>> sunfish62 at yahoo.com>:
>>>
>>>> It's not automatic. You trigger it from Tools-> Price Database ->
>>>> Get Quotes
>>>>
>>>> David T.
>>>> On Oct 16, 2024, at 11:45 AM, Boniforti Flavio
>>>> <boniforti.f at gmail.com>
>>>> wrote:
>>>>>
>>>>> Hi John.
>>>>> Sure, you're right! Found it.
>>>>>
>>>>> Now, seems that the value is not updating. I've added the VT
>>>>> security, but in the list I still see "user:price-editor", which I
>
>>>>> imagine is not correct?!
>>>>>
>>>>> How should I proceed to troubleshoot and fix the quotes updates
>not working?
>>>>>
>>>>> Thanks,
>>>>> F.
>>>>>
>>>>> John Ralls <jralls at ceridwen.us> schrieb am Mi., 16. Okt. 2024,
>04:24:
>>>>>
>>>>>  Flavio,
>>>>>>
>>>>>>  Where it always is on Mac applications: In the application
>>>>>> (Gnucash)  menu, and since macOS 14 it’s called Settings instead
>of Preferences.
>>>>>>
>>>>>>  Regards,
>>>>>>  John Ralls
>>>>>>
>>>>>>
>>>>>>  On Oct 15, 2024, at 13:06, Boniforti Flavio
>>>>>> <boniforti.f at gmail.com>
>>>>>>>
>>>>>>  wrote:
>>>>>>
>>>>>>>
>>>>>>>  Hi all.
>>>>>>>  I've added VT security in my Security Editor. I've chosen to
>>>>>>> have it  automatically updated using Alpha Vantage, for which I
>got an API key.
>>>>>>>  Now, some instructions I found tell me to go under "Edit -
>Preferences"
>>>>>>>
>>>>>>  but
>>>>>>
>>>>>>>  on MacOS with GnuCash 5.9 there's no such menu option. So my
>>>>>>> first
>>>>>>>
>>>>>>  question
>>>>>>
>>>>>>>  is: where do I have to enter the API key for Alpha Vantage?
>>>>>>>  The next question would be: how does automatic retrieval work?
>>>>>>> Will it  retrieve the value of the securities only once when I
>start GnuCash?
>>>>>>>
>>>>>>>  Thanks,
>>>>>>>  Flavio.
>>>>>>>
>>>>>>>  https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216139932%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=d%2Bp8VoqZRUs%2BPukmqxo6MXFxDlV%2BxfGzs5z8oiQEzQ0%3D&reserved=0<https://www.instagram.com/boniforti_music>
>>>>>>>  https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216150145%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=UDbYmTvn0aSKsT04j%2B3kUURdyM98vShcQTpNJulA%2BoI%3D&reserved=0<https://soundcloud.com/boniforti_music>
>>>>>>>  https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216160337%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=FkPlkF8AArByyM7UabOklYkMB2Gtyd9IfABQAAki5nM%3D&reserved=0<https://bonny-j.bandcamp.com/>
>>>>>>> ------------------------------
>>>>>>>
>>>>>>>  gnucash-user mailing list
>>>>>>>  gnucash-user at gnucash.org
>>>>>>>  To update your subscription preferences or to unsubscribe:
>>>>>>>  https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216170567%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=AUM4dTMeBCuwS55JhpcZ8%2FdIvrVls1RhrmbuUECw7O0%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>>>>>>  -----
>>>>>>>  Please remember to CC this list on all your replies.
>>>>>>>  You can do this by using Reply-To-List or Reply-All.
>>>>>>>
>>>>>>
>>>>> ------------------------------
>>>>>
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216180871%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=zu2TBlMdZc%2FW2Kd0BYc0Ysjf%2FPNDQaWDp3sLHOZmX9Y%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>>
>>>>>
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C383f144496f140a11c3b08dceebd1be5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638647743216195313%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=6O8RQiIbel1hYRDbKw7%2Fp7a4HAs0O3yLfTA5Gm%2BrcWs%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.