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

2022-09-26 Thread 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

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

2022-09-26 Thread 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

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

2022-09-26 Thread 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

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

2022-09-26 Thread 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 ;

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

2022-09-26 Thread 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.

[GNC] GC4.12 OFX Import

2022-09-26 Thread 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

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

2022-09-26 Thread 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? --

Re: [GNC] Register sort order

2022-09-26 Thread 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

Re: [GNC] Register sort order

2022-09-26 Thread 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

[GNC] Finance::Quote in GC 4.11 Flatpak

2022-09-26 Thread 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

Re: [GNC] Register sort order

2022-09-26 Thread 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

Re: [GNC] Register sort order

2022-09-26 Thread 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: > >

[GNC] Register sort order

2022-09-26 Thread 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] ,