Tweet
Hello,
When I try to use some of the putcall stats in Excel (such as $pcc-st and $pcis-st), using 30-minute bars, I only get data from 1:30pm - 16:00.
Using the same parameters, I get the full day from 9:30 - 16:00.
This is the formula I'm using:
=QLink|Bars!'$pcc-st,30,161,dtohlc,09:30-16:00'
Any idea on why that may be happening?
Thanks.
When I try to use some of the putcall stats in Excel (such as $pcc-st and $pcis-st), using 30-minute bars, I only get data from 1:30pm - 16:00.
Using the same parameters, I get the full day from 9:30 - 16:00.
This is the formula I'm using:
=QLink|Bars!'$pcc-st,30,161,dtohlc,09:30-16:00'
Any idea on why that may be happening?
Thanks.