Re: [GNC] Fwd: Price Source "Last up through Report Date" issue

[David Carlson]

Geoff,

Interesting theory and perhaps that is the source of this anomaly.  I
cannot see these timestamps in the normal price database view, but I can
say that most of the price records that were involved in both reports were
probably collected online by the Finance-Quote method, usually between
10:00 pm and 2:00 am Central time.  I think that I ran the May 31 report
this morning and the June 30 report tonight.

However, if that turns out to be the case, I would expect GnuCash to
perform the calculations on normalized dates with the times truncated out
so this would not affect the reports.  I have created a bug report <
https://bugs.gnucash.org/show_bug.cgi?id=798622> so that we can track the
problem.

On Mon, Sep 26, 2022 at 11:35 PM Geoff  wrote:

> Hi David
>
> This is a longshot: I noticed that records in the Prices table have a
> timestamp, see attached screenshot.
>
> So, perhaps, you ran the report for the 31st in the morning and the
> prices had an afternoon timestamp?
>
> You could inspect your Prices and run the report at different times of
> the day to test this conjecture.
>
> Regards
>
> Geoff
> =
>
> On 27/09/2022 2:17 pm, David Carlson wrote:
> > This is odd.  While prices that were picked by GnuCash for the Tuesday,
> May
> > 31 dated account balance sheet report were actually the last prices in
> the
> > data before May 31, possibly several days earlier when there were prices
> > for every security actually dated May 31, the report which I created
> later
> > for Thursday June 30 picked the prices actually dated June 30.  There
> were
> > also prices dated June 29 and July 1 in the data for most or all the
> > securities in the report. Why is May 31 an outlier?
> >
> > -- Forwarded message -
> > From: David Carlson 
> > Date: Mon, Sep 26, 2022 at 4:15 PM
> > Subject: Price Source "Last up through Report Date" issue
> > To: gnucash-user@gnucash.org 
> >
> >
> > I finally had a real test for this price source while running an account
> > report for May 31, 2022 in release 4.8, which I only recently adopted.
> > Unfortunately, it took prices from May 30 for this report, which is not
> > exactly as described by the title.  Has this been corrected since release
> > 4.8?
> >



-- 
David Carlson
___
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] Fwd: Price Source "Last up through Report Date" issue

[Geoff]

Hi David

This is a longshot: I noticed that records in the Prices table have a 
timestamp, see attached screenshot.


So, perhaps, you ran the report for the 31st in the morning and the 
prices had an afternoon timestamp?


You could inspect your Prices and run the report at different times of 
the day to test this conjecture.


Regards

Geoff
=

On 27/09/2022 2:17 pm, David Carlson wrote:

This is odd.  While prices that were picked by GnuCash for the Tuesday, May
31 dated account balance sheet report were actually the last prices in the
data before May 31, possibly several days earlier when there were prices
for every security actually dated May 31, the report which I created later
for Thursday June 30 picked the prices actually dated June 30.  There were
also prices dated June 29 and July 1 in the data for most or all the
securities in the report. Why is May 31 an outlier?

-- Forwarded message -
From: David Carlson 
Date: Mon, Sep 26, 2022 at 4:15 PM
Subject: Price Source "Last up through Report Date" issue
To: gnucash-user@gnucash.org 


I finally had a real test for this price source while running an account
report for May 31, 2022 in release 4.8, which I only recently adopted.
Unfortunately, it took prices from May 30 for this report, which is not
exactly as described by the title.  Has this been corrected since release
4.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.

[GNC] Fwd: Price Source "Last up through Report Date" issue

[David Carlson]

This is odd.  While prices that were picked by GnuCash for the Tuesday, May
31 dated account balance sheet report were actually the last prices in the
data before May 31, possibly several days earlier when there were prices
for every security actually dated May 31, the report which I created later
for Thursday June 30 picked the prices actually dated June 30.  There were
also prices dated June 29 and July 1 in the data for most or all the
securities in the report. Why is May 31 an outlier?

-- Forwarded message -
From: David Carlson 
Date: Mon, Sep 26, 2022 at 4:15 PM
Subject: Price Source "Last up through Report Date" issue
To: gnucash-user@gnucash.org 


I finally had a real test for this price source while running an account
report for May 31, 2022 in release 4.8, which I only recently adopted.
Unfortunately, it took prices from May 30 for this report, which is not
exactly as described by the title.  Has this been corrected since release
4.8?

-- 
David Carlson


-- 
David Carlson
___
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 in GC 4.11 Flatpak

