Price retrieval

[Alan Schold]

I usually update prices on the weekend, but this past weekend suddenly 
the process would not happen. I attempted ro reinstall the perl from the 
GnuCash section of Windows 10 and got an error message. Attached is the 
screenshot of the installation process. Any ideas?


___
gnucash-user mailing list
gnucash-user@gnucash.org
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] Price retrieval

[randix]

I'm using GnuCash 4.2 on Windows 10 Pro.

On a separate laptop, I installed GnuCash, and copied over from my regular
laptop where I normally use GnuCash, the files that I thought contained the
customization needed for the new install.

Everything works great, except for one component, price retrieval.  The
"remove", "edit" and "get quotes" buttons are greyed out.  I did enter the
API key, and strawberry perl is installed.

Any thoughts?  Screenshot below.

<http://gnucash.1415818.n4.nabble.com/file/t374961/Screenshot_2020-11-09_115107.png>
 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Price retrieval

[Maf. King]

Hi,

look at the list archives for the last few days.  Yahoo! removed their online 
quotes service.

No idea about your error message though.  perhaps a bad download?

Maf.


On Monday, 6 November 2017 16:54:33 GMT Alan Schold wrote:
> I usually update prices on the weekend, but this past weekend suddenly
> the process would not happen. I attempted ro reinstall the perl from the
> GnuCash section of Windows 10 and got an error message. Attached is the
> screenshot of the installation process. Any ideas?


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

Price Retrieval Failure

[David T. via gnucash-user]

Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
works at the command line:

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts”)

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage AAPL
Finance::Quote fields Gnucash uses:
symbol: AAPL <=== required
  date: 01/23/2018   <=== recommended
  currency: USD  <=== required
  last: 178.6400 <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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] Online price retrieval

[J Medina]

Gentlemen/Ladies,

I want to install Finance::Quote on Windows10

Could you please give me a bit more detailed explanation on how to do this >>>  
Run Start → GnuCash → Install Online Price Retrieval.

I understand I need to do this from the command prompt ...I just need a more 
substantial explanation even if it is a broad one. Thank you a lot.
___
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] Price retrieval

[Geoff]

Hi Randix

That screenshot is too small for me to read, however you can start 
troubleshooting using the GnuCash price support utilities in a command 
window.


Here is an example - Windows 10 / GnuCash 4.1

C:\Program Files (x86)\gnucash\bin>perl 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")


C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump yahoo_json IBM
Finance::Quote fields Gnucash uses:
symbol: IBM  <=== required
  date: 11/10/2020   <=== recommended
  currency: USD  <=== required
  last: 115.53   <=\
   nav:  <=== one of these
 price:      <=/
  timezone:  <=== optional

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump australia BHP
Finance::Quote fields Gnucash uses:
symbol: BHP  <=== required
  date: 11/09/2020   <=== recommended
  currency: AUD  <=== required
  last: 36.195   <=\
   nav:  <=== one of these
 price: 36.195   <=/
  timezone:  <=== optional

C:\Program Files (x86)\gnucash\bin>

Geoff
=

On 10/11/2020 6:56 am, randix wrote:

I'm using GnuCash 4.2 on Windows 10 Pro.

On a separate laptop, I installed GnuCash, and copied over from my regular
laptop where I normally use GnuCash, the files that I thought contained the
customization needed for the new install.

Everything works great, except for one component, price retrieval.  The
"remove", "edit" and "get quotes" buttons are greyed out.  I did enter the
API key, and strawberry perl is installed.

Any thoughts?  Screenshot below.

<http://gnucash.1415818.n4.nabble.com/file/t374961/Screenshot_2020-11-09_115107.png>



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Price retrieval

[randix]

Ok, so after my last post, I figured I better read the user manual as it's
been a long time since I've installed GnuCash.  Appears to me that I need to
"install" the Finance::Quote module.  However, despite the documentation, I
cannot find the "Gnucash Start Group"-- all it includes is the exe file (I'm
running Windows 10 Pro)... in the start group Gnucash exe simply appears
under the Financial folder.

I did try and run gnc-fq-check via the bin folder and it confirmed I need to
install Finance::Quote.  When I run gnc-fq-update from the bin folder it
stops at c:\strawb~/\c\bin\gmake.exe -- ok.  

So I throw myself at your mercy, do I need new glasses or where do i look to
install Finance::Quote.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Price retrieval

[randix]

I sincerely appreciate your response, however, as reflected in the attached
piks:

1. I do NOT have a GnuCash group in the Start menu, only the exe file
appears, as reflected in the attached screenshot, so I can't access the
"Install Online Price Retrieval" from there;

2. If I do a search for "Install Online Price Retrieval for Gnucash" off the
search option on the taskbar, it only brings up hits on the web, nothing to
run on my own laptop, as reflected in the attached screenshot.

So color me confused.  I'm running Windows 10 Professional, on a brand new
Dell XPS 13 laptop.

I should also mention that on my other laptop, also a Dell XPS 13, also
which is running Windows 10 Pro, which I also have Gnucash installed running
4.2 and which I've been using without a problem for the past couple of
years, the price module works fine... however, as in the case of the brand
new laptop described above, on this laptop GnuCash ALSO has NO folder in the
start menu, and if you do a search for the retrieval off the taskbar, it
also only brings up hits on the web.  I have no recollection how I
successfully installed it on this laptop, but I must have done something
right, cause it runs perfectly.

g1.jpg <http://gnucash.1415818.n4.nabble.com/file/t374961/g1.jpg>  
g2.jpg <http://gnucash.1415818.n4.nabble.com/file/t374961/g2.jpg>  





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Price retrieval

[Geert Janssens]

Hi,

You seem to have a different Windows menu on your Windows 10 than I do. 
Perhaps that's the tablet mode and I'm in desktop mode.

On my Windows menu there are both a GnuCash application and a GnuCash folder. 
Inside the folder I do see the Online price retrieval installer.

Having said all that, the reference in the Windows menu is just a fancy link 
to
C:\Program Files (x86)\gnucash\bin\install-fq-mods.cmd

So you can just run that command directly instead.

Regards,

Geert

Op woensdag 11 november 2020 21:46:42 CET schreef randix:
> I sincerely appreciate your response, however, as reflected in the attached
> piks:
> 
> 1. I do NOT have a GnuCash group in the Start menu, only the exe file
> appears, as reflected in the attached screenshot, so I can't access the
> "Install Online Price Retrieval" from there;
> 
> 2. If I do a search for "Install Online Price Retrieval for Gnucash" off the
> search option on the taskbar, it only brings up hits on the web, nothing to
> run on my own laptop, as reflected in the attached screenshot.
> 
> So color me confused.  I'm running Windows 10 Professional, on a brand new
> Dell XPS 13 laptop.
> 
> I should also mention that on my other laptop, also a Dell XPS 13, also
> which is running Windows 10 Pro, which I also have Gnucash installed running
> 4.2 and which I've been using without a problem for the past couple of
> years, the price module works fine... however, as in the case of the brand
> new laptop described above, on this laptop GnuCash ALSO has NO folder in
> the start menu, and if you do a search for the retrieval off the taskbar,
> it also only brings up hits on the web.  I have no recollection how I
> successfully installed it on this laptop, but I must have done something
> right, cause it runs perfectly.
> 
> g1.jpg <http://gnucash.1415818.n4.nabble.com/file/t374961/g1.jpg>
> g2.jpg <http://gnucash.1415818.n4.nabble.com/file/t374961/g2.jpg>
> 
> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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] Price retrieval

[randix]

Geert... just to put a cap on this thread (it has a good ending)...

1. The Dell XPS 13 that was involved is not a 2-1 version (which Dell does
offer), it has a standard Windows 10 Professional install with no optional
tablet version as far as I'm aware.  I have no idea why the Start menu does
not reflect a "group" for GnuCash, only the exe file, etc.

2. I had previously tried to run "C:\Program Files
(x86)\gnucash\bin\install-fq-mods.cmd" but it stopped at
"c:/strawb~/\c\bin\gmake.exe -- ok." and it stopped there for such a "long
time" that I assumed it got stuck there for whatever reason.  I did try
running it again this morning and it again stopped at that point, but this
time I just went and took the proverbial "walk around the block", and it
finally did resume and the install was successful.

/So I have no explanation why the option does not appear in the Start menu,
nor when you type it in the search window on the task bar, but running the
CMD file in the bin folder did work, I just wasn't being patient enough
(something I seem to recall I've been told once or twice in my life on other
endeavors)./

In any event, thanks for your response.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Price retrieval

[Kalpesh Patel]

Looking at the picture of the menu shows that it has been customized.

 

Next best step would be to download the official full Windows package and
try to install it. That should create and populate that group properly. I
don't believe reinstalling it will harm in anyway as I have reinstalled
multiple times on my own desktop without any issues nor will it impact your
ability to retrieve prices as it will not touch that portion of installation
either.

 

Kalpesh.

___
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] Online price retrieval

[duru...@netzero.net]

Does anyone know (or think he/she knows) whether online price retrieval is 
supposed towork with windows version 6.1.7601?  I ran the install procedure, 
but it seems to havefailed.  It didn't leave a log file that I could identify, 
so I don't really know what to look at. Joe D. duru...@netzero.net 

1 Cup (Before Bed) Burns Belly Fat Like Crazy!
worldhealthlabs.com
http://thirdpartyoffers.netzero.net/TGL3241/5d2bd18b7d282518b7685st01duc
___
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: Price Retrieval Failure

[david amaral via gnucash-user]

Verify security editor for your investments have get quotes checked and 
AlphaVantage  listed as source for each entry.

  From: David T. via gnucash-user 
 To: Gnucash Users  
 Sent: Tuesday, January 23, 2018 10:07 AM
 Subject: Price Retrieval Failure
   
Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
works at the command line:

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts”)

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage AAPL
Finance::Quote fields Gnucash uses:
    symbol: AAPL                <=== required
      date: 01/23/2018          <=== recommended
  currency: USD                  <=== required
      last: 178.6400            <=\      
      nav:                      <=== one of these
    price:                      <=/        
  timezone:                      <=== optional

I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Price Retrieval Failure

[D via gnucash-user]

Thanks. As I noted originally, my file was correctly configured and retrieving 
quotes from Alphavantage before the upgrade. Regardless, I had double checked 
that as well. 

Did you know that you can display the quote source for your securities on the 
main securities page? I didn't, before this.

David

On January 23, 2018, at 10:25 PM, david amaral  wrote:

Verify security editor for your investments have get quotes checked and 
AlphaVantage  listed as source for each entry.



From: David T. via gnucash-user 
To: Gnucash Users  
Sent: Tuesday, January 23, 2018 10:07 AM
Subject: Price Retrieval Failure


Hello,


I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.


Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
works at the command line:


$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check

