Re: [GNC] Finance::Quote not working on MacOS

[kunagu varun kumar]

Those links helped.. Thank you
___
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] Finance::Quote not working on MacOS

[Jim DeLaHunt]

Hello, Kunagu:

On 2023-12-05 22:35, kunagu varun kumar wrote:

Hi,

I cannot get Finance::Quote to get to working on my laptop. I’m getting an error 
"Failed to initialize Finance::Quote: missing_modules Finance::Quote”.

varun@Varun-Mac ~ % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli 
--quotes info

Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
Failed to initialize Finance::Quote: missing_modules Finance::Quote

varun@Varun-Mac ~ % sudo 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

Password:
Reading '/Users/varun/.cpan/Metadata'
   Database was generated on Wed, 06 Dec 2023 00:17:01 GMT
Test2 is up to date (1.302198).
Finance::Quote is up to date (1.58).
JSON::Parse is up to date (0.62).


Recent macOS changes, such as the advent of Apple Silicon-based Macs, 
and increased security controls, have made the methods for installing 
Finance::Quote more complex, with variations for different situations.


Some questions you can answer to help us help you:

Q1. What version of GnuCash are you using?

Q2. What version of macOS are you using?

Also, read the following sections of the GnuCash wiki, and see if they 
apply to you:








Does that help you progress?  Come back with answers to the above 
questions, and with questions based on reading the above sections of the 
wiki. Perhaps we will be able to help you some more.


Good luck!

    —Jim DeLaHunt

___
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] Finance::Quote not working on MacOS

[kunagu varun kumar]

Hi,

I cannot get Finance::Quote to get to working on my laptop. I’m getting an 
error "Failed to initialize Finance::Quote: missing_modules Finance::Quote”.

varun@Varun-Mac ~ % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli 
--quotes info

Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
Failed to initialize Finance::Quote: missing_modules Finance::Quote

varun@Varun-Mac ~ % sudo 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

Password:
Reading '/Users/varun/.cpan/Metadata'
  Database was generated on Wed, 06 Dec 2023 00:17:01 GMT
Test2 is up to date (1.302198).
Finance::Quote is up to date (1.58).
JSON::Parse is up to date (0.62).

___
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] Finance quote not working

[Paras Desai]

Hello John,

Thanks for the diagnosis – spot on.

I disabled price update for the stock from BSE and finance quote works 
just fine. I will keep it that way for the time being.


It was amazing how you devoted your time in helping me and very 
logically reached to the root of the cause.


My much gratitude and profound thanks to you for your wonderful help.

Best regards

Paras

On 09-08-2023 01:27, John Ralls wrote:

Paras,

Thanks. With that I was able to diagnose the problem: It's from a source and 
symbol that hadn't been mentioned in the thread before. I've sent you a private 
reply with which stock it is.

The problem was caused by the Finance::Quote BSEIndia.pm inserting an invalid string into 
the JSON return value, causing the parser to not parse anything. I've reported that to 
Finance::Quote ashttps://github.com/finance-quote/finance-quote/issues/335. I'll also 
make sure that GnuCash pops its "quotes not retrieved" message box when that 
happens.

In the meantime you can disable quotes on that stock while you figure out how 
to reliably retrieve quotes for it.

Regards,
John Ralls


On Aug 8, 2023, at 10:55 AM, Paras Desai  wrote:

Hello John,

Please find attached the regenerated Trace file

Thanks

Paras

On 08-08-2023 23:10, john wrote:

Prasad,

Darn it, I told you the wrong log argument. It should be 
--log=gnc.price-quotes=debug. Sorry, please try again.

Regards,
John Ralls



On Aug 8, 2023, at 10:28, Paras Desai
  wrote:






___
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] Finance quote not working

[John Ralls]

Paras,

Thanks. With that I was able to diagnose the problem: It's from a source and 
symbol that hadn't been mentioned in the thread before. I've sent you a private 
reply with which stock it is.

The problem was caused by the Finance::Quote BSEIndia.pm inserting an invalid 
string into the JSON return value, causing the parser to not parse anything. 
I've reported that to Finance::Quote as 
https://github.com/finance-quote/finance-quote/issues/335. I'll also make sure 
that GnuCash pops its "quotes not retrieved" message box when that happens.

In the meantime you can disable quotes on that stock while you figure out how 
to reliably retrieve quotes for it.

Regards,
John Ralls

> On Aug 8, 2023, at 10:55 AM, Paras Desai  wrote:
> 
> Hello John,
> 
> Please find attached the regenerated Trace file
> 
> Thanks 
> 
> Paras
> 
> On 08-08-2023 23:10, john wrote:
>> Prasad,
>> 
>> Darn it, I told you the wrong log argument. It should be 
>> --log=gnc.price-quotes=debug. Sorry, please try again.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 8, 2023, at 10:28, Paras Desai 
>>>  wrote:
>>> 
>>> 
>>> 
> 

___
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] Finance quote not working

[john]

Paras,

OK, so something in F::Q's response is creating JSON that 
boost::property_tree's parser to throw. Let's find out what that might be. 
Please run
  "C:\Program Files (x86)\gnucash\bin\gnucash.exe" --log=gnc.quotes=debug
and try the Get Quotes button. That will dump a lot more detail, including the 
JSON in each direction, into the tracefile and should help diagnose the 
problem. If you'd rather not publish your stock portfolio to the world you can 
send me the file directly.

Regards,
John Ralls

> On Aug 8, 2023, at 00:12, Paras Desai  wrote:
> 
> Thanks Jon,
> 
> My reply to your questions, Hope this will throw some light to my issue, 
> 
> 
> 
> 1. while i try to get quote, blank screen splashes (perhaps command prompt) 
> second splash screen stays for a while and goes off. No error message is 
> displayed. 
> 
> 2. As suggested by you, I located the Trace file and checked. It says : Price 
> retrieval failed: Failed to parse result returned by Finance::Quote.
> 
> 
> * 12:25:02  WARN  [GncFQQuoteSource::GncFQQuoteSource()] No 
> Alpha Vantage API key set, currency quotes and other AlphaVantage based 
> quotes won't work.
> * 12:25:04 ERROR  [webkit_resource_load_error()] WebKit load of 
> resource 
> f:/gnucash/share/guile/site/2.2/gnucash/reports/stylesheets/balsheet-eg.css, 
> type (NULL), failed due to URL cannot be shown
> * 12:25:16  WARN  [GncFQQuoteSource::GncFQQuoteSource()] No 
> Alpha Vantage API key set, currency quotes and other AlphaVantage based 
> quotes won't work.
> * 12:25:25 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price 
> retrieval failed: Failed to parse result returned by Finance::Quote.
> Error message:
> (1): expected value
> * 12:25:25  WARN  invalid cast from '(NULL)' to 'GtkWindow'
> * 12:25:25 ERROR  gtk_message_dialog_new: assertion 'parent == NULL || 
> GTK_IS_WINDOW (parent)' failed
> * 12:25:25 ERROR  gtk_dialog_run: assertion 'GTK_IS_DIALOG (dialog)' 
> failed
> * 12:25:25 ERROR  gtk_widget_destroy: assertion 'GTK_IS_WIDGET (widget)' 
> failed
> * 12:27:33  WARN  [GncFQQuoteSource::GncFQQuoteSource()] No 
> Alpha Vantage API key set, currency quotes and other AlphaVantage based 
> quotes won't work.
> * 12:27:42 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price 
> retrieval failed: Failed to parse result returned by Finance::Quote.
> Error message:
> hare/locale/en_IN/LC_MESSAGES/gnucash.mo
> * 12:27:42  WARN  invalid cast from '(NULL)' to 'GtkWindow'
> * 12:27:42 ERROR  gtk_message_dialog_new: assertion 'parent == NULL || 
> GTK_IS_WINDOW (parent)' failed
> * 12:27:42 ERROR  gtk_dialog_run: assertion 'GTK_IS_DIALOG (dialog)' 
> failed
> * 12:27:42 ERROR  gtk_widget_destroy: assertion 'GTK_IS_WIDGET (widget)' 
> failed
> 
> 
> On 08-08-2023 02:01, John Ralls wrote:
>> 
>>> On Aug 7, 2023, at 7:01 AM, Paras Desai  
>>>  wrote:
>>> 
>>> Hello Jin and all friends
>>> 
>>> Thanks for your kind help and suggestion in running command prompt. GnuCash 
>>> was installed in F drive and I forgot that, so the error message was coming,
>>> 
>>> I ran the command prompt, and it threw the result for RELIANCE, FOR 
>>> EXAMPLE, as below. So the Finance quote works, but integrated Finance quote 
>>> in GnuCash does not. What could be the next step?
>>> 
>>> Thank you.
>>> 
>>> Paras
>>> 
>>> 
>>>  close => 2523.85
>>>   symbol => RELIANCE
>>>prevclose => 2509.55
>>> open => 2521
>>>  low => 2505
>>> last => 2523.5
>>>  isodate => 2023-08-07
>>>   method => nseindia
>>> exchange => NSE
>>> high => 2528.4
>>>  success => 1
>>> currency => INR
>>> date => 08/07/2023
>>> 
>> Paras,
>> 
>> GnuCash and gnucash-cli use the same code for Finance::Quote integration, so 
>> it's not that. You reported that updating your book worked until 26 July, so 
>> something must have changed around that day. Do you remember changing 
>> anything, like updating GnuCash or Finance::Quote, that might offer a clue?
>> 
>> There may be an error in your tracefile (see 
>> https://wiki.gnucash.org/wiki/Tracefile) that explains why the prices aren't 
>> being updated.
>> 
>> When trying to retrieve quotes in the GUI are you getting the message box 
>> saying that it couldn't retrieve quotes for some stocks followed by a list 
>> of stocks that fail?
>> 
>> Regards,
>> John Ralls
>> 
>> 

___
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] Finance quote not working

