Re: [GNC] Commodity is currently used...

[Fred Tydeman]

Thank you.  That idea works for me.

On Sat, Sep 28, 2024 at 2:48 PM Murugan Mariappan <
m.muruganan...@hotmail.com> wrote:

>
> You can generate a advanced portfolio report, make sure you select
> "include account with no shares" in the options:Accounts
>
> I am not sure if you have used this security in any of your account, even
> though the current position is zero, the system will allow you to delete it
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Fred Tydeman  >
> *Sent:* 28 September 2024 10:38
> *To:* Gnucash Users 
> *Subject:* [GNC] Commodity is currently used...
>
> In the Securities editor, I am trying to delete a security.
> When I try that, I get a message:
>
> That commodity is currently used by at least one of your accounts.
> You may not delete it.
>
> How do I find out which account is using it?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C4c2308c80e414fb8ae9e08dcdfc30fd0%7C84df9e7fe9f640afb435%7C1%7C0%7C638631276089285200%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=DMB%2FKf5qyS9iL5dy1JAphX3mIRuHZ6xq8nJHD4g3SWg%3D&reserved=0
> <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] Commodity is currently used...

[Fred Tydeman]

In the Securities editor, I am trying to delete a security.
When I try that, I get a message:

That commodity is currently used by at least one of your accounts.
You may not delete it.

How do I find out which account is using it?
___
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] Crash after delete sub-account

[Fred Tydeman]

After doing an Import of a QIF file, I had a new top level account
(along with Assets, Equity, Expenses, Income, Liabilities, Trading).
It had one sub-account with one transaction in it.
So I had  Tax Forn:IRA as the account and sub-account.
I edited the transaction by changing that part of the transaction
to Expenses: us:Tax:Fore:IRA
So, Tax Forn:IRA is now empty.
So much for the background.

In the Accounts tab, I click on the IRA sub-account of Tax Fore.
I then click on Delete at the top of the screen.
Now, Tax Fore still has a right pointing arrow indicating that it
has sub-accounts (yet I just deleted the sub-account).
If I click on that right pointing arrow, Gnucash crashes.

I am running Gnucash 5.8 on Fedora Linux 40
___
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] Import QIF into placeholder

[Fred Tydeman]

Doing a File: Import: Import QIF
of stock brokerage transactions,
some of them end up in a placeholder account.
This mainly happens for cash transactions.
They end up in the parent account, which is the brokerage account;
which is a placeholder account.
It would be better if the import process warned about this error.

After the import is done, I manually correct those transactions.

I am running Gnucash 5.8 on Fedora Linux 40
___
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 expected digits after -

[Fred Tydeman]

On Mon, Sep 23, 2024 at 5:34 PM Scott Steimle  wrote:

> Looking at the JSON, I see this being returned, so indeed there is an issue
> with the service response not being parsed well:  "div_yield":-nan
>

'nan' means Not A Number
In this case, it would have come from 0 / 0
___
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] General Journal scrolling

[Fred Tydeman]

Perhaps doing
  Ctrl-G
  M
  Enter

Ctrl-G means Goto
M means beginning of Month

On Wed, Sep 18, 2024 at 3:51 AM Owen Willows  wrote:

> Dear GnuCash users,
>
> I have been very happy to use Gnucash over the past 2 years but I find a
> problem scrolling back when in the General Journal.
> As I enter transactions they fill the screen but I find I cannot scroll
> back to the beginning of the month’s entries.
> Can someone please advise whether I can make a setting adjustment for
> this. I have tried to work through all thee ‘Help’ options etc.
> Thank you.
> Owen.
>
> ___
> 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] Advanced Portfolio report - missing stocks

[Fred Tydeman]

I am a USA based person/book.

Part of my COA looks like:
asset Assets
asset  Fidelity
asset   Intl
cash  CAD Canada dollar stocks
stockEIF:CA
cash  GBP  Great Britain pound stocks
stockRIO:GB

Those two foreign stocks do NOT show up in the Advanced Portfolio report.
I believe it is because their parent is a Cash type account.

I noticed in other books, the Cash account at a brokerage does not
show up in the Advanced Portfolio report.
___
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] 5.8 crash

[Fred Tydeman]

OS: Fedora Linux 40
Gnucash 5.8

When I tried to delete a Trading account, Gnucash crashed.
Here is the /tmp/gnucash.trace file

* 13:04:36 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:03 ERROR  const char* xaccAccountGetName(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:03 ERROR  const char* xaccAccountGetColor(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:03 ERROR  const char* xaccAccountGetName(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:03 ERROR  const char* xaccAccountGetColor(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:03 ERROR  const char* xaccAccountGetName(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:03 ERROR  const char* xaccAccountGetColor(const
Account*): assertion 'GNC_IS_ACCOUNT(acc)' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gnc_tree_model_account_iter_has_child: assertion
'iter->user_data != ((void *)0)' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gnc_tree_model_account_get_value: assertion
'iter->user_data != NULL' failed
* 13:14:05 ERROR  gtk_tree_model_filter_convert_iter_to_child_iter:
assertion 'valid == TRUE' failed
* 13:14:05 ERROR  gnc_tree_model_account_get_value: assertion
'iter->user_data != NULL' failed
___
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] 5.8 crash

[Fred Tydeman]

OS:  Fedora Linux 40
Gnucash 5.8

It has crashed on me today.  I am not sure what the last action I did was.
/tmp/gnucash.trace has:
* 10:31:14  WARN  [gnc_option_db_destroy()] Direct Destroy
called on GncOptionDB 93837014456096
* 10:54:27  WARN  [gnc_option_db_destroy()] Direct Destroy
called on GncOptionDB 93837013042656
* 11:02:54  WARN  [gnc_option_db_destroy()] Direct Destroy
called on GncOptionDB 93837013042656

Now, this might be the trace file after I started Gnucash after the crash.

If the crash happens again, what files should I be saving to help debug the
problem?
___
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] IRA value

[Fred Tydeman]

I did: Actions: Check & Repair All
I did some other things that I do not remember.
I updated prices to Friday night.
Now, the Accounts tab value matches the brokerage statement (+/- some
pennies).
Also, the Accounts tab matches the Advanced Portfolio with cash money
market added in.
Running: Fedora Linux 40, Gnucash 5.8

On Fri, Aug 30, 2024 at 12:02 AM Murugan Mariappan <
m.muruganan...@hotmail.com> wrote:

>
> Advanced portfolio report will calculate the price based on the price
> source settings you have chosen. So the report will always be different
> from the accounts tab
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Fred Tydeman  >
> *Sent:* 29 August 2024 18:56
> *To:* Gnucash Users 
> *Subject:* [GNC] IRA value
>
> I have updated stock prices.
> I have run the Advanced portfolio on an IRA to get Total value.
> If I look at the Accounts tab for that IRA, the Present(USD) value
> is 9% lower than the report  value.  Why?
>
> Gnucash 4.14 on Fedora Linux 37
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C6124680871be432eac2008dcc87e0689%7C84df9e7fe9f640afb435%7C1%7C0%7C638605690823155104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=N1PMCOROIIgHBL3MVcCSsB%2FvWvOXsmJ7m6g%2BjCnucTY%3D&reserved=0
> <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] IRA value

[Fred Tydeman]

I have updated stock prices.
I have run the Advanced portfolio on an IRA to get Total value.
If I look at the Accounts tab for that IRA, the Present(USD) value
is 9% lower than the report  value.  Why?

Gnucash 4.14 on Fedora Linux 37
___
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] Get Quotes hung

[Fred Tydeman]

It appears to depend upon where one is in the world.
Last week in Medellin, Colombia, it took hours on a fast
internet connection.
Today, in the Miami, FL, USA, airport, it takes about one minute.
I have tried
  Fedora Linux 40 with Gnucash 5.8
  Fedora Linux 37 with Gnucash 4.14
Both take the same time in either place in the world

On Wed, Aug 21, 2024 at 7:41 PM Kalpesh Patel  wrote:

> That length of time indicates that it is getting into some sort of weird
> loop for each security being fetched and then it waits to time out each one
> of those fetch call.
>
>
>
> There are number of things you can try to narrow down the issue on your
> system:
>
>
>
> -  See if you can time the fetch of single quote using the CLI
> that is provided with GNUCash.
>
> -  Start with a blank file and then define just one or two
> securities. BK and BRK-A are good to start with and time that.
>
> -  Run GNUCash in a debug mode and enable trace mode to capture
> the output to see if there is something not so right.
>
>
>
> Some odd reason it feels like you are on a Linux Distro and it might be
> setup to auto configure for a proxy server but one does not exist. Although
> it wound ’t take that length of time to timeout.
>
>
>
> Last thing that I can think is that your Perl distribution is busted badly
> enough and might need a fresh install.
>
>
>
> What version of GNUCash, and on which type and version of OS are running
> on?
>
>
>
> *From:* Fred Tydeman 
> *Sent:* Wednesday, August 21, 2024 7:08 PM
> *To:* Kalpesh Patel 
> *Cc:* R Losey ; Gnucash Users 
> *Subject:* Re: [GNC] Get Quotes hung
>
>
>
>
>
>
>
> On Wed, Aug 21, 2024 at 11:38 AM Kalpesh Patel 
> wrote:
>
> I am not seeing such delays and completes in about a minute. I do see
> failures now and then and that has all to do with Yahoo performing
> maintenance on their systems and is transient in nature.
>
> Silly question I'll ask: did you verify that all those stocks are getting
> data from Yahoo and Yahoo only via yahoo_json as a single source? You
> aren't running any VPN session, knowingly or unknowingly, right?
>
>
>
> No VPN.
>
> All stocks are getting from yahoo.
>
>
>
___
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] Get Quotes hung

