Topics

historical intraday price data


Olo Rising
 

Hello, this formula is pulling in the intraday date/time but not the intraday price data... do you know why it's not pulling in historical price data for intraday?

=xlqIntraTime("IBM",A6,"iqfeed")     and     =xlqIntraPrice("IBM",A6,"iqfeed")


Seq Intraday Price
0 1/27/20 11:30 AM 138.34
-1 1/27/20 11:20 AM 0
-2 1/27/20 11:10 AM 0
-3 1/27/20 11:00 AM 0
-4 1/27/20 10:50 AM 0
-5 1/27/20 10:40 AM 0
-6 1/27/20 10:30 AM 0
-7 1/27/20 10:20 AM 0
-8 1/27/20 10:10 AM 0
-9 1/27/20 10:00 AM 0
-10 1/27/20 9:50 AM 0
-11 1/27/20 9:40 AM 0
-12 1/27/20 9:30 AM 0
-13 1/24/20 3:50 PM 0
-14 1/24/20 3:40 PM 0
-15 1/24/20 3:30 PM 0
-16 1/24/20 3:20 PM 0
-17 1/24/20 3:10 PM 0
-18 1/24/20 3:00 PM 0
-19 1/24/20 2:50 PM 0
-20 1/24/20 2:40 PM 0
-21 1/24/20 2:30 PM 0
-22 1/24/20 2:20 PM 0
-23 1/24/20 2:10 PM 0
-24 1/24/20 2:00 PM 0
-25 1/24/20 1:50 PM 0
-26 1/24/20 1:40 PM 0
-27 1/24/20 1:30 PM 0
-28 1/24/20 1:20 PM 0
-29 1/24/20 1:10 PM 0
-30 1/24/20 1:00 PM 0
-31 1/24/20 12:50 PM 0
-32 1/24/20 12:40 PM 0
-33 1/24/20 12:30 PM 0
-34 1/24/20 12:20 PM 0
-35 1/24/20 12:10 PM 0
-36 1/24/20 12:00 PM 0
-37 1/24/20 11:50 AM 0
-38 1/24/20 11:40 AM 0
-39 1/24/20 11:30 AM 0
-40 1/24/20 11:20 AM 0
-41 1/24/20 11:10 AM 0
-42 1/24/20 11:00 AM 0
-43 1/24/20 10:50 AM 0
-44 1/24/20 10:40 AM 0
-45 1/24/20 10:30 AM 0
-46 1/24/20 10:20 AM 0
-47 1/24/20 10:10 AM 0
-48 1/24/20 10:00 AM 0
-49 1/24/20 9:50 AM 0
-50 1/24/20 9:40 AM 0
-51 1/24/20 9:30 AM 0
-52 1/23/20 3:50 PM 0
-53 1/23/20 3:40 PM 0


Leo
 

Hi Olo

 

It is returning the backfill along with the date/time but use are using xlqIntraPrice while using 10 minute bars, so should be using xlqIntraClose to get the closing price, or xlqIntraOpen, xlqIntraHigh etc.

 

xlqIntraPrice, xlqIntraBid etc would be returned for the last bar by xlq as it is populated in realtime, and the data will remain accessible once the bar is no longer the last where price, bid, ask would correspond to the closing data, but such data will only be populated while xlq is updating the data realtime. xlqIntraPrice, bid etc would not be returned via backfill from the sources.

 

Regards

 

Leo

On Mon, Jan 27, 2020 at 08:38 AM, Olo Rising wrote:
Hello, this formula is pulling in the intraday date/time but not the intraday price data... do you know why it's not pulling in historical price data for intraday?

=xlqIntraTime("IBM",A6,"iqfeed")     and     =xlqIntraPrice("IBM",A6,"iqfeed")


Seq Intraday Price
0 1/27/20 11:30 AM 138.34
-1 1/27/20 11:20 AM 0
-2 1/27/20 11:10 AM 0
-3 1/27/20 11:00 AM 0
-4 1/27/20 10:50 AM 0
-5 1/27/20 10:40 AM 0
-6 1/27/20 10:30 AM 0
-7 1/27/20 10:20 AM 0
-8 1/27/20 10:10 AM 0
-9 1/27/20 10:00 AM 0
-10 1/27/20 9:50 AM 0
-11 1/27/20 9:40 AM 0
-12 1/27/20 9:30 AM 0
-13 1/24/20 3:50 PM 0
-14 1/24/20 3:40 PM 0
-15 1/24/20 3:30 PM 0
-16 1/24/20 3:20 PM 0
-17 1/24/20 3:10 PM 0
-18 1/24/20 3:00 PM 0
-19 1/24/20 2:50 PM 0
-20 1/24/20 2:40 PM 0
-21 1/24/20 2:30 PM 0
-22 1/24/20 2:20 PM 0
-23 1/24/20 2:10 PM 0
-24 1/24/20 2:00 PM 0
-25 1/24/20 1:50 PM 0
-26 1/24/20 1:40 PM 0
-27 1/24/20 1:30 PM 0
-28 1/24/20 1:20 PM 0
-29 1/24/20 1:10 PM 0
-30 1/24/20 1:00 PM 0
-31 1/24/20 12:50 PM 0
-32 1/24/20 12:40 PM 0
-33 1/24/20 12:30 PM 0
-34 1/24/20 12:20 PM 0
-35 1/24/20 12:10 PM 0
-36 1/24/20 12:00 PM 0
-37 1/24/20 11:50 AM 0
-38 1/24/20 11:40 AM 0
-39 1/24/20 11:30 AM 0
-40 1/24/20 11:20 AM 0
-41 1/24/20 11:10 AM 0
-42 1/24/20 11:00 AM 0
-43 1/24/20 10:50 AM 0
-44 1/24/20 10:40 AM 0
-45 1/24/20 10:30 AM 0
-46 1/24/20 10:20 AM 0
-47 1/24/20 10:10 AM 0
-48 1/24/20 10:00 AM 0
-49 1/24/20 9:50 AM 0
-50 1/24/20 9:40 AM 0
-51 1/24/20 9:30 AM 0
-52 1/23/20 3:50 PM 0
-53 1/23/20 3:40 PM 0


Olo Rising
 

ok got it. thank you


On Mon, Jan 27, 2020 at 1:17 PM Leo <leov@...> wrote:

Hi Olo

 

It is returning the backfill along with the date/time but use are using xlqIntraPrice while using 10 minute bars, so should be using xlqIntraClose to get the closing price, or xlqIntraOpen, xlqIntraHigh etc.

 

xlqIntraPrice, xlqIntraBid etc would be returned for the last bar by xlq as it is populated in realtime, and the data will remain accessible once the bar is no longer the last where price, bid, ask would correspond to the closing data, but such data will only be populated while xlq is updating the data realtime. xlqIntraPrice, bid etc would not be returned via backfill from the sources.

 

Regards

 

Leo

On Mon, Jan 27, 2020 at 08:38 AM, Olo Rising wrote:
Hello, this formula is pulling in the intraday date/time but not the intraday price data... do you know why it's not pulling in historical price data for intraday?

=xlqIntraTime("IBM",A6,"iqfeed")     and     =xlqIntraPrice("IBM",A6,"iqfeed")


Seq Intraday Price
0 1/27/20 11:30 AM 138.34
-1 1/27/20 11:20 AM 0
-2 1/27/20 11:10 AM 0
-3 1/27/20 11:00 AM 0
-4 1/27/20 10:50 AM 0
-5 1/27/20 10:40 AM 0
-6 1/27/20 10:30 AM 0
-7 1/27/20 10:20 AM 0
-8 1/27/20 10:10 AM 0
-9 1/27/20 10:00 AM 0
-10 1/27/20 9:50 AM 0
-11 1/27/20 9:40 AM 0
-12 1/27/20 9:30 AM 0
-13 1/24/20 3:50 PM 0
-14 1/24/20 3:40 PM 0
-15 1/24/20 3:30 PM 0
-16 1/24/20 3:20 PM 0
-17 1/24/20 3:10 PM 0
-18 1/24/20 3:00 PM 0
-19 1/24/20 2:50 PM 0
-20 1/24/20 2:40 PM 0
-21 1/24/20 2:30 PM 0
-22 1/24/20 2:20 PM 0
-23 1/24/20 2:10 PM 0
-24 1/24/20 2:00 PM 0
-25 1/24/20 1:50 PM 0
-26 1/24/20 1:40 PM 0
-27 1/24/20 1:30 PM 0
-28 1/24/20 1:20 PM 0
-29 1/24/20 1:10 PM 0
-30 1/24/20 1:00 PM 0
-31 1/24/20 12:50 PM 0
-32 1/24/20 12:40 PM 0
-33 1/24/20 12:30 PM 0
-34 1/24/20 12:20 PM 0
-35 1/24/20 12:10 PM 0
-36 1/24/20 12:00 PM 0
-37 1/24/20 11:50 AM 0
-38 1/24/20 11:40 AM 0
-39 1/24/20 11:30 AM 0
-40 1/24/20 11:20 AM 0
-41 1/24/20 11:10 AM 0
-42 1/24/20 11:00 AM 0
-43 1/24/20 10:50 AM 0
-44 1/24/20 10:40 AM 0
-45 1/24/20 10:30 AM 0
-46 1/24/20 10:20 AM 0
-47 1/24/20 10:10 AM 0
-48 1/24/20 10:00 AM 0
-49 1/24/20 9:50 AM 0
-50 1/24/20 9:40 AM 0
-51 1/24/20 9:30 AM 0
-52 1/23/20 3:50 PM 0
-53 1/23/20 3:40 PM 0