[GNC] stocks/tickers

[James Baxter via gnucash-user]

Sir. 
I really don't like this at all. I have said before, "SORRY" if I did something 
wrong. But I think if there is a problem, I wish to be told.  

I set up a dummy account to work with the GNUCASH.  I am looking to see how the 
stocks/ticker work over the internet.But for some reason. I have read about all 
of the help. even the Google.com but not seeing what I am looking for. I know 
the program was writen some time ago. But updating it is not easy.
 I am not getting email back. Would like to know why 
James baxterkangaro...@yahoo.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Finance-Quote 1.53 released!

[Eric Coates via gnucash-user]

There's a lot of people involved! Thanks to all of them

Eric

==

On 09/10/2022 02:35, Bruce Schuck wrote:
New version 1.52 (*sic*) of Finance-Quote is available with the 
following changes:

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] stocks/tickers

[Geoff]

Hello James Baxter

> I really don't like this at all.
What don't you like?
Please articulate what is the "this" that you don't like.


> I am looking to see how the stocks/ticker work over the internet.
> I have read about all of the help. even the Google.com
Well done!  That is a very good start.
Absorbing so much information is of course difficult, so may I suggest 
that you go back and review pages 128-130 of the comprehensive 264 page 
GnuCash Help Manual that numerous volunteers have put together to assist 
you and other GnuCash users:-

https://www.gnucash.org/docs/v4/C/gnucash-help.pdf

Also, perhaps you skimmed through chapter 9.4 "Setup Investment 
Portfolio" in the outstanding 315 page GnuCash Tutorial and Concepts 
Guide?  Once again a sterling publication produced by volunteers 
cheerfully donating their spare time to assist people just like you.  I 
recommend that you revise it here:-

https://www.gnucash.org/docs/v4/C/gnucash-guide.pdf


> I am not getting email back. Would like to know why
So sad.  Most people complain of receiving too much email.
What email are you expecting to receive?
Have you checked your spam folder?
Have you checked your blocked senders list?
Perhaps the content of your email is difficult for the average mortal to 
comprehend?  Take the time and effort to go into more detail.
Perhaps the tone of your email offends some correspondents who 
consequently do not reply?  Study the cultural mores of the internet.
Or perhaps they are just flat out like a lizard drinking assisting other 
GnuCash users in their precious little free time.


Just in case you *were* wondering, the prices for your "stocks/ticker" 
do not come via email, they are updated directly into GnuCash itself. 
So please don't waste any further time trying to find those particular 
emails.


Finally, do note that email support is generally not provided in this 
forum which, in case you hadn't deduced from the name "GnuCash User", is 
dedicated to supporting GnuCash itself.  But, fear not James Baxter, all 
is not lost!  Your email corporation provides excellent dedicated around 
the clock email support for customers just like you:-

* Talk to a live expert
* No robots
* No issue is too small
* Their representatives are patient, friendly, and knowledgeable
* They'll stay on the phone with you until your problem is resolved
So, don't delay, sign up straight away at:-
https://www.yahoo.com/subscriptions/products/yahoo-plus-support-help


> I have said before, "SORRY" if I did something wrong.
Apology accepted.

> But I think if there is a problem, I wish to be told.
Well, since you asked, sadly there IS a problem.  Several problems in 
fact.  Let me set them out for you here so that there is no cause for 
any further confusion whatsoever on your own part:-

For reasons best known only to your good self, you have NOT:-
* Told us what version of GnuCash you are using
* Told us what operating system you are using
* Told us any details of how you set up your dummy account
* Told us what version of Finance Quote you have installed
* Told us what stock exchange you are using for your dummy account
* Told us what ticker symbol you are using for your dummy account
* Attached any screenshots of any of the above

Now, I know that you hold the genius-like community of GnuCash 
volunteers in the highest regard.  They are so knowledgeable and helpful 
that it is an extremely commonplace error to ascribe mystical and 
god-like powers to them when you see them resurrecting working GnuCash 
solutions from the smoking wreckage of catastrophic misinstallations, 
misconfigurations, and misunderstandings on a daily basis.  But I will 
share with you a secret if you promise faithfully not to damage their 
reputations with this knowledge.  Promise?  There is one thing that 
these near supernatural beings cannot do.  They cannot read your mind!


So James Baxter, you need to take a good hard look in the metaphorical 
mirror before gushing forth with your likes and dislikes in this manner. 
 Apart from claiming to have read "all of the help", in this email 