[Fred Tydeman]

On Wed, Aug 21, 2024 at 11:38 AM Kalpesh Patel 
wrote:

> I am not seeing such delays and completes in about a minute. I do see
> failures now and then and that has all to do with Yahoo performing
> maintenance on their systems and is transient in nature.
>
> Silly question I'll ask: did you verify that all those stocks are getting
> data from Yahoo and Yahoo only via yahoo_json as a single source? You
> aren't running any VPN session, knowingly or unknowingly, right?
>

No VPN.
All stocks are getting from yahoo.
___
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] Get Quotes hung

[Fred Tydeman]

I removed the get quote from stocks that have been sold, so now I only have
35 stocks.
Last night, it took 2 hours and 45 minutes, or 165 minutes, to get prices.
That works out to 4.7 minutes per stock.
Anyone else seeing this long time to get stock prices using yahoo_json?


On Tue, Aug 13, 2024 at 6:49 PM Fred Tydeman  wrote:

> yahoo_json for all the stocks
>
> On Tue, Aug 13, 2024 at 6:47 PM R Losey  wrote:
>
>> From what service are you retrieving the prices?  One of the services
>> only allows something like 5 prices, and then it puts a 1 minute delay in
>> before it does the next 5. So, if you have 60 stocks, it will take over 12
>> minutes.
>>
>>
>> On Tue, Aug 13, 2024 at 3:40 PM Fred Tydeman 
>> wrote:
>>
>>> Two weeks ago, using the GUI, it took about 10 minutes.
>>> All the prices are coming from yahoo_json
>>> OS:  Linux Fedora 40
>>> Gnucash 5.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] Stock w/ no shares, but get quotes

[Fred Tydeman]

Is there an easy way to get a list of stocks
that are no longer owned (have 0 shares),
and the Get online quotes box is checked?
___
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] two instances on different books

[Fred Tydeman]

On Wed, Aug 14, 2024 at 7:47 AM Brook Milligan via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Is it safe for a single user to run simultaneously two different instances
> of GC on two different books?
>

How about this case:
  Run the command line interface to get stock quotes for one book
  Run the GUI interface on another book at the same time
Is that safe?
___
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] Get Quotes hung

[Fred Tydeman]

yahoo_json for all the stocks

On Tue, Aug 13, 2024 at 6:47 PM R Losey  wrote:

> From what service are you retrieving the prices?  One of the services only
> allows something like 5 prices, and then it puts a 1 minute delay in before
> it does the next 5. So, if you have 60 stocks, it will take over 12 minutes.
>
>
> On Tue, Aug 13, 2024 at 3:40 PM Fred Tydeman 
> wrote:
>
>> I ran the command line interface to update the stock prices
>> on the file/book that crashed from the GUI.  No crash with CLI.
>> It ran for about 18 hours!  Anyone have any idea why so long?
>> Two weeks ago, using the GUI, it took about 10 minutes.
>> All the prices are coming from yahoo_json
>> OS:  Linux Fedora 40
>> Gnucash 5.8
>>
>> On Sun, Aug 11, 2024 at 4:05 PM Fred Tydeman 
>> wrote:
>>
>> > After several hours, I got (in the Price Database window):
>> > Price retrieval failed:  Failed to parse result returned by
>> Finance::Quote
>> > Error message:
>> > (1): expected value
>> > Result:
>> >  then comes lines and lines of text that exceeds the screen
>>
>
> --
> _
> 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] Get Quotes hung

[Fred Tydeman]

I ran the command line interface to update the stock prices
on the file/book that crashed from the GUI.  No crash with CLI.
It ran for about 18 hours!  Anyone have any idea why so long?
Two weeks ago, using the GUI, it took about 10 minutes.
All the prices are coming from yahoo_json
OS:  Linux Fedora 40
Gnucash 5.8

On Sun, Aug 11, 2024 at 4:05 PM Fred Tydeman  wrote:

> After several hours, I got (in the Price Database window):
> Price retrieval failed:  Failed to parse result returned by Finance::Quote
> Error message:
> (1): expected value
> Result:
>  then comes lines and lines of text that exceeds the screen
>
>
___
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] Get Quotes hung

[Fred Tydeman]

After reading the wiki, I have tried:
  gnucash-cli --log gnc.price-quotes=debug --quotes get tybor.gnucash
It finished after 6.5 hours!  Why so long now? As before, it took about 5
minutes.
With this book, it did not crash (the crash I got before was with another
book).
It did find 5 securities with errors (no listing found).
It appears to have updated the book with the prices of the good securities.
I have about 85 securities.

On Sun, Aug 11, 2024 at 1:47 PM Fred Tydeman  wrote:

> Fedora Linux 40
> Gnucash 5.8
>
> Running Tools: Price Database: Get Quotes hangs or runs "forever"
> All my stocks are setup to get prices via Yahoo_Jason
> Today I am in Medellin, Colombia, and my internet is very fast.
>
___
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] Get Quotes hung

[Fred Tydeman]

The currency problem was my fault.
In moving to a newer Linux and Gnucash,
I forgot to set the Alphavantage key.
That part is working OK now.

On Sun, Aug 11, 2024 at 7:47 AM Fred Tydeman  wrote:

> Fedora Linux 40
> Gnucash 5.8
>
> Trying this on another file/book that has no stocks, but does have
> four currencies gets: Quote reported failure set no error.
> for all of them.
>
___
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] Get Quotes hung

[Fred Tydeman]

I found an app to capture the screen (but not the window),
so now have a screen shot if it helps anyone

On Sun, Aug 11, 2024 at 4:05 PM Fred Tydeman  wrote:

> After several hours, I got (in the Price Database window):
> Price retrieval failed:  Failed to parse result returned by Finance::Quote
> Error message:
> (1): expected value
> Result:
>  then comes lines and lines of text that exceeds the screen
>
> I have tried to capture that window with
>  PrtSc key
>  Alt-PrtSc
>  Shift PrtSc
> but none of them worked.  Any suggestions?
>
>
___
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] Get Quotes hung

[Fred Tydeman]

After several hours, I got (in the Price Database window):
Price retrieval failed:  Failed to parse result returned by Finance::Quote
Error message:
(1): expected value
Result:
 then comes lines and lines of text that exceeds the screen

I have tried to capture that window with
 PrtSc key
 Alt-PrtSc
 Shift PrtSc
but none of them worked.  Any suggestions?

I also tried Left mouse and touchpad to try to select text
and that failed.


On Sun, Aug 11, 2024 at 7:47 AM Fred Tydeman  wrote:

> Fedora Linux 40
> Gnucash 5.8
>
> Running Tools: Price Database: Get Quotes hangs or runs "forever"
> All my stocks are setup to get prices via Yahoo_Jason
> Today I am in Medellin, Colombia, and my internet is very fast.
> Clicking on the X in the top right of Price Database window gets
> a popup about window not responding, do I want fo force exit.
> Saying yes to that ends the Gnucash program.
> Restarting Gnucash and doing Actions: Check & Repair All
> runs in under a second and leaves the Save icon dim
> (so nothing was changed).
>
> Trying this on another file/book that has no stocks, but does have
> four currencies gets: Quote reported failure set no error.
> for all of them.
>
___
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] Get Quotes hung

[Fred Tydeman]

Fedora Linux 40
Gnucash 5.8

Running Tools: Price Database: Get Quotes hangs or runs "forever"
All my stocks are setup to get prices via Yahoo_Jason
Today I am in Medellin, Colombia, and my internet is very fast.
Clicking on the X in the top right of Price Database window gets
a popup about window not responding, do I want fo force exit.
Saying yes to that ends the Gnucash program.
Restarting Gnucash and doing Actions: Check & Repair All
runs in under a second and leaves the Save icon dim
(so nothing was changed).

Trying this on another file/book that has no stocks, but does have
four currencies gets: Quote reported failure set no error.
for all of them.
___
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 quote fail popup too tall

[Fred Tydeman]

Today, when I tried to get stock price quotes, I got a popup
Unable to retrieve quotes for these items:
  very long list that is more than one screen

So, there is no way to get to the No/Yes items at the bottom of the popup.
So, I clicked on the X at the top right of the popup to kill it.
I assume that means none of the good quotes were saved.
I also assume no damage was done to any data.

I tried a second time and the popup was shorter, so the No/Yes items
were visible and clickable.

OS: Fedora Linux 37
Gnucash 4.14
___
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] Same currency pair, two places, same date

[Fred Tydeman]

On Sat, Jul 13, 2024 at 3:22 PM Murugan Mariappan <
m.muruganan...@hotmail.com> wrote:

> This behavior I have observed if you change the base currency of GNUCash
> Did you by any chance change the same ?
>

No,  I have always had USD  as my default currency.
___
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] Same currency pair, two places, same date

[Fred Tydeman]

I was wrong; same month/day, different years.
I saw June 30 in both places, but failed to notice the different years.
Under COP, the USD entries ended July 19, 2023.
Under USD, the COP entries started July 30, 2023 and go to today.
Those are for Finance::Quote entries.
I try to update the Price Database each Saturday.
That is for both currencies and stocks.

