Announcement

Collapse
No announcement yet.

How to Offset Historical Table by x seconds ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • eSignal_EricL
    replied
    Hi Dave,

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

    Eric L.

    Leave a comment:


  • How to Offset Historical Table by x seconds ?

    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
Working...
X