Re: [GNC] Stocks with prices in more than one currency

[Fred Tydeman]

This bug report has more details and the reason the current price was not
used.

https://bugs.gnucash.org/show_bug.cgi?id=799453

On Thu, Oct 31, 2024 at 10:08 PM Kalpesh Patel 
wrote:

> While I don't know the full background on your situation, something is not
> adding up right. If the setup for your book is correct then the exchange
> rate between two currencies should reconcile the report to correct value
> for the Advance Portfolio and the Current Value for 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.

Re: [GNC] GnuCash 5.9 on macOS 15.2 Dev Beta

[John Ralls]

I have, plus David Reiser reported yesterday "No problems on 15.1 using Gnucash 
5.9 arm-64 version”.

Regards,
John Ralls


> On Nov 2, 2024, at 18:26, William Prescott  wrote:
> 
> From Seth's comment below, it appears that the problem is only with MacOS 
> 15.2, the public beta. Has anyone else confirmed that Gnucash 5.9-1 runs okay 
> on MacOS 15.1?
> 
> Best wishes,
> Will
> 
> On 2 Nov 2024, at 14:04, John Ralls  wrote:
> 
> I tried to work around this by building libgc as a static library and linking 
> it to guile with -hidden-l that’s supposed to keep its symbols private. Dyld 
> found it anyway:
> Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
> 0   libsystem_kernel.dylib   0x19829d700 __pthread_kill + 8
> 1   libsystem_pthread.dylib  0x1982d5f70 pthread_kill + 288
> 2   libsystem_c.dylib0x1981e2908 abort + 128
> 3   libguile-2.2.1.dylib 0x1031c7584 
> GC_add_roots_inner.cold.1 + 36 (mark_rts.c:253)
> 4   libguile-2.2.1.dylib 0x1031bd040 GC_add_roots_inner + 
> 308 (mark_rts.c:253)
> 5   libguile-2.2.1.dylib 0x1031b6018 GC_dyld_image_add + 
> 336 (dyn_load.c:1344)
> 6   dyld 0x197f62fe0 invocation function 
> for block in dyld4::RuntimeState::notifyLoad(std::__1::span const*, 18446744073709551615ul> const&) + 248
> 
> I’ve filed feedback with Apple. I can’t think of another way to work around 
> it; I haven’t found a way to disable WritingTools inserting itself in the 
> NSView.
> 
> Regards,
> John Ralls
> 
> 
>> On Oct 30, 2024, at 20:46, John Ralls  wrote:
>> 
>> Save yourself the trouble of diving in to the rabbit hole and notice that 
>> the stack trace features WritingToolsUILibraryCore in Frame 11.  It looks 
>> like it’s trying to insert Writing Tools stuff into a menu. The actual crash 
>> seems to be in libgc, a dependency of Guile.
>> 
>> Homebrew just wraps our dmg. You can prove this to yourself by running 
>> codesign on Gnucash.app to see who signed it.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Oct 30, 2024, at 07:45, Seth Hamstead  wrote:
>>> 
>>> Thank you for confirming.  That is the same crash report I’m getting (which 
>>> I now realized I should have included).  I also tried installing it via 
>>> brew and got the same results.  Spun up a virtual machine with macOS15.1 on 
>>> the same system and it launched fine.  I see a possible rabbit hole in my 
>>> future.
>>> 
>>> Seth Hamstead
>>> s...@hamstead.net
>>> 
 On Oct 30, 2024, at 09:32, David Reiser  wrote:
 
 
 