>> On 12/7/2024 18:30, Fred Tydeman wrote:
> >>> In looking at my Price Database for Currencies,
> >>> I see that the conversion rate for a pair appears twice
> >>> for the same date.
> >>> Under COP there is a USD entry for June 30 of 0.000239
> >>> Under USD there is a COP entry for June 30 of 4148
> >>> So, which one is used for reports?
> >>> Is this going to cause issues?
> >>>
> >>> In looking at other values, I see that most of them in both
> >>> COP and USD came from Finance::Quote, but at different dates.
> >>>
> >>> There are a few user:price-editor entries.
> >>>
> >>> I am running Fedora Linux 37 and Gnucash 4.14
>
___
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] Same currency pair, two places, same date

[Fred Tydeman]

In looking at my Price Database for Currencies,
I see that the conversion rate for a pair appears twice
for the same date.
Under COP there is a USD entry for June 30 of 0.000239
Under USD there is a COP entry for June 30 of 4148
So, which one is used for reports?
Is this going to cause issues?

In looking at other values, I see that most of them in both
COP and USD came from Finance::Quote, but at different dates.

There are a few user:price-editor entries.

I am running Fedora Linux 37 and Gnucash 4.14
___
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] More than 4 files

[Fred Tydeman]

The FAQ was helpful (look for MRU).
For some reason, my Fedora Linux 37 with GnuCash 4.14 has both locations
for maxfiles
that are mentioned in the FAQ.

Anyway, I got what I need.  Thanks.


On Sun, Jul 7, 2024 at 5:05 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> And I see it is in the Wiki FAQ.
>
> Regards,
> Adrien
>
> On 7/7/24 9:57 AM, Adrien Monteleone wrote:
> > Found it surprisingly fast:
> >
> >
> https://lists.gnucash.org/pipermail/gnucash-user/2021-January/094869.html
>
> ___
> 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] More than 4 files

[Fred Tydeman]

Is there a way to have the list of files/books have more than 4?
___
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] Zeros in Balance sheet

[Fred Tydeman]

Using the same Gnucash file on Fedora Linux 40 and Gnucash 5.6,
the Balance Sheet does NOT show the zero lines (once I change
the option to not display zero entries).

On Thu, Jun 20, 2024 at 6:14 PM Brad Morrison 
wrote:

> Fred & GnuCash users,
>
> Although this might not be specific to your issue:
>
> The current version of Fedora Linux is 40 -
> https://fedoramagazine.org/announcing-fedora-linux-40/ &
> https://fedoraproject.org/ &
> https://distrowatch.com/table.php?distribution=fedora
>
> The current version of GnuCash is 5.6 -
> https://gnucash.org/download.phtml#distribution &
> https://repology.org/project/gnucash/versions &
> https://flathub.org/apps/org.gnucash.GnuCash
>
> ---
> Thanks,
>
> Brad - https://www.facebook.com/brad.morrison.12327/ &
> https://norcal.social/@BradMorrison
>
> On 2024-06-20 07:03, Fred Tydeman wrote:
>
> > Fedora Linux 37
> > GnuCash 4.14
> >
> > Doing  Reports: Assets&Liabilities: Balance Sheet
> > In the Options: Display:
> > I uncheck Include accounts with zero total balances
> > I check Omit zero balance figures
> >
> > If I take the default of 3 Levels of subaccounts
> > the report has lots of lines with zero amounts.
> >
> > If I change the Levels of subaccounts to All,
> > then the zero entries go away.
> >
> > Seems wrong.
> > ___
> > 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] Zeros in Balance sheet

[Fred Tydeman]

One account I checked in detail has no children.
In the report, it shows as VOO
The only account with that name is a trading account.
The corresponding stock investment account is Vang 500 ETF
The account has two buys and two sells in 2023 with a net of zero.
I am doing a Balance Sheet for today.
I believe that most (if not all) of the zero lines are for stocks that have
been sold
and have no children accounts.

If I run a report with default level of 3, but check Flatten list to depth
limit,
then the zero lines in the report go away.

On Thu, Jun 20, 2024 at 3:54 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 6/20/2024 10:03 AM, Fred Tydeman wrote:
> > Fedora Linux 37
> > GnuCash 4.14
> >
> > Doing  Reports: Assets&Liabilities: Balance Sheet
> > In the Options: Display:
> > I uncheck Include accounts with zero total balances
> > I check Omit zero balance figures
> >
> > If I take the default of 3 Levels of subaccounts
> > the report has lots of lines with zero amounts.
> >
> > If I change the Levels of subaccounts to All,
> > then the zero entries go away.
> >
> > Seems wrong.
>
> I'm not so sure wrong. Let me ask you a question
>
> These accounts that appear (even though showing zero) at a small number
> of levels but that disappear then the nesting level is increased enough
> to expand the entire tree  Do they have children that are not
> appearing because of level truncation.
>
> Consider THIS situation << where truncation is set so that only Account
> X shows >>
>
>   Account X(balance 0)
>
>  Account Y   (balance debit  10)
>
>  Account Z   (balance credit 10)
>
> In other words, I might want to see an account whose balance is zero IF
> it has children  (being truncated) with non-zero balances. I'd at least
> want to think about it some  before deciding show vs don't show.And
> possibly any situation where the children COULD BE non-zero. In other
> words, is the "exclude zero" not working as you expect because  because
> truncation of levels means the report can no longer "see" if below there
> all zero or not.
>
> 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.

[GNC] Zeros in Balance sheet

[Fred Tydeman]

Fedora Linux 37
GnuCash 4.14

Doing  Reports: Assets&Liabilities: Balance Sheet
In the Options: Display:
I uncheck Include accounts with zero total balances
I check Omit zero balance figures

If I take the default of 3 Levels of subaccounts
the report has lots of lines with zero amounts.

If I change the Levels of subaccounts to All,
then the zero entries go away.

Seems wrong.
___
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] Delete a trading account => crash

[Fred Tydeman]

By mistake, I had two Asset accounts for the same stock, but with different
spellings.
That is what produced the two similar Trading accounts.

So, I ended up doing in the Cash account that did the buys and sells:
In split view mode: change the stock asset account from one to the other,
press Enter, that got me a popup to adjust the number of shares.
Press Enter and all was fixed.

Doing that was a lot easier than deleting and re-entering the transactions.

When I was done, one stock asset account and one trading account were
both empty, so could be deleted.  I also deleted the wrong spelling in the
Security editor.

On Sun, May 19, 2024 at 9:28 AM Kalpesh Patel  wrote:

> That is the behavior, sadly, where it goes back to what the original
> transaction was. It is undesired but it is there and not likely to be
> fixed.. (I run into it when I want to duplicate the transaction and then
> just update the quantity)
>
> To get around, you technically have to enter the entire transaction from
> beginning to end. Work around is to "modify" transaction is to open up the
> transaction, select first row from split view, go to first column highlight
> what is in it, copy it to clipboard, delete it, paste it from clipboard
> (correct as you need to during this paste phase). Rinse-&-repeat for all
> columns across for all rows in the transaction... you can minimize this by
> doing cut-&-paste to only the Shares, Buy and Sell columns and let it
> calculate the Price column. It does get crazy when you have multi-currency
> enabled and/or are dividend reinvestment transactions ...
>
>
> -Original Message-
> From: Fred Tydeman 
> Sent: Sunday, May 19, 2024 1:04 AM
> To: Gnucash Users 
> Subject: [GNC] Delete a trading account => crash
>
> Running GnuCash 4.14 on Fedora Linux.
>
> Due to a mistake on my part, I have two Trading accounts:
>   IVR-PC
>   IVRPRC
> for the same security.
>
> First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> transaction from the cash account. However, when I pressed Enter, Gnucash
> undid my change.
>
> Then, I tried deleting Trading:IVRPRC account and moving its transactions
> to Trading: IVR-PC.
> That crashed Gnucash.
>
> I am now running a Check & Repair all (takes many minutes).
>
>
>
___
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] Delete a trading account => crash

[Fred Tydeman]

Running GnuCash 4.14 on Fedora Linux.

Due to a mistake on my part, I have two Trading accounts:
  IVR-PC
  IVRPRC
for the same security.

First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
transaction from the cash account. However, when I pressed Enter,
Gnucash undid my change.

Then, I tried deleting Trading:IVRPRC account and moving its transactions
to Trading: IVR-PC.
That crashed Gnucash.

I am now running a Check & Repair all (takes many minutes).
___
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 PreRelease 1.61_03

[Fred Tydeman]

make depend
fails (as there is no 'depend' target in the makefile).

On Thu, May 2, 2024 at 6:16 AM Kalpesh Patel  wrote:

> If you are installing it into the system installed perl, which most likely
> you are doing so with a su switch user utility, then correct way to do so
> would be to:
>
> # sudo su -
> # cd 
> # make depend
> # make
> # make test
> # make install
> # make clean
>
>
___
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 PreRelease 1.61_03

[Fred Tydeman]

perl -MCPAN -e shell
gets
Can't locate CPAN.pm

This is Fedora Linux 40 (the most recent)

perl -v
gets 5.38.2

dnf list perl*CPAN*
gets lots of hits (so it is available).


On Thu, May 2, 2024 at 6:04 AM Kalpesh Patel  wrote:

> "Gets nothing on my linux." sounds like those modules have not been
> initialized as your system is NOT running in an "island" configuration
> since sudo make install works. This might possibly be an outbound firewall
> issue although if wget and/or curl works then not.
>
> Run following:
> perl -MCPAN -e shell
>
> to see if you get 'cpan>' prompt. If not then most likely CPAN module is
> not installed on your system which would be unusual as it comes with modern
> perl. Not sure which type of Linux you are running but generally if a Perl
> library is named Foo::Bar on CPAN (CPAN is named CPAN), the Debian/Ubuntu
> package will be named libfoo-bar-perl and for Fedora/Redhat it will be
> named perl-Foo-Bar.
>
> If you have cpan modules installed then it is a good idea to initialize it
> by executing 'o conf commit' at CPAN shell prompt of 'cpan>'.
>
> -Original Message-
> From: Fred Tydeman 
> Sent: Wednesday, May 01, 2024 11:50 PM
> To: Bruce Schuck 
> Cc: GnuCash User 
> Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03
>
> Running: sudo make install
> worked.  I was able to get stock quotes again.  So thank you.
>
> Trying:
>   cpan
>   cpanm
>   locate cpan
> Gets nothing on my linux.
>
>   dnf list cpan*
> gets: cpanspec.noarch
>
>
> On Wed, May 1, 2024 at 8:07 PM Bruce Schuck 
> wrote:
>
> > On 5/1/24 7:39 PM, Fred Tydeman wrote:
> >
> > > On my Linux systems, after some searching, I found that I needed:
> > > dnf install perl-ExtUtils-MakeMake* to get me started. Running perl
> > > Makefile.PL got me several warnings of other missing perl files.
> > > After doing a bunch of dnf install perl-... for them, 'make' and
> > > 'make test' ran But, 'make install' failed due to permission issues.
> > > Does it need 'su' to do the install?
> >
> > People not familiar with the "manual" method of installing should use
> > cpan or cpanm. To install an interim release
> >
> > "cpanm BPSCHUCK/Finance-Quote-1.61_03.tar.gz" or "cpan
> > BPSCHUCK/Finance-Quote-1.61_03.tar.gz".
> >
> > Depending how cpan(m) is configured, super user permissions may or may
> > not be required. Typically when running cpan or cpanm, the install
> > process will ask for the user's sudo password to install modules.
> >
> > When I would install using the "perl Makefile.PL; make; make test;
> > make install" steps, I would become root or use sudo to execute "make
> > install". But again, most people should utilize cpan or cpanm. The
> > install tool provided by GnuCash utilizes CPAN.
> >
> > There is a brief overview of installing modules at
> > https://www.cpan.org/modules/INSTALL.html which doesn't mention the
> > legacy "perl Makefile.PL" method. As I mentioned in my post though,
> > "For those who are comfortable with the interim releases". Comfortable
> > being the operative word.
> >
> > 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] Finance::Quote PreRelease 1.61_03

[Fred Tydeman]

Running: sudo make install
worked.  I was able to get stock quotes again.  So thank you.

Trying:
  cpan
  cpanm
  locate cpan
Gets nothing on my linux.

  dnf list cpan*
gets: cpanspec.noarch


On Wed, May 1, 2024 at 8:07 PM Bruce Schuck 
wrote:

> On 5/1/24 7:39 PM, Fred Tydeman wrote:
>
> > On my Linux systems, after some searching, I found that I needed: dnf
> > install perl-ExtUtils-MakeMake* to get me started. Running perl
> > Makefile.PL got me several warnings of other missing perl files.
> > After doing a bunch of dnf install perl-... for them, 'make' and
> > 'make test' ran But, 'make install' failed due to permission issues.
> > Does it need 'su' to do the install?
>
> People not familiar with the "manual" method of installing should use
> cpan or cpanm. To install an interim release
>
> "cpanm BPSCHUCK/Finance-Quote-1.61_03.tar.gz" or "cpan
> BPSCHUCK/Finance-Quote-1.61_03.tar.gz".
>
> Depending how cpan(m) is configured, super user permissions may or may
> not be required. Typically when running cpan or cpanm, the install
> process will ask for the user's sudo password to install modules.
>
> When I would install using the "perl Makefile.PL; make; make test; make
> install" steps, I would become root or use sudo to execute "make
> install". But again, most people should utilize cpan or cpanm. The
> install tool provided by GnuCash utilizes CPAN.
>
> There is a brief overview of installing modules at
> https://www.cpan.org/modules/INSTALL.html which doesn't mention the
> legacy "perl Makefile.PL" method. As I mentioned in my post though, "For
> those who are comfortable with the interim releases". Comfortable being
> the operative word.
>
> 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] Finance::Quote PreRelease 1.61_03

[Fred Tydeman]

On my Linux systems, after some searching, I found that I needed:
  dnf install perl-ExtUtils-MakeMake*
to get me started.
Running perl Makefile.PL
got me several warnings of other missing perl files.
After doing a bunch of dnf install perl-... for them,
'make' and
'make test' ran
But, 'make install' failed due to permission issues.
Does it need 'su' to do the install?



On Wed, May 1, 2024 at 7:09 PM Fred Tydeman  wrote:

> I am running Fedora Linux 26
> I downloaded the Finance::Quote.
> When I run:  perl Maklefile.pl
> I get:  Can't locate ExtUtils/MakeMaker.pm
> So, can you point me to more complete documentation?
>
> On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
> wrote:
>
>> A few more fixes and additions to Finance::Quote. For those who are
>> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>>
>>
>> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>>
>> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
>> "cpan" or "cpanm".
>>
>> The Fool.pm module has been fixed (but like Yahoo, who knows for how
>> long?), method "fool". For the time being, only returns data for
>> securities on NYSE, Nasdaq, and OTC exchanges.
>>
>> A new module for US traded stocks, StockData.pm, with default method
>> "stockdata". This requires an API token from https://www.stockdata.org/.
>> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
>> token. Once installed "perldoc Finance::Quote::StockData" will display
>> more information.
>>
>> I also discovered that the TwelveData module was not working because the
>> method "twelvedata" was not returning a value for price or last. This is
>> another module that requires an API, this one from
>> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
>> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
>> display more information.
>>
>> Regards,
>>
>> 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.
>>
>
___
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 PreRelease 1.61_03

[Fred Tydeman]

I am running Fedora Linux 26
I downloaded the Finance::Quote.
When I run:  perl Maklefile.pl
I get:  Can't locate ExtUtils/MakeMaker.pm
So, can you point me to more complete documentation?

On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> 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.
>
___
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 PreRelease 1.61_03

[Fred Tydeman]

Can I apply this update to my older 4.14 Gnucash system on Linux?

On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> 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.
>
___
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] One LLC pay expense of another LLC

[Fred Tydeman]

If LLC-a pays an expense of  LLC-b
ie, cash from LLC-a goes to expense of LLC-b,
should I also show a transfer of equity from LLC-a to LLC-b?
It seems that needs to be done so that the Balance sheet for LLC-b is
correct.
___
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] Use 4.14 and 5.6 on same file (at different times)

[Fred Tydeman]

Will I run into problems if I use both GnuCash 4.14 and 5.6 on the same
file / book?
That is, 4.14 is on my current production Linux system and where I use
Gnucash.
I have installed a later Linux system on a different disk partition and it
has Gnucash 5.6
If I were to use Gnucash 5.6 to enter some data, and then switch back to
4.14, will the
data / book be OK?
___
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] Multiple Currencies with Balance Sheet not balanced

[Fred Tydeman]

A guess on my part.

In the Balance sheet:
  Click on Options
 Click on Commodities
Click on Price Source
  Try Closet to Report Date

You might also check if the conversion rate between PHP and USD was
recorded:
Tools
   Price Database
  Currencies
Look in both USD and PHP for the date in question.

On Mon, Apr 22, 2024 at 3:52 PM Stephen M. Butler  wrote:

> This has been a thorn in my flesh for some time but I've been too busy
> to deal with it.  The non-profit where I volunteer works in two
> currencies:  PHP and USD.  The main currency is set to USD.
>
> Chapter 12 of the Guide implies two ways of tracking multiple
> currencies:  Manually (without trading accounts) and Automatically (with
> trading accounts).  I do not have trading accounts activated.
>
> Every time I exchange USD into PHP I enter the exact number of PHP
> received for he exact USD value.
>
> Today I tracked down the first instance of the Balance Sheet going out
> of balance.  On July 4, 2023, Assets = Liabilities + Equity. [$6562.90]
> On July 5 there is a single transaction moving $626.80 USD to 34,250
> PHP.  But the Balance Sheet for that date shows Assets of $6518.06 vs
> Liabilities + Equity of $6516.45
>
> There is only one price entry for 7/5/2023 in the price database.  I did
> click on the transaction to verify the $626.80 to 34,250 PHP was entered
> correctly.
>
> This transaction was between two asset accounts.  One in USD and the
> other in PHP.  So why did my Asset value drop?  And why is the Balance
> Sheet out of balance?  I suspect I'll find more of these as I move
> forward toward today.
>
> --Steve
>
> --
> Stephen M Butler
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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] IRA conversion

[Fred Tydeman]

I assume that that Distributions account should be of type Income (not
Asset).

It appears that Income accounts cannot have a stock account type (so cannot
move stock via this method).
Would have to fake it by selling the stock (in 'from' account) to get cash,
move the cash, then buy the stock
(in the 'to' account).

Also, since X dollars come into Distributions and X dollars leave, the net
is zero.  So, any report would
show zero income.

I think a better solution is to use four splits:
  Cash or stock coming out of Regular IRA Asset account
  Cash or stock going into Roth IRA Asset account
  Cash going into a Distributions Income account
  Cash going into a dummy Expense account

