[GNC] Closest to report date bug?

[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 <martaneeziak at gmail.com> 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 <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> 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 <martaneeziak at gmail.com <mailto: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
>>>> 
>>>> 
>>