("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts”)


$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage AAPL

Finance::Quote fields Gnucash uses:

    symbol: AAPL                <=== required

      date: 01/23/2018          <=== recommended

  currency: USD                  <=== required

      last: 178.6400            <=\      

      nav:                      <=== one of these

    price:                      <=/        

  timezone:                      <=== optional


I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:


# Set AlphaVantage API Key to allow Finance::Quote to work

ALPHAVANTAGE_API_KEY=8SET


Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”


I welcome any reminders on what I have missed, or how to debug this further.


TIA,

David T.

___

gnucash-user mailing list

gnucash-user@gnucash.org

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
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: Price Retrieval Failure

[Derek Atkins]

Did you update the environment file again after the upgrade? The update 
process overwrites that file.


-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user 
 wrote:


Thanks. As I noted originally, my file was correctly configured and 
retrieving quotes from Alphavantage before the upgrade. Regardless, I had 
double checked that as well.


Did you know that you can display the quote source for your securities on 
the main securities page? I didn't, before this.


David

On January 23, 2018, at 10:25 PM, david amaral  wrote:

Verify security editor for your investments have get quotes checked 
and AlphaVantage  listed as source for each entry.




From: David T. via gnucash-user 
To: Gnucash Users 
Sent: Tuesday, January 23, 2018 10:07 AM
Subject: Price Retrieval Failure


Hello,


I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the 
prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable 
for the Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, 
changed all my stocks to use other:alphavantage, and I was able to retrieve 
quotes.



Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. 
F::Q works at the command line:



$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check

("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
"asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" 
"bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
"ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
"greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
"tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
"yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
"yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)



$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage 
AAPL


Finance::Quote fields Gnucash uses:

    symbol: AAPL                <=== required

      date: 01/23/2018          <=== recommended

  currency: USD                  <=== required

      last: 178.6400            <=\     

      nav:                      <=== one of these

    price:                      <=/       

  timezone:                      <=== optional


I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:



# Set AlphaVantage API Key to allow Finance::Quote to work

ALPHAVANTAGE_API_KEY=8SET


Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”



I welcome any reminders on what I have missed, or how to debug this further.


TIA,

David T.

___

gnucash-user mailing list

gnucash-user@gnucash.org

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
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
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: Price Retrieval Failure

[D via gnucash-user]

Derek,

I did edit the environment file.

This experience makes it clear to me that it would be nice if Gnucash had some 
way of showing F::Q information to the end user, like a screen showing the 
version installed, and maybe having buttons to trigger the various gnc- scripts 
and show the output. This would make debugging just a tad easier... (Note that 
I am not asking for better error messages, which certainly would be nice, but 
not likely, since finance quote isn't Gnucash).

David



On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:

Did you update the environment file again after the upgrade? The update 
process overwrites that file.

-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user 
 wrote:

> Thanks. As I noted originally, my file was correctly configured and 
> retrieving quotes from Alphavantage before the upgrade. Regardless, I had 
> double checked that as well.
>
> Did you know that you can display the quote source for your securities on 
> the main securities page? I didn't, before this.
>
> David
>
> On January 23, 2018, at 10:25 PM, david amaral  wrote:
>
> Verify security editor for your investments have get quotes checked 
> and AlphaVantage  listed as source for each entry.
>
>
>
> From: David T. via gnucash-user 
> To: Gnucash Users 
> Sent: Tuesday, January 23, 2018 10:07 AM
> Subject: Price Retrieval Failure
>
>
> Hello,
>
>
> I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the 
> prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable 
> for the Alphavantage key, added the same key to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, 
> changed all my stocks to use other:alphavantage, and I was able to retrieve 
> quotes.
>
>
> Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. 
> F::Q works at the command line:
>
>
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" 
> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>
>
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage 
> AAPL
>
> Finance::Quote fields Gnucash uses:
>
>     symbol: AAPL                <=== required
>
>       date: 01/23/2018          <=== recommended
>
>   currency: USD                  <=== required
>
>       last: 178.6400            <=\     
>
>       nav:                      <=== one of these
>
>     price:                      <=/       
>
>   timezone:                      <=== optional
>
>
> I have restored the following two lines into the aforementioned lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>
>
> # Set AlphaVantage API Key to allow Finance::Quote to work
>
> ALPHAVANTAGE_API_KEY=8SET
>
>
> Unfortunately, I am getting the dreaded "There was an unknown error while 
> retrieving the price quotes.”
>
>
> I welcome any reminders on what I have missed, or how to debug this further.
>
>
> TIA,
>
> David T.
>
> ___
>
> gnucash-user mailing list
>
> gnucash-user@gnucash.org
>
> 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
> 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
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: Price Retrieval Failure

[David Carlson]

D

Some of that information is already available.  I know that the F::Q
version appears in the console if GnuCash is started from the command
line.  There are also instructions somewhere in the WIKI (I think) to run
F::Q as a stand-alone.  Perhaps the answer is to have better documentation
(which is dear to the hearts of some of us ;-) )

David C

On Tue, Jan 23, 2018 at 9:01 PM, D via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Derek,
>
> I did edit the environment file.
>
> This experience makes it clear to me that it would be nice if Gnucash had
> some way of showing F::Q information to the end user, like a screen showing
> the version installed, and maybe having buttons to trigger the various gnc-
> scripts and show the output. This would make debugging just a tad easier...
> (Note that I am not asking for better error messages, which certainly would
> be nice, but not likely, since finance quote isn't Gnucash).
>
> David
>
>
>
> On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:
>
> Did you update the environment file again after the upgrade? The update
> process overwrites that file.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
>
>
> On January 23, 2018 1:08:36 PM D via gnucash-user
>  wrote:
>
> > Thanks. As I noted originally, my file was correctly configured and
> > retrieving quotes from Alphavantage before the upgrade. Regardless, I had
> > double checked that as well.
> >
> > Did you know that you can display the quote source for your securities on
> > the main securities page? I didn't, before this.
> >
> > David
> >
> > On January 23, 2018, at 10:25 PM, david amaral 
> wrote:
> >
> > Verify security editor for your investments have get quotes checked
> > and AlphaVantage  listed as source for each entry.
> >
> >
> >
> > From: David T. via gnucash-user 
> > To: Gnucash Users 
> > Sent: Tuesday, January 23, 2018 10:07 AM
> > Subject: Price Retrieval Failure
> >
> >
> > Hello,
> >
> >
> > I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the
> > prior setup, I had upgraded Finance::Quote to 1.47, added a shell
> variable
> > for the Alphavantage key, added the same key to
> > /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment,
> > changed all my stocks to use other:alphavantage, and I was able to
> retrieve
> > quotes.
> >
> >
> > Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes.
> > F::Q works at the command line:
> >
> >
> > $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> >
> > ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
> > "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
> "bse"
> > "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
> "dutch"
> > "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> > "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> > "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> > "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
> > "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
> > "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
> > "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> > "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> "tsx"
> > "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard"
> "vwd"
> > "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
> > "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> >
> >
> >

Re: Price Retrieval Failure

[David T. via gnucash-user]

David,
I know how to extract that information. 
My point is that it should be made readily available to a user ***from within 
gnucash***.
This is especially true given that it is possible for F::Q to work in one 
scenario (i.e., at the command line), but not the other. I will also note that 
there are many instances where a user has multiple versions of F::Q on their 
systems, with one version running at the command line, and the other in 
gnucash. 
So, really, for reliable debugging, you need to know exactly what gnucash 
thinks it is using. 

Documentation isn't the answer here, since F::Q is a separately maintained 
project. 
David T.
 
 
  On Wed, Jan 24, 2018 at 10:05, David Carlson 
wrote:   D

Some of that information is already available.  I know that the F::Q version 
appears in the console if GnuCash is started from the command line.  There are 
also instructions somewhere in the WIKI (I think) to run F::Q as a stand-alone. 
 Perhaps the answer is to have better documentation (which is dear to the 
hearts of some of us ;-) )

David C

On Tue, Jan 23, 2018 at 9:01 PM, D via gnucash-user  
wrote:

Derek,

I did edit the environment file.

This experience makes it clear to me that it would be nice if Gnucash had some 
way of showing F::Q information to the end user, like a screen showing the 
version installed, and maybe having buttons to trigger the various gnc- scripts 
and show the output. This would make debugging just a tad easier... (Note that 
I am not asking for better error messages, which certainly would be nice, but 
not likely, since finance quote isn't Gnucash).

David



On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:

Did you update the environment file again after the upgrade? The update
process overwrites that file.

-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user
 wrote:

> Thanks. As I noted originally, my file was correctly configured and
> retrieving quotes from Alphavantage before the upgrade. Regardless, I had
> double checked that as well.
>
> Did you know that you can display the quote source for your securities on
> the main securities page? I didn't, before this.
>
> David
>
> On January 23, 2018, at 10:25 PM, david amaral  wrote:
>
> Verify security editor for your investments have get quotes checked
> and AlphaVantage  listed as source for each entry.
>
>
>
> From: David T. via gnucash-user 
> To: Gnucash Users 
> Sent: Tuesday, January 23, 2018 10:07 AM
> Subject: Price Retrieval Failure
>
>
> Hello,
>
>
> I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the
> prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable
> for the Alphavantage key, added the same key to
> /Applications/Gnucash.app/ Contents/Resources/etc/ gnucash/environment,
> changed all my stocks to use other:alphavantage, and I was able to retrieve
> quotes.
>
>
> Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes.
> F::Q works at the command line:
>
>
> $ /Applications/Gnucash.app/ Contents/Resources/bin/gnc-fq- check
>
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd"
> "yahoo" "yahoo_

Re: Price Retrieval Failure

[Geert Janssens]

David,

Op woensdag 24 januari 2018 04:01:23 CET schreef D via gnucash-user:
> Derek,
> 
> I did edit the environment file.
> 
As a sneak preview, with 3.0 this will become a thing of the past. Instead of 
updating the environment file over and over, you will be creating an 
"environment.local" file right next to the environment file and make your 
local customizations in there. Gnucash will never override that file, so your 
customizations will survive gnucash updates.

Of course that's not much help right now. I thought it was worth mentioning 
already.

Even better would be if gnucash would provide a gui somewhere to allow the 
user to enter the alphavantage key. There are several pitfalls to that 
approach as well though and in the context of this mail I won't go into those.

> This experience makes it clear to me that it would be nice if Gnucash had
> some way of showing F::Q information to the end user, like a screen showing
> the version installed, and maybe having buttons to trigger the various gnc-
> scripts and show the output. This would make debugging just a tad easier...
> (Note that I am not asking for better error messages, which certainly would
> be nice, but not likely, since finance quote isn't Gnucash).

Totally agreed indeed.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Price Retrieval Failure

[Geert Janssens]

David,

Another thing to try is run gnucash from the command line (I  believe this is 
also possible on OS X, though I don't know the details).

Normally gnucash prints the version of F::Q it finds to the console during 
startup. That may give a hint already.

Geert

Op woensdag 24 januari 2018 04:01:23 CET schreef D via gnucash-user:
> Derek,
> 
> I did edit the environment file.
> 
> This experience makes it clear to me that it would be nice if Gnucash had
> some way of showing F::Q information to the end user, like a screen showing
> the version installed, and maybe having buttons to trigger the various gnc-
> scripts and show the output. This would make debugging just a tad easier...
> (Note that I am not asking for better error messages, which certainly would
> be nice, but not likely, since finance quote isn't Gnucash).
> 
> David
> 
> 
> 
> On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:
> 
> Did you update the environment file again after the upgrade? The update 
> process overwrites that file.
> 
> -derek
> Sent using my mobile device. Please excuse any typos.
> 
> 
> 
> On January 23, 2018 1:08:36 PM D via gnucash-user 
>  wrote:
> 
> 
> > Thanks. As I noted originally, my file was correctly configured and 
> > retrieving quotes from Alphavantage before the upgrade. Regardless, I had
> > 
> > double checked that as well.
> >
> >
> >
> > Did you know that you can display the quote source for your securities on
> > 
> > the main securities page? I didn't, before this.
> >
> >
> >
> > David
> >
> >
> >
> > On January 23, 2018, at 10:25 PM, david amaral 
> > wrote:
>
> >
> >
> > Verify security editor for your investments have get quotes checked 
> > and AlphaVantage  listed as source for each entry.
> >
> >
> >
> >
> >
> > From: David T. via gnucash-user 
> > To: Gnucash Users 
> > Sent: Tuesday, January 23, 2018 10:07 AM
> > Subject: Price Retrieval Failure
> >
> >
> >
> >
> > Hello,
> >
> >
> >
> >
> > I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the
> > 
> > prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable
> > 
 for the Alphavantage key, added the same key to
> > /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, 
> > changed all my stocks to use other:alphavantage, and I was able to
> > retrieve 
 quotes.
> >
> >
> >
> >
> > Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes.
> > 
> > F::Q works at the command line:
> >
> >
> >
> >
> > $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> >
> >
> >
> > ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
> > "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
> > 
 "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
> > "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> > "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner"
> > "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct"
> > "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary"
> > "hustock" "indiamutual"
> > "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> > "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> > "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> > "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> > "tsx" 
 "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds"
> > "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil"
> > "yahoo_europe" "yaho

Re: Price Retrieval Failure

[Cam Ellison]

On 24/01/18 11:26 AM, Geert Janssens wrote:

David,

Another thing to try is run gnucash from the command line (I  believe this is
also possible on OS X, though I don't know the details).

Normally gnucash prints the version of F::Q it finds to the console during
startup. That may give a hint already.



You can force discovery of the version by doing this on the command line:
gnucash --add-price-quotes /path/to/gnucash_file

It's probably better to do this when gnucash is not running, but it 
should work even when it does. It just won't access the file because 
it's already locked.


Cheers

Cam

___
gnucash-user mailing list
gnucash-user@gnucash.org
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] Automatic Price Retrieval

[rsbrux via gnucash-user]

I would like GnuCah to retrieve prices automatically each time I open it.

The documentation describes the "Get Quotes" feature as "automatic", but 
I still have to remember to open the Price Editor and click "Get Quotes".


Is there a way to make price retrieval fully automatic?

___
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] Price retrieval failing

[R. Warriner via gnucash-user]

Since updating to the latest version I have been unable to get prices to 
download. I updated the necessary Perl modules using gnc-fq-update.
In the application it does not report an error. I can see the command line 
window (running the perl scripts) briefly appear in the background, then close. 
The application then returns to the main window with the price window in the 
background. Prices do not update and no error is persistently displayed. If an 
error is shown in the brief command prompt I am unable to catch it in time 
before the window closes.  
If I using the command line, running

"c:\program files (x86)\gnucash\bin\gnucash-cli" --quotes get --namespace=ETF 
Household.gnucash

returns:

.ound Finance::Quote version 1.54
Price retrieval failed: GncQuotes::Fetch called with no commodities.

Everything was working and downloading properly prior to updating to 5.0 and no 
changes were made to commodities. The specified namespace (ETF) uses 
Alphavantage as its quote source, I also receive the same error if I use Yahoo 
as json.

Are there additional configuration changes to be made?

Thanks

Robert


Sent with Proton Mail secure email.

publickey - rmwarriner@protonmail.com - 0x08D61740.asc
Description: application/pgp-keys


signature.asc
Description: OpenPGP digital signature
___
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] Online price retrieval

[David H]

Lots of info at https://wiki.gnucash.org/wiki/Online_Quotes if you want to
read up on it.

There's a menu item for it - left click on the start menu windows logo,
left click on "A" in the list of installed programs, then left click "G"
for Gnucash and then open the Gnucash folder and click on the "Install
Online Price Retrieval for GnuCash" shortcut in the folder and let it do
it's thing.  This will also install Strawberry Perl for you as it needs
that to run - can take 5 - 10 minutes so wait until it finishes.

Cheers David H.

On Thu, 14 Oct 2021 at 15:36, J Medina  wrote:

> Gentlemen/Ladies,
>
> I want to install Finance::Quote on Windows10
>
> Could you please give me a bit more detailed explanation on how to do this
> >>>  Run Start → GnuCash → Install Online Price Retrieval.
>
> I understand I need to do this from the command prompt ...I just need a
> more substantial explanation even if it is a broad one. Thank you a lot.
> ___
> 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] Online price retrieval

[Kalpesh Patel]

In the search box (the icon that looks like magnifying glass in the task
bar) just type in "Install Online Price Retrieval for GnuCash" and press the
"Enter" key to kick off the installation routine. You can follow the same
process to upgrade now and then as well. If all goes well, you should get a
message to the effect "* Installation succeeded" followed by "Press any key
to continue . . ." message. Here is the final screen output that I see:

 

 

 

Finance::Quote is up to date (1.51).

 

* Check environment variable ALPHAVANTAGE_API_KEY

 

  ***

  *** You need an API key (from https://www.alphavantage.co)

  ***   to run the Perl module Finance::Quote.

  ***

  *** Make it available to GnuCash by

  ***- setting the environment variable ALPHAVANTAGE_API_KEY or

  ***- starting GnuCash and adding the Alpha Vantage api key in

  ***Edit->Preferences->Online Quotes

  ***

 

* Run gnc-fq-check

 

("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia"
"bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual"
"comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies"
"fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds"
"fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
"hustock" "iexcloud" "india" "indiamutual" "known_currencies"
"morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
"onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
"tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds"
"usa" "usfedbonds" "yahoo_json" "za")

 

* Run gnc-fq-helper

 

(#f)

 

* Installation succeeded

 

Press any key to continue . . .

 

 

 

--

 

Message: 5

Date: Thu, 14 Oct 2021 15:50:21 +1000

From: David H 

To: J Medina 

Cc: "gnucash-user@gnucash.org" 

Subject: Re: [GNC] Online price retrieval

Message-ID:

 


Content-Type: text/plain; charset="UTF-8"

 

Lots of info at https://wiki.gnucash.org/wiki/Online_Quotes if you want to
read up on it.

 

There's a menu item for it - left click on the start menu windows logo, left
click on "A" in the list of installed programs, then left click "G"

for Gnucash and then open the Gnucash folder and click on the "Install
Online Price Retrieval for GnuCash" shortcut in the folder and let it do
it's thing.  This will also install Strawberry Perl for you as it needs that
to run - can take 5 - 10 minutes so wait until it finishes.

 

Cheers David H.

 

On Thu, 14 Oct 2021 at 15:36, J Medina  wrote:

 

> Gentlemen/Ladies,

> 

> I want to install Finance::Quote on Windows10

> 

> Could you please give me a bit more detailed explanation on how to do 

> this

> >>>  Run Start ? GnuCash ? Install Online Price Retrieval.

> 

> I understand I need to do this from the command prompt ...I just need 

> a more substantial explanation even if it is a broad one. Thank you a lot.

> ___

> 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] Online price retrieval

[Fred Bone]

On 13 October 2021 at 0:24, J Medina said:

> Gentlemen/Ladies,
> 
> I want to install Finance::Quote on Windows10
> 
> Could you please give me a bit more detailed explanation on how to do this
> >>>  Run Start → GnuCash → Install Online Price Retrieval.
> 
> I understand I need to do this from the command prompt ...I just need a
> more substantial explanation even if it is a broad one. Thank you a lot.

No, you do not do it from the command prompt. You run it from the Start 
menu.

___
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] Online price retrieval

[John Ralls]

> On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote:
> 
> Does anyone know (or think he/she knows) whether online price retrieval is 
> supposed towork with windows version 6.1.7601?  I ran the install procedure, 
> but it seems to havefailed.  It didn't leave a log file that I could 
> identify, so I don't really know what to look at. Joe D. duru...@netzero.net 
> 

Yes, it should work on Win7.

Look in the Start Menu for a folder named Strawberry Perl. If it's there then 
open it and pick "CPAN Client". You'll get a terminal window with a 
cpan>prompt. Tell it:

  install Date::Manip

and if that completes without errors

  install Finance::Quote

If they both complete successfully online quotes should work inside of GnuCash. 
If either fails or if the Strawberry folder is missing come back with details.

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] Online price retrieval

[John Ralls]

Please remember to copy the list on all replies. "Reply All" works well for 
most mail clients.


Sounds like Strawberry Perl didn't get installed all the way. There should be a 
download in your downloads directory, but if there isn't you can download the 
latest version from http://strawberryperl.com/. Try installing it by hand. If 
it doesn't work there's a support link in the upper right corner of that page.

Regards,
John Ralls


> On Jul 15, 2019, at 5:24 PM, duru...@netzero.net wrote:
> 
> Thank you for your response. 
>  
> The Strawberry Perl folder does exist.
> However, there is no object inside that folder named CPAN Client (Or CPAN
> anything, for that matter).
>  
> The contents of the Strawberry Perl folder are:
>Perl (command line)
>Strawberry Perl README
>Strawberry Perl Release notes
>Related websites
>Tools
>  
> On the off chance that it might work, I ran CPAN Client as a command from the
> DOS prompt. 
>  
> The first error message was :
>Couldn't fork at test.p1 line 44.
>Client couldn't establish a connection to localhost at test.p1 line 57.
>   dmake.exe:  Error code 153, while making "test_dynamic'
>   EESTABR00/Crypt-HCE_SHA-0.75.tar.gz
>  
> So it appearss that something is missing.
>  
> Joe D.
>  
> 
> 
> -- Original Message --
> From: John Ralls 
> To: "duru...@netzero.net" 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Online price retrieval
> Date: Mon, 15 Jul 2019 13:28:07 -0700
> 
> 
> 
> > On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote:
> > 
> > Does anyone know (or think he/she knows) whether online price retrieval is 
> > supposed towork with windows version 6.1.7601?  I ran the install 
> > procedure, but it seems to havefailed.  It didn't leave a log file that I 
> > could identify, so I don't really know what to look at. Joe D. 
> > duru...@netzero.net 
> > 
> 
> Yes, it should work on Win7.
> 
> Look in the Start Menu for a folder named Strawberry Perl. If it's there then 
> open it and pick "CPAN Client". You'll get a terminal window with a 
> cpan>prompt. Tell it:
> 
>  install Date::Manip
> 
> and if that completes without errors
> 
>  install Finance::Quote
> 
> If they both complete successfully online quotes should work inside of 
> GnuCash. If either fails or if the Strawberry folder is missing come back 
> with details.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
> Exposed: Big Pharma’s Lies About Diabetes
> glucotype2.com
> http://thirdpartyoffers.netzero.net/TGL3242/5d2d1970641fa19704e31st01duc
> 

___
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] Online price retrieval

[Fross, Michael]

Hello. I just had to reinstall strawberry Perl on windows 10. I just
downloaded the 64 bit version and installed it.  Then make sure both it’s
perl/bin and the c/bin directories are in your path. I had to add the c/bin
manually. Without it cpan was unable to build correctly.

After I installed Date::Manip and Finance::Quote GC was able to down my
quotes per usual. I use yahoo-Json as my quote source.

Michael

On Mon, Jul 15, 2019 at 10:05 PM John Ralls  wrote:

> Please remember to copy the list on all replies. "Reply All" works well
> for most mail clients.
>
>
> Sounds like Strawberry Perl didn't get installed all the way. There should
> be a download in your downloads directory, but if there isn't you can
> download the latest version from http://strawberryperl.com/. Try
> installing it by hand. If it doesn't work there's a support link in the
> upper right corner of that page.
>
> Regards,
> John Ralls
>
>
> > On Jul 15, 2019, at 5:24 PM, duru...@netzero.net wrote:
> >
> > Thank you for your response.
> >
> > The Strawberry Perl folder does exist.
> > However, there is no object inside that folder named CPAN Client (Or CPAN
> > anything, for that matter).
> >
> > The contents of the Strawberry Perl folder are:
> >Perl (command line)
> >Strawberry Perl README
> >Strawberry Perl Release notes
> >Related websites
> >Tools
> >
> > On the off chance that it might work, I ran CPAN Client as a command
> from the
> > DOS prompt.
> >
> > The first error message was :
> >Couldn't fork at test.p1 line 44.
> >Client couldn't establish a connection to localhost at test.p1 line
> 57.
> >   dmake.exe:  Error code 153, while making "test_dynamic'
> >   EESTABR00/Crypt-HCE_SHA-0.75.tar.gz
> >
> > So it appearss that something is missing.
> >
> > Joe D.
> >
> >
> >
> > -- Original Message --
> > From: John Ralls 
> > To: "duru...@netzero.net" 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Online price retrieval
> > Date: Mon, 15 Jul 2019 13:28:07 -0700
> >
> >
> >
> > > On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote:
> > >
> > > Does anyone know (or think he/she knows) whether online price
> retrieval is supposed towork with windows version 6.1.7601?  I ran the
> install procedure, but it seems to havefailed.  It didn't leave a log file
> that I could identify, so I don't really know what to look at. Joe D.
> duru...@netzero.net
> > > 
> >
> > Yes, it should work on Win7.
> >
> > Look in the Start Menu for a folder named Strawberry Perl. If it's there
> then open it and pick "CPAN Client". You'll get a terminal window with a
> cpan>prompt. Tell it:
> >
> >  install Date::Manip
> >
> > and if that completes without errors
> >
> >  install Finance::Quote
> >
> > If they both complete successfully online quotes should work inside of
> GnuCash. If either fails or if the Strawberry folder is missing come back
> with details.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> > 
> > Exposed: Big Pharma’s Lies About Diabetes
> > glucotype2.com
> > http://thirdpartyoffers.netzero.net/TGL3242/5d2d1970641fa19704e31st01duc
> >
>
> ___
> 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] Online price retrieval

[John Ralls]

That looks like a problem with Strawberry Perl. There's a support link on their 
web page.

Regards,
John Ralls


> On Jul 19, 2019, at 6:34 PM, duru...@netzero.net wrote:
> 
> Well, I've made a little progress.  It turns out that I was not aware of the 
> fact that you can't just search
> for cpan client or some such, you have to click on the windows Icon, then all 
> programs, blah, blah
> and that cpan client is stored under a tools subdirectory.
>  
> Once there, the command install date::Manip seemed to work without errors.
>  
> However, install Finance::Quote did not do so.  I am attaching a sheet that 
> shows a scan of the
> last screen of the installation procedure, and the result of a command that 
> supposedly gives a clue
> as to what the error is.  Unfortunately, the codes cited mean nothing to me 
> as such.  I hope
> whoever is in charge of updating cpan will consider at some time including a 
> command that
> will redirect all output to a discrete file, which would make finding this 
> kind of error much easier.
>  
> Thanks to all who have tried to help.
>  
> Joe D.
>  
> 
> 
> -- Original Message --
> From: John Ralls 
> To: "duru...@netzero.net" 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Online price retrieval
> Date: Mon, 15 Jul 2019 13:28:07 -0700
> 
> 
> 
> > On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote:
> > 
> > Does anyone know (or think he/she knows) whether online price retrieval is 
> > supposed towork with windows version 6.1.7601?  I ran the install 
> > procedure, but it seems to havefailed.  It didn't leave a log file that I 
> > could identify, so I don't really know what to look at. Joe D. 
> > duru...@netzero.net 
> > 
> 
> Yes, it should work on Win7.
> 
> Look in the Start Menu for a folder named Strawberry Perl. If it's there then 
> open it and pick "CPAN Client". You'll get a terminal window with a 
> cpan>prompt. Tell it:
> 
>  install Date::Manip
> 
> and if that completes without errors
> 
>  install Finance::Quote
> 
> If they both complete successfully online quotes should work inside of 
> GnuCash. If either fails or if the Strawberry folder is missing come back 
> with details.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
> Meghan Markle Confirms Unfortunate News
> track.volutrk.com
> http://thirdpartyoffers.netzero.net/TGL3242/5d326ffcb8dc76ffc64cfst02duc
> 

___
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] Online price retrieval

[Fross, Michael]

Did you confirm that the following are in your path?  I had a few issues
until both were there.  perl/bin is probably added during installation, but
the c\bin entry was not for me.

C:\Strawberry\c\bin
C:\Strawberry\perl\bin

If you are not certain what that means, go to Control Panel, System,
Advanced System Settings, Environment Variables.

Make sure the two preceding directories are part of the PATH variable which
is a semi-colon delimited list of directories that are searched if you are
running an executable file that is not in your current directory.

If they are not there you can append the missing ones to the existing path
variable.  It doesn't really matter which as they are concatenated during
the actual search.

Hope this helps.

Michael
___
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.

stock price retrieval not working

[Dino Carubia via gnucash-user]

Installed latest version of gnucash (2.6.18).Ran "Install online price 
retrieval..."
When I try to update stock prices I get the following:"There was an unknown 
error while retrieving the price quotes."
I have tried to use the "multiple sources" option, but I still cannot get any 
prices.
If I try the command line I get the following result:C:\Program Files 
(x86)\gnucash\bin>perl gnc-fq-dump -v yahoo ibmNo results found for stock ibm.
I was last able to retrieve prices successfully on October 29th, 2017.
Any advice would be appreciated!

___
gnucash-user mailing list
gnucash-user@gnucash.org
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 Install Online Price Retrieval

[Bob Wachtel]

I have recently installed Gnucash with import from my previous Quicken files. I 
have not been able to find the Install Online Price Retrieval function to 
enable online stock price retrieval. I am running windows 8.1 and do not find a 
"Start Menu Gnucash Group". Windows 8.1 does not seem to have the Start Menu 
function.

Any help would be appreciated.

--
Bob Wachtel
BPAB Chair
BTPA Treasurer and Webmaster
Home: 406-728-6398
Cell: 406-218-1132 (text, voice)
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Price Retrieval Failure, Part 2

[David T. via gnucash-user]

In thread 
https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
<https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, I 
noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac (OS 
X 10.13.3), Price retrieval was failing with the generic error: "There was an 
unknown error while retrieving the price quotes.”

