Re: [GNC] Mutual funds total shares not showing up on Account Page.
Hi John, The 5 funds that were showing up as 0 in the Totals column on the account page have been fixed. When I checked the box 'Get Online Quotes', the number of shares along with the symbol showed up in the Totals column. Your help is much appreciated! Bill On Sun, Jun 18, 2023 at 6:21 PM John Ralls wrote: > Bill, > > Please remember to copy the list on all replies. > > It does not answer my questions. I'll try again: > > 1. What is the exact word or words at the top of the Accounts page over > the column with the missing balances? > 2. Are the balances actually missing, meaning that there is no entry at > all, or does it show a zero (0) balance with the symbol for the fund? > > Regards, > John Ralls > > > On Jun 18, 2023, at 3:00 PM, Bill Swanson wrote: > > > > Hi John, > > > > The number of shares purchased or sold get carried over to the Balance > column on the fund transaction page. This does not show up in the Totals on > the Account page for a few funds. > > > > Double clicking in the accounts name column takes me to the fund page > but the Balance amount does not show up in the Account page under Topals. > > > > I hope this answers your question. > > > > Your help is appreciated. > > > > Bill > > > > On Sun, Jun 18, 2023 at 5:53 PM John Ralls wrote: > > What column heading are you using for total shares? Is the line in that > column blank or 0? > > > > Regards, > > John Ralls > > > > > On Jun 18, 2023, at 1:00 PM, Bill Swanson wrote: > > > > > > There are a few mutual funds whose total shares do not show up on the > > > Accounts page. I am using SqLite for the database. > > > > > > On the account page, when I double click on the fund it takes me to the > > > fund page that shows the ledger but the total shares do not get carried > > > back to the account page. > > > > > > What can cause a few funds not to show their totals on the account > page? > > > > > > -- > > > 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 > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > > > > -- > > Bill Swanson > > 207-2443946 > > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mutual funds total shares not showing up on Account Page.
There are a few mutual funds whose total shares do not show up on the Accounts page. I am using SqLite for the database. On the account page, when I double click on the fund it takes me to the fund page that shows the ledger but the total shares do not get carried back to the account page. What can cause a few funds not to show their totals on the account page? -- 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 - 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 243, Issue 24
on release 1.56_02 is available for evaluation/testing. > https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz > > > > > It can be installed via cpan/cpanm as > >> 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. > > > > The YahooWeb module currently requires the Date::Business module. > Installing it cannot be done unattended, as the Makefile.PL used requires a > yes/no question be answered. Not updated since January 2000, attempts to > reach the author have been unsuccessful so far. > > > > Bruce, > > Maybe you could use Date::Manip::Date_PrevWorkDay instead? > > But either way it's pretty US-centric because of the holidays enumeration. > What about the Monday-Friday trading days assumption? Is that valid for all > of the stock markets that Yahoo can get quotes for? > > Regards, > John Ralls > > > > -- > > Message: 7 > Date: Fri, 16 Jun 2023 12:23:25 -0700 > From: Bruce Schuck > To: John Ralls > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 6/16/23 12:11 PM, John Ralls wrote: > > > Maybe you could use Date::Manip::Date_PrevWorkDay instead? > > > But either way it's pretty US-centric because of the holidays > > enumeration. What about the Monday-Friday trading days assumption? Is > > that valid for all of the stock markets that Yahoo can get quotes > > for? > > The module was written by Vincent L. Without a trade date available in > the HTML, I added using Date::Business as a quick fix for the time > being. Before pushing 1.57 to CPAN I may just revert to Vincent's > original version which uses today's date at the trade date, even if > executed on weekends and holidays. Pick yer poison, I was just trying to > make it a little better for some subset of users. > > Thanks. > > BTW - Fixed the 2025 US NYSE holiday dates in YahooWeb.pm. > > Bruce S. > > > -- > > Subject: Digest Footer > > ___ > > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > -- > > End of gnucash-user Digest, Vol 243, Issue 24 > * > -- 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 - 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 runn
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] Price tool -- get price works for 3 mutual funds but not the rest.
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.
[GNC] Price editor is not getting the quotes.
I am using alphavantage. Has the get quotes method changed? Thanks in advance! -- 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: GnuCash: Price Editor -- Linux Mint
How do I update the Price Editor to use the Financial::Quote? GnuCash Version: 2.6.12 I used the: perl -MCPAN -e shell install Finance::Quote Got version 1.47 How do I get this to show up in the drop down in the Security Editor? ( *Alphavantage)* https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F The OS is LinuxMint 17.1 -- Bill Swanson 207-2443946 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.