Re: [GNC] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

John,

I hate to say this, but on the High Sierra VM I just built 
Finance::Quote is getting valid currency exchanges. At first I was 
having the same issue, but after installing/updating Module::Load the 
issue was corrected.


Bruces-Virtual-High-Sierra:~ bschuck$ sw_vers
ProductName:Mac OS X
ProductVersion: 10.13.6
BuildVersion:   17G66

Bruces-Virtual-High-Sierra:~ bschuck$ perl -v

This is perl 5, version 18, subversion 2 (v5.18.2) built for 
darwin-thread-multi-2level


#!/usr/bin/perl
use strict;
use warnings;
use ExtUtils::Installed; # By default this module will be available in Perl

my $instmod = ExtUtils::Installed->new();
foreach my $module ($instmod->modules()) {
 my $version = $instmod->version($module) || "Version Not Found.";
 print "$module version=$version \n";
}


Archive::Any::Lite version=0.11
Array::Diff version=0.09
AutoLoader version=5.74
B::COW version=0.007
B::Keywords version=1.24
Bundle::NetSNMP version=Version Not Found.
CPAN::DistnameInfo version=0.12
CPAN::Meta version=2.150010
CPAN::Meta::Check version=0.017
CPAN::Meta::Requirements version=2.140
CPAN::Meta::YAML version=0.018
Clone version=0.46
Compress::Raw::Zlib version=2.204
Config::Tiny version=2.28
Crypt::RC4 version=2.02
Cwd version=3.75
Data::Binary version=0.01
Data::Dumper::Perltidy version=0.03
Data::Section version=0.28
Date::Manip version=6.91
Date::Range version=1.41
Date::Simple version=3.03
DateTime version=1.59
DateTime::Format::Builder version=0.83
DateTime::Format::ISO8601 version=0.16
DateTime::Format::Strptime version=1.79
DateTime::Locale version=1.37
DateTime::TimeZone version=2.59
Devel::StackTrace version=2.04
Devel::Symdump version=2.18
Devel::Trace version=0.12
Digest::Perl::MD5 version=1.9
Encode version=3.19
Exception::Class version=1.45
ExtUtils::MakeMaker version=7.68
ExtUtils::MakeMaker::CPANfile version=0.09
File::Copy::Recursive version=0.45
File::Find::Object version=0.3.7
File::ShareDir version=1.118
File::ShareDir::Install version=0.14
File::TreeCreate version=0.0.1
File::pushd version=1.016
Finance::Quote version=1.54
HTML-TableExtract version=Version Not Found.
HTML::Selector::XPath version=0.26
HTML::TokeParser::Simple version=3.16
HTML::TreeBuilder::XPath version=0.14
HTTP::Daemon version=6.16
HTTP::Message version=6.44
IO::Socket::IP version=0.41
IPC::System::Simple version=1.30
Importer version=0.026
JSON version=4.10
JSON::PP version=4.16
LWP version=6.68
Lingua::EN::Inflect version=1.905
List::SomeUtils version=0.59
List::SomeUtils::XS version=0.58
List::Util version=1.63
MCE version=1.884
Module::Build version=0.4232
Module::Build::Tiny version=0.039
Module::CPANTS::Analyse version=1.01
Module::CPANfile version=1.1004
Module::CoreList version=5.20230320
Module::Load version=0.36
Module::Metadata version=1.37
Module::Pluggable version=5.2
Mozilla::CA version=20221114
OLE::Storage_Lite version=0.22
PPI version=1.276
PPIx::QuoteLike version=0.023
PPIx::Regexp version=0.088
PPIx::Utils version=0.003
Params::ValidationCompiler version=0.31
Parse::Distname version=0.05
Path::Tiny version=0.144
Perl version=5.18.2
Perl::Critic version=1.150
Perl::PrereqScanner::NotQuiteLite version=0.9916
Perl::Tidy version=20230309
Pod::Coverage version=0.23
Pod::Spell version=1.26
Readonly version=2.05
Regexp::Trie version=0.02
Role::Tiny version=2.002004
SelfLoader version=1.24
Smart::Comments version=1.06
Software::License version=0.104002
Specio version=0.48
Spiffy version=0.46
Spreadsheet::ParseExcel version=0.65
Spreadsheet::XLSX version=0.17
String::Format version=1.18
String::Util version=1.34
Sub::Identify version=0.14
Sub::Info version=0.002
Sub::Override version=0.09
Term::ReadLine version=1.14
Term::Table version=0.016
Test2::Plugin::NoWarnings version=0.09
Test2::Suite version=0.000150
Test::Base version=0.89
Test::FailWarnings version=0.008
Test::File version=1.993
Test::File::ShareDir version=1.001002
Test::Harness version=3.44
Test::Inter version=1.10
Test::Kwalitee version=1.28
Test::LeakTrace version=0.17
Test::More::UTF8 version=0.05
Test::Needs version=0.002010
Test::NoWarnings version=1.06
Test::Perl::Critic version=1.04
Test::Pod version=1.52
Test::Pod::Coverage version=1.10
Test::RequiresInternet version=0.05
Test::Simple version=1.302194
Test::UseAllModules version=0.17
Test::Warnings version=0.031
Test::Without::Module version=0.21
Test::YAML version=1.07
Text::Template version=1.61
Web::Scraper version=0.38
XML::XPathEngine version=0.14
XString version=0.005
YAML version=1.30
YAML::LibYAML version=0.86
mod_perl2 version=2.09
namespace::autoclean version=0.29

