Re: [GNC-dev] Fraction in splits.value_denom is only 100 although the value in the qif file has more then decimal places 2

2023-04-12 Thread John Ralls 
That's a false precision, it's the price or exchange rate that needs to change 
to reflect the exact amounts in each currency. Always tell GnuCash the amounts 
and let it calculate the price; after all it stores the amount and value in a 
split, not the price or exchange rate. That's always calculated.

That's not to be confused with the price database that's used to present market 
values in reports and on the account page. Those market values are of course 
rounded, but they're also ephemeral because the price will be different soon: 
maybe in a second, maybe on the next trading day.

Regards,
John Ralls

> On Apr 12, 2023, at 1:03 AM, Alexander Damm  wrote:
> 
> Hello,
> 
> ok understood. Due to currency exchange it is sometimes necessary to be a 
> little more precise. But if only 2 decimal places are supported then it is 
> the way it is.
> 
> We are not dealing with fraction of shares. 
> 
> Regards alex 
> 
> On Tue, 11 Apr 2023 at 19:13, john  > wrote:
>> > On Apr 11, 2023, at 5:14 AM, Alexander Damm > > > wrote:
>> > 
>> > Hello,
>> > 
>> > I recognized, that although my qif imports has 6 decimal places, only 2
>> > decimal places seem to be imported and rounded up.
>> > 
>> > Example 1:
>> > QIF File:
>> > 
>> > !Type:Invst
>> > D05-01-2023 00:00:00
>> > NBuyX
>> > YAMGN
>> > T1506.114762
>> > I251.019127
>> > Q6
>> > MBuy: AMGEN INC Symbol:AMGN ISIN:US0311621009
>> > L[Bank]
>> > $-1506.114762
>> > ^
>> > 
>> > Database:
>> > name | value_num | value_denom
>> > AMGN| 150611 | 100
>> > 
>> > 
>> > Example 2:
>> > !Type:Invst
>> > D05-01-2023 00:00:00
>> > NBuyX
>> > YKHC
>> > T1414.6985574
>> > I39.29718215
>> > Q36
>> > MKauf: KRAFT HEINZ CO/THE Symbol:KHC ISIN:US5007541064
>> > L[Bank]
>> > $-1414.6985574
>> > ^
>> > 
>> > Database:
>> > name | value_num | value_denom
>> > KHC| 141470 | 100
>> > 
>> > 
>> > 
>> > This leads to incorrect amounts.Is this correct and/or wanted?
>> > 
>> > Source:
>> > https://github.com/hjacobs/gnucash-qif-import
>> 
>> It's correct and wanted. There is no such thing as a millionth of a US 
>> dollar. The smallest legally recognized fraction is a hundredth, aka a penny.
>> Note also that there is no legally recognized fraction of a share of Amgen 
>> or Kraft-Heinz.
>> 
>> Is this from one of those investment-pool schemes where your broker pretends 
>> to let you trade fractional shares?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
> 
> 
> -- 
> Alexander Damm (ehemals Ritzer)
> Drosselweg 4
> 61440 Oberursel
> Tel.: 016092173081 
>  

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Fraction in splits.value_denom is only 100 although the value in the qif file has more then decimal places 2

2023-04-12 Thread Alexander Damm 
Hello,

ok understood. Due to currency exchange it is sometimes necessary to be a
little more precise. But if only 2 decimal places are supported then it is
the way it is.

We are not dealing with fraction of shares.

Regards alex

On Tue, 11 Apr 2023 at 19:13, john  wrote:

> > On Apr 11, 2023, at 5:14 AM, Alexander Damm 
> wrote:
> >
> > Hello,
> >
> > I recognized, that although my qif imports has 6 decimal places, only 2
> > decimal places seem to be imported and rounded up.
> >
> > Example 1:
> > QIF File:
> >
> > !Type:Invst
> > D05-01-2023 00:00:00
> > NBuyX
> > YAMGN
> > T1506.114762
> > I251.019127
> > Q6
> > MBuy: AMGEN INC Symbol:AMGN ISIN:US0311621009
> > L[Bank]
> > $-1506.114762
> > ^
> >
> > Database:
> > name | value_num | value_denom
> > AMGN| 150611 | 100
> >
> >
> > Example 2:
> > !Type:Invst
> > D05-01-2023 00:00:00
> > NBuyX
> > YKHC
> > T1414.6985574
> > I39.29718215
> > Q36
> > MKauf: KRAFT HEINZ CO/THE Symbol:KHC ISIN:US5007541064
> > L[Bank]
> > $-1414.6985574
> > ^
> >
> > Database:
> > name | value_num | value_denom
> > KHC| 141470 | 100
> >
> >
> >
> > This leads to incorrect amounts.Is this correct and/or wanted?
> >
> > Source:
> > https://github.com/hjacobs/gnucash-qif-import
>
> It's correct and wanted. There is no such thing as a millionth of a US
> dollar. The smallest legally recognized fraction is a hundredth, aka a
> penny.
> Note also that there is no legally recognized fraction of a share of Amgen
> or Kraft-Heinz.
>
> Is this from one of those investment-pool schemes where your broker
> pretends to let you trade fractional shares?
>
> Regards,
> John Ralls
>
>
>
>

-- 
Alexander Damm (ehemals Ritzer)
Drosselweg 4
61440 Oberursel
Tel.: 016092173081

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Fraction in splits.value_denom is only 100 although the value in the qif file has more then decimal places 2

2023-04-11 Thread john 
> On Apr 11, 2023, at 5:14 AM, Alexander Damm  wrote:
> 
> Hello,
> 
> I recognized, that although my qif imports has 6 decimal places, only 2
> decimal places seem to be imported and rounded up.
> 
> Example 1:
> QIF File:
> 
> !Type:Invst
> D05-01-2023 00:00:00
> NBuyX
> YAMGN
> T1506.114762
> I251.019127
> Q6
> MBuy: AMGEN INC Symbol:AMGN ISIN:US0311621009
> L[Bank]
> $-1506.114762
> ^
> 
> Database:
> name | value_num | value_denom
> AMGN| 150611 | 100
> 
> 
> Example 2:
> !Type:Invst
> D05-01-2023 00:00:00
> NBuyX
> YKHC
> T1414.6985574
> I39.29718215
> Q36
> MKauf: KRAFT HEINZ CO/THE Symbol:KHC ISIN:US5007541064
> L[Bank]
> $-1414.6985574
> ^
> 
> Database:
> name | value_num | value_denom
> KHC| 141470 | 100
> 
> 
> 
> This leads to incorrect amounts.Is this correct and/or wanted?
> 
> Source:
> https://github.com/hjacobs/gnucash-qif-import

It's correct and wanted. There is no such thing as a millionth of a US dollar. 
The smallest legally recognized fraction is a hundredth, aka a penny.
Note also that there is no legally recognized fraction of a share of Amgen or 
Kraft-Heinz.

Is this from one of those investment-pool schemes where your broker pretends to 
let you trade fractional shares?

Regards,
John Ralls



___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

[GNC-dev] Fraction in splits.value_denom is only 100 although the value in the qif file has more then decimal places 2

2023-04-11 Thread Alexander Damm 
Hello,

I recognized, that although my qif imports has 6 decimal places, only 2
decimal places seem to be imported and rounded up.

Example 1:
QIF File:

!Type:Invst
D05-01-2023 00:00:00
NBuyX
YAMGN
T1506.114762
I251.019127
Q6
MBuy: AMGEN INC Symbol:AMGN ISIN:US0311621009
L[Bank]
$-1506.114762
^

Database:
name | value_num | value_denom
AMGN| 150611 | 100


Example 2:
!Type:Invst
D05-01-2023 00:00:00
NBuyX
YKHC
T1414.6985574
I39.29718215
Q36
MKauf: KRAFT HEINZ CO/THE Symbol:KHC ISIN:US5007541064
L[Bank]
$-1414.6985574
^

Database:
name | value_num | value_denom
KHC| 141470 | 100



This leads to incorrect amounts.Is this correct and/or wanted?

Source:
https://github.com/hjacobs/gnucash-qif-import



-- 
Alexander Damm (ehemals Ritzer)
Drosselweg 4
61440 Oberursel
Tel.: 016092173081

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel