Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-16 Thread Mike Alexander
Sorry for the late reply, I didn't see this because of the subject change. The bug in F9nance::Quote has been fixed. I don't know if the fix is in a version that has been released, but if not it will be in the next one. Mike On 9 Mar 2024, at 10:06, john wrote: Good that you've gotten it

Re: [GNC] GNUCash Finance Quote Error with YahooWeb

2024-01-11 Thread Mike Alexander
This is in code that I added in V1.59 so it's probably my fault, but I can't see how it could happen. It would imply that yahoo web returned a page with a price history table in it but there was no first price history table in the page. I.e., it had a table, but then it didn't have a first

Re: [GNC] AlphaVantage now restricting users to 25 quotes

2023-10-31 Thread Mike Alexander
On 27 Oct 2023, at 3:47, Adrian Holbrook wrote: I have been using Alphavantage for my stock quotes for some time now using F:Q. IRecently it stopped working for me - the last valid quotes I have are dated October 20th 2023. I now get a message that they are restricting quotes to 25 per user

Re: [GNC] Intl currencies

2023-08-29 Thread Mike Alexander
This is probably happening because the COP -> USD exchange rate is so small (0.000243884 right now). Some versions of GnuCash stored the reverse conversion if the forward conversion is too small. More recent versions no longer do that. What version are you using? Mike On 29 Aug 2023, at

Re: [GNC] Trading accounts

2022-07-27 Thread Mike Alexander
This is one side of the story. For another view of things you might take a look at https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html. You could also look at https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html which is outdated but still might be useful. If you want

Re: [GNC] QFX Import in 4.8

2021-11-21 Thread Mike Alexander
://github.com/Gnucash/gnucash/pull/1167 I have no control over what gets merged when, hopefully soon? In the meatime you can get that branch, rebase on main if needs be, and test... On 11/21/2021 7:07 PM, Mike Alexander wrote: On 21 Nov 2021, at 14:45, Jean L wrote: This should be fixed

Re: [GNC] QFX Import in 4.8

2021-11-21 Thread Mike Alexander
On 21 Nov 2021, at 14:45, Jean L wrote: This should be fixed in the next release. The code is already in. In where? I just rebuilt from commit 3f758ff2 which was the end of the Maint branch around 7PM EST tonight and when I imported my wife's TIAA changes I had to click OK over 20 times.

Re: [GNC] QFX Import in 4.8

2021-11-20 Thread Mike Alexander
Have you thought about this any more? I have the same issue with TIAA and it's annoying. I gather this is a side effect of commit 248a850. I can see how this change could cause the behavior we're seeing, but I'm not sure what it is trying to fix. The comment says "Add code to handle ofx

Re: [GNC] Duplicate Trading Account Created in V4.5

2021-05-01 Thread Mike Alexander
On 24 Apr 2021, at 19:02, John Ralls wrote: Thanks for reporting this. Mike is right, it's a mistake in the fix for Bug 798093. I think I've fixed it and pushed the fix so it will be in tomorrow's nightlies for Microsoft Windows and Flatpak at https://code.gnucash.org/builds/win32/maint and

Re: [GNC] Trading accounts functionality

2021-04-05 Thread Mike Alexander
On 4 Apr 2021, at 3:29, zuperkoleopt...@gmail.com wrote: Do you think I should file bug reports? Sure, if you can specify detailed step by step instructions for reproducing the errors. The more information you can give the more likely it is to get fixed. Mike

Re: [GNC] Duplicate Trading Account Created in V4.5

2021-04-05 Thread Mike Alexander
On 4 Apr 2021, at 0:18, Thomas Chen wrote: I usually use Trading Account to understand the unrealized cap gain/loss and currency exchange gain/loss, I am wondering if it is providing right information if there are two Trading Accounts. It's probably working ok, but since I haven't seen this

Re: [GNC] Trading accounts functionality

2021-04-03 Thread Mike Alexander
On 3 Apr 2021, at 1:31, zuperkoleopt...@gmail.com wrote: Another issue that I just realized and is related to the functionality of trading accounts, but maybe not the one that we are discussing here, is the security/currency of the top level placeholder account Trading. Shouldn't that be set

Re: [GNC] Trading accounts functionality

2021-04-02 Thread Mike Alexander
On 28 Mar 2021, at 11:21, zuperkoleopt...@gmail.com wrote: The problem I am facing is the following, after activating trading accounts the system created the hierarchy for all the trading accounts, but also created a bunch of splits in already recorded transactions. So from the beginning the

Re: [GNC] Duplicate Trading Account Created in V4.5

2021-04-02 Thread Mike Alexander
On 29 Mar 2021, at 22:53, Thomas Chen wrote: Just upgraded GNC to V4.5 from V4.4 yesterday, and it’s running in a Mac. Today when I added a transaction for a stock purchase, a duplicate Trading Account was created automatically by GNC. Two Trading Accounts exist now. This is just a guess,

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Mike Alexander
On 22 Jan 2021, at 20:10, John Ralls wrote: To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Mike Alexander
, Mike Alexander wrote: On 19 Jan 2021, at 20:08, Lukas Haase wrote: So I got recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best deal with this? Is it possible

