Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

2024-05-10 Thread Kalpesh Patel
That was it. Rounding down to 9 decimal places works. Thank you! -Original Message- From: John Ralls Sent: Wednesday, May 08, 2024 10:13 PM To: Kalpesh Patel Cc: GnuCash User Subject: Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02) Kalpesh, I think your

Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

2024-05-08 Thread John Ralls
Kalpesh, I think your price has too many digits. Try rounding it to 10E-9. Regards, John Ralls > On May 8, 2024, at 09:05, Kalpesh Patel wrote: > > Hi GNC User community - > > > > I am developing a second F::Q module of my own. The first one works fine but > seco

[GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

2024-05-08 Thread Kalpesh Patel
Hi GNC User community - I am developing a second F::Q module of my own. The first one works fine but second one seems to NOT want to work no matter what. I am in middle of debugging it and it has stomped me why not so hoping someone might be able to help me zero in where I am falling sort

[GNC] F::Q Dependencies list

2024-04-20 Thread Kalpesh Patel
In case you are interested in seeing what packages are needed for F::Q, go to this site.. https://cpandeps.grinnz.com/?dist=Finance-Quote <https://cpandeps.grinnz.com/?dist=Finance-Quote_version==runtime _version=v5.38.2=table> _version==runtime_version=v5.38.2

[GNC] F::Q CLI issue with GNC 5.6-1 on Win 11

2024-04-19 Thread gnucash
When using GNC 5.4 on Windows 11, F::Q 1.59 & 1.60 work perfectly (except for the quote source issues resolved with 1.6). When upgrade to GNC 5.6-1 neither F::Q 1.59 nor 1.6 CLI works, error message indicates unable to find data file. Note that using the Get Quotes button in the P

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Geoff
Monteleone wrote: I'm pretty sure the answer to that is yes, as I seem to recall this question in the distant past, but things may have changed since then. Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Adrien Monteleone
Indeed yes, see the GnuCash Manual §8.6 Price Editor: https://lists.gnucash.org/docs/C/gnucash-manual/tool-price.html Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Adrien Monteleone
I'm pretty sure the answer to that is yes, as I seem to recall this question in the distant past, but things may have changed since then. Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct

[GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Kalpesh Patel
Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is currently designed to consume only one quote for one or more security per firing to update it? ___ gnucash-user mailing list gnucash-user

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-12 Thread Adrien Monteleone
Thanks. I'm not sure I want to get that deep into it. Yes, they were created as 'currencies' and can't be changed. I'll just manually enter prices periodically. It is only two of them. Regards, Adrien On 10/12/23 8:55 PM, Ken Farley wrote: My guess would be that it's because they were created

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-12 Thread Ken Farley
My guess would be that it's because they were created as a "currency" and can't be changed? I don't use any currencies as investments, so I don't have any experience with this kind of thing. If there is a way you can specify the source of the quotes (i.e. not Alphavantage), you could take the

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Adrien Monteleone
. It looks like I'll just wait until if/when F::Q changes back their Alphavantage call to include PMs. Regards, Adrien On 10/5/23 3:53 PM, Ken Farley wrote: Oh I don't think you have to do anything terribly complicated. I've had mutual funds change their trading symbols in the past

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Ken Farley
Oh I don't think you have to do anything terribly complicated. I've had mutual funds change their trading symbols in the past, and it was as simple as editing the security via Tools-> Security Editor Changing all the perinent information for the affected securities. Gnucash uses that info,

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Adrien Monteleone
Thanks Ken, I was able to add those two in a 'Precious Metals' namespace, that indeed works. But now how to integrate that with my existing XAU/XAG denominated accounts? I'm guessing I'll have to make new ones with those symbols for commodity, then delete the old accounts and let GnuCash move

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-04 Thread Ken Farley
Yahoo seems to use "GC=F" as the symbol for Gold. I am able to get the price of gold as shown in the following output from gnc-fq-dump --> gnc-fq-dump yahoo_json GC=F Finance::Quote fields Gnucash uses:     symbol: GC=F <=== required   date: 10/04/2023   <===

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-02 Thread Adrien Monteleone
Hmm... Seems that as of F::Q 1.53, Alphavantage mucked with getting CURRENCY_EXCHANGE_RATE with the free API, so F::Q switched to a FX_DAILY request that doesn't include Crypto or Precious Metals, but there is a note (in the Github Issues) that Aphavantage then reversed their decision so now

[GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-02 Thread Adrien Monteleone
This has been on my back burner for some time, but I decided to tackle it for a spell tonight. I haven't been able to retrieve an XAG quote since June 2020, and an XAU quote since December 2020. I've updated F::Q, and tried running GnuCash with debug logging, but can't seem to find anything

Re: [GNC] loading custom F::Q module from GNC

2023-08-23 Thread jackielou wong
> Sent: Wednesday, August 23, 2023 4:24 PM > To: 'Murugan Muruganandam' ; > gnucash-user@gnucash.org > Subject: RE: [GNC] loading custom F::Q module from GNC > > > Hi Murugan – > > > > I am using those steps currently (which you had outlined for me while > back)

Re: [GNC] loading custom F::Q module from GNC

2023-08-23 Thread Murugan Muruganandam
From: Kalpesh Patel Sent: Wednesday, August 23, 2023 4:24 PM To: 'Murugan Muruganandam' ; gnucash-user@gnucash.org Subject: RE: [GNC] loading custom F::Q module from GNC Hi Murugan – I am using those steps currently (which you had outlined for me while back) and they work

Re: [GNC] loading custom F::Q module from GNC

2023-08-23 Thread Kalpesh Patel
Hi Murugan – I am using those steps currently (which you had outlined for me while back) and they work perfectly. I am trying to avoid altering the install of F::Q in anyway if it was possible by wiring up in GNC that can pass the info to F::Q thus doing away with needing to update C

Re: [GNC] loading custom F::Q module from GNC

2023-08-23 Thread Murugan Muruganandam
ve to redo this step one time Saludos Cordiales Murugan From: gnucash-user on behalf of Kalpesh Patel Sent: Wednesday, August 23, 2023 1:21 PM To: gnucash-user@gnucash.org Subject: [GNC] loading custom F::Q module from GNC Is there a simpler way, by way o

[GNC] loading custom F::Q module from GNC

2023-08-23 Thread Kalpesh Patel
Is there a simpler way, by way of possibly configuration specification, from GNC to utilize a privately developed F::Q module for pricing without modifying any of the official underlying release code for F::Q? >From reading F::Q documentation, it mentions that I can pass the privat

Re: [GNC] Update F::Q in flatpak GC?

2023-08-22 Thread rsbrux via gnucash-user
-out sources confusing ;-) On 21.08.23 22:56, john wrote: The list of sources in the Security Edit dialog is hard coded and not often updated. Entries are grayed out if the item isn't found in the list of sources retrieved from F::Q at start up, which at preset is a lot of them. Sources

Re: [GNC] Update F::Q in flatpak GC?

2023-08-21 Thread john
The list of sources in the Security Edit dialog is hard coded and not often updated. Entries are grayed out if the item isn't found in the list of sources retrieved from F::Q at start up, which at preset is a lot of them. Sources that are in the F::Q list but don't have a hardcoded entry get

Re: [GNC] Update F::Q in flatpak GC?

2023-08-21 Thread rsbrux via gnucash-user
Still one problem (perhaps better handled on the F::Q mailing list): My main reason for wanting to update F::Q is that I saw that SIX.pm had been updated. However, in GC (flatpak) 5.3+ with the updates to the PM scripts mentioned below, the Securities Editor still shows the obsolete SIXfunds

Re: [GNC] Update F::Q in flatpak GC?

2023-08-18 Thread rsbrux via gnucash-user
Spot on! Deleted the two lines, now working as expected. Many thanks! -Original Message- From: John Ralls Sent: Thursday, August 17, 2023 11:23 PM To: rsbrux Subject: Re: [GNC] Update F::Q in flatpak GC? I meant go back to the 1.56 version of IndiaMutual.pm, leaving everything else

Re: [GNC] Update F::Q in flatpak GC?

2023-08-17 Thread rsbrux via gnucash-user
::String ([1]https://metacpan.org/pod/IO::String) as of F::Q 1.57. That dependency is in the nightlies but not the release flatpak. It's pure perl and has no dependencies so you have a couple of ways forward: * Get the source code (there are links in the sidebar on the left

Re: [GNC] Update F::Q in flatpak GC?

2023-08-17 Thread john
IndiaMutual.pm has a new perl dependency IO::String (https://metacpan.org/pod/IO::String) as of F::Q 1.57. That dependency is in the nightlies but not the release flatpak. It's pure perl and has no dependencies so you have a couple of ways forward: * Get the source code (there are links

Re: [GNC] Update F::Q in flatpak GC?

2023-08-17 Thread rsbrux via gnucash-user
Aug 14, 2023, at 04:33, rsbrux via gnucash-user wrote: I am running GC 5.3+ as a flatpak under Ubuntu Studio 22.04 LTS. The included F::Q version is 1..56, which I have modified with the Yahoo as JSON patch already published to this mailing list. However, it looks as though the current F::Q re

Re: [GNC] Update F::Q in flatpak GC?

2023-08-15 Thread john
1.58 release code or the current development >>> version? If the latter, where should I be looking for the release? >>> >>> On 14.08.23 18:58, john wrote: >>>> >>>>> On Aug 14, 2023, at 04:33, rsbrux via gnucash-user >>>>> wr

Re: [GNC] Update F::Q in flatpak GC?

2023-08-15 Thread rsbrux via gnucash-user
8:58, john wrote: On Aug 14, 2023, at 04:33, rsbrux via gnucash-user wrote: I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS. The included F::Q version is 1..56, which I have modified with the Yahoo as JSON patch already published to this mailing list. However, it looks

Re: [GNC] Update F::Q in flatpak GC?

2023-08-15 Thread rsbrux via gnucash-user
. The included F::Q version is 1..56, which I have modified with the Yahoo as JSON patch already published to this mailing list. However, it looks as though the current F::Q release, 1.58, includes quite a few fixes for various sources. The last I heard,  it wasn't possible to update F::Q within

Re: [GNC] Update F::Q in flatpak GC?

2023-08-15 Thread rsbrux via gnucash-user
? On 14.08.23 18:58, john wrote: On Aug 14, 2023, at 04:33, rsbrux via gnucash-user wrote: I am running GC 5.3+ as a flatpak under Ubuntu Studio 22.04 LTS. The included F::Q version is 1..56, which I have modified with the Yahoo as JSON patch already published to this mailing list. However

Re: [GNC] Update F::Q in flatpak GC?

2023-08-14 Thread john
> On Aug 14, 2023, at 04:33, rsbrux via gnucash-user > wrote: > > I am running GC 5.3+ as a flatpak under Ubuntu Studio 22.04 LTS. > > The included F::Q version is 1..56, which I have modified with the Yahoo as > JSON patch already published to this mailing list. &

[GNC] Update F::Q in flatpak GC?

2023-08-14 Thread rsbrux via gnucash-user
I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS. The included F::Q version is 1..56, which I have modified with the Yahoo as JSON patch already published to this mailing list. However, it looks as though the current F::Q release, 1.58, includes quite a few fixes for various

[GNC] Strawberry Perl 5.38 breaks F::Q (with workaround)

2023-08-13 Thread byemail
Hello, I use winget to automatically update apps on my Windows devices. Last week, winget automatically updated Strawberry Perl from 5.32 to 5.38. In doing so, it broke F::Q in Gnucash. (broke=greyed out button in Tools->Price Database). When I tried reinstalling F::Q it failed while mak

Re: [GNC] F::Q Currency Issues

2022-08-16 Thread WR D
r On Behalf Of Jim DeLaHunt Sent: Tuesday, 16 August 2022 1:52 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] F::Q Currency Issues On 2022-08-15 17:48, Bruce Schuck wrote: > Hello everyone, > > As I am now the F::Q team member with CPAN/Pause upload priv, please > have patience.

Re: [GNC] F::Q Currency Issues

2022-08-15 Thread Jim DeLaHunt
On 2022-08-15 17:48, Bruce Schuck wrote: Hello everyone, As I am now the F::Q team member with CPAN/Pause upload priv, please have patience. I had to unexpectedly travel out of state for a family matter. I am not sure how long I will be away, but it will be at least a few days before I have

[GNC] F::Q Currency Issues

2022-08-15 Thread Bruce Schuck
Hello everyone, As I am now the F::Q team member with CPAN/Pause upload priv, please have patience. I had to unexpectedly travel out of state for a family matter. I am not sure how long I will be away, but it will be at least a few days before I have time to review and merge the pull request

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
Thanks very much, Frank. I didn't quite understand the difference between gnc-fq-dump and gnc-fq-helper. My data retrieval method name contained digits and gnc-fq-helper did not allow them. I changed the method name to contain letters only and it works fine now. Best,Derek  On Monday,

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Frank H. Ellenberger
Hello Derek, Am Mo., 18. Nov. 2019 um 17:28 Uhr schrieb Derek Robinson via gnucash-user : > > Apologies - I don't know why the linebreaks didn't work in my last message. > Please disregard that (unreadable) version. Tip: To avoid reformatting of source file send them as attachments instead of

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
inson via gnucash-user wrote: Apologies - I don't know why the linebreaks didn't work in my last message. Please disregard that (unreadable) version. New to the list - please direct me to previous posts if I've missed something that will explain what's happening. I wrote a custom F::Q m

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
will explain what's happening. I wrote a custom F::Q module to extract daily "prices" from Vanguard 529 plan portfolios that are not traded on exchanges. I believe I've done that correctly. When I run gnc-fq-dump, I get return values that make sense and appear to be the same returns

[GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
Apologies - I don't know why the linebreaks didn't work in my last message. Please disregard that (unreadable) version. New to the list - please direct me to previous posts if I've missed something that will explain what's happening. I wrote a custom F::Q module to extract daily "prices&

[GNC] Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
New to the list - please direct me to previous posts if I've missed something that will explain what's happening. I wrote a custom F::Q module to extract daily "prices" from Vanguard 529 plan portfolios that are not traded on exchanges. I believe I've done that correctly. When I run g

[GNC] F::Q -Quote Source Information Inactive

2019-10-28 Thread J Michael Boling via gnucash-user
I’ma new user to Linux Mint 19.2, 4.15.0-55-generic trying to installGnuCash 3.7+ withFinance::Quote (F::Q). Iused Software Manager to install. [Apparentlythe same as sudoapt install flatpak | flatpak install flathub org.gnucash.GnuCash.] I then ranthe gnc-fq-update command to installedF::Q

Re: [GNC] Next release of F::Q

2018-10-30 Thread Eric Coates
wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018 Hello all, I'm on some extended vacation and will be back home next week. My intent is to release F::Q from master at the end of this month. The alphavantage module has undergone some modifications which should make it more re

Re: [GNC] Next release of F::Q

2018-09-10 Thread Chris Good
e next week. My intent is to release F::Q from master at the end of this month. The alphavantage module has undergone some modifications which should make it more reliable since we can now tell the module at which speed it can question the alphavantage API. Before releasing F::Q, I woul

Re: [GNC] Next release of F::Q

2018-08-19 Thread Erik Colson
brad writes: > My version of AlphaVantage.pm in > /usr/local/share/perl/5.26.1/Finance/Quote/AlphaVantage.pm has no > maxQueries variable. I just ran gnc-fq-update. Do we need to get the > latest from github? Hello Brad, You need to get the whole F::Q from github master b

Re: [GNC] Next release of F::Q

2018-08-16 Thread brad
and will be back home next week. My intent is to release F::Q from master at the end of this month. The alphavantage module has undergone some modifications which should make it more reliable since we can now tell the module at which speed it can question the alphavantage API. Before releasing F::Q, I would

[GNC] Next release of F::Q

2018-08-16 Thread Erik Colson
Hello all, I'm on some extended vacation and will be back home next week. My intent is to release F::Q from master at the end of this month. The alphavantage module has undergone some modifications which should make it more reliable since we can now tell the module at which speed it can

Re: [GNC] Installing F::Q on Ubuntu

2018-08-15 Thread David T. via gnucash-user
> But I am currently not able to get price quotes in the linux version of > gnucash either. I get the error, Unable to retrieve quotes for these items, > then a list of all my securities. > > Here's what I did to install F::Q. Am I missing something? > > cpan > install Fi

[GNC] Installing F::Q on Ubuntu

2018-08-15 Thread Tim Kallmer
securities. Here's what I did to install F::Q. Am I missing something? cpan install Finance::Quote quit edited /usr/share/perl5/Finance/Quote/AlphaVantage.pm entered my key between the quotes in the line that previously read, my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'}; sudo chmod 666

Re: Re: F::Q changes

2017-11-23 Thread uhopfer@gmail
Liz, I just saw that you have wiki privileges and was asking for corrections. Here is a small one that I had sent to the user list,but  has not been implemented.

Error - possibly caused by incorrect F::Q update

2017-11-20 Thread Eric Coates
GnuCash 2.6.17 on Ubuntu 16.04. Like many others I found that Finance::Quote was failing. Following advice from this forum I updated F::Q to version 1.45 by running sudo gnc-fq-update but did not try to update any stock prices (I only do this once a month). Shortly afterwards it became apparent

F::Q

2017-11-13 Thread Les
I attempted to download quotes today (the first opportunity since adding Alphavantage as source). My Mac died in progress with a message of unknown error.  My Linux Mint 18.2 just stopped without completing (no message). However, my 2 ASX stocks ended up being priced in USD which resulted in

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread listreader
On Sun, 12 Nov 2017 21:27:47 -0600 listreader <susel...@cableone.net> wrote: > > >> me "0.0200". Should I NOT be using alphavantage for the currency > > >> quotes in gc? > > > > > > I have no idea. I don't know how gnucash actuall

Re: F::Q changes

2017-11-12 Thread Dale Alspach
...@billiau.net> wrote: >>> >>> I've put a small piece on the FAQ about this, with the intention that >>> the information gets picked up by the search engines. >>> I don't actually use F::Q, so could someone with wiki edit privileges >>> who u

Re: F::Q changes

2017-11-12 Thread nvsoar
On 11/12/17 18:02, David Carlson wrote: I cannot find Finance::Quote on my Ubuntu 16.04 computer that has GnuCash 6.12 installed. How can I update it? I have tried using Synaptic and even searching with files. David C snip Try GetDeb to update -

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread listreader
> >> me "0.0200". Should I NOT be using alphavantage for the currency > >> quotes in gc? > > > > I have no idea. I don't know how gnucash actually gets the quote > > for currencies from F::Q. It might i.e. use another method... > > Mayb

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
gain, because there is no effort without error and > shortcoming" -Theodore Roosevelt > > On Sun, Nov 12, 2017 at 8:46 PM, D <sunfis...@yahoo.com> wrote: > >> For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45. >> >> David >> &

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread D via gnucash-user
eodore Roosevelt On Sun, Nov 12, 2017 at 8:46 PM, D <sunfis...@yahoo.com> wrote: For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45. David On November 13, 2017, at 3:15 AM, Erik Colson <e...@ecocode.net> wrote: Greg Etling <g...@gregetling.com> wri

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread D via gnucash-user
For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45. David On November 13, 2017, at 3:15 AM, Erik Colson <e...@ecocode.net> wrote: Greg Etling <g...@gregetling.com> writes: > I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at > al

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread Erik Colson
y) > but "gnc-fq-dump alphavantage XAG" still gives me "0.0200". Should I > NOT be using alphavantage for the currency quotes in gc? I have no idea. I don't know how gnucash actually gets the quote for currencies from F::Q. It might i.e. use another method... May

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread listreader
7 <=== recommended > > currency: USD <=== required > > last: 6.5100 <=\ > > From the F::Q Examples I get following data: > and for XAG > ~/DEVELOPMENT/finance-quote >>> perl -Ilib > Examples/currency-lookup.pl XAG U

Re: F::Q changes

2017-11-12 Thread John Ralls
> On Nov 12, 2017, at 1:57 PM, Liz <ed...@billiau.net> wrote: > > I've put a small piece on the FAQ about this, with the intention that > the information gets picked up by the search engines. > I don't actually use F::Q, so could someone with wiki edit privileges >

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
now I'll just have to leave this broken. Thanks anyway. It is indeed a wrong idea to mess with system Perl. You should however install your own Perl with brew or another tool like that. Meantime, I'll try F::Q with perl v5.18 on a test system to see if I can figure this out. b

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at all possible as I've already had to blow away one profile over the years due to too much tinkering with perl. I'll take it under consideration, but for now I'll just have to leave this broken. Thanks anyway. Greg

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
Greg Etling writes: > Lots of output follows, most tests failed: hmmm... I'm out of ideas for now. Your Perl is pretty old. Although it should be working AFAIK, would you mind upgrading to a recent version ? best -- erik colson

F::Q changes

2017-11-12 Thread Liz
I've put a small piece on the FAQ about this, with the intention that the information gets picked up by the search engines. I don't actually use F::Q, so could someone with wiki edit privileges who understands what has and is happening enlarge on this - perhaps a wiki page linked to the FAQ

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread Erik Colson
gt;> > quotes work fine for me but I am not getting how to get precious >> > metals quotes to work through the gnucash frontend. I think I've >> > tried every possible combo of settings in gnucash. Is this >> > available yet? >> >> please check F::Q ver

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
Greg Etling writes: >> perl -MFinance::Quote -e 'print $Finance::Quote::VERSION' >> > > 1.47 > > >> and >> >> perl -v >> > > This is perl 5, version 18, subversion 2 (v5.18.2) built for > darwin-thread-multi-2level > (with 2 registered patches, see perl -V for more

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
On Sun, Nov 12, 2017 at 4:05 PM, Erik Colson wrote: > > Greg Etling writes: > > > Same result when I cd into that directory and run as either: > > perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl > > alphavantage SCHB > > or > >

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
Greg Etling writes: > Same result when I cd into that directory and run as either: > perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl > alphavantage SCHB > or > perl -Ilib Examples/stockdump.pl alphavantage SCHB Well, that is weird... Can you send

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread listreader
; > metals quotes to work through the gnucash frontend. I think I've > > tried every possible combo of settings in gnucash. Is this > > available yet? > > please check F::Q version 1.47 (untested). Hello Erik. 1.47 - No errors but returns the wrong price data, i.e. for g

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
ommand line, I have tried running changing directories to /Applications/Gnucash.app . >>> >>> >>> On 11/12/2017 07:30 AM, David T. wrote: >>>> My question to both Les and Robert is *which* environment file have you updated? ~/.bash_profile, or /Ap

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
On Sun, Nov 12, 2017 at 1:58 PM, Erik Colson wrote: > > Greg Etling writes: > > > #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump. > pl > > alphavantage SCHB > > you need to run this command from the directory >

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
Greg Etling writes: > #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl > alphavantage SCHB you need to run this command from the directory ~/.cpan/build/Finance-Quote-1.47-IUv7sO otherwise the -Ilib won't use the correct library best -- erik

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
t; malformed JSON string, neither array, object, number, string or atom, at > > character offset 0 (before "Can't connect to www...") at > > /Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138. > > > > For reference, line 138: > > my $json_data = JSON::decode_

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Erik Colson
; my $json_data = JSON::decode_json $body; The page returned by alphavantage is sometimes empty. On my system the SCHB works correctly from F::Q. ~/DEVELOPMENT/finance-

F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
/Resources/etc/gnucash/environment. Prior to Yahoo deactivation, F::Q worked fine for me. Software: OSX Sierra 10.12.6, Finance::Quote 1.45, Gnucash 2.6.18 Commands: export ALPHAVANTAGE_API_KEY=XXX... perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage SCHB.US Note

F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread Greg Etling
/Contents/Resources/etc/gnucash/environment. Prior to Yahoo deactivation, F::Q worked fine for me. Software: OSX Sierra 10.12.6, Finance::Quote 1.45, Gnucash 2.6.18 Commands: export ALPHAVANTAGE_API_KEY=XXX... perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage SCHB.US Note

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread D via gnucash-user
t;>> As for command line, I have tried running changing directories to >>> /Applications/Gnucash.app . >>> >>> >>> On 11/12/2017 07:30 AM, David T. wrote: >>>> My question to both Les and Robert is *which* environment file have y

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
Ok, that works.  Thanks!! On 11/12/2017 08:43 AM, David Reiser wrote: If gnucash is even letting you punch the “Get Quotes” button, it thinks both perl and finance-quote are installed correctly. If the environment file you edited is

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
:30 AM, David T. wrote: My question to both Les and Robert is *which* environment file have you updated? ~/.bash_profile, or /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment? F::Q will not work in the Mac bundle with Alphavantage if you modify ...bash_profile (but wil

Re: Currency/metals quotes with new f::q 1.45?

2017-11-12 Thread Erik Colson
combo of settings in gnucash. Is this available yet? please check F::Q version 1.47 (untested). best -- erik colson ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC thi

F::Q releases 1.46 and 1.47

2017-11-12 Thread Erik Colson
untested. It adds support for currency lookup through AlphaVantage and passes the currency.t test and maybe it won't break other stuff. If you need currency conversions and feel confident enough, please use 1.47 and report issues to F::Q mailing list or through github issues. Otherwise use 1.46

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David Reiser
If gnucash is even letting you punch the “Get Quotes” button, it thinks both perl and finance-quote are installed correctly. If the environment file you edited is /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment then it looks to me like you only need the

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David T. via gnucash-user
unning changing directories to > /Applications/Gnucash.app . > > > On 11/12/2017 07:30 AM, David T. wrote: >> My question to both Les and Robert is *which* environment file have you >> updated? ~/.bash_profile, or >> /Applications/Gnucash.app/Contents/Resources/etc/gnucash

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
, David T. wrote: My question to both Les and Robert is *which* environment file have you updated? ~/.bash_profile, or /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment? F::Q will not work in the Mac bundle with Alphavantage if you modify ..bash_profile (but will work

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
after I first issue a "export ALPHAVANTAGE_AKI_KEY=" command so you might find that's what is needed when running it directly. Remember the environment file you added the key to is used by GnuCash and presumably passes the api key into F::Q so if you ru

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
l works OK on MacOS 10.13 here but only after I first issue a "export ALPHAVANTAGE_AKI_KEY=" command so you might find that's what is needed when running it directly.  Remember the environment file you added the key to is used by GnuCash and presumably passes the

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Michael Fross
GnuCash and > presumably passes the api key into F::Q so if you run F:Q directly you have > to let it know what your api key is ? > > Cheers Dave H. > > > On 12 November 2017 at 20:28, Les <lellio...@gmail.com> wrote: > > > When I run the same command from my L

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Dave H
eeded when running it directly. Remember the environment file you added the key to is used by GnuCash and presumably passes the api key into F::Q so if you run F:Q directly you have to let it know what your api key is ? Cheers Dave H. On 12 November 2017 at 20:28, Les <lellio...@gmail.com> wrot

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Les
might be doing wrong. MacOS 10.11.6 GnuCash 2.6.15 F::Q 1.45 After obtaining an API key, specifying it in the environment file, and adjusting each security that uses automatics quotes to get them through Alphavantage, if I use Price Editor > Get Quotes, I get an error, "Unable to retrie

Alphavantage quotes working through F::Q, not through Gnucash

2017-11-11 Thread Robert Shimmin
Curious what I might be doing wrong. MacOS 10.11.6 GnuCash 2.6.15 F::Q 1.45 After obtaining an API key, specifying it in the environment file, and adjusting each security that uses automatics quotes to get them through Alphavantage, if I use Price Editor > Get Quotes, I get an error, &quo

F::Q on Windows 8.1 works ok, Windows 10.0 no joy

2017-11-10 Thread samsurd2
For background, I've been using GnuCash 2.6.16 on an HP desktop running Win 8.1 and an HP laptop running Win 10.0 Home version. I usually update quotes on the Win 8.1 machine, store the .gnucash account file on Dropbox and then download/run that file to the Win 10.0 machine. I do the reverse

Re: F::Q 1.40 uploaded

2017-11-09 Thread Fross, Michael
One mistake I made in my email was that I am running F:Q 1.45. I ran that command on another machine and not the one running GNUCash. My apologies for any confusion. Michael On Thu, Nov 9, 2017 at 4:14 PM, rosid wrote: > Michael Fross wrote > > Hello. Happy to if it

Re: F::Q 1.40 uploaded

2017-11-09 Thread rosid
Michael Fross wrote > Hello. Happy to if it helps. I'm running Windows 10 latest version. > > > *Checking my version of F:Q* > > D:\Users\Michael>ppm query finance-quote > ┌───┬─┬─┬──┐ > │ name │ version

Re: F::Q 1.40 uploaded

2017-11-09 Thread Fross, Michael
Fross wrote > > Hi Rosid, > > > > It's been working fine for me. What version of of F:Q are you using? > > > > I use Activestate Perl, so I can find the version with: *ppm query > > finance-quote* > > > > I did have to manually upgrade as

  1   2   >