> On Oct 28, 2024, at 17:55, Seth Hamstead  wrote:
> 
> Is anyone having issues using GnuCash 5.9 on Apple Silicon (M1) running 
> macOS15.2 Developer Beta 1?  The app crashes as soon as it is launched 
> and I have tried scrubbing the system of all GnuCash files and 
> reinstalling.  I mistakenly moved the GnuCash files while updating the 
> machine which is why I’m wondering if this is a beta OS issue or possibly 
> a file issue.  TIA
 
 Crashes on launch for me too. No problems on 15.1 using Gnucash 5.9 arm-64 
 version
 
 Process:   Gnucash [1602]
 Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
 Identifier:org.gnucash.Gnucash
 Version:   5.9-1 (5.9-1)
 Code Type: ARM-64 (Native)
 Parent Process:launchd [1]
 User ID:   502
 
 Date/Time: 2024-10-30 10:24:36.3313 -0400
 OS Version:macOS 15.2 (24C5057p)
 Report Version:12
 Anonymous UUID:1470AA79-A889-1423-C4C6-47CEF5F004B4
 
 
 Time Awake Since Boot: 280 seconds
 
 System Integrity Protection: enabled
 
 Crashed Thread:0  Dispatch queue: com.apple.main-thread
 
 Exception Type:EXC_CRASH (SIGABRT)
 Exception Codes:   0x, 0x
 
 Termination Reason:Namespace SIGNAL, Code 6 Abort trap: 6
 Terminating Process:   Gnucash [1602]
 
 Application Specific Information:
 abort() called
 
 
 Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
 0   libsystem_kernel.dylib0x192cb1700 __pthread_kill + 8
 1   libsystem_pthread.dylib   0x192ce9f70 pthread_kill + 288
 2   libsystem_c.dylib 0x192bf6908 abort + 128
 3   libgc.1.dylib 0x102a4ff6c 
 GC_add_roots_inner.cold.1 + 32
 4   libgc.1.dylib 0x102a3fc80 GC_add_roots_inner + 
 312
 5   libgc.1.dylib 0x102a4ee94 GC_dyld_image_add + 
 336
 6   dyld  0x192976fe0 invocation function 
 for block in dyld4::RuntimeState::notifyLoad(std::__1::span>>> const*, 18446744073709551615ul> const&) + 248
 7   dyld 

Re: [GNC] Archive?

[R Losey]

Yes, that's it... I originally felt foolish, but gmail is hiding the
headers from me, so I didn't see it.

On Sat, Nov 2, 2024 at 11:19 AM dewaj  wrote:

> On Sat, 2 Nov 2024 11:10:18 -0500
> R Losey  wrote:
>
> > Which leads to the question: Are these emails archived somewhere that
> > I can search for topics?
> >
>
> From the email headers:
>
> "List-Archive: "
>
> Is this what you're looking for?
>
> --
> dj
> ___
> 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.
>


-- 
_
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] Forces Rebalance Causes Fatal Error - Now with images

[John Ralls]

Crashes are bugs, but some bugs have been fixed. Make sure that you’re using 
the latest release (5.9); if you’re on Windows or Linux consider using a 
nightly build from https://code.gnucash.org/builds/win32/stable or 
https://code.gnucash.org/builds/flatpak/stable to get the absolute latest.