which you started with an unspecified dislike, you have shown no 
evidence that you have understood *any* of the copious GnuCash 
documentation that is freely available, and you provided absolutely no 
useful information whatsoever to tempt even the most saintly of 
time-poor GnuCash volunteers to assist with whatever problems you may or 
may not be having.



In closing, do please believe me James Baxter when I say that, having 
observed your correspondence trail on this forum over a number of 
months, and watched on from the sidelines as one volunteer after another 
has patiently tried to dig you out of yet another ill-described hole; I 
have reluctantly put my fingers to the keyboard once and once only to 
provide you, and only you, this specially personalised feedback with 
only your very best interests in my heart.


You have my wishes for your future GnuCash success, but (as

Re: [GNC] Finance-Quote 1.53 released!

[Bruce Schuck]

On Sun, 9 Oct 2022 09:30:23 +0100
Eric Coates writes:

> There's a lot of people involved! Thanks to all of them

The author list is created by grabbing every contributor to the GitHub 
repo with at least 2 commits. Some of those commits could be minor such 
as correcting a typo in documentation.


I may start pruning the author list published to those contributors with 
at least 3 commits.


- Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Mac Installation 4.12 issue

[Adrien Monteleone]

Dragging .app packages from a .dmg to /Applications (or ~/Applications) 
is standard for all MacOS apps not installed by the AppStore.


It is not particular to GnuCash.

Many Apps have made a handy /Applications shortcut in their .dmg main 
folder to prompt the user to do so, but that is not required, or even 
'standard' practice for MacOS apps.


If you look over the README, there are no specific detailed installation 
instructions for *any* operating system. (nothing for MacOS, Windows, 
Linux, BSD, etc.)


There *are* instructions for 'building & installing' which is a far 
different process than what you are referring to. (and perhaps could 
either be moved to the wiki entirely, or else re-titled to avoid confusion.)


It *may* be fine to add such instructions either in that file, or a 
separate INSTALL file, but the best place to make that request would be 
bugs.gnucash.org so the request/issue can be tracked.


Regards,
Adrien

On 10/8/22 11:40 AM, Hylton Conacher (ZR1HPC) wrote:

Hi,

I recently downloaded the .dmg file for my OS.

I read the README and several other of the texts and not seeing any 
reference installation on a Mac I double clicked on the GnuCash icon.


This verified the package and opened it where I was able to create a new 
set of accounts.
I was puzzled as I had not seen anything about dragging and dropping the 
executable into the Applications folder.


I carried on and made the Mac remember the icon in the task bar.

Each time I execute the app it verifies the package, asks me if I am 
sure I want to open it as it was downloaded from a website. I confirm 
and the accounts I created and saved are opened, thank goodness.


I did some Google work and found the GnuCash app does not open a window 
showing a Mac user to drag the app into the Applications folder.


I ran the .dmg again and dragged the GnuCash icon to a Finder window 
open on Applications.


My problem was solved.

Please add something into the README contents about installing on a Mac.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Problem with missing balance in a parent account

[Jay Ridgley]

Good afternoon,

Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the 
type of account I am using (Parent account  and Placeholder). I am 
including an example of my account structure here:


Banking Account (Parent Account, Placeholder)
Checkbook  (sub-account)(contains all checkbook transactions)
Reserve (sub-account) (contains minimum account balance)
Separate Purpose (sub account) (rental income & expenses)
Checkbook Blind (sub-account) (amount held as a pad)

All transactions take place in the sub-accounts. For me it has worked 
successfully since I began using GnuCash (over 25 years ago).


I was advised of a workaround that allows me to continue using this 
arrangement until it can be fixed/changed to act as it did previously.


It is as follows:
Open Parent account
right click and choose reconcile from the drop down

Works just fine.

Would not be necessary if the Reconcile button was not grayed out.

My question boils down too: Is this change a bug or a "feature" and can 
it be put back the way it was?



Please advise how I should proceed.

Thanks,
Jay

On 10/8/22 07:50, David T. wrote:
That account register doesn't have any transactions in it, so it won't 
have any value either. Is it possible that in the past, you used a 
report to see the parent account balances, or even the Chart of Accounts?


And if the account in the screen shot is a placeholder account, then you 
a) wouldn't be able to open the account by double clicking, b) be told 
on selecting Open that it was read only, and c) once opened, the entire 
register would be greyed out. The screen shot seems to show a normal 
account. It also shows a similarly-named tab next to the active tab.


David T.
On Oct 8, 2022, at 1:51 PM, Jay Ridgley > wrote:


On 10/7/22 16:38, john wrote:



On Oct 7, 2022, at 12:43 PM, Jay Ridgley
 wrote:

Good Morning,

BRAND NEW to the list, have been using GnuCash on my Ubuntu
system for over 20 years, this is the first problem I have
encountered that I have not been able to resolve.

I discovered that the balance amount that should appear in a
the parent account for my bank is missing. Therefore I am
unable to do this month's reconcile.

The account was proper last month, and I was able to balance
my checkbook successfully. In the meantime I upgraded to
Ubuntu 22.04 LTS from 20.04 LTS every thing seems to running
properly, otherwise, including GnuCash.

Today when I tried to reconcile my bank account I discovered
the amount of the balance is missing and the reconcile
button is grayed out(naturally since nothing shows).

All the sub accounts point to the parent account and when I
list my accounts the balance appears there and is correct.

What happened and how can I get it back?



Can you attach (don't inline!) a screenshot of the problem? It's
not clear from your description what balance is missing and what
button is disabled.

Regards,
John Ralls

John,

   Sorry it took so long...
The account shown is the parent and the Balance should NOT be blank, but
the sum of 4  account balances.

Thanks,
Jay



--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Problem with missing balance in a parent account

[Robin Chattopadhyay]

I have a substantially similar arrangement with sub-accounts under a
checking account. And I also use v4.12 under Ubuntu 22.04 LTS.

I suspect there are a couple of things going on:
1) When you click the Open button on the placeholder account, nothing shows
up. If you want to see the consolidated balance and listing of
transactions, in the Accounts tab, right-click on the Banking Account line
and select 'Open SubAccounts' from the pop-up menu. That will display all
the transactions in the sub-accounts
2) I agree, the Reconcile button is grayed out when you open the register
this way. I can't say if that's a feature or a bug, but it can also be
worked around by -- from the Accounts tab, right click on the Banking
Account line and select 'Reconcile' from the pop-up menu. That will open
the Reconcile Information window that you're familiar with and be sure to
select 'Include subaccounts'.

Robin

On Sun, Oct 9, 2022 at 3:49 PM Jay Ridgley  wrote:

> Good afternoon,
>
> Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the
> type of account I am using (Parent account  and Placeholder). I am
> including an example of my account structure here:
>
> Banking Account (Parent Account, Placeholder)
> Checkbook  (sub-account)(contains all checkbook transactions)
> Reserve (sub-account) (contains minimum account balance)
> Separate Purpose (sub account) (rental income & expenses)
> Checkbook Blind (sub-account) (amount held as a pad)
>
> All transactions take place in the sub-accounts. For me it has worked
> successfully since I began using GnuCash (over 25 years ago).
>
> I was advised of a workaround that allows me to continue using this
> arrangement until it can be fixed/changed to act as it did previously.
>
> It is as follows:
> Open Parent account
> right click and choose reconcile from the drop down
>
> Works just fine.
>
> Would not be necessary if the Reconcile button was not grayed out.
>
> My question boils down too: Is this change a bug or a "feature" and can
> it be put back the way it was?
>
>
> Please advise how I should proceed.
>
> Thanks,
> Jay
>
> On 10/8/22 07:50, David T. wrote:
> > That account register doesn't have any transactions in it, so it won't
> > have any value either. Is it possible that in the past, you used a
> > report to see the parent account balances, or even the Chart of Accounts?
> >
> > And if the account in the screen shot is a placeholder account, then you
> > a) wouldn't be able to open the account by double clicking, b) be told
> > on selecting Open that it was read only, and c) once opened, the entire
> > register would be greyed out. The screen shot seems to show a normal
> > account. It also shows a similarly-named tab next to the active tab.
> >
> > David T.
> > On Oct 8, 2022, at 1:51 PM, Jay Ridgley  > > wrote:
> >
> > On 10/7/22 16:38, john wrote:
> >
> >
> >
> > On Oct 7, 2022, at 12:43 PM, Jay Ridgley
> >  wrote:
> >
> > Good Morning,
> >
> > BRAND NEW to the list, have been using GnuCash on my Ubuntu
> > system for over 20 years, this is the first problem I have
> > encountered that I have not been able to resolve.
> >
> > I discovered that the balance amount that should appear in a
> > the parent account for my bank is missing. Therefore I am
> > unable to do this month's reconcile.
> >
> > The account was proper last month, and I was able to balance
> > my checkbook successfully. In the meantime I upgraded to
> > Ubuntu 22.04 LTS from 20.04 LTS every thing seems to running
> > properly, otherwise, including GnuCash.
> >
> > Today when I tried to reconcile my bank account I discovered
> > the amount of the balance is missing and the reconcile
> > button is grayed out(naturally since nothing shows).
> >
> > All the sub accounts point to the parent account and when I
> > list my accounts the balance appears there and is correct.
> >
> > What happened and how can I get it back?
> >
> >
> >
> > Can you attach (don't inline!) a screenshot of the problem? It's
> > not clear from your description what balance is missing and what
> > button is disabled.
> >
> > Regards,
> > John Ralls
> >
> > John,
> >
> >Sorry it took so long...
> > The account shown is the parent and the Balance should NOT be blank,
> but
> > the sum of 4  account balances.
> >
> > Thanks,
> > Jay
> >
>
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> htt

Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

[Chris Grinton]

Good to know that this isn't just me. Using "File > Save As" works as a
workaround for me too - good find!

Chris


On Fri, 7 Oct 2022 at 12:59, john  wrote:

> I can reproduce this with your sample file, and I discovered another
> facet: If one does a File>Save As, either to XML or SQlite3, the new file
> doesn't exhibit the behavior.
> I also found that if I remove the extra splits in the original file they
> don't come back. It's not a last-transaction issue, either: If one creates
> two transactions in a session they'll both get the Orphan and Imbalance
> splits created.
>
> I''l try watching the program load in the debugger next.
>
> Regards,
> John Ralls
>
> On Oct 5, 2022, at 9:33 PM, Chris Grinton  wrote:
>
> Good spotting on the share balance difference! I hadn't intended that in
> the screenshots; it was just a side effect of me playing around trying to
> get it to work between the first and 2nd screenshot - I had added some
> other transactions for testing that did adjust the share balance.
>
> Selecting "Edit Exchange Rate" on the CapitalLosses:CurrentYear:Realized
> split in the CapitalLosses:CurrentYear:Realized account register shows an
> error: "The two currencies involved equal each other".
>
> I can reproduce the problem by creating a brand new (empty) GnuCash file
> and then following the steps I described, and using only a single currency
> in that file. So I don't think a multi-currency factor is at play here.
>
> If it helps and I've inspired anybody to dig deeper, I've shared a
> .gnucash file at https://app.box.com/s/xdrru5yr8gjm3r7ovatmsn92jcvme053
> that can be used to reproduce: simply create a new buy or sell transaction
> involving the ACME security in the Assets:ACME Corp account, and new Orphan
> & Imbalance splits will be created in your transaction the next time the
> file is opened.
>
> Chris
>
> On Thu, 6 Oct 2022 at 11:59, john  wrote:
>
>> That looks like a proper cap gains transaction. It's odd that the share
>> balance differs by 250 between the two screenshots: Is there some other
>> transaction that might be affecting things?
>>
>> The next thought is that there might be a non-AUD transaction currency
>> involved. If you open the transaction in the
>> CapitalLosses:CurrentYear:Realized account register, right-click on the
>> split for that account, and select "Edit Exchange Rate" does it open the
>> transfer dialog or pop an error box? If the former, what is the non-AUD
>> currency/commodity it wants to price; if the latter,
>> what's the error?
>>
>> Regards,
>> John Ralls
>>
>> > On Oct 5, 2022, at 7:33 PM, Chris Grinton  wrote:
>> >
>> > Good thought - but the problem still occurs even if the share count and
>> > price are non-0. (The example transaction I've described is a simple
>> > reduction in the cost base of the asset without changing the number of
>> > shares held. But I think that is not directly relevant to the problem
>> and
>> > probably the example I described more complex than it needed to be.)
>> >
>> > Chris
>> >
>> >
>> > On Thu, 6 Oct 2022 at 09:45, R Losey  wrote:
>> >
>> >> Perhaps I'm missing something, but if there is a transaction that has a
>> >> cost of 5000, and you have shares with a price of 0, that may be
>> causing it
>> >> to think there is an imbalance, and thus the transactions get added?
>> >>
>> >> On Wed, Oct 5, 2022 at 7:09 AM Chris Grinton 
>> wrote:
>> >>
>> >>> Hi GnuCashers,
>> >>>
>> >>> I have a strange situation where a transaction is automagically (and
>> >>> unexpectedly) getting splits added to it against the
>> "Orphan-"
>> >>> and "Imbalance-" accounts when my GnuCash data file is
>> closed
>> >>> and
>> >>> reopened. I can't work out why these splits are getting added, and
>> would
>> >>> love any insights that people might have on how to stop it from
>> happening.
>> >>>
>> >>> The unexpected behavior here appears to be somehow related to having
>> >>> trading accounts enabled, and a consequence of changing the namespace
>> of a
>> >>> security.
>> >>>
>> >>> Here are steps I do to reproduce this problem:
>> >>>
>> >>> 1. Create a transaction as follows:
>> >>>Expenses:Realised capital losses DR 5000
>> >>>Assets:Stock account CR
>> >>> 5000 (with shares & price = 0)
>> >>>
>> >>> This appears in GnuCash as per the following screenshot:
>> >>>
>> >>> [image: image.png]
>> >>>
>> >>> No change occurs to this transaction as long as I keep the GnuCash
>> file
>> >>> open.
>> >>>
>> >>> 2. Edit the UNLISTED:ACME security, and change its namespace. For
>> example,
>> >>> change the namespace from "UNLISTED" to "UNLISTED2".
>> >>>
>> >>> 3. Open a different GnuCash file (or close GnuCash), and then open the
>> >>> original file again. The act of opening the file appears to cause the
>> >>> transaction to be updated with additional splits to read as follows:
>> >>>
>> >>>Expenses:Realised capital losses DR 5000
>> >>> *Orphan-AUD

Re: [GNC] Stock/tickers Geoff

[David Carlson]

Those screenshots give more information than you realize.  I see that you
have installed GnuCash in the Linux Mint operating system.  While I have
not used  Linux Mint myself, I see from information available on
DistroWatch that Mint does not come with GnuCash pre-installed but it uses
the Debian package manager.  Thus you may have any of several different
versions of GnuCash and, in fact, any of several different versions of
Linux Mint.  Since you finally stated that you have GnuCash version 4.12,
it is possible that you have a flatpack version, which may have some quirks
different than versions available through the package manager.  While the
general principles of documenting securities in GnuCash have not changed,
some details have, so it is still of value to know the precise versions you
are using.  One area in particular that has been having  issues recently,
if you have been watching the maillist, is in downloading security prices
through the Finance/Quote module.

Your screenshots show that you have not completed the setup of a brokerage
account to contain your securities and to manage the currency transactions
that you need to purchase and sell securities as outlined in the chapter of
the help manual describing security investments.  You need to read that
chapter.  If you cannot access the manual with the F1 key, a common problem
with some GnuCash installations in Linux, you should go to the GnuCash
website and read it there.  Then you  can ask specific questions one
screenshot at a time and get good answers from the users and developers
that watch this maillist.

On Sun, Oct 9, 2022 at 3:08 PM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Geoff.I know we all make mistakes. As I am 76 years old/young. As I love
> the email you sent. I am going to read it again.i have Gnucash 4.12. As I
> know when the program was writen. it is not the same. As we need to stop
> and looking, see if we can do better.
>
> Below are some of the screen shots. I have about 8 in them. but only
> listed a few of them in the Gnucash.
> So for know. have a nice night or day.
> thanksJames baxterkangaro...@yahoo.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Price update not working

[R Losey]

I'm not fetching that many -- maybe around 18 or so (I didn't count). In
the "old" days from the GUI, it would only take seconds (that was pre-Alpha
Vantage)

