Tweet
Hi,
I'm attempting to get intraday data for stock symbols using the Insert Historical Table Window. For interval I'm setting it at 120 mins and Time Range is 6:30 to 7:30. When I click OK, it creates the right data for the first 5 days with BarTime reading 6:30. The data reads for the entire length of 6:30 - 7:30(I basically just want data for the first hour of the day so this is what I want). Past the fifth day the bartime changes to 5:30 and the data becomes incorrect. Is this just me?
Attached xlsx that has live data and values copy and pasted. I've tried to explain my problem a bit better in there with some screenshots and text boxes.
Thanks,
Colton
I'm attempting to get intraday data for stock symbols using the Insert Historical Table Window. For interval I'm setting it at 120 mins and Time Range is 6:30 to 7:30. When I click OK, it creates the right data for the first 5 days with BarTime reading 6:30. The data reads for the entire length of 6:30 - 7:30(I basically just want data for the first hour of the day so this is what I want). Past the fifth day the bartime changes to 5:30 and the data becomes incorrect. Is this just me?
Attached xlsx that has live data and values copy and pasted. I've tried to explain my problem a bit better in there with some screenshots and text boxes.
Thanks,
Colton