[GNC] Closest to report date bug?

[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 <martaneeziak at gmail.com> 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 <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> 
>> 
>> > On Oct 11, 2023, at 09:17, Marta Neeziak <martaneeziak at gmail.com <mailto:martaneeziak at gmail.com>> 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
>> 
>>