[Paras Desai]

Thanks David,

Yes I have configured exactly as you have mentioned.

As advised by John, i checked Trace file, which says, failed to parse price.

So waiting for further advice under the situation.

Something seems wrong with my laptop or installation, as every one is getting 
the price update.

Hope to figure out what is going on at my end with your all help.


Thanks your kind efforts to help me out. Very much appreciated.

Get Outlook for Android<https://aka.ms/AAb9ysg>

From: David H 
Sent: Tuesday, August 8, 2023 2:35:10 AM
To: Paras Desai 
Cc: list+gnuc...@jdlh.com ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Finance quote not working

Paras,

How have you set up the security editor entry for RELIANCE in your gnucash 
file. I have set it up in my file as follows and it returns the same price 
details as gnucash-cli without error.

Cheers David H.

[image.png]

On Tue, 8 Aug 2023 at 00:02, Paras Desai 
mailto:desaipa...@outlook.com>> wrote:
Hello Jin and all friends

Thanks for your kind help and suggestion in running command prompt.
GnuCash was installed in F drive and I forgot that, so the error message
was coming,

I ran the command prompt, and it threw the result for RELIANCE, FOR
EXAMPLE, as below. So the Finance quote works, but integrated Finance
quote in GnuCash does not. What could be the next step?

Thank you.

Paras


  close => 2523.85
   symbol => RELIANCE
prevclose => 2509.55
 open => 2521
  low => 2505
 last => 2523.5
  isodate => 2023-08-07
   method => nseindia
 exchange => NSE
 high => 2528.4
  success => 1
 currency => INR
 date => 08/07/2023
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto: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] Finance quote not working

[Paras Desai]

Thanks Murugan,

I do not use NS extension. I have been getting the prices  and suddenly it 
stopped. I have been able to get the prices thru command prompt.

Thanks for your effort to help me out

Get Outlook for Android<https://aka.ms/AAb9ysg>

From: Murugan Muruganandam 
Sent: Tuesday, August 8, 2023 5:07:38 AM
To: David H ; Paras Desai 
Cc: gnucash-user@gnucash.org ; list+gnuc...@jdlh.com 

Subject: Re: [GNC] Finance quote not working

Paras

just a thought, if you had been using Yahoo earlier, the symbol was RELIANCE.NS 
, if you use nseindia you remove the .NS from symbol




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David H 
Sent: Monday, August 7, 2023 5:05 PM
To: Paras Desai 
Cc: gnucash-user@gnucash.org ; list+gnuc...@jdlh.com 

Subject: Re: [GNC] Finance quote not working

Paras,

How have you set up the security editor entry for RELIANCE in your gnucash
file. I have set it up in my file as follows and it returns the same price
details as gnucash-cli without error.

Cheers David H.

[image: image.png]

On Tue, 8 Aug 2023 at 00:02, Paras Desai  wrote:

> Hello Jin and all friends
>
> Thanks for your kind help and suggestion in running command prompt.
> GnuCash was installed in F drive and I forgot that, so the error message
> was coming,
>
> I ran the command prompt, and it threw the result for RELIANCE, FOR
> EXAMPLE, as below. So the Finance quote works, but integrated Finance
> quote in GnuCash does not. What could be the next step?
>
> Thank you.
>
> Paras
>
>
>   close => 2523.85
>symbol => RELIANCE
> prevclose => 2509.55
>  open => 2521
>   low => 2505
>  last => 2523.5
>   isodate => 2023-08-07
>method => nseindia
>  exchange => NSE
>  high => 2528.4
>   success => 1
>  currency => INR
>  date => 08/07/2023
> ___
> 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] Finance quote not working

[Paras Desai]

Thanks Jon,

My reply to your questions, Hope this will throw some light to my issue,


1. while i try to get quote, blank screen splashes (perhaps command 
prompt) second splash screen stays for a while and goes off. No error 
message is displayed.


2. As suggested by you, I located the Trace file and checked. It says : 
Price retrieval failed: Failed to parse result returned by Finance::Quote.


