Re: [GNC] gnucash-cli --quotes get

I’m also only interested in the market closing price. The question is how will GnuCash handle multiple quotes for one day. Which one will actually be used to valuate the portfolio? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _

Re: [GNC] gnucash-cli --quotes get

Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not create a new one. Thanks. -- Sent from: h

[GNC] GnuCash sqlite backend on windows and linux

Hi everyone, Is the gnucash sqlite backend compatible between windows and linux? If, let's say, I keep the sqlite database on a network shared folder, can that database be open by one gnucash instance running on windows and another one running on linux, at different moments in time? Looking for

[GNC] Import accounts from CSV / new security

Hi everyone, When doing an "Import accounts from CSV" if the account is "stock" type, it will require a "security" (or commodity) as parameter. Is there any way to create the security through import, when it is a new one and it does not exist? TIA. -- Sent from: http://gnucash.1415818.n4.nabb

Re: [GNC] Building GnuCash from src distributions

Just to update you guys. The fedora 34 rpm, gnucash-4.5-1.fc34.x86_64.rpm, indeed includes the python bindings and the gnucash python module is properly install. Once the rpm is installed, the "import gnucash" in python is successful. Regarding building from sources, after trying a couple of rele

Re: [GNC] Building GnuCash from src distributions

Hi John, As recommended, I have tried Fedora's regular GnuCash RPM. Just by launching it, I don't have a way to validate that includes or not python bindings. The issue is that the gnucash python module cannot be installed. [@fedora ~]$ pip install gnucash Defaulting to user installation

Re: [GNC] Building GnuCash from src distributions

Hi Derek, I need GnuCash with python bindings. IAFAIk EPEL GnuCash package does not include the bindings. Can you please confirm this. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-

Re: [GNC] Building GnuCash from src distributions

Thank you John, How do I get support for build? I've sent two days ago a message to "GnuCash - Dev" but no answer. Here is the error I am getting: [**@CentOS-8dot1 gnucash-build]$ cat /home/**/gnucash-build/CMakeFiles/CMakeError.log Determining if the pthread_create exist failed with th

[GNC] Building GnuCash from src distributions

Since no GnuCash build with python bindings was ever provided, I have attempted to build one myself. I would be interested to hear why the dev team chose not to distribute binaries for GnuCash with python bindings. I spent couple of days working on this: - 3 different linux distributions - source

Re: [GNC] gnucash-cli --quotes get

Is there a build for GnuCash with python bindings (binaries) available anywhere? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preference

Re: [GNC] gnucash-cli --quotes get

Are GnuCash with python bindings binaries available anywhere? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] gnucash-cli --quotes get

Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucas

Re: [GNC] gnucash-cli --quotes get

I use a SQLite backend and I would love to test your script. Could you email it to me? Thanks. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscript

Re: [GNC] gnucash-cli --quotes get

