Re: [GNC] Gnucash 5.1 Online Quotes not working

[Thornefamilytrust]

Kalpesh - 

 

Some success .

 

My perl location the same as below

 

Setup clean GNU with BRK-B using Alphavantage and ANZ with ASX the price for
both updates when running the Get Quotes

 

But . using same settings in current GNU file there I can still not update
quotes

 

From: Kalpesh Patel  
Sent: Wednesday, May 24, 2023 11:21 PM
To: 'Murugan Muruganandam' ;
thornefamilytr...@bigpond.com; 'David H' 
Cc: gnucash-user@gnucash.org
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

 

Kevin -

 

In addition to below what Murugan has mentioned . two additional items to
try:

 

1.  Check which perl is GNC using (this is to eliminate munged up path
or GNC is looking at different Perl install base - unlikely but validation
won't hurt)

To do so, type in following in an clean CMD window:

 

where Perl

 

This for me returns back 'C:\Strawberry\Perl\bin\perl.exe'

 

2.  Start with a clean slate in GNC . also recommend that you fully turn
off Norton mal-ware/anti-virus software for duration of this clean slate
test. 

a.  Open GNC 

Select 'File' -> 'New File' (select default all the way through and save the
file as 'test' or something like that at a known location in a separate
folder. You'll want to delete the folder once test is over)

b.  Define the 'Berkshire Hathaway Inc Class B' security as previously
mentioned and only this one security precisely as detailed in prior email.
c.  Update prices
d.  Review if prices got retrieved

 

Few notes:

 

On 'Change the symbol for Berkshire to BRK.B from BRK-B', for me when the
source is set to 'Yahoo as JSON', BRK-B (one with the dash) retrieves
prices. There is likely a chance that different price sourcer might set the
symbol format differently - this is the experimentation part which is to
figure out what security works with which price source as mentioned earlier
in the thread. If you want an alternate that does not have a complication of
different classes of security then try the below simpler one:

 

Security Information:

Full Name: BANK OF NEW YORK MELLON CORP COM

Symbol/abbreviation: BK

Display symbol: BK

Namespace: NYSE

ISIN, CUSIP or other code: 

Fraction traded 1/:1000

 

Quote Source Information:

--tick 'Get Online Quotes'

Type of quote source:

--click 'Single' and field next to it needs to read 'Yahoo
as JSON' (scroll down the drop down by clicking the arrow on the right side
and then select it from the list. )

 Timezone: Use local time

 

Prices pull for 'BRK-B' via 'Yahoo as JSON' source was working for me as of
this writing but your mileage may very if Yahoo is in middle of shutdown of
v6 spigot (David H mentioned this).

 

 

 

From: Murugan Muruganandam mailto:m.muruganan...@hotmail.com> > 
Sent: Wednesday, May 24, 2023 10:49 AM
To: thornefamilytr...@bigpond.com  ;
'David H' mailto:hell...@gmail.com> >
Cc: 'Kalpesh Patel' mailto:kalpesh.pa...@usa.net> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] Gnucash 5.1 Online Quotes not working

 

 

couple of things from your screen shots

 

1.  Change the symbol for Berkshire to BRK.B from BRK-B
2.  for ANZ choose single quote and exchange as Australian Stock
Exchange, AU

 

 

 

Saludos Cordiales

 

Murugan

  _  

From: gnucash-user
mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on
behalf of thornefamilytr...@bigpond.com
  mailto:thornefamilytr...@bigpond.com> >
Sent: Wednesday, May 24, 2023 3:43 AM
To: 'David H' mailto:hell...@gmail.com> >
Cc: 'Kalpesh Patel' mailto:kalpesh.pa...@usa.net> >;
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Gnucash 5.1 Online Quotes not working 

 

Thanks David that works - still no online quotes in Gnucash

 

I can run gnucash-cli from the CMD and get the desired results for ASX and
ALPHAVANTAGE as per attached, but no online quotes within Gnucash - see
settings attached.

 

Is there another step I need to do in Gnucash to get this to work?

 

 

 

