[GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-23 Thread Dan Nelms
I am using GnuCash v3.2 Build ID:3.2+(2018-06-24) with Strawberry Perl Finance::Quote 1.47. It is running on Windows 10. I started using GnuCash on January 1, 2018 in tandem with Quicken in an effort to get away from the new Quicken subscription plan. In the last 3 weeks the Price Database Tool

Re: [GNC] AlphaVantage Deal

2018-08-23 Thread Bruce Schuck
In my opinion, at $5.00 or more per month one might as well purchase Quicken (which is now a subscription based product I believe). For the F::Q developers, I've been working on module for World Trading Data. Free use is limited to 250 per day, and it's only US traded equities and funds. See pull

Re: [GNC] AlphaVantage deal

2018-08-23 Thread David G Hamblen
It's apparently only for US securities, which might be ok for a subset of users.  There is an alphavantage_batch.pm out there. https://github.com/finance-quote/finance-quote/issues/77 On 08/23/2018 04:22 PM, Alun Champion wrote: Any reason not to move to the batch API (` https://www.alphavant

Re: [GNC] AlphaVantage deal

2018-08-23 Thread Alun Champion
Any reason not to move to the batch API (` https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES&symbols=MSFT,AXP,...&apikey=XXX`) then you could get all the current quotes with a single call. It seems inefficient to get the stock history one stock at a time to discard all the values but th

Re: [GNC] gnucash-user Digest, Vol 185, Issue 91

2018-08-23 Thread Bill Swanson
Use: Security Editor to edit secuiry Use Single: Yahoo as JSON Thanks Brad! On Wed, Aug 22, 2018 at 5:46 PM wrote: > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org

Re: [GNC] Price tool -- get price works for 3 mutual funds but not the rest.

2018-08-23 Thread Bill Swanson
Many thanks for the Yahoo as Jason. It works! btw Capitalization in this command makes no difference: sudo perl gnc-fq-dump -v alphavantage IPAS Bill On Thu, Aug 23, 2018 at 3:41 PM brad wrote: > Try Yahoo as JSON for the quote source. > > On 08/22/2018 03:41 PM, Bill Swanson wrote: > > ISSU

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Stephen M. Butler
On 08/23/2018 10:58 AM, John Ralls wrote: > >> On Aug 23, 2018, at 8:59 AM, Stephen M. Butler wrote: >> >> On 08/23/2018 08:04 AM, Christopher Lam wrote: >>> I can confirm loading of eguile reports is different. Hence I could not >>> trigger loading. Hence there's no test for them. >>> >>> Off the

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread John Ralls
> On Aug 23, 2018, at 8:59 AM, Stephen M. Butler wrote: > > On 08/23/2018 08:04 AM, Christopher Lam wrote: >> I can confirm loading of eguile reports is different. Hence I could not >> trigger loading. Hence there's no test for them. >> >> Off they go, please! > > Ach! OK. So what language

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Stephen M. Butler
On 08/23/2018 09:44 AM, Geert Janssens wrote: > Op donderdag 23 augustus 2018 15:17:34 CEST schreef Derek Atkins: >> Hi, >> >> "Stephen M. Butler" writes: >>> I tripped over a few more typos that seemingly were unrelated to the >>> errors produced. >>> >>> I can get this set of files to work usurp

Re: [GNC] AlphaVantage deal

2018-08-23 Thread floppy5.25
On Thursday, August 23, 2018 10:51:32 AM -05 Ethan Swint wrote: > I recently inquired with AlphaVantage about providing something between > their free 1 quote/20 seconds and their $20/month offering of 1 request / 4 > seconds with premium support. > > I think most users here are on the once-a-day

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Geert Janssens
Op donderdag 23 augustus 2018 15:17:34 CEST schreef Derek Atkins: > Hi, > > "Stephen M. Butler" writes: > > I tripped over a few more typos that seemingly were unrelated to the > > errors produced. > > > > I can get this set of files to work usurping the balsheet-eg.scm > > report. If I change

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Stephen M. Butler
On 08/23/2018 08:04 AM, Christopher Lam wrote: > I can confirm loading of eguile reports is different. Hence I could not > trigger loading. Hence there's no test for them. > > Off they go, please! Ach!  OK.  So what language should I learn this winter?  Anything that looks like:  COBOL, BASIC, For

[GNC] AlphaVantage deal

2018-08-23 Thread Ethan Swint
I recently inquired with AlphaVantage about providing something between their free 1 quote/20 seconds and their $20/month offering of 1 request / 4 seconds with premium support. I think most users here are on the once-a-day sync between GnuCash and the markets, so I proposed a tier that would prov

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Stephen M. Butler
On 08/23/2018 06:17 AM, Derek Atkins wrote: > Hi, > > "Stephen M. Butler" writes: > >> I tripped over a few more typos that seemingly were unrelated to the >> errors produced. >> >> I can get this set of files to work usurping the balsheet-eg.scm >> report.  If I change that back to balsheet-fmtd.

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Christopher Lam
I can confirm loading of eguile reports is different. Hence I could not trigger loading. Hence there's no test for them. Off they go, please! On Thu, 23 Aug 2018, 21:20 Derek Atkins wrote: > Hi, > > "Stephen M. Butler" writes: > > > I tripped over a few more typos that seemingly were unrelated

Re: [GNC] Cannot change preferences -- see bug 555187?

2018-08-23 Thread Adrien Monteleone
This page is almost 3 years old: https://wiki.gnome.org/Initiatives/GnomeGoals/GSettingsMigration But it does offer a list of potential apps to check that might still be using gconf. I’m pretty sure Chromium has completed their migration as of early this year. Ubuntu stopped installing it as o

Re: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)

