Fwd: Unable to download stock quotes

[Steven Anter]

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




*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
>>
>>
>>
>>
>>
>>
>>
>