* 12:25:02  WARN  
[GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, 
currency quotes and other AlphaVantage based quotes won't work.
* 12:25:04 ERROR  [webkit_resource_load_error()] WebKit load 
of resource 
f:/gnucash/share/guile/site/2.2/gnucash/reports/stylesheets/balsheet-eg.css, 
type (NULL), failed due to URL cannot be shown
* 12:25:16  WARN  
[GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, 
currency quotes and other AlphaVantage based quotes won't work.
* 12:25:25 ERROR  [gnc_prices_dialog_get_quotes_clicked()] 
Price retrieval failed: Failed to parse result returned by Finance::Quote.

Error message:
(1): expected value
* 12:25:25  WARN  invalid cast from '(NULL)' to 'GtkWindow'
* 12:25:25 ERROR  gtk_message_dialog_new: assertion 'parent == NULL 
|| GTK_IS_WINDOW (parent)' failed
* 12:25:25 ERROR  gtk_dialog_run: assertion 'GTK_IS_DIALOG 
(dialog)' failed
* 12:25:25 ERROR  gtk_widget_destroy: assertion 'GTK_IS_WIDGET 
(widget)' failed
* 12:27:33  WARN  
[GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, 
currency quotes and other AlphaVantage based quotes won't work.
* 12:27:42 ERROR  [gnc_prices_dialog_get_quotes_clicked()] 
Price retrieval failed: Failed to parse result returned by Finance::Quote.

Error message:
hare/locale/en_IN/LC_MESSAGES/gnucash.mo
* 12:27:42  WARN  invalid cast from '(NULL)' to 'GtkWindow'
* 12:27:42 ERROR  gtk_message_dialog_new: assertion 'parent == NULL 
|| GTK_IS_WINDOW (parent)' failed
* 12:27:42 ERROR  gtk_dialog_run: assertion 'GTK_IS_DIALOG 
(dialog)' failed
* 12:27:42 ERROR  gtk_widget_destroy: assertion 'GTK_IS_WIDGET 
(widget)' failed


On 08-08-2023 02:01, John Ralls wrote:



On Aug 7, 2023, at 7:01 AM, Paras Desai  wrote:

Hello Jin and all friends

Thanks for your kind help and suggestion in running command prompt. GnuCash was 
installed in F drive and I forgot that, so the error message was coming,

I ran the command prompt, and it threw the result for RELIANCE, FOR EXAMPLE, as 
below. So the Finance quote works, but integrated Finance quote in GnuCash does 
not. What could be the next step?

Thank you.

Paras


  close => 2523.85
   symbol => RELIANCE
prevclose => 2509.55
 open => 2521
  low => 2505
 last => 2523.5
  isodate => 2023-08-07
   method => nseindia
 exchange => NSE
 high => 2528.4
  success => 1
 currency => INR
 date => 08/07/2023


Paras,

GnuCash and gnucash-cli use the same code for Finance::Quote integration, so 
it's not that. You reported that updating your book worked until 26 July, so 
something must have changed around that day. Do you remember changing anything, 
like updating GnuCash or Finance::Quote, that might offer a clue?

There may be an error in your tracefile 
(seehttps://wiki.gnucash.org/wiki/Tracefile) that explains why the prices 
aren't being updated.

When trying to retrieve quotes in the GUI are you getting the message box 
saying that it couldn't retrieve quotes for some stocks followed by a list of 
stocks that fail?

Regards,
John Ralls



___
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] finance Quote Not working

[R Losey]

A tip I've often used on Windows... the "tab" key does file expansion.

So, if I'm at C:\ in Windows, I can type "Prog" followed by the tab key,
and it will expand to "Program Files", with the quotes needed. (If it
brings up the wrong directory, such as "Program Data", continued presses of
the tab key will move to the next matching file). I find this MUCH easier
to navigate to an executable file on Windows, and it helps to avoid
spelling mistakes.


On Sun, Aug 6, 2023 at 4:42 PM Fross, Michael  wrote:

> As an FYI, on my windows 11 installation, the default location where
> GNUCash installs itself is:
>
> "C:\Program Files (x86)\gnucash"
>
> and the full path to the CLI executable is:
>
> "C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"
>
> For command line guys like me, these paths are just crazy
>
> Michael
>
> On Sun, Aug 6, 2023 at 4:23 PM David H  wrote:
>
> > On windows you'll need the double quotes around the .exe path because of
> > the space in "Program Files"
> >
> > i.e.   "C:\Program Files\GnuCash\gnucash-cli.exe" -V --quotes dump
> nseindia
> > RELIANCE
> >
> > OR
> >
> > you can also open a command prompt and change directory to C:\Program
> > Files\GnuCash end then just run the command without the full path name
> i.e.
> > gnucash-cli.exe -V --quotes dump nseindia RELIANCE
> >
> > Cheers David H.
>

-- 
_
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] Finance quote not working

[Murugan Muruganandam]

Paras

just a thought, if you had been using Yahoo earlier, the symbol was RELIANCE.NS 
, if you use nseindia you remove the .NS from symbol




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David H 
Sent: Monday, August 7, 2023 5:05 PM
To: Paras Desai 
Cc: gnucash-user@gnucash.org ; list+gnuc...@jdlh.com 

Subject: Re: [GNC] Finance quote not working

Paras,

How have you set up the security editor entry for RELIANCE in your gnucash
file. I have set it up in my file as follows and it returns the same price
details as gnucash-cli without error.

Cheers David H.

[image: image.png]

On Tue, 8 Aug 2023 at 00:02, Paras Desai  wrote:

> Hello Jin and all friends
>
> Thanks for your kind help and suggestion in running command prompt.
> GnuCash was installed in F drive and I forgot that, so the error message
> was coming,
>
> I ran the command prompt, and it threw the result for RELIANCE, FOR
> EXAMPLE, as below. So the Finance quote works, but integrated Finance
> quote in GnuCash does not. What could be the next step?
>
> Thank you.
>
> Paras
>
>
>   close => 2523.85
>symbol => RELIANCE
> prevclose => 2509.55
>  open => 2521
>   low => 2505
>  last => 2523.5
>   isodate => 2023-08-07
>method => nseindia
>  exchange => NSE
>  high => 2528.4
>   success => 1
>  currency => INR
>  date => 08/07/2023
> ___
> 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] Finance quote not working

[David H]

Paras,

How have you set up the security editor entry for RELIANCE in your gnucash
file. I have set it up in my file as follows and it returns the same price
details as gnucash-cli without error.

Cheers David H.

[image: image.png]

On Tue, 8 Aug 2023 at 00:02, Paras Desai  wrote:

> Hello Jin and all friends
>
> Thanks for your kind help and suggestion in running command prompt.
> GnuCash was installed in F drive and I forgot that, so the error message
> was coming,
>
> I ran the command prompt, and it threw the result for RELIANCE, FOR
> EXAMPLE, as below. So the Finance quote works, but integrated Finance
> quote in GnuCash does not. What could be the next step?
>
> Thank you.
>
> Paras
>
>
>   close => 2523.85
>symbol => RELIANCE
> prevclose => 2509.55
>  open => 2521
>   low => 2505
>  last => 2523.5
>   isodate => 2023-08-07
>method => nseindia
>  exchange => NSE
>  high => 2528.4
>   success => 1
>  currency => INR
>  date => 08/07/2023
> ___
> 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] Finance quote not working

[John Ralls]

> On Aug 7, 2023, at 7:01 AM, Paras Desai  wrote:
> 
> Hello Jin and all friends
> 
> Thanks for your kind help and suggestion in running command prompt. GnuCash 
> was installed in F drive and I forgot that, so the error message was coming,
> 
> I ran the command prompt, and it threw the result for RELIANCE, FOR EXAMPLE, 
> as below. So the Finance quote works, but integrated Finance quote in GnuCash 
> does not. What could be the next step?
> 
> Thank you.
> 
> Paras
> 
> 
>  close => 2523.85
>   symbol => RELIANCE
>prevclose => 2509.55
> open => 2521
>  low => 2505
> last => 2523.5
>  isodate => 2023-08-07
>   method => nseindia
> exchange => NSE
> high => 2528.4
>  success => 1
> currency => INR
> date => 08/07/2023
> 

Paras,

GnuCash and gnucash-cli use the same code for Finance::Quote integration, so 
it's not that. You reported that updating your book worked until 26 July, so 
something must have changed around that day. Do you remember changing anything, 
like updating GnuCash or Finance::Quote, that might offer a clue?

There may be an error in your tracefile (see 
https://wiki.gnucash.org/wiki/Tracefile) that explains why the prices aren't 
being updated.

When trying to retrieve quotes in the GUI are you getting the message box 
saying that it couldn't retrieve quotes for some stocks followed by a list of 
stocks that fail?

Regards,
John Ralls


___
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] Finance quote not working

[Paras Desai]

Hello Jin and all friends

Thanks for your kind help and suggestion in running command prompt. 
GnuCash was installed in F drive and I forgot that, so the error message 
was coming,


I ran the command prompt, and it threw the result for RELIANCE, FOR 
EXAMPLE, as below. So the Finance quote works, but integrated Finance 
quote in GnuCash does not. What could be the next step?


Thank you.

Paras


 close => 2523.85
  symbol => RELIANCE
   prevclose => 2509.55
    open => 2521
 low => 2505
    last => 2523.5
 isodate => 2023-08-07
  method => nseindia
    exchange => NSE
    high => 2528.4
 success => 1
    currency => INR
    date => 08/07/2023
___
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] finance Quote Not working

[Fred Bone]

On 06 August 2023 at 16:40, Fross, Michael said:

> As an FYI, on my windows 11 installation, the default location where
> GNUCash installs itself is:
> 
> "C:\Program Files (x86)\gnucash"
> 
> and the full path to the CLI executable is:
> 
> "C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"
> 
> For command line guys like me, these paths are just crazy

Microsoft doesn't want "command line guys" as customers ...


___
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] finance Quote Not working

[David H]

Ah of course it is Michael, thanks for the correction/  I'm sitting in
front of my iMac at present so that didn't even register with me at the
time :-)

Cheers David H.


On Mon, 7 Aug 2023 at 07:41, Fross, Michael  wrote:

> As an FYI, on my windows 11 installation, the default location where
> GNUCash installs itself is:
>
> "C:\Program Files (x86)\gnucash"
>
> and the full path to the CLI executable is:
>
> "C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"
>
> For command line guys like me, these paths are just crazy
>
> Michael
>
> On Sun, Aug 6, 2023 at 4:23 PM David H  wrote:
>
>> On windows you'll need the double quotes around the .exe path because of
>> the space in "Program Files"
>>
>> i.e.   "C:\Program Files\GnuCash\gnucash-cli.exe" -V --quotes dump
>> nseindia
>> RELIANCE
>>
>> OR
>>
>> you can also open a command prompt and change directory to C:\Program
>> Files\GnuCash end then just run the command without the full path name
>> i.e.
>> gnucash-cli.exe -V --quotes dump nseindia RELIANCE
>>
>> Cheers David H.
>>
>>
>> On Mon, 7 Aug 2023 at 05:36, Jim DeLaHunt  wrote:
>>
>> > Paras:
>> >
>> > On 2023-08-06 01:21, Paras Desai wrote:
>> > > ...I tried to run the command prompt, and I received the following
>> > > message.
>> > >
>> > > I run command from as an administrator,  the same message received as
>> > > below.
>> > >
>> > > gnucash-cli' is not recognized as an internal or external command,
>> > > operable program or batch file.
>> > >
>> > This message indicates a problem not with GnuCash or Perl, but of
>> > learning how to use the command prompt. The message says that Windows
>> > cannot find a file named "gnucash-cli" in the current directory. You fix
>> > the problem by using the full path and exact filename for the GnuCash
>> > command.
>> >
>> > Use File Explorer to find the directory where GnuCash is installed, and
>> > a file named something like "gnucash-cli.exe" in that directory. Note
>> > the full file path to that directory.
>> >
>> > Suppose that path is:
>> >
>> > C:\Program Files\GnuCash\gnucash-cli.exe
>> >
>> > (I don't use GnuCash on Windows, so I am not sure what the exact path
>> > and file name are.)
>> >
>> > Then in place of "gnucash-cli", use that full path and file name. For
>> > instance:
>> >
>> > C:\Program Files\GnuCash\gnucash-cli.exe -V --quotes dump nseindia
>> RELIANCE
>> >
>> > That should give you the output similar to my example. If you get the
>> > same error message as before, then there is probably something wrong in
>> > the path or the file name.
>> >
>> > Learning more about using the Windows command prompt is a separate task,
>> > and one that will probably help you for more things than just GnuCash.
>> > According to a brief web search, here are a couple of pages that explain
>> > the Windows Command Prompt:
>> >
>> > <
>> >
>> https://www.makeuseof.com/tag/a-beginners-guide-to-the-windows-command-line/
>> > >
>> > <
>> >
>> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/windows-commands
>> > >
>> >
>> > Teaching details about the Windows command prompt is out of the scope of
>> > this list. A Windows support group would be a better place to learn
>> > about it.
>> >
>> > Best regards,
>> >   —Jim DeLaHunt
>> >
>> > ___
>> > 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] finance Quote Not working

[Fross, Michael]

As an FYI, on my windows 11 installation, the default location where
GNUCash installs itself is:

"C:\Program Files (x86)\gnucash"

and the full path to the CLI executable is:

"C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"

For command line guys like me, these paths are just crazy

Michael

On Sun, Aug 6, 2023 at 4:23 PM David H  wrote:

> On windows you'll need the double quotes around the .exe path because of
> the space in "Program Files"
>
> i.e.   "C:\Program Files\GnuCash\gnucash-cli.exe" -V --quotes dump nseindia
> RELIANCE
>
> OR
>
> you can also open a command prompt and change directory to C:\Program
> Files\GnuCash end then just run the command without the full path name i.e.
> gnucash-cli.exe -V --quotes dump nseindia RELIANCE
>
> Cheers David H.
>
>
> On Mon, 7 Aug 2023 at 05:36, Jim DeLaHunt  wrote:
>
> > Paras:
> >
> > On 2023-08-06 01:21, Paras Desai wrote:
> > > ...I tried to run the command prompt, and I received the following
> > > message.
> > >
> > > I run command from as an administrator,  the same message received as
> > > below.
> > >
> > > gnucash-cli' is not recognized as an internal or external command,
> > > operable program or batch file.
> > >
> > This message indicates a problem not with GnuCash or Perl, but of
> > learning how to use the command prompt. The message says that Windows
> > cannot find a file named "gnucash-cli" in the current directory. You fix
> > the problem by using the full path and exact filename for the GnuCash
> > command.
> >
> > Use File Explorer to find the directory where GnuCash is installed, and
> > a file named something like "gnucash-cli.exe" in that directory. Note
> > the full file path to that directory.
> >
> > Suppose that path is:
> >
> > C:\Program Files\GnuCash\gnucash-cli.exe
> >
> > (I don't use GnuCash on Windows, so I am not sure what the exact path
> > and file name are.)
> >
> > Then in place of "gnucash-cli", use that full path and file name. For
> > instance:
> >
> > C:\Program Files\GnuCash\gnucash-cli.exe -V --quotes dump nseindia
> RELIANCE
> >
> > That should give you the output similar to my example. If you get the
> > same error message as before, then there is probably something wrong in
> > the path or the file name.
> >
> > Learning more about using the Windows command prompt is a separate task,
> > and one that will probably help you for more things than just GnuCash.
> > According to a brief web search, here are a couple of pages that explain
> > the Windows Command Prompt:
> >
> > <
> >
> https://www.makeuseof.com/tag/a-beginners-guide-to-the-windows-command-line/
> > >
> > <
> >
> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/windows-commands
> > >
> >
> > Teaching details about the Windows command prompt is out of the scope of
> > this list. A Windows support group would be a better place to learn
> > about it.
> >
> > Best regards,
> >   —Jim DeLaHunt
> >
> > ___
> > 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] finance Quote Not working

[David H]

On windows you'll need the double quotes around the .exe path because of
the space in "Program Files"

i.e.   "C:\Program Files\GnuCash\gnucash-cli.exe" -V --quotes dump nseindia
RELIANCE

OR

you can also open a command prompt and change directory to C:\Program
Files\GnuCash end then just run the command without the full path name i.e.
gnucash-cli.exe -V --quotes dump nseindia RELIANCE

Cheers David H.


On Mon, 7 Aug 2023 at 05:36, Jim DeLaHunt  wrote:

> Paras:
>
> On 2023-08-06 01:21, Paras Desai wrote:
> > ...I tried to run the command prompt, and I received the following
> > message.
> >
> > I run command from as an administrator,  the same message received as
> > below.
> >
> > gnucash-cli' is not recognized as an internal or external command,
> > operable program or batch file.
> >
> This message indicates a problem not with GnuCash or Perl, but of
> learning how to use the command prompt. The message says that Windows
> cannot find a file named "gnucash-cli" in the current directory. You fix
> the problem by using the full path and exact filename for the GnuCash
> command.
>
> Use File Explorer to find the directory where GnuCash is installed, and
> a file named something like "gnucash-cli.exe" in that directory. Note
> the full file path to that directory.
>
> Suppose that path is:
>
> C:\Program Files\GnuCash\gnucash-cli.exe
>
> (I don't use GnuCash on Windows, so I am not sure what the exact path
> and file name are.)
>
> Then in place of "gnucash-cli", use that full path and file name. For
> instance:
>
> C:\Program Files\GnuCash\gnucash-cli.exe -V --quotes dump nseindia RELIANCE
>
> That should give you the output similar to my example. If you get the
> same error message as before, then there is probably something wrong in
> the path or the file name.
>
> Learning more about using the Windows command prompt is a separate task,
> and one that will probably help you for more things than just GnuCash.
> According to a brief web search, here are a couple of pages that explain
> the Windows Command Prompt:
>
> <
> https://www.makeuseof.com/tag/a-beginners-guide-to-the-windows-command-line/
> >
> <
> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/windows-commands
> >
>
> Teaching details about the Windows command prompt is out of the scope of
> this list. A Windows support group would be a better place to learn
> about it.
>
> Best regards,
>   —Jim DeLaHunt
>
> ___
> 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] finance Quote Not working

[Jim DeLaHunt]

Paras:

On 2023-08-06 01:21, Paras Desai wrote:
...I tried to run the command prompt, and I received the following 
message.