Try to get a stack trace (https://wiki.gnucash.org/wiki/Stack_Trace) but at 
least include a trace file (https://wiki.gnucash.org/wiki/Tracefile), then file 
a bug report at https://bugs.gnucash.org/. 

Regards,
John Ralls


> On Nov 2, 2024, at 07:49, Griffin  wrote:
> 
> 
> On 2024-10-30 2:56 p.m., Griffin wrote:
>> Hi,
>> 
>> I am trying to reconcile accounts that have got way behind. They are stock 
>> (options) trades that might have been entered before I understood how 
>> trading accounts should be setup.
>> 
>> When I view the register for the account, I notice some of the records 
>> display a box with a square in it, in the top left corner of both the 
>> deposit and the Withdrawal field. When I tab through the deposit and the 
>> withdrawal fields as the focus leaves the withdrawal field, a dialog pops 
>> saying the transaction needs to be rebalanced.
>> 
>> The transaction split looks like this. You can see the box with a cross in it
>> 
>> As I don't know what needs to be balanced I click on "Let GnuCash add an 
>> adjusting split", and I click .
>> 
>> The transaction split, then looks like this.
>> 
>> As I move onto the next transaction, and follow the exact same steps, after 
>> clicking on , there is a pause of 1 to 2 seconds, following which 
>> GnuCash silently crashes.
>> 
>> When I reopen GnuCash I am presented with cannot get a lock popup
>> 
>> I can delete the file 2024 Accounts.gnucash.LCK to restart GnuCash.
>> 
>> Nothing has been changed of course, and there was no time to save anything. 
>> Some times Even the first try ends abnormally.
>> 
>> Any ideas, anyone, Bueller… anyone?
>> 
>> 
> 
> -- 
> This email has been checked for viruses by Avast antivirus software.
> www.avast.com Rebalance.png>___
> 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] GnuCash 5.9 on macOS 15.2 Dev Beta

[William Prescott]

From Seth's comment below, it appears that the problem is only with MacOS 15.2, 
the public beta. Has anyone else confirmed that Gnucash 5.9-1 runs okay on 
MacOS 15.1?

Best wishes,
Will

On 2 Nov 2024, at 14:04, John Ralls  wrote:

I tried to work around this by building libgc as a static library and linking 
it to guile with -hidden-l that’s supposed to keep its symbols private. Dyld 
found it anyway:
Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib 0x19829d700 __pthread_kill + 8
1   libsystem_pthread.dylib0x1982d5f70 pthread_kill + 288
2   libsystem_c.dylib  0x1981e2908 abort + 128
3   libguile-2.2.1.dylib   0x1031c7584 
GC_add_roots_inner.cold.1 + 36 (mark_rts.c:253)
4   libguile-2.2.1.dylib   0x1031bd040 GC_add_roots_inner + 
308 (mark_rts.c:253)
5   libguile-2.2.1.dylib   0x1031b6018 GC_dyld_image_add + 
336 (dyn_load.c:1344)
6   dyld   0x197f62fe0 invocation function 
for block in dyld4::RuntimeState::notifyLoad(std::__1::span const&) + 248

I’ve filed feedback with Apple. I can’t think of another way to work around it; 
I haven’t found a way to disable WritingTools inserting itself in the NSView.

Regards,
John Ralls


> On Oct 30, 2024, at 20:46, John Ralls  wrote:
> 
> Save yourself the trouble of diving in to the rabbit hole and notice that the 
> stack trace features WritingToolsUILibraryCore in Frame 11.  It looks like 
> it’s trying to insert Writing Tools stuff into a menu. The actual crash seems 
> to be in libgc, a dependency of Guile.
> 
> Homebrew just wraps our dmg. You can prove this to yourself by running 
> codesign on Gnucash.app to see who signed it.
> 
> Regards,
> John Ralls
> 
>> On Oct 30, 2024, at 07:45, Seth Hamstead  wrote:
>> 
>> Thank you for confirming.  That is the same crash report I’m getting (which 
>> I now realized I should have included).  I also tried installing it via brew 
>> and got the same results.  Spun up a virtual machine with macOS15.1 on the 
>> same system and it launched fine.  I see a possible rabbit hole in my future.
>> 
>> Seth Hamstead
>> s...@hamstead.net
>> 
>>> On Oct 30, 2024, at 09:32, David Reiser  wrote:
>>> 
>>> 
>>> 
 On Oct 28, 2024, at 17:55, Seth Hamstead  wrote:
 
 Is anyone having issues using GnuCash 5.9 on Apple Silicon (M1) running 
 macOS15.2 Developer Beta 1?  The app crashes as soon as it is launched and 
 I have tried scrubbing the system of all GnuCash files and reinstalling.  
 I mistakenly moved the GnuCash files while updating the machine which is 
 why I’m wondering if this is a beta OS issue or possibly a file issue.  TIA
>>> 
>>> Crashes on launch for me too. No problems on 15.1 using Gnucash 5.9 arm-64 
>>> version
>>> 
>>> Process:   Gnucash [1602]
>>> Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
>>> Identifier:org.gnucash.Gnucash
>>> Version:   5.9-1 (5.9-1)
>>> Code Type: ARM-64 (Native)
>>> Parent Process:launchd [1]
>>> User ID:   502
>>> 
>>> Date/Time: 2024-10-30 10:24:36.3313 -0400
>>> OS Version:macOS 15.2 (24C5057p)
>>> Report Version:12
>>> Anonymous UUID:1470AA79-A889-1423-C4C6-47CEF5F004B4
>>> 
>>> 
>>> Time Awake Since Boot: 280 seconds
>>> 
>>> System Integrity Protection: enabled
>>> 
>>> Crashed Thread:0  Dispatch queue: com.apple.main-thread
>>> 
>>> Exception Type:EXC_CRASH (SIGABRT)
>>> Exception Codes:   0x, 0x
>>> 
>>> Termination Reason:Namespace SIGNAL, Code 6 Abort trap: 6
>>> Terminating Process:   Gnucash [1602]
>>> 
>>> Application Specific Information:
>>> abort() called
>>> 
>>> 
>>> Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
>>> 0   libsystem_kernel.dylib 0x192cb1700 __pthread_kill + 8
>>> 1   libsystem_pthread.dylib0x192ce9f70 pthread_kill + 288
>>> 2   libsystem_c.dylib  0x192bf6908 abort + 128
>>> 3   libgc.1.dylib  0x102a4ff6c 
>>> GC_add_roots_inner.cold.1 + 32
>>> 4   libgc.1.dylib  0x102a3fc80 GC_add_roots_inner + 
>>> 312
>>> 5   libgc.1.dylib  0x102a4ee94 GC_dyld_image_add + 
>>> 336
>>> 6   dyld   0x192976fe0 invocation function 
>>> for block in dyld4::RuntimeState::notifyLoad(std::__1::span>> const*, 18446744073709551615ul> const&) + 248
>>> 7   dyld   0x192970454 
>>> dyld4::RuntimeLocks::withNotifiersReadLock(void () block_pointer) + 100
>>> 8   dyld   0x192976810 
>>> dyld4::RuntimeState::notifyLoad(std::__1::span>> 18446744073709551615ul> const&) + 352
>>> 9   dyld   0x192998148 
>>> dyld4::APIs::dlopen

Re: [GNC] Archive?

[David Cousens]

https://www.mail-archive.com/gnucash-user@gnucash.org/

https://www.mail-archive.com/gnucash-devel@gnucash.org/

have the emails archived in a searchable, by thread and by date form.


On Sat, 2024-11-02 at 11:10 -0500, R Losey wrote:
> Hello, all... I've been a part of this email list for a couple of
> years,
> and is has been good; I've learned things about GnuCash and related
> topics.
> 
> I just noticed today, however, that I have over 10,000 emails from
> this
> group. I was thinking of deleting the oldest ones, but they may be
> useful
> to search for problems that have been asked before.
> 
> Which leads to the question: Are these emails archived somewhere that
> I can
> search for topics?
> 
> If not, how do those of you who have been on this list long-term deal
> with
> all the archives?
> 
> 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.

Re: [GNC] GnuCash 5.9 on macOS 15.2 Dev Beta

[John Ralls]

I tried to work around this by building libgc as a static library and linking 
it to guile with -hidden-l that’s supposed to keep its symbols private. Dyld 
found it anyway:
Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib 0x19829d700 __pthread_kill + 8
1   libsystem_pthread.dylib0x1982d5f70 pthread_kill + 288
2   libsystem_c.dylib  0x1981e2908 abort + 128
3   libguile-2.2.1.dylib   0x1031c7584 
GC_add_roots_inner.cold.1 + 36 (mark_rts.c:253)
4   libguile-2.2.1.dylib   0x1031bd040 GC_add_roots_inner + 
308 (mark_rts.c:253)
5   libguile-2.2.1.dylib   0x1031b6018 GC_dyld_image_add + 
336 (dyn_load.c:1344)
6   dyld   0x197f62fe0 invocation function 
for block in dyld4::RuntimeState::notifyLoad(std::__1::span const&) + 248

I’ve filed feedback with Apple. I can’t think of another way to work around it; 
I haven’t found a way to disable WritingTools inserting itself in the NSView.

Regards,
John Ralls


> On Oct 30, 2024, at 20:46, John Ralls  wrote:
> 
> Save yourself the trouble of diving in to the rabbit hole and notice that the 
> stack trace features WritingToolsUILibraryCore in Frame 11.  It looks like 
> it’s trying to insert Writing Tools stuff into a menu. The actual crash seems 
> to be in libgc, a dependency of Guile.
> 
> Homebrew just wraps our dmg. You can prove this to yourself by running 
> codesign on Gnucash.app to see who signed it.
> 
> Regards,
> John Ralls
> 
>> On Oct 30, 2024, at 07:45, Seth Hamstead  wrote:
>> 
>> Thank you for confirming.  That is the same crash report I’m getting (which 
>> I now realized I should have included).  I also tried installing it via brew 
>> and got the same results.  Spun up a virtual machine with macOS15.1 on the 
>> same system and it launched fine.  I see a possible rabbit hole in my future.
>> 
>> Seth Hamstead
>> s...@hamstead.net
>> 
>>> On Oct 30, 2024, at 09:32, David Reiser  wrote:
>>> 
>>> 
>>> 
 On Oct 28, 2024, at 17:55, Seth Hamstead  wrote:
 
 Is anyone having issues using GnuCash 5.9 on Apple Silicon (M1) running 
 macOS15.2 Developer Beta 1?  The app crashes as soon as it is launched and 
 I have tried scrubbing the system of all GnuCash files and reinstalling.  
 I mistakenly moved the GnuCash files while updating the machine which is 
 why I’m wondering if this is a beta OS issue or possibly a file issue.  TIA
>>> 
>>> Crashes on launch for me too. No problems on 15.1 using Gnucash 5.9 arm-64 
>>> version
>>> 
>>> Process:   Gnucash [1602]
>>> Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
>>> Identifier:org.gnucash.Gnucash
>>> Version:   5.9-1 (5.9-1)
>>> Code Type: ARM-64 (Native)
>>> Parent Process:launchd [1]
>>> User ID:   502
>>> 
>>> Date/Time: 2024-10-30 10:24:36.3313 -0400
>>> OS Version:macOS 15.2 (24C5057p)
>>> Report Version:12
>>> Anonymous UUID:1470AA79-A889-1423-C4C6-47CEF5F004B4
>>> 
>>> 
>>> Time Awake Since Boot: 280 seconds
>>> 
>>> System Integrity Protection: enabled
>>> 
>>> Crashed Thread:0  Dispatch queue: com.apple.main-thread
>>> 
>>> Exception Type:EXC_CRASH (SIGABRT)
>>> Exception Codes:   0x, 0x
>>> 
>>> Termination Reason:Namespace SIGNAL, Code 6 Abort trap: 6
>>> Terminating Process:   Gnucash [1602]
>>> 
>>> Application Specific Information:
>>> abort() called
>>> 
>>> 
>>> Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
>>> 0   libsystem_kernel.dylib 0x192cb1700 __pthread_kill + 8
>>> 1   libsystem_pthread.dylib0x192ce9f70 pthread_kill + 288
>>> 2   libsystem_c.dylib  0x192bf6908 abort + 128
>>> 3   libgc.1.dylib  0x102a4ff6c 
>>> GC_add_roots_inner.cold.1 + 32
>>> 4   libgc.1.dylib  0x102a3fc80 GC_add_roots_inner + 
>>> 312
>>> 5   libgc.1.dylib  0x102a4ee94 GC_dyld_image_add + 
>>> 336
>>> 6   dyld   0x192976fe0 invocation function 
>>> for block in dyld4::RuntimeState::notifyLoad(std::__1::span>> const*, 18446744073709551615ul> const&) + 248
>>> 7   dyld   0x192970454 
>>> dyld4::RuntimeLocks::withNotifiersReadLock(void () block_pointer) + 100
>>> 8   dyld   0x192976810 
>>> dyld4::RuntimeState::notifyLoad(std::__1::span>> 18446744073709551615ul> const&) + 352
>>> 9   dyld   0x192998148 
>>> dyld4::APIs::dlopen_from(char const*, int, void*) + 2412
>>> 10  SoftLinking0x1a097ebd8 _sl_dlopen + 100
>>> 11  AppKit 0x19715862c 
>>> WritingToolsUILibraryCore + 156
>>> 12  AppKit  

Re: [GNC] Forces Rebalance Causes Fatal Error - Now with images

[Griffin]

On 2024-10-30 2:56 p.m., Griffin wrote:

Hi,

I am trying to reconcile accounts that have got way behind. They are 
stock (options) trades that might have been entered before I 
understood how trading accounts should be setup.


When I view the register for the account, I notice some of the records 
display a box with a square in it, in the top left corner of both the 
deposit and the Withdrawal field. When I tab through the deposit and 
the withdrawal fields as the focus leaves the withdrawal field, a 
dialog pops saying the transaction needs to be rebalanced.


The transaction split looks like this. You can see the box with a 
cross in it


As I don't know what needs to be balanced I click on "Let GnuCash add 
an adjusting split", and I click .


The transaction split, then looks like this.

As I move onto the next transaction, and follow the exact same steps, 
after clicking on , there is a pause of 1 to 2 seconds, 
following which GnuCash silently crashes.


When I reopen GnuCash I am presented with cannot get a lock popup

I can delete the file 2024 Accounts.gnucash.LCK to restart GnuCash.

Nothing has been changed of course, and there was no time to save 
anything. Some times Even the first try ends abnormally.


Any ideas, anyone, Bueller… anyone?




--
This email has been checked for viruses by Avast antivirus software.
www.avast.com___
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] Importing CSV exchange rate prices