From: David H mailto:hell...@gmail.com> > 
Sent: Wednesday, May 24, 2023 1:07 PM
To: thornefamilytr...@bigpond.com  
Cc: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >;
gnucash-user@gnucash.org  
Subject: Re: [GNC] Gnucash 5.1 Online Quotes not working

 

It's a windows exe and you'll need double quotes around the path name
because of the embedded spaces - see Geert's email -
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106961.html

 

 Try the following in a windows command prompt, you should see similar
results

 

Cheers David H.

 

C:\Users\David>"c:\Program Files (x86)\gnucash\bin\gnucash-cli" --quotes
info


Found Finance::Quote version 1.55.
Finance::Quote sources:
aex  alphavantage   

[GNC] Revisiting Quotes

[R Losey]

>From the discussion here, one would get the idea that the only two options
for quotes are Alphavantage and Yahoo/JSON... don't the other options work?
I seem to remember seeing a very long list of options.

Thanks!

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and not working

[Murugan Muruganandam]

Yahoo has disruptions again. Bruce is working on alternatives 


Regard

Murugan


> On 25-05-2023, at 14:44, Kalpesh Patel  wrote:
> 
> I am getting an error. 
> 
> I am in the US. 
> 
> -Original Message-
> From: Murugan Muruganandam  
> Sent: Wednesday, May 24, 2023 2:51 PM
> To: David Carlson ; Carsten Hütter 
> 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and 
> not working
> 
> yahoo v6 is back on line
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> David Carlson 
> Sent: Wednesday, May 24, 2023 12:30 PM
> To: Carsten Hütter 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and 
> not working
> 
> I concur there was a change to Yahoo as JSON v6 yesterday May 23.  I am 
> changing the Title (I hope)
> 
>> On Wed, May 24, 2023 at 10:51 AM Carsten Hütter 
>> wrote:
>> 
>>> Am 24.05.2023 um 11:46 schrieb David H:
>>> [...]
>>> 
>>> On another note it for anyone else reading this it seems Yahoo have
>> turned
>>> off access to the version 6 api as I am now getting a HTTP Response 
>>> 404 (Not Found) error when trying to use it and have had to revert 
>>> my YahooJSON.pm module to use v7 which gives an unauthorised error.
>> 
>> Yahoo now wants the user to be authorized before getting any 
>> information via API. So the Yahoo script needs to be modified to pass 
>> OAuth 2.0 credentials to Yahoo. Otherwise it won't be of any use in the 
>> future.
>> 
>>https://developer.yahoo.com/sign-in-with-yahoo/#python-step-one
>> 
>> Unfortunately, that's beyond my expertise.
>> 
>> Probably we need a separate thread for this issue.
>> 
>>> [...]
>>> gnucash-user mailing list
>>> gnucash-user@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@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.
>> 
> 
> 
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and not working

[Kalpesh Patel]

I am getting an error. 

I am in the US. 

-Original Message-
From: Murugan Muruganandam  
Sent: Wednesday, May 24, 2023 2:51 PM
To: David Carlson ; Carsten Hütter 

Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and not 
working

yahoo v6 is back on line




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David Carlson 
Sent: Wednesday, May 24, 2023 12:30 PM
To: Carsten Hütter 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and not 
working

I concur there was a change to Yahoo as JSON v6 yesterday May 23.  I am 
changing the Title (I hope)

On Wed, May 24, 2023 at 10:51 AM Carsten Hütter 
wrote:

> Am 24.05.2023 um 11:46 schrieb David H:
> > [...]
> >
> > On another note it for anyone else reading this it seems Yahoo have
> turned
> > off access to the version 6 api as I am now getting a HTTP Response 
> > 404 (Not Found) error when trying to use it and have had to revert 
> > my YahooJSON.pm module to use v7 which gives an unauthorised error.
>
> Yahoo now wants the user to be authorized before getting any 
> information via API. So the Yahoo script needs to be modified to pass 
> OAuth 2.0 credentials to Yahoo. Otherwise it won't be of any use in the 
> future.
>
> https://developer.yahoo.com/sign-in-with-yahoo/#python-step-one
>
> Unfortunately, that's beyond my expertise.
>
> Probably we need a separate thread for this issue.
>
> > [...]
> > gnucash-user mailing list
> > gnucash-user@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@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.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@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@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.

