[GNC] Price Editor Problems

[Eric Coates]

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.coates at 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 at 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 at 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 at 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.
>