[Andrew Beattie]

Hi all

I’m successfully importing stock prices in multiple currencies into gnucash, 
but can’t seem to find a way to import exchange rates.  I’ve tried setting 
namespace to “Currencies” which is what’s used in the price editor, but the 
import routine highlights any line with namespace Currencies in red and says 
not all fields could be parsed.  

Is it possible to import exchange rates in this way - I’ve down quite a bit of 
googling on it and not found an solution.

Many thanks

Andrew

PS - Here’s an example of the contents of a CSV file where the first two lines 
of data are parsed and imported, but the third fails as above.

Namespace   SecurityDateCurrencyPrice
LSEETF  FTSE Dev Eur31/10/2024  GBP 33.12
NASDAQ  NVDA31/10/2024  USD 135.40
Currencies  USD 31/10/2024  GBP 0.77
___
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] Importing CSV exchange rate prices

[Jim DeLaHunt]

Andrew:

On 2024-11-02 05:27, Andrew Beattie wrote:

Hi all

I’m successfully importing stock prices in multiple currencies into gnucash, 
but can’t seem to find a way to import exchange rates.  I’ve tried setting 
namespace to “Currencies” which is what’s used in the price editor, but the 
import routine highlights any line with namespace Currencies in red and says 
not all fields could be parsed.