[Murugan Muruganandam]

Geoff

thanks so much, it works perfectly for me in windows, i replaced the 
AlphaVantage.pm file with the FX_Daily code




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Geoff 
Sent: Monday, September 26, 2022 9:48 PM
To: rsbrux ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Finance::Quote in GC 4.11 Flatpak

CAVEAT:- I am not familiar with FlatPak.

1. See 3b.

2. I personally have no idea, but discussion on the pull request you
cited says YES.

3a.
https://raw.githubusercontent.com/shirayu/finance-quote/9aee4b6d06da8a0e689b751d0e926160fb99d71b/lib/Finance/Quote/CurrencyRates/AlphaVantage.pm

3b.  Follow these steps to locate and replace your current
AlphaVantage.pm file:-

3b.1  Save the file from 3a (plain text) as AlphaVantage.pm in a
temporary location.

3b.2  Find the current copy of AlphaVantage.pm on your machine - run
something like this command:
   sudo find / -name AlphaVantage.pm -print

3b.3  Rename the current copy of AlphaVantage.pm in that location to
something like AlphaVantage.pm.BACKUP

3b.4   Copy the AlphaVantage.pm file from 3b.1 to that location.

4.  If the above makes things worse, simply delete the new file and
rename the backup file.

Good luck!

Geoff
=


On 27/09/2022 1:43 am, rsbrux via gnucash-user wrote:
> I have installed my free AlphaVantage API key in /etc/environment, but when I 
> try to "Get Quotes", I get the well-known message "Unable to retrieve quotes 
> for these items:, CURRENCY:  ...".  I presume that this is due to the problem 
> reported on the page 
> https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:
>
>>>
> GnuCash stopped being able to retrieve currency exchange rates using a free 
> AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
> method F::Q used to obtain exchange rates unavailable for free API keys.
>
> F::Q has been modified to work with free API keys and the fix should be 
> available in the next F::Q version (1.53).
> <<
>
> By running "gnc-fq-check" in a console running "flatpak run --command=sh 
> org.gnucash.GnuCash" I found that the F::Q version in my Flatpak installation 
> is 1.49.  Obviously, I would like to update F::Q to version 1.53.   I tried 
> running "gnc-fq-update" from within "flatpak run --command=sh 
> org.gnucash.GnuCash", but it fails from a normal account (presumably due to 
> inadequate priveleges), and "sudo flatpak run --command=sh 
> org.gnucash.GnuCash" doesn't work either, nor does running "flatpak run 
> --command=sh org.gnucash.GnuCash" after having used "su " to 
> invoke it with higher privileges.
>
> 1. How can I update F::Q in my Flatpak installation?
>
> 2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
> metacpan.
>
> 3. I looked at the workaround 
> (https://github.com/finance-quote/finance-quote/pull/230), but it isn't clear 
> to me:
>
> a. How to obtain the updated AlphaVantage.pm from github pull #230?
>
> b. How to apply it to the flatpak environment?
>
>
>
> ___
> 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.

Re: [GNC] Finance::Quote in GC 4.11 Flatpak

[Geoff]

CAVEAT:- I am not familiar with FlatPak.

1. See 3b.

2. I personally have no idea, but discussion on the pull request you 
cited says YES.


3a. 
https://raw.githubusercontent.com/shirayu/finance-quote/9aee4b6d06da8a0e689b751d0e926160fb99d71b/lib/Finance/Quote/CurrencyRates/AlphaVantage.pm


3b.  Follow these steps to locate and replace your current 
AlphaVantage.pm file:-


3b.1  Save the file from 3a (plain text) as AlphaVantage.pm in a 
temporary location.


3b.2  Find the current copy of AlphaVantage.pm on your machine - run 
something like this command:

  sudo find / -name AlphaVantage.pm -print

3b.3  Rename the current copy of AlphaVantage.pm in that location to 
something like AlphaVantage.pm.BACKUP


3b.4   Copy the AlphaVantage.pm file from 3b.1 to that location.

4.  If the above makes things worse, simply delete the new file and 
rename the backup file.


Good luck!

Geoff
=


On 27/09/2022 1:43 am, rsbrux via gnucash-user wrote:

I have installed my free AlphaVantage API key in /etc/environment, but when I try to "Get 
Quotes", I get the well-known message "Unable to retrieve quotes for these items:, 
CURRENCY:  ...".  I presume that this is due to the problem reported on the page 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:




GnuCash stopped being able to retrieve currency exchange rates using a free 
AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
method F::Q used to obtain exchange rates unavailable for free API keys.

F::Q has been modified to work with free API keys and the fix should be 
available in the next F::Q version (1.53).
<<

By running "gnc-fq-check" in a console running "flatpak run --command=sh org.gnucash.GnuCash" I found that the F::Q version in my 
Flatpak installation is 1.49.  Obviously, I would like to update F::Q to version 1.53.   I tried running "gnc-fq-update" from within 
"flatpak run --command=sh org.gnucash.GnuCash", but it fails from a normal account (presumably due to inadequate priveleges), and "sudo 
flatpak run --command=sh org.gnucash.GnuCash" doesn't work either, nor does running "flatpak run --command=sh org.gnucash.GnuCash" after 
having used "su " to invoke it with higher privileges.

1. How can I update F::Q in my Flatpak installation?

2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
metacpan.

3. I looked at the workaround 
(https://github.com/finance-quote/finance-quote/pull/230), but it isn't clear 
to me:

a. How to obtain the updated AlphaVantage.pm from github pull #230?

b. How to apply it to the flatpak environment?

  


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

[GNC] GC4.12 OFX Import

[David Cousens]

Hi, 

Just tried importing an OFX file in GC 4.12 on Linux Mint 22. The multiple
transaction selection in the Import Matcher to assign the same transfer account
to multiple transactions seems to no longer be functioning. Using the CTRl mouse
click to add to the selection appears to have been disabled but the SHIFT click
to add a range of transactions to the selection still seems to be functioning.

The funny thing is after a bit more experimentation, the left CTRL Mouse click
works to add to the selection but the right CTRL Mouse click doesnt'. This might
not be a GnuCash issue but may be either the GTK library or the Linux Mint
keyboard driver. Haven't noticed it in other programs but I don't use that
capability often in other programs but will test it out.

David Cousens
___
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.

[GNC] Price Source "Last up through Report Date" issue

[David Carlson]

I finally had a real test for this price source while running an account
report for May 31, 2022 in release 4.8, which I only recently adopted.
Unfortunately, it took prices from May 30 for this report, which is not
exactly as described by the title.  Has this been corrected since release
4.8?

-- 
David Carlson
___
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] Register sort order

[finance]

I use the ISO 8601 format in the num column - sorts just fine and 
doesn't matter if it sorts as text or alphabetically.

https://en.wikipedia.org/wiki/ISO_8601
___
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] Register sort order