*** As I noted there: Finance::Quote works at the command line:

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts”)

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage 
AAPL
Finance::Quote fields Gnucash uses:
symbol: AAPL <=== required
  date: 02/08/2018   <=== recommended
  currency: USD  <=== required
  last: 160.1350 <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

*** As I noted earlier: I restored the following two lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

It seems to me that somehow Gnucash.app is not reading or using the 
ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
somehow my environment file is not properly configured. However, I do not see 
any way to test these hypotheses. 

Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
the Alphavantage API key is being read, and what its value currently is? Is 
there any other way to troubleshoot this problem?

David
___
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] Automatic Price Retrieval

[John Ralls]

> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user 
>  wrote:
> 
> I would like GnuCah to retrieve prices automatically each time I open it.
> 
> The documentation describes the "Get Quotes" feature as "automatic", but I 
> still have to remember to open the Price Editor and click "Get Quotes".
> 
> Is there a way to make price retrieval fully automatic?

Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE 
argument, FILE being the path to your gnucash data file. 

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] Automatic Price Retrieval

[John Ralls]

> On Apr 29, 2020, at 9:54 AM, John Ralls  wrote:
> 
> 
> 
>> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user 
>>  wrote:
>> 
>> I would like GnuCah to retrieve prices automatically each time I open it.
>> 
>> The documentation describes the "Get Quotes" feature as "automatic", but I 
>> still have to remember to open the Price Editor and click "Get Quotes".
>> 
>> Is there a way to make price retrieval fully automatic?
> 
> Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE 
> argument, FILE being the path to your gnucash data file. 

I should have added that GnuCash should not be running with that file open when 
the job runs.

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] Online Price Retrieval Fails

[nvsoar]

Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
reports DateManip could not be found; reports the following at the end.


* Run gnc-fq-helper
Can't locate Date/Manip.pm in @INC (you may need to install the 
Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib 
C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper 
line 29.

BEGIN failed--compilation aborted at gnc-fq-helper line 29.
An error occurred, see above.
Press any key to continue . . .

Have know idea for the meaning of @INC, or where to put the Date::Manip 
module.


Same fault for GnuCash version 2.6.17

Please advise.

Thank you for your assistance.
nvsoar

___
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] Security price retrieval [again]

[Graham]

Hi team,

After unsuccessful aatempts to get price retrieval to work on Windows, 
Gnucash 3.8, i went back to the manual, only to find that I was missing 
gnc-fq-dump in the start menu.


I have uninstalled and installed 4.4, but it is still not there. When I 
run the update prices, some stocks are updated, but after a good 4 
minutes, this appears :



Looking at the list, some were set to Morningstar GB whereas the 
Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo 
JSON ran update prices again and it just froze completely.


Any ideas, o wise ones?

--

--
Cheerio,

Graham



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Security price retrieval [again]

[Frank H. Ellenberger]

Hi Graham,

Am 03.01.21 um 18:45 schrieb Graham:
>
> I have uninstalled and installed 4.4, but it is still not there. When I
> run the update prices, some stocks are updated, but after a good 4
> minutes, this appears :
>
>
> Looking at the list, some were set to Morningstar GB whereas the
> Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo
> JSON ran update prices again and it just froze completely.
>
> Any ideas, o wise ones?

lookong at https://github.com/finance-quote/finance-quote/commits/master
several services like Morningstar have problems in F::Q

Can you test with gnc-fq-* scripts?
https://wiki.gnucash.org/wiki/Online_Quotes

Regards
Frank
___
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] Security price retrieval [again]

[Graham]

Thanks Frank, but I get ' Can't open perl script "gnc-fq-check": No such 
file or directory '.

This

is all i have in the start menu. I have used the install program to get 
the latest version, and I've d/l'd GNC4.4


Graham






On 03/01/2021 20:06, Frank H. Ellenberger wrote:

Hi Graham,

Am 03.01.21 um 18:45 schrieb Graham:

I have uninstalled and installed 4.4, but it is still not there. When I
run the update prices, some stocks are updated, but after a good 4
minutes, this appears :


Looking at the list, some were set to Morningstar GB whereas the
Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo
JSON ran update prices again and it just froze completely.

Any ideas, o wise ones?

lookong at https://github.com/finance-quote/finance-quote/commits/master
several services like Morningstar have problems in F::Q

Can you test with gnc-fq-* scripts?
https://wiki.gnucash.org/wiki/Online_Quotes

Regards
Frank



--
--
Cheerio,

Graham



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Security price retrieval [again]

[David H]

Graham,

My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files
(x86)\gnucash\bin.

If they're not present have you run the "Install Online Price Retrieval for
GnuCash" which installs/sets up everything for Online Price Retrieval to
work?

Cheers David H.


On Mon, 4 Jan 2021 at 23:57, Graham  wrote:

> Thanks Frank, but I get ' Can't open perl script "gnc-fq-check": No such
> file or directory '.
> This
>
> is all i have in the start menu. I have used the install program to get
> the latest version, and I've d/l'd GNC4.4
>
> Graham
>
>
>
>
>
>
> On 03/01/2021 20:06, Frank H. Ellenberger wrote:
> > Hi Graham,
> >
> > Am 03.01.21 um 18:45 schrieb Graham:
> >> I have uninstalled and installed 4.4, but it is still not there. When I
> >> run the update prices, some stocks are updated, but after a good 4
> >> minutes, this appears :
> >>
> >>
> >> Looking at the list, some were set to Morningstar GB whereas the
> >> Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo
> >> JSON ran update prices again and it just froze completely.
> >>
> >> Any ideas, o wise ones?
> > lookong at https://github.com/finance-quote/finance-quote/commits/master
> > several services like Morningstar have problems in F::Q
> >
> > Can you test with gnc-fq-* scripts?
> > https://wiki.gnucash.org/wiki/Online_Quotes
> >
> > Regards
> > Frank
>
>
> --
> --
> Cheerio,
>
> Graham
>
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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] Security price retrieval [again]

[Graham]

On 04/01/2021 22:22, David H wrote:

Graham,

My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files 
(x86)\gnucash\bin.


If they're not present have you run the "Install Online Price 
Retrieval for GnuCash" which installs/sets up everything for Online 
Price Retrieval to work?


Cheers David H.


Thanks David.  There are gnc-fq-xxx files in C:\Program Files 
(x86)\gnucash\bin. [ I have run Install Online Price Retrieval for 
GnuCash .]


I apologise for ignorance but trying to run check from cmd prompt i get:

C:\Program Files (x86)\gnucash\bin>$ gnc-fq-check

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



--
Cheerio,

Graham


--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] Security price retrieval [again]

[Graham]

On 04/01/2021 22:22, David H wrote:

Sorry - just read your reply to Michelle. Ran it and got: C:\Program 
Files (x86)\gnucash\bin>perl "C:\Program Files 
(x86)\gnucash\bin\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")


C:\Program Files (x86)\gnucash\bin>

The dump command gave:
C:\Program Files (x86)\gnucash\bin>perl "C:\Program Files 
(x86)\gnucash\bin\gnc-fq-dump


Usage: C:\Program Files (x86)\gnucash\bin\gnc-fq-dump [-v] 
  [ ...]


-v: verbose
Available sources are:
 aex za_unittrusts cse bourso citywire morningstar fidelity_direct 
za mstaruk hustock deka amfiindia ftportfolios nyse bse troweprice 
greece finland aufunds hex vanguard nz hu yahoo_json uk_unit_trusts vwd 
usfedbonds fidelity canadamutual romania fool goldmoney tnetuk 
tdwaterhouse dwsfunds iexcloud financecanada unionfunds morningstarau 
bsero tsx platinum usa morningstarjp ftfunds tdefunds seb_funds hufund 
tiaacref indiamutual tsp france bamosz bmonesbittburns nzx maninv 
fidelityfixed finanzpartner adig hungary europe dutch asegr 
ftportfolios_direct aiahk sixfunds australia stockhousecanada_fund 
troweprice_direct morningstarch alphavantage nasdaq known_currencies 
lerevenu yahoo_yql asx fundlibrary ukfunds bet sixshares trustnet canada 
cominvest fetch_live_currencies


What do I do next?

Cheerio,

Graham



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Security price retrieval [again]

[David H]

Hi Graham,

Well I'm not sure what your original issue was as this is all I saw - no
image as you can't send images inline as part of your email. From memory
you either need to add images to the end or attach them as a separate file.

So what was your exact problem again :-)

Cheers David H.

I have uninstalled and installed 4.4, but it is still not there. When I
run the update prices, some stocks are updated, but after a good 4
minutes, this appears :

NOTHING HERE 

Looking at the list, some were set to Morningstar GB whereas the
Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo
JSON ran update prices again and it just froze completely.

Any ideas, o wise ones?

On Thu, 7 Jan 2021 at 00:18, Graham  wrote:

> On 04/01/2021 22:22, David H wrote:
>
> Sorry - just read your reply to Michelle. Ran it and got: C:\Program
> Files (x86)\gnucash\bin>perl "C:\Program Files
> (x86)\gnucash\bin\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")
>
> C:\Program Files (x86)\gnucash\bin>
>
> The dump command gave:
> C:\Program Files (x86)\gnucash\bin>perl "C:\Program Files
> (x86)\gnucash\bin\gnc-fq-dump
>
> Usage: C:\Program Files (x86)\gnucash\bin\gnc-fq-dump [-v] 
>  [ ...]
>
> -v: verbose
> Available sources are:
>  aex za_unittrusts cse bourso citywire morningstar fidelity_direct za
> mstaruk hustock deka amfiindia ftportfolios nyse bse troweprice greece
> finland aufunds hex vanguard nz hu yahoo_json uk_unit_trusts vwd usfedbonds
> fidelity canadamutual romania fool goldmoney tnetuk tdwaterhouse dwsfunds
> iexcloud financecanada unionfunds morningstarau bsero tsx platinum usa
> morningstarjp ftfunds tdefunds seb_funds hufund tiaacref indiamutual tsp
> france bamosz bmonesbittburns nzx maninv fidelityfixed finanzpartner adig
> hungary europe dutch asegr ftportfolios_direct aiahk sixfunds australia
> stockhousecanada_fund troweprice_direct morningstarch alphavantage nasdaq
> known_currencies lerevenu yahoo_yql asx fundlibrary ukfunds bet sixshares
> trustnet canada cominvest fetch_live_currencies
>
> What do I do next?
>
> Cheerio,
>
> Graham
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-8591653207436599312_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
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] Security price retrieval [again]

[dullege]

gnc-fq-check is not a standalone executable command, it's a perl script.

So open a Windows command prompt

Navigate ("cd" command) to " C:\Program Files (x86)\gnucash\bin" 

Then enter "perl gnc-fq-check"

This should list all version (eg "1.49", followed by all the quote sources)

-Original Message-
From: gnucash-user  On 
Behalf Of Graham
Sent: Thursday, 7 January 2021 1:12 AM
To: David H 
Cc: Gnucash Users 
Subject: Re: [GNC] Security price retrieval [again]

On 04/01/2021 22:22, David H wrote:
> Graham,
>
> My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files 
> (x86)\gnucash\bin.
>
> If they're not present have you run the "Install Online Price 
> Retrieval for GnuCash" which installs/sets up everything for Online 
> Price Retrieval to work?
>
> Cheers David H.

> Thanks David.  There are gnc-fq-xxx files in C:\Program Files 
> (x86)\gnucash\bin. [ I have run Install Online Price Retrieval for 
> GnuCash .]

I apologise for ignorance but trying to run check from cmd prompt i get:

C:\Program Files (x86)\gnucash\bin>$ gnc-fq-check

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



--
Cheerio,

Graham


--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] Security price retrieval [again]

[Graham]

Sorry - didn't realise that the images hadn't gone through.
When I try to update prices, more than half do not update, and it 
prompts me to continue with the ones that have updated. I tried 
converting the source from Morningstar GB to Yahoo-JSON but that froze 
Gnucash.



I have run gnc-fq-update and I get:  Date::Manip is up to date (6.83). 
Finance::Quote is up to date (1.49).



Not sure where I go next

--
--
Cheerio,

Graham



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Security price retrieval [again]

[David H]

Not uncommon, perhaps you should list the ones that aren't working, other
users might be able to point you in the right direction...

Cheers David H.


On Fri, 8 Jan 2021 at 03:01, Graham  wrote:

> Sorry - didn't realise that the images hadn't gone through.
> When I try to update prices, more than half do not update, and it prompts
> me to continue with the ones that have updated. I tried converting the
> source from Morningstar GB to Yahoo-JSON but that froze Gnucash.
>
>
> I have run gnc-fq-update and I get:  Date::Manip is up to date (6.83).
> Finance::Quote is up to date (1.49).
>
>
> Not sure where I go next
>
> --
> --
> Cheerio,
>
> Graham
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_4030054196922404818_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
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] Security price retrieval [again]

[Graham]

On 07/01/2021 20:06, David H wrote:
Not uncommon, perhaps you should list the ones that aren't working, 
other users might be able to point you in the right direction...


Cheers David H.


Thanks David,

All LSE:

DNE, SCF, EUDV, LGEN, GFRD, JCH, KETL, EPIC, PNN,AIRE,CTY , 
currency:eur, currency:aud plus some funds. Ive tried altering the 
source between Alphavantage US, Morningstar GB, Yahoo-JSON and Yahoo-JQL 
but the same tickers keep coming up.


Thanks for anyone who can help

--
--
Cheerio,

Graham


--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] Security price retrieval [again]

[Graham]

On 08/01/2021 10:16, Liz Dodd wrote:

On Thu, 7 Jan 2021 17:01:42 +
Graham  wrote:


Sorry - didn't realise that the images hadn't gone through.
When I try to update prices, more than half do not update, and it
prompts me to continue with the ones that have updated. I tried
converting the source from Morningstar GB to Yahoo-JSON but that
froze Gnucash.


I have run gnc-fq-update and I get:  Date::Manip is up to date
(6.83). Finance::Quote is up to date (1.49).


Not sure where I go next

Sell the shares and buy something different you can price

Stay well Dr Balin from Dr Dodd


Good advice! Maybe not the most financially astute, but an answer to the 
problem, certainly.


Stay well yourself, Dr Dodd, and keep posting -lurking enthusiastically 
-enjoying your spot diagnosis at present.


no2 could well be HSV as posited, but perhaps HZV?

--
--
Cheerio,

Graham


--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] Security price retrieval [again]

[Frank H. Ellenberger]

Am 07.01.21 um 18:01 schrieb Graham:
> Sorry - didn't realise that the images hadn't gone through.
> When I try to update prices, more than half do not update, and it
> prompts me to continue with the ones that have updated. I tried
> converting the source from Morningstar GB to Yahoo-JSON but that froze
> Gnucash.
> 
> 
> I have run gnc-fq-update and I get:  Date::Manip is up to date (6.83).
> Finance::Quote is up to date (1.49).


gnc-fq-update is *not* the program to update quotes. It updates the
software. You want to run
perl gnc-fq-dump -v  

Regards
Frank
___
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] Security price retrieval [again]

[Fred Bone]

On 09 January 2021 at 16:54, Frank H. Ellenberger said:

> Am 07.01.21 um 18:01 schrieb Graham:
> > Sorry - didn't realise that the images hadn't gone through.
> > When I try to update prices, more than half do not update, and it
[...]
> > I have run gnc-fq-update and I get:  Date::Manip is up to date (6.83).
> > Finance::Quote is up to date (1.49).
> 
> 
> gnc-fq-update is *not* the program to update quotes. It updates the
> software. You want to run
> perl gnc-fq-dump -v  

This is unhelpful. Given that he has already told us that some of his 
prices updated OK, it is obvious that he was only using *-update to check 
the status of the components.

Anyway *-dump doesn't update the prices either.

___
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] Stock price retrieval (again, sorry!)

[Steve]

Every since Yahoo shut down their service, I have not been able to get
any stock quotes. I had been running a very old version 2.6.15, I
think, so I did not try to resolve the issue but now I have updated to
3.4 and I still have the same problem.

I have checked that I have the necessary version of Perl and
gnc-fq-dump installed and I changed all my securities to retrieve
quotes using yahoo_jason. From the command line I ban get a quote:

$ gnc-fq-dump yahoo_json googl
Finance::Quote fields Gnucash uses:
symbol: googl<=== required
  date: 05/17/2019   <=== recommended
  currency: USD  <=== required
  last: 1168.78  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

but when I try from inside GNC I get the "Unknown Error" popup. Are
there any debug logs I can look at to see what is going on? Perhaps I
have too many securities? Is there a way to request just one from
inside GNC?

Thanks,
Steve
___
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: stock price retrieval not working

[D via gnucash-user]

Dino,

This is known. Apparently, Yahoo has disabled quote retrieval for many users, 
and this is true for the tool that Gnucash uses to retrieve quotes. We will all 
have to see what happens I this.

David

On November 5, 2017, at 5:37 PM, Dino Carubia via gnucash-user 
 wrote:

Installed latest version of gnucash (2.6.18).Ran "Install online price 
retrieval..."
When I try to update stock prices I get the following:"There was an unknown 
error while retrieving the price quotes."
I have tried to use the "multiple sources" option, but I still cannot get any 
prices.
If I try the command line I get the following result:C:\Program Files 
(x86)\gnucash\bin>perl gnc-fq-dump -v yahoo ibmNo results found for stock ibm.
I was last able to retrieve prices successfully on October 29th, 2017.
Any advice would be appreciated!

___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: stock price retrieval not working

[John Ralls]

> On Nov 5, 2017, at 4:31 AM, Dino Carubia via gnucash-user 
>  wrote:
> 
> Installed latest version of gnucash (2.6.18).Ran "Install online price 
> retrieval..."
> When I try to update stock prices I get the following:"There was an unknown 
> error while retrieving the price quotes."
> I have tried to use the "multiple sources" option, but I still cannot get any 
> prices.
> If I try the command line I get the following result:C:\Program Files 
> (x86)\gnucash\bin>perl gnc-fq-dump -v yahoo ibmNo results found for stock ibm.
> I was last able to retrieve prices successfully on October 29th, 2017.
> Any advice would be appreciated!

https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072702.html 
<https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072702.html> 
and following.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: GnuCash Install Online Price Retrieval

[Fross, Michael]

Hello Bob,

You're going to want to install perl.  I use activeperl from activestate,
but there are others that work.  Ensure perl.exe is in your path.  Should
happen during install, but just check.   Running 'perl -V' from the command
line should tell you if it's found.

Secondly, you'll want to run install-fq-mods.cmd in c:\program files
(x86)\gnucash\bin (or wherever you installed gnucash.)

Lastly, read the wiki about setting up online quotes.  I use yahoo-json
since yahoo no longer is working.  That may work for you or you may need to
use alphavantage depending on what you are pulling.  A search of the
mailing list will pull up a ton of info concerning that.

Best of luck.

Michael

On Tue, Jan 23, 2018 at 5:03 PM, Bob Wachtel  wrote:

> I have recently installed Gnucash with import from my previous Quicken
> files. I have not been able to find the Install Online Price Retrieval
> function to enable online stock price retrieval. I am running windows 8.1
> and do not find a "Start Menu Gnucash Group". Windows 8.1 does not seem to
> have the Start Menu function.
>
> Any help would be appreciated.
>
> --
> Bob Wachtel
> BPAB Chair
> BTPA Treasurer and Webmaster
> Home: 406-728-6398
> Cell: 406-218-1132 (text, voice)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: GnuCash Install Online Price Retrieval

[Dave H]

Hi Bob,

Yeah I think from memory Win 8.1 has a start screen instead of the start
menu - it's been awhile :-)  There are 3rd party addons out there to
restore the start menu if you want it.

How do you start gnucash without the Start Menu.  When you installed
gnucash did you also tell it to install the start / taskbar icons ?
Somewhere there with the GnuCash icon, there should also be an Install
Strawberry perl icon ?

You also can download and install it manually from
http://strawberryperl.com/releases.html

Cheers Dave H.

On 24 January 2018 at 09:03, Bob Wachtel  wrote:

> I have recently installed Gnucash with import from my previous Quicken
> files. I have not been able to find the Install Online Price Retrieval
> function to enable online stock price retrieval. I am running windows 8.1
> and do not find a "Start Menu Gnucash Group". Windows 8.1 does not seem to
> have the Start Menu function.
>
> Any help would be appreciated.
>
> --
> Bob Wachtel
> BPAB Chair
> BTPA Treasurer and Webmaster
> Home: 406-728-6398
> Cell: 406-218-1132 (text, voice)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?

David,

There’s no UI for examining the environment. I can only say that it works for 
me on MacOS 10.13 and GnuCash 2.6.19.

If you’re willing to hack a bit you could add a snippet to 
GnuCash.app/Contents/Resources/bin/gnc-fq-helper to print out the value of the 
key:

  print (“Alphavantage Key: $ENV{‘ALPHAVANTAGE_API_KEY’}\n”}

Put it down at the bottom somewhere after the #Runtime comment. You’ll have to 
run GnuCash from the command line to see that output.

Geert pushed a commit last week that keeps the Alphavantage key in preferences 
instead of the environment file so that in 3.0 one won’t have to keep resetting 
the environment file.

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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

John,

Thanks for the suggestion. I inserted the line as you indicated (at line 324 in 
my copy of gnc-fq-helper), but didn’t get any output on the command line after 
“Found Finance::Quote version 1.47”

I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
but that didn’t change anything. I also tried adding a semi-colon at the end of 
the line, without effect. Heck, I even tried putting a Hello world print 
statement, but that didn’t generate either. Either I am a bone fide idiot, or 
there is something else going on here. I’ve got my money on the first, but I 
hold out hope that it’s the second. Is it possible that I’ve latched on to the 
wrong file somehow? Or that the command isn’t going to the standard output?

David

P.S.: Should I be seeing:

/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’

at the command line? This appears at startup before the F::Q note...

> On Feb 8, 2018, at 9:33 PM, John Ralls  wrote:
> 
> 
> 
>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350  

Re: Price Retrieval Failure, Part 2

[David Reiser]

> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?
> 
> David

Depending on your holdings, I’d suggest you open every single security in the 
security editor dialog and make sure that _none_ of them are set to retrieve 
online quotes from yahoo.

Back when my investing time horizon was a few months rather than years, I 
bought and sold stocks in a total of something like 200 companies. When the 
yahoo quote retrieval apocalypse hit, it took me three trips through the list 
of 200 companies to find the last stock that was set to use yahoo as a source. 
That’s annoying when one has to open each security definition individually to 
see if it is set to retrieve quotes and from where. Hmm, time for an 
enhancement request to include online-quote-source in the security editor main 
dialog list…

Dave
--
Dave Reiser
dbrei...@icloud.com





___
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: Price Retrieval Failure, Part 2

[D via gnucash-user]

David,

Thanks, but that's not it. I have my security editor window set up so that it 
shows the quote source, so I can see at a glance that every one of the 100-plus 
securities is set to Alphavantage.

I think that tomorrow, when I have a little time, I'll create a small test file 
with one security in it, and see what happens.

Thanks,
David

On February 8, 2018, at 10:07 PM, David Reiser  wrote:


> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?
> 
> David

Depending on your holdings, I’d suggest you open every single security in the 
security editor dialog and make sure that _none_ of them are set to retrieve 
online quotes from yahoo.

Back when my investing time horizon was a few months rather than years, I 
bought and sold stocks in a total of something like 200 companies. When the 
yahoo quote retrieval apocalypse hit, it took me three trips through the list 
of 200 companies to find the last stock that was set to use yahoo as a source. 
That’s annoying when one has to open each security definition individually to 
see if it is set to retrieve quotes and from where. Hmm, time for an 
enhancement request to include online-quote-source in the security editor main 
dialog list…

Dave
--
Dave Reiser
dbrei...@icloud.com





___
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: Price Retrieval Failure, Part 2

[John Ralls]

David,

Sorry for the typos, I should have tested first. Then I would have realized 
that of course price-quotes.scm eats gnc-fq-helper’s stdout--that’s after all 
how it gets the quotes. Unfortunately it seems also to send stderr to /dev/null 
so that approach won’t work without changing price-quotes.scm.

Regards,
John Ralls

> On Feb 8, 2018, at 9:05 AM, David T.  wrote:
> 
> John,
> 
> Thanks for the suggestion. I inserted the line as you indicated (at line 324 
> in my copy of gnc-fq-helper), but didn’t get any output on the command line 
> after “Found Finance::Quote version 1.47”
> 
> I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
> two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
> but that didn’t change anything. I also tried adding a semi-colon at the end 
> of the line, without effect. Heck, I even tried putting a Hello world print 
> statement, but that didn’t generate either. Either I am a bone fide idiot, or 
> there is something else going on here. I’ve got my money on the first, but I 
> hold out hope that it’s the second. Is it possible that I’ve latched on to 
> the wrong file somehow? Or that the command isn’t going to the standard 
> output?
> 
> David
> 
> P.S.: Should I be seeing:
> 
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’
> 
> at the command line? This appears at startup before the F::Q note...
> 
>> On Feb 8, 2018, at 9:33 PM, John Ralls > <mailto:jra...@ceridwen.us>> wrote:
>> 
>> 
>> 
>>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>> mailto:gnucash-user@gnucash.org>> wrote:
>>> 
>>> In thread 
>>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>>> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html> 
>>> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>>> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>>,
>>>  I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my 
>>> Mac (OS X 10.13.3), Price retrieval was failing with the generic error: 
>>> "There was an unknown error while retrieving the price quotes.”
>>> 
>>> *** As I noted there: Finance::Quote works at the command line:
>>> 
>>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
>>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" 
>>> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterh

Re: Price Retrieval Failure, Part 2

[Geert Janssens]

David,

You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
Library/Application Support/Gnucash)

If you then start gnucash from the command line, it should print out the value 
of your API key there, together with the version of Finance::Quote that got 
installed. Unless the OS X edition doesn't print this early boot 
information...

Regards,

Geert(let ((api-key (getenv "ALPHAVANTAGE_API_KEY")))
  (if (not api-key)
  (display "ALPHAVANTAGE_API_KEY is not set\n" (current-error-port))
  (display (string-append
  "ALPHAVANTAGE_API_KEY is set to '"
   (getenv "ALPHAVANTAGE_API_KEY")
   "'\n")
   (current-error-port)
  )
  )
)
___
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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Oh, and I mentioned this in the earlier thread, but it bears repeating: the 
Security Editor window has the option to display price source. 

As with the Chart of Accounts window, there is a selector arrow on the upper 
right corner which drops down a list of user-selectable co,lumns for display. 
Source is one of these.

Cheers,
David


> On Feb 8, 2018, at 10:33 PM, D via gnucash-user  
> wrote:
> 
> David,
> 
> Thanks, but that's not it. I have my security editor window set up so that it 
> shows the quote source, so I can see at a glance that every one of the 
> 100-plus securities is set to Alphavantage.
> 
> I think that tomorrow, when I have a little time, I'll create a small test 
> file with one security in it, and see what happens.
> 
> Thanks,
> David
> 
> On February 8, 2018, at 10:07 PM, David Reiser  wrote:
> 
> 
>> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> <https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html>, 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350 <=\   
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> *** As I noted earlier: I restored the following two lines to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>> 
>> # Set AlphaVantage API Key to allow Finance::Quote to work
>> ALPHAVANTAGE_API_KEY=8SET
>> 
>> It seems to me that somehow Gnucash.app is not reading or using the 
>> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
>> somehow my environment file is not properly configured. However, I do not 
>> see any way to test these hypotheses. 
>> 
>> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
>> the Alphavantage API key is being read, and what its value currently is? Is 
>> there any other way to troublesh

Re: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Unfortunately, adding these lines to my config.user did not result in any 
further information.  I am stumped, and disappointed.


It seems that an upgrade of GnuCash not only tanks one’s customized environment 
file in the application bundle (understandable), but also any additional files 
that a user might have put into the DOT_GNUCASH_DIR folder—like, custom scheme 
reports, or a config.user file that a user might have created in vain attempts 
to get said custom reports to load into their personal installation of GnuCash. 
I find this circumstance to be rather troubling, as the files that a user has 
put into this folder should not be summarily sent to the executioner by the 
next version of the application. This is especially troubling given that the 
authorized methods for creating and using custom scheme reports (as convoluted 
and sensitive as they are) specifically directs such reports to be placed into 
this folder. If *I* were to have written a custom report for GnuCash (as 
opposed to simply copying someone else’s work to my own system) I would be 
pretty ticked off to find my work discarded this way. Thank goodness I had 
backups, but really, one shouldn’t have to restore from a backup on this.


I have now created a simple file to test out price retrieval. I put one stock 
account that uses AAPL, a cash account and Equity, and created a simple buy 
transaction (to create one price entry). For me, this file fails in the same 
way. I attach it here, so that someone else can test it. If it works for you, 
then there is something about my Mac that F::Q doesn’t like. And then I am 
really up the creek, because it’s a big operating system out there…

David



TestAlpha.gnucash
Description: Binary data


> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
> wrote:
> 
> David,
> 
> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
> Library/Application Support/Gnucash)
> 
> If you then start gnucash from the command line, it should print out the 
> value 
> of your API key there, together with the version of Finance::Quote that got 
> installed. Unless the OS X edition doesn't print this early boot 
> information...
> 
> Regards,
> 
> Geert

___
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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

In reply to my own message, in the interest of trying to run a fresh 
installation of GnuCash, I logged in to a different (new) Mac user account and 
replicated the test there. In other words, I opened GnuCash and created a 
simple file with AAPL and tried to retrieve prices. I receive the same error. 

Because GnuCash on the Mac installs the application bundle at the system level, 
the environment file there is still invoked (a check in that account confirms 
that this file is accessible in the new account), so I wonder whether there is 
something going on there that causes my problem.

I don’t know whether this is a problem, but digging through the enviroment file 
yields two variables with John’s folder structures:

GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share

These should be removed, or scrubbed to be generically valid. 

At this point, I am at a loss for how to proceed.  

I would try for a “clean slate,” but I would have thought that downloading and 
installing the newer version would have done that. Since I have been using 
GnuCash so long, and have sporadically attempted to contribute to the project, 
my machine has numerous development tools (git, SourceTree, etc.) and GnuCash 
content (gnucash-docs, gnucash-htdocs) installed; I imagine I could delete all 
of that as well, and try from there. Given how much trouble it has been for me 
to get these development technologies to work, I am loathe to take this step, 
however.

Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
when is that slated for release? Is the feature active on 2.7.4—and should I 
try using that (*he shudders*)? 

David

> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>  wrote:
> 
> Unfortunately, adding these lines to my config.user did not result in any 
> further information.  I am stumped, and disappointed.
> 
> 
> It seems that an upgrade of GnuCash not only tanks one’s customized 
> environment file in the application bundle (understandable), but also any 
> additional files that a user might have put into the DOT_GNUCASH_DIR 
> folder—like, custom scheme reports, or a config.user file that a user might 
> have created in vain attempts to get said custom reports to load into their 
> personal installation of GnuCash. I find this circumstance to be rather 
> troubling, as the files that a user has put into this folder should not be 
> summarily sent to the executioner by the next version of the application. 
> This is especially troubling given that the authorized methods for creating 
> and using custom scheme reports (as convoluted and sensitive as they are) 
> specifically directs such reports to be placed into this folder. If *I* were 
> to have written a custom report for GnuCash (as opposed to simply copying 
> someone else’s work to my own system) I would be pretty ticked off to find my 
> work discarded this way. Thank goodness I had backups, but really, one 
> shouldn’t have to restore from a backup on this.
> 
> 
> I have now created a simple file to test out price retrieval. I put one stock 
> account that uses AAPL, a cash account and Equity, and created a simple buy 
> transaction (to create one price entry). For me, this file fails in the same 
> way. I attach it here, so that someone else can test it. If it works for you, 
> then there is something about my Mac that F::Q doesn’t like. And then I am 
> really up the creek, because it’s a big operating system out there…
> 
> David
> 
> 
> 
>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>> wrote:
>> 
>> David,
>> 
>> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
>> Library/Application Support/Gnucash)
>> 
>> If you then start gnucash from the command line, it should print out the 
>> value 
>> of your API key there, together with the version of Finance::Quote that got 
>> installed. Unless the OS X edition doesn't print this early boot 
>> information...
>> 
>> Regards,
>> 
>> Geert
> 
> ___
> 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:

Re: Price Retrieval Failure, Part 2

[John Ralls]

GnuCash on the Mac doesn’t install anything. You drag the bundle to wherever 
you like, and you can have as many as you like. If you want to try a “fresh 
installation” (shouldn’t make any difference, nothing in the bundle should 
change with use) just open up the dmg and drag Gnucash.app somewhere else.

The variables in the environment file are overridden by those variables being 
set in the launcher script (Gnucash.app/Contents/MacOS/Gnucash). In 2.7.4 and 
later there is no launcher script and the code that writes the environment file 
is changed to use paths relative to {GNC_HOME}.

You’re right that GnuCash shouldn’t be overwriting files in GNC_DOT_DIR. I’ll 
have a look at that. 

Regards,
John Ralls

> On Feb 8, 2018, at 9:14 PM, David T. via gnucash-user 
>  wrote:
> 
> In reply to my own message, in the interest of trying to run a fresh 
> installation of GnuCash, I logged in to a different (new) Mac user account 
> and replicated the test there. In other words, I opened GnuCash and created a 
> simple file with AAPL and tried to retrieve prices. I receive the same error. 
> 
> Because GnuCash on the Mac installs the application bundle at the system 
> level, the environment file there is still invoked (a check in that account 
> confirms that this file is accessible in the new account), so I wonder 
> whether there is something going on there that causes my problem.
> 
> I don’t know whether this is a problem, but digging through the enviroment 
> file yields two variables with John’s folder structures:
> 
> GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
> XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share
> 
> These should be removed, or scrubbed to be generically valid. 
> 
> At this point, I am at a loss for how to proceed.  
> 
> I would try for a “clean slate,” but I would have thought that downloading 
> and installing the newer version would have done that. Since I have been 
> using GnuCash so long, and have sporadically attempted to contribute to the 
> project, my machine has numerous development tools (git, SourceTree, etc.) 
> and GnuCash content (gnucash-docs, gnucash-htdocs) installed; I imagine I 
> could delete all of that as well, and try from there. Given how much trouble 
> it has been for me to get these development technologies to work, I am loathe 
> to take this step, however.
> 
> Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
> when is that slated for release? Is the feature active on 2.7.4—and should I 
> try using that (*he shudders*)? 
> 
> David
> 
>> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Unfortunately, adding these lines to my config.user did not result in any 
>> further information.  I am stumped, and disappointed.
>> 
>> 
>> It seems that an upgrade of GnuCash not only tanks one’s customized 
>> environment file in the application bundle (understandable), but also any 
>> additional files that a user might have put into the DOT_GNUCASH_DIR 
>> folder—like, custom scheme reports, or a config.user file that a user might 
>> have created in vain attempts to get said custom reports to load into their 
>> personal installation of GnuCash. I find this circumstance to be rather 
>> troubling, as the files that a user has put into this folder should not be 
>> summarily sent to the executioner by the next version of the application. 
>> This is especially troubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they are) 
>> specifically directs such reports to be placed into this folder. If *I* were 
>> to have written a custom report for GnuCash (as opposed to simply copying 
>> someone else’s work to my own system) I would be pretty ticked off to find 
>> my work discarded this way. Thank goodness I had backups, but really, one 
>> shouldn’t have to restore from a backup on this.
>> 
>> 
>> I have now created a simple file to test out price retrieval. I put one 
>> stock account that uses AAPL, a cash account and Equity, and created a 
>> simple buy transaction (to create one price entry). For me, this file fails 
>> in the same way. I attach it here, so that someone else can test it. If it 
>> works for you, then there is something about my Mac that F::Q doesn’t like. 
>> And then I am really up the creek, because it’s a big operating system out 
>> there…
>> 
>> David
>> 
>> 
>> 
>>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>>> wrote:
>>> 
>>> David,
&

Re: Price Retrieval Failure, Part 2

[D via gnucash-user]

John,

Thank you for clarifying. I'll note that Gnucash does put stuff into 
~/Library/Application Support/Gnucash as well, so there is at least one thing 
that gets installed.

I asked this question because I am still observing several "idiosyncrasies" on 
my system that no one else seems to be experiencing (such as this retrieval 
problem and my ongoing inability to get custom reports to load). Because I am 
experiencing such problems, it suggests a problem unique to my computer, and I 
was looking for a way to ensure that I was starting with a truly clean slate.

If I delete Gnucash.app and move (or delete) ~/Library/Application 
Support/Gnucash, will that create a completely empty Gnucash environment, or is 
there another system location that needs cleaning?I

Also, is the internalized Alphavantage setting active in 2.7.4?

David

On February 9, 2018, at 8:35 PM, John Ralls  wrote:

GnuCash on the Mac doesn’t install anything. You drag the bundle to wherever 
you like, and you can have as many as you like. If you want to try a “fresh 
installation” (shouldn’t make any difference, nothing in the bundle should 
change with use) just open up the dmg and drag Gnucash.app somewhere else.

The variables in the environment file are overridden by those variables being 
set in the launcher script (Gnucash.app/Contents/MacOS/Gnucash). In 2.7.4 and 
later there is no launcher script and the code that writes the environment file 
is changed to use paths relative to {GNC_HOME}.

You’re right that GnuCash shouldn’t be overwriting files in GNC_DOT_DIR. I’ll 
have a look at that. 

Regards,
John Ralls

> On Feb 8, 2018, at 9:14 PM, David T. via gnucash-user 
>  wrote:
> 
> In reply to my own message, in the interest of trying to run a fresh 
> installation of GnuCash, I logged in to a different (new) Mac user account 
> and replicated the test there. In other words, I opened GnuCash and created a 
> simple file with AAPL and tried to retrieve prices. I receive the same error. 
> 
> Because GnuCash on the Mac installs the application bundle at the system 
> level, the environment file there is still invoked (a check in that account 
> confirms that this file is accessible in the new account), so I wonder 
> whether there is something going on there that causes my problem.
> 
> I don’t know whether this is a problem, but digging through the enviroment 
> file yields two variables with John’s folder structures:
> 
> GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
> XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share
> 
> These should be removed, or scrubbed to be generically valid. 
> 
> At this point, I am at a loss for how to proceed.  
> 
> I would try for a “clean slate,” but I would have thought that downloading 
> and installing the newer version would have done that. Since I have been 
> using GnuCash so long, and have sporadically attempted to contribute to the 
> project, my machine has numerous development tools (git, SourceTree, etc.) 
> and GnuCash content (gnucash-docs, gnucash-htdocs) installed; I imagine I 
> could delete all of that as well, and try from there. Given how much trouble 
> it has been for me to get these development technologies to work, I am loathe 
> to take this step, however.
> 
> Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
> when is that slated for release? Is the feature active on 2.7.4—and should I 
> try using that (*he shudders*)? 
> 
> David
> 
>> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Unfortunately, adding these lines to my config.user did not result in any 
>> further information.  I am stumped, and disappointed.
>> 
>> 
>> It seems that an upgrade of GnuCash not only tanks one’s customized 
>> environment file in the application bundle (understandable), but also any 
>> additional files that a user might have put into the DOT_GNUCASH_DIR 
>> folder—like, custom scheme reports, or a config.user file that a user might 
>> have created in vain attempts to get said custom reports to load into their 
>> personal installation of GnuCash. I find this circumstance to be rather 
>> troubling, as the files that a user has put into this folder should not be 
>> summarily sent to the executioner by the next version of the application. 
>> This is especially troubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they are) 
>> specifically directs such reports to be placed into this folder. If *I* were 
>> to have written a custom report for GnuCash (as opposed to simply copying 
>> someone else’s wor

Re: Price Retrieval Failure, Part 2

[D via gnucash-user]

oubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they are) 
>> specifically directs such reports to be placed into this folder. If *I* were 
>> to have written a custom report for GnuCash (as opposed to simply copying 
>> someone else’s work to my own system) I would be pretty ticked off to find 
>> my work discarded this way. Thank goodness I had backups, but really, one 
>> shouldn’t have to restore from a backup on this.
>> 
>> 
>> I have now created a simple file to test out price retrieval. I put one 
>> stock account that uses AAPL, a cash account and Equity, and created a 
>> simple buy transaction (to create one price entry). For me, this file fails 
>> in the same way. I attach it here, so that someone else can test it. If it 
>> works for you, then there is something about my Mac that F::Q doesn’t like. 
>> And then I am really up the creek, because it’s a big operating system out 
>> there…
>> 
>> David
>> 
>> 
>> 
>>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>>> wrote:
>>> 
>>> David,
>>> 
>>> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
>>> Library/Application Support/Gnucash)
>>> 
>>> If you then start gnucash from the command line, it should print out the 
>>> value 
>>> of your API key there, together with the version of Finance::Quote that got 
>>> installed. Unless the OS X edition doesn't print this early boot 
>>> information...
>>> 
>>> Regards,
>>> 
>>> Geert
>> 
>> ___
>> 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.

