Re: [GNC] Budget report fails in multiple currencies

ion during the budget period part of the result. In the language of my last e-mail, this pull request computes "ES_12*X_1" (but perhaps it should be "ES_12*X_2"... to be discussed). https://github.com/Gnucash/gnucash/pull/1497 On Sun, Jan 8, 2023 at 9:34 AM ml enquirer wrote:

Re: [GNC] Budget report fails in multiple currencies

Yes, it's cumulative, which is a problem I think. Let: 0 indicate the opening of the book 1 indicate the start of the budget period in question 2 indicate the end of that period S_i indicates the sum of transactions since 0 at marker i, in the currency of the sub-account P_i indicates the sum of

Re: [GNC] Budget report fails in multiple currencies

at least for expense accounts if not for asset accounts ;) But as I keep on saying, I'm very ignorant of even basic accountancy techniques, so feel free to (gently) teach me! D On Sat, Jan 7, 2023 at 6:08 PM Fred Bone wrote: > On 07 January 2023 at 10:21, ml enquirer said: > > &

Re: [GNC] Budget report fails in multiple currencies

uot; spend will be 10,000 GBP despite nothing having been spent. This reporting bug gets worse the longer gnucash is used. Thanks, D On Sat, Jan 7, 2023 at 9:52 AM ml enquirer wrote: > Hi Adrien, > > Thanks for the mental bandwidth on this. I don't like replying inline, but > I'm

Re: [GNC] Budget report fails in multiple currencies

ference) > No trading accounts. > > - > I've been in the habit of hazarding guesses lately, so here's one for > this topic: > > Since the Budget Report does not have an option for commodity price > source like other reports cognizant of other currencies, I'll > hypot

Re: [GNC] Budget report fails in multiple currencies

ant that the balance of "Groceries" was (10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000 GBP. Difference 30,000 GBP. so 1 + 1 = 3. On Thu, Jan 5, 2023 at 9:37 PM ml enquirer wrote: > Hi! > > Any clues as to where to start to understand this odd budget repor

Re: [GNC] Budget report fails in multiple currencies

in such an apparently-illogical (but presumably profoundly reasonable to a better-informed person!) way... Hints very much appreciated! On Mon, Jan 2, 2023 at 4:10 PM ml enquirer wrote: > Dear all, > > I spend in two currencies and, historically, I chose to create separate > account

Re: [GNC] How to "Get Quotes" for a specific day?

Hi Michael, I've faced the same problem. I use the gnucash python bindings and the following script, to import prices from a text file which has date (-MM-DD) and price with a new date on each line. Hope it could be some use. As always, test it before deploying! Best wishes. ```python

[GNC] Budget report fails in multiple currencies

Dear all, I spend in two currencies and, historically, I chose to create separate accounts under each expense line for each currency. In future I will do this differently, employing trading accounts, but what I'm about to describe should still work. I budget in my 'home' currency, and the budget

Re: [GNC] Unable to retrieve currency quotes

rities (but no other currencies, I think) set up. I'll try debugging by disabling one by one and let you know how I get on. All the best, On Sat, May 19, 2018 at 7:39 PM, John Ralls <jra...@ceridwen.us> wrote: > > > On May 19, 2018, at 9:10 AM, ml enquirer <ml.hnel.227...@gma

Re: [GNC] Unable to retrieve currency quotes

Hi all, @shaq32: thanks for the idea, but no, this is not the problem, I already have a valid API key (that's a very old FAQ...) Any luck debugging, John? Anything I can do to provide more useful info? Best regards, On Tue, May 8, 2018 at 7:31 PM, shaq32 wrote: > Hi, >

Re: [GNC] Unable to retrieve currency quotes

Thanks - it's reassuring to know it's not just me... all the best, On Mon, Apr 30, 2018 at 10:18 PM, John Ralls <jra...@ceridwen.us> wrote: > > > > On Apr 30, 2018, at 1:05 PM, ml enquirer <ml.hnel.227...@gmail.com> > wrote: > > > > Sorry, that sh

Re: [GNC] Unable to retrieve currency quotes

or message. Is AlphaVantage really very unstable? I tried with a new API key but with no luck. On Mon, Apr 30, 2018 at 10:05 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Sorry, that should have read GnuCash 3.1... > > D > > > On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer

Re: [GNC] Unable to retrieve currency quotes

Sorry, that should have read GnuCash 3.1... D On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Hi, > > I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up > Finance::Quote properly, with my alphavantage key. When I press "Get

[GNC] Unable to retrieve currency quotes

Hi, I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up Finance::Quote properly, with my alphavantage key. When I press "Get quotes" in the Price Editor, I expect updates for CHF, EUR and several stock quotes. The stock quotes come back fine each time, but the two currency updates fail

Re: yahoo as json stock quotes pounds/pence

ear what more experienced people have to say! Thanks, Dan On Thu, Jan 25, 2018 at 11:55 PM, ml enquirer <ml.hnel.227...@gmail.com> wrote: > Hi, > > I'm aware this is not a new question: > - https://lists.gnucash.org/pipermail/gnucash-user/2008- > November/027224.html >