Is it possible to import exchange rates in this way - I’ve down quite a bit of 
googling on it and not found an solution.


Simple, just look in the GnuCash tutorial and guide, section 9.6. 
Setting Share Price 
... oh, 
nothing there about importing prices.


Ah well, at least the GnuCash wiki has an article "CSV Import/Export", 
with section 1.3 "Importing Prices" 
... 
oh, that section is empty.


Well, I know that I used to import currency exchange rates from my 
currency to a couple of other major currencies in the past, but I don't 
have notes at hand about exactly how I did it.


You are using the menu item File… Import… Import prices from a CSV 
file…, right?


The first page of the price import assistant has an example currency 
import table:

CURRENCY;USD:2016-11-21;1.56;GBP

Do your CSV file lines have those columns? Do the instructions on that 
page help?


If you do figure something out, I encourage you to write instructions in 
the above Wiki page on CSV Import/Export. Whatever you can contribute, 
it will be better than literally nothing.


Best regards,
 —Jim DeLaHunt
___
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 imports failing

[Geoff]

Hi Liz

I suspect that your problem is this bug that was fixed in release 5.7:

https://bugs.gnucash.org/show_bug.cgi?id=799262

Regards

Geoff
=

On 3/11/2024 8:16 am, Liz wrote:

Gnucash Version: 5.6
Build ID: 5.6+(2024-03-30)
Finance::Quote: 1.62