___
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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op vrijdag 9 februari 2018 05:40:22 CET schreef David T.:
> Unfortunately, adding these lines to my config.user did not result in any
> further information.  I am stumped, and disappointed.
> 
I tried it myself on OS X now and indeed it doesn't work as it does on linux. 
Sorry about that.

Attached you will find an adjusted version that does work on my OS X box (which 
is pretty old).

It will print a warning on the console stating either the key is not set or 
what it is set to. To find 
this message you have to open Console and search for "ALPHAVANTAGE" after you 
have started 
gnucash.

Does this reveal the requested information ?

> 
> It seems that an upgrade of GnuCash not only tanks one’s customized
> environment file in the application bundle (understandable), but also any
> additional files that a user might have put into the DOT_GNUCASH_DIR
> folder—like, custom scheme reports, or a config.user file that a user might
> have created in vain attempts to get said custom reports to load into their
> personal installation of GnuCash. I find this circumstance to be rather
> troubling, as the files that a user has put into this folder should not be
> summarily sent to the executioner by the next version of the application.
> This is especially troubling given that the authorized methods for creating
> and using custom scheme reports (as convoluted and sensitive as they are)
> specifically directs such reports to be placed into this folder. If *I*
> were to have written a custom report for GnuCash (as opposed to simply
> copying someone else’s work to my own system) I would be pretty ticked off
> to find my work discarded this way. Thank goodness I had backups, but
> really, one shouldn’t have to restore from a backup on this. 
> 

Indeed. And on linux this doesn't happen. So if this is the case on OS X, 
that's a bug.

Geert
(use-modules (gnucash main))
(let ((api-key (getenv "ALPHAVANTAGE_API_KEY")))
  (if (not api-key)
  (gnc:warn "ALPHAVANTAGE_API_KEY is not set")
  (gnc:warn (string-append
  "ALPHAVANTAGE_API_KEY is set to '"
   (getenv "ALPHAVANTAGE_API_KEY") "'")
  )
  )
)
___
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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op vrijdag 9 februari 2018 06:14:03 CET schreef David T.:
> Geert mentioned that the Alphavantage settings will be incorporated into
> 3.0; when is that slated for release? Is the feature active on 2.7.4—and
> should I try using that (*he shudders*)?
> 
Yes, 2.7.4 comes with this change, but I don't recommend to use it for 
anything but testing. We hope to release 3.0 end of March. That will depend on 
which issues will still pop up during the next weeks though.

Geert


___
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: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 9, 2018, at 9:52 PM, D  wrote:
> 
> Sorry to be replying to my own message, but it also occurs to me that, in 
> addition to Gnucash, Finance::Quote gets installed. Given that my troubles in 
> this instance are intimately linked to F::Q, what steps might I take to 
> ensure that IT gets removed as well?I
> 
> David
> 
> On February 10, 2018, at 10:49 AM, D via gnucash-user 
>  wrote:
> 
> John,
> 
> Thank you for clarifying. I'll note that Gnucash does put stuff into 
> ~/Library/Application Support/Gnucash as well, so there is at least one thing 
> that gets installed.
> 
> I asked this question because I am still observing several "idiosyncrasies" 
> on my system that no one else seems to be experiencing (such as this 
> retrieval problem and my ongoing inability to get custom reports to load). 
> Because I am experiencing such problems, it suggests a problem unique to my 
> computer, and I was looking for a way to ensure that I was starting with a 
> truly clean slate.
> 
> If I delete Gnucash.app and move (or delete) ~/Library/Application 
> Support/Gnucash, will that create a completely empty Gnucash environment, or 
> is there another system location that needs cleaning?I

David,

GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs, 
mostly to save state but also to save things like saved report configurations. 
It also writes out your data files and their associated logs to wherever you 
tell it to. Where do you draw the line for what’s “installation”?

GnuCash doesn’t install F::Q, that’s a separate, optional, step using perl’s 
cpan module. Unfortunately uninstalling modules installed with cpan isn’t easy, 
I suggest that you google “cpan uninstall” and look through the different 
approaches to find one that you’re comfortable with.

There’s one other place GnuCash stores user state: 
~/Library/Preferences/org.gnucash.Gnucash.plist, which you can simply remove or 
move aside to get a default set of preferences the next time you start GnuCash.

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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op zaterdag 10 februari 2018 16:38:58 CET schreef John Ralls:
> > On Feb 9, 2018, at 9:52 PM, D  wrote:
> > 
> > Sorry to be replying to my own message, but it also occurs to me that, in
> > addition to Gnucash, Finance::Quote gets installed. Given that my
> > troubles in this instance are intimately linked to F::Q, what steps might
> > I take to ensure that IT gets removed as well?I
> > 
> > David
> > 
> > On February 10, 2018, at 10:49 AM, D via gnucash-user
> >  wrote:
> > 
> > John,
> > 
> > Thank you for clarifying. I'll note that Gnucash does put stuff into
> > ~/Library/Application Support/Gnucash as well, so there is at least one
> > thing that gets installed.
> > 
> > I asked this question because I am still observing several
> > "idiosyncrasies" on my system that no one else seems to be experiencing
> > (such as this retrieval problem and my ongoing inability to get custom
> > reports to load). Because I am experiencing such problems, it suggests a
> > problem unique to my computer, and I was looking for a way to ensure that
> > I was starting with a truly clean slate.
> > 
> > If I delete Gnucash.app and move (or delete) ~/Library/Application
> > Support/Gnucash, will that create a completely empty Gnucash environment,
> > or is there another system location that needs cleaning?I
> David,
> 
> GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs,
> mostly to save state but also to save things like saved report
> configurations. It also writes out your data files and their associated
> logs to wherever you tell it to. Where do you draw the line for what’s
> “installation”?
> 
Warning: more technical consideration ahead!

This is probably why XDG proposes a user_data_dir and a user_config_dir. The 
former is for the application to store any user data (like window sizes and 
positions, saved reports,...), the latter should be for files such as 
config.user, log.conf and any custom reports written  by the user. Gnucash can 
do whatever with the files in the former, but should never alter anything in 
the latter.
Unfortunately the XDG specification doesn't seem to map very well to the way 
OS X handles things, where both types of data are stored in Library/
Application Support/
And also on Windows gtk maps both locations on one directory.

However in all cases it surprises me gnucash would remove config.user or files 
it didn't add there by itself from the Application Support directories. If 
this is really the case, that would need changing.

Geert


___
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: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 10, 2018, at 8:30 AM, Geert Janssens  
> wrote:
> 
> Op zaterdag 10 februari 2018 16:38:58 CET schreef John Ralls:
>>> On Feb 9, 2018, at 9:52 PM, D  wrote:
>>> 
>>> Sorry to be replying to my own message, but it also occurs to me that, in
>>> addition to Gnucash, Finance::Quote gets installed. Given that my
>>> troubles in this instance are intimately linked to F::Q, what steps might
>>> I take to ensure that IT gets removed as well?I
>>> 
>>> David
>>> 
>>> On February 10, 2018, at 10:49 AM, D via gnucash-user
>>>  wrote:
>>> 
>>> John,
>>> 
>>> Thank you for clarifying. I'll note that Gnucash does put stuff into
>>> ~/Library/Application Support/Gnucash as well, so there is at least one
>>> thing that gets installed.
>>> 
>>> I asked this question because I am still observing several
>>> "idiosyncrasies" on my system that no one else seems to be experiencing
>>> (such as this retrieval problem and my ongoing inability to get custom
>>> reports to load). Because I am experiencing such problems, it suggests a
>>> problem unique to my computer, and I was looking for a way to ensure that
>>> I was starting with a truly clean slate.
>>> 
>>> If I delete Gnucash.app and move (or delete) ~/Library/Application
>>> Support/Gnucash, will that create a completely empty Gnucash environment,
>>> or is there another system location that needs cleaning?I
>> David,
>> 
>> GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs,
>> mostly to save state but also to save things like saved report
>> configurations. It also writes out your data files and their associated
>> logs to wherever you tell it to. Where do you draw the line for what’s
>> “installation”?
>> 
> Warning: more technical consideration ahead!
> 
> This is probably why XDG proposes a user_data_dir and a user_config_dir. The 
> former is for the application to store any user data (like window sizes and 
> positions, saved reports,...), the latter should be for files such as 
> config.user, log.conf and any custom reports written  by the user. Gnucash 
> can 
> do whatever with the files in the former, but should never alter anything in 
> the latter.
> Unfortunately the XDG specification doesn't seem to map very well to the way 
> OS X handles things, where both types of data are stored in Library/
> Application Support/
> And also on Windows gtk maps both locations on one directory.
> 
> However in all cases it surprises me gnucash would remove config.user or 
> files 
> it didn't add there by itself from the Application Support directories. If 
> this is really the case, that would need changing.

If they really need to be separate, how about 
XDG_DATA_DIR=$HOME/Library/Application Support/Gnucash/User Data and 
XDG_CONFIG_DIR=$HOME/Library/Application Support/Gnucash/config?

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: Price Retrieval Failure, Part 2

[D via gnucash-user]

John,

A little patience; I am honestly grasping at straws.

Given that I consistently have troubles that others can't replicate or don't 
experience, I am looking for some way to get back to what others have. That 
means trying to figure out what has been put in, and taking it back out again, 
to get back to ground zero, as it were.

In that vein, my question had to do with files that Gnucash has put in, that I 
have not explicitly, directly asked it to create. My data files are items I 
explicitly and directly asked to be created. I know about them, and can move 
them aside on my own.

Files in ~/ Library/Application Support/Gnucash are not things I have directly 
created. Although those items are a result of my actions (like saving a 
report), I didn't directly say "Gnucash, please create a file in that hidden 
folder, and call it saved-reports-2.4 ," for example. Ditto for the preferences 
file. I appreciate the leads.

Now, to start digging in to the whole Perl problem...

David

On February 10, 2018, at 8:41 PM, John Ralls  wrote:



> On Feb 9, 2018, at 9:52 PM, D  wrote:
> 
> Sorry to be replying to my own message, but it also occurs to me that, in 
> addition to Gnucash, Finance::Quote gets installed. Given that my troubles in 
> this instance are intimately linked to F::Q, what steps might I take to 
> ensure that IT gets removed as well?I
> 
> David
> 
> On February 10, 2018, at 10:49 AM, D via gnucash-user 
>  wrote:
> 
> John,
> 
> Thank you for clarifying. I'll note that Gnucash does put stuff into 
> ~/Library/Application Support/Gnucash as well, so there is at least one thing 
> that gets installed.
> 
> I asked this question because I am still observing several "idiosyncrasies" 
> on my system that no one else seems to be experiencing (such as this 
> retrieval problem and my ongoing inability to get custom reports to load). 
> Because I am experiencing such problems, it suggests a problem unique to my 
> computer, and I was looking for a way to ensure that I was starting with a 
> truly clean slate.
> 
> If I delete Gnucash.app and move (or delete) ~/Library/Application 
> Support/Gnucash, will that create a completely empty Gnucash environment, or 
> is there another system location that needs cleaning?I

David,

GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs, 
mostly to save state but also to save things like saved report configurations. 
It also writes out your data files and their associated logs to wherever you 
tell it to. Where do you draw the line for what’s “installation”?

GnuCash doesn’t install F::Q, that’s a separate, optional, step using perl’s 
cpan module. Unfortunately uninstalling modules installed with cpan isn’t easy, 
I suggest that you google “cpan uninstall” and look through the different 
approaches to find one that you’re comfortable with.

There’s one other place GnuCash stores user state: 
~/Library/Preferences/org.gnucash.Gnucash.plist, which you can simply remove or 
move aside to get a default set of preferences the next time you start GnuCash.

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] Difficulty with online price retrieval

[Samantha Payn]

   I did post this question before but am still having the same problem.

   I have successfully used Gnucash for a couple of years for
   multicurrency invoice processing using the Strawberry perl plug in (by
   clicking on Install online price retrieval in the Gnucash section of
   the start menu) and an #Alpha Vantage access key. I use Windows 10.

   Recently I had to upgrade my hardware and since installing gnucash on
   the new machine I've not been able to make the price retrieval work.

   I have tried installing gnucash, adding the API key, and then adding
   Strawberry perl; and I have tried uninstalling everything and then
   installing gnucash, adding Strawberry perl and then adding the API key.
   No joy.

   Where am I going wrong?

   All help gratefully received.

   Thanks.
___
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] Online Price Retrieval Fails

[John Ralls]

> On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:
> 
> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
> reports DateManip could not be found; reports the following at the end.
> 
> * Run gnc-fq-helper
> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
> module) (@INC contains: C:/strawberry/perl/site/lib 
> C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper line 
> 29.
> BEGIN failed--compilation aborted at gnc-fq-helper line 29.
> An error occurred, see above.
> Press any key to continue . . .
> 
> Have know idea for the meaning of @INC, or where to put the Date::Manip 
> module.
> 
> Same fault for GnuCash version 2.6.17
> 

Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
module.

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] Online Price Retrieval Fails

[nvsoar]

On 09/05/18 17:27, John Ralls wrote:



On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:

Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
reports DateManip could not be found; reports the following at the end.

* Run gnc-fq-helper
Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
module) (@INC contains: C:/strawberry/perl/site/lib 
C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper line 
29.
BEGIN failed--compilation aborted at gnc-fq-helper line 29.
An error occurred, see above.
Press any key to continue . . .

Have know idea for the meaning of @INC, or where to put the Date::Manip module.

Same fault for GnuCash version 2.6.17


Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
module.

Regards,
John Ralls



That's what did not work.  Downloaded v2.6.21; went GnuCash menu and 
selected "Install Online Price Retrieval for GnuCash."  This action 
resulted in the message above at the end of the process. Observing the 
process running on the terminal showed a message similar to "could not 
find DateManip" part way through.


I apologize for not being clear in the initial report.

All the best,
nvsoar

___
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] Online Price Retrieval Fails

[John Ralls]

> On Sep 5, 2018, at 8:49 PM, nvsoar  wrote:
> 
> On 09/05/18 17:27, John Ralls wrote:
>> 
>>> On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:
>>> 
>>> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
>>> reports DateManip could not be found; reports the following at the end.
>>> 
>>> * Run gnc-fq-helper
>>> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
>>> module) (@INC contains: C:/strawberry/perl/site/lib 
>>> C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper 
>>> line 29.
>>> BEGIN failed--compilation aborted at gnc-fq-helper line 29.
>>> An error occurred, see above.
>>> Press any key to continue . . .
>>> 
>>> Have know idea for the meaning of @INC, or where to put the Date::Manip 
>>> module.
>>> 
>>> Same fault for GnuCash version 2.6.17
>>> 
>> Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
>> module.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
> That's what did not work.  Downloaded v2.6.21; went GnuCash menu and selected 
> "Install Online Price Retrieval for GnuCash."  This action resulted in the 
> message above at the end of the process. Observing the process running on the 
> terminal showed a message similar to "could not find DateManip" part way 
> through.
> 
> I apologize for not being clear in the initial report.

Hmm. Date::Manip is in the CPAN repository, 
https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz 
<https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz>. The 
URL has changed, though, from cpan.org to metacpan.org <http://metacpan.org/>. 
That’s just the last couple of months, I think.

Try opening a Strawberry Perl window from the Start menu and run the command
  cpan -i Date::Manip

There are likely multiple error messages and having the output in a window that 
doesn’t disappear at the end will help you see them all.

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] Online Price Retrieval Fails

[nvsoar]

On 09/06/18 07:12, John Ralls wrote:



On Sep 5, 2018, at 8:49 PM, nvsoar <mailto:nvs...@charter.net>> wrote:


On 09/05/18 17:27, John Ralls wrote:


On Sep 5, 2018, at 12:26 PM, nvsoar <mailto:nvs...@charter.net>> wrote:


Running Win 10 - Install online price retrieval (GnuCash version 
2.6.21) reports DateManip could not be found; reports the following 
at the end.


* Run gnc-fq-helper
Can't locate Date/Manip.pm in @INC (you may need to install the 
Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib 
C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at 
gnc-fq-helper line 29.

BEGIN failed--compilation aborted at gnc-fq-helper line 29.
An error occurred, see above.
Press any key to continue . . .

Have know idea for the meaning of @INC, or where to put the 
Date::Manip module.


Same fault for GnuCash version 2.6.17

Run the Online Price Retrieval Setup program. Date::Manip is a 
required perl module.


Regards,
John Ralls



That's what did not work.  Downloaded v2.6.21; went GnuCash menu and 
selected "Install Online Price Retrieval for GnuCash."  This action 
resulted in the message above at the end of the process. Observing 
the process running on the terminal showed a message similar to 
"could not find DateManip" part way through.


I apologize for not being clear in the initial report.


Hmm. Date::Manip is in the CPAN repository, 
https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz. 
The URL has changed, though, from cpan.org <http://cpan.org> to 
metacpan.org <http://metacpan.org>. That’s just the last couple of 
months, I think.


Try opening a Strawberry Perl window from the Start menu and run the 
command

  cpan -i Date::Manip

There are likely multiple error messages and having the output in a 
window that doesn’t disappear at the end will help you see them all.


Regards,
John Ralls


For info - Here are the results from the above suggestion -
-
C:\>cd strawberry

C:\strawberry> cpan -i Date::Manip
CPAN: CPAN::SQLite loaded ok (v0.203)
CPAN: LWP::UserAgent loaded ok (v6.05)
CPAN: Time::HiRes loaded ok (v1.9726)
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
CPAN: YAML::XS loaded ok (v0.41)
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Database was generated on Wed, 05 Sep 2018 03:53:51 GMT

Updating database file ...
Done!
Warning: Cannot install Date::Manip, don't know what it is.
Try the command

    i /Date::Manip/

to find objects with matching identifiers.

C:\strawberry> i /Date::Manip/
'i' is not recognized as an internal or external command,
operable program or batch file.

C:\strawberry>cpan i /Date::Manip/
CPAN: CPAN::SQLite loaded ok (v0.203)
Database was generated on Sat, 15 Sep 2018 22:32:21 GMT

Warning: Cannot install i, don't know what it is.
Try the command

    i /i/

to find objects with matching identifiers.
CPAN: Time::HiRes loaded ok (v1.9726)
Sorry, install with a regular expression is only supported when unambiguous.
Rejecting argument '/Date::Manip/'

C:\strawberry>
__


___
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] Online Price Retrieval Fails

[John Ralls]

