The number of shares for some of the mutual funds does not show up on the Account Totals. I am using SQLIte for the database. How can I fix this?
Thanks, Bill On Sat, Jun 17, 2023 at 12:00 PM <gnucash-user-requ...@gnucash.org> 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: gnucash-user Digest, Vol 243, Issue 23 (Colin Arndt) > 2. Re: Finance::Quote 1.56_02 Available for Evaluation > (Bruce Schuck) > 3. Re: Finance::Quote 1.56_02 Available for Evaluation > (Murugan Muruganandam) > 4. Re: Finance::Quote 1.56_02 Available for Evaluation > (Bruce Schuck) > 5. Re: Finance::Quote 1.56_02 Available for Evaluation > (Fross, Michael) > 6. Re: Finance::Quote 1.56_02 Available for Evaluation (John Ralls) > 7. Re: Finance::Quote 1.56_02 Available for Evaluation > (Bruce Schuck) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 16 Jun 2023 12:12:20 -0400 > From: Colin Arndt <colinfar...@gmail.com> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] gnucash-user Digest, Vol 243, Issue 23 > Message-ID: <1ee8906d-f406-4c9a-95bf-db4225085...@gmail.com> > Content-Type: text/plain; charset=utf-8 > > Hi Bruce, > > Thank you for your efforts to resolve the Yahoo API issues. I rely on > quotes in GNC to track the value of portfolios and overall net worth. Your > efforts are much appreciated! > > I?ll install this to help with testing. > > Best, > Colin > > > Date: Thu, 15 Jun 2023 12:23:42 -0700 > > From: Bruce Schuck <bsch...@asgard-systems.com> > > To: Finance-Quote-News <finance-quote-n...@lists.sourceforge.net>, > > Finance-Quote-User <finance-quote-u...@lists.sourceforge.net>, > GnuCash > > User <gnucash-user@gnucash.org> > > Subject: [GNC] Finance::Quote 1.56_02 Available for Evaluation > > Message-ID: <66d8719e-5324-d74f-d92c-34f259514...@asgard-systems.com> > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > Greetings all, > > > > Non-production 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'. > > > > Anticipating that Yahoo may block access to the URL used in the > > YahooJSON (yahoo_json) module, there are 3 new modules that gather > > information from URLs normally accessed through a browser. > > > > GoogleWeb (googleweb) > > MarketWatch (marketwatch) > > YahooWeb (yahooweb) > > > > In addition the Fool module was corrected so it now works. > > > > 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 23 > > ********************************************* > > > > ------------------------------ > > Message: 2 > Date: Fri, 16 Jun 2023 09:42:06 -0700 > From: Bruce Schuck <bsch...@asgard-systems.com> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: <60e4fe31-2008-8d90-bdb4-84c27877d...@asgard-systems.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 06/15/2023 12:23 -0700, Bruce S wrote: > > > Non-production 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 S. > > > ------------------------------ > > Message: 3 > Date: Fri, 16 Jun 2023 17:12:52 +0000 > From: Murugan Muruganandam <m.muruganan...@hotmail.com> > To: Bruce Schuck <bsch...@asgard-systems.com>, > "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: > < > cpwp152mb5742d29eda961818df6f70979c...@cpwp152mb5742.lamp152.prod.outlook.com > > > > Content-Type: text/plain; charset="us-ascii" > > thanks so much for your effort. > > i checked YahooWeb module with different combinations including symbols > with .extensions , all the quotes were fetched correctly. > > > > > Saludos Cordiales > > > Murugan > > ________________________________ > From: gnucash-user <gnucash-user-bounces+m.muruganandam= > hotmail....@gnucash.org> on behalf of Bruce Schuck < > bsch...@asgard-systems.com> > Sent: Friday, June 16, 2023 12:42 PM > To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > > On 06/15/2023 12:23 -0700, Bruce S wrote: > > > Non-production 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 S. > _______________________________________________ > 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. > > > ------------------------------ > > Message: 4 > Date: Fri, 16 Jun 2023 10:26:37 -0700 > From: Bruce Schuck <bsch...@asgard-systems.com> > To: Murugan Muruganandam <m.muruganan...@hotmail.com>, > "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: <7c5d3c2c-376d-c8c1-debc-e955bf70a...@asgard-systems.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 6/16/23 10:12 AM, Murugan Muruganandam wrote: > > > i checked YahooWeb module with different combinations including > > symbols with .extensions , all the quotes were fetched correctly. > > Awesome, thank you for the response. > > Bruce S. > > > ------------------------------ > > Message: 5 > Date: Fri, 16 Jun 2023 13:18:57 -0500 > From: "Fross, Michael" <mich...@fross.org> > To: Bruce Schuck <bsch...@asgard-systems.com> > Cc: Murugan Muruganandam <m.muruganan...@hotmail.com>, > "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: > < > camd2dfvg9khsjwyav8ybfkeikswwplprtxudey6dn-qoz8l...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Bruce. I echo Murugan's comments - thank you and the team. > > I've been using it the last few days with yahoo_JSON. No issues. I'll > have to try out a few of the others as I also think our days of using Yahoo > are very numbered. > > Michael > > On Fri, Jun 16, 2023 at 12:27?PM Bruce Schuck <bsch...@asgard-systems.com> > wrote: > > > On 6/16/23 10:12 AM, Murugan Muruganandam wrote: > > > > > i checked YahooWeb module with different combinations including > > > symbols with .extensions , all the quotes were fetched correctly. > > > > Awesome, thank you for the response. > > > > Bruce S. > > _______________________________________________ > > 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. > > > > > ------------------------------ > > Message: 6 > Date: Fri, 16 Jun 2023 12:11:49 -0700 > From: John Ralls <jra...@ceridwen.us> > To: Bruce Schuck <bsch...@asgard-systems.com> > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: <0cb7edfc-aa9e-490c-9cb9-5d52b7c15...@ceridwen.us> > Content-Type: text/plain; charset=us-ascii > > > > > On Jun 16, 2023, at 9:42 AM, Bruce Schuck <bsch...@asgard-systems.com> > wrote: > > > > On 06/15/2023 12:23 -0700, Bruce S wrote: > > > >> Non-production 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 <bsch...@asgard-systems.com> > To: John Ralls <jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation > Message-ID: <bcf4df3a-17fd-7734-15e3-b120e2a18...@asgard-systems.com> > 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.