Debian GNU/Linux trixie/sid

I have tried 2 QIF imports on different accounts and had both fail. I
used to do this without difficulty, and I don't know if it is a problem
with the file supplied by the bank or if it is in Gnucash.

One screenshot shows the error "Missing QIF Investment action for
transaction dated 31/10/24" and the other the list of transactions for
that date.

Any ideas?

Liz


___
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] Stocks with prices in more than one currency

[Patrick James via gnucash-user]

Fred,

The basic challenge here is that you don't seem to know how data gets into your 
GnuCash database. There are some very crafty people reading this list, so I'm 
not going to exclude the possibility that one might be able to explain how 
different currencies were entered into your GnuCash data, yet at the same time 
I'm going to bet that it would make things much easier if you could explain how 
both USD and CAD data ended up in your data.

Even if you don't know when the specific entries were created, maybe you can 
explain your workflow.


> On 11/02/2024 2:06 AM PDT Fred Tydeman  wrote:
> 
>  
> This bug report has more details and the reason the current price was not
> used.
> 
> https://bugs.gnucash.org/show_bug.cgi?id=799453
> 
> On Thu, Oct 31, 2024 at 10:08 PM Kalpesh Patel 
> wrote:
> 
> > While I don't know the full background on your situation, something is not
> > adding up right. If the setup for your book is correct then the exchange
> > rate between two currencies should reconcile the report to correct value
> > for the Advance Portfolio and the Current Value for 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.
___
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] Archive?

