[GNC] Closest to report date bug?

[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 <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> 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> wrote:
>
>>
>>
>> > On Oct 11, 2023, at 09:17, Marta Neeziak <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
>>
>>
>>
>