I'm not sure how busy their servers are... but when I run the gnc-fq-dump
program using Alpha Vantage and getting four quotes, it returns in 1-2
seconds. I ran the full gnucash-cli program using "time", and it shows over
7 minutes to complete.

I doubt very much that my ISP is throttling me... I'm running Linux
(Ubuntu) and it is mostly idle.

Now the data file may be an idea... it's about 1.5M... it's on a NAS, so it
has to go through the home network, so that is slower... and I don't know
how much parsing the gnucash-cli program has to do.

The GnuCash GUI is also very, very slow using "multiple" (which uses Alpha
Vantage first). I didn't time it, but it was minutes.

I don't think this is network, but it may be... nothing else seems to be
slow... and the gnc-fq-dump is very fast.



On Sat, Oct 8, 2022 at 5:11 AM Geoff  wrote:

> Hi Richard
>
> Glad to hear you can now fetch prices.
>
>  > It is supposed to take so long? There is a long (7 minute) delay before
>  > the update finishes... I've been using the gnucash-cli command line.
>
> That does seem a long time, but how long is a piece of string? (as my
> father used to say ;--)
>
> How many prices are you fetching?
> How busy are Alpha Vantage's servers?
> Are Alpha Vantage throttling you?
> Is your ISP throttling you?
> How fast, and how busy, is your machine?
> How long does it take to fetch a single price manually from the command
> line?
> How long does it take to open and save your GnuCash data file?
> Have you tried using the GnuCash GUI instead of the gnucash-cli command
> line?
>
>
> As a benchmark, my 13 year old Windows 10 desktop consistently retrieves
> prices for 30 odd securities in about 3 seconds using the GnuCash GUI,
> but in my case Finance Quote pulls them directly from the local stock
> exchange and doesn't use Alpha Vantage.
>
> I did a few command line tests for a single security using Alpha Vantage
> and it averages around 2.2 seconds from the other side of the world -
> see attached screenshot.
> [Technically it is slightly quicker than this which includes invoking
> the Python interpreter to measure the elapsed time.]
>
> Perhaps others on this list who do use Alpha Vantage can relate their
> own experiences?
>
> Finally, if you do know your way around Linux, Wire Shark is your go to
> friend for network troubleshooting:
> https://www.wireshark.org/
>
>
> Good luck!
>
> Regards
>
> Geoff
> =
>
>
> On 8/10/2022 6:29 pm, R Losey wrote:
> > Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the
> > issue. Things now seem to be updating properly.
> >
> > It is supposed to take so long? There is a long (7 minute) delay before
> > the update finishes... I've been using the gnucash-cli command line.
> >
> > On Sat, Oct 8, 2022 at 1:03 AM Geoff  > > wrote:
> >
> > Hi Richard
> >
> > If you have configured your GnuCash securities to retrieve their
> prices
> > using AlphaVantage then you need to make sure that you have entered
> > your
> > API Key in GnuCash preferences.
> >
> > Also, depending on the problem, it may help if you upgrade to a later
> > version of of Finance Quote:-
> >
> >
> https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 <
> https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2>
> >
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
> <
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
> >
> >
> > Hope this helps.
> >
> > Regards
> >
> > Geoff
> > =
> >
> >
> > On 8/10/2022 4:58 pm, R Losey wrote:
> >  > I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8
> > from the
> >  > Ubuntu Software area).
> >  >
> >  > On a different Ubuntu, I had an older version running, and back
> > then, price
> >  > updates were working. I managed to mess up that gnucash Linux
> > install, so I
> >  > haven't been updating quotes - I've been using GnuCash on other
> > operating
> >  > systems, and since it is a pain to get the quotes working on
> them, I
> >  > haven't bothered.
> >  >
> >  > But now that I have a nice shiny Ubuntu, I have installed gnucash
> and
> >  > thought I'd attempt to update prices. I merely get :
> >  >
> >  > "ERROR  There was an unknown error while retrieving the
> > price
> >  >> quotes."
> >  >
> >  >
> >  > I have Finance::Quote version 1.51 - it was installed along with
> > GnuCash 4.8
> >  >
> >  > Notes:
> >  > - The reason I mentioned running updates some time ago (pre
> > version 4.0, I
> >  > think) is that perhaps I need to do something in the securities
> > editor? I
> >  > think that I no longer own s