2018-08-23 Thread Adrien Monteleone
Aha! ‘Purchase Order’ is easier to grok for this. Would that be a terribly difficult fix? Would a bug report be welcome or are there messy implications by changing it? At least one I can think of would be users wanting to create a single ‘PO’ document (with line items) independent of bills/inv

Re: [GNC] Cannot change preferences -- see bug 555187?

2018-08-23 Thread Geert Janssens
Op donderdag 23 augustus 2018 16:00:24 CEST schreef Ken Heard: > On 2018-08-18 13:38, Geert Janssens wrote: > > Op zaterdag 18 augustus 2018 16:34:14 CEST schreef Ken Heard: > >> Last evening I was thinking of filing a bug report for my problem. In > >> the process I found a previous bug report 55

Re: [GNC] Cannot change preferences -- see bug 555187?

2018-08-23 Thread Colin Law
On Thu, 23 Aug 2018 at 15:02, Ken Heard wrote: > > On 2018-08-18 13:38, Geert Janssens wrote: > > ... > > The only thing André added yesterday was a message indicating that the (old) > > GConf tool should be considered dead and burried. Which is fine because > > gnucash has not been using it since

Re: [GNC] Cannot change preferences -- see bug 555187?

2018-08-23 Thread Ken Heard
On 2018-08-18 13:38, Geert Janssens wrote: Op zaterdag 18 augustus 2018 16:34:14 CEST schreef Ken Heard: Last evening I was thinking of filing a bug report for my problem. In the process I found a previous bug report 555187 dealing with the same one (1). This bug was originally filed on 2008-1

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

2018-08-23 Thread Adrien Monteleone
Originally I had typed ’simple’ in quotes and thought better of it. Certainly no, it won’t be simple or easy. But I do hope by then, either myself or someone else with nothing better to do will write a Cocoa native version. (or whatever Mac is using at the time) I have to say though, the present

Re: [GNC] Price tool -- get price works for 3 mutual funds but not the rest.

2018-08-23 Thread Derek Atkins
Hi, Bill Swanson writes: > ISSUE SUMMARY: > GnuCash 2.6.12 (Using Sqlite for data) > Unable to retrieve quotes for these items: > NASDAQ:ABSYX > NASDAQ:JVMIX > NASDAQ:IPAS > NASDAQ:WSTL > NASDAQ:LMSC [snip] > bill@bill-mint64 ~/Downloads/Gnucash/gnucash-2.6.12/src/quotes $ sudo perl >

Re: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)

2018-08-23 Thread Derek Atkins
Adrien Monteleone writes: > Yes, thank you Derek, > > I was describing it backwards. > > A single invoice can have only one job and a single job can’t be used > with multiple vendors. (or multiple customers, but I would think that > to be a very rare case) > > So in addition to the first case, th

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Derek Atkins
Hi, "Stephen M. Butler" writes: > I tripped over a few more typos that seemingly were unrelated to the > errors produced. > > I can get this set of files to work usurping the balsheet-eg.scm > report.  If I change that back to balsheet-fmtd.scm (and fix the name > dependencies in the file), it i

Re: [GNC] No Disk error

2018-08-23 Thread Colin Law
Googling for that error message finds lots of hits. It seems to be do do with having a drive that windows thinks is there but actually isn't. Something like that anyway. There are some solutions offered. Colin On Thu, 23 Aug 2018 at 04:39, jeffrey black wrote: > > On 8/22/2018 1:43 PM, Adrien