> On Sep 15, 2018, at 3:46 PM, nvsoar  wrote:
> 
> On 09/06/18 07:12, John Ralls wrote:
>> 
>> 
>>> On Sep 5, 2018, at 8:49 PM, nvsoar >> <mailto:nvs...@charter.net>> wrote:
>>> 
>>> On 09/05/18 17:27, John Ralls wrote:
>>>> 
>>>>> On Sep 5, 2018, at 12:26 PM, nvsoar >>>> <mailto:nvs...@charter.net>> wrote:
>>>>> 
>>>>> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) 
>>>>> reports DateManip could not be found; reports the following at the end.
>>>>> 
>>>>> * Run gnc-fq-helper
>>>>> Can't locate Date/Manip.pm in @INC (you may need to install the 
>>>>> Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib 
>>>>> C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper 
>>>>> line 29.
>>>>> BEGIN failed--compilation aborted at gnc-fq-helper line 29.
>>>>> An error occurred, see above.
>>>>> Press any key to continue . . .
>>>>> 
>>>>> Have know idea for the meaning of @INC, or where to put the Date::Manip 
>>>>> module.
>>>>> 
>>>>> Same fault for GnuCash version 2.6.17
>>>>> 
>>>> Run the Online Price Retrieval Setup program. Date::Manip is a required 
>>>> perl module.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
>>>> 
>>> That's what did not work.  Downloaded v2.6.21; went GnuCash menu and 
>>> selected "Install Online Price Retrieval for GnuCash."  This action 
>>> resulted in the message above at the end of the process. Observing the 
>>> process running on the terminal showed a message similar to "could not find 
>>> DateManip" part way through.
>>> 
>>> I apologize for not being clear in the initial report.
>> 
>> Hmm. Date::Manip is in the CPAN repository, 
>> https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz. The 
>> URL has changed, though, from cpan.org <http://cpan.org> to metacpan.org 
>> <http://metacpan.org>. That’s just the last couple of months, I think.
>> 
>> Try opening a Strawberry Perl window from the Start menu and run the command
>>   cpan -i Date::Manip
>> 
>> There are likely multiple error messages and having the output in a window 
>> that doesn’t disappear at the end will help you see them all.
>> 
>> Regards,
>> John Ralls
>> 
> For info - Here are the results from the above suggestion -
> -
> C:\>cd strawberry
> 
> C:\strawberry> cpan -i Date::Manip
> CPAN: CPAN::SQLite loaded ok (v0.203)
> CPAN: LWP::UserAgent loaded ok (v6.05)
> CPAN: Time::HiRes loaded ok (v1.9726)
> Fetching with LWP:
> http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
> CPAN: YAML::XS loaded ok (v0.41)
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/03modlist.data.gz
> Database was generated on Wed, 05 Sep 2018 03:53:51 GMT
> 
> Updating database file ...
> Done!
> Warning: Cannot install Date::Manip, don't know what it is.
> Try the command
> 
> i /Date::Manip/
> 
> to find objects with matching identifiers.
> 
> C:\strawberry> i /Date::Manip/
> 'i' is not recognized as an internal or external command,
> operable program or batch file.
> 
> C:\strawberry>cpan i /Date::Manip/
> CPAN: CPAN::SQLite loaded ok (v0.203)
> Database was generated on Sat, 15 Sep 2018 22:32:21 GMT
> 
> Warning: Cannot install i, don't know what it is.
> Try the command
> 
> i /i/
> 
> to find objects with matching identifiers.
> CPAN: Time::HiRes loaded ok (v1.9726)
> Sorry, install with a regular expression is only supported when unambiguous.
> Rejecting argument '/Date::Manip/'

The instruction to try the command 'i Date::Manip' assumes that you're running 
cpan as an interactive shell. The easiest way to do that is to open Strawberry 
Perl>CPAN Client from the Start menu.

It seems that something has gotten borked with Strawberry's index. Try 
installing Date::Manip::Date instead:
  cpan -i Date::Manip::Date

That actually installs all of Date::Manip. We can only hope that Strawberry 
gets its index fixed on the next build.

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] Difficulty with online price retrieval

[Samantha Payn]

ry. Instead of bothering you guys should I try to get local help?

   Best wishes and thanks again

   Samantha

   On 27 July 2020 19:30 John Ralls < [5]jra...@ceridwen.us> wrote:

   Samantha,

   Sorry I wasn't more explicit: Yes, each command is a line on its own,
   followed by . You need to use quotes around your API key, so

   $Env:ALPHAVANTAGE_API_KEY = "[my API key]"

   I see that I left off the second quote in the perl command line, it
   should be

   perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP

   The Powershell terminal color-codes errors in red on black, variables
   and special values (e.g. $true, $false) in green, and command names in
   yellow.

   Regards,

   John Ralls

   On Jul 27, 2020, at 2:30 AM, Samantha Payn <
   [6]saman...@boorertranslations.com> wrote:

   Hi John

   I am sorry to have to come back to you for more support on this and
   thanks again for your patience.

   After some fumbling (am I right that I should type each line you have
   typed followed by the "Enter" key? I really am that much of a newb at
   this), I got an error message in red type as follows:

   [my API key] : The term '[my API key]' is not recognized as the name of
   a cmdlet, function,

   script file, or operable program. Check the spelling of the name, or if
   a path was included, verify

   that the path is correct and try again.

   At line:1 char:29

   + $Env:ALPHAVANTAGE_API_KEY = [my API key]

   + ~~~

   + CategoryInfo : ObjectNotFound: ([my API key]:String) [],
   CommandNotFoundException

   + FullyQualifiedErrorId : CommandNotFoundException

   (In the text above I have switched out my 16 digit API key for the
   words "[my API key]").

   Please also explain what the significance of green and yellow text is
   in this environment.

   Many thanks

   Samantha

   On 25 July 2020 20:04 John Ralls < [7]jra...@ceridwen.us> wrote:

   Samantha,

   Powershell (Admin) just means Powershell with admin privilege. Starting
   it will raise a User Authorization Escalation dialog box asking if
   you're sure that you want Powershell to "make changes to your device".
   You don't need it for this test, plain Powershell is fine. Yes,
   Powershell. I don't think that there is a Poweshell, please excuse my
   hasty typing.

   Since you use only those 3 currencies try all three combinations, i.e.
   USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump.

   Regards,

   John Ralls

   On Jul 25, 2020, at 10:27 AM, Samantha Payn <
   [8]saman...@boorertranslations.com> wrote:

   John, thank you for your continued support.

   Before I try this can I just clarify two points:

   I have a choice of Windows Powershell and Windows Powershell (Admin):
   which should I choose?

   And in the middle of your email I presume you mean "Powershell" (not
   Poweshell as typed)?

   Finally, in response to your question I have no securities in my
   Gnucash accounts. I am a freelance translator with a home currency of
   GBP and clients who pay me (and a very occasional purchase) in EUR and
   USD and use Gnucash for my business accounts. These are the currency
   rates I am trying to access.

   Best wishes

   Samantha

   On 25 July 2020 17:12 John Ralls < [9]jra...@ceridwen.us> wrote:

   Samantha,

   Next, some command-line testing. You can use CMD if you like, but I
   find Powershell to be a bit friendlier and easier to get to: Just
   right-click in the Start menu and it's in the middle. Once you have a
   shell, cd to C:\Program Files (x86)\gnucash\bin.

   First you'll need to set your ALPHAVANTAGE_API_KEY in the environment:

   CMD

   set ALPHAVANTAGE_API_KEY xxx...

   Poweshell

   $Env:ALPHAVANTAGE_API_KEY = xxx...

   Now test that you can retrieve an arbitrary currency pair:

   perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP

   If that works then Finance::Quote is working correctly and something
   else is going on. So far you've mentioned only currency rates, but the
   usual reason for a system error message from online price retrieval is
   trying to get a stock price from one of the dicontinued Yahoo! price
   sources. Do you have any securities in your book? If you're unsure use
   Tools>Security Editor to show a list of them.

   Regards,

   John Ralls

   On Jul 25, 2020, at 5:22 AM, Samantha Payn <
   [10]saman...@boorertranslations.com> wrote:

   Thank you for your help John.

   I have done as you instruct (including restarting Gnucash after the
   install) but there is now a different problem.

   The Gnucash about info now does show version 1.49 for Finance::Quote

   The Get Quotes button does light up, but when I click it I get an error
   window that says: "There was a system error while retrieving the price
   quotes".

   I have tried restarting

Re: [GNC] Difficulty with online price retrieval

[John Ralls]

;>>>> Powershell (Admin) just means Powershell with admin privilege. 
>>>>>>>> Starting it will raise a User Authorization Escalation dialog box 
>>>>>>>> asking if you're sure that you want Powershell to "make changes to 
>>>>>>>> your device". You don't need it for this test, plain Powershell is 
>>>>>>>> fine. Yes, Powershell. I don't think that there is a Poweshell, please 
>>>>>>>> excuse my hasty typing.
>>>>>>>> 
>>>>>>>> Since you use only those 3 currencies try all three combinations, i.e. 
>>>>>>>> USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump.
>>>>>>>> 
>>>>>>>> Regards,
>>>>>>>> John Ralls
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>>> On Jul 25, 2020, at 10:27 AM, Samantha Payn < 
>>>>>>>>> saman...@boorertranslations.com> wrote:
>>>>>>>>> 
>>>>>>>>> John, thank you for your continued support.
>>>>>>>>> Before I try this can I just clarify two points:
>>>>>>>>> I have a choice of Windows Powershell and Windows Powershell (Admin): 
>>>>>>>>> which should I choose?
>>>>>>>>> And in the middle of your email I presume you mean "Powershell" (not 
>>>>>>>>> Poweshell as typed)?
>>>>>>>>> Finally, in response to your question I have no securities in my 
>>>>>>>>> Gnucash accounts. I am a freelance translator with a home currency of 
>>>>>>>>> GBP and clients who pay me (and a very occasional purchase) in EUR 
>>>>>>>>> and USD and use Gnucash for my business accounts. These are the 
>>>>>>>>> currency rates I am trying to access.
>>>>>>>>> Best wishes
>>>>>>>>> Samantha
>>>>>>>>>> On 25 July 2020 17:12 John Ralls < jra...@ceridwen.us> wrote:
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> Samantha,
>>>>>>>>>> 
>>>>>>>>>> Next, some command-line testing. You can use CMD if you like, but I 
>>>>>>>>>> find Powershell to be a bit friendlier and easier to get to: Just 
>>>>>>>>>> right-click in the Start menu and it's in the middle. Once you have 
>>>>>>>>>> a shell, cd to C:\Program Files (x86)\gnucash\bin.
>>>>>>>>>> 
>>>>>>>>>> First you'll need to set your ALPHAVANTAGE_API_KEY in the 
>>>>>>>>>> environment:
>>>>>>>>>> CMD
>>>>>>>>>> set ALPHAVANTAGE_API_KEY xxx...
>>>>>>>>>> Poweshell
>>>>>>>>>> $Env:ALPHAVANTAGE_API_KEY = xxx...
>>>>>>>>>> 
>>>>>>>>>> Now test that you can retrieve an arbitrary currency pair:
>>>>>>>>>> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP
>>>>>>>>>> 
>>>>>>>>>> If that works then Finance::Quote is working correctly and something 
>>>>>>>>>> else is going on. So far you've mentioned only currency rates, but 
>>>>>>>>>> the usual reason for a system error message from online price 
>>>>>>>>>> retrieval is trying to get a stock price from one of the dicontinued 
>>>>>>>>>> Yahoo! price sources. Do you have any securities in your book? If 
>>>>>>>>>> you're unsure use Tools>Security Editor to show a list of them.
>>>>>>>>>> 
>>>>>>>>>> Regards,
>>>>>>>>>> John Ralls
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>>> On Jul 25, 2020, at 5:22 AM, Samantha Payn < 
>>>>>>>>>>> saman...@boorertranslations.com> wrote:
>>>>>>>>>>> 
>>>>>>>>>>> Thank you for your help John.
>>>>>

Re: [GNC] Difficulty with online price retrieval

[Samantha Payn]

 to be a bit friendlier and easier to get to: Just
   right-click in the Start menu and it's in the middle. Once you have a
   shell, cd to C:\Program Files (x86)\gnucash\bin.

   First you'll need to set your ALPHAVANTAGE_API_KEY in the environment:

   CMD

   set ALPHAVANTAGE_API_KEY xxx...

   Poweshell

   $Env:ALPHAVANTAGE_API_KEY = xxx...

   Now test that you can retrieve an arbitrary currency pair:

   perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP

   If that works then Finance::Quote is working correctly and something
   else is going on. So far you've mentioned only currency rates, but the
   usual reason for a system error message from online price retrieval is
   trying to get a stock price from one of the dicontinued Yahoo! price
   sources. Do you have any securities in your book? If you're unsure use
   Tools>Security Editor to show a list of them.

   Regards,

   John Ralls

   On Jul 25, 2020, at 5:22 AM, Samantha Payn <
   [12]saman...@boorertranslations.com> wrote:

   Thank you for your help John.

   I have done as you instruct (including restarting Gnucash after the
   install) but there is now a different problem.

   The Gnucash about info now does show version 1.49 for Finance::Quote

   The Get Quotes button does light up, but when I click it I get an error
   window that says: "There was a system error while retrieving the price
   quotes".

   I have tried restarting my computer to see if that helps but it made no
   difference.

   The last two lines of the installing text in the CPAN window, before
   the cpan prompt reappeared were *slightly* different to what you showed
   in your email. As far as I can recall they said:

   Appending installation info to C:\strawberry\perl\lib/perllocal.pod

   ECOCODE/Finance-Quote-1.49.tar.gz

   C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK

   Can you please give me guidance on what to do now?

   Very many thanks!

   Samantha

   On 24 July 2020 21:12 John Ralls < [13]jra...@ceridwen.us> wrote:

   On Jul 24, 2020, at 4:33 AM, Samantha Payn <
   [14]saman...@boorertranslations.com> wrote:

   Sorry to repeat myself but can anyone help me or shall I have to rely

   on manual input of foreign exchange rates for the foreseeable future? I

   think that Windows has put the online price retrieval somewhere where

   Gnucash cannot "see" it and I am not sufficiently computer literate to

   correct this.

   My problem is that when I go to post an invoice in a "foreign" currency

   the "fetch rate" button is greyed out so I cannot use the online

   currency rate retrieval that I used to be able to before I upgraded my

   hardware.

   After installing the current version of gnucash on my new PC, I clicked

   on "Install Online Price Retrieval" from the Gnucash list in my start

   menu and I have entered the Alfa Vantage API key in my gnucash

   preferences.

   I have checked for the presence of the perl software using the

   Troubleshooting method John Ralls directed me to and received the

   response that I should install the Finance::Quote. The only way I have

   done this in the past is by clicking on "Install Online Price

   Retrieval" from the Gnucash list in my start menu and this is what I

   have done. So I have done this again and after a run of code in the cmd

   window the final lines are:

   "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - -

   examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump

   SBECK/Date-Manip-6.82.tar.gz

   C:\STRAWB~1\c\bin\gmake.exe - -OK

   Does this mean that online price retrieval has been installed?

   When I look in the Windows list of apps installed it says I have

   installed Strawberry Perl on 3rd July (when I first tried installing it

   on my new PC).

   I am running the latest version of Gnucash and I find that in the help

   window it says

   "Version: 4.0

   Build ID: 4.0+(2020-06-27)

   Finance::Quote: -"

   Please let me know what other information you need in order to be able

   to help me. I am stepping way out of my comfort zone when I enter the

   cmd window but willing to give it a go.

   It looks like Finance::Quote is not getting installed. Try this:

   Find the Strawberry Perl group in the Start menu (windows logo at the
   bottom left of the screen). Open it and start CPAN Client. You'll get
   something that looks sort of like a CMD window. At the prompt there
   type

   install Finance::Quote

   It will probably take a while and should eventually finish with

   Appending installation info to C:\strawberry\perl\lib/perllocal.pod

   ECOCODE/Finance-Quote-1.49.tar.gz

   C:\strawberry\c\bin\dmake.exe install UNINST=1 -- OK

   If GnuCash is running restart it, after which it should report version
   1.49 for Finance::Quote and light up the Get Quot

Re: [GNC] Difficulty with online price retrieval

[John Ralls]

e explicit: Yes, each command is a line on its own, 
>>>>>>>> followed by . You need to use quotes around your API key, so
>>>>>>>> $Env:ALPHAVANTAGE_API_KEY = "[my API key]"
>>>>>>>> 
>>>>>>>> I see that I left off the second quote in the perl command line, it 
>>>>>>>> should be
>>>>>>>> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP
>>>>>>>> 
>>>>>>>> The Powershell terminal color-codes errors in red on black, variables 
>>>>>>>> and special values (e.g. $true, $false) in green, and command names in 
>>>>>>>> yellow.
>>>>>>>> 
>>>>>>>> Regards,
>>>>>>>> John Ralls
>>>>>>>> 
>>>>>>>>> On Jul 27, 2020, at 2:30 AM, Samantha Payn < 
>>>>>>>>> saman...@boorertranslations.com> wrote:
>>>>>>>>> 
>>>>>>>>> Hi John
>>>>>>>>> I am sorry to have to come back to you for more support on this and 
>>>>>>>>> thanks again for your patience.
>>>>>>>>> After some fumbling (am I right that I should type each line you have 
>>>>>>>>> typed followed by the "Enter" key? I really am that much of a newb at 
>>>>>>>>> this), I got an error message in red type as follows:
>>>>>>>>> [my API key] : The term '[my API key]' is not recognized as the name 
>>>>>>>>> of a cmdlet, function,
>>>>>>>>> script file, or operable program. Check the spelling of the name, or 
>>>>>>>>> if a path was included, verify
>>>>>>>>> that the path is correct and try again.
>>>>>>>>> At line:1 char:29
>>>>>>>>> + $Env:ALPHAVANTAGE_API_KEY = [my API key]
>>>>>>>>> + ~~~
>>>>>>>>> + CategoryInfo : ObjectNotFound: ([my API key]:String) [], 
>>>>>>>>> CommandNotFoundException
>>>>>>>>> + FullyQualifiedErrorId : CommandNotFoundException
>>>>>>>>> 
>>>>>>>>> (In the text above I have switched out my 16 digit API key for the 
>>>>>>>>> words "[my API key]").
>>>>>>>>> 
>>>>>>>>> Please also explain what the significance of green and yellow text is 
>>>>>>>>> in this environment.
>>>>>>>>> Many thanks
>>>>>>>>> Samantha
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>>> On 25 July 2020 20:04 John Ralls < jra...@ceridwen.us> wrote:
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> Samantha,
>>>>>>>>>> 
>>>>>>>>>> Powershell (Admin) just means Powershell with admin privilege. 
>>>>>>>>>> Starting it will raise a User Authorization Escalation dialog box 
>>>>>>>>>> asking if you're sure that you want Powershell to "make changes to 
>>>>>>>>>> your device". You don't need it for this test, plain Powershell is 
>>>>>>>>>> fine. Yes, Powershell. I don't think that there is a Poweshell, 
>>>>>>>>>> please excuse my hasty typing.
>>>>>>>>>> 
>>>>>>>>>> Since you use only those 3 currencies try all three combinations, 
>>>>>>>>>> i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump.
>>>>>>>>>> 
>>>>>>>>>> Regards,
>>>>>>>>>> John Ralls
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>>> On Jul 25, 2020, at 10:27 AM, Samantha Payn < 
>>>>>>>>>>> saman...@boorertranslations.com> wrote:
>>>>>>>>>>> 
>>>>>>>>>>> John, thank you for your continued support.
>>>>>>>>>>> Before I try this can I just cla

Re: [GNC] Difficulty with online price retrieval

[Samantha Payn]