[Adrien Monteleone]

On 9/26/22 10:35 AM, Derek Atkins wrote:

The "number" column is actually treated as a number!  So it is not sorted
lexically but sorted numerically.  That means 090 will come before 0190.

If you have a "number" with a non-numeric piece, it will only sort up to
that non-numeric piece, so 1a and 1b will sort "the same", as will d1 and
d2.

I thought that had changed a few versions back.

I use the NUM field for a time stamp to force my register order, because 
more often than not, I do not enter transactions in the order they 
happen, so using a time stamp on a receipt keeps them in line.


I used to use 24hr notation with a 't' appended to indicate to me that 
this was a time stamp and not an actual transaction number. (which 
sometimes I do have)


But a few versions ago, the sorting was changed so that alpha characters 
sort lexically and then the sort continues, though I think in that case, 
all subsequent characters are also sorted lexically. (and maybe even the 
whole thing, I haven't tested)


So now I can enter say, "14:35" instead of "1435t" as my time stamp and 
it sorts properly, without stopping at the ":".


Regards,
Adrien


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

[GNC] Finance::Quote in GC 4.11 Flatpak

[rsbrux via gnucash-user]

I have installed my free AlphaVantage API key in /etc/environment, but when I 
try to "Get Quotes", I get the well-known message "Unable to retrieve quotes 
for these items:, CURRENCY:  ...".  I presume that this is due to the problem 
reported on the page 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:

>>
GnuCash stopped being able to retrieve currency exchange rates using a free 
AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
method F::Q used to obtain exchange rates unavailable for free API keys.

F::Q has been modified to work with free API keys and the fix should be 
available in the next F::Q version (1.53).
<<

By running "gnc-fq-check" in a console running "flatpak run --command=sh 
org.gnucash.GnuCash" I found that the F::Q version in my Flatpak installation 
is 1.49.  Obviously, I would like to update F::Q to version 1.53.   I tried 
running "gnc-fq-update" from within "flatpak run --command=sh 
org.gnucash.GnuCash", but it fails from a normal account (presumably due to 
inadequate priveleges), and "sudo flatpak run --command=sh org.gnucash.GnuCash" 
doesn't work either, nor does running "flatpak run --command=sh 
org.gnucash.GnuCash" after having used "su " to invoke it with 
higher privileges.