Re: [GNC] Switching to trading accounts in existing database

2021-01-20 Thread Mike Alexander
On 19 Jan 2021, at 20:08, Lukas Haase wrote: So I got recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best deal with this? Is it possible to keep my old multi

Re: [GNC] Can Finance::Quote look up bond prices by CUSIP?

2020-06-04 Thread Mike Alexander
Currency exchange rates are easy and this documentation should help. I don't know of any way to get bond prices, but I haven't tried every source. It used to be possible, but it stopped working a few years ago. Mike On 3 Jun 2020, at 14:34, Frank H. Ellenberger wrote: Hello

Re: [GNC] Unable to download more than 5 currency exchange rates

2020-04-29 Thread Mike Alexander
On 26 Apr 2020, at 4:36, davygc wrote: It seems that the quote for exchange rate is not handled by Alphavantage.pm and the cause of the problem is the limitation of 5 quote per minute. This is a bug in Finance::Quote which I fixed some time ago. My fix was merged into the master branch on

Re: [GNC] Investment Portfolio Reporting

2020-03-02 Thread Mike Alexander
On 1 Mar 2020, at 11:51, rsbrux via gnucash-user wrote: I need some reports which show the performance of various investment accounts over the past year.  I don't find anything suitable in GC 2.6.19 and don't have the chops (neither in accounting nor in guile) to write my own.  Surely I am

Re: [GNC] Find Invoice display issue

2019-10-15 Thread Mike Alexander
3.7 is better, but it's still not right. The search results window now consists of two equal sized panes. The top pane is completely blank and the bottom pane contains the search results. If the window is resized the two panes still occupy half the window each and the boundary between them

Re: [GNC] multiple currencies in one transaction

2019-08-19 Thread Mike Alexander
I’ve been thinking for a while about how the register could be changed to better handle multiple currency transactions with trading accounts turned on. Back when I implemented trading accounts I knew this was a problem. However at that time it was expected that the Register2 rewrite of the

Re: [GNC] Advanced Portfolio Report Price Display Error

2019-04-05 Thread Mike Alexander
This may bug 797106, https://bugs.gnucash.org/show_bug.cgi?id=797106 or at least related to it. Mike > On Apr 5, 2019, at 6:41 PM, Richard Ullger wrote: > > Running the report today has displayed a price of > £24 +

Re: [GNC] postpone reconciliation broken: ignores my changes

2019-02-06 Thread Mike Alexander
> On Feb 6, 2019, at 5:00 PM, Colin Law wrote: > > Perhaps it is a Windows issue. As I said it is ok for me using 3.4 on > Ubuntu. It’s not just a Windows problem. I see the same behavior (at least part of the time) with version 3.4 running on a Mac. Mike

Re: [GNC] How to handle bounced check

2019-02-04 Thread Mike Alexander
> On Feb 4, 2019, at 4:32 AM, Geert Janssens wrote: > > Back to the original question: I think gnucash will try its best to keep you > from adding a reverse payment to an already paid invoice. So what you did via > manual lot manipulation is probably the closest you can get to that outcome. >

Re: [GNC] How to handle bounced check

2019-02-01 Thread Mike Alexander
I’ve deleted payments before too when they were recorded incorrectly. This isn’t quite the same thing. I need to keep both the payment and the charge back. Otherwise I can’t accurately reconcile my bank account. Both transactions will appear in the statement (perhaps not even on the same

[GNC] How to handle bounced check

2019-02-01 Thread Mike Alexander
A few weeks ago I received a check in payment for an invoice I had sent to a customer. I recorded the payment and deposited the check. A couple of weeks later I got notice from my bank that the check had bounced. My question is how to record this. I want to “unpay” the invoice and charge

Re: [GNC] When will there be a new Finance::Quote version on CPAN?

2018-11-29 Thread Mike Alexander
> On Nov 27, 2018, at 6:26 PM, John Ralls wrote: > > Not here. It’s up to Erik Colson. Who has been asking for help on the finance-quote list. If you have Perl experience and want to volunteer, that would be helpful. Mike ___ gnucash-user

Re: Fast reactions to 2.7.8

2018-04-01 Thread Mike Alexander
> On Mar 31, 2018, at 8:37 AM, Geert Janssens > wrote: > > * On linux there's a second default theme called "Adwaita-dark" which should > also give you a dark themed gnucash. Unfortunately this doesn't work on > Windows. I suppose it's not included or improperly

Re: Fast reactions to 2.7.8

2018-04-01 Thread Mike Alexander
Thanks for all the research, Geert. I’ve done some experimentation on MacOSX and can add a bit. > 6. Move this directory to a location on your system that's parsed by gtk. > This > is platform dependent: > - Linux: $HOME/.local/share/themes/ > - OS X: Here I'm not sure. Possibly >

Re: Tracking a TIAA mixed fund account

2017-07-31 Thread Mike Alexander
> On Jul 26, 2017, at 10:27 PM, AC wrote: > > I'm going to try > the structure in a new file and see how it behaves. If everything looks > ok then I'll recreate the structure in my main file and start entering > the data. For what it’s worth, I’ve been doing it that way