I run command from as an administrator,  the same message received as 
below.


gnucash-cli' is not recognized as an internal or external command,
operable program or batch file.

This message indicates a problem not with GnuCash or Perl, but of 
learning how to use the command prompt. The message says that Windows 
cannot find a file named "gnucash-cli" in the current directory. You fix 
the problem by using the full path and exact filename for the GnuCash 
command.


Use File Explorer to find the directory where GnuCash is installed, and 
a file named something like "gnucash-cli.exe" in that directory. Note 
the full file path to that directory.


Suppose that path is:

C:\Program Files\GnuCash\gnucash-cli.exe

(I don't use GnuCash on Windows, so I am not sure what the exact path 
and file name are.)


Then in place of "gnucash-cli", use that full path and file name. For 
instance:


C:\Program Files\GnuCash\gnucash-cli.exe -V --quotes dump nseindia RELIANCE

That should give you the output similar to my example. If you get the 
same error message as before, then there is probably something wrong in 
the path or the file name.


Learning more about using the Windows command prompt is a separate task, 
and one that will probably help you for more things than just GnuCash. 
According to a brief web search, here are a couple of pages that explain 
the Windows Command Prompt:





Teaching details about the Windows command prompt is out of the scope of 
this list. A Windows support group would be a better place to learn 
about it.


Best regards,
 —Jim DeLaHunt

___
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] finance Quote Not working

[Paras Desai]

Thank you Jon

I do try .

Very much appreciate your kind help
Paras

Get Outlook for Android<https://aka.ms/AAb9ysg>

From: john 
Sent: Sunday, August 6, 2023 9:09:05 PM
To: Paras Desai 
Cc: Jim DeLaHunt ; gnucash-user@gnucash.org 

Subject: Re: [GNC] finance Quote Not working

Paras,

If you're on Windows or Mac you need to give the full path.
Windows:
 " C:\Program Files (x86)\gnucash\bin\gnucash-cli"
***Including the quotes!***
Mac:
  /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

Regards,
John Ralls


> On Aug 6, 2023, at 01:21, Paras Desai  wrote:
>
> Hello Jim,
>
> Thanks for your suggestion and efforts to test finance quote  for me !
>
> I tried to run the command prompt, and I received the following message.
>
> I run command from as an administrator,  the same message received as below.
>
> gnucash-cli' is not recognized as an internal or external command,
> operable program or batch file.
>
>
> I also tried to use Perl Command Line but without success, the same message 
> as above was diplayed.
>
>
> I am not sure, If I am making any mistake, in running command line !!
>
> With regards
>
> Paras
> ___
> 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] finance Quote Not working

[john]

Paras,

If you're on Windows or Mac you need to give the full path.
Windows:
 " C:\Program Files (x86)\gnucash\bin\gnucash-cli"
***Including the quotes!***
Mac:
  /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

Regards,
John Ralls


> On Aug 6, 2023, at 01:21, Paras Desai  wrote:
> 
> Hello Jim,
> 
> Thanks for your suggestion and efforts to test finance quote  for me !
> 
> I tried to run the command prompt, and I received the following message.
> 
> I run command from as an administrator,  the same message received as below.
> 
> gnucash-cli' is not recognized as an internal or external command,
> operable program or batch file.
> 
> 
> I also tried to use Perl Command Line but without success, the same message 
> as above was diplayed.
> 
> 
> I am not sure, If I am making any mistake, in running command line !!
> 
> With regards
> 
> Paras
> ___
> 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] finance Quote Not working

[Paras Desai]

Hello Jim,

Thanks for your suggestion and efforts to test finance quote  for me !

I tried to run the command prompt, and I received the following message.

I run command from as an administrator,  the same message received as below.

gnucash-cli' is not recognized as an internal or external command,
operable program or batch file.


I also tried to use Perl Command Line but without success, the same 
message as above was diplayed.



I am not sure, If I am making any mistake, in running command line !!

With regards

Paras
___
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] finance quote not working

[Bruce Schuck]

On 2023-08-04 at 20:16 EDT, Jim DeLaHunt wrote:


Paras:



On 2023-08-04 06:23, Paras Desai wrote:


So far, Mutual fund is concerned, following is an example of the 
fund


1. Axis Special Situation Fund , symbol for fetching price is 
INF846K01Y05


Excellent. That is helpful information. Next, try testing quote 
retrieval from the command line. If this succeeds, then your problem
is probably inside GnuCash. If this fails, then the problem is 
probably with the Finance::Quote software bundled with GnuCash, or

with the data source, or with the configRelauration.
The ISIN "INF846K01Y05" does not exist in the data used by the nseindia 
method.


The Finance::Quote module NSEIndia.pm module works by extracting data 
from a zipped CSV file retrieved from nseindia.com. Friday's file would 
have been 
https://archives.nseindia.com/content/historical/EQUITIES/2023/AUG/cm04AUG2023bhav.csv.zip


Reliance and INFY do exist, and F::Q's own example retrieval script will 
show (The example scripts are in the tarball CPAN downloads when 
installing the F::Q module):


bschuck@valhalla:~/tmp/finance-quote$ ./Examples/stockdump.pl nseindia 
INFY RELIANCE

$VAR1 = {
  'RELIANCElow' => '2471.6',
  'RELIANCEhigh' => '2516',
  'INFYexchange' => 'NSE',
  'RELIANCElast' => '2508',
  'INFYdate' => '08/04/2023',
  'RELIANCEmethod' => 'nseindia',
  'INFYlast' => '1377.9',
  'RELIANCEsuccess' => 1,
  'INFYmethod' => 'nseindia',
  'RELIANCEcurrency' => 'INR',
  'RELIANCEclose' => '2509.55',
  'INFYcurrency' => 'INR',
  'RELIANCEexchange' => 'NSE',
  'RELIANCEdate' => '08/04/2023',
  'INFYsymbol' => 'INFY',
  'RELIANCEisodate' => '2023-08-04',
  'RELIANCEprevclose' => '2475.9',
  'RELIANCEsymbol' => 'RELIANCE',
  'RELIANCEopen' => '2498.8',
  'INFYprevclose' => '1364.3',
  'INFYlow' => '1362',
  'INFYclose' => '1378.35',
  'INFYisodate' => '2023-08-04',
  'INFYhigh' => '1385.9',
  'INFYsuccess' => 1,
  'INFYopen' => '1368.9'
};


Why the data for INF846K01Y05 is not available from NSE India (did it 
perhaps stop trading?) is beyond the scope of both GnuCash and 
Finance::Quote. Sorry.


Bruce S.
___
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] finance quote not working

[Jim DeLaHunt]

Paras:

On 2023-08-04 06:23, Paras Desai wrote:

Hello Jim,

Thanks for replying to my query regarding "Finance Quote Not Working"

My response to  your questions are as below

1. I am looking to update prices of Stocks and mutual Fund both _from
   India__only_. After I created stock account and mutual fund account,
   the prices of all mutual funds and stocks updated successfully
   twice. ( last update was on 26-7-2023) , there after update is not
   working . For example, I have tried to update following stock
    1. Reliance Industry : Ticker is "RELIANCE", listed at NSEIndia
    2. Infosys : Ticker is INFY listed at NSEindia

So far, Mutual fund is concerned, following is an example of the fund

            1. Axis Special Situation Fund , symbol for fetching price
   is INF846K01Y05


2. my source for fetching prices are as below ( from the options 
offered by GNUcash)


Stock : Type of quote source --> Unlnown --> nseindia-->time zone (local)

Mutual Fund: Type of quote Source --> Single--> India Mutual --> time 
zone (local)


both the sources were working fine, prices were updating successfully 
till 26-7-2023, but thereafter , they are not working.



Excellent. That is helpful information. Next, try testing quote 
retrieval from the command line. If this succeeds, then your problem is 
probably inside GnuCash. If this fails, then the problem is probably 
with the Finance::Quote software bundled with GnuCash, or with the data 
source, or with the configuration.


Instructions for testing quote retrieval from the command line are at: 



The command looks something like:

gnucash-cli -V --quotes dump nseindia RELIANCE

On my older version (4.14) of GnuCash, with an older version of the 
command, I get:


% /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump nseindia RELIANCE

Finance::Quote fields Gnucash uses:

    symbol: RELIANCE <=== required

  date: 08/04/2023   <=== recommended

  currency: INR  <=== required

  last: 2508 <=\

   nav:  <=== one of these

 price:  <=/

  timezone:  <=== optional

I hope this helps you get another step further forward.




3. I am using following version ( as it appears in help--> about menu 
of GNU Cash)


Version : 5.3
Finance Quote : 1.57
I am using Window 10 home

___
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] finance quote not working

[Paras Desai]

Hello Jim,

Thanks for replying to my query regarding "Finance Quote Not Working"

My response to  your questions are as below

1. I am looking to update prices of Stocks and mutual Fund both _from
   India__only_. After I created stock account and mutual fund account,
   the prices of all mutual funds and stocks updated successfully
   twice. ( last update was on 26-7-2023) , there after update is not
   working . For example, I have tried to update following stock
1. Reliance Industry : Ticker is "RELIANCE", listed at NSEIndia
2. Infosys : Ticker is INFY listed at NSEindia

So far, Mutual fund is concerned, following is an example of the fund

        1. Axis Special Situation Fund , symbol for fetching price
   is INF846K01Y05


2. my source for fetching prices are as below ( from the options offered 
by GNUcash)


Stock : Type of quote source --> Unlnown --> nseindia-->time zone (local)

Mutual Fund: Type of quote Source --> Single--> India Mutual --> time 
zone (local)


both the sources were working fine, prices were updating successfully 
till 26-7-2023, but thereafter , they are not working.



3. I am using following version ( as it appears in help--> about menu of 
GNU Cash)


Version : 5.3

Finance Quote : 1.57

I am using Window 10 home

I tried to install GNU cash on another laptop running on Windows 11 
student, using the same account  file which I created on my computer ( 
xml), as well as creating nwe account and configuring the same way, but 
still without success so far the finance quotes are concerned.


Before starting posting my regular accounts and suing the GNU cash at 
production level for my accounts, I studied it detail, particularly the 
finance quote and investment accounting, as one of the purpose of using 
GNUcash over other software was to track my investment.



Hope above information is useful to you for anylsing the issue. Thanks 
again a lot for your kind support and eagerness to hep me. Very much 
appreciate,



With my best regards


Paras






___
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] Finance Quote Not working on MacBook Air M1 chip

[John Ralls]

Super. I guess you needed to install JSON::Parse and maybe other dependencies 
in the Rosetta instance. No doubt it's lost now but I wonder if during the 
Rosetta install cpan saw that it was already installed and couldn't tell that 
it was for the wrong architecture.

Regards,
John Ralls


> On Jul 3, 2021, at 11:35 PM, Deepti Randad  wrote:
> 
> Hey John - it worked after some trouble shooting - now Finance:Quote is 
> “recognised” by the GnuCash GUI - Again - Thanks for your help !!
> 
> Regards,
> Kamlesh
> 
>> On 04-Jul-2021, at 11:52 AM, Deepti Randad  wrote:
>> 
>> I was able to create a “terminal instance” to run under Rosetta2 and also 
>> then was able to install Finance::Quote using gnc-fq-update.
>> 
>> However, when I tried to run the command "echo '(yahoo_json "CSCO")' | 
>> ./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had 
>> chance to troubleshoot these yet, maybe next weekend)
>> 
>> Thanks John for your guidance so far.
>> 
>> 
>> Can't load 
>> '/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' 
>> for module JSON::Parse: 
>> dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle,
>>  1): no suitable image found.  Did find:
>>  
>> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
>> mach-o, but wrong architecture
>>  
>> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
>> mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line 
>> 96.
>>  at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23.
>> Compilation failed in require at 
>> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
>> BEGIN failed--compilation aborted at 
>> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
>> Compilation failed in require at (eval 301) line 1.
>> BEGIN failed--compilation aborted at (eval 301) line 1.
>>  at ./gnc-fq-helper line 325.
>> Can't locate object method "methods" via package 
>> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line 
>> 120.
>> 
>> 
>>> On 01-Jul-2021, at 10:09 PM, John Ralls  wrote:
>>> 
>>> OK. I suspect that it's because GnuCash is running under Rosetta2 and that 
>>> forces the Intel perl. Try following the instructions in 
>>> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/
>>>  to create a Terminal instance that runs under Rosetta2 and use that to run 
>>> gnc-fq-update.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>> 
 On Jun 30, 2021, at 5:31 AM, Deepti Randad  wrote:
 
 Hallo John - Many Thanks for your response.
 
 I ran the GUI from the terminal command prompt as you have suggested - 
 however, the problem remains the same - the application does not “get” / 
 “find” Finance::Quote.
 
 Regards,
 Kamlesh
 
 Regards,
 Kamlesh
 
> On 29-Jun-2021, at 8:43 AM, John Ralls  wrote:
> 
> /Applications/Gnucash.app/Contents/MacOS/Gnucash 
 
>>> 
>> 
> 

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

Re: [GNC] Finance Quote Not working on MacBook Air M1 chip

[Deepti Randad via gnucash-user]

Hey John - it worked after some trouble shooting - now Finance:Quote is 
“recognised” by the GnuCash GUI - Again - Thanks for your help !!

Regards,
Kamlesh

> On 04-Jul-2021, at 11:52 AM, Deepti Randad  wrote:
> 
> I was able to create a “terminal instance” to run under Rosetta2 and also 
> then was able to install Finance::Quote using gnc-fq-update.
> 
> However, when I tried to run the command "echo '(yahoo_json "CSCO")' | 
> ./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had 
> chance to troubleshoot these yet, maybe next weekend)
> 
> Thanks John for your guidance so far.
> 
> 
> Can't load 
> '/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' 
> for module JSON::Parse: 
> dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle,
>  1): no suitable image found.  Did find:
>   
> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
> mach-o, but wrong architecture
>   
> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
> mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line 
> 96.
>  at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23.
> Compilation failed in require at 
> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> BEGIN failed--compilation aborted at 
> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> Compilation failed in require at (eval 301) line 1.
> BEGIN failed--compilation aborted at (eval 301) line 1.
>  at ./gnc-fq-helper line 325.
> Can't locate object method "methods" via package 
> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line 
> 120.
> 
> 
>> On 01-Jul-2021, at 10:09 PM, John Ralls > > wrote:
>> 
>> OK. I suspect that it's because GnuCash is running under Rosetta2 and that 
>> forces the Intel perl. Try following the instructions in 
>> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/
>>  
>> 
>>  to create a Terminal instance that runs under Rosetta2 and use that to run 
>> gnc-fq-update.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>>> On Jun 30, 2021, at 5:31 AM, Deepti Randad >> > wrote:
>>> 
>>> Hallo John - Many Thanks for your response.
>>> 
>>> I ran the GUI from the terminal command prompt as you have suggested - 
>>> however, the problem remains the same - the application does not “get” / 
>>> “find” Finance::Quote.
>>> 
>>> Regards,
>>> Kamlesh
>>> 
>>> Regards,
>>> Kamlesh
>>> 
 On 29-Jun-2021, at 8:43 AM, John Ralls >>> > wrote:
 
 /Applications/Gnucash.app/Contents/MacOS/Gnucash 
>>> 
>> 
> 

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

Re: [GNC] Finance Quote Not working on MacBook Air M1 chip

[Deepti Randad via gnucash-user]

I was able to create a “terminal instance” to run under Rosetta2 and also then 
was able to install Finance::Quote using gnc-fq-update.

However, when I tried to run the command "echo '(yahoo_json "CSCO")' | 
./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had chance 
to troubleshoot these yet, maybe next weekend)

Thanks John for your guidance so far.


Can't load 
'/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' 
for module JSON::Parse: 
dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle,
 1): no suitable image found.  Did find:

/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
mach-o, but wrong architecture

/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: 
mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line 96.
 at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23.
Compilation failed in require at 
/Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
BEGIN failed--compilation aborted at 
/Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
Compilation failed in require at (eval 301) line 1.
BEGIN failed--compilation aborted at (eval 301) line 1.
 at ./gnc-fq-helper line 325.
