Re: [GNC] Closest to report date bug?

2023-10-15 Thread Michael or Penny Novack 

On 10/15/2023 1:02 AM, Sherlock wrote:

On Oct 11, 2023, at 09:17, Marta Neeziak https://lists.gnucash.org/mailman/listinfo/gnucash-user>> wrote:

Not sure what's going on here - but I updated to 5.4 last week and have
since had issues with generating graphs that use "Closest to report date"
for price data.

Basically, when I have the price of an asset and I try to graph it - it
graphs the asset using the following day's price data. Example: A stock is
worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
price of $20 on Day1 and $10 on all other days. I spun up a new db to test
this, and can't seem to figure it out...
Results: https://imgur.com/a/fjmwnHc

If anyone has any idea as to what's going on and how to fix this, I'd


I have an idea about what might be going on but if I am right, this is 
not something requiring a "fix"


When you say "stock is worth X on day one" does this really mean NOW (in 
the middle oi trading day one) or "as of close of the market day-1"? 
Because that is what most of MY on-line value statements mean. The 
valuation I see on day one is clearly labeled "at close of the markets 
day-1".


Look at whatever you are using to get stock values to find out what date 
it is actually using.


Michael D Novack


___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-14 Thread Sherlock 
On Oct 11, 2023, at 09:17, Marta Neeziak https://lists.gnucash.org/mailman/listinfo/gnucash-user>> wrote:
> Not sure what's going on here - but I updated to 5.4 last week and have
> since had issues with generating graphs that use "Closest to report date"
> for price data.
> 
> Basically, when I have the price of an asset and I try to graph it - it
> graphs the asset using the following day's price data. Example: A stock is
> worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
> price of $20 on Day1 and $10 on all other days. I spun up a new db to test
> this, and can't seem to figure it out...
> Results: https://imgur.com/a/fjmwnHc
> 
> If anyone has any idea as to what's going on and how to fix this, I'd
> really appreciate it. Thank you.
If you’re using a 32-bit build (Windows), this may be:

https://bugs.gnucash.org/show_bug.cgi?id=799104

Sherlock
___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-12 Thread john 
See 
https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows-shortcut/
 for setting an environment variable, just substitute TZ=FLE Standard Time for 
LANG=en. There's a list of all of the Windows Timezone names at 
https://howtomanagedevices.com/windows-10/1774/list-of-windows-10-time-zone-codes-tzutil/,
 I picked that one because it's one of the two shortest names in +2.

Regards,
John Ralls


> On Oct 12, 2023, at 11:37, Marta Neeziak  wrote:
> 
> I'll try to figure out the TZ environment variable on my end - is there a 
> standard path where I'd find the file to be modified? For reference, I'm on 
> Windows 10.
> 
> And yes, Last Before doesn't seem to increment by date and just uses the last 
> security price found in the Price DB.
> 
> Thanks for the help.
> 
> On Thu, Oct 12, 2023 at 1:32 PM john  > wrote:
>> You can use the TZ environment variable to run GnuCash in a different 
>> timezone from the system.
>> 
>> Last Before should operate on the increment date for time series just like 
>> Closest to. Chris Lam, can you take a look at that?
>> 
>> Regards,
>> John Ralls
>> 
>>> On Oct 11, 2023, at 18:47, Marta Neeziak >> > wrote:
>>> 
>>> Thank you, this is good to know.
>>> 
>>> Unfortunately, the "Last up through report date" is not what I'm looking 
>>> for since it only shows one price across the whole report period (graph 
>>> scales up/down by units/shares, not price)...
>>> 
>>> Is there anyway for me to manually change the report time zone or price 
>>> data time zone? I don't think that this was a good change, at all, since 
>>> there is now a clear disconnect between what people will expect to see on 
>>> their screens vs. what is happening on the back end w/ time zones.
>>> 
>>> Would appreciate any support in helping me get this resolved on either my 
>>> machine (manually) or a fix globally in a new version.
>>> 
>>> Thanks again.
>>> 
>>> On Wed, Oct 11, 2023 at 8:35 PM john >> > wrote:
 
 
 > On Oct 11, 2023, at 09:17, Marta Neeziak >>> > > wrote:
 > 
 > Not sure what's going on here - but I updated to 5.4 last week and have
 > since had issues with generating graphs that use "Closest to report date"
 > for price data.
 > 
 > Basically, when I have the price of an asset and I try to graph it - it
 > graphs the asset using the following day's price data. Example: A stock 
 > is
 > worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
 > price of $20 on Day1 and $10 on all other days. I spun up a new db to 
 > test
 > this, and can't seem to figure it out...
 > Results: https://imgur.com/a/fjmwnHc
 > 
 > If anyone has any idea as to what's going on and how to fix this, I'd
 > really appreciate it. Thank you.
 
 It's because the report time is midnight local and the quote time is  now 
 neutral time (10:59 UTC) so that the price will have the same date in all 
 timezones. Unless your time zone is east of UTC+2 (Central European 
 Standard Time) 10:59Z the next day is closer to midnight than 10:59Z 
 today. Use "Last up through report date" to align the prices the way you 
 want.
 
 Regards,
 John Ralls
 
 
