Dave
My comments are in-line:
On 14/05/2019 09:07, DaveW wrote:
I modified the AlphaVantge.pm file as you suggested. That it was a
read-only file I had quite a lot of problems saving the modification.
For want of a better solution I resorted to use Master Commander, (sudo
mc), simply because I don't know how to open a file as Root. What is a
better method???
The way I edit "system" files is:
(1) Find the file I want to edit. I find that the Terminal command
locate / AlphaVantage.pm (or whatever the file name is) is far
more useful than the find file button in the graphical interface
(2) Using the graphical interface open the directory that contains the
file (slightly counter-intuitive but hang on!)
(3) Right click in a blank area of the display and select
Open In Terminal
(4) Optional (but a good idea!) check you're in the right place by
giving the command ls and confirm that Alphavantage.pm appears in
the output
(5) Give the command sudo nano AlphaVantage.pm nano is a generally
available, simple(ish) text editor.
(6) Make the necessary changes.
(7) Write out the modified file using CTRL+O (it'll ask whether you
want to overwrite the file, just click ENTER)
(8) Exit nano by keying CTRL+X
(9) Close the Terminal
(10) Job done - well for me it was!
Whether it's better than Master Commander I don't know having never used
the latter (or ever even hearing of it!), I suppose that's a matter of
personal choice.
Yes I confirrmed I have an API key.
That's good - without you ain't going nowhere! (A colloquial expression
which means exactly the opposite of what it says - but, at least, it
does allow me to use the word "colloquial"))
But . . . when setting up the Securities, in the "Get online quotes
section, I run into trouble again. My securities are all on the
Australian Stock Exchange (ASX). The only AlphaVantage selection
available is AlphaVantage US. I now don't know quite how to set up the
Get Online Quotes section. I have tried a few of the many
combinations of selections to no avail.
It appears that what was AlphaVantage in the "Unknown" section of the
Edit Security window has been renamed as AlphaVantage, US in the
"Single" section (I don't know why). For me - and my UK shares -
choosing AlphaVantage, US gave me all the information I needed (I don't
know why - some things I just accept). Try it, it may work for ASX
shares as well - we can but hope.
Can you help me further please. What other information should I
provide?
Hopefully, that's sufficient for you
Best wishes
Eric
=============================
On Sat, 11 May 2019 11:20:11 +0100
Eric Coates <eric.coa...@sky.com> wrote:
My apologies.
I am going to swear!
The message below is not the one I sent; lots of asterixes have been
added, to get the correct message remove all of them (and if you want
to see the original, enbolden the text they delineate)
I was trying to make the text more readable by emphasising the
important bits - I'm going to have to rethink how that's possible.
Eric
====================================
On 11/05/2019 11:12, Eric Coates wrote:
Hi (again!)
OK, if you had AlphaVantage working at some time you'll have an
AlphAvantage API key.
(In GnuCash 3.5 you can confirm this by going through*Edit >
Preferences > Online Quotes *and confirming that the key appears
there)
It sounds as if you've hit the problem with AlphaVantage throttling
the queries; the way to overcome this is to modify the file
*AlphaVantage.pm.* I had problems finding the correct file to
modify but I think in Ubuntu 18.04 it is
at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at
*usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more
exact, that's where it was/is on my system; if it's not there a
hint (given by John Ralls a while ago) is to look in the
*/etc/share* directory and look in folders called perl or perl5.
Having found the file it needs to be modified to add in a delay
that overcomes the throttling problem. Very close to the end of the
file there is a line
*select(undef, undef, undef, .7) if ($quantity);*
(although, to be honest, I can't swear that the final semi-colon
appears) that needs to be modified to read
*select(undef, undef, undef, .7) if ($quantity); sleep(15);*
(the modified line does need the semi-colon).
It took me some time to gather the courage to go in and modify a
"system" file; if you share my discomfort I can provide some
guidance on how to do it.
Best wishes
Eric
**
On 11/05/2019 02:18, DaveW wrote:
Where, please, can I get wo-to-go instructions to get my stock
Price Editor (Re)working??
I am running Ubuntu 18.04. GNC ver 3.5. My stock is all on the
ASX (Australia). Things worked wonderfully until the Yahoo demise
and then for a while I was able to use Alphvantage but that
stopped too.
I have tried all sorts of fixes randomly and fear I have completely
confused GNC in the process.
I would greatly appreciate some step by step assistance.
Dave W
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
----- 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