ershell terminal color-codes errors in red on black, variables
   and special values (e.g. $true, $false) in green, and command names in
   yellow.

   Regards,

   John Ralls

   On Jul 27, 2020, at 2:30 AM, Samantha Payn <
   [10]saman...@boorertranslations.com> wrote:

   Hi John

   I am sorry to have to come back to you for more support on this and
   thanks again for your patience.

   After some fumbling (am I right that I should type each line you have
   typed followed by the "Enter" key? I really am that much of a newb at
   this), I got an error message in red type as follows:

   [my API key] : The term '[my API key]' is not recognized as the name of
   a cmdlet, function,

   script file, or operable program. Check the spelling of the name, or if
   a path was included, verify

   that the path is correct and try again.

   At line:1 char:29

   + $Env:ALPHAVANTAGE_API_KEY = [my API key]

   + ~~~

   + CategoryInfo : ObjectNotFound: ([my API key]:String) [],
   CommandNotFoundException

   + FullyQualifiedErrorId : CommandNotFoundException

   (In the text above I have switched out my 16 digit API key for the
   words "[my API key]").

   Please also explain what the significance of green and yellow text is
   in this environment.

   Many thanks

   Samantha

   On 25 July 2020 20:04 John Ralls < [11]jra...@ceridwen.us> wrote:

   Samantha,

   Powershell (Admin) just means Powershell with admin privilege. Starting
   it will raise a User Authorization Escalation dialog box asking if
   you're sure that you want Powershell to "make changes to your device".
   You don't need it for this test, plain Powershell is fine. Yes,
   Powershell. I don't think that there is a Poweshell, please excuse my
   hasty typing.

   Since you use only those 3 currencies try all three combinations, i.e.
   USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump.

   Regards,

   John Ralls

   On Jul 25, 2020, at 10:27 AM, Samantha Payn <
   [12]saman...@boorertranslations.com> wrote:

   John, thank you for your continued support.

   Before I try this can I just clarify two points:

   I have a choice of Windows Powershell and Windows Powershell (Admin):
   which should I choose?

   And in the middle of your email I presume you mean "Powershell" (not
   Poweshell as typed)?

   Finally, in response to your question I have no securities in my
   Gnucash accounts. I am a freelance translator with a home currency of
   GBP and clients who pay me (and a very occasional purchase) in EUR and
   USD and use Gnucash for my business accounts. These are the currency
   rates I am trying to access.

   Best wishes

   Samantha

   On 25 July 2020 17:12 John Ralls < [13]jra...@ceridwen.us> wrote:

   Samantha,

   Next, some command-line testing. You can use CMD if you like, but I
   find Powershell to be a bit friendlier and easier to get to: Just
   right-click in the Start menu and it's in the middle. Once you have a
   shell, cd to C:\Program Files (x86)\gnucash\bin.

   First you'll need to set your ALPHAVANTAGE_API_KEY in the environment:

   CMD

   set ALPHAVANTAGE_API_KEY xxx...

   Poweshell

   $Env:ALPHAVANTAGE_API_KEY = xxx...

   Now test that you can retrieve an arbitrary currency pair:

   perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP

   If that works then Finance::Quote is working correctly and something
   else is going on. So far you've mentioned only currency rates, but the
   usual reason for a system error message from online price retrieval is
   trying to get a stock price from one of the dicontinued Yahoo! price
   sources. Do you have any securities in your book? If you're unsure use
   Tools>Security Editor to show a list of them.

   Regards,

   John Ralls

   On Jul 25, 2020, at 5:22 AM, Samantha Payn <
   [14]saman...@boorertranslations.com> wrote:

   Thank you for your help John.

   I have done as you instruct (including restarting Gnucash after the
   install) but there is now a different problem.

   The Gnucash about info now does show version 1.49 for Finance::Quote

   The Get Quotes button does light up, but when I click it I get an error
   window that says: "There was a system error while retrieving the price
   quotes".

   I have tried restarting my computer to see if that helps but it made no
   difference.

   The last two lines of the installing text in the CPAN window, before
   the cpan prompt reappeared were *slightly* different to what you showed
   in your email. As far as I can recall they said:

   Appending installation info to C:\strawberry\perl\lib/perllocal.pod

   ECOCODE/Finance-Quote-1.49.tar.gz

   C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK

   Can you please give me guidance on what to do now?

   Very many thanks!

   Samantha

   On 24 July 2020 21:12 John Ralls < [15]jra...@ceridw

Re: [GNC] Difficulty with online price retrieval

[Frank H. Ellenberger]

Samanta,

Am 10.08.20 um 12:53 schrieb Samantha Payn:
>  But you lost me at the next bit.
> 
>PS C:\Users\User> Get-ChildItem -Path
>$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
>Sort-Object -Property Date
>Directory: C:\Users\User\AppData\Local\Temp
>Mode LastWriteTime Length Name
> - -- 
>-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
>-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
>-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
>-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
>-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
>-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
>-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
>-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
>-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
>-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
>-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
>-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
>PS C:\Users\User>
>Where do I substitute the most recent file name from my listing? Which
>listing?
>Awaiting further guidance and thanks again.
>Samantha

In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46

HTH
Frank
___
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] Difficulty with online price retrieval

[D. via gnucash-user]

Odd that the list isn't properly sorted...


 Original Message 
From: "Frank H. Ellenberger" 
Sent: Mon Aug 10 09:16:42 EDT 2020
To: Samantha Payn 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Difficulty with online price retrieval

Samanta,

Am 10.08.20 um 12:53 schrieb Samantha Payn:
>  But you lost me at the next bit.
> 
>PS C:\Users\User> Get-ChildItem -Path
>$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
>Sort-Object -Property Date
>Directory: C:\Users\User\AppData\Local\Temp
>Mode LastWriteTime Length Name
> - -- 
>-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
>-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
>-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
>-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
>-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
>-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
>-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
>-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
>-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
>-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
>-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
>-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
>PS C:\Users\User>
>Where do I substitute the most recent file name from my listing? Which
>listing?
>Awaiting further guidance and thanks again.
>Samantha

In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46

HTH
Frank
___
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] Difficulty with online price retrieval

[John Ralls]

> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger 
>  wrote:
> 
> Samanta,
> 
> Am 10.08.20 um 12:53 schrieb Samantha Payn:
>> But you lost me at the next bit.
>> 
>>   PS C:\Users\User> Get-ChildItem -Path
>>   $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
>>   Sort-Object -Property Date
>>   Directory: C:\Users\User\AppData\Local\Temp
>>   Mode LastWriteTime Length Name
>>    - -- 
>>   -a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
>>   -a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
>>   -a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
>>   -a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
>>   -a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
>>   -a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
>>   -a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
>>   -a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
>>   -a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
>>   -a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
>>   -a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
>>   -a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
>>   PS C:\Users\User>
>>   Where do I substitute the most recent file name from my listing? Which
>>   listing?
>>   Awaiting further guidance and thanks again.
>>   Samantha
> 
> In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
> 11:46

Samantha,

Specifically, run 
  Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log 

and paste the results into a reply.

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] Difficulty with online price retrieval

[Samantha Payn]

   Hi John

   I did what you suggest and this is what I got:

   PS C:\Users\User> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
   * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard
   * 11:46:06 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
   * 11:46:06 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)
   * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example
   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
   * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)
   * 11:46:07 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us
   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
   * 11:46:07 DEBUG  dir-files=(taxtxf)
   * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets
   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
   * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)
   * 11:46:10 DEBUG  gnc:fq-check-sources results: (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)
   * 11:46:10 MESSG  Found Finance::Quote version 1.49
   PS C:\Users\User>

   Cheers

   Samantha

   On 10 August 2020 16:37 John Ralls < [1]jra...@ceridwen.us> wrote:

   On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
   [2]frank.h.ellenber...@gmail.com> wrote:

   Samanta,

   Am 10.08.20 um 12:53 schrieb Samantha Payn:

   But you lost me at the next bit.

   PS C:\Users\User> Get-ChildItem -Path

   $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |

   Sort-Object -Property Date

   Directory: C:\Users\User\AppData\Local\Temp

   Mode LastWriteTime Length Name

    - -- 

   -a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log

   -a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log

   -a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log

   -a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log

   -a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log

   -a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log

   -a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log

   -a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log

   -a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log

   -a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log

   -a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log

   -a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log

   PS C:\Users\User>

   Where do I substitute the most recent file name from my listing? Which

   listing?

   Awaiting further guidance and thanks again.

   Samantha

   In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020

   11:46

   Samantha,

   Specifically, run

   Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   and paste the results into a reply.

   Regards,

   John Ralls

References

   1. mailto:jra...@ceridwen.us
   2. mailto:frank.h.ellenber...@gmail.com
___
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] Difficulty with online price retrieval

[John Ralls]

Good. It succeeded in finding Finance::Quote from the command line. That should 
be sufficient to enable the Fetch Rate button. Was it enabled?

Regards,
John Ralls

> On Aug 10, 2020, at 12:06 PM, Samantha Payn  
> wrote:
> 
> Hi John 
> I did what you suggest and this is what I got: 
> 
> PS C:\Users\User> Get-Content 
> $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log 
> * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard 
> * 11:46:06 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard 
> * 11:46:06 DEBUG  dir-files=(view-column trial-balance transaction 
> taxinvoice register reconcile-report receivables receipt price-scatter 
> portfolio payables owner-report new-owner-report new-aging net-charts 
> lot-viewer job-report invoice income-statement income-gst-statement 
> general-ledger general-journal equity-statement dashboard customer-summary 
> category-barchart cashflow-barchart cash-flow budget budget-income-statement 
> budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg 
> balance-sheet balance-forecast advanced-portfolio account-summary 
> account-piecharts) 
> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example 
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example 
> * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs 
> hello-world daily-reports average-balance) 
> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/locale-specific/us 
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
> * 11:46:07 DEBUG  dir-files=(taxtxf) 
> * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets 
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets 
> * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css) 
> * 11:46:10 DEBUG  gnc:fq-check-sources results: (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) 
> * 11:46:10 MESSG  Found Finance::Quote version 1.49 
> PS C:\Users\User> 
> 
> Cheers 
> Samantha 
>> On 10 August 2020 16:37 John Ralls < jra...@ceridwen.us> wrote:
>> 
>> 
>>> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger < 
>>> frank.h.ellenber...@gmail.com> wrote:
>>> 
>>> Samanta,
>>> 
>>> Am 10.08.20 um 12:53 schrieb Samantha Payn:
 But you lost me at the next bit.
 
 PS C:\Users\User> Get-ChildItem -Path
 $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
 Sort-Object -Property Date
 Directory: C:\Users\User\AppData\Local\Temp
 Mode LastWriteTime Length Name
  - -- 
 -a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
 -a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
 -a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
 -a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
 -a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
 -a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
 -a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
 -a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
 -a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
 -a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
 -a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
 -a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
 PS C:\Users\User>
 Where do I substitute the most recent file name from my listing? Which
 listing?
 Awaiting further guidance and thanks again.
 Samantha
>>> In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
>>> 11:46
>> Samantha,
>> 
>> Specifically, run
>> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
>> 
>> and paste the results into a reply.
>> 
>> 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] Difficulty with online price retrieval

[Samantha Payn]

   I'm afraid the problem has not been solved.

   The Get Quotes button does light up (as I mentioned in an email to the
   list just after I first reported the problem), but when I click it I
   get an error window that says: "There was a system error while
   retrieving the price quotes".

   Thank you for your persisitance and continued support.

   Samantha

   On 11 August 2020 00:51 John Ralls < [1]jra...@ceridwen.us> wrote:

   Good. It succeeded in finding Finance::Quote from the command line.
   That should be sufficient to enable the Fetch Rate button. Was it
   enabled?

   Regards,

   John Ralls

   On Aug 10, 2020, at 12:06 PM, Samantha Payn <
   [2]saman...@boorertranslations.com> wrote:

   Hi John

   I did what you suggest and this is what I got:

   PS C:\Users\User> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard

   * 11:46:06 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard

   * 11:46:06 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example

   * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)

   * 11:46:07 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  dir-files=(taxtxf)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets

   * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)

   * 11:46:10 DEBUG  gnc:fq-check-sources results: (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)

   * 11:46:10 MESSG  Found Finance::Quote version 1.49

   PS C:\Users\User>

   Cheers

   Samantha

   On 10 August 2020 16:37 John Ralls < [3]jra...@ceridwen.us> wrote:

   On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
   [4]frank.h.ellenber...@gmail.com> wrote:

   Samanta,

   Am 10.08.20 um 12:53 schrieb Samantha Payn:

   But you lost me at the next bit.

   PS C:\Users\User> Get-ChildItem -Path

   $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |

   Sort-Object -Property Date

   Directory: C:\Users\User\AppData\Local\Temp

   Mode LastWriteTime Length Name

    - -- 

   -a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log

   -a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log

   -a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log

   -a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log

   -a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log

   -a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log

   -a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log

   -a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log

   -a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log

   -a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log

   -a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log

   -a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log

   PS C:\Users\User>

   Where do I substitute the most recent file name from my listing? Which

   listing?

   Awaiting further guidance and thanks again.

   Samantha

   In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020

   11:46

   Samantha,

   Specifically, run

   Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   and paste the results into a reply.

   Reg

Re: [GNC] Difficulty with online price retrieval

[John Ralls]

Samantha,

Sorry, I lost that in the ensuing conversation about how to work Powershell and 
got hung up on the previous no Get Rate button issue.

The Fetch Rate and Get Quotes buttons work a bit differently from each other: 
The first looks only at the currencies involved in the transaction you're 
entering and the latter tries to retrieve rates for all of the currencies in 
your book. Can you try the Fetch Rate button? You can do that most easily by 
editing the rate on a foreign currency split. (Open a foreign currency 
transaction, put it in split view, select a split in the "other" currency, 
right-click and pick Edit Exchange Rate from the context menu. Note that which 
currency is the "other" one depends on which account you started the 
transaction from so it might be GBP if you created the transaction starting 
from an account denominated in, say, EUR.)

Please run from the PowerShell command line with the --log gnc.scm=debug option 
as before, try both a Fetch Rate and a Get Quotes and paste in the contents of 
the resulting log file.

Regards,
John Ralls

> On Aug 11, 2020, at 5:00 AM, Samantha Payn  
> wrote:
> 
> I'm afraid the problem has not been solved. 
> The Get Quotes button does light up (as I mentioned in an email to the list 
> just after I first reported the problem), but when I click it I get an error 
> window that says: "There was a system error while retrieving the price 
> quotes".
> Thank you for your persisitance and continued support. 
> Samantha 
>> On 11 August 2020 00:51 John Ralls < jra...@ceridwen.us> wrote:
>> 
>> 
>> Good. It succeeded in finding Finance::Quote from the command line. That 
>> should be sufficient to enable the Fetch Rate button. Was it enabled?
>> 
>> Regards,
>> John Ralls
>> 
>>> On Aug 10, 2020, at 12:06 PM, Samantha Payn < 
>>> saman...@boorertranslations.com> wrote:
>>> 
>>> Hi John
>>> I did what you suggest and this is what I got:
>>> 
>>> PS C:\Users\User> Get-Content 
>>> $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
>>> * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard
>>> * 11:46:06 DEBUG  mod-dir=C:\Program Files 
>>> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
>>> * 11:46:06 DEBUG  dir-files=(view-column trial-balance transaction 
>>> taxinvoice register reconcile-report receivables receipt price-scatter 
>>> portfolio payables owner-report new-owner-report new-aging net-charts 
>>> lot-viewer job-report invoice income-statement income-gst-statement 
>>> general-ledger general-journal equity-statement dashboard customer-summary 
>>> category-barchart cashflow-barchart cash-flow budget 
>>> budget-income-statement budget-flow budget-barchart budget-balance-sheet 
>>> balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio 
>>> account-summary account-piecharts)
>>> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example
>>> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
>>> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
>>> * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs 
>>> hello-world daily-reports average-balance)
>>> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/locale-specific/us
>>> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
>>> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
>>> * 11:46:07 DEBUG  dir-files=(taxtxf)
>>> * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets
>>> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
>>> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
>>> * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)
>>> * 11:46:10 DEBUG  gnc:fq-check-sources results: (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)
>>> * 11:46:10 MESSG  Found Finance::Quote version 1.49
>>> PS C:\Users\User>
>>> 
>>> Cheers
>>> Samantha
 On 10 August 2020 16:37 John Ralls < jra...@ceridwen.us> wrote:
 
 
> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger < 
> frank.h.ellenber...@gmail.com> wrote:
> 
> Samanta,
> 
> Am 10.08.20 um 12:53 schrieb Samantha Payn:
>> But you lost me at the next bit.
>> 
>> PS C:\Users\User> Get-ChildItem -Path
>> $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace

Re: [GNC] Difficulty with online price retrieval

[Samantha Payn]

   John, I am so sorry, I have slightly misled you. It is the "Fetch Rate"
   button which returns the error message. I only use Gnucash for my
   business accounts and have no need of the "Get Quotes" button.

   On 11 August 2020 18:54 John Ralls < [1]jra...@ceridwen.us> wrote:

   Samantha,

   Sorry, I lost that in the ensuing conversation about how to work
   Powershell and got hung up on the previous no Get Rate button issue.

   The Fetch Rate and Get Quotes buttons work a bit differently from each
   other: The first looks only at the currencies involved in the
   transaction you're entering and the latter tries to retrieve rates for
   all of the currencies in your book. Can you try the Fetch Rate button?
   You can do that most easily by editing the rate on a foreign currency
   split. (Open a foreign currency transaction, put it in split view,
   select a split in the "other" currency, right-click and pick Edit
   Exchange Rate from the context menu. Note that which currency is the
   "other" one depends on which account you started the transaction from
   so it might be GBP if you created the transaction starting from an
   account denominated in, say, EUR.)

   Please run from the PowerShell command line with the --log
   gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes
   and paste in the contents of the resulting log file.

   Regards,

   John Ralls

   On Aug 11, 2020, at 5:00 AM, Samantha Payn <
   [2]saman...@boorertranslations.com> wrote:

   I'm afraid the problem has not been solved.

   The Get Quotes button does light up (as I mentioned in an email to the
   list just after I first reported the problem), but when I click it I
   get an error window that says: "There was a system error while
   retrieving the price quotes".

   Thank you for your persisitance and continued support.

   Samantha

   On 11 August 2020 00:51 John Ralls < [3]jra...@ceridwen.us> wrote:

   Good. It succeeded in finding Finance::Quote from the command line.
   That should be sufficient to enable the Fetch Rate button. Was it
   enabled?

   Regards,

   John Ralls

   On Aug 10, 2020, at 12:06 PM, Samantha Payn <
   [4]saman...@boorertranslations.com> wrote:

   Hi John

   I did what you suggest and this is what I got:

   PS C:\Users\User> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard

   * 11:46:06 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard

   * 11:46:06 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example

   * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)

   * 11:46:07 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  dir-files=(taxtxf)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets

   * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)

   * 11:46:10 DEBUG  gnc:fq-check-sources results: (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)

   * 11:46:10 MESSG  Found Finance::Quote version 1.49

   PS C:\Users\User>

   Cheers

   Samantha

   On 10 August 2020 16:37 John Ralls < [5]jra...@ceridwen.us> wrote:

   On Aug 10, 2020, at 6:16 AM, Frank H. Elle

Re: [GNC] Difficulty with online price retrieval

[John Ralls]

Samantha,

OK. Please do it when running GnuCash from Powershell with the --log 
gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log.

Regards,
John Ralls


> On Aug 12, 2020, at 6:54 AM, Samantha Payn  
> wrote:
> 
> John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" 
> button which returns the error message. I only use Gnucash for my business 
> accounts and have no need of the "Get Quotes" button. 
>> On 11 August 2020 18:54 John Ralls < jra...@ceridwen.us> wrote:
>> 
>> 
>> Samantha,
>> 
>> Sorry, I lost that in the ensuing conversation about how to work Powershell 
>> and got hung up on the previous no Get Rate button issue.
>> 
>> The Fetch Rate and Get Quotes buttons work a bit differently from each 
>> other: The first looks only at the currencies involved in the transaction 
>> you're entering and the latter tries to retrieve rates for all of the 
>> currencies in your book. Can you try the Fetch Rate button? You can do that 
>> most easily by editing the rate on a foreign currency split. (Open a foreign 
>> currency transaction, put it in split view, select a split in the "other" 
>> currency, right-click and pick Edit Exchange Rate from the context menu. 
>> Note that which currency is the "other" one depends on which account you 
>> started the transaction from so it might be GBP if you created the 
>> transaction starting from an account denominated in, say, EUR.)
>> 
>> Please run from the PowerShell command line with the --log gnc.scm=debug 
>> option as before, try both a Fetch Rate and a Get Quotes and paste in the 
>> contents of the resulting log file.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Aug 11, 2020, at 5:00 AM, Samantha Payn < 
>>> saman...@boorertranslations.com> wrote:
>>> 
>>> I'm afraid the problem has not been solved.
>>> The Get Quotes button does light up (as I mentioned in an email to the list 
>>> just after I first reported the problem), but when I click it I get an 
>>> error window that says: "There was a system error while retrieving the 
>>> price quotes".
>>> Thank you for your persisitance and continued support.
>>> Samantha
 On 11 August 2020 00:51 John Ralls < jra...@ceridwen.us> wrote:
 
 
 Good. It succeeded in finding Finance::Quote from the command line. That 
 should be sufficient to enable the Fetch Rate button. Was it enabled?
 
 Regards,
 John Ralls
 
