[GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases
Ove Grunnér
write2ove at gmail.com
Wed Aug 7 13:33:31 EDT 2019
No Problem, John, thanks for helping,
Anyone else got this working somehow?
br Ove.
On Tue, 6 Aug 2019 at 21:55, John Ralls <jralls at ceridwen.us> wrote:
>
>
> > On Aug 6, 2019, at 11:06 AM, Ove <write2ove at gmail.com> wrote:
> >
> > Thanks very much for that John.
> >
> > I did as you suggested, and it fixed the original problem but exposed a
> > different one.
> >
> > I get two currency quotes, EUR/SEK & EUR/USD from the online quote
> function.
> >
> > However since there is no SEK/USD quote , the total of my SEK Asset does
> not
> > include the USD ammounts, e.g.
> >
> > Assets: €xxx (Correct, equivalent of Kr70 + $12 + €1 in
> Euro)
> > Brokerage: Kr70 (missing the USD amount)
> > USD Assets: $12
> > USD Cash $4
> > USD Stocks: $8
> > AMZN 1 Amazon
> > SEK Assets: Kr70
> > SEK Cash kr40
> > SEK Stocks: Kr20
> > AZN.STO 1 AstraZeneca
> > SEK Mutual Funds: kr10
> > Handelsbanken Multiasset 50 1 Handelsbanken
> > Bank Account (EUR) €1.
> >
> > In order to try to reset it:
> > I Deleted all currency quotes,
> > I un-ticked currency quotes in the Security Editor, and then re-Ticked
> them
> > I have tried only having USD & SEK ticked, and I have tried having USD &
> SEK
> > & EUR ticked.
> > however I only receive the online quotes for EUR/USD & EUR/SEK.
> > If I insert a manual quote for USD/SEK it will add up correctly.
> >
> > Is there a way to get Triangle quotes like this via online quotes, or is
> > there another way to achieve what I want to do.
> >
> > Possibly also worth mentioning, when I get the two quotes for EUR/USD &
> > EUR/SEK the window in Price Database looks like this:
> > +Currency
> > EUR(Euro)
> > where + denotes the drop down triangle
> > Note that there is no triangle to expand to look at what is under the EUR
> > quote.
> >
> > Rather than what I would have expected:
> > +Currency
> > +SEK (Swedish Krona)
> > SEK (Swedish Krona) EUR (Euro) 06/08/19
> > Finance::Quote Last 0.093101
> > +USD (US Dollar)
> > USD (US Dollar) EUR (Euro) 06/08/19
> > Finance::Quote Last 0.892777
> >
> >
> > when I look at the gnucash XML, it looks like this:
> >
> > <gnc:commodity version="2.0.0">
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>EUR</cmdty:id>
> > <cmdty:slots>
> > <slot>
> > <slot:key>auto_quote_control</slot:key>
> > <slot:value type="string">false</slot:value>
> > </slot>
> > </cmdty:slots>
> > </gnc:commodity>
> > <gnc:commodity version="2.0.0">
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>SEK</cmdty:id>
> > <cmdty:get_quotes/>
> > <cmdty:quote_source>currency</cmdty:quote_source>
> > <cmdty:quote_tz/>
> > </gnc:commodity>
> > <gnc:commodity version="2.0.0">
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>USD</cmdty:id>
> > <cmdty:get_quotes/>
> > <cmdty:quote_source>currency</cmdty:quote_source>
> > <cmdty:quote_tz/>
> > </gnc:commodity>
> >
> > and the resulting quotes:
> > <gnc:pricedb version="1">
> > <price>
> > <price:id type="guid">9724d1f0b2cc4c709cba5026a8a01928</price:id>
> > <price:commodity>
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>EUR</cmdty:id>
> > </price:commodity>
> > <price:currency>
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>SEK</cmdty:id>
> > </price:currency>
> > <price:time>
> > <ts:date>2019-08-06 18:53:19 +0100</ts:date>
> > </price:time>
> > <price:source>Finance::Quote</price:source>
> > <price:type>last</price:type>
> > <price:value>10741/1000</price:value>
> > </price>
> > <price>
> > <price:id type="guid">60e4902beaab4a8f8dbf6e5227257336</price:id>
> > <price:commodity>
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>EUR</cmdty:id>
> > </price:commodity>
> > <price:currency>
> > <cmdty:space>CURRENCY</cmdty:space>
> > <cmdty:id>USD</cmdty:id>
> > </price:currency>
> > <price:time>
> > <ts:date>2019-08-06 18:53:19 +0100</ts:date>
> > </price:time>
> > <price:source>Finance::Quote</price:source>
> > <price:type>last</price:type>
> > <price:value>11201/10000</price:value>
> > </price>
> > <price>
> >
> >
> > Many thanks in advance.
>
> Sorry, I don't know the answer to that and I haven't found a good answer
> in the relevant code.
>
> Regards,
> John Ralls
>
>
More information about the gnucash-user
mailing list