Re: [GNC] Price update not working

[Geoff]

H I think I may have just about run out of ideas.

If the GUI is just as slow as the CLI we have ruled that variable out.

Perhaps you could try using "Yahoo as JSON" as the Quote Source in the 
Securities Editor.  It won't take you very long to swap over your 18 
securities, and this will eliminate Alpha Vantage as the cause, although 
if gnc-fq-dump is fast then this is unlikely to make a difference.


As a last resort, you can try running GnuCash in debug mode and see if 
anything useful emerges.  I don't know how to do this, but Google is 
probably your friend.


Good luck!

Geoff
=

On 10/10/2022 3:48 pm, R Losey wrote:
I'm not fetching that many -- maybe around 18 or so (I didn't count). In 
the "old" days from the GUI, it would only take seconds (that was 
pre-Alpha Vantage)


I'm not sure how busy their servers are... but when I run the 
gnc-fq-dump program using Alpha Vantage and getting four quotes, it 
returns in 1-2 seconds. I ran the full gnucash-cli program using "time", 
and it shows over 7 minutes to complete.


I doubt very much that my ISP is throttling me... I'm running Linux  
(Ubuntu) and it is mostly idle.


Now the data file may be an idea... it's about 1.5M... it's on a NAS, so 
it has to go through the home network, so that is slower... and I don't 
know how much parsing the gnucash-cli program has to do.


The GnuCash GUI is also very, very slow using "multiple" (which uses 
Alpha Vantage first). I didn't time it, but it was minutes.


I don't think this is network, but it may be... nothing else seems to be 
slow... and the gnc-fq-dump is very fast.




On Sat, Oct 8, 2022 at 5:11 AM Geoff > wrote:


Hi Richard

Glad to hear you can now fetch prices.

  > It is supposed to take so long? There is a long (7 minute) delay
before
  > the update finishes... I've been using the gnucash-cli command line.

That does seem a long time, but how long is a piece of string? (as my
father used to say ;--)

How many prices are you fetching?
How busy are Alpha Vantage's servers?
Are Alpha Vantage throttling you?
Is your ISP throttling you?
How fast, and how busy, is your machine?
How long does it take to fetch a single price manually from the command
line?
How long does it take to open and save your GnuCash data file?
Have you tried using the GnuCash GUI instead of the gnucash-cli command
line?


As a benchmark, my 13 year old Windows 10 desktop consistently
retrieves
prices for 30 odd securities in about 3 seconds using the GnuCash GUI,
but in my case Finance Quote pulls them directly from the local stock
exchange and doesn't use Alpha Vantage.

I did a few command line tests for a single security using Alpha
Vantage
and it averages around 2.2 seconds from the other side of the world -
see attached screenshot.
[Technically it is slightly quicker than this which includes invoking
the Python interpreter to measure the elapsed time.]

Perhaps others on this list who do use Alpha Vantage can relate their
own experiences?

Finally, if you do know your way around Linux, Wire Shark is your go to
friend for network troubleshooting:
https://www.wireshark.org/ 


Good luck!

Regards

Geoff
=


On 8/10/2022 6:29 pm, R Losey wrote:
 > Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the
 > issue. Things now seem to be updating properly.
 >
 > It is supposed to take so long? There is a long (7 minute) delay
before
 > the update finishes... I've been using the gnucash-cli command line.
 >
 > On Sat, Oct 8, 2022 at 1:03 AM Geoff mailto:cleanoutmys...@gmail.com>
 > >> wrote:
 >
 >     Hi Richard
 >
 >     If you have configured your GnuCash securities to retrieve
their prices
 >     using AlphaVantage then you need to make sure that you have
entered
 >     your
 >     API Key in GnuCash preferences.
 >
 >     Also, depending on the problem, it may help if you upgrade to
a later
 >     version of of Finance Quote:-
 >
 >
https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 
 
>
 >
https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz 
 
>
 >
 >     Hope this helps.
 >

Re: [GNC] Price update not working

[Ismael Smajli]

Hello Alpha Vantage's standard API usage is limited to five (5) API requests 
per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) 
Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) slightly 
above 5min for the update. Regards Ismael On 2022-10-10 12:50, R Losey 
 wrote: > > I'm not fetching that many -- maybe around 18 or 
so (I didn't count). In > the "old" days from the GUI, it would only take 
seconds (that was pre-Alpha > Vantage) > > I'm not sure how busy their servers 
are... but when I run the gnc-fq-dump > program using Alpha Vantage and getting 
four quotes, it returns in 1-2 > seconds. I ran the full gnucash-cli program 
using "time", and it shows over > 7 minutes to complete. > > I doubt very much 
that my ISP is throttling me... I'm running Linux > (Ubuntu) and it is mostly 
idle. > > Now the data file may be an idea... it's about 1.5M... it's on a NAS, 
so it > has to go through the home network, so that is slower... and 

I don't know > how much parsing the gnucash-cli program has to do. > > The 
GnuCash GUI is also very, very slow using "multiple" (which uses Alpha > 
Vantage first). I didn't time it, but it was minutes. > > I don't think this is 
network, but it may be... nothing else seems to be > slow... and the 
gnc-fq-dump is very fast. > > > > On Sat, Oct 8, 2022 at 5:11 AM Geoff 
 wrote: > > > Hi Richard > > > > Glad to hear you can 
now fetch prices. > > > > > It is supposed to take so long? There is a long (7 
minute) delay before > > > the update finishes... I've been using the 
gnucash-cli command line. > > > > That does seem a long time, but how long is a 
piece of string? (as my > > father used to say ;--) > > > > How many prices are 
you fetching? > > How busy are Alpha Vantage's servers? > > Are Alpha Vantage 
throttling you? > > Is your ISP throttling you? > > How fast, and how busy, is 
your machine? > > How long does it take to fetch a single price manually from 
the co

mmand > > line? > > How long does it take to open and save your GnuCash data 
file? > > Have you tried using the GnuCash GUI instead of the gnucash-cli 
command > > line? > > > > > > As a benchmark, my 13 year old Windows 10 desktop 
consistently retrieves > > prices for 30 odd securities in about 3 seconds 
using the GnuCash GUI, > > but in my case Finance Quote pulls them directly 
from the local stock > > exchange and doesn't use Alpha Vantage. > > > > I did 
a few command line tests for a single security using Alpha Vantage > > and it 
averages around 2.2 seconds from the other side of the world - > > see attached 
screenshot. > > [Technically it is slightly quicker than this which includes 
invoking > > the Python interpreter to measure the elapsed time.] > > > > 
Perhaps others on this list who do use Alpha Vantage can relate their > > own 
experiences? > > > > Finally, if you do know your way around Linux, Wire Shark 
is your go to > > friend for network troubleshooting: > > https://www.w

ireshark.org/ > > > > > > Good luck! > > > > Regards > > > > Geoff > > = > 
> > > > > On 8/10/2022 6:29 pm, R Losey wrote: > > > Hi... yes, I did not have 
al ALPHAVANTAGE_API_KEY and that was the > > > issue. Things now seem to be 
updating properly. > > > > > > It is supposed to take so long? There is a long 
(7 minute) delay before > > > the update finishes... I've been using the 
gnucash-cli command line. > > > > > > On Sat, Oct 8, 2022 at 1:03 AM Geoff 
 > > > wrote: > > > 
> > > Hi Richard > > > > > > If you have configured your GnuCash securities to 
retrieve their > > prices > > > using AlphaVantage then you need to make sure 
that you have entered > > > your > > > API Key in GnuCash preferences. > > > > 
> > Also, depending on the problem, it may help if you upgrade to a later > > > 
version of of Finance Quote:- > > > > > > > > 
https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 < > > 
https://github.com

/finance-quote/finance-quote/releases/tag/v1.53-rc.2> > > > > > 
https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
 > > < > > 
https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
 > > > > > > > > > Hope this helps. > > > > > > Regards > > > > > > Geoff > > > 
= > > > > > > > > > On 8/10/2022 4:58 pm, R Losey wrote: > > > > I just 
installed GnuCash on Ubuntu 22.04LTS (it is version 4.8 > > > from the > > > > 
Ubuntu Software area). > > > > > > > > On a different Ubuntu, I had an older 
version running, and back > > > then, price > > > > updates were working. I 
managed to mess up that gnucash Linux > > > install, so I > > > > haven't been 
updating quotes - I've been using GnuCash on other > > > operating > > > > 
systems, and since it is a pain to get the quotes working on > > them, I > > > 
> haven't bothered. > > > > > > > > But now that I have a nice shiny Ubuntu, I 
have installed gnucash > > and > > > > thought I'd at

tempt t

Re: [GNC] Price update not working - Alpha Vantage's limit is five (5) API requests per one (1) minute

[Ismael Smajli]

Hello Alpha Vantage's standard API usage is limited to five (5) API requests 
per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) 
Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) slightly 
above 5min for the update. Regards Ismael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Price update not working - Alpha Vantage's limit is five (5) API requests per one (1) minute

[Geoff]

Thanks for letting us know Ismael.

Richard - this looks like the explanation for the delays you are seeing.

Alpha Vantage are gently tightening the screws on their free service...

Geoff
=

On 10/10/2022 4:50 pm, Ismael Smajli wrote:

Hello Alpha Vantage's standard API usage is limited to five (5) API requests 
per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) 
Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) slightly 
above 5min for the update. Regards Ismael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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@gnucash.org
To update your subscription preferences or to unsubscribe:
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.