1. How can I update F::Q in my Flatpak installation?

2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
metacpan.

3. I looked at the workaround 
(https://github.com/finance-quote/finance-quote/pull/230), but it isn't clear 
to me:

a. How to obtain the updated AlphaVantage.pm from github pull #230?

b. How to apply it to the flatpak environment?

 

___
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] Register sort order

[Gyle McCollam]

Derek,
Thank you for the quick response.  I was obviously missing something and I feel 
like an idiot.
191774074 is larger than 092022 and would sort after!


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: Derek Atkins 
Sent: Monday, September 26, 2022 11:35 AM
To: Gyle McCollam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Register sort order

Hi,

On Mon, September 26, 2022 11:25 am, Gyle McCollam wrote:
> I would like to control the order that items are displayed in the
> register.  I use the standard sort order as that has multiple sort
> criteria and the other options only show one.  However, the Standard Sort
> Order shows:
>
> Keep normal order: date posted [day], number, date entered [second] [a] ,
> description.
>
>
> In the attached JPEG there are 4 transactions.  They are all posted as
> 09/26/2022 and appear to be sorted on the 2nd criteria "number".  However,
> when I change the 4th transaction, which currently starts with a 19 while
> all the others start with 09, to 0191774074, it still is listed 4th.  You
> would think 01 would be before 09, but it doesn't change the order.

The "number" column is actually treated as a number!  So it is not sorted
lexically but sorted numerically.  That means 090 will come before 0190.

If you have a "number" with a non-numeric piece, it will only sort up to
that non-numeric piece, so 1a and 1b will sort "the same", as will d1 and
d2.

> Originally, I thought it would be better to have a sort order that was
> based on Date, Debit/Credit, but I can manipulate the standard order
> exactly how I want it to display if it actually sorted as it says it does.
>  Am I missing something that is causing the "number" criteria to not sort
> correctly.  If I remove the number completely it moves it to the 1st
> position, but if I insert a blank in the first character it has no effect.

Possibly.  See above.

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Register sort order

[Derek Atkins]

Hi,

On Mon, September 26, 2022 11:25 am, Gyle McCollam wrote:
> I would like to control the order that items are displayed in the
> register.  I use the standard sort order as that has multiple sort
> criteria and the other options only show one.  However, the Standard Sort
> Order shows:
>
> Keep normal order: date posted [day], number, date entered [second] [a] ,
> description.
>
>
> In the attached JPEG there are 4 transactions.  They are all posted as
> 09/26/2022 and appear to be sorted on the 2nd criteria "number".  However,
> when I change the 4th transaction, which currently starts with a 19 while
> all the others start with 09, to 0191774074, it still is listed 4th.  You
> would think 01 would be before 09, but it doesn't change the order.

The "number" column is actually treated as a number!  So it is not sorted
lexically but sorted numerically.  That means 090 will come before 0190.

If you have a "number" with a non-numeric piece, it will only sort up to
that non-numeric piece, so 1a and 1b will sort "the same", as will d1 and
d2.

> Originally, I thought it would be better to have a sort order that was
> based on Date, Debit/Credit, but I can manipulate the standard order
> exactly how I want it to display if it actually sorted as it says it does.
>  Am I missing something that is causing the "number" criteria to not sort
> correctly.  If I remove the number completely it moves it to the 1st
> position, but if I insert a blank in the first character it has no effect.

Possibly.  See above.

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

[GNC] Register sort order

[Gyle McCollam]

I would like to control the order that items are displayed in the register.  I 
use the standard sort order as that has multiple sort criteria and the other 
options only show one.  However, the Standard Sort Order shows:

Keep normal order: date posted [day], number, date entered [second] [a] , 
description.


In the attached JPEG there are 4 transactions.  They are all posted as 
09/26/2022 and appear to be sorted on the 2nd criteria "number".  However, when 
I change the 4th transaction, which currently starts with a 19 while all the 
others start with 09, to 0191774074, it still is listed 4th.  You would think 
01 would be before 09, but it doesn't change the order. Originally, I thought 
it would be better to have a sort order that was based on Date, Debit/Credit, 
but I can manipulate the standard order exactly how I want it to display if it 
actually sorted as it says it does.  Am I missing something that is causing the 
"number" criteria to not sort correctly.  If I remove the number completely it 
moves it to the 1st position, but if I insert a blank in the first character it 
has no effect.


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