>> 

___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-12 Thread Marta Neeziak 
I'll try to figure out the TZ environment variable on my end - is there a
standard path where I'd find the file to be modified? For reference, I'm on
Windows 10.

And yes, Last Before doesn't seem to increment by date and just uses the
last security price found in the Price DB.

Thanks for the help.

On Thu, Oct 12, 2023 at 1:32 PM john  wrote:

> You can use the TZ environment variable to run GnuCash in a different
> timezone from the system.
>
> Last Before should operate on the increment date for time series just like
> Closest to. Chris Lam, can you take a look at that?
>
> Regards,
> John Ralls
>
> On Oct 11, 2023, at 18:47, Marta Neeziak  wrote:
>
> Thank you, this is good to know.
>
> Unfortunately, the "Last up through report date" is not what I'm looking
> for since it only shows one price across the whole report period (graph
> scales up/down by units/shares, not price)...
>
> Is there anyway for me to manually change the report time zone or price
> data time zone? I don't think that this was a good change, at all, since
> there is now a clear disconnect between what people will expect to see on
> their screens vs. what is happening on the back end w/ time zones.
>
> Would appreciate any support in helping me get this resolved on either my
> machine (manually) or a fix globally in a new version.
>
> Thanks again.
>
> On Wed, Oct 11, 2023 at 8:35 PM john  wrote:
>
>>
>>
>> > On Oct 11, 2023, at 09:17, Marta Neeziak 
>> wrote:
>> >
>> > Not sure what's going on here - but I updated to 5.4 last week and have
>> > since had issues with generating graphs that use "Closest to report
>> date"
>> > for price data.
>> >
>> > Basically, when I have the price of an asset and I try to graph it - it
>> > graphs the asset using the following day's price data. Example: A stock
>> is
>> > worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display
>> a
>> > price of $20 on Day1 and $10 on all other days. I spun up a new db to
>> test
>> > this, and can't seem to figure it out...
>> > Results: https://imgur.com/a/fjmwnHc
>> >
>> > If anyone has any idea as to what's going on and how to fix this, I'd
>> > really appreciate it. Thank you.
>>
>> It's because the report time is midnight local and the quote time is  now
>> neutral time (10:59 UTC) so that the price will have the same date in all
>> timezones. Unless your time zone is east of UTC+2 (Central European
>> Standard Time) 10:59Z the next day is closer to midnight than 10:59Z today.
>> Use "Last up through report date" to align the prices the way you want.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>
___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-12 Thread john 
You can use the TZ environment variable to run GnuCash in a different timezone 
from the system.

Last Before should operate on the increment date for time series just like 
Closest to. Chris Lam, can you take a look at that?

Regards,
John Ralls

