[GNC] Issues Retrieving Quotes with v5.0

Wed Mar 29 11:41:32 EDT 2023

I found the problem; I thought I had switched everything over to use JSON
for prices, but I still had some using Alpha Vantage, and I don't have my
key in the iMac version of GnuCash. Once I switched the few remaining
items, the update is working fine.

On Wed, Mar 29, 2023 at 10:18 AM R Losey <rlosey at gmail.com> wrote:

> Yes, I have an M1 iMac.
>
> Getting the right JSON::Parse for my architecture was what was needed... I
> get data now.
>
> But it didn't give me the "want x86_64, have amd64" error... it just said
> it wasn't installed.
>
> Checking with GnuCash...better; not greyed out, but not working properly.
> I think something is failing, so it just stops on the others. I probably
> need to figure out where the log file is to find out which item it cannot
> get.
>
>
> On Tue, Mar 28, 2023 at 1:34 PM David Reiser <dbreiser at icloud.com> wrote:
>
>> Is your iMac an Apple Silicon (M1) machine? It’s possible to get mixed
>> architecture perl modules installed. If your gnucash-cli -Q error included
>> something like “want x86_64, have amd64”, then you definitely have an
>> incompatible version of JSON::Parse. The way around that is to enter (in
>> Terminal):
>>
>> sudo arch -arch x86_64 cpan -f JSON::Parse
>>
>> After that finishes, since gnucash-cli quits at the first error, you need
>>  to run gnucash-cli -Q again — both to ensure that the right architecture
>> JSON::Parse got installed, and to check if there are any other perl errors.
>>
>> If necessary, run the above command repeatedly, substituting any new
>> module names from arch-related error messages. When gnucash-cli -Q runs
>> without complaint, you should be able to get quotes within gnucash 5.0
>>
>> Dave
>> --
>> Dave Reiser
>> dbreiser at icloud.com
>>
>>
>>
>>
>>
>> On Mar 28, 2023, at 1:27 AM, R Losey <rlosey at gmail.com> wrote:
>>
>> David, thank you.
>>
>> I did this on my iMac; it ran a LONG time with LOTS of output, and
>> installed the development tools, but finally finished. Even though I'm a
>> software engineer, it was kind of scary.
>>
>> But the "Get Quotes" is still greyed out, even though I ran the
>> gnc-fq-update...
>>
>> When I attempt the gnucash-cli command, it fails, stating that
>> Finance::Quote is missingcthe JSON::Parse module
>>
>>
>> On Mon, Mar 27, 2023 at 3:49 PM David H <hellvee at gmail.com> wrote:
>>
>> Michael,
>>
>> Is your "Get Quotes" button in Gnucash also greyed out?  I had to run
>> gnc-fq-update in /Applications/Gnucash.app/Contents/Resources/bin in the
>> terminal on macOS and let it update and then start Gnucash before the
>> button became active. Same in windows 11 pro - open a command prompt as
>> Administrator and use the command perl "C:\Program Files
>> (x86)\gnucash\bin\gnc-fq-update" - you need the double quotes around the
>> path because of the space in the path. After I did this it all seemed ok.
>>
>> Hope this helps,
>>
>> Cheers David H.
>>
>>
>>
>> On Tue, 28 Mar 2023 at 06:24, Fross, Michael <michael at fross.org> wrote:
>>
>> Hello everyone,
>>
>> I'm looking for a few pointers on how to troubleshoot an issue I'm having
>> with v5 downloading quotes.  I had no issues with v4.13.  When I select
>> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
>> nothing is updated.
>>
>> I don't seem to have any issues with gnucash-cli.  Here are the results:
>> ---
>> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
>> yahoo_json acn
>> acn:
>>     isodate => 2023-03-27
>>         low => 270.64
>>        type => EQUITY
>>        name => acn (Accenture plc)
>>          pe => 25.180145
>>    exchange => Sourced from Yahoo Finance (as JSON)
>>         eps => 10.88
>>    currency => USD
>>      method => yahoo_json
>>     success => 1
>>      volume => 2805531
>>       close => 272
>>        date => 03/27/2023
>>  year_range =>        242.8 - 345.3
>>        last => 273.96
>>        open => 270.73
>>   div_yield => 1.5919117
>>      symbol => acn
>>        high => 274.36
>> ---
>>
>> Running gnucash with the "--log gnc.scm=debug"  shows the following
>>
>> error:
>>
>>
>> * 15:11:29 ERROR <gnc.gui> [gnc_prices_dialog_get_quotes_clicked()] Price
>> retrieval failed: Failed to parse result returned by Finance::Quote.
>> Error message:
>> <unspecified file>(1): expected value
>>
>>
>> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
>> itself does not.
>>
>> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>>
>> Lastly, if I check the security editor, it seems like every quote
>>
>> provider
>>
>> is greyed out.  This woudl suggest to me that gnucash doesn't think there
>> is a valid Finance::Quote configured.
>>
>> I'd appreciate any pointers on how to dig deeper and determine what broke
>> for me between 4.13 and 5.0.  Is anyone else having issues?
>>
>> I'm enjoying v5 quite a bit - congrats on the release.
>>
>> Michael
>> _______________________________________________
>> 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
>> -----
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>> --
>> _________________________________
>> Richard Losey
>> rlosey at gmail.com
>> Micah 6:8
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>
> --
> _________________________________
> Richard Losey
> rlosey at gmail.com
> Micah 6:8
>

-- 
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8