How to handle time zone differences?

[windward]

My concern is that since I am in an ASIAN time zone and 12:00 pm EST is really my 12:00 am of the next day the formula PIVOT ALL which depends on daily data to compute its values re-calculates itself in the middle of the day thinking that it is a new day. The end result is that values all of a sudden change even if the markets are still open. I suspect that other studies that are daily data dependent will do the same thing.
Is there a way to correct this ??

[ACM]

windward
AFAIK there is now way to apply a time offset in the charts. FWIW it has been requested by others.
The only suggestion I have seen so far is to switch the computer's clock.
Alex