Last bar open and close price of day

[adTS]

Hi,
I am having trouble getting for the last bar open and close price at the closing session (4pm est) , specially on Mondays
I am using
def day = GetDay();
def lastDay = GetLastDay();
def isToday = If(day == lastDay, 1, 0);
but not always work for SPX, ES, SPY with and without extended hours on

Today at 3pm I would like to get yesterday's values
Today at 5pm I would like to get today's values
Tomorrow at 8am I would like to get yesterday's values

Any help is appreciated

 

[Svanoy]

@adTS
You can reduce your above code to:

def isToday = GetDay() == GetLastDay();

and get the same results, but I don't think you even need it at all.
A script to record open and close of a certain bar from every day would overwrite itself with the data of the current day at the time defined.
This code records the open and close of the bar at 4:00 p.m.

input Reset_Time = 1600; # Time of bar to record open and close.

def Start =
(SecondsTillTime(Reset_Time)[1] > 0 and SecondsTillTime(Reset_Time) <= 0);
    
def SessionOpen;
def SessionClose;
if Start {
SessionOpen = open;
SessionClose = close;
} else {
SessionOpen = SessionOpen[1];
SessionClose = SessionClose[1];
}

 

[adTS]

@Svanoy​

Thank you reply, very appreciated.
I tried you code, but the open and close price is for the first bar of the day (9:30am), not the last bar of the day.
I tried SPY and SPX at 11:00pm EST

 

[adTS]

Found this thread, that may help me
https://usethinkscript.com/threads/last-bar-close.11779/
I will post the results later

 

[Svanoy]

@adTS
I had forgot to change the start time def, it is fixed now.
The code I posted has an input field for time of day. Change that to the time of the bar you want.

 

[adTS]

@Svanoy
Thank you for your reply.
I was able to accomplish what I was looking for.