Can't locate object method "methods" via package 
"Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line 120.


> On 01-Jul-2021, at 10:09 PM, John Ralls  wrote:
> 
> OK. I suspect that it's because GnuCash is running under Rosetta2 and that 
> forces the Intel perl. Try following the instructions in 
> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/
>  to create a Terminal instance that runs under Rosetta2 and use that to run 
> gnc-fq-update.
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Jun 30, 2021, at 5:31 AM, Deepti Randad  wrote:
>> 
>> Hallo John - Many Thanks for your response.
>> 
>> I ran the GUI from the terminal command prompt as you have suggested - 
>> however, the problem remains the same - the application does not “get” / 
>> “find” Finance::Quote.
>> 
>> Regards,
>> Kamlesh
>> 
>> Regards,
>> Kamlesh
>> 
>>> On 29-Jun-2021, at 8:43 AM, John Ralls  wrote:
>>> 
>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash 
>> 
> 

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

Re: [GNC] Finance Quote Not working on MacBook Air M1 chip

[Deepti Randad via gnucash-user]

Hallo John - Many Thanks for your response.

I ran the GUI from the terminal command prompt as you have suggested - however, 
the problem remains the same - the application does not “get” / “find” 
Finance::Quote.

Regards,
Kamlesh

Regards,
Kamlesh

> On 29-Jun-2021, at 8:43 AM, John Ralls  wrote:
> 
>  /Applications/Gnucash.app/Contents/MacOS/Gnucash 

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

Re: [GNC] Finance Quote Not working on MacBook Air M1 chip

[John Ralls]

OK. I suspect that it's because GnuCash is running under Rosetta2 and that 
forces the Intel perl. Try following the instructions in 
https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/
 to create a Terminal instance that runs under Rosetta2 and use that to run 
gnc-fq-update.

Regards,
John Ralls



> On Jun 30, 2021, at 5:31 AM, Deepti Randad  wrote:
> 
> Hallo John - Many Thanks for your response.
> 
> I ran the GUI from the terminal command prompt as you have suggested - 
> however, the problem remains the same - the application does not “get” / 
> “find” Finance::Quote.
> 
> Regards,
> Kamlesh
> 
> Regards,
> Kamlesh
> 
>> On 29-Jun-2021, at 8:43 AM, John Ralls  wrote:
>> 
>>  /Applications/Gnucash.app/Contents/MacOS/Gnucash 
> 

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

Re: [GNC] Finance Quote Not working on MacBook Air M1 chip

[John Ralls]

> On Jun 27, 2021, at 4:05 AM, Deepti Randad via gnucash-user 
>  wrote:
> 
> Hallo Folks - 
> 
> I recently installed GnuCash on MacBook Air with the Apple M1 chip - the 
> GnuCash GUI itself seems to be working great. Then I tried installing 
> finance::quote to get stock quotes automatically, however, this has not been 
> working even after a lot of trouble shooting I did. Please find below the 
> steps I have taken. Any help / direction will be appreciated. Thanks.
> 
> Regards,
> Kamlesh
> 
> Finance Quote on MacOS with MacBook Air M1 chip 
> 
> In the GnuCash GUI, I get the following error message in the “Security 
> Editor” screen: 
>> Warning: Finance::Quote not installed properly < 
> and the rest of the fields below this are disabled. 
> I followed the installation instructions on 
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS
>  
> 
> 
> The about page of the GUI shows:
> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: -
> 
> I did the following for installation:
> 
> First, run the gnc-fq-update - this I had to run a couple of times, but it 
> succeeded. 
> 
> Now if I run it, I get the following:
> 
> Date::Manip is up to date (6.85).
> Finance::Quote is up to date (1.49)
> 
> Perldoc gives the following output:
> 
> perldoc -lm Finance::Quote
> /Library/Perl/5.30/Finance/Quote.pm
> 
> Then, I run the following command, gnc-fq-helper
> 
> echo '(yahoo_json "CSCO")' | ./gnc-fq-helper
> 
> This returns the data fetched:
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-06-19 12:00:00") (last . 
> #e52.07) (currency . "USD")))
> 
> Another command I tried:
> 
> ./gnc-fq-dump currency USD EUR
> 1 USD = 0.8428 EUR
> 
> Therefore I am guessing Finance::Quote is working from command line.
> 
> ./gnc-fq-check 
> 
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" 
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "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" "iexcloud" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" 
> "morningstarch" "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_json" 
> "yahoo_yql" "za" "za_unittrusts"

Try running 
  /Applications/Gnucash.app/Contents/MacOS/Gnucash 
from Terminal. Does that get it working?

Regards,
John Ralls

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

[GNC] Finance Quote Not working on MacBook Air M1 chip

[Deepti Randad via gnucash-user]

Hallo Folks - 

I recently installed GnuCash on MacBook Air with the Apple M1 chip - the 
GnuCash GUI itself seems to be working great. Then I tried installing 
finance::quote to get stock quotes automatically, however, this has not been 
working even after a lot of trouble shooting I did. Please find below the steps 
I have taken. Any help / direction will be appreciated. Thanks.

Regards,
Kamlesh

Finance Quote on MacOS with MacBook Air M1 chip 

In the GnuCash GUI, I get the following error message in the “Security Editor” 
screen: 
> Warning: Finance::Quote not installed properly < 
and the rest of the fields below this are disabled. 
I followed the installation instructions on 
https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS 


The about page of the GUI shows:
Version: 4.5
Build ID: 4.5+(2021-03-27)
Finance::Quote: -

I did the following for installation:

First, run the gnc-fq-update - this I had to run a couple of times, but it 
succeeded. 

Now if I run it, I get the following:

Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.49)

Perldoc gives the following output:

perldoc -lm Finance::Quote
/Library/Perl/5.30/Finance/Quote.pm

Then, I run the following command, gnc-fq-helper

echo '(yahoo_json "CSCO")' | ./gnc-fq-helper

