Missing times for put/call ratio

[jmglkg]

Hello,

I'm using half-hourly bars for pcE-st and pcis-st. Based on a prior post, the times were not pulling in correctly, so I've been using the time frame 13:30 - 20:00 in my Excel formula to pull those numbers.

Over the past week, the data for 1:30 and 2:00 are showing as black values every day. All other times appear correct.

Do I need to change the time values again for them to display properly?

Thank you.

[ACM]

Re: Missing times for put/call ratio

jmglkg
That could be due to the switch from Daylight Saving Time to Standard Time
Try shifting the start and end times to 14:30 and 21:00 respectively and see if that resolves the issue of the blank rows
Alex

Originally posted by jmglkg
Hello,

I'm using half-hourly bars for pcE-st and pcis-st. Based on a prior post, the times were not pulling in correctly, so I've been using the time frame 13:30 - 20:00 in my Excel formula to pull those numbers.

Over the past week, the data for 1:30 and 2:00 are showing as black values every day. All other times appear correct.

Do I need to change the time values again for them to display properly?

Thank you.

[jmglkg]

Ahh, thank you very much, that helped.

[ACM]

jmglkg
You are most welcome
Alex

Originally posted by jmglkg
Ahh, thank you very much, that helped.