Re: [GNC] reporting currency

[Murugan Muruganandam]

Open the environment file in the  GNC_CONF path (you can see it in Help - about)

insert the following
LANG=ms_MY

save it as environment.local

restart GNUCash and you will be able to see MYR as your base currency.



Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of John 
Ralls 
Sent: Thursday, May 25, 2023 9:49 AM
To: David Long 
Cc: D. via gnucash-user 
Subject: Re: [GNC] reporting currency

Reinstalling GnuCash won't change anything.

There are two default currency preferences, one for reports and the other for 
creating new accounts. They both work the same way: They offer the locale 
currency, which is set from the environment, or a combo box with a currency you 
select. In order to enable the combo box you must first select the Choose radio 
item.

Another option would be to change the environment so that the Locale currency 
is MYR. You can do that globally according to your OS or just for GnuCash, see 
https://wiki.gnucash.org/wiki/Locale_Settings.

Finally, remember that you can change the currency in report options for each 
report individually.

Regards,
John Ralls


> On May 25, 2023, at 05:29, David Long  wrote:
>
> I have been using GnuCash on a laptop which became problematic, so I
> installed it on a new laptop. Its so happened that I bought that laptop,
> whilst in the UK, whereas the business I am using it for is in Malaysia,
> where the currency is Malaysian MYR.
> All the historic data is MYR. However, when I installed Gnucash, it seemed
> to have defaulted to British Pounds as the local currency. So now the
> reporting does not work, as it tries to report in Pounds.
>
> I have tried to change the local currency in Preferences, wherever I can
> find it, but I cannot change the local currency as it is greyed out.
>
> What can I do?I am thinking I should reinstall GnuCash.
>
> Thanks
>
> David Long
> ___
> gnucash-user mailing list
> gnucash-user@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@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@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.

Re: [GNC] reporting currency

[John Ralls]

Reinstalling GnuCash won't change anything.

There are two default currency preferences, one for reports and the other for 
creating new accounts. They both work the same way: They offer the locale 
currency, which is set from the environment, or a combo box with a currency you 
select. In order to enable the combo box you must first select the Choose radio 
item.

Another option would be to change the environment so that the Locale currency 
is MYR. You can do that globally according to your OS or just for GnuCash, see 
https://wiki.gnucash.org/wiki/Locale_Settings.

Finally, remember that you can change the currency in report options for each 
report individually.

Regards,
John Ralls


> On May 25, 2023, at 05:29, David Long  wrote:
> 
> I have been using GnuCash on a laptop which became problematic, so I
> installed it on a new laptop. Its so happened that I bought that laptop,
> whilst in the UK, whereas the business I am using it for is in Malaysia,
> where the currency is Malaysian MYR.
> All the historic data is MYR. However, when I installed Gnucash, it seemed
> to have defaulted to British Pounds as the local currency. So now the
> reporting does not work, as it tries to report in Pounds.
> 
> I have tried to change the local currency in Preferences, wherever I can
> find it, but I cannot change the local currency as it is greyed out.
> 
> What can I do?I am thinking I should reinstall GnuCash.
> 
> Thanks
> 
> David Long
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

[GNC] reporting currency

[David Long]

I have been using GnuCash on a laptop which became problematic, so I
installed it on a new laptop. Its so happened that I bought that laptop,
whilst in the UK, whereas the business I am using it for is in Malaysia,
where the currency is Malaysian MYR.
All the historic data is MYR. However, when I installed Gnucash, it seemed
to have defaulted to British Pounds as the local currency. So now the
reporting does not work, as it tries to report in Pounds.

I have tried to change the local currency in Preferences, wherever I can
find it, but I cannot change the local currency as it is greyed out.

What can I do?I am thinking I should reinstall GnuCash.

Thanks

David Long
___
gnucash-user mailing list
gnucash-user@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.