Re: [GNC] [resolved, sort-of] Re: no drop-down accounts list in ledger Transfer column.
I think that I am in a somewhat similar position to Mike. My Linux
machines happen to be virtual machines that are, for me, test cases for
older hardware with modest resources. When I looked into flatpak it
appeared that it would use a lot more resources yet would be tricky to set
up some functions that involve interfaces for example to external hardware
such that I just wasn't ready to make the intellectual investment in
learning to use flatpak. Someone would still have to sell me on using
flatpak.
On Wed, May 8, 2024, 7:17 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Any opposition to using flatpak? You wouldn't have to wait.
>
> Regards,
> Adrien
>
> On 5/8/24 3:18 AM, v@scottsonline.org.uk wrote:
> > That could explain things. Unfortunately, I can't (readily) install 4.13
> > on mint - even the latest mint 21.3 has libraries too old for the deb's
> > off the website. But thanks for the info - at least I can look forward
> > to the next mint upgrade that should sort things. Meanwhile, I can
> > muddle through :-{
> >
> > Thanks to you and to Adrien for replying.
> >
> >
>
> ___
> 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] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
Kalpesh,
I think your price has too many digits. Try rounding it to 10E-9.
Regards,
John Ralls
> On May 8, 2024, at 09:05, Kalpesh Patel wrote:
>
> Hi GNC User community -
>
>
>
> I am developing a second F::Q module of my own. The first one works fine but
> second one seems to NOT want to work no matter what. I am in middle of
> debugging it and it has stomped me why not so hoping someone might be able
> to help me zero in where I am falling sort on the flow for it. I am working
> with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on
> Windows 11. (Note: I don't believe any interface change has taken place in
> GNC v5.x that would cause this but correct me here if I am wrong.).
>
>
>
> Invoking GNC with debug shows that return value is #f, which means something
> went wrong (run_executor is the "label" for my module and other modules work
> fine from the debug output):
>
>
>
> 11:19:24 DEBUG handling-request: (currency INR USD)
>
> * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone .
> 2024-05-08 11:19:11) (last . 3/250) (currency . USD)))
>
> * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY
>
> * 11:20:39 DEBUG handling-request: (tsp C S L2030 I)
>
> * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S)
> (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD))
> (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last .
> 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD)))
>
> * 11:20:43 DEBUG handling-request: (run_executor BK)
>
> * 11:20:43 DEBUG results: (#f)
>
> * 11:20:43 DEBUG handling-request: (yahoojson ^NYA)
>
> * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone
> . 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD)))
>
>
>
> Following is debug run from command line of gnc-fq-dump (which provides all
> necessary fields for quote to be valid as it does not show '** This stock
> quote cannot be used by GnuCash!' message):
>
>
>
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
> run_executor BK
>
> {snip}
>
> ### [Wed May 8 11:34:40 2024] %info : {
>
> ###'BKISIN' => '-',
>
> ###'BKcurrency' => 'USD',
>
> ###'BKdate' => '05/08/2024',
>
> ###'BKisodate' => '2024-05-08',
>
> ###'BKmethod' => 'run_executor',
>
> ###'BKprice' => '57.64500045776367',
>
> ###'BKsuccess' => '1',
>
> ###'BKsymbol' => 'BK',
>
> ###'BKtimezone' => 'EDT'
>
> ### }
>
> Finance::Quote fields Gnucash uses:
>
> symbol: BK <=== required
>
>date: 05/08/2024 <=== recommended
>
> currency: USD <=== required
>
>last: <=\
>
> nav: <=== one of these
>
> price: 57.64500045776367<=/
>
> timezone: EDT <=== optional
>
>
>
> All fields returned by Finance::Quote for stock BK
>
>
>
> stock field value
>
> - - -
>
> BK ISIN: -
>
> BK currency: USD
>
> BK date: 05/08/2024
>
> BKisodate: 2024-05-08
>
> BK method: run_executor
>
> BK price: 57.64500045776367
>
> BKsuccess: 1
>
> BK symbol: BK
>
> BK timezone: EDT
>
>
>
>
>
> C:\Users\kalpesh>
>
>
>
> When running same command via YahooJSON following is the output which works
> fine (I see that it does have more information returned back):
>
>
>
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
> yahoojson BK
>
> {snip}
>
> Finance::Quote fields Gnucash uses:
>
> symbol: BK <=== required
>
>date: 05/08/2024 <=== recommended
>
> currency: USD <=== required
>
>last: 57.605 <=\
>
> nav: <=== one of these
>
> price: <=/
>
> timezone: <=== optional
>
>
>
> All fields returned by Finance::Quote for stock BK
>
>
>
> stock field value
>
> - - -
>
> BK close: 57.4
>
> BK currency: USD
>
> BK date: 05/08/2024
>
> BK div_yield: 2.8397212
>
> BKeps: 3.99
>
> BK exchange: NYSE
>
> BK high: 57.75
>
> BKisodate: 2024-05-08
>
> BK last: 57.605
>
> BK
Re: [GNC] [resolved, sort-of] Re: no drop-down accounts list in ledger Transfer column.
Any opposition to using flatpak? You wouldn't have to wait.
Regards,
Adrien
On 5/8/24 3:18 AM, v@scottsonline.org.uk wrote:
That could explain things. Unfortunately, I can't (readily) install 4.13
on mint - even the latest mint 21.3 has libraries too old for the deb's
off the website. But thanks for the info - at least I can look forward
to the next mint upgrade that should sort things. Meanwhile, I can
muddle through :-{
Thanks to you and to Adrien for replying.
___
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] Minor suggestion for gnucache-guide
Hi, I'm very new to GNUCash. After importing QIF file from Quicken I was struggling for several days trying to figure out why the Checking Register didn't display the cents decimal (USD). Searched everywhere and was surprised to find no answer. I finally tried */Accounts>>CHECKING>>[right click) Edit Account>>Smallest fraction/*. After setting it to 1/100, the problem was resolved. Although there is a Preference in Numbers, Date, Time that I would have thought should correct the problem when set to 2 Decimal places, it did not. This would be an ideal place to refer the new user to the "Smallest fraction" setting. In the gnucache-guide documentation, when searching for "decimal" There were 2 references to "decimal" but these did not relate to the account registry preferences. In the guide, the reference to "Smallest fraction" should also state the the decimal value of the account register could be effected. Thank you for what is apparent to be hard work. MikeNH ___ 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] An external tool to edit securities in Gnucash books
All, I've written a small tool that augments the Gnucash security editor. Currently it has only one noteworthy feature: adding a stock ticker by automatically looking it up by ISIN: $ tickers add test.gnucash US6903701018 +---+++++--+ | Namespace | Name | Symbol | Display Symbol | ISIN | Fraction | +---+++++--+ | NYQ | Beyond, Inc. | BYON | BYON | US6903701018 | 1/1 | +---+++++--+ Do you want to add this security? (yes/no) [no] y I also plan to add import/export features. My personal use-case is to migrate a security database from one Gnucash book to another. The code is on Github[1] and also might be a good start if you were ever interested in writing Python programs using Gnucash bindings. Let me know if you have any questions. If this is something that could be useful to you too, feel free to try it out and file issue reports if you encounter any problems. Best regards, -- Edward [1] https://github.com/hades/gnucash-tickers/ publickey - gnucash@hades.name - 0x313E7073.asc Description: application/pgp-keys signature.asc Description: OpenPGP digital signature ___ 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] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
Hi GNC User community -
I am developing a second F::Q module of my own. The first one works fine but
second one seems to NOT want to work no matter what. I am in middle of
debugging it and it has stomped me why not so hoping someone might be able
to help me zero in where I am falling sort on the flow for it. I am working
with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on
Windows 11. (Note: I don't believe any interface change has taken place in
GNC v5.x that would cause this but correct me here if I am wrong.).
Invoking GNC with debug shows that return value is #f, which means something
went wrong (run_executor is the "label" for my module and other modules work
fine from the debug output):
11:19:24 DEBUG handling-request: (currency INR USD)
* 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone .
2024-05-08 11:19:11) (last . 3/250) (currency . USD)))
* 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY
* 11:20:39 DEBUG handling-request: (tsp C S L2030 I)
* 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone .
2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S)
(gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD))
(L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last .
237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone .
2024-05-07 12:00:00) (last . 42507/1000) (currency . USD)))
* 11:20:43 DEBUG handling-request: (run_executor BK)
* 11:20:43 DEBUG results: (#f)
* 11:20:43 DEBUG handling-request: (yahoojson ^NYA)
* 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone
. 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD)))
Following is debug run from command line of gnc-fq-dump (which provides all
necessary fields for quote to be valid as it does not show '** This stock
quote cannot be used by GnuCash!' message):
C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
run_executor BK
{snip}
### [Wed May 8 11:34:40 2024] %info : {
###'BKISIN' => '-',
###'BKcurrency' => 'USD',
###'BKdate' => '05/08/2024',
###'BKisodate' => '2024-05-08',
###'BKmethod' => 'run_executor',
###'BKprice' => '57.64500045776367',
###'BKsuccess' => '1',
###'BKsymbol' => 'BK',
###'BKtimezone' => 'EDT'
### }
Finance::Quote fields Gnucash uses:
symbol: BK <=== required
date: 05/08/2024 <=== recommended
currency: USD <=== required
last: <=\
nav: <=== one of these
price: 57.64500045776367<=/
timezone: EDT <=== optional
All fields returned by Finance::Quote for stock BK
stock field value
- - -
BK ISIN: -
BK currency: USD
BK date: 05/08/2024
BKisodate: 2024-05-08
BK method: run_executor
BK price: 57.64500045776367
BKsuccess: 1
BK symbol: BK
BK timezone: EDT
C:\Users\kalpesh>
When running same command via YahooJSON following is the output which works
fine (I see that it does have more information returned back):
C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
yahoojson BK
{snip}
Finance::Quote fields Gnucash uses:
symbol: BK <=== required
date: 05/08/2024 <=== recommended
currency: USD <=== required
last: 57.605 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
All fields returned by Finance::Quote for stock BK
stock field value
- - -
BK close: 57.4
BK currency: USD
BK date: 05/08/2024
BK div_yield: 2.8397212
BKeps: 3.99
BK exchange: NYSE
BK high: 57.75
BKisodate: 2024-05-08
BK last: 57.605
BKlow: 57.12
BK method: yahoo_json
BK name: BK (The Bank of New York Mellon Cor)
BK open: 57.23
BK pe: 14.437344
BKsuccess: 1
BK symbol: BK
BK type: EQUITY
BK volume: 730814
BK year_range:39.65 - 58.28
C:\Users\kalpesh>
Given that, why would GNC not accept the pricing? Does it have to be in a
particular order what is returned back, or
[GNC] [resolved, sort-of] Re: no drop-down accounts list in ledger Transfer column.
On 07/05/2024 16:44, John Ralls wrote:
IIRC this was a bug having to do with computing the box size for the list on
certain window managers. It took Bob Fewell several tries to get it fixed so
unfortunately the fix is to upgrade. You may be able to use the 4.13 .deb from
the Debian Archive, see
https://wiki.gnucash.org/wiki/Debian#Using_the_Debian_Archive.
Regards,
John Ralls
That could explain things. Unfortunately, I can't (readily) install 4.13
on mint - even the latest mint 21.3 has libraries too old for the deb's
off the website. But thanks for the info - at least I can look forward
to the next mint upgrade that should sort things. Meanwhile, I can
muddle through :-{
Thanks to you and to Adrien for replying.
--
Mike Scott
Harlow, Essex, England
___
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.
