[GNC] Not Getting Complete Stock Quotes with Price Database Tool
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 will only provide quotes for 5 to 6 of my stocks and reports it is unable to provide quotes for my other stocks and funds. I have 1 OTC stock, 3 NYSE stocks, 1 NASDAQ stock, and 9 mutual funds. Since January I have had no problem getting quotes for all of them with only an occasional stock not getting a quote. I my last good quotes retrieved by the price tool for all the stocks was July 31, 2018. I haven't made any changes that I know of in the last 60 days that would affect this change. On July 31 everything was working great. Then in the first week of August it is only partially working. What happened on August 1? Did Alpha Vantage start enforcing their 5 calls per minute limit for their free API numbers? Did something else happen? Am I the only one with this experience? I don't care to get the quotes manually and then load prices by importing. I need to determine if GnuCash or Finance::Quote is broken or if Alpha Vantage is changing the rules. Does anyone know? Thanks for any response. Dan ___ 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] AlphaVantage Deal
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 request #88 on the F::Q github site. It needs a little polishing, but it has been working for me. - Bruce S. 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 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] AlphaVantage deal
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.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 the first one to get the current quote. -A. On Thu, 23 Aug 2018 at 12:22, floppy5.25 wrote: 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 sync between GnuCash and the markets, so I proposed a tier that would provide 128 queries/day at 2 queries/second before dropping back down to the free level of 1 quote / 20 seconds for a monthly fee of USD$5/month. AlphaVantage expressed willingness to provide something along those lines - what do you folks think? Would this be something worth $5/mo, $10/mo, or are most users happy at the free levels? Regards, Ethan I would gladly pay $10/mo for reliable quotes as long as I can get a wide range of sources. Many funds that I use are not supported by AlphaVantage. My $0.2 ___ 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. -- dhamb...@afrinc.com home phone (207) 633-4342 Cell Phone (207) 350-0440 ___ 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] AlphaVantage deal
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 the first one to get the current quote. -A. On Thu, 23 Aug 2018 at 12:22, floppy5.25 wrote: > 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 sync between GnuCash and > the > > markets, so I proposed a tier that would provide 128 queries/day at 2 > > queries/second before dropping back down to the free level of 1 quote / > 20 > > seconds for a monthly fee of USD$5/month. AlphaVantage expressed > > willingness to provide something along those lines - what do you folks > > think? Would this be something worth $5/mo, $10/mo, or are most users > happy > > at the free levels? > > > > Regards, > > Ethan > > I would gladly pay $10/mo for reliable quotes as long as I can get a wide > range of sources. Many funds that I use are not supported by AlphaVantage. > > My $0.2 > > > ___ > 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] gnucash-user Digest, Vol 185, Issue 91
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/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > >1. Re: Balsheet-eg.scm problem (Stephen M. Butler) >2. Re: Price tool -- get price works for 3 mutual funds but not > the rest. (Bill Swanson) > > > -- > > Message: 1 > Date: Wed, 22 Aug 2018 14:17:21 -0700 > From: "Stephen M. Butler" > To: Derek Atkins > Cc: GnuCash users group > Subject: Re: [GNC] Balsheet-eg.scm problem > Message-ID: <7360a9b9-82ad-56de-5412-02f723cb7...@gmail.com> > Content-Type: text/plain; charset="utf-8" > > On 08/22/2018 08:01 AM, Derek Atkins wrote: > > Hi, > > > > There should be a > /usr/local/share/gnucash/scm/gnucash/report/business-reports* > > in your installation. > I see a business-reports.scm file there.? The other files are: > steve@stevelaptop:/usr/local/share/gnucash/scm/gnucash/report$ ls -l > total 916 > -rw-r--r-- 1 root root? 30346 Aug? 8 12:34 aging.scm > -rw-r--r-- 1 root root?? 1240 Aug? 8 12:34 balsheet-eg.css > -rw-r--r-- 1 root root? 11728 Aug? 8 12:34 balsheet-eg.eguile.scm > -rw-r--r-- 1 root root? 33739 Aug 21 19:21 balsheet-eg.old > -rw-r--r-- 1 root root? 33386 Aug 21 20:51 balsheet-eg.scm > -rw-r--r-- 1 root root? 11556 Aug 21 21:27 balsheet-fmtd.eguile.scm > -rw-r--r-- 1 root root? 34010 Aug 21 19:22 balsheet-fmtd.scm > -rw-r--r-- 1 root root?? 5383 Aug? 8 12:34 business-reports.scm > -rw-r--r-- 1 root root? 38987 Aug? 8 12:34 customer-summary.scm > -rw-r--r-- 1 root root? 27079 Aug? 8 12:34 easy-invoice.scm > -rw-r--r-- 1 root root? 10148 Aug? 8 12:34 eguile-gnc.scm > -rw-r--r-- 1 root root?? 5523 Aug? 8 12:34 eguile-html-utilities.scm > -rw-r--r-- 1 root root?? 4142 Aug? 8 12:34 eguile-utilities.scm > -rw-r--r-- 1 root root? 32028 Aug? 8 12:34 fancy-invoice.scm > -rw-r--r-- 1 root root? 21430 Aug? 8 12:34 hello-world.scm > -rw-r--r-- 1 root root? 11639 Aug 21 19:22 income-statement2.scm > -rw-r--r-- 1 root root? 24147 Aug? 8 12:34 invoice.scm > -rw-r--r-- 1 root root? 21536 Aug? 8 12:34 job-report.scm > drwxr-xr-x 2 root root?? 4096 Aug? 8 19:13 locale-specific > -rw-r--r-- 1 root root? 32733 Aug? 8 12:34 owner-report.scm > -rw-r--r-- 1 root root?? 4115 Aug? 8 12:34 payables.scm > -rw-r--r-- 1 root root?? 2521 Aug? 8 12:34 receipt.css > -rw-r--r-- 1 root root? 13049 Aug? 8 12:34 receipt.eguile.scm > -rw-r--r-- 1 root root? 12901 Aug? 8 12:34 receipt.scm > -rw-r--r-- 1 root root?? 4635 Aug? 8 12:34 receivables.scm > -rw-r--r-- 1 root root?? 5486 Aug? 8 12:34 report-gnome.scm > drwxr-xr-x 3 root root?? 4096 Aug? 8 19:13 report-system > -rw-r--r-- 1 root root? 28028 Aug? 8 12:34 report-system.scm > drwxr-xr-x 3 root root?? 4096 Aug? 8 19:13 standard-reports > -rw-r--r-- 1 root root?? 5648 Aug? 8 12:34 standard-reports.scm > -rw-r--r-- 1 root root? 12994 Aug? 8 12:34 stylesheet-easy.scm > -rw-r--r-- 1 root root? 12910 Aug? 8 12:34 stylesheet-fancy.scm > -rw-r--r-- 1 root root? 13592 Aug? 8 12:34 stylesheet-footer.scm > -rw-r--r-- 1 root root? 20856 Aug? 8 12:34 stylesheet-head-or-tail.scm > -rw-r--r-- 1 root root?? 7547 Aug? 8 12:34 stylesheet-plain.scm > -rw-r--r-- 1 root root?? 1240 Aug 21 19:22 stylesheet-reports.css > -rw-r--r-- 1 root root?? 1518 Aug? 8 12:34 stylesheets.scm > -rw-r--r-- 1 root root?? 1855 Aug? 8 12:34 taxinvoice.css > -rw-r--r-- 1 root root? 19239 Aug? 8 12:34 taxinvoice.eguile.scm > -rw-r--r-- 1 root root? 19041 Aug? 8 12:34 taxinvoice.scm > -rw-r--r-- 1 root root? 39142 Aug? 8 12:34 taxtxf-de_DE.scm > -rw-r--r-- 1 root root 192419 Aug? 8 12:34 taxtxf.scm > -rw-r--r-- 1 root root??? 847 Aug? 8 12:34 > test-load-report-stylesheets-module.scm > -rw-r--r-- 1 root root?? 1497 Aug? 8 12:34 utility-reports.scm > -rw-r--r-- 1 root root?? 8988 Aug? 8 12:34 view-column.scm > -rw-r--r-- 1 root root?? 4431 Aug? 8 12:34 welcome-to-gnucash.scm > > > > > What version of GnuCash is this? Considering it's /usr/local I'm > > guessing you built it yourself. Did you possibly upgrade a 2.6.x to 3.y > > version and overwrite the older version? > > I've been running v3.2 for awhile (compiled locally) and recently pulled > down from github to fix some bugs so now have v3.2-100. > > I had made changes to the eguile balance sheet program pre-3.x but > hadn't moved it in thinking the new multi-column balance sheet report > would make it obsolete.? That turns out to not be the case and the new > one is headed i
Re: [GNC] Price tool -- get price works for 3 mutual funds but not the rest.
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:
> > 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
> > ...
> >
> > But good quotes are received for :
> > ABCYX
> > JAENX
> > PTTPX
> >
> > Running on Linux Mint (Mate) 18.3 Sylvia
> > Environment varibles:
> > [Variables]
> > # PATH is used to find the finance::quote utility functions
> > PATH={GNC_BIN};{PATH}
> > ALPHAVANTAGE_API_KEY=###
> >
> >> sudo cpan -D Finance::Quote
> > CPAN::SQLite not installed, trying to work without
> > Reading '/home/bill/.cpan/Metadata'
> >Database was generated on Sat, 18 Aug 2018 13:17:03 GMT
> > Finance::Quote
> > -
> > (no description)
> > E/EC/ECOCODE/Finance-Quote-1.47.tar.gz
> > /usr/local/share/perl/5.22.1/Finance/Quote.pm
> > Installed: 1.47
> > CPAN: 1.47 up to date
> > Erik Colson (ECOCODE)
> > e...@ecocode.net
> >
> > gnc-fq-dump -v alphavantage ipas works when the code in
> > gnc-fq-dump is changed from:
> > # my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
> > my $ALPHAVANTAGE_API_KEY = '###';
> >
> > and it now works!
> > bill@bill-mint64 ~/Downloads/Gnucash/gnucash-2.6.12/src/quotes $ sudo
> perl
> > gnc-fq-dump -v alphavantage ipas
> > Finance::Quote fields Gnucash uses:
> > symbol: ipas <=== required
> >date: 08/22/2018 <=== required
> >currency: USD <=== required
> >last: 0.2201 <=\
> > nav: <=== one of these
> > price: <=/
> >timezone: <=== optional
> >
> > All fields returned by Finance::Quote for stock ipas
> >
> > stock field value
> > - - -
> > ipasclose: 0.2201
> > ipas currency: USD
> > ipas currency_set_by_fq: 1
> > ipas date: 08/22/2018
> > ipas high: 0.2400
> > ipas isodate: 2018-08-22
> > ipas last: 0.2201
> > ipas low: 0.1813
> > ipas method: alphavantage
> > ipas open: 0.1999
> > ipas success: 1
> > ipas symbol: ipas
> > ipas volume: 1739863
> >
> > But from GnuCash I only get 3 updates for the entire list.
> >
> > Suggestions?
>
>
--
Bill Swanson
207-2443946
___
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] Balsheet-eg.scm problem
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 they go, please!
>> Ach! OK. So what language should I learn this winter? Anything that
>> looks like: COBOL, BASIC, Fortran, PL/SQL, Pascal (just a smidgen),
>> Transact, SPL (HP-3000)? I have been thinking that putting C under my
>> belt might be useful -- then I retired!
> Pascal and HP-SPL are both Algol descendants, as is C, so learning that will
> likely be closest to your work experience. I don't think there are many
> people writing new code in procedural languages like COBOL, FORTAN, and BASIC.
>
> If you want to learn 21st-century programming idioms I recommend Python, but
> unless you've already encountered object-oriented programming you'll want to
> start with a "how-to-program" book rather than the language reference. Object
> orientation requires a different approach to breaking the problem into
> solvable pieces ("decomposition") than modular ("block-oriented") languages
> like Pascal, HP-SPL, and C.
>
> That said, if you want to write reports that are internal to GnuCash you've
> got to learn Scheme. If you're willing to use a SQL backend you can query the
> database and use any language you like and can find a compiler for on the
> results.
>
> Regards,
> John Ralls
>
>
Thanks John. I read the "Tao of Objects" a decade or so ago. But
that's as close as I've gotten to doing anything with that class of
programming.
Looks like C and Scheme are on my todo list. I'll check to see if there
is a CBT for Scheme.
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
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] Balsheet-eg.scm problem
> 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 should I learn this winter? Anything that
> looks like: COBOL, BASIC, Fortran, PL/SQL, Pascal (just a smidgen),
> Transact, SPL (HP-3000)? I have been thinking that putting C under my
> belt might be useful -- then I retired!
Pascal and HP-SPL are both Algol descendants, as is C, so learning that will
likely be closest to your work experience. I don't think there are many people
writing new code in procedural languages like COBOL, FORTAN, and BASIC.
If you want to learn 21st-century programming idioms I recommend Python, but
unless you've already encountered object-oriented programming you'll want to
start with a "how-to-program" book rather than the language reference. Object
orientation requires a different approach to breaking the problem into solvable
pieces ("decomposition") than modular ("block-oriented") languages like Pascal,
HP-SPL, and C.
That said, if you want to write reports that are internal to GnuCash you've got
to learn Scheme. If you're willing to use a SQL backend you can query the
database and use any language you like and can find a compiler for on the
results.
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] Balsheet-eg.scm problem
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 usurping the balsheet-eg.scm >>> report. If I change that back to balsheet-fmtd.scm (and fix the name >>> dependencies in the file), it isn't seen by GNC. >>> >>> Moving the files down to standard-reports throws other errors that I >>> can't figure out. So, what has to happen to get the report to load >>> independent of balsheet-eg? >> >> I was under the impression that all the files in standard-reports get >> auto-loaded.So just pulling a new report in there should be >> sufficient. > That is correct. However Stephen has put his customized balsheet-fmtd.scm > report in > /usr/local/share/gnucash/scm/gnucash/report > instead of > /usr/local/share/gnucash/scm/gnucash/report/standard-reports I tried in standard-reports and it threw errors. Moved back up to report and it works. I'm sure there is something about the code that I didn't change correctly for the new location. > Files in the former directory are not automatically loaded, a historical > artifact we should one day fix. > >> HOWEVER the e-guile reports MIGHT be different. > What is different about the e-guile reports is that they are business > reports. > And contrary to the standard reports they are only loaded if explicitly > mentioned in > /usr/local/share/gnucash/scm/gnucash/report/business-reports.scm > (in a use-modules construct). Aha. The missing piece of information. >> Also, ensure the file name and path matches the module name. >> > This is the problem IMO. The attached balsheet-fmtd.scm (renamed to balsheet- > eg.scm) defines this module: > (define-module (gnucash report balsheet-fmtd)) > As this file replaces balsheet-eg.scm there no longer is a module defined by > (define-module (gnucash report balsheet-eg)) > > And hence gnucash complains it can't find that one. I changed the define-module and the debug lines to match the balsheet-eg name. That got it to work. > > To solve this, restore the original balsheet-eg.scm and instead add a line in > business-reports.scm like this: > > (use-modules (gnucash report balsheet-fmtd)) OK. Will take this path. > > Better still: don't mess with the installation directory at all and instead > follow > https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report > to load your custom report. I tried that path and it didn't work. One of these days I'll figure out what I did wrong there. But, if the above will work then I'm willing to suffer making the changes for each new release. > > Regards, > > Geert > > > Thanks Geert. I believe you gave me the missing piece of information that I needed. --Steve (feeling my way in the twilight) -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] AlphaVantage deal
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 sync between GnuCash and the > markets, so I proposed a tier that would provide 128 queries/day at 2 > queries/second before dropping back down to the free level of 1 quote / 20 > seconds for a monthly fee of USD$5/month. AlphaVantage expressed > willingness to provide something along those lines - what do you folks > think? Would this be something worth $5/mo, $10/mo, or are most users happy > at the free levels? > > Regards, > Ethan I would gladly pay $10/mo for reliable quotes as long as I can get a wide range of sources. Many funds that I use are not supported by AlphaVantage. My $0.2 ___ 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] Balsheet-eg.scm problem
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 that back to balsheet-fmtd.scm (and fix the name > > dependencies in the file), it isn't seen by GNC. > > > > Moving the files down to standard-reports throws other errors that I > > can't figure out. So, what has to happen to get the report to load > > independent of balsheet-eg? > > [snip] > > 3068: 9 [try-module-autoload (gnucash report business-reports) #f] > 2404: 8 [save-module-excursion # ice-9/boot-9.scm:3069:17 ()>] > 3088: 7 [#] > In unknown file: > ?: 6 [primitive-load-path "gnucash/report/business-reports" ...] > In business-reports.scm: > 123: 5 [#] > In ice-9/boot-9.scm: > 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] > 705: 3 [map # (mif-args)> ((#))] > 3590: 2 [# (mif-args)> (#)] > 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] > In unknown file: > ?: 0 [scm-error misc-error #f ...] > > ERROR: In procedure scm-error: > ERROR: no code for module (gnucash report balsheet-eg) > > Basically, the issue being reported is that it is trying to find "gnucash > report balsheet-eg" but it can't. WHY it thinks there is "no code for > module" is a different question. One possibility is caching -- you > should definitely clear your guile cache. You can also "touch" the .scm > files to make them look newer so they get recompiled. > > I was under the impression that all the files in standard-reports get > auto-loaded.So just pulling a new report in there should be > sufficient. That is correct. However Stephen has put his customized balsheet-fmtd.scm report in /usr/local/share/gnucash/scm/gnucash/report instead of /usr/local/share/gnucash/scm/gnucash/report/standard-reports Files in the former directory are not automatically loaded, a historical artifact we should one day fix. > HOWEVER the e-guile reports MIGHT be different. What is different about the e-guile reports is that they are business reports. And contrary to the standard reports they are only loaded if explicitly mentioned in /usr/local/share/gnucash/scm/gnucash/report/business-reports.scm (in a use-modules construct). > > Also, ensure the file name and path matches the module name. > This is the problem IMO. The attached balsheet-fmtd.scm (renamed to balsheet- eg.scm) defines this module: (define-module (gnucash report balsheet-fmtd)) As this file replaces balsheet-eg.scm there no longer is a module defined by (define-module (gnucash report balsheet-eg)) And hence gnucash complains it can't find that one. To solve this, restore the original balsheet-eg.scm and instead add a line in business-reports.scm like this: (use-modules (gnucash report balsheet-fmtd)) Better still: don't mess with the installation directory at all and instead follow https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report to load your custom report. 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: [GNC] Balsheet-eg.scm problem
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, Fortran, PL/SQL, Pascal (just a smidgen), Transact, SPL (HP-3000)? I have been thinking that putting C under my belt might be useful -- then I retired! --Steve > 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 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 isn't seen by GNC. >>> >>> Moving the files down to standard-reports throws other errors that I >>> can't figure out. So, what has to happen to get the report to load >>> independent of balsheet-eg? >> [snip] >> 3068: 9 [try-module-autoload (gnucash report business-reports) #f] >> 2404: 8 [save-module-excursion #> ice-9/boot-9.scm:3069:17 ()>] >> 3088: 7 [#] >> In unknown file: >>?: 6 [primitive-load-path "gnucash/report/business-reports" ...] >> In business-reports.scm: >> 123: 5 [#] >> In ice-9/boot-9.scm: >> 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] >> 705: 3 [map #> (mif-args)> ((#))] >> 3590: 2 [#> (mif-args)> (#)] >> 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] >> In unknown file: >>?: 0 [scm-error misc-error #f ...] >> >> ERROR: In procedure scm-error: >> ERROR: no code for module (gnucash report balsheet-eg) >> Basically, the issue being reported is that it is trying to find "gnucash >> report balsheet-eg" but it can't. WHY it thinks there is "no code for >> module" is a different question. One possibility is caching -- you >> should definitely clear your guile cache. You can also "touch" the .scm >> files to make them look newer so they get recompiled. >> >> I was under the impression that all the files in standard-reports get >> auto-loaded. So just pulling a new report in there should be >> sufficient. HOWEVER the e-guile reports MIGHT be different. >> >> Also, ensure the file name and path matches the module name. >> >> -derek >> >> -- >>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory >>Member, MIT Student Information Processing Board (SIPB) >>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH >>warl...@mit.eduPGP key available >> ___ -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] AlphaVantage deal
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 provide 128 queries/day at 2 queries/second before dropping back down to the free level of 1 quote / 20 seconds for a monthly fee of USD$5/month. AlphaVantage expressed willingness to provide something along those lines - what do you folks think? Would this be something worth $5/mo, $10/mo, or are most users happy at the free levels? Regards, Ethan ___ 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] Balsheet-eg.scm problem
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.scm (and fix the name >> dependencies in the file), it isn't seen by GNC. >> >> Moving the files down to standard-reports throws other errors that I >> can't figure out. So, what has to happen to get the report to load >> independent of balsheet-eg? > Basically, the issue being reported is that it is trying to find "gnucash > report balsheet-eg" but it can't. WHY it thinks there is "no code for > module" is a different question. One possibility is caching -- you > should definitely clear your guile cache. You can also "touch" the .scm > files to make them look newer so they get recompiled. > > I was under the impression that all the files in standard-reports get > auto-loaded. So just pulling a new report in there should be > sufficient. HOWEVER the e-guile reports MIGHT be different. > > Also, ensure the file name and path matches the module name. > > -derek > Thanks Derek. I've reverted back to usurping the balsheet eguile names. My version is running that way and since my purpose was to clean up some things I didn't like about the eguile version, I don't need to keep it around. One of these days I should take time to learn the language instead of hacking at it. If anyone has insights on how to get an eguile report loaded in standard-reports (and I don't see any others there so it may not be possible), I'd like to have that input. Maybe I can learn the language over winter! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Balsheet-eg.scm problem
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 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 isn't seen by GNC. > > > > Moving the files down to standard-reports throws other errors that I > > can't figure out. So, what has to happen to get the report to load > > independent of balsheet-eg? > > [snip] > 3068: 9 [try-module-autoload (gnucash report business-reports) #f] > 2404: 8 [save-module-excursion # ice-9/boot-9.scm:3069:17 ()>] > 3088: 7 [#] > In unknown file: > ?: 6 [primitive-load-path "gnucash/report/business-reports" ...] > In business-reports.scm: > 123: 5 [#] > In ice-9/boot-9.scm: > 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] > 705: 3 [map # (mif-args)> ((#))] > 3590: 2 [# (mif-args)> (#)] > 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] > In unknown file: > ?: 0 [scm-error misc-error #f ...] > > ERROR: In procedure scm-error: > ERROR: no code for module (gnucash report balsheet-eg) > > Basically, the issue being reported is that it is trying to find "gnucash > report balsheet-eg" but it can't. WHY it thinks there is "no code for > module" is a different question. One possibility is caching -- you > should definitely clear your guile cache. You can also "touch" the .scm > files to make them look newer so they get recompiled. > > I was under the impression that all the files in standard-reports get > auto-loaded. So just pulling a new report in there should be > sufficient. HOWEVER the e-guile reports MIGHT be different. > > Also, ensure the file name and path matches the module name. > > -derek > > -- >Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory >Member, MIT Student Information Processing Board (SIPB) >URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH >warl...@mit.eduPGP key available > ___ > 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] Cannot change preferences -- see bug 555187?
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 of 17.04. So if your system doesn’t have anything on it that isn’t on 17.04, it is probably safe to delete. And if you do have extra software as most people do, then the list to check is smaller. Regards, Adrien > On Aug 23, 2018, at 9:13 AM, Geert Janssens > wrote: > > 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 555187 dealing with the same one (1). This bug was originally filed on 2008-10-16, but the last comment on it by André Klapper was filed on 2018-08-17 13:58:19 UTC -- yesterday! >>> >>> That bug is about GConf, which was used for preferences before we switched >>> to dconf. GConf and dconf are completely different tools and your problem >>> is with dconf so this bug is irrelevant here. >>> >>> 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 version 2.6.0. >> >> Does the foregoing mean that directory ~/.gconf can be safely deleted? >> The most recent dates of the files in its subdirecties date from 2014 or >> earlier. >> >> Regards, Ken > > I don't know. I know gnucash is no longer using gconf, but perhaps other > applications on your system still are (though unlikely). > > The fact the most recent date in that directory is from 2014 means no > application you have run since that time has made changes in gconf, but some > may still read the current state. > > Having said all that, it's unlikely there are still currently maintained > applications using GConf though. And if you remove the directory, worst case > is for those applications the default preferences are reset. You won't loose > your data because of this. > > If in doubt, archive a copy of the directory somewhere before removing. If > you > find one of your applications starts behaving oddly (in the sense it's no > longer configured as you expected) you may check if it's still using gconf. > > 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: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)
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/invoices. I think I’ve seen that question already on the list. And thank you for the clarifications! Regards, Adrien > On Aug 23, 2018, at 8:23 AM, Derek Atkins wrote: > > 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, there is also the limitation that >> you also can’t buy supplies from multiple vendors on the same job. >> >> Or did I confuse that as well? > > No, you go it right. Think of a job as a "vendor contract", a way to > link multiple vendor bills together for some purpose. I suppose I > should have named it "Purchase Order". > >> The other part I never could understand was not being able to use the >> same ‘job’ for both a customer and a vendor. So even following the >> above limitations, I can’t use a job on a vendor bill to rebill a >> customer AND assign that job on the customer’s invoice? > > See above. A "job" is really a misnomer. The idea was more like a > "Purchase Order" (PO). A PO is a way to link multiple invoices > together, but a PO is only valid to a single customer or single vendor. > >> I’m also not quite understanding your last caveat. So the Job is then >> not an extra layer of info, but replaces the Vendor/Customer? I think >> I’m truly lost now on the feature and its purpose. > > Internally that is correct. Because a Job (PO) has only a single > customer (or vendor), you can use a Job instead -- so the "Owner" of an > invoice can be a Job (which implies a customer). > >> Regards, >> Adrien > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > Member, MIT Student Information Processing Board (SIPB) > URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH > warl...@mit.eduPGP key available > ___ 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] Cannot change preferences -- see bug 555187?
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 555187 dealing with the same > >> one (1). This bug was originally filed on 2008-10-16, but the last > >> comment on it by André Klapper was filed on 2018-08-17 13:58:19 UTC -- > >> yesterday! > > > > That bug is about GConf, which was used for preferences before we switched > > to dconf. GConf and dconf are completely different tools and your problem > > is with dconf so this bug is irrelevant here. > > > > 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 version 2.6.0. > > Does the foregoing mean that directory ~/.gconf can be safely deleted? > The most recent dates of the files in its subdirecties date from 2014 or > earlier. > > Regards, Ken I don't know. I know gnucash is no longer using gconf, but perhaps other applications on your system still are (though unlikely). The fact the most recent date in that directory is from 2014 means no application you have run since that time has made changes in gconf, but some may still read the current state. Having said all that, it's unlikely there are still currently maintained applications using GConf though. And if you remove the directory, worst case is for those applications the default preferences are reset. You won't loose your data because of this. If in doubt, archive a copy of the directory somewhere before removing. If you find one of your applications starts behaving oddly (in the sense it's no longer configured as you expected) you may check if it's still using gconf. 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: [GNC] Cannot change preferences -- see bug 555187?
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 version 2.6.0. > > Does the foregoing mean that directory ~/.gconf can be safely deleted? > The most recent dates of the files in its subdirecties date from 2014 or > earlier. As far as gnucash is concerned then yes, but you may have other apps that are still using it I suppose. Colin ___ 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] Cannot change preferences -- see bug 555187?
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-10-16, but the last comment on it by André Klapper was filed on 2018-08-17 13:58:19 UTC -- yesterday! That bug is about GConf, which was used for preferences before we switched to dconf. GConf and dconf are completely different tools and your problem is with dconf so this bug is irrelevant here. 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 version 2.6.0. Does the foregoing mean that directory ~/.gconf can be safely deleted? The most recent dates of the files in its subdirecties date from 2014 or earlier. Regards, Ken ___ 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] Gnucash 3 in the Debian / Ubuntu pipeline?
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 Gtk+3 version is much better than the old Gtk+2 iteration. (even with the quirks and bugs) Regards, Adrien > On Aug 22, 2018, at 11:17 PM, John Ralls wrote: > > > >> On Aug 22, 2018, at 3:41 PM, Adrien Monteleone >> wrote: >> >> >>> On Aug 22, 2018, at 4:04 PM, GWB wrote: >>> >>> >>> Why is gnucash in the Gnome ghetto for program categories? Am I able >>> to run it in xfce because I already have the gnome dependencies >>> installed already? >>> >> >> That is probably an historical artifact. You can run it in XFCE as that is >> built on Gtk. If you try to run it on KDE, you can still run it, but it will >> pull in the Gtk dependencies. (that is, it won’t use QT which is native to >> KDE) >> >> Somewhere long in the future, when/if GnuCash abides the MVC pattern, it >> will be easier to port the interface using a native toolkit such as QT, >> Cocoa, etc. At present, the functional code is very tied to the UI which is >> built using Gtk. > > We do hope so, but easier != easy. Writing a GUI is a lot of work, and aside > from the general design one must pretty much start from scratch every time. I > don’t anticipate that core GnuCash will ever provide multiple GUI toolkit > implementations. > > 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] Price tool -- get price works for 3 mutual funds but not the rest.
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 > gnc-fq-dump -v alphavantage ipas > Finance::Quote fields Gnucash uses: > symbol: ipas <=== required > date: 08/22/2018 <=== required > currency: USD <=== required > last: 0.2201 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional Capitalization matters -- sometimes. What do you get from: gnc-fq-dump -v alphavantage IPAS I ask because "IPAS" is what you have listed above. Also, Alphavantage is overloaded so sometimes can bog down and fail to respond. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)
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, there is also the limitation that > you also can’t buy supplies from multiple vendors on the same job. > > Or did I confuse that as well? No, you go it right. Think of a job as a "vendor contract", a way to link multiple vendor bills together for some purpose. I suppose I should have named it "Purchase Order". > The other part I never could understand was not being able to use the > same ‘job’ for both a customer and a vendor. So even following the > above limitations, I can’t use a job on a vendor bill to rebill a > customer AND assign that job on the customer’s invoice? See above. A "job" is really a misnomer. The idea was more like a "Purchase Order" (PO). A PO is a way to link multiple invoices together, but a PO is only valid to a single customer or single vendor. > I’m also not quite understanding your last caveat. So the Job is then > not an extra layer of info, but replaces the Vendor/Customer? I think > I’m truly lost now on the feature and its purpose. Internally that is correct. Because a Job (PO) has only a single customer (or vendor), you can use a Job instead -- so the "Owner" of an invoice can be a Job (which implies a customer). > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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] Balsheet-eg.scm problem
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 isn't seen by GNC. > > Moving the files down to standard-reports throws other errors that I > can't figure out. So, what has to happen to get the report to load > independent of balsheet-eg? [snip] 3068: 9 [try-module-autoload (gnucash report business-reports) #f] 2404: 8 [save-module-excursion #>>> ice-9/boot-9.scm:3069:17 ()>] 3088: 7 [#] In unknown file: ?: 6 [primitive-load-path "gnucash/report/business-reports" ...] In business-reports.scm: 123: 5 [#] In ice-9/boot-9.scm: 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))] 705: 3 [map #>>> (mif-args)> ((#))] 3590: 2 [#>>> (mif-args)> (#)] 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...] In unknown file: ?: 0 [scm-error misc-error #f ...] ERROR: In procedure scm-error: ERROR: no code for module (gnucash report balsheet-eg) Basically, the issue being reported is that it is trying to find "gnucash report balsheet-eg" but it can't. WHY it thinks there is "no code for module" is a different question. One possibility is caching -- you should definitely clear your guile cache. You can also "touch" the .scm files to make them look newer so they get recompiled. I was under the impression that all the files in standard-reports get auto-loaded. So just pulling a new report in there should be sufficient. HOWEVER the e-guile reports MIGHT be different. Also, ensure the file name and path matches the module name. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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] No Disk error
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 Monteleone wrote: > > Were either of you at any time storing your GnuCash files on an SD card? > > > > If so, I’d suggest using a card to load the file, then doing a Save As > > elsewhere (with the card still in the drive). Then close and re-open > > GnuCash to load from the new location. THEN Safely Eject and remove the SD > > card. > > > > Otherwise, some sort of bug is at play. > > > > Regards, > > Adrien > > > >> On Aug 22, 2018, at 7:30 AM, Mike stagl wrote: > >> > >> I have the same issue on Windows 7 and GnuCash 3.2, and I believe its > >> because I have several SD card readers on my machine and no cards > >> installed in them. > >> > >> > >> I haven't looked into a work around yet, but I agree its highly annoying. > >> > >> > >> I figure I'll need to uninstall my SD card readers in order to stop the > >> alerts. > >> > >> > >> Anyone else have any thoughts? > >> > >> > >> Mike > >> > >> > >> > >> From: Patrick Murez > >> Sent: Wednesday, August 22, 2018 1:34 AM > >> To: gnucash-user@gnucash.org > >> Subject: [GNC] No Disk error > >> > >> Dear all I want to report a problem already submitted in this mailing list > >> with no answer so far: > >> > >> Hi! > >> > >> I am starting over with gnucash, and thought I'd do a clean re-install. > >> Note, I am on windows, and have removed all the gnucash files I could > >> find before installing 3.1. > >> > >> However, now I am getting an annoying error message every time I try to > >> look at the preferences, as well as when I do "save as": > >> > >> Gnucash.exe - No Disk > >> There is no disk in the drive. Please insert a disk into drive > >> \Device\Harddisk1\DR1. > >> > >> I have the options Cancel, Try Again and Continue. Try Again just pops > >> up the message again, so do the other two too. However, if I click > >> enough times on Cancel or Continue, the message goes away. > >> > >> Note, when I change something in Preferences, that change stays when I > >> quit and restart. > >> > >> This is quite annoying, and if anybody could shed some light on what has > >> happened and how to get rid of said message, I'd be very happy. > >> > >> Karin > >> > >> your help will great. > >> > >> Thanks > >> > >> -- > >> > >> -- > >> Patrick Murez, Ch. Eng. > >> Unit Manager Technical Trainings > >> Ruashi mining > >> Cel.:+243816179054 > >>+243995601060 > >> > >> ___ > >> 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. > > I am going to go out on a limb here and suggest it is a Micro$oft > "upgrade" problem. My home Winoze server is up 24/7 (yes I know, ughh > run a real os ), barring power outages out here in the sticks. > > I do not know how many updates my computer installed since its last > reboot but; I do know that I have had trouble for the last week > accessing usb drives. Part of the time they exist and part of time they > don't according to windoze. > > Not much help but; a little more information. > > -- > --JEffrey Black M.B.A. > > ___ > 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 inf