Then, make sure to exclude the dummy Expense account in any reports.


On Sat, Apr 6, 2024 at 12:43 AM sunfis...@yahoo.com 
wrote:

> I am not really knowledgeable in this area (or many other areas, to be
> honest), but I found the following discussion (in a Quicken forum) that
> might lead you towards an answer:
> https://community.quicken.com/discussion/7931315/tax-summary-report-does-not-include-income-for-conversions-to-roth-ira
>
> My reading of that post suggests that you might first sell your regular
> IRA into a (taxable)  Distributions account. That would allow creation of
> any gains entries necessary. Then use the Distributions account to buy into
> the Roth.
>
> I'm sure others will inform me and you of the errors in my advice.
>
> David T.
> On Apr 6, 2024, at 8:02 AM, Fred Tydeman  wrote:
>>
>> Suggestions on how to record moving cash and stock from
>> a regular IRA to a Roth IRA so that a taxable event is recorded?
>> --
>>
>> 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] IRA conversion

[Fred Tydeman]

Suggestions on how to record moving cash and stock from
a regular IRA to a Roth IRA so that a taxable event is recorded?
___
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] Find account

[Fred Tydeman]

Thank you.  That worked.
I was trying to use Ctrl-F while in Chart of Accounts.

On Sat, Mar 30, 2024 at 12:39 AM david whiting 
wrote:

> Do you mean find all accounts with a given string in the account name?
>
> Edit > Find Account (Ctrl+I) brings up a search window (it doesn't
> work if you are in a report, so go to an account register or your
> chart of accounts).
>
> David
>
>
> On Sat, 30 Mar 2024 at 01:36, Fred Tydeman  wrote:
> >
> > Is there a way to find all accounts that contain a given string?
> > I am looking for *quote* somewhere in the account name.
> >
> > Gnucash 4.14 on Fedora Linux
> > ___
> > 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.
>
>
>
> --
> David Whiting
>
___
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] Find account

[Fred Tydeman]

Is there a way to find all accounts that contain a given string?
I am looking for *quote* somewhere in the account name.

Gnucash 4.14 on Fedora Linux
___
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 Quotes Yahoo off the rails again?

[Fred Tydeman]

I am on Fedora Linux, GnuCash 4.14 and yahoo_json works for me (just got
the quarter ending prices
for both stocks and currencies).

On Thu, Mar 28, 2024 at 7:59 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  So anyone care to recommend a source setting for quotes that works?
> ___
> 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] Last day of month

[Fred Tydeman]

Is there a way to force reports (such as Assets over time) to show values
on the last day of the month (instead of the first day of the month)?
___
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] Max value during year

[Fred Tydeman]

Is there an easy way to find the maximum value of an account during a given
time period (such as a year)?

I currently do:  Reports: Assets & Liabilities: Asset chart:
Options:
  Accounts:  the account I care about
  Display: Show table
  General:  Start and End of previous year (or specific dates);
  Step size:  One Day
and then scan the table for the maximum.
___
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] Bill total does not match real total

[Fred Tydeman]

Actually, DFP (decimal floating point) has been part of gcc since 2005.
DFP is now part of standard C (C23).  DFP was first proposed for C in 2003
N1016  01-Sep-2003
Mak, Extension for the programming language C to support decimal
floating-point arithmetic

Intel 8080 and x86 CPUs both have a limited instruction set for BCD
(binary coded decimal).

The first computer I ever used (in 1967), the IBM 1620, used BCD
floating-point.
___
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] Net Assets

[Fred Tydeman]

In one of my files/books that holds just US assets (no foreign), when I
click
on the down arrow at the bottom of the screen (to the right of Profits), I
get a
list of assets that I can scroll thru.

On Sat, Feb 24, 2024 at 3:38 PM Stan Brown (using GC 4.14) <
stan...@fastmail.fm> wrote:

> Thanks for writing, but nothing changes in the display, whether I hold
> down the mouse button or not.
>
> But see David H's screen shot, sent a few minutes ago. That shows many
> currencies, but everything in my book is in US$, so I suspect that's why
> I don't get anything in the drop-down.
>
___
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] Net Assets

[Fred Tydeman]

On Sat, Feb 24, 2024 at 4:23 PM Fred Tydeman  wrote:

> The "Net Assets" value at the bottom of the screen does NOT match the
> Assets account Present(USD) value.
> So, when I saw the word "Net", I assumed Assets-Liability.
> But, as you pointed out, that would be Equity.
>
> If I play with Edit:Preferences:Accounting Period
> I can keep or remove Grand total (at bottom of screen)
> If I change End Date, the Net Assets value does change, but not match.
>   I have tried:   Today, End of this year, End of previous year
> If I change Start Date, the Profits value changes, but the Net Assets
> remains the same.
>

I have 5 files/books of accounts.  3 have some foreign assets, 2 have only
US assets.
For the two books with just US assets , I can get Net Assets in the Summary
Bar to match
Present(USD) for the Assets account if I change Accounting Period End Date
to Today.
For the three books with some foreign assets, I have not been able to get a
match.
___
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] Net Assets

[Fred Tydeman]

799026 appears to be that bug report (search for "Summary Bar")

On Sat, Feb 24, 2024 at 4:06 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> And I'm pretty sure there is a bug filed on it.
>
> Regards,
> Adrien
>
> On 2/24/24 2:14 PM, David H wrote:
> > Thank you for that as I don't think that in 10 or more years of using
> > Gnucash that I've realised that it is a drop down list :-)  I've always
> > been puzzled as to why it always shows a zero amount for "$, Grand Total"
> > on the left hand side when in actual fact this is just displaying the
> > currency or category the  Net Asset and Profits are displayed in.
>
> ___
> 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] Net Assets

[Fred Tydeman]

The "Net Assets" value at the bottom of the screen does NOT match the
Assets account Present(USD) value.
So, when I saw the word "Net", I assumed Assets-Liability.
But, as you pointed out, that would be Equity.

If I play with Edit:Preferences:Accounting Period
I can keep or remove Grand total (at bottom of screen)
If I change End Date, the Net Assets value does change, but not match.
  I have tried:   Today, End of this year, End of previous year
If I change Start Date, the Profits value changes, but the Net Assets
remains the same.


On Sat, Feb 24, 2024 at 3:44 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 2/24/2024 2:10 PM, Fred Tydeman wrote:
> > I am looking at the Accounts account screen.
> > At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy
> > I assume Net Assets is the current value of Assets - Liabilities.
> > If that is the case, numbers are wrong by a lot.
>
> Wrong assumption.
>
> > If that is not the case, what is Net Assets?
>
> Net Assets.
>
> You need to go back the the tutorial until it is clear to you what are
> "assets", "liabilities", and "equity"
>
> Net EQUITY would be net assets - net liabilities
>
> 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] Net Assets

[Fred Tydeman]

The grand total net assets on bottom of screen does not match Balance Sheet.
Also, what date is being used for Grand Total net assets?
  Today?
  End of accounting period?

On Sat, Feb 24, 2024 at 11:36 AM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> fred
>
> the bottom ticker net asset displays multiple accounts, from the drop down
> select Grand total then it will show you the net asset as per your balance
> sheet
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Fred Tydeman  >
> *Sent:* Saturday, February 24, 2024 4:10 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] Net Assets
>
> I am looking at the Accounts account screen.
> At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy
> I assume Net Assets is the current value of Assets - Liabilities.
> If that is the case, numbers are wrong by a lot.
> If that is not the case, what is Net Assets?
>
> Running GnuCash 4.14 on Fedora Linux 37.
> ___
> 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] Net Assets

[Fred Tydeman]

With arrow/cursor over "down arrow" on right side of bottom line, Press and
hold down the left mouse button .
While still pressing down the left mouse button, press "down cursor/arrow
button"
(can also press up arrow button to scroll thru the list of assets).
Trying again, it appears one does not need to hold down the Left mouse
button to scroll thru the list.

But, I still do not know where the Grand total value comes from.

On Sat, Feb 24, 2024 at 3:08 PM Stan Brown (using GC 4.14) <
stan...@fastmail.fm> wrote:

> Is this a new thing (or possibly a fixed bug) in 5.x?
>
> In 4.14 I have Net Assets and Profits at the bottom of my Accounts list
> as Fred described, and there is a drop-down arrow, but all it does is
> make the bar containing Net Assets and Profits wider than the GC window.
> I can't see anything to click to change what's displayed in that bar.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
>
> On 2024-02-24 11:36, Murugan Muruganandam wrote:
> > the bottom ticker net asset displays multiple accounts, from the drop
> down select Grand total then it will show you the net asset as per your
> balance sheet
>
> > From: Fred Tydeman 
> > Sent: Saturday, February 24, 2024 4:10 PM
> >
> > I am looking at the Accounts account screen.
> > At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy
> > I assume Net Assets is the current value of Assets - Liabilities.
> > If that is the case, numbers are wrong by a lot.
> > If that is not the case, what is Net Assets?
> >
> > Running GnuCash 4.14 on Fedora Linux 37.
> ___
> 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] Net Assets

[Fred Tydeman]

I am looking at the Accounts account screen.
At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy
I assume Net Assets is the current value of Assets - Liabilities.
If that is the case, numbers are wrong by a lot.
If that is not the case, what is Net Assets?

Running GnuCash 4.14 on Fedora Linux 37.
___
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] Popup shows wrong acnt

[Fred Tydeman]

OS: Linux
GC 4.14