> On Aug 10, 2020, at 12:06 PM, Samantha Payn < 
> saman...@boorertranslations.com> wrote:
> 
> Hi John
> I did what you suggest and this is what I got:
> 
> PS C:\Users\User> Get-Content 
> $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
> * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard
> * 11:46:06 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
> * 11:46:06 DEBUG  dir-files=(view-column trial-balance 
> transaction taxinvoice register reconcile-report receivables receipt 
> price-scatter portfolio payables owner-report new-owner-report new-aging 
> net-charts lot-viewer job-report invoice income-statement 
> income-gst-statement general-ledger general-journal equity-statement 
> dashboard customer-summary category-barchart cashflow-barchart cash-flow 
> budget budget-income-statement budget-flow budget-barchart 
> budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet 
> balance-forecast advanced-portfolio account-summary account-piecharts)
> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
> * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs 
> hello-world daily-reports average-balance)
> * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/locale-specific/us
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
> * 11:46:07 DEBUG  dir-files=(taxtxf)
> * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets
> * 11:46:07 DEBUG  mod-dir=C:\Program Files 
> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
> * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)
> * 11:46:10 DEBUG  gnc:fq-check-sources results: (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 sixshare

Re: [GNC] Difficulty with online price retrieval

[Samantha Payn]

   I am sorry John, do what?

   I am afraid I just do not understand "Please run from the PowerShell
   command line with the --log gnc.scm=debug option as before, try both a
   Fetch Rate and a Get Quotes and paste in the contents of the resulting
   log file."

   I am such a beginner with the Powershell window stuff, all I can do is
   copy/paste what you provide. This problem has been so drawn out that we
   both lost sight of the fact that I had originally raised the issue over
   "Fetch Rates" for foreign currency transactions in my business.

   Yours apologetically

   Samantha

   On 13 August 2020 01:30 John Ralls < [1]jra...@ceridwen.us> wrote:

   Samantha,

   OK. Please do it when running GnuCash from Powershell with the --log
   gnc.scm=debug option and paste in the resulting
   gnucash.trace.XX.log.

   Regards,

   John Ralls

   On Aug 12, 2020, at 6:54 AM, Samantha Payn <
   [2]saman...@boorertranslations.com> wrote:

   John, I am so sorry, I have slightly misled you. It is the "Fetch Rate"
   button which returns the error message. I only use Gnucash for my
   business accounts and have no need of the "Get Quotes" button.

   On 11 August 2020 18:54 John Ralls < [3]jra...@ceridwen.us> wrote:

   Samantha,

   Sorry, I lost that in the ensuing conversation about how to work
   Powershell and got hung up on the previous no Get Rate button issue.

   The Fetch Rate and Get Quotes buttons work a bit differently from each
   other: The first looks only at the currencies involved in the
   transaction you're entering and the latter tries to retrieve rates for
   all of the currencies in your book. Can you try the Fetch Rate button?
   You can do that most easily by editing the rate on a foreign currency
   split. (Open a foreign currency transaction, put it in split view,
   select a split in the "other" currency, right-click and pick Edit
   Exchange Rate from the context menu. Note that which currency is the
   "other" one depends on which account you started the transaction from
   so it might be GBP if you created the transaction starting from an
   account denominated in, say, EUR.)

   Please run from the PowerShell command line with the --log
   gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes
   and paste in the contents of the resulting log file.

   Regards,

   John Ralls

   On Aug 11, 2020, at 5:00 AM, Samantha Payn <
   [4]saman...@boorertranslations.com> wrote:

   I'm afraid the problem has not been solved.

   The Get Quotes button does light up (as I mentioned in an email to the
   list just after I first reported the problem), but when I click it I
   get an error window that says: "There was a system error while
   retrieving the price quotes".

   Thank you for your persisitance and continued support.

   Samantha

   On 11 August 2020 00:51 John Ralls < [5]jra...@ceridwen.us> wrote:

   Good. It succeeded in finding Finance::Quote from the command line.
   That should be sufficient to enable the Fetch Rate button. Was it
   enabled?

   Regards,

   John Ralls

   On Aug 10, 2020, at 12:06 PM, Samantha Payn <
   [6]saman...@boorertranslations.com> wrote:

   Hi John

   I did what you suggest and this is what I got:

   PS C:\Users\User> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard

   * 11:46:06 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard

   * 11:46:06 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/reports/example

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example

   * 11:46:07 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)

   * 11:46:07 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us

   * 11:46:07 DEBUG  dir-files=(taxtxf)

   * 11:46:07 DEBUG  rpt-subdir=gnucash/report/stylesheets

   * 11:46:07 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets

   * 11:46:07 DEBUG  dir-files=(plain head-or-tail footer css)

   * 11:46:10 DEBUG  gnc:fq-check-sources results: (1.49 adig aex
   aiahk alphavantage amfiindia asegr asx aufunds australia bamosz 

Re: [GNC] Difficulty with online price retrieval

[John Ralls]

Samantha,

Run GnuCash from Powershell as you did before:
  & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug
(The last time the command was & 'C:\Program Files 
(x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that last 
command, --nofile, tells GnuCash to not open the previous data file. Last time 
I didn't need to see anything from a data file and starting GnuCash without one 
is faster. This time I do want you to have access to your data file.)

This time edit an exchange rate on an existing multi-currency transaction and 
use the Fetch Rate button to attempt to get an online quote. Dismiss the error 
dialog, cancel the edit, and quit GnuCash.

Then list the log files
  Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter 
gnucash.trace.* | Sort-Object -Property Date
figure out which is the latest one (the guidance about that is still at the 
bottom of the quoted text in this message if you've forgotten)
Display the contents
  Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
(That's the file name from last time, you'll replace VEQEP0 with whatever is in 
the latest file's name.)
And copy and paste them into a reply.

Regards,
John Ralls

> On Aug 15, 2020, at 6:42 AM, Samantha Payn  
> wrote:
> 
> I am sorry John, do what? 
> I am afraid I just do not understand "Please run from the PowerShell command 
> line with the --log gnc.scm=debug option as before, try both a Fetch Rate and 
> a Get Quotes and paste in the contents of the resulting log file." 
> I am such a beginner with the Powershell window stuff, all I can do is 
> copy/paste what you provide. This problem has been so drawn out that we both 
> lost sight of the fact that I had originally raised the issue over "Fetch 
> Rates" for foreign currency transactions in my business.
> Yours apologetically 
> Samantha 
> 
>> On 13 August 2020 01:30 John Ralls < jra...@ceridwen.us> wrote:
>> 
>> 
>> Samantha,
>> 
>> OK. Please do it when running GnuCash from Powershell with the --log 
>> gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 12, 2020, at 6:54 AM, Samantha Payn < 
>>> saman...@boorertranslations.com> wrote:
>>> 
>>> John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" 
>>> button which returns the error message. I only use Gnucash for my business 
>>> accounts and have no need of the "Get Quotes" button.
 On 11 August 2020 18:54 John Ralls < jra...@ceridwen.us> wrote:
 
 
 Samantha,
 
 Sorry, I lost that in the ensuing conversation about how to work 
 Powershell and got hung up on the previous no Get Rate button issue.
 
 The Fetch Rate and Get Quotes buttons work a bit differently from each 
 other: The first looks only at the currencies involved in the transaction 
 you're entering and the latter tries to retrieve rates for all of the 
 currencies in your book. Can you try the Fetch Rate button? You can do 
 that most easily by editing the rate on a foreign currency split. (Open a 
 foreign currency transaction, put it in split view, select a split in the 
 "other" currency, right-click and pick Edit Exchange Rate from the context 
 menu. Note that which currency is the "other" one depends on which account 
 you started the transaction from so it might be GBP if you created the 
 transaction starting from an account denominated in, say, EUR.)
 
 Please run from the PowerShell command line with the --log gnc.scm=debug 
 option as before, try both a Fetch Rate and a Get Quotes and paste in the 
 contents of the resulting log file.
 
 Regards,
 John Ralls
 
> On Aug 11, 2020, at 5:00 AM, Samantha Payn < 
> saman...@boorertranslations.com> wrote:
> 
> I'm afraid the problem has not been solved.
> The Get Quotes button does light up (as I mentioned in an email to the 
> list just after I first reported the problem), but when I click it I get 
> an error window that says: "There was a system error while retrieving the 
> price quotes".
> Thank you for your persisitance and continued support.
> Samantha
>> On 11 August 2020 00:51 John Ralls < jra...@ceridwen.us> wrote:
>> 
>> 
>> Good. It succeeded in finding Finance::Quote from the command line. That 
>> should be sufficient to enable the Fetch Rate button. Was it enabled?
>> 
>> Regards,
>> John Ralls
>> 
>>> On Aug 10, 2020, at 12:06 PM, Samantha Payn < 
>>> saman...@boorertranslations.com> wrote:
>>> 
>>> Hi John
>>> I did what you suggest and this is what I got:
>>> 
>>> PS C:\Users\User> Get-Content 
>>> $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
>>> * 11:46:06 DEBUG  rpt-subdir=gnucash/reports/standard
>>> * 11:46:06 DEBUG  mod-dir=C:\Program Files 
>>> (x86)\gnucash\share/guile/site/2.2\gnuc

Re: [GNC] Get quote - online price retrieval

[Geoff]

Ashok, I have tried to replicate your issue on a new Windows 10 installation.

You said:-
"Did the cpan Date::Manip, but that freezes at the point of the below stage.
Have to "Ctrl"+C, ugly exit."

You need to be more patient, it wasn't frozen, just having a rest!  The
complete installation process of all the necessary perl modules for price
quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
about 30 minutes on my machine, and there were a couple of significant
pauses along the way.

Once you have successfully installed Finance::Quotes and all of its
dependencies, you will be able to get a quote for your fund:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
Finance::Quote fields Gnucash uses:
symbol: 106876   <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last:  <=\
   nav: 17.6037  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 106876

stock   field  value
-   -  -
106876   currency: INR
106876   date: 08/14/2020
106876isodate: 2020-08-14
106876   link: https://www.amfiindia.com/spages/NAVAll.txt
106876 method: amfitable
106876   name: Aditya Birla Sun Life International Equity Fund -
Plan B - Growth - Regular Plan
106876nav: 17.6037
106876 source: http://www.amfiindia.com/
106876success: 1
106876 symbol: 106876


I have also attached a screenshot of getting a quote from within gnucash -
don't forget to add your AlphaVantage API key first as explained here:
https://wiki.gnucash.org/wiki/Online_Quotes


DETAILED INSTRUCTIONS
=
Windows 10 Version 1903

Download gnucash 4.1 for Windows 10 from:
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe

Verify the checksum from https://www.gnucash.org/news.phtml
We are expecting:
"836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
gnucash-4.1.setup.exe

08/17/2020  12:56 PM  ..
08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe

C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
SHA256 hash of gnucash-4.1.setup.exe:
836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
CertUtil: -hashfile command completed successfully.


Download strawberry perl from http://strawberryperl.com/
http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi

08/17/2020  01:04 PM  .
08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi

C:>perl -v
This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread

C:>cd "C:\Program Files (x86)\gnucash\bin"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Creating database file ... Done!
Running install for module 'Date::Manip'
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS
Checksum for
C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok
Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good

~~~ snip ~~~

2900 lines later it should complete successfully with:

Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm
Appending installation info to C:\Strawberry\perl\lib/perllocal.pod
  ECOCODE/Finance-Quote-1.49.tar.gz
  C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK

C:\Program Files (x86)\gnucash\bin>

Hope this helps.

Geoff
=
 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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

Re: [GNC] Difficulty with online price retrieval

[Samantha Payn]

   John, thank you for your continued patience!

   This is what I got:

   * 10:13:32 DEBUG  rpt-subdir=gnucash/reports/standard
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
   * 10:13:32 DEBUG  dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)
   * 10:13:32 DEBUG  rpt-subdir=gnucash/reports/example
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
   * 10:13:32 DEBUG  dir-files=(welcome-to-gnucash sample-graphs
   hello-world daily-reports average-balance)
   * 10:13:32 DEBUG 
   rpt-subdir=gnucash/reports/locale-specific/us
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
   * 10:13:32 DEBUG  dir-files=(taxtxf)
   * 10:13:32 DEBUG  rpt-subdir=gnucash/report/stylesheets
   * 10:13:32 DEBUG  mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
   * 10:13:32 DEBUG  dir-files=(plain head-or-tail footer css)
   * 10:13:33 DEBUG  gnc:fq-check-sources results: (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)
   * 10:13:33 MESSG  Found Finance::Quote version 1.49
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:30 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:31 DEBUG  ALPHAVANTAGE_API_KEY=7HZ0P6PV6VC2GODA
   * 10:15:31 DEBUG  handling-request: (currency USD GBP)
   * 10:15:31 DEBUG  results: #
   * 10:15:31 DEBUG  handling-request: (currency EUR GBP)
   * 10:15:31 ERROR  There was a system error while retrieving
   the price quotes.
   * 10:15:37 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.
   * 10:15:37 WARN  [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   On 15 August 2020 19:20 John Ralls < [1]jra...@ceridwen.us> wrote:

   Samantha,

   Run GnuCash from Powershell as you did before:

   & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug

   (The last time the command was & 'C:\Program Files
   (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that
   last command, --nofile, tells GnuCash to not open the previous data
   file. Last time I didn't need to see anything from a data file and
   starting GnuCash without one is faster. This time I do want you to have
   access to your data file.)

   This time edit an exchange rate on an existing multi-currency
   transaction and use the Fetch Rate button to attempt to get an online
   quote. Dismiss the error dialog, cancel the edit, and quit GnuCash.

   Then list the log files

   Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter
   gnucash.trace.* | Sort-Object -Property Date

   figure out which is the latest one (the guidance about that is still at
   the bottom of the quoted text in this message if you've forgotten)

   Display the contents

   Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   (That's the file nam

Re: [GNC] Get quote - online price retrieval

[D. via gnucash-user]

Of course, if you're using amfiindia as your price source, it's not technically 
necessary to add an AlphaVantage key, since you're not using AlphaVantage as a 
source. 


 Original Message 
From: Geoff 
Sent: Mon Aug 17 01:41:22 EDT 2020
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

Ashok, I have tried to replicate your issue on a new Windows 10 installation.

You said:-
"Did the cpan Date::Manip, but that freezes at the point of the below stage.
Have to "Ctrl"+C, ugly exit."

You need to be more patient, it wasn't frozen, just having a rest!  The
complete installation process of all the necessary perl modules for price
quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
about 30 minutes on my machine, and there were a couple of significant
pauses along the way.

Once you have successfully installed Finance::Quotes and all of its
dependencies, you will be able to get a quote for your fund:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
Finance::Quote fields Gnucash uses:
symbol: 106876   <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last:  <=\
   nav: 17.6037  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 106876

stock   field  value
-   -  -
106876   currency: INR
106876   date: 08/14/2020
106876isodate: 2020-08-14
106876   link: https://www.amfiindia.com/spages/NAVAll.txt
106876 method: amfitable
106876   name: Aditya Birla Sun Life International Equity Fund -
Plan B - Growth - Regular Plan
106876nav: 17.6037
106876 source: http://www.amfiindia.com/
106876success: 1
106876 symbol: 106876


I have also attached a screenshot of getting a quote from within gnucash -
don't forget to add your AlphaVantage API key first as explained here:
https://wiki.gnucash.org/wiki/Online_Quotes


DETAILED INSTRUCTIONS
=
Windows 10 Version 1903

Download gnucash 4.1 for Windows 10 from:
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe

Verify the checksum from https://www.gnucash.org/news.phtml
We are expecting:
"836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
gnucash-4.1.setup.exe

08/17/2020  12:56 PM  ..
08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe

C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
SHA256 hash of gnucash-4.1.setup.exe:
836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
CertUtil: -hashfile command completed successfully.


Download strawberry perl from http://strawberryperl.com/
http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi

08/17/2020  01:04 PM  .
08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi

C:>perl -v
This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread

C:>cd "C:\Program Files (x86)\gnucash\bin"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Creating database file ... Done!
Running install for module 'Date::Manip'
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS
Checksum for
C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok
Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good

~~~ snip ~~~

2900 lines later it should complete successfully with:

Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm
Appending installation info to C:\Strawberry\perl\lib/perllocal.pod
  ECOCODE/Finance-Quote-1.49.tar.gz
  C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK

C:\Program Files (x86)\gnucash\bin>

Hope this helps.

Geoff
=
<h

Re: [GNC] Get quote - online price retrieval

[D. via gnucash-user]

Ah, yes. ISTR that AlphaVantage is used for all currency conversions. 

That would suggest that users should be told that outright somewhere.


 Original Message 
From: Geoff 
Sent: Mon Aug 17 08:32:10 EDT 2020
To: "D." 
Cc: David Reiser via gnucash-user , 
gnucash-user@gnucash.org
Subject: Re: [GNC] Get quote - online price retrieval

One would think so David, but my experience was otherwise.

When running Get Quotes on a brand new default database with no 
securities defined, and then after adding just one security for this 
mutual fund, in both cases I was prompted to enter an AlphaVantage API 
key - see attached screenshots.

I believe this behaviour is because I set up the database with a 
currency code of INR, as when I do the same with USD the error message 
doesn't manifest.

Anyway, for this particular issue, the root cause was the failed 
installation of the supporting perl modules.

Have a good day.

Regards

Geoff
=

On 17/08/2020 9:00 pm, D. wrote:
> Of course, if you're using amfiindia as your price source, it's not 
> technically necessary to add an AlphaVantage key, since you're not using 
> AlphaVantage as a source.
> 
> 
>  Original Message 
> From: Geoff 
> Sent: Mon Aug 17 01:41:22 EDT 2020
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Get quote - online price retrieval
> 
> Ashok, I have tried to replicate your issue on a new Windows 10 installation.
> 
> You said:-
> "Did the cpan Date::Manip, but that freezes at the point of the below stage.
> Have to "Ctrl"+C, ugly exit."
> 
> You need to be more patient, it wasn't frozen, just having a rest!  The
> complete installation process of all the necessary perl modules for price
> quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
> about 30 minutes on my machine, and there were a couple of significant
> pauses along the way.
> 
> Once you have successfully installed Finance::Quotes and all of its
> dependencies, you will be able to get a quote for your fund:
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
> Finance::Quote fields Gnucash uses:
>  symbol: 106876   <=== required
>date: 08/14/2020   <=== recommended
>currency: INR  <=== required
>last:  <=\
> nav: 17.6037  <=== one of these
>   price:  <=/
>timezone:  <=== optional
> 
> All fields returned by Finance::Quote for stock 106876
> 
> stock   field  value
> -   -  -
> 106876   currency: INR
> 106876   date: 08/14/2020
> 106876isodate: 2020-08-14
> 106876   link: https://www.amfiindia.com/spages/NAVAll.txt
> 106876 method: amfitable
> 106876   name: Aditya Birla Sun Life International Equity Fund -
> Plan B - Growth - Regular Plan
> 106876nav: 17.6037
> 106876 source: http://www.amfiindia.com/
> 106876success: 1
> 106876 symbol: 106876
> 
> 
> I have also attached a screenshot of getting a quote from within gnucash -
> don't forget to add your AlphaVantage API key first as explained here:
> https://wiki.gnucash.org/wiki/Online_Quotes
> 
> 
> DETAILED INSTRUCTIONS
> =
> Windows 10 Version 1903
> 
> Download gnucash 4.1 for Windows 10 from:
> https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe
> 
> Verify the checksum from https://www.gnucash.org/news.phtml
> We are expecting:
> "836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
> gnucash-4.1.setup.exe
> 
> 08/17/2020  12:56 PM  ..
> 08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe
> 
> C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
> SHA256 hash of gnucash-4.1.setup.exe:
> 836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
> CertUtil: -hashfile command completed successfully.
> 
> 
> Download strawberry perl from http://strawberryperl.com/
> http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi
> 
> 08/17/2020  01:04 PM  .
> 08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi
> 
> C:>perl -v
> This is perl 5, version 30, subversion 2 (v5.30.2) built for
> MSWin32-x64-multi-thread
> 
> C:>cd "C:\Program Files (x86)\gnucash\bin"
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
> 
> You need to install the following Perl modules:
>Finance::Quote
> 
> Use your system's package manager