I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code bellow in Gnucash::GnucashCli::start . Is another developer already working on the same functionality? if (m_quotes_cmd) { if (*m_quotes_cmd != "get") { std::cerr << bl::format (bl::tran

[GNC] gnucash-cli --quotes get

Can "gnucash-cli --quotes get" load quotes from a file, like the import prices from CSV does? Thanks. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your su

[GNC] Saved Import / Export configurations

Where are they stored? How do I transfer them from on gnucash file / database to another? Interested for Windows. TIA. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org

[GNC] multi-split CSV import

Is there a way to create a multi-split transaction using "import transactions from CSV" like the one in the picture? How should the csv record look like? TIA. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415

[GNC] Advanced portfolio report - same stock in multiple investment accounts

Hi everyone, I am using the advanced portfolio report for tracking multiple investment accounts for family members, less than 20. One major issue I am having is that reporting can be done only by "account" which is the security and no information about account hierarchy is available in the report

[GNC] Online quotes for currencies not working anymore

My GnuCash Installation stopped downloading online quotes for currencies ten days ago. I am using 5 different currencies and I am only getting "unable to retrieve quotes for ..." error only for 3 of them. See attached picture. Looking for some ideea on how to troubleshot something like this. Who i

[GNC] Online quotes for currencies not working anymore

My GnuCash Installation stopped downloading online quotes for currencies ten days ago. I am using 5 different currencies and I am only getting "unable to retrieve quotes for ..." error only for 3 of them. See attached picture. Looking for some ideea on how to troubleshot something like this. Who i

Re: [GNC] Online quotes for Canadian Mutual Funds

Just to update you guys, Finance Quote 1.50 RC1 includes fixes for Canadian Mutual Funds. Tested, everything works fine. Details here -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

[GNC] Online quotes for Canadian Mutual Funds

I have tried a couple of providers (bmonesbittburns, canadamutual, fundlibrary) but none of them seems to be working. Any suggestions? >perl "***\gnucash\bin\gnc-fq-dump" -v bmonesbittburns TDB902 Parsing of undecoded UTF-8 will give garbage when decoding entities at D:/tools/Strawberry/perl/site/

[GNC] Bug in Advanced Portfolio report when Shares < 0

When Shares < 0, Money In is always zero & Money Out does not have correct value as it supposed to be a negative number. This would be the case for short positions. Thank you for looking into this issue. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

[GNC] gnucash-cli --report run: multiple errors

Hi everyone, I am wondering if anyone was able to use "gnucash-cli --report run'. I have tried multiple reports, and not one single was successful: 1. one standard report: gnucash-cli --debug --report run --name "Advanced Portfolio" --export-type csv --output-file "apa.csv" "file.sqlite3.gnucash"

[GNC] Getting the value of a "stock" type account in the currency of the account

Is there any way of getting the value of a "stock" type account in the currency of the account, in the "Accounts" tab. Default behavior is to use the commodity of the account, instead of currency. -- Sent from: http://gnucash.1

[GNC] What is the purpose of the row at the bottom of a "stock" type account?

-- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsu

[GNC] What is the purpose of the row at the bottom of an "stock" type account?

-- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsu

Re: [GNC] quotes for stock options

Yes, that is my opinion as well. Is there any other source for US options? I was thinking to use "Import prices from CSV file" and load them from an external file. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucas

[GNC] quotes for stock options

I am wondering what people are using for downloading quotes for US stock options. I am currently using yahoo_json, which works fine for stocks but it is not reliable for stock options. D:\>perl "D:\tools\gnucash\bin\gnc-fq-dump" -v yahoo_json SPY211217C00325000 Finance::Quote fields Gnucash uses:

Re: [GNC] 4.2 on Windows 10 keeps randomly crashing

The number already existing there had a comma, it was "139,625.00" -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubs

Re: [GNC] 4.2 on Windows 10 keeps randomly crashing

No comma but a long number. "138.56250" -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucas

[GNC] 4.2 on Windows 10 keeps randomly crashing

My new installation of 4.2 on Windows 10 keeps randomly crashing. Maybe 10 times in the last two weeks. Version 3 was extremely stable, have not seen a crash in years. Today it happen 5 times while I was trying to enter a new stock buying transaction as following: - duplicated an existing transac

Re: [GNC] Issues with Balance Sheet report in 4.2

It is more than the hierarchy. Subaccounts are missing on some levels - this is the highest criticality. Look at the pictures I've sent before. The report shows the Account Taxation Class ( RRSP | TFSA ) but does not show the Account Owner. The report calculates the Cash Balance but it does not

Re: [GNC] Issues with Balance Sheet report in 4.2

One other bug I noticed is that the order of the accounts on the same level is also wrong. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Issues with Balance Sheet report in 4.2

When all accounts are selected, the report works fine. The thing is that I only need a few accounts, not all, in the report. The relevant "Chart of Accounts" looks like this: Assets

Re: [GNC] Issues with Balance Sheet report in 4.2

Part of the balance sheet report in the picture below. Assets is level 0, RRSP & TFSA level 3, Oaken level 4, CAD & ZST.TO level 5. Level 2 and most level 4 accounts are not being displayed Options

Re: [GNC] Issues with Balance Sheet report in 4.2

I definitely do not understand what you are trying to say. - Are talking about "Balance Sheet (eguile)" report or "Balance Sheet"? - You are using "nesting" term in context of report options but there is no such option. - "CoA" is an acronim for what ? The issues I have mentioned are presen

Re: [GNC] Issues with Balance Sheet report in 4.2

"Include accounts with zero balances" & "Omit zero balance figures" both unchecked. It does not make any difference if I change them / any combination checked - unchecked. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html __

Re: [GNC] Issues with Balance Sheet report in 4.2

I also looked into the "Balance Sheet (eguile)" report as well and while this one does indenting properly and shows all subaccount levels, it does not allow account selection. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html __

Re: [GNC] Issues with Balance Sheet report in 4.2

If you are referring to "Levels of Subaccounts" setting from Accounts options tab, it is set to 6. The balances I am trying to report are usually one or two levels lower. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

[GNC] Issues with Balance Sheet report in 4.2

Hi everyone, I have noticed a couple of bugs in Balance Sheet report in GnuCash 4.2: 1. some subaccounts seem to be missing randomly. Let's say that for an subaccount of level 5, I would expect to see all accounts of higher level above, like this: account-of-level-0 account-of-level-1

Re: [GNC] Just installed 4.2

Will, I did what you did, closed GnuCash and started for the second time. I got an error on closing "cannot save database" I believe, but the second time Net Work Line Chart works just fine. Still have the error in top of the Advanced Portfolio report. -- Sent from: http://gnucash.1415818.n4.

Re: [GNC] Error with Advanced portfolio report

Continuing discussion here http://gnucash.1415818.n4.nabble.com/GNC-Just-installed-4-2-tp4721803.html, 4.2 dedicated thread. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucas

Re: [GNC] Just installed 4.2

Windows 10 x64, with SQLite. Both reports work fine on 3.11. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Just installed 4.2

... and did a bit of testing. Advanced portfolio report, although is better than in 4.1 (no crash in 4.2) still throws an error: > Error > > There is an error processing the transaction 'buying .0200 share units'. > This may to be caused by a sell transaction causing a negative stock > balance,

Re: [GNC] Error with Advanced portfolio report

You were 100% right. 4.2 was just released. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.g

Re: [GNC] Error with Advanced portfolio report

Got it. Any chance you can estimate the new date for us? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: htt

Re: [GNC] Error with Advanced portfolio report

Are you guys releasing 4.2 today, as scheduled? TIA. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https:/

Re: [GNC] Error with Advanced portfolio report

Sorry, I meant 4.1. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listin

Re: [GNC] Error with Advanced portfolio report

Thank you John. It is good to know that a fix is coming. I had to rollback 4.0 installation because of a bug in the command line utility and 4.1 due to the advanced portfolio report error. Both issues have been raised here and while the first one got a reply from the dev team, the report one seemed

Re: [GNC] Error with Advanced portfolio report

It is a bug and it was reported at least 5 times since 4.2 was released. Never got any attention for the dev team. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To u