Re: [GNC] Crash in Trial Balance

On Sun, Aug 14, 2022 at 11:22 PM john wrote: > When the depth is "all" does crash make the same stack trace? > The traces are the "same" except for the hex numbers after the word "procedure" > Do you have a GBP->USD rate in pricedb? > Yes, I do. But, I do not understand why you are asking

Re: [GNC] Online Currency Exchange Rates

Jim, Interesting. that would require a couple of changes to Finance/Quote/CurrencyRates/AlphaVantage.pm, so how's your Perl? PRs to https://finance-quote/finance-quote/. Regards, John Ralls > On Aug 14, 2022, at 8:25 PM, Jim DeLaHunt wrote: > > On 2022-08-14 14:42, John Ralls wrote: > >>

Re: [GNC] AutoHotKey: Date Arithmetic Example

Nice work Glenn! (I still think AutoHotKey would have been a better choice than KeePass for your keystroke automation though.) I wasn't aware of UI.Vision - looks interesting, thanks for sharing. Regards Geoff = On 15/08/2022 1:00 pm, Glenn Fowler wrote: Hi, Automating the GUI is

Re: [GNC] Online Currency Exchange Rates

On 2022-08-14 14:42, John Ralls wrote: We got a bug report,https://bugs.gnucash.org/show_bug.cgi?id=798599, this morning reporting that currency exchange rates aren't working. After a bit of fiddling I got an intelligible error message: Thank you for using Alpha Vantage! This is a premium

Re: [GNC] Crash in Trial Balance

> On Aug 14, 2022, at 1:07 PM, Fred Tydeman wrote: > > > > On Sun, Aug 14, 2022 at 1:43 PM john > wrote: >> Try increasing the account depth to 6 so that Acciones Open End and $cop are >> included. > > I changed it to "All" levels and it still crashes. > >>

Re: [GNC] AutoHotKey: Date Arithmetic Example

Hi, Automating the GUI is certainly possible (basically it's just RPA). I did it using PowerShell: https://www.reddit.com/r/GnuCash/comments/mugurm/automatically_scan_ocr_receipts_invoices/ Just adding that if you are looking into Selenium I would recommend UI.Vision: https://ui.vision/ It runs

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

Thank you for your example, Kalpesh. On 2022-08-14 17:11, Kalpesh Patel wrote: Jim, In my case I actually have additional intermediate accounts like so: * Assets o Investments + Brokerage account # Bond # Mutual Fund

Re: [GNC] How to bulk import about 130 Securities entries?

Kalpesh: Thank you for the advice. > …see if your broker provides transactions in OFX format instead of CSV. But remember, I am trying to import Securities, not transactions. I am trying to automate what is done manually in Tools -- Security Editor, and pressing the Add button. Best

[GNC] AutoHotKey: Date Arithmetic Example

Hi Tom Yes, AutoHotKey is quite a powerful scripting language and has some basic date handling functionality built in. Here is a trivial example as a demonstration, but note that it fails for cases where the day of the month is greater than 28. This is easy to fix, but I don't know the

[GNC] How to bulk import about 130 Securities entries?

Jim, Not sure if anyone has mentioned or not but see if your broker provides transactions in OFX format instead of CSV. With CSV I imagine that you will have to perform some pre-processing before importing into GNC. You will have much better success in minimizing import clicks and errors

[GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

Jim, In my case I actually have additional intermediate accounts like so: * Assets o Investments + Brokerage account # Bond # Mutual Fund - Fidler * FXAIX - Vans *

Re: [GNC] Online Currency Exchange Rates

Thanks for this! I had wondered why currency retrieval was failing the last few days - thought maybe just weekend maintenance. I had checked my Alphavantage key and it was still correct so I couldn't figure out what was happening. I also couldn't see exactly where to specify a source for

[GNC] Online Currency Exchange Rates

We got a bug report, https://bugs.gnucash.org/show_bug.cgi?id=798599, this morning reporting that currency exchange rates aren't working. After a bit of fiddling I got an intelligible error message: Thank you for using Alpha Vantage! This is a premium endpoint. You may subscribe to any of the

Re: [GNC] Crash in Trial Balance

On Sun, Aug 14, 2022 at 1:43 PM john wrote: > Try increasing the account depth to 6 so that Acciones Open End and $cop > are included. > I changed it to "All" levels and it still crashes. > What is the report currency? > USD. If I switch to COP, then that crash goes away.

Re: [GNC] How to bulk import about 130 Securities entries?

The program you want to use that is the macOS equivalent of what the other reply suggested is called "Automator". As long as you have not moved it, it is located in "Launchpad > Other > Automator" or "Applications > Automator". Also, this is just a general suggestion about XML manipulation (or

Re: [GNC] How to bulk import about 130 Securities entries?

Geoff: On 2022-08-13 22:38, Geoff wrote: Hi Jim I don't have any experience manipulating GnuCash XML files, but in principle what you want to do should work, although it does void your GnuCash warranty. However, if you are going to all this effort you may find it more worthwhile to invest

Re: [GNC] Crash in Trial Balance

> On Aug 14, 2022, at 7:18 AM, flywire wrote: > > They look big numbers. I wonder if it's an overflow issue. Not that big. Display is 64-bit integers with computation done in 128 bit, so 18 digits each for numerator and denominator for display and 36 digits each for computations. Regards,

Re: [GNC] Crash in Trial Balance

Try increasing the account depth to 6 so that Acciones Open End and $cop are included. What is the report currency? Regards, John Ralls > On Aug 14, 2022, at 7:07 AM, Fred Tydeman wrote: > > As suggested in other emails, I looked at the price data base. I did find > two 0 entries and one

Re: [GNC] gnucash-user Digest, Vol 233, Issue 50

Not officially. There was a 'GnuCash for Android' created by someone else that is no longer maintained for a few years now. (it was never a part of the same project) There may be other apps that can export their transactions which you can then import to GnuCash on your computer. Maybe

Re: [GNC] How to bulk import about 130 Securities entries?

Check the 'Using GnuCash' page perhaps. Regards, Adrien On 8/14/22 9:50 AM, Tom Browder wrote: P.S. Is there a spot on the Wiki to list things like Geoff's suggestion and flycatcher's program? If not, I will be glad to start one--suggestions welcomed.

Re: [GNC] Using GnuCash with Portfolio Performance Share Software

If the issue is creating the security, why not set that up in GnuCash before the import? Am I missing something? Regards, Adrien On 8/14/22 3:06 AM, flywire wrote: Portfolio Performance also exports broker account transactions that can be normalised with a python script to import into

Re: [GNC] gnucash-user Digest, Vol 233, Issue 50

Is there an app to work with your cell/mobile phone. Thanks James Baxter kangaro...@yahoo.com  Sent from Yahoo Mail on Android On Sun, Aug 14, 2022 at 12:00 PM, gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to     gnucash-user@gnucash.org To

Re: [GNC] How to bulk import about 130 Securities entries?

On Sun, Aug 14, 2022 at 00:40 Geoff wrote: > Hi Jim > > I don't have any experience manipulating GnuCash XML files, but in > principle what you want to do should work, although it does void your > GnuCash warranty. > > However, if you are going to all this effort you may find it more >

Re: [GNC] Crash in Trial Balance report

I was trying to complain about gmail, gnot Gnucash On Sun, Aug 14, 2022 at 9:37 AM David Carlson wrote: > I guess GnuCash on my cellphone doesn't work as I expect. > > On Sun, Aug 14, 2022 at 9:10 AM Fred Tydeman > wrote: > >> https://bugs.gnucash.org/show_bug.cgi?id=798550 >> >> On Sun, Aug

Re: [GNC] Crash in Trial Balance report

I guess GnuCash on my cellphone doesn't work as I expect. On Sun, Aug 14, 2022 at 9:10 AM Fred Tydeman wrote: > https://bugs.gnucash.org/show_bug.cgi?id=798550 > > On Sun, Aug 14, 2022 at 10:06 AM David Carlson < > david.carlson@gmail.com> wrote: > >> If that 798550 is a gnucash Bugzilla

[GNC] Crash in Trial Balance

They look big numbers. I wonder if it's an overflow issue. ___ 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

Re: [GNC] Crash in Trial Balance report

https://bugs.gnucash.org/show_bug.cgi?id=798550 On Sun, Aug 14, 2022 at 10:06 AM David Carlson wrote: > If that 798550 is a gnucash Bugzilla report number I couldn't find it in > a search. Can you provide a link? > ___ gnucash-user mailing list

Re: [GNC] Crash in Trial Balance report

If that 798550 is a gnucash Bugzilla report number I couldn't find it in a search. Can you provide a link? On Sun, Aug 14, 2022, 7:10 AM Fred Tydeman wrote: > 798550 was reported some time ago. > > On Sat, Aug 13, 2022 at 11:45 PM Christopher Lam < > christopher@gmail.com> > wrote: > > >

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

On 8/13/2022 10:44 PM, Derek Atkins wrote: Pretty much the only distinction is the UI labels. -derek Sent using my mobile device. Please excuse any typos. On August 13, 2022 21:53:17 Jim DeLaHunt wrote: Yes and no. There are TWO different kinds of "mutual funds", "open end" funds and

Re: [GNC] Crash in Trial Balance report

798550 was reported some time ago. On Sat, Aug 13, 2022 at 11:45 PM Christopher Lam wrote: > May I suggest that any report crash of this sort should be logged in > Bugzilla? > > On Sat, 13 Aug 2022, 9:13 pm Fred Tydeman, wrote: > > > I am running Linux and GnuCash 4.11 > > When I try to do a

[GNC] How to bulk import about 130 Securities entries?

Jim, this overlaps with what I was putting into https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102404.html so I stripped the data exchange part out. The sample data sets and references might still be useful. The GnuCash GUI won't import security data so in addition to what has been

[GNC] Using GnuCash with Portfolio Performance Share Software

Share software can manage shares and show all sorts of interesting things. I use Portfolio Performance portfolio-performance.info/en/ and Sharesight sharesight.com is also popular. Portfolio Performance easily imports broker trade pdfs (Sharesight even strips emails or uploads a hot folder) but

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

Jim, The default account hierarchy that’s provided when you choose investment accounts is just that. You can choose to have it per your tracking requirements. Like you, my parent brokerage account is a placeholder and I have a $Cash account under that which acts as a staging account for buys

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

Jim, I'll address a little of this from my non-technical, non-accountant perspective. I don't know the rationale behind those intermediate accounts, and I don't use them. That said, each investment type behaves a little differently, and perhaps separating them makes some operations easier

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

And I designate ETFs as Mutual Funds... On August 14, 2022 5:44:55 AM GMT+03:00, Derek Atkins wrote: >Pretty much the only distinction is the UI labels. >-derek >Sent using my mobile device. Please excuse any typos. >On August 13, 2022 21:53:17 Jim DeLaHunt wrote: > >> Hello, folks: >> >> I am