How to Offset Historical Table by x seconds ?

[eSignal_EricL]

Hi Dave,

I just checked with the Qlink developers and what you are requesting is not possible at this time.

Eric L.

[braidednation]

Hello,

I am looking to time offset my Historical table I have setup in Excel.

=ESHistI("EUR A0-FX","Last","I1",30)
=....................
=ESHistI("EUR A0-FX","Last","I1",3)
=ESHistI("EUR A0-FX","Last","I1",2)
=ESHistI("EUR A0-FX","Last","I1",1) - Previous Minute Last Price

=ESHistI("EUR A0-FX","Last","I1",0) - Current tick data

The data I capture is the "Last" price at the top of the minute. I would like to capture data at the 59th second of the last minute, respectively on all 30 preceeding rows.

Ideally I would like to be able to draw a historical table at what ever offset I want, i.e, HH:MM:56, etc.

If this is possible, please let me know.

Thanks

Dave