I would love to see the output of the above Perl script from the system 
having the issue.


Bruces-Virtual-High-Sierra:finance-quote bschuck$ pwd
/Users/bschuck/tmp/finance-quote
Bruces-Virtual-High-Sierra:finance-quote bschuck$ 
./Examples/currency-lookup.pl EUR USD

EUR->USD = 1.0763104

Thanks.

- Bruce S.


On 3/25/23 4:11 PM, Bruce Schuck wrote:

Thanks John.

Re: [GNC] Report Question

[R Losey]

Hi.

I don't consider myself accomplished regarding GnuCash Reports, but for
what you are wanting, it sounds like a spreadsheet is the perfect way to
go.  Maybe get the data into a spreadsheet, and then you can adjust it /
report it to your heart's content. If you find a good way to get a report
on just those accounts, it seems that (based on other emails here) you can
cut and paste the report data into a spreadsheet.


On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay  wrote:

> I have used gnucash for a few years, and have all of my investments sorted
> by account. To understand how my investments are distributed, it would be
> very convenient for me to have a report that computes the percentage of
> certain investments in the whole, e.g., the percent that is bonds. Is it
> possible for me to write a report in which I sort my investments and then
> compute quantities like percentages, etc.?
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Finance Quote problem MacOS High Sierra.

[Bruce Schuck]

Thanks John.

Coincidentally I just managed to install a High Sierra VM under 
VirtualBox on my MacBook w/Catalina.


I'll be taking a look at this soon.

- Bruce S.

On 3/25/23 3:47 PM, John Ralls wrote:

Bruce,

Versions:
Module::Load 0.36
Module::Load::Conditional 0.74
SelfLoader 1.24
AutoLoader 5.74

and for good measure
Perl 5.18.2

I ran perl -d:Trace 
.cpan/build/Finance-Quote-blah-blah/Examples/currency-lookup.pl EUR USD and 
attached the zipped result below. You might see a couple of unfamiliar strings, 
those are from print statements I'd inserted to try to see what was going on.

Regards,
John Ralls





On Mar 23, 2023, at 7:33 PM, Bruce Schuck  wrote:

On 03/23/23 9:21 PM, Bruce Schuck wrote:

What versions of those modules are on the 10.13 OS you have access to?

Can you update Module::Load and test again?

Perl does have two modules, Devel::Trace and Devel::DumpTrace.

I think the output of Devel::Trace may be more useful.

"perl -d:Trace /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v currency 
EUR USD 2>/tmp/foobar"

It creates a fairly large file, over 300k lines on my Catalina system where it 
is working. Starting on line 246638 I see the call to autoload and subsequent 
perl lines executed.

Just starting it as "perl -d /Applications/..." runs the script in a sort of 
gdb like environment. But I've always debugged using prints to stdout or Smart::Comments.

So if you or whoever is having issues on a High Sierra OS can install install 
Devel::Trace and provide me the output (I checked mine, my ALPHAVANTAGE API key 
is not exposed, but double check your output), I can maybe compare.

Thanks again.

- 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.

Re: [GNC] Error in "Close Book" help text

[Adrien Monteleone]

Aha, good to know Stan, thanks!

Regards,
Adrien

On 3/24/23 6:43 PM, Stan Brown wrote:

Thanks, Adrien.

I started at  then followed "Q: I
think I found a bug. How do I report it?" to
. From there I searched the bug
database as described under "Triage". Not finding my issue already
reported, I continued to "Commenting on existing bugs or entering new
ones" and to "Open a new GnuCash bug", at
.