> On Oct 11, 2023, at 18:47, Marta Neeziak  wrote:
> 
> Thank you, this is good to know.
> 
> Unfortunately, the "Last up through report date" is not what I'm looking for 
> since it only shows one price across the whole report period (graph scales 
> up/down by units/shares, not price)...
> 
> Is there anyway for me to manually change the report time zone or price data 
> time zone? I don't think that this was a good change, at all, since there is 
> now a clear disconnect between what people will expect to see on their 
> screens vs. what is happening on the back end w/ time zones.
> 
> Would appreciate any support in helping me get this resolved on either my 
> machine (manually) or a fix globally in a new version.
> 
> Thanks again.
> 
> On Wed, Oct 11, 2023 at 8:35 PM john  > wrote:
>> 
>> 
>> > On Oct 11, 2023, at 09:17, Marta Neeziak > > > wrote:
>> > 
>> > Not sure what's going on here - but I updated to 5.4 last week and have
>> > since had issues with generating graphs that use "Closest to report date"
>> > for price data.
>> > 
>> > Basically, when I have the price of an asset and I try to graph it - it
>> > graphs the asset using the following day's price data. Example: A stock is
>> > worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
>> > price of $20 on Day1 and $10 on all other days. I spun up a new db to test
>> > this, and can't seem to figure it out...
>> > Results: https://imgur.com/a/fjmwnHc
>> > 
>> > If anyone has any idea as to what's going on and how to fix this, I'd
>> > really appreciate it. Thank you.
>> 
>> It's because the report time is midnight local and the quote time is  now 
>> neutral time (10:59 UTC) so that the price will have the same date in all 
>> timezones. Unless your time zone is east of UTC+2 (Central European Standard 
>> Time) 10:59Z the next day is closer to midnight than 10:59Z today. Use "Last 
>> up through report date" to align the prices the way you want.
>> 
>> Regards,
>> John Ralls
>> 
>> 

___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-11 Thread Marta Neeziak 
Thank you, this is good to know.

Unfortunately, the "Last up through report date" is not what I'm looking
for since it only shows one price across the whole report period (graph
scales up/down by units/shares, not price)...

Is there anyway for me to manually change the report time zone or price
data time zone? I don't think that this was a good change, at all, since
there is now a clear disconnect between what people will expect to see on
their screens vs. what is happening on the back end w/ time zones.

Would appreciate any support in helping me get this resolved on either my
machine (manually) or a fix globally in a new version.

Thanks again.

On Wed, Oct 11, 2023 at 8:35 PM john  wrote:

>
>
> > On Oct 11, 2023, at 09:17, Marta Neeziak  wrote:
> >
> > Not sure what's going on here - but I updated to 5.4 last week and have
> > since had issues with generating graphs that use "Closest to report date"
> > for price data.
> >
> > Basically, when I have the price of an asset and I try to graph it - it
> > graphs the asset using the following day's price data. Example: A stock
> is
> > worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
> > price of $20 on Day1 and $10 on all other days. I spun up a new db to
> test
> > this, and can't seem to figure it out...
> > Results: https://imgur.com/a/fjmwnHc
> >
> > If anyone has any idea as to what's going on and how to fix this, I'd
> > really appreciate it. Thank you.
>
> It's because the report time is midnight local and the quote time is  now
> neutral time (10:59 UTC) so that the price will have the same date in all
> timezones. Unless your time zone is east of UTC+2 (Central European
> Standard Time) 10:59Z the next day is closer to midnight than 10:59Z today.
> Use "Last up through report date" to align the prices the way you want.
>
> Regards,
> John Ralls
>
>
>
___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

2023-10-11 Thread john 



> On Oct 11, 2023, at 09:17, Marta Neeziak  wrote:
> 
> Not sure what's going on here - but I updated to 5.4 last week and have
> since had issues with generating graphs that use "Closest to report date"
> for price data.
> 
> Basically, when I have the price of an asset and I try to graph it - it
> graphs the asset using the following day's price data. Example: A stock is
> worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
> price of $20 on Day1 and $10 on all other days. I spun up a new db to test
> this, and can't seem to figure it out...
> Results: https://imgur.com/a/fjmwnHc
> 
> If anyone has any idea as to what's going on and how to fix this, I'd
> really appreciate it. Thank you.

It's because the report time is midnight local and the quote time is  now 
neutral time (10:59 UTC) so that the price will have the same date in all 
timezones. Unless your time zone is east of UTC+2 (Central European Standard 
Time) 10:59Z the next day is closer to midnight than 10:59Z today. Use "Last up 
through report date" to align the prices the way you want.

Regards,
John Ralls


___
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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.