[David H]

Clicking on the subscription preferences link you'll see in the email
footer (copied below), gives you some options including a link to the
search instructions (also copied below) using google search, forget the
nabble search option as it's been gone for ages.

Cheers David H.

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


No local search

Currently, there is no on-site mechanism to search the GnuCash mailing
lists. Instead, you can search the lists using one of these external sites:

   - Google
   
   - Nabble
   

These links prepopulate the search form with the list you want to search.

If for some reason that didn't happen (e.g. if JavaScript is disabled):
For GoogleIn the search bar, type site:lists.gnucash.org/pipermail/list-name to
search a specific list, or site:lists.gnucash.org to search them allFor
NabbleBy default, all of the lists will be searched. The individual lists
can be found at the *Sub-forums* link

On Sun, 3 Nov 2024 at 02:11, R Losey  wrote:

> Hello, all... I've been a part of this email list for a couple of years,
> and is has been good; I've learned things about GnuCash and related topics.
>
> I just noticed today, however, that I have over 10,000 emails from this
> group. I was thinking of deleting the oldest ones, but they may be useful
> to search for problems that have been asked before.
>
> Which leads to the question: Are these emails archived somewhere that I can
> search for topics?
>
> If not, how do those of you who have been on this list long-term deal with
> all the archives?
>
> Thanks!
>
> --
> _
> 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.
>
___
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] Forces Rebalance Causes Fatal Error - Now with images

[Jim DeLaHunt]

Hello, Griffin, and welcome to GnuCash.

Thank you for providing screen excerpts in your previous message. That 
helps me understand. Maybe I can give you some insight. See my replies 
interleaved below.


On 2024-11-02 07:49, Griffin wrote:


On 2024-10-30 2:56 p.m., Griffin wrote:

Hi,

I am trying... 


OK, before you go any further.

What version of GnuCash are you running, and on what operating system?  
(I'm going to guess Windows, but please tell us explicitly.) Different 
versions of GnuCash behave differently. This basic information is important.


...to reconcile accounts that have got way behind. They are stock 
(options) trades that might have been entered before I understood how 
trading accounts should be setup.


When I view the register for the account, I notice some of the 
records display a box with a square in it, in the top left corner of 
both the deposit and the Withdrawal field 


What is the Account Type of this account? I am guessing it is Stock or 
Mutual Fund.  See 
 for a 
list of account types.   The registers for different account types 
behave differently.


What is happening in the transaction you are showing us?   I suspect it 
is a sale of a stock "NCLH" for Canadian Dollars, but it might be a 
purchase.


What I see in your screen excerpt "Transaction split.jpg" is that each 
cell in the credit and debit columns have a small shape drawn with thin 
black lines, forming a square having diagonals drawn that form an "X". 
This shape appears in every row, whether the background colour is green, 
light beige, or vivid yellow.  This excerpt shows a transaction — a 
stock sale or purchase — containing one split in CAD currency and one 
split in NCLH stock. This transaction is not balanced (see below). 
Another of your screen excerpts, "After Rebalance.jpg", does not have 
these small shapes in the debit and credit columns.


I speculate that these small squares are an artifact of the technology 
going wrong — maybe in a small way, maybe large. They might be a place 
where GnuCash can draw indicators of some kind. Perhaps the indicators 
have to do with the transaction not being balanced. The drawing is not 
working right, and so you see these squares. If you care to take the 
time to describe this situation clearly, you might consider filing a bug 
report about it.  See  to get 
started with a bug report.


For now, I suggest you treat the small squares as a separate issue from 
your other questions.



When I tab through the deposit and the withdrawal fields as the 
focus leaves the withdrawal field, a dialog pops saying the 
transaction needs to be rebalanced.


The transaction split looks like this. You can see the box with a 
cross in it


As I don't know what needs to be balanced I click on "Let GnuCash add 
an adjusting split", and I click .


The transaction split, then looks like this.


Next, let's look at the issue of "balanced transactions". You say you 
set up this book without Trading Accounts, entered some transactions, 
then turned on Trading Accounts. You might be seeing GnuCash attempting 
to clean up the older transactions so that they become correct with 
Trading Accounts.


Three basic things to know:

1. A balanced transaction is where the sum of all the debits equals the 
sum of all the credits. If a transaction involves multiple currencies, 
then these sums are calculated separately for each currency.


2. GnuCash uses the same mechanisms for representing currencies and 
securities in the book. Thus your transaction involves the CAD currency 
and the NCLH "currency".


3. When a transaction is not balanced in one of its currencies, GnuCash 
inserts a split using Trading Accounts with whatever debit or credit 
amount brings that currency into balance for that transaction. For more 
on Trading Accounts, see 
.


What I see in "Transaction split.png" is a transaction which is not 
balanced. There is one split for 120.30 CAD, and another split for 5 
NCLH.  I can imagine that GnuCash accepted this transaction before you 
turned on Trading Accounts, and will not accept it after. What I see in 
"After Rebalance.png" is a transaction which is now balanced, via one 
split using a trading account in CAD and a second split using a trading 
account in NCLH.


Thus I think this sequence sounds like GnuCash dealing correctly with a 
transaction which is no longer acceptable given your Trading Accounts 
setting. To a first approximation, it is separate from the mysterious 
square shapes, or the crash. It is not a problem to be solved.





As I move onto the next transaction, and follow the exact same steps, 
after clicking on , there is a pause of 1 to 2 seconds, 
following which GnuCash silently crashes.


This is a separate issue. GnuCash should not not crash. When it does, 
you have thr

[GNC] Archive?

[R Losey]

Hello, all... I've been a part of this email list for a couple of years,
and is has been good; I've learned things about GnuCash and related topics.

I just noticed today, however, that I have over 10,000 emails from this
group. I was thinking of deleting the oldest ones, but they may be useful
to search for problems that have been asked before.

Which leads to the question: Are these emails archived somewhere that I can
search for topics?

If not, how do those of you who have been on this list long-term deal with
all the archives?

Thanks!

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