This returns the data fetched:
(("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-06-19 12:00:00") (last . 
#e52.07) (currency . "USD")))

Another command I tried:

./gnc-fq-dump currency USD EUR
1 USD = 0.8428 EUR

Therefore I am guessing Finance::Quote is working from command line.

./gnc-fq-check 

("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "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" "iexcloud" "indiamutual" "known_currencies" 
"lerevenu" "maninv" "morningstar" "morningstarau" "morningstarch" 
"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_json" "yahoo_yql" "za" "za_unittrusts")
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Finance::Quote not Working on Macbook

[Geoff]

Hi BP

Background:
To retrieve price data, GnuCash depends on a Perl module called 
Finance-Quote.
Finance-Quote depends on other Perl modules, including one called 
Date-Manip.

Date-Manip in turn also depends on other Perl modules.
These modules may depend on further Perl modules.
Etc etc.
Most of these dependencies are *not* included in the base Perl installation.

Your problem:
Based on the scant information you have provided, it appears that the 
Date-Manip module can't be installed because of one or more missing 
dependencies.


Your task:
Carefully track down all the missing dependencies and install them.


I have no experience with MacOS, but Google is your friend:
https://bioinformaticsonline.com/blog/view/29479/how-to-install-perl-modules-on-mac-os-x-in-easy-steps

Good luck, and report back with more details if you get stuck.

Geoff
=



On 16/02/2021 3:55 pm, bdp3 wrote:

Thanks, John, for the suggestion.  It ran--produced a lot of activity in the 
Terminal window.  The problems started immediately.

This message was first...
 Unsatisfied dependencies detected during 
   SBECK/Date-Manip-6.83.tar.gz   

Then there was a whole lot of this message throughout...
  Make had some problems, won't install
  Delayed until after prerequisites

Also had loads and loads of ...
Warning: prerequisite < blah blah blah > with 'make => NO'. 
Continuing, but chances to succeed are limited.

And if finally ended with these messages...
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible

Is there something else I can try, or another reference I can read?  I don't 
understand any of it and I'm thinking I did it wrong.

Thanks for all!  (Even if I don't know what that is.)
BP




On 2/15/21, 8:01 PM, "John Ralls"  wrote:



 > On Feb 15, 2021, at 5:47 PM, bdp3  wrote:
 >
 > Is anyone else having trouble making F:Q work on a Mac?  If not, maybe 
you can help me—I’m new here and I just don’t ‘get it’!
 >
 > I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave).
 >
 > I downloaded version 1.49 from SourceForge.  There’s an ‘Applications’ 
folder at the hard-drive level, and an ‘Applications’ folder at the User folder 
level; I’ve tried unzipping FQ into both directories and still have no success.  I 
read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; I’m 
getting lost in the weeds.  The ‘Security Edit’ page (for any given security which 
I have set up) shows the Online Checkbox greyed-out with the same message familiar 
to us: “Warning: Finance::Quote not installed properly”.   I also tried running 
“gnc-fq-check“ and “gnc-fq-update” – No Joy!
 >
 > What am I missing?
 >
 >
 >
 > Thanks much for anything you can tell me!!  (Pictures help – preferably 
in crayons or watercolors.)

 The only thing you tried that's right is gnc-fq-update. It needs sudo as 
shown in 
https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt

 Regards,
 John Ralls




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

Re: [GNC] Finance::Quote not Working on Macbook

[bdp3]

Thanks, John, for the suggestion.  It ran--produced a lot of activity in the 
Terminal window.  The problems started immediately.

This message was first...
 Unsatisfied dependencies detected during 
   SBECK/Date-Manip-6.83.tar.gz   

Then there was a whole lot of this message throughout...
  Make had some problems, won't install
  Delayed until after prerequisites

Also had loads and loads of ...
Warning: prerequisite < blah blah blah > with 'make => NO'. 
Continuing, but chances to succeed are limited.

And if finally ended with these messages...
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible

Is there something else I can try, or another reference I can read?  I don't 
understand any of it and I'm thinking I did it wrong.

Thanks for all!  (Even if I don't know what that is.)
BP




On 2/15/21, 8:01 PM, "John Ralls"  wrote:



> On Feb 15, 2021, at 5:47 PM, bdp3  wrote:
>
> Is anyone else having trouble making F:Q work on a Mac?  If not, maybe 
you can help me—I’m new here and I just don’t ‘get it’!
>
> I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave).
>
> I downloaded version 1.49 from SourceForge.  There’s an ‘Applications’ 
folder at the hard-drive level, and an ‘Applications’ folder at the User folder 
level; I’ve tried unzipping FQ into both directories and still have no success. 
 I read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; 
I’m getting lost in the weeds.  The ‘Security Edit’ page (for any given 
security which I have set up) shows the Online Checkbox greyed-out with the 
same message familiar to us: “Warning: Finance::Quote not installed properly”.  
 I also tried running “gnc-fq-check“ and “gnc-fq-update” – No Joy!
>
> What am I missing?
>
>
>
> Thanks much for anything you can tell me!!  (Pictures help – preferably 
in crayons or watercolors.)

The only thing you tried that's right is gnc-fq-update. It needs sudo as 
shown in 
https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt

Regards,
John Ralls




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

Re: [GNC] Finance::Quote not Working on Macbook

[John Ralls]

> On Feb 15, 2021, at 5:47 PM, bdp3  wrote:
> 
> Is anyone else having trouble making F:Q work on a Mac?  If not, maybe you 
> can help me—I’m new here and I just don’t ‘get it’!  
> 
> I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave).  
> 
> I downloaded version 1.49 from SourceForge.  There’s an ‘Applications’ folder 
> at the hard-drive level, and an ‘Applications’ folder at the User folder 
> level; I’ve tried unzipping FQ into both directories and still have no 
> success.  I read the GnuCash wiki on Online Quotes; I have perl installed; I 
> used CPAN; I’m getting lost in the weeds.  The ‘Security Edit’ page (for any 
> given security which I have set up) shows the Online Checkbox greyed-out with 
> the same message familiar to us: “Warning: Finance::Quote not installed 
> properly”.   I also tried running “gnc-fq-check“ and “gnc-fq-update” – No 
> Joy! 
> 
> What am I missing?
> 
> 
> 
> Thanks much for anything you can tell me!!  (Pictures help – preferably in 
> crayons or watercolors.)

The only thing you tried that's right is gnc-fq-update. It needs sudo as shown 
in 
https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt

Regards,
John Ralls

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

[GNC] Finance::Quote not Working on Macbook

[bdp3]

Is anyone else having trouble making F:Q work on a Mac?  If not, maybe you can 
help me—I’m new here and I just don’t ‘get it’!  

I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave).  

I downloaded version 1.49 from SourceForge.  There’s an ‘Applications’ folder 
at the hard-drive level, and an ‘Applications’ folder at the User folder level; 
I’ve tried unzipping FQ into both directories and still have no success.  I 
read the GnuCash wiki on Online Quotes; I have perl installed; I used CPAN; I’m 
getting lost in the weeds.  The ‘Security Edit’ page (for any given security 
which I have set up) shows the Online Checkbox greyed-out with the same message 
familiar to us: “Warning: Finance::Quote not installed properly”.   I also 
tried running “gnc-fq-check“ and “gnc-fq-update” – No Joy! 

What am I missing?

 

Thanks much for anything you can tell me!!  (Pictures help – preferably in 
crayons or watercolors.)

BP  

 

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

Re: [GNC] Finance : Quote not working

[John Ralls]

> On Aug 6, 2018, at 1:30 AM, Kevin Thorne  wrote:
> 
> Hi,
> 
> When running Gnucash I can’t get any stock quote updates for Australia ASX or 
> USA Nasdaq or NSE or any currency updates. 
> I have run the install price retrieval install and from what I can see all ok 
> but cant get any info
> 
> Please help
> 
> Running Perl 1.47
> GnuCash 3.2
> Windows 10
> Have Alphavantage API key
> 
> Have entered the API key in Gnucash 3.2 and added it to the environment file
> 
> Tried running gnc-fq-dump alphavantage  wow.ax and get the following
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v alphavantage wow.ax
> Finance::Quote fields Gnucash uses:
>symbol: wow.ax (deduced) <=== required
>  date: ** missing **<=== recommended
>  currency: ** missing **<=== required
>  last:  <=\
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> ** This stock quote cannot be used by GnuCash!
> 
> 
> All fields returned by Finance::Quote for stock wow.ax
> 
> stock   field  value
> -   -  -
> wow.ax   errormsg: Expected ALPHAVANTAGE_API_KEY to be set; get an API 
> key at https://www.alphavantage.co
> wow.ax   last: **missing**
> wow.axnav: **missing**
> wow.ax  price: **missing**
> wow.axsuccess: 0

The command-line tools, gnc-fq-dump and gnc-fq-helper, cannot read the GnuCash 
environment file nor query the GnuCash preferences, so to use them you need to  
set the environment variable ALPHAVANTAGE_API_KEY with your key.

As for GnuCash’s difficulties, Alphavantage has increased the request time from 
1 per second to 1 per 20 seconds. There are commits addressing this in 
Finance::Quote’s Github repository, so we’re just waiting for Erik Colson to do 
a release so that everyone can use them.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Finance : Quote not working

[Kevin Thorne]

Hi,

When running Gnucash I can’t get any stock quote updates for Australia ASX or 
USA Nasdaq or NSE or any currency updates. 
I have run the install price retrieval install and from what I can see all ok 
but cant get any info

Please help

Running Perl 1.47
GnuCash 3.2
Windows 10
Have Alphavantage API key

Have entered the API key in Gnucash 3.2 and added it to the environment file

Tried running gnc-fq-dump alphavantage  wow.ax and get the following

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v alphavantage wow.ax
Finance::Quote fields Gnucash uses:
symbol: wow.ax (deduced) <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock wow.ax

stock   field  value
-   -  -
wow.ax   errormsg: Expected ALPHAVANTAGE_API_KEY to be set; get an API key 
at https://www.alphavantage.co
wow.ax   last: **missing**
wow.axnav: **missing**
wow.ax  price: **missing**
wow.axsuccess: 0


Sent from Mail for Windows 10

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