I attach a screen shot of what I got. I just proceeded to fill in the
blanks, since the status of NEW (red ellipse) was already filled in. I
didn't try any of the menu selections (green ellipse), since I was
apparently already on the screen I needed. Now, following your email, I
see that I would have got the screen you showed if I had clicked that
apparently-redundant New, but in fairness I don't think there was any
way for me to know that up front.

All of that said, I got a notice that John Ralls had changed the bug
from General to Documentation. And he also emailed me to say that he was
going to fix up the Wiki page to avoid this problem for the future.


___
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] Error in "Close Book" help text

[Michael or Penny Novack]

On 3/25/2023 4:28 AM, David T. wrote:

Michael,

As a past documentation contributor, I'd assume any person taking up 
this bug would attempt to document the functionality of the newly 
added feature, regardless of the initial bug request.


David T.


What I meant is that it is easy for those inexperienced with 
bookkeeping, especially those who never did it the old way, to conflate 
"close the books" (as a logical operation) and "close the books" using 
this particular gnucash tool. We see lots of this sort of confusion with 
"opening the books" using the opening value wizard vs doing it the old 
fashioned way with explicit transaction(s)  to enter the initial values.


It might seem unnecessary since most newbies hopefully read the 
tutorial, etc. but some new to gnucash but experienced with other 
similar software (like QuickBooks  not Quicken) or very experienced 
with old fashioned bookkeeping might jump right in and do things the old 
way (without the shortcut/tools). This is also just like the 
(unexpected?) behavior that to specify options for a report you first 
run the report default and THEN  use edit=?options to specify the options.


Michael D Novack


___
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] Error in "Close Book" help text

[David T. via gnucash-user]

Michael,

As a past documentation contributor, I'd assume any person taking up this bug 
would attempt to document the functionality of the newly added feature, 
regardless of the initial bug request.

David T.​

On Mar 25, 2023, 02:31, at 02:31, Michael or Penny Novack 
 wrote:
>On 3/24/2023 5:48 PM, Adrien Monteleone wrote:
>> When you first click 'New' or 'File a Bug', you get the option to 
>> select Documentation. (see screenshot) I'm not sure if you can move
>it 
>> after filing, but if not, one of the devs can do that for you. 
>
>Care should be used in defining this bug. The documentation change 
>should make it clear that this refers to closing the books using the 
>built in clod=se the books tool.
>
>As opposed to the logical/bookkeeping process "close the books" itself 
>(possibly done without the tool, in other words, "manually". THOSE 
>transactions would probably not be recognized as special. In which case
>
>would still need to be careful to run the Income
>Statement/P/Statement 
>of Revenues and Expenses (the different names refer to how different 
>types of entities know this report) BEFORE closing the books.
>
>If LITERALLY modelling the old way, would have closed to a special 
>account with a name like P and then THAT closed to equity by the net 
>profit of loss that brings it to zero.
>
>
>Michael D Novack
>
>
>___
>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.
___
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] Error in "Close Book" help text

[David T. via gnucash-user]

If you've ever filled out an online form before, you should be fine. I'd simply 
copy your original email and paste it in the description. 

David T. 



On Mar 24, 2023, 11:44 PM, at 11:44 PM, Stan Brown  
wrote:
>Sigh. You're right, of course. I've never filed a bug report before, so
>I was hoping someone else would do it for me. But I'll figure it out --
>it's the least I can do in return for all the benefits I receive from
>using GnuCash.
>
>Stan Brown
>Tehachapi, CA, USA
>https://BrownMath.com
>
>On 2023-03-24 12:46, Adrien Monteleone wrote:
>> Maybe file a documentation bug for tracking?
>> 
>> Regards,
>> Adrien
>> 
>> On 3/23/23 6:06 PM, Stan Brown wrote:
>>> In 4.13, the Close Book help text, which is the Close Book section
>of
>>> the installed manual, includes the following text under "How It
>Works",
>>> as the second paragraph under "Necessity":
>>>
>>> "In fact, closing the books reduces the usefulness of the standard
>>> reports because the reports don’t currently understand closing
>>> transactions. So from their point of view it simply looks like the
>net
>>> income or expense in each account for a given period was simply
>zero. "
>>>
>>> That paragraph doesn't seem to be accurate any more. I closed the
>books
>>> in 4.13 and the ran an income statement for the full year. The
>account
>>> totals were given just as they were before I closed the book.
>>>
>>> Can whoever is maintaining the book look at deleting that paragraph,
>>> please? (And please note: This is the installed manual, not the one
>on
>>> the website. I have GnuCash running in a virtual machine with no
>>> Internet.)
>>>
>> 
>> ___
>> 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.
>___
>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.
___
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.