Fwd: Unable to download stock quotes

Steven Anter anter.s at gmail.com
Sat Mar 24 01:53:14 EDT 2018 

---------- Forwarded message ----------
From: Steven Anter <anter.s at gmail.com>
Date: Fri, Mar 23, 2018 at 10:44 PM
Subject: Re: Unable to download stock quotes
To: Chris Good <goodchris96 at gmail.com>


C:\Program Files (x86)\gnucash\bin>echo %PATH%
C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Program
Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files
(x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\
WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\
WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL
SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL
SDK\2.0\bin\x64;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files
(x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Skype\Phone\;C:\
Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\
Strawberry\perl\bin;C:\Users\Steven\AppData\Local\Microsoft\WindowsApps;

C:\Program Files (x86)\gnucash\bin>
C:\Program Files (x86)\gnucash\bin>perl -v

This is perl 5, version 26, subversion 1 (v5.26.1) built for
MSWin32-x86-multi-thread-64int

Copyright 1987-2017, Larry Wall

Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.

On Fri, Mar 23, 2018 at 10:29 PM, Steven Anter <anter.s at gmail.com> wrote:

> I'm using strawberry perl
>
> On Fri, Mar 23, 2018 at 10:28 PM, Steven Anter <anter.s at gmail.com> wrote:
>
>> I'm an Administrator
>> This is my computer
>> I used netplwiz to verify and ran   *echo (yahoo_json "CBA.AX
>> <http://cba.ax/>") | perl gnc-fq-helper*
>>
>> On Fri, Mar 23, 2018 at 10:24 PM, Steven Anter <anter.s at gmail.com> wrote:
>>
>>>
>>>
>>> *when I run: echo (yahoo_json "CBA.AX <http://cba.ax/>") | perl
>>> gnc-fq-helper*
>>>
>>> I now get this
>>>
>>>
>>> (("CBA.AX" (symbol . "CBA.AX") (gnc:time-no-zone . "2018-03-22
>>> 12:00:00") (last . 72.81) (currency . "AUD")))
>>>
>>> On Fri, Mar 23, 2018 at 10:15 PM, Steven Anter <anter.s at gmail.com>
>>> wrote:
>>>
>>>> I used the cpan command
>>>>
>>>>
>>>> On Fri, Mar 23, 2018, 9:41 PM Chris Good <goodchris96 at gmail.com> wrote:
>>>>
>>>>> Hi Steven,
>>>>>
>>>>>
>>>>>
>>>>> Do you mean you used the cpan command to find the version of
>>>>> Finance::Quote
>>>>>
>>>>> or you logged in as a user that does have administrative privileges?
>>>>>
>>>>>
>>>>>
>>>>> Please answer all the questions I ask, and tell me exactly what you
>>>>> have done, to speed up a resolution.
>>>>>
>>>>>
>>>>>
>>>>> Reinstalling may help but if you don’t have administrative privileges,
>>>>> it may cause more issues.
>>>>>
>>>>>
>>>>>
>>>>> We should try a few other things before reinstalling GnuCash.
>>>>>
>>>>>
>>>>>
>>>>> Re the “access denied” error from *perl gnc-fq-check:*
>>>>>
>>>>> What happens when you try running
>>>>>
>>>>> *cd \Program Files (x86)\gnucash\bin*
>>>>>
>>>>> *echo (yahoo_json "CBA.AX <http://CBA.AX>") | perl gnc-fq-helper*
>>>>>
>>>>> from an administrative command prompt?
>>>>>
>>>>>
>>>>>
>>>>> What is your login name?
>>>>>
>>>>> Are you an administrator?
>>>>>
>>>>>
>>>>>
>>>>> In File Explorer, right click on C:\Program Files
>>>>> (x86)\gnucash\bin\gnc-fq-check,
>>>>>
>>>>> Properties, Security Tab.
>>>>>
>>>>> Click on each of the entries in ‘Group or user names’.
>>>>>
>>>>> Under Permissions for Users, for each, it should show at least “Read &
>>>>> Execute” & “Read” is allowed, as follows:
>>>>>
>>>>>
>>>>>
>>>>> Note my pc name is goodi7.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Are you using strawberry perl or ActiveState perl?
>>>>>
>>>>> If you are using strawberry perl, which you should be, you should see
>>>>> only that in
>>>>>
>>>>> Start, Settings, Apps, not ActiveState.
>>>>>
>>>>>
>>>>>
>>>>> Please paste in the response from running the following in a command
>>>>> prompt (NOT administrative):
>>>>>
>>>>> *echo %PATH%*
>>>>>
>>>>> *perl -v*
>>>>>
>>>>>
>>>>>
>>>>> If you are a programmer , you can debug the problem using:
>>>>>
>>>>> *cd \Program Files (x86)\gnucash\bin*
>>>>>
>>>>> *echo (yahoo_json "CBA.AX <http://CBA.AX>") | perl -d gnc-fq-helper*
>>>>>
>>>>> If you open in WordPad:
>>>>>
>>>>> *C:\strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm*
>>>>>
>>>>> And change the Page Setup to landscape, do you see the following lines
>>>>> which are only in my fixed YahooJSON.pm:
>>>>>
>>>>>
>>>>>
>>>>> # MS Windows strftime() does not support %T so use %H:%M:%S
>>>>>
>>>>>                 #  instead.
>>>>>
>>>>>                 $my_date =
>>>>>
>>>>>                     localtime($json_timestamp)->strftime('%d.%m.%Y
>>>>> %H:%M:%S');
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Regards, Chris Good
>>>>>
>>>>>
>>>>>
>>>>> *From:* Steven Anter <anter.s at gmail.com>
>>>>> *Sent:* Saturday, 24 March 2018 1:45 PM
>>>>> *To:* Chris Good <goodchris96 at gmail.com>
>>>>> *Subject:* Re: Unable to download stock quotes
>>>>>
>>>>>
>>>>>
>>>>> Chris,
>>>>>
>>>>>
>>>>>
>>>>> I followed your instructions.  I have 1.47.   Perhaps I should
>>>>> uninstall and then reinstall gnucash?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>>>>>
>>>>> Virus-free. www.avast.com
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Mar 21, 2018 at 10:18 PM, Chris Good <goodchris96 at gmail.com>
>>>>> wrote:
>>>>>
>>>>> Hi Steven,
>>>>>
>>>>>
>>>>>
>>>>> Well that’s strange.
>>>>>
>>>>> Was Gnucash perhaps installed when signed on as another user?
>>>>>
>>>>> Try running the echo command from an administrative command prompt.
>>>>>
>>>>>
>>>>>
>>>>> If you don’t have administrative privileges, login to Windows as a
>>>>> user that does.
>>>>>
>>>>>
>>>>>
>>>>> Another way to check the version of Finance::Quote:
>>>>>
>>>>>   From a command prompt (NOT run as administrator):
>>>>>
>>>>>                cpan
>>>>>
>>>>>                m Finance::Quote
>>>>>
>>>>>                quit
>>>>>
>>>>>
>>>>>
>>>>> If your Finance::Quote is not 1.47:
>>>>>
>>>>> cpan
>>>>>
>>>>>                upgrade Finance::Quote
>>>>>
>>>>>                quit
>>>>>
>>>>> After you upgrade Finance::Quote you will need to reinstall my fixed
>>>>> YahooJSON.pm.
>>>>>
>>>>>
>>>>>
>>>>> Good luck, Chris Good
>>>>>
>>>>>
>>>>>
>>>>> *From:* Steven Anter <anter.s at gmail.com>
>>>>> *Sent:* Wednesday, 21 March 2018 4:49 PM
>>>>>
>>>>>
>>>>> *To:* Chris Good <goodchris96 at gmail.com>
>>>>> *Subject:* Re: Unable to download stock quotes
>>>>>
>>>>>
>>>>>
>>>>> Chris,
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> When I try to execute this:
>>>>>
>>>>> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>>>>>
>>>>>
>>>>>
>>>>> I get
>>>>>
>>>>> Access Denied
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>>>>>
>>>>> Virus-free. www.avast.com
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good <goodchris96 at gmail.com>
>>>>> wrote:
>>>>>
>>>>> Hi Steve,
>>>>>
>>>>>
>>>>>
>>>>> Hmm.. works for me.
>>>>>
>>>>> What version of Finance::Quote do you have:
>>>>>
>>>>>
>>>>>
>>>>> Do
>>>>>
>>>>>
>>>>>
>>>>> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>>>>>
>>>>>
>>>>>
>>>>> Response should be:
>>>>>
>>>>> ("*1.47*" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr"
>>>>> "asia" "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
>>>>> "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
>>>>> "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
>>>>> "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland"
>>>>> "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct"
>>>>> "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock"
>>>>> "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar"
>>>>> "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania"
>>>>> "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds"
>>>>> "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct"
>>>>> "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa"
>>>>> "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia"
>>>>> "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za"
>>>>> "za_unittrusts")
>>>>>
>>>>>
>>>>>
>>>>> You should have version 1.47 at the start of the response. This is the
>>>>> latest.
>>>>>
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>>
>>>>> Chris Good
>>>>>
>>>>>
>>>>>
>>>>> *From:* Steven Anter <anter.s at gmail.com>
>>>>> *Sent:* Wednesday, 21 March 2018 4:29 PM
>>>>> *To:* Chris Good <goodchris96 at gmail.com>
>>>>> *Subject:* Re: Unable to download stock quotes
>>>>>
>>>>>
>>>>>
>>>>> Chris,
>>>>>
>>>>> I ran this in the command prompt
>>>>>
>>>>>
>>>>>
>>>>> *C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CBA.AX
>>>>> <http://CBA.AX>") | perl gnc-fq-helper*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> This is all that returned:
>>>>>
>>>>> *(#f)*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>>>>>
>>>>> Virus-free. www.avast.com
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Mar 20, 2018 at 10:08 PM, Chris Good <goodchris96 at gmail.com>
>>>>> wrote:
>>>>>
>>>>> Hi Steven,
>>>>>
>>>>>
>>>>>
>>>>> Instructions are in the nabble link. GnuCash does not have to be
>>>>> running.
>>>>>
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>>
>>>>> Chris Good
>>>>>
>>>>> Mobile 0484 001 392
>>>>>
>>>>>
>>>>>
>>>>> *From:* Steven Anter <anter.s at gmail.com>
>>>>> *Sent:* Wednesday, 21 March 2018 4:06 PM
>>>>> *To:* Chris Good <goodchris96 at gmail.com>
>>>>> *Subject:* RE: Unable to download stock quotes
>>>>>
>>>>>
>>>>>
>>>>> Chris,
>>>>>
>>>>> I know how to run a command from the prompt.
>>>>>
>>>>> But what's the command?
>>>>>
>>>>> Can I run it from any directory?
>>>>>
>>>>> Does gnucash have to be running?
>>>>>
>>>>>
>>>>>
>>>>> On Mar 20, 2018 10:02 PM, "Chris Good" <goodchris96 at gmail.com> wrote:
>>>>>
>>>>> Hi Steven,
>>>>>
>>>>>
>>>>>
>>>>> Type into Google: how to run a command prompt
>>>>>
>>>>>
>>>>>
>>>>> Sorry to seem unhelpful but the GnuCash Users email list is not the
>>>>> place to teach basic computer usage.
>>>>>
>>>>> Google is your friend.. or perhaps you have a friend who is computer
>>>>> savvy?
>>>>>
>>>>>
>>>>>
>>>>> Regards, Chris Good
>>>>>
>>>>>
>>>>>
>>>>> *From:* Steven Anter <anter.s at gmail.com>
>>>>> *Sent:* Wednesday, 21 March 2018 3:43 PM
>>>>> *To:* Chris Good <goodchris96 at gmail.com>
>>>>> *Cc:* gnucash-user at gnucash.org
>>>>> *Subject:* RE: Unable to download stock quotes
>>>>>
>>>>>
>>>>>
>>>>> How do I run the test from command prompt
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

More information about the gnucash-user mailing list