I have some accounts open, so the bar near the top shows the accounts.
If I hover the mouse over one of those accounts, I get a popup with the
full "path" (acnt:subacnt:subacnt:...).

I then click on the leftmost Accounts, pick one of those other accounts
(that are on the bar), click Edit, change the parent account (move to a
different place).

If I then hover the mouse over that account (on the top bar) that just
moved, it still shows the  old "path".  Seems like a very minor bug (if
others have this issue).

If I close that moved account, and reopen it, when I hover the mouse, it
now shows the correct "path".
___
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] Compare two sets of accounts?

[Fred Tydeman]

On Linux, on the command line:
  gnucash --nofile


On Sun, Jan 21, 2024 at 8:06 AM Myron A Schroeder  wrote:

> Where do I find the " --nofile runtime parameter."
>
>
___
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] QIF import ignore account

[Fred Tydeman]

On Sat, Jan 20, 2024 at 3:02 PM Geoff  wrote:

> Hmmm...
>
> When I try importing that file into GnuCash 5.5 it crashes silently, and
> the trace file contains just one line:
>
> * 09:56:13  WARN  Failed to open application manifest
> `C:\Program
> Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml'
>
> for package #38
> (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'):
> error code 0x2
>
> As I said in my previous reply, when it comes to investment
> transactions, cut your losses with the QIF Importer and use the CSV
> Importer instead.  It just works.
>

I am getting the QIF file from Quicken for DOS v8.7 of 1996.
It can only export as QIF.


> P.S. You have a quote instead of a slash between the day and the year:
>
>  > D1/19'24


That is how this old version Quicken does dates of form 20xx
___
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] QIF import ignore account

[Fred Tydeman]

OK.  Bug 799224 opened with trace file.

On Sat, Jan 20, 2024 at 2:50 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The Wiki has information on tracefiles. (and crash dumps)  Start with
> the tracefile. Also, running from command line can offer some feedback.
>
> Regards,
> Adrien
>
> On 1/20/24 4:33 PM, Fred Tydeman wrote:
> > If there is some trace or dump file that I should be looking for,
> > I do not know what/where it is.
>
> ___
> 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] QIF import ignore account

[Fred Tydeman]

On Mon, Jan 15, 2024 at 5:57 PM Geoff  wrote:

> The reason for this problem you encountered with the QIF Importer:
>
>  > However, when I do the Import in GnuCash, it shows up as:
>  > Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl
> cap
>
> Is this record in your file:
>  > NDiv
>
> As far as I can tell, this causes the QIF Importer to prepend
> "Income:Dividends:" to your account.
>

OK.  I have removed that one line for this week's import.
Here is the entire QIF file:

 !Account
NAssets:us:Investments:TaxFree:f:Roth-F-Fid
TInvst
^
!Type:Invst
D1/19'24
Yroyal gold
CX
T45.60
Mroyal gold
LIncome:us:NoTax:Roth-F-Fid:div:royal gold
^

When I try to import that one transaction, I get:
A bug was detected while detecting duplicates.

Since this is not a duplicate transaction, I am very confused.
If there is some trace or dump file that I should be looking for,
I do not know what/where it is.
___
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] Idiot 101 question

[Fred Tydeman]

This is the only way I know to still run 16-bit DOS programs
They will NOT run under recent Microsoft Windows (except maybe in DOS Box).

Quicken for DOS (Version 8.0, 1994)
 |
16-bit Microsoft DOS emulator (built into OS/2)
 |
32-bit OS/2 (IBM operating system; actually eComStation follow-on)
 |
32-bit Virtual Machine (Oracle VM VirtualBox)
 |
64-bit Linux (Fedora)
 |
64-bit x86 hardware (Intel Core i5 7th gen)
PS:  I do not see how to change the Subject line in gmail.
Should be:  Virtual Machine
___
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] Viewing account balances of today

[Fred Tydeman]

On the accounts tab, top right corner (down pointing arrow):
Click on:  Present or Present(USD)
Depends upon how you want stocks/mutual funds to show up (shares or dollars)

On Sun, Jan 14, 2024 at 8:21 AM Thomas 
wrote:

> Hello everybody,
>
> I was wondering whether it is possible to change the account overview of
> GnuCash to the status of the current day.
>
> What I mean is the following:
> Usually, when I have some scheduled transactions or some expected
> transactions for the future, they show up in the balance and in the
> account overview immediately, even though they have a date in the future.
>
> What I am looking for is the possibility to switch the account overview
> to include "all bookings up to today" (excluding transactions in the
> future). Is there such a feature or possibility to configure GnuCash
> like that?
>
> E.g.,
> (yesterday) Grocery shopping: 10 €
> (today) Brunch: 15 €
> 
> (tomorrow) Monthly energy consumption deposit: 50 €
>
> I'd like to see the status in the account overview where GnuCash
> (literally) draws the line ;-)
>
>
> Thanks a lot in advance for any hints and pointers!
>
> Best regards,
> Thomas
> ___
> 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] End of Year?

[Fred Tydeman]

On Sat, Jan 13, 2024 at 9:20 AM R Losey  wrote:

> I gather that the main reason for "closing" books is that on the "Accounts"
> tab, one can see the year-to-date expenses and income instead of the total
> since one started using GnuCash. It's a neat idea.
>

Another option is to use the "Total(Period)" column.
Click the down arrow in the upper right on the Accounts page.
___
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] QIF import ignore account

[Fred Tydeman]

GnuCash 4.14 on Linux

As part of a QIF import, I have the following transaction:
^
D1/12'24
NDiv
Yblue owl cap
CX
T122.50
Mblue owl cap
LIncome:us:NoTax:Roth-F-Fid:div:blue owl cap
^

However, when I do the Import in GnuCash, it shows up as:
Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl cap

I do not understand why the QIF importer is ignoring the L... line
Now, the account on the L... line does not yet exist (so that might be the
reason).

In case it matters, the first few lines in the QIF are:
!Account
NAssets:us:Investments:TaxFree:f:Roth-F-Fid
TInvst
^
!Type:Invst
___
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] QIF import Failed

[Fred Tydeman]

Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:

> Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
> Income/Expense account (Category).
> -derek
>
>
___
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] QIF import Failed

[Fred Tydeman]

Running GC 4.14 on Linux
During an import of a QIF file, I am getting "Failed" on the QIF Import
screen.
The message at the top of the box says there should be details shown below
for my review.  However, there are no details about the failure.

Suggestions on where I should look for the details of the failure?

The entire QIF file is:

!Account
NAssets:Investments
TInvst
^
!Type:Invst
^
D02/26/2021
NMiscExp
CX
T0.12
Mfee
L[Expenses:fees]
^
D03/31/2021
NMiscExp
CX
T0.24
Mfee
L[Expenses:fees]
^
D04/30/2021
NMiscExp
CX
T0.38
Mfee
L[Expenses:fees]
^
D05/28/2021
NMiscExp
CX
T0.51
Mfee
L[Expenses:fees]
^
D06/30/2021
NMiscExp
CX
T0.64
Mfee
L[Expenses:fees]
^

As an experiment,
I changed
 L[Expenses:fees]
to
 LFees

and that imported just fine (although I had to pick the mapping of Fees to
Expenses:Fees during the import process).
___
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] Can I print an account?

[Fred Tydeman]

How about the "PrtSc"  (Print Screen) key?

On Mon, Dec 18, 2023 at 3:59 PM Simon Roberts <
si...@dancingcloudservices.com> wrote:

> Hi all, I'd like to be able to print a range of transactions in a single
> account. Essentially just a dump of what I see on the screen, though I
> suppose I would need to select a range of rows and the columns that should
> be in the output.
>
> Can this be done? Is it one of the business reports? My accounting
> background is essentially nothing, so it's entirely possible I don't know
> what one of them might do, though I believe I've tried all the options.
>
> Thanks for any input!
> Cheers,
> Simon
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> 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] Size of description column not shrinkable?

[Fred Tydeman]

Try doing
Going from right to left
Double click the column headers / titles area
eg, Balance, then Credit, then Debit, then Transfer, then Description
___
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] Accounting Period Change issue

[Fred Tydeman]

In trying to track down a Total (Period) issue,
I used Edit -> Preferences -> Accounting Period
to change the Start Date and End Date fields
to Absolute dates.
After doing Close of that dialog,
there appeared to be no change
in the values in the Total (period) column.
I expected a change, but maybe it is working as designed.

However, after closing and reopening GnuCash,
there then were changes in the values.
___
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] Wrong Total(Period)

[Fred Tydeman]

All of the (sub)accounts have either
  no transactions
  no transactions in 2023
So, for 2023, they all should be zero.
Doing an Income report for those gets zero.

On Thu, Dec 14, 2023 at 4:17 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I'm not familiar with how it works with multiple currencies, but at
> first glance, that looks like the sub-accounts are rolling up to the
> parents, which is as expected.
>
___
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] Wrong Total(Period)

[Fred Tydeman]

I have run Check & Repair All (which runs for about 10 minutes).
Still have the wrongTotal(Period) value.

Trying on a different system:
OS: Fedora Linux 39
GnuCash: 5.4; build ID 5.3-412
Still have the Total(Period) showing a value, yet all of the
sub-accounts have no transactions in 2023.



On Wed, Dec 13, 2023 at 5:10 PM Fred Tydeman  wrote:

> OS:  Fedora Linux 36
> GnuCash: 4.14
>
> Looking at the expanded Chart of Accounts, Total(Period) shows a non-zero
> amount
> for a specific Income account.  Yet, all of the accounts and sub-accounts
> involved
> have 0 for Total(Period).  There are no transactions for this year for any
> of these accounts.
> I have also run an Income Statement for just those accounts for
> this period,
> and it shows zero.  Accounting period is Start of this year and End of
> this year.
> The accounts are a mixture of USD and COP.
>
> Assuming the screenshot makes it to the list, the columns are:
> AccountName  Description  Total  Total(USD)  Total(Period)
>
> Both of the accounts Colombia and Interest have zero transactions in them.
>
___
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] Wrong Total(Period)

[Fred Tydeman]

OS:  Fedora Linux 36
GnuCash: 4.14

Looking at the expanded Chart of Accounts, Total(Period) shows a non-zero
amount
for a specific Income account.  Yet, all of the accounts and sub-accounts
involved
have 0 for Total(Period).  There are no transactions for this year for any
of these accounts.
I have also run an Income Statement for just those accounts for this period,
and it shows zero.  Accounting period is Start of this year and End of this
year.
The accounts are a mixture of USD and COP.

Assuming the screenshot makes it to the list, the columns are:
AccountName  Description  Total  Total(USD)  Total(Period)

Both of the accounts Colombia and Interest have zero transactions in them.
___
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] Adding security during import

[Fred Tydeman]

When I import a QIF file that contains stocks that GnuCash does not know
about, I get a screen to provide details about Tradable commodities.

It would be nice if there were a button at the bottom to advance to the
next security (in addition to the existing advance to the next screen ==
QIF import)

I realize I can click on Back after clicking on Next, to get back to the
Tradable commodities screen to do other stocks (when I clicked on Next by
mistake).
___
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] GNU Cash not performing math functions correctly on entry [SOLVED]

[Fred Tydeman]

In GC of 4.14 using Automatic Decimal,  1/3 gets 0.33, while 1./3 gets 33.33

On Fri, Dec 1, 2023 at 9:42 AM Fred Bone  wrote:

> On 01 December 2023 at 0:27, Adrien Monteleone said:
>
> > It is working fine here on MacOS and Linux Mint.
> >
> > Can you replicate it with a fresh test book using all default settings?
>
> I can readily replicate it on my copy of 2.6.21:
>
> 1. Check the "automatic decimal point" setting (with 2dp)
> 2. Enter "2.40/6" into a suitable box
> 3. Result is "40.00"
> 4. Uncheck
> 5. Repeat 2
> 6. Result is "0.40"
>
> I conclude that no-one is using the "automatic decimal point" setting who
> also uses the arithmetic-expressions feature, otherwise this would have
> been noticed before now. 2.6.21 has been around for quite a while
> (2018-04-10)
>
>
> ___
> 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] GNU Cash not performing math functions correctly on entry [SOLVED]

[Fred Tydeman]

In GC 4.14, using Automatic Decimal of 2

On Fri, Dec 1, 2023 at 9:42 AM Fred Bone  wrote:

> On 01 December 2023 at 0:27, Adrien Monteleone said:
>
> > It is working fine here on MacOS and Linux Mint.
> >
> > Can you replicate it with a fresh test book using all default settings?
>
> I can readily replicate it on my copy of 2.6.21:
>
> 1. Check the "automatic decimal point" setting (with 2dp)
> 2. Enter "2.40/6" into a suitable box
> 3. Result is "40.00"
> 4. Uncheck
> 5. Repeat 2
> 6. Result is "0.40"
>
> I conclude that no-one is using the "automatic decimal point" setting who
> also uses the arithmetic-expressions feature, otherwise this would have
> been noticed before now. 2.6.21 has been around for quite a while
> (2018-04-10)
>
>
> ___
> 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] I need basic help

[Fred Tydeman]

At top left of screen, click on Accounts.
Then under Account Name, click on Expenses
Then click on New at top of screen.
that will get you a popup to create a new account.

On Wed, Oct 25, 2023 at 10:02 AM Edwin Booth via gnucash-user <
gnucash-user@gnucash.org> wrote:

> How do I add a new Expense Account? I’d like to assign transactions in my
> CC (liability) account to a few additional expense accounts. GnuCash said I
> could “add more later” but I cannot seem to do it right. Do I have to
> assign that account to some different top-level account?
>
___
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] Bad date not caught

[Fred Tydeman]

In an account, I clicked on Duplicate of a transaction.
I got a small popup with the date field highlighted.
I typed in 5.19.21  (instead of the correct 5/19/21) and pressed enter.
That got me the transaction duplicated, but with the
date of 12/31/1969.
Seems like the code should warn me about bad date.

I am running GnuCash 4.14
on Linux Fedora 37
___
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] Stock quotes hung

[Fred Tydeman]

I am back home and stock quotes is working fine.
So, my problem must have been a very slow internet connection.
It would be nice if there were some way to cancel a stock quote fetch
in progress.  I had to reboot the entire Linux system before.

On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman  wrote:

> I was wrong.  The gnucash-cli command, after a couple of minutes, did
> finish.
> And looking at the price history, it did get the AT&T price for yesterday.
> So, it looks like things are very slow for some reason.
> Perhaps the internet at this airbnb is causing problems.
>
> On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman 
> wrote:
>
>> I have removed Get Quotes for all of my stocks and have just GBP currency
>> getting quotes.
>> Doing the gnucash-cli command works.
>>
>> If I add in just one stock (T == AT&T), gnucash-cli hangs.
>>
>> I tried adding in --debug to that gnucash-cli, but nothing stood out as a
>> problem.
>>
>> Suggestions?
>>
>
___
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] Stock quotes hung

[Fred Tydeman]

I was wrong.  The gnucash-cli command, after a couple of minutes, did
finish.
And looking at the price history, it did get the AT&T price for yesterday.
So, it looks like things are very slow for some reason.
Perhaps the internet at this airbnb is causing problems.

On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman  wrote:

> I have removed Get Quotes for all of my stocks and have just GBP currency
> getting quotes.
> Doing the gnucash-cli command works.
>
> If I add in just one stock (T == AT&T), gnucash-cli hangs.
>
> I tried adding in --debug to that gnucash-cli, but nothing stood out as a
> problem.
>
> Suggestions?
>
___
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] Stock quotes hung

[Fred Tydeman]

I have removed Get Quotes for all of my stocks and have just GBP currency
getting quotes.
Doing the gnucash-cli command works.

If I add in just one stock (T == AT&T), gnucash-cli hangs.

I tried adding in --debug to that gnucash-cli, but nothing stood out as a
problem.

Suggestions?
___
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] Stock quotes hung

[Fred Tydeman]

Is there an easy way to add or remove Get Quotes for many stocks at a time?

On Sat, Sep 9, 2023 at 11:50 AM john  wrote:

>
> GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The
> info and dump commands were added to gncuash-cli --quotes in 5.0.
>
> FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem
> isn't with Yahoo! messing with their URI again. Most likely there's an
> issue with one of your more thinly-traded securities, so repeat the triage
> steps from when this happened a few weeks ago to figure out which one.
>
>
___
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] Stock quotes hung

[Fred Tydeman]

I am running GnuCash 4.14 on Fedora Linux 37

Last weekend, I could get stock quotes.
Yesterday and today, all I get is a spinning circle.
I end up rebooting Linux to get out of a hung session.
All of my stocks are getting prices from yahoo as json.

In looking at the online documentation in 11.3 about gnucash-cli,
I have tried
gnucash-cli --quotes info
and
gnucash-cli --quotes dump
Both get:  Unknown quotes command 'info' and 'dump'.

Doing
gnucash-cli --quotes get /lindata/GnuCash/tybor/tybor.gnucash
gets: Found Finance::Quote version 1.58
and a hung session.

Suggestions?
___
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] Intl currencies

[Fred Tydeman]

I am tracking COP, EUR, GBP, THB about every two weeks.
My base currency is USD.
After doing Tools: Price database: Get Quotes,
I see that EUR, GBP, and THB all have today's prices.
But not COP.  There are entries for COP up until around 07/18/2023.
However, under USD, there is an entry for COP for today as well
as two weeks ago and four weeks ago.  Why the difference?

I am running GC 4.14 on Linux.
___
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] Month date in report

[Fred Tydeman]

In the Asset Chart (Assets over time) report, picking a step size of
one month, is there a way to have it use the last day of the month
(instead of the first day of the month)?
___
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] Consolidation of family member accounts

[Fred Tydeman]

Based upon my usage of keeping three separate "trusts" in the same one
file/book,
If multiple family members own the same stock,
then the Trading transactions will be a pain to keep correct.
I gave up and went with three separate files/books.

On Mon, Aug 14, 2023 at 12:00 PM James Thomas  wrote:

> I’m not sure why you’re maintaining separate books for each family member
> but it occurs to me that, rather than keeping them separate and having
> trouble combining when you want, you might try keeping all the accounts
> together but giving each a different name (perhaps just add each  family
> member’s initials before each account name). Then you could produce
> statements which included only those accounts pertaining to one entity at a
> time.
>
> You could even make each entity account subsidiary to its master account
> which (the master accounts) would then be the sum of all combined and could
> be displayed exclusively in the combined entity statements.
>
> Without trying it myself I’m not sure how many challenges might arise out
> of this but it might be worth giving a shot.
>
>
___
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] Convert Money Market stock acnt to Bank acnt

[Fred Tydeman]

Is there an easy way to convert a money market stock account
to a bank account?

Since the price is always $1, and each transaction has Trading splits, the
money market accounts are adding extra data to the book file and the price
history file.
___
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] Addition to basis

[Fred Tydeman]

Thank you for the instructions.

I started with my existing transaction with the Imbalance split in one
of the Income accounts.

In the Imbalance split, I changed the Imbalance account to the stock
asset account.  Pressed tab twice.  Got a popup of Transfer Funds.
Changed the Currency transfer Exchange Rate to 1.0 and clicked on OK.
Clicked on Enter at top of screen.  That filled in the Trading account
transactions.

Moved cursor to the stock asset split and clicked on Jump at top of
screen.

Now, in the stock asset account I (mostly) followed your instructions.
Cursor in stock asset split.  Type in Memo/description, tab to stock
asset account (already filled in), tab, 0.0 (for shares), tab, 0.0
(for price), tab, tab, Click on Enter at top of screen.

On Tue, Aug 8, 2023 at 8:24 PM David Carlson 
wrote:

> The trick to adjusting the basis of a security position in GnuCash is to
> start in the security account register then when on the security split line
> of the transaction fill in description Tab enter security name Tab enter
> zeroTtab enter zero Tab enter the currency value (negative to reduce basis)
> Tab Tab into next split line.  The income or loss goes in another line with
> the income account.
>
> IIRC There is a description in chapter 9 of the Tutorial.
>
___
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] Addition to basis

[Fred Tydeman]

I am getting the numbers from my Fidelity 2022 tax report.
It has the following sections:
 1099-DIV
 1099-INT
 1099-MISC
 1099-B
 1099-DIV
  Account Fees
  Addition to Basis
  Foreign Income and Taxes Summary

Two of my mutual funds had Addition to Basis information.
  DFA Int'l Small Cap Value
  DFA Int'l Small Company Portfolio



On Tue, Aug 8, 2023 at 7:52 PM Brad Morrison  wrote:

> Hi Fred/Derek/flywire/all,
>
> Maybe I am just not understanding the situation as you are describing
> it, but I have not ever seen a 1099DIV (the USA's IRS form for
> accounting for dividend payments -
> https://www.irs.gov/forms-pubs/about-form-1099-div) that also listed
> basis adjustments on it...? But I have only seen a few foreign/non-US
> dividend statements...
>
> I understood basis adjustments to be accounted for when the asset is
> sold and the most common adjustments for US stocks are wash sales, but I
> can't ever remember seeing those noted on a 1099DIV, they are usually
> recorded on a 1099B (https://www.irs.gov/forms-pubs/about-form-1099-b).
>
> If the asset is not being sold/disposed of
> (https://www.irs.gov/forms-pubs/about-schedule-d-form-1040 &
> https://www.irs.gov/taxtopics/tc703), would just making a note that
> could carry forward to the next year be the easiest thing to do?
>
> Maybe I am just not understanding, are there more details that you could
> share with us?
>
> Thanks,
>
> Brad
>
> P.S. Although I like to include all the related emails in my response,
> Thunderbird (the email client I use -
> https://www.thunderbird.net/en-US/) is separating flywire's email, even
> though it has the same subject line, from Fred & Derek's emails...?
>
>
> On 8/8/23 13:32, Derek Atkins wrote:
> > Hi,
> >
> > On Tue, August 8, 2023 4:12 pm, Fred Tydeman wrote:
> >> How does one record an Addition to basis for a stock?
> >>
> >> The splits involved are:
> >>Income: qualified div
> >>Income:  non-qualified div
> >>Expense: foreign tax
> >>Asset: cash
> >>Imbalance -- should be addition to basis
> >>
> >> I have tried changing the Imbalance to
> >>Asset: stock
> >> with a price of 0.00, but gnucash adds shares with a price of 1.00
> > ISTR there are "issues" with this...  Keep in mind, when entering data in
> > the stock account, you need to enter TWO of the three values (#shares,
> > price, and value), and GnuCash will compute the third.  Note that it's
> the
> > #shares and total value that is stored, the price is always computed.  In
> > THIS particular case, you can TRY to enter 0 shares and the change in
> > value, but I'm not 100% sure GnuCash will like that.  It's been a while
> > since I played in the stock accounts.
> >
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > -derek
> >
> ___
> 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] Addition to basis

[Fred Tydeman]

How does one record an Addition to basis for a stock?

The splits involved are:
  Income: qualified div
  Income:  non-qualified div
  Expense: foreign tax
  Asset: cash
  Imbalance -- should be addition to basis

I have tried changing the Imbalance to
  Asset: stock
with a price of 0.00, but gnucash adds shares with a price of 1.00
___
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] Small amount

[Fred Tydeman]

I am trying to record a sale of a crypto coin and a purchase with that cash.

Sell 76 "A"  for $0.006 total
Buy 0.1 "B" for 0.06/share for $0.006 total

But, the system keeps changing the total buy/sell $ to 0.01 from 0.006

Is there a way to keep more digits in the USD?

I changed the parent crypto account to USD with smallest fraction of 1/1000
and that did not work.
___
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] Ideas and recommendations for community project

[Fred Tydeman]

On Tue, Aug 1, 2023 at 7:43 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> And yet, apart from that, it would already help me a lot if there was an
> idea how I could promptly and internally (i.e. without all tax aspects
> and legal requirements) map the (partial) payments of members and their
> shares in the overall project, because the other tasks will take up
> quite a bit of time, I fear.
>

I might be doing something similar.

For a hotel being built, I bought 3 shares on credit in a private company
In the Assets:Investment:Hotel   which is an Account Type of Stock
I bought 3 shares with the money for those shares coming from
Liabilities:Loans:Hotelwhich is an Account Type of Liability.

Then, as I get income from other places, that income is used to
pay off the Hotel loan.

So, perhaps, you could replace "Hotel" with "person1", "person2", ...
in the above.
___
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] Currency conversion

[Fred Tydeman]

I have noticed that my Price Database has both
 COP -> USD
and
 USD -> COP
conversion rates.
Does it matter?
___
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] Income Statement versus Transaction Report

[Fred Tydeman]

On Wed, Jul 19, 2023 at 9:09 PM Steve Butler 
wrote:

> Look on the currency tab if I remember correctly.
>

Transaction Report: Options: Currency: Price source: Last up through report
date.
Income Statement: Options: Commodities: Price source: Last up through
report date.

So, they are the same.  Yet reports differ.
___
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] Income Statement versus Transaction Report

[Fred Tydeman]

On Wed, Jul 19, 2023 at 9:44 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I could be mistaken, but if you wanted each and every transaction to be
> converted to the FX rate at the time of each transaction, then the only
> way to do that would be with trading accounts turned on when you entered
> them. (or turn them on and re-create/edit each one, but that could be an
> enormous amount of work.)
>
> In such a case, trading splits are added to cross-currency transactions
> when they are entered.
>

I have Trading turned on.

The income accounts in question are using COP as their currency.
Transactions in those accounts do not show any splits for Trading.

Income in those accounts is coming from an Asset account that also is in
COP.

So, there is no conversion between COP and USD involved in that transaction.
___
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] Income Statement versus Transaction Report

[Fred Tydeman]

On Wed, Jul 19, 2023 at 8:24 PM David Cousens 
wrote:

> Fred,
>
> You may need to look at the report options for the transaction report to
> ensure
> they match the settings used for the income statement report particularly
> the
> setting for beginning and end dates and the account settings.
>

Both reports are:  Start of previous year and End of previous year
Both reports select all the Income accounts.

In playing around, if I change
  Commodities: Price Source:
to
  Weighted average of all transactions in the past,
then the two reports match.  But, the Transaction
report is using the same COP/USD conversion
for each month (instead of the proper monthly
conversion rate).
___
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] Income Statement versus Transaction Report

[Fred Tydeman]

In looking at Income Statement versus Transaction Report for just
Income accounts for all of last year, the numbers do not match.

My main currency is USD.  However, for this file, all the income
was in COP.  Now, during the year the number of COP / USD varied
a lot: from around 3748 to 4846; year end was 4846.

For Report Options, I am picking:
   Commodities: Price Source: Last up through report date.

It appears that the Income Statement sums up all the COP
for the year and uses the year end COP/USD value.

While the Transaction Report uses the month end COP/USD value
for the transactions in that month.

I believe that the US tax people want foreign transaction values
converted to USD at the time of the transaction (not use the
year end COP/USD value).  So, I think the Transaction Report
has the correct values.

Is there a way to have the Income Statement use values like the
Transaction Report?
___
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] Cannot alter Trading value

[Fred Tydeman]

On Tue, Jul 18, 2023 at 9:13 AM john  wrote:

> To change the price in a bank register, right-click the stock split and
> select "Edit Exchange Rate" from the pop-up menu. In the exchange rate
> section of the resulting transfer dialog select the "amount" radio button
> and enter the number of shares to let GnuCash calculate the price. Remember
> that doing it that way avoids rounding issues that can arise when you enter
> the price and have GnuCash calculate the amount.
>

If I am in the stock Asset account, when I click Actions (top of screen),
then Edit Exchange Rate,
I get a popup:  This register does not support editing exchange rates.

If I am in the  Equity account (stock was a gift), when I click Actions
(top of screen), then Edit Exchange Rate,
I get a popup:  The two currencies involved equal each other.

If I am in the Equity account, with the 4 splits showing, Right click on
split with stock,
then click on Edit Exchange Rate, I get the popup that lets me change the
price per share.
If I then click on Enter on top of screen, the Trading split is finally
correct.  Thanks.
___
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.