[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Does your Esignal data match your QP2 data???



PureBytes Links

Trading Reference Links




Thank 
you Tomasz and others for all your comments however I really think i 
understand ALL the issues and i am NOT arguing with any of them. The problem has 
been confirmed: I am not seeking an explanantion; i am seeking a practical 
solution.
<FONT face=Arial color=#0000ff 
size=2> 
The 
differences appear in all price fields (OHLC) and seem to exceed that which may 
be caused by Form-T trades so there is no garantee that adding a Form-T 
filter would solve the problem. If it is an easy test we could try but 
perhaps the effort would be better spend on development of a function that 
allows us to access both the eSignal EOD and eSignal RT DB from the same code. I 
know this will introduce other problems however i think we can code around 
those.
<FONT face=Arial color=#0000ff 
size=2> 
Best 
regards,
<FONT face=Arial color=#0000ff 
size=2>herman

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Tomasz Janeczko 
  [mailto:amibroker@xxxxxx]Sent: Tuesday, March 16, 2004 11:11 
  AMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker] 
  Does your Esignal data match your QP2 data???Importance: 
  High
  Herman,
  TimeFrameGetPrice as any other timeframe funciton COMPRESSES 
  data.
  In your case it creates DAILY bars from intraday data. Those intraday 
  data contain
  ALL trades, while EOD records published by NASDAQ do NOT include all 
  trades.
  Hence the difference.
   
  As Jayson pointed out this is by nasdaq regulation and you may only wish 
  NOT to receive Form-T
  in intraday data - this is doable but would require changing the plugin 
  to REMOVE Form-T records
  from intraday data.
  Best regards,Tomasz Janeczkoamibroker.com
  <BLOCKQUOTE dir=ltr 
  >
    ----- Original Message ----- 
    <DIV 
    >From: 
    Herman van den 
    Bergen 
    To: <A title=amibroker@xxxxxxxxxxxxxxx 
    href="">amibroker@xxxxxxxxxxxxxxx 
    Sent: Tuesday, March 16, 2004 5:03 
    PM
    Subject: RE: [amibroker] Does your 
    Esignal data match your QP2 data???
    
    <FONT face=Arial color=#0000ff 
    size=2>Hello Jayson, I think everybody misses the point.
    <FONT face=Arial color=#0000ff 
    size=2> 
    As 
    my subject line indicates I found a significant difference between 
    eSignal/QP2 EOD and eSignal RT data. Initially this was denied, now it is 
    explained. 
    <FONT face=Arial color=#0000ff 
    size=2> 
    <FONT face=Arial color=#0000ff 
    size=2>The point I made and that is missed by most readers remains 
    exactly the same: the data differs significantly and you cannot convert 
    short term EOD systems to RT and expect the same results. BTW, I trade 
    NASDAQ exclusively and wouldn't think of changing, also pre/after hours data 
    is NOT included in the comparison.
    <FONT face=Arial color=#0000ff 
    size=2> 
    <FONT face=Arial color=#0000ff 
    size=2>AmiBroker does not let you access separate EOD and RT databases from 
    one program (as far as I know) so it is impossible to convert complicated 
    code that took years to develop and is based on EOD-quality data to an RT 
    environment. This means that EOD short-term traders will not be able 
    to optimize Stops, Targets and Limit orders with adding RT data; 
    using that type of orders will give you unrealistic results in EOD 
    backtesting. The only solution i can think of is to maintain two 
    databases and develop some form of communication between the RT and EOD 
    instances of AB (Composites don't work because they reside in different 
    DBs).
    <FONT face=Arial color=#0000ff 
    size=2> 
    <FONT face=Arial color=#0000ff 
    size=2>After going around in circles a few times my original question has 
    been answered: eSignal RT OHLC data retrieved using <FONT color=#0000ff 
    size=2>TimeFrameGetPrice() is NOT the same as eSignal or QP2 EOD 
    OHLC data. The reason for this is irrelevant, the fact stands and 
    causes problems in system design and conversion from EOD to RT. Now that 
    this has been confirmed I have to find a way to work around/with 
    it.
    <FONT face=Arial color=#0000ff 
    size=2> 
    <FONT face=Arial color=#0000ff 
    size=2>Thank you for your comments Jason,
    <FONT face=Arial color=#0000ff 
    size=2>best regards,
    <FONT face=Arial color=#0000ff 
    size=2>herman.
    
      <FONT face=Tahoma 
      size=2>-----Original Message-----From: Jayson 
      [mailto:jcasavant@xxxxxxxxxxx]Sent: Tuesday, March 16, 2004 
      10:11 AMTo: amibroker@xxxxxxxxxxxxxxxSubject: RE: 
      [amibroker] Does your Esignal data match your QP2 
      data???Importance: High
      <FONT face=Arial color=#0000ff 
      size=2>Herman,
      <FONT face=Arial color=#0000ff 
      size=2> 
      <FONT face=Arial color=#0000ff 
      size=2>I think Tomasz hit the nail on the head. Are you finding the errors 
      to be in Nasdaq stocks only? You will not match exactly RT and EOD  
      because of nasdaq rules. But the real question is, are they errors? I 
      would say no, they are accurate reflections of the nasdaq rules. RT data 
      by design is a zoomed in snapshot of what actually occurred during the 
      trading day and does in fact include trades that the EOD numbers do not 
      see. Did those trades not happen? Of course they did and of course they 
      will be reflected in the decisions of RT traders during the after hours 
      session and again tomorrow in the pre market. Personally I hate the pre 
      and after markets as they just muddy of the waters but nasdaq has them and 
      if you plan to trade RT data you have to learn to live with it. An 
      alternative would be to avoid the Nasdaq stocks for your system 
      testing
       
      Regards, 
      Jayson 
      <FONT face=Tahoma 
      size=2>-----Original Message-----From: Herman van den Bergen 
      [mailto:psytek@xxxxxxxx]Sent: Tuesday, March 16, 2004 9:13 
      AMTo: amibroker@xxxxxxxxxxxxxxxSubject: RE: 
      [amibroker] Does your eSignal data match your QP2 
      data???
      <FONT face=Arial color=#0000ff 
      size=2><FONT 
      face=Arial color=#0000ff size=2>see also my inline response to 
      Tomasz...
      <FONT face=Arial color=#0000ff 
      size=2><SPAN 
      class=796213912-16032004> 
      <FONT face=Arial color=#0000ff 
      size=2><SPAN 
      class=796213912-16032004>I challenge anybody to produce 
      code that extracts EOD OHLC prices from eSignal RT that "reasonable 
      accurate" matches either eSignal EOD or QP2 data. <SPAN 
      class=796213912-16032004>Considering 
      the trend of EOD traders moving into RT this is an important topic; nobody 
      wants to throw out working EOD trading systems that took years to develop; 
      the idea is to improve existing EOD systems with RT data, not to 
      start from scratch developing new systems.
      <FONT face=Arial color=#0000ff 
      size=2> <FONT 
      face=Arial color=#0000ff size=2>
      The 
      TimeFrameGetPrice() doesn't seem to help here (see code posted 
      earlier). We may need a way to 
      switch from eSignal RT or eSignal EOD on the fly. The only 
      alternative I see is to run two AB instances and use custom 
      files to share data between them. This means forever synchronizing two 
      code versions for each system, maintain two databases, and develop 
      additional data-sharing code. All this work is a very discouraging 
      thought. If you have a better idea I'd like to hear from 
      you.
      <SPAN 
      class=796213912-16032004> 
      If somebody proves me 
      wrong (wouldn't be the first time) I will humbly and publicly post a 
      retraction and apology.
      <SPAN 
class=796213912-16032004> 
      <SPAN 
      class=796213912-16032004>best 
      regards,
      <SPAN 
      class=796213912-16032004>herman
      <SPAN 
      class=796213912-16032004> <FONT 
      color=#0000ff size=2><SPAN 
      class=796213912-16032004>
      
      <TABLE  cellSpacing=0 
      cellPadding=0 width=700 border=0 x:str>
        
        <COL  
        width=46>
        <COL  
        width=94>
        <COL  
        span=8 width=46>
        <COL  
        span=4 width=48>
        
        
          <TD class=xl32 
           
          width=46 height=17>
             
          <TD class=xl33 
           
          width=94>
            <FONT 
          size=2> 
          <TD class=xl25 
           
          width=184 colSpan=4>
            <FONT 
            size=2>eSignal-RT
          <TD class=xl22 
           
          width=184 colSpan=4>
            <FONT 
            size=2>eSignal-EOD
          <TD class=xl29 
           
          width=192 colSpan=4>
            <FONT 
          size=2>%Error
        
          <TD class=xl33 
           
          height=17>
            <FONT 
          size=2>Ticker
          <TD class=xl33 
          >
            <FONT 
            size=2>Date/Time
          <TD class=xl34 
          >
            O
          <TD class=xl34 
          >
            H
          <TD class=xl34 
          >
            L
          <TD class=xl34 
          >
            C
          <TD class=xl28 
          >
            O
          <TD class=xl28 
          >
            H
          <TD class=xl28 
          >
            L
          <TD class=xl28 
          >
            C
          <TD class=xl30 
          >
            O
          <TD class=xl30 
          >
            H
          <TD class=xl30 
          >
            L
          <TD class=xl30 
          >
            C
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38021.395833333336">
            2/4/2004 
            9:30
          <TD class=xl36 
           
          x:num="22">
            $22.00
          <TD class=xl36 
           
          x:num="22.09">
            $22.09
          <TD class=xl36 
           
          x:num="21.7">
            $21.70
          <TD class=xl36 
           
          x:num="21.78">
            $21.78
          <TD class=xl37 
           
          x:num="22">
            $22.00
          <TD class=xl37 
           
          x:num="22.09">
            $22.09
          <TD class=xl37 
           
          x:num="21.7">
            $21.70
          <TD class=xl37 
           
          x:num="21.79">
            $21.79
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G3/C3-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H3/D3-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I3/E3-1)">
             
          <TD class=xl31 
           
          x:num="4.5913682277309853E-4" x:fmla="=(J3/F3-1)">
            0.05%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38022.395833333336">
            2/5/2004 
            9:30
          <TD class=xl36 
           
          x:num="21.82">
            $21.82
          <TD class=xl36 
           
          x:num="22.91">
            $22.91
          <TD class=xl36 
           
          x:num="21.81">
            $21.81
          <TD class=xl36 
           
          x:num="22.42">
            $22.42
          <TD class=xl37 
           
          x:num="21.82">
            $21.82
          <TD class=xl37 
           
          x:num="22.91">
            $22.91
          <TD class=xl37 
           
          x:num="21.81">
            $21.81
          <TD class=xl37 
           
          x:num="22.42">
            $22.42
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G4/C4-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H4/D4-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I4/E4-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(J4/F4-1)">
             
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38023.395833333336">
            2/6/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.45">
            $22.45
          <TD class=xl36 
           
          x:num="22.89">
            $22.89
          <TD class=xl36 
           
          x:num="22.4">
            $22.40
          <TD class=xl36 
           
          x:num="22.7">
            $22.70
          <TD class=xl37 
           
          x:num="22.45">
            $22.45
          <TD class=xl37 
           
          x:num="22.89">
            $22.89
          <TD class=xl37 
           
          x:num="22.4">
            $22.40
          <TD class=xl37 
           
          x:num="22.71">
            $22.71
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G5/C5-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H5/D5-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I5/E5-1)">
             
          <TD class=xl31 
           
          x:num="4.4052863436139233E-4" x:fmla="=(J5/F5-1)">
            0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38026.395833333336">
            2/9/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.62">
            $22.62
          <TD class=xl36 
           
          x:num="22.86">
            $22.86
          <TD class=xl36 
           
          x:num="22.5">
            $22.50
          <TD class=xl36 
           
          x:num="22.67">
            $22.67
          <TD class=xl37 
           
          x:num="22.62">
            $22.62
          <TD class=xl37 
           
          x:num="22.86">
            $22.86
          <TD class=xl37 
           
          x:num="22.5">
            $22.50
          <TD class=xl37 
           
          x:num="22.67">
            $22.67
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G6/C6-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H6/D6-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I6/E6-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(J6/F6-1)">
             
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38027.395833333336">
            2/10/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.63">
            $22.63
          <TD class=xl36 
           
          x:num="23.12">
            $23.12
          <TD class=xl36 
           
          x:num="22.44">
            $22.44
          <TD class=xl36 
           
          x:num="23.03">
            $23.03
          <TD class=xl37 
           
          x:num="22.62">
            $22.62
          <TD class=xl37 
           
          x:num="23.12">
            $23.12
          <TD class=xl37 
           
          x:num="22.44">
            $22.44
          <TD class=xl37 
           
          x:num="22.98">
            $22.98
          <TD class=xl31 
           
          x:num="-4.4189129474137001E-4" x:fmla="=(G7/C7-1)">
            -0.04%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H7/D7-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I7/E7-1)">
             
          <TD class=xl31 
           
          x:num="-2.1710811984368972E-3" x:fmla="=(J7/F7-1)">
            -0.22%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38028.395833333336">
            2/11/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.12">
            $23.12
          <TD class=xl36 
           
          x:num="23.87">
            $23.87
          <TD class=xl36 
           
          x:num="23.05">
            $23.05
          <TD class=xl36 
           
          x:num="23.8">
            $23.80
          <TD class=xl37 
           
          x:num="23.09">
            $23.09
          <TD class=xl37 
           
          x:num="23.87">
            $23.87
          <TD class=xl37 
           
          x:num="23.05">
            $23.05
          <TD class=xl37 
           
          x:num="23.8">
            $23.80
          <TD class=xl31 
           
          x:num="-1.2975778546713279E-3" x:fmla="=(G8/C8-1)">
            -0.13%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H8/D8-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I8/E8-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(J8/F8-1)">
             
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38029.395833333336">
            2/12/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.75">
            $23.75
          <TD class=xl36 
           
          x:num="24">
            $24.00
          <TD class=xl36 
           
          x:num="23.6">
            $23.60
          <TD class=xl36 
           
          x:num="23.78">
            $23.78
          <TD class=xl37 
           
          x:num="23.67">
            $23.67
          <TD class=xl37 
           
          x:num="23.99">
            $23.99
          <TD class=xl37 
           
          x:num="23.6">
            $23.60
          <TD class=xl37 
           
          x:num="23.73">
            $23.73
          <TD class=xl31 
           
          x:num="-3.3684210526314651E-3" x:fmla="=(G9/C9-1)">
            -0.34%
          <TD class=xl31 
           
          x:num="-4.166666666667318E-4" x:fmla="=(H9/D9-1)">
            -0.04%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I9/E9-1)">
             
          <TD class=xl31 
           
          x:num="-2.102607232968956E-3" x:fmla="=(J9/F9-1)">
            -0.21%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38030.395833333336">
            2/13/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.73">
            $23.73
          <TD class=xl36 
           
          x:num="24.1">
            $24.10
          <TD class=xl36 
           
          x:num="22.83">
            $22.83
          <TD class=xl36 
           
          x:num="22.99">
            $22.99
          <TD class=xl37 
           
          x:num="23.85">
            $23.85
          <TD class=xl37 
           
          x:num="24.1">
            $24.10
          <TD class=xl37 
           
          x:num="22.83">
            $22.83
          <TD class=xl37 
           
          x:num="23">
            $23.00
          <TD class=xl31 
           
          x:num="5.0568900126422012E-3" x:fmla="=(G10/C10-1)">
            0.51%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H10/D10-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I10/E10-1)">
             
          <TD class=xl31 
           
          x:num="4.349717268379294E-4" x:fmla="=(J10/F10-1)">
            0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38034.395833333336">
            2/17/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.15">
            $23.15
          <TD class=xl36 
           
          x:num="23.49">
            $23.49
          <TD class=xl36 
           
          x:num="23.1">
            $23.10
          <TD class=xl36 
           
          x:num="23.17">
            $23.17
          <TD class=xl37 
           
          x:num="23.1">
            $23.10
          <TD class=xl37 
           
          x:num="23.49">
            $23.49
          <TD class=xl37 
           
          x:num="23.1">
            $23.10
          <TD class=xl37 
           
          x:num="23.16">
            $23.16
          <TD class=xl31 
           
          x:num="-2.1598272138227959E-3" x:fmla="=(G11/C11-1)">
            -0.22%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H11/D11-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I11/E11-1)">
             
          <TD class=xl31 
           
          x:num="-4.315925766077422E-4" x:fmla="=(J11/F11-1)">
            -0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38035.395833333336">
            2/18/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.05">
            $23.05
          <TD class=xl36 
           
          x:num="23.44">
            $23.44
          <TD class=xl36 
           
          x:num="23.05">
            $23.05
          <TD class=xl36 
           
          x:num="23.25">
            $23.25
          <TD class=xl37 
           
          x:num="23.18">
            $23.18
          <TD class=xl37 
           
          x:num="23.44">
            $23.44
          <TD class=xl37 
           
          x:num="23.05">
            $23.05
          <TD class=xl37 
           
          x:num="23.26">
            $23.26
          <TD class=xl31 
           
          x:num="5.6399132321041101E-3" x:fmla="=(G12/C12-1)">
            0.56%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H12/D12-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I12/E12-1)">
             
          <TD class=xl31 
           
          x:num="4.3010752688177334E-4" x:fmla="=(J12/F12-1)">
            0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38036.395833333336">
            2/19/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.28">
            $23.28
          <TD class=xl36 
           
          x:num="23.64">
            $23.64
          <TD class=xl36 
           
          x:num="22.43">
            $22.43
          <TD class=xl36 
           
          x:num="22.49">
            $22.49
          <TD class=xl37 
           
          x:num="23.31">
            $23.31
          <TD class=xl37 
           
          x:num="23.64">
            $23.64
          <TD class=xl37 
           
          x:num="22.41">
            $22.41
          <TD class=xl37 
           
          x:num="22.47">
            $22.47
          <TD class=xl31 
           
          x:num="1.2886597938144284E-3" x:fmla="=(G13/C13-1)">
            0.13%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H13/D13-1)">
             
          <TD class=xl31 
           
          x:num="-8.9166295140430396E-4" x:fmla="=(I13/E13-1)">
            -0.09%
          <TD class=xl31 
           
          x:num="-8.8928412627831133E-4" x:fmla="=(J13/F13-1)">
            -0.09%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38037.395833333336">
            2/20/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.49">
            $22.49
          <TD class=xl36 
           
          x:num="22.51">
            $22.51
          <TD class=xl36 
           
          x:num="22.21">
            $22.21
          <TD class=xl36 
           
          x:num="22.38">
            $22.38
          <TD class=xl37 
           
          x:num="22.5">
            $22.50
          <TD class=xl37 
           
          x:num="22.51">
            $22.51
          <TD class=xl37 
           
          x:num="22.21">
            $22.21
          <TD class=xl37 
           
          x:num="22.4">
            $22.40
          <TD class=xl31 
           
          x:num="4.4464206313921117E-4" x:fmla="=(G14/C14-1)">
            0.04%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H14/D14-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I14/E14-1)">
             
          <TD class=xl31 
           
          x:num="8.9365504915095428E-4" x:fmla="=(J14/F14-1)">
            0.09%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38040.395833333336">
            2/23/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.45">
            $22.45
          <TD class=xl36 
           
          x:num="22.5">
            $22.50
          <TD class=xl36 
           
          x:num="21.89">
            $21.89
          <TD class=xl36 
           
          x:num="22.1">
            $22.10
          <TD class=xl37 
           
          x:num="22.45">
            $22.45
          <TD class=xl37 
           
          x:num="22.46">
            $22.46
          <TD class=xl37 
           
          x:num="21.89">
            $21.89
          <TD class=xl37 
           
          x:num="22.19">
            $22.19
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G15/C15-1)">
             
          <TD class=xl31 
           
          x:num="-1.777777777777767E-3" x:fmla="=(H15/D15-1)">
            -0.18%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I15/E15-1)">
             
          <TD class=xl31 
           
          x:num="4.0723981900452344E-3" x:fmla="=(J15/F15-1)">
            0.41%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38041.395833333336">
            2/24/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.11">
            $22.11
          <TD class=xl36 
           
          x:num="22.74">
            $22.74
          <TD class=xl36 
           
          x:num="22">
            $22.00
          <TD class=xl36 
           
          x:num="22.37">
            $22.37
          <TD class=xl37 
           
          x:num="22.14">
            $22.14
          <TD class=xl37 
           
          x:num="22.74">
            $22.74
          <TD class=xl37 
           
          x:num="22">
            $22.00
          <TD class=xl37 
           
          x:num="22.36">
            $22.36
          <TD class=xl31 
           
          x:num="1.3568521031208647E-3" x:fmla="=(G16/C16-1)">
            0.14%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H16/D16-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I16/E16-1)">
             
          <TD class=xl31 
           
          x:num="-4.4702726866341358E-4" x:fmla="=(J16/F16-1)">
            -0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38042.395833333336">
            2/25/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.2">
            $22.20
          <TD class=xl36 
           
          x:num="22.9">
            $22.90
          <TD class=xl36 
           
          x:num="22.19">
            $22.19
          <TD class=xl36 
           
          x:num="22.82">
            $22.82
          <TD class=xl37 
           
          x:num="22.22">
            $22.22
          <TD class=xl37 
           
          x:num="22.9">
            $22.90
          <TD class=xl37 
           
          x:num="22.21">
            $22.21
          <TD class=xl37 
           
          x:num="22.81">
            $22.81
          <TD class=xl31 
           
          x:num="9.009009009008917E-4" x:fmla="=(G17/C17-1)">
            0.09%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H17/D17-1)">
             
          <TD class=xl31 
           
          x:num="9.0130689499767769E-4" x:fmla="=(I17/E17-1)">
            0.09%
          <TD class=xl31 
           
          x:num="-4.3821209465388922E-4" x:fmla="=(J17/F17-1)">
            -0.04%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38043.395833333336">
            2/26/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.81">
            $22.81
          <TD class=xl36 
           
          x:num="23.18">
            $23.18
          <TD class=xl36 
           
          x:num="22.8">
            $22.80
          <TD class=xl36 
           
          x:num="23.11">
            $23.11
          <TD class=xl37 
           
          x:num="22.84">
            $22.84
          <TD class=xl37 
           
          x:num="23.18">
            $23.18
          <TD class=xl37 
           
          x:num="22.8">
            $22.80
          <TD class=xl37 
           
          x:num="23.04">
            $23.04
          <TD class=xl31 
           
          x:num="1.3152126260411734E-3" x:fmla="=(G18/C18-1)">
            0.13%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H18/D18-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I18/E18-1)">
             
          <TD class=xl31 
           
          x:num="-3.0289917784509512E-3" x:fmla="=(J18/F18-1)">
            -0.30%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38044.395833333336">
            2/27/2004 
            9:30
          <TD class=xl36 
           
          x:num="22.96">
            $22.96
          <TD class=xl36 
           
          x:num="24.02">
            $24.02
          <TD class=xl36 
           
          x:num="22.95">
            $22.95
          <TD class=xl36 
           
          x:num="23.9">
            $23.90
          <TD class=xl37 
           
          x:num="22.96">
            $22.96
          <TD class=xl37 
           
          x:num="24.02">
            $24.02
          <TD class=xl37 
           
          x:num="22.95">
            $22.95
          <TD class=xl37 
           
          x:num="23.92">
            $23.92
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G19/C19-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H19/D19-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I19/E19-1)">
             
          <TD class=xl31 
           
          x:num="8.3682008368213268E-4" x:fmla="=(J19/F19-1)">
            0.08%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38047.395833333336">
            3/1/2004 
            9:30
          <TD class=xl36 
           
          x:num="24.1">
            $24.10
          <TD class=xl36 
           
          x:num="24.3">
            $24.30
          <TD class=xl36 
           
          x:num="23.87">
            $23.87
          <TD class=xl36 
           
          x:num="24">
            $24.00
          <TD class=xl37 
           
          x:num="24.09">
            $24.09
          <TD class=xl37 
           
          x:num="24.3">
            $24.30
          <TD class=xl37 
           
          x:num="23.87">
            $23.87
          <TD class=xl37 
           
          x:num="24.02">
            $24.02
          <TD class=xl31 
           
          x:num="-4.1493775933620913E-4" x:fmla="=(G20/C20-1)">
            -0.04%
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H20/D20-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I20/E20-1)">
             
          <TD class=xl31 
           
          x:num="8.3333333333324155E-4" x:fmla="=(J20/F20-1)">
            0.08%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38048.395833333336">
            3/2/2004 
            9:30
          <TD class=xl36 
           
          x:num="24">
            $24.00
          <TD class=xl36 
           
          x:num="24.1">
            $24.10
          <TD class=xl36 
           
          x:num="23.8">
            $23.80
          <TD class=xl36 
           
          x:num="23.83">
            $23.83
          <TD class=xl37 
           
          x:num="24">
            $24.00
          <TD class=xl37 
           
          x:num="24.1">
            $24.10
          <TD class=xl37 
           
          x:num="23.77">
            $23.77
          <TD class=xl37 
           
          x:num="23.81">
            $23.81
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G21/C21-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H21/D21-1)">
             
          <TD class=xl31 
           
          x:num="-1.2605042016806678E-3" x:fmla="=(I21/E21-1)">
            -0.13%
          <TD class=xl31 
           
          x:num="-8.3927822073015523E-4" x:fmla="=(J21/F21-1)">
            -0.08%
        
          <TD class=xl33 
           
          height=17>
            AAPL
          <TD class=xl35 
           
          x:num="38049.395833333336">
            3/3/2004 
            9:30
          <TD class=xl36 
           
          x:num="23.6">
            $23.60
          <TD class=xl36 
           
          x:num="24.19">
            $24.19
          <TD class=xl36 
           
          x:num="23.6">
            $23.60
          <TD class=xl36 
           
          x:num="23.89">
            $23.89
          <TD class=xl37 
           
          x:num="23.6">
            $23.60
          <TD class=xl37 
           
          x:num="24.19">
            $24.19
          <TD class=xl37 
           
          x:num="23.6">
            $23.60
          <TD class=xl37 
           
          x:num="23.92">
            $23.92
          <TD class=xl31 
           
          x:num="0" x:fmla="=(G22/C22-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(H22/D22-1)">
             
          <TD class=xl31 
           
          x:num="0" x:fmla="=(I22/E22-1)">
             
          <TD class=xl31 
           
          x:num="1.2557555462537895E-3" x:fmla="=(J22/F22-1)">
            <FONT 
      size=2>0.13%
      
        <FONT face=Tahoma 
        size=2>-----Original Message-----From: Tomasz Janeczko 
        [mailto:amibroker@xxxxxx]Sent: Tuesday, March 16, 2004 4:15 
        AMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: 
        [amibroker] Does your eSignal data match your QP2 
        data???Importance: High
        Herman,
         
        As I wrote you in a separate e-mail: if you are in EST 
        time zone you should turn on pre/after hours filtering and 
        set
        START time to 9:30 and END time to 15:59. If you set 
        it otherwise open or close price may be slightly different
        than QP2 data because of after hours trading being 
        accounted. So please check start-end times you have in
        File->Database Settings->Intraday 
        Settings. <FONT face=Arial 
        color=#0000ff>  
        <FONT face=Arial 
        color=#0000ff> 
        <FONT face=Arial 
        color=#0000ff>Tomasz, I followed all suggestions you made to the 
        letter. All my settings are correct and I also created the new 
        eSignal EOD database. If anybody  doubts my findings then just 
        run the two code samples to convince yourself - don't go by my word 
        alone. I fact I challenge anybody to prove me wrong using the code shown 
        previously. 
         
        Anyway you will never be able to reach 100% match 
        because
        intraday data contain all trading (including Form-Ts). 
        My observation is that Form-Ts start flowing even before 
        16:00
        hence streaming intraday data will contain them while 
        EOD data not as per nasdaq regulations.<SPAN 
        class=796213912-16032004><FONT face=Arial 
        color=#0000ff> 
        <SPAN 
        class=796213912-16032004> 
        <FONT face=Arial 
        color=#0000ff>I do not expect a 100% match however I do not 
        expect a 38% error rate accross all price fields (OHLC) either 
        this is too high to successfully translate any EOD short term trading 
        system to RT. 
        <FONT face=Arial 
        color=#0000ff> 
        <FONT face=Arial 
        color=#0000ff>The TimeFrameGetPrice() does not help here. 
        What we need is a way to switch 
        from eSignal RT or eSignal EOD on the fly. The only 
        alternative I see is to run two AB instances and use 
        custom files to share data between them. This means forever 
        synchronizing two code versions, maintain two databases, and develop 
        additional data-sharing code.
        See the following excerpt from: <A 
        href="">http://www.csidata.com/techjournal/csinews/200010/page01.htm
         
        "A complicating feature of this arrangement was 
        the inconsistent way trades were reported for the various exchanges. All 
        trades for Nasdaq-listed issues that occurred in the late trading 
        session (after 4:00 p.m.) were sent from Nasdaq as Form-T trades. By 
        Nasdaq rule, these trades were not (and still are not) allowed to change 
        the official daily high-low-last price data, but they do increment the 
        volume. Ostensibly, this is because Nasdaq uses 4:00 p.m. prices to 
        calculate indices. They (apparently) have no way to preserve the 4:00 
        p.m. price quote for each index component. In contrast, trades on Nasdaq 
        of NYSE-listed issues were sent as regular trades, which altered the 
        official composite high-low-last quote.<FONT 
        face="Times New Roman,Times"><FONT 
        color=#000000>  "
        Best regards,Tomasz 
        Janeczkoamibroker.com
        <BLOCKQUOTE 
        >
          ----- Original Message ----- 
          <DIV 
          >From: 
          Herman van den 
          Bergen 
          To: <A 
          title=amibroker@xxxxxxxxxxxxxxx 
          href="">amibroker@xxxxxxxxxxxxxxx 
          
          Sent: Tuesday, March 16, 2004 
          1:09 AM
          Subject: RE: [amibroker] Does 
          your eSignal data match your QP2 data???
          
          <FONT face=Arial color=#0000ff 
          size=2>Yes Tomasz I did created a new EOD eSignal data base and i 
          found that (over the same 20-day random sample) QP2 and eSignal data 
          were exactly the same using EOD, the problem i have is with the 
          RT data conversion to EOD prices using only the eSignal RT 
          database. 
          <FONT face=Arial color=#0000ff 
          size=2> 
          <FONT face=Arial color=#0000ff 
          size=2>Also, as you suggested, setting AA Settings to 
          the Daily mode <SPAN 
          class=765523122-15032004>gave 
          EOD prices that matched the OHLC extracted from RT data, but they do 
          not match either QP2 or eSignal EOD data - this suggests that 
          either my code is wrong or RT data is different. When 
          setting the AA to Minutes and using <FONT color=#0000ff 
          size=2>TimeFrameGetPrice(<FONT 
          color=#ff00ff size=2>"O", inDaily, expandFirst 
          ); to extract EOD prices from eSignal RT 
          data this gives me different prices from both QP2 and 
          eSignal EOD data. 
          <FONT face=Arial color=#0000ff 
          size=2> 
          Any suggestions on 
          how I can extract EOD 
          data from eSignal RT will be appreciated. 
          <SPAN 
          class=765523122-15032004><FONT face=Arial color=#0000ff 
          size=2> 
          <FONT face=Arial color=#0000ff 
          size=2>best regards,
          <FONT face=Arial color=#0000ff 
          size=2>Herman.
          <FONT 
          color=#008000>// Real time Exploration Run on eSignal<SPAN 
          class=765523122-15032004>, use 1 Minute settingsOt= 
          TimeFrameGetPrice(<FONT 
          color=#ff00ff>"O", inDaily,expandLast );Ht = 
          TimeFrameGetPrice(<FONT 
          color=#ff00ff>"H", inDaily,expandLast );Lt = 
          TimeFrameGetPrice(<FONT 
          color=#ff00ff>"L", inDaily,expandLast );Ct = 
          TimeFrameGetPrice(<FONT 
          color=#ff00ff>"C", inDaily,expandLast );Vt = 
          TimeFrameGetPrice(<FONT 
          color=#ff00ff>"V", inDaily,expandLast 
          );Buy=Sell=Short=Cover=<FONT 
          color=#ff00ff>0;Filter = <FONT 
          color=#0000ff>TimeNum() == <FONT 
          color=#ff00ff>093000;<FONT 
          color=#0000ff>AddColumn(Ot,"O",<FONT 
          color=#ff00ff>1.2);<FONT 
          color=#0000ff>AddColumn(Ht,"H",<FONT 
          color=#ff00ff>1.2);<FONT 
          color=#0000ff>AddColumn(Lt,"L",<FONT 
          color=#ff00ff>1.2);<FONT 
          color=#0000ff>AddColumn(Ct,"C",<FONT 
          color=#ff00ff>1.2);<FONT 
          size=2> // 
          Exploration Run on QP2, use Daily 
          settingsBuy=Sell=Short=Cover=<FONT 
          color=#ff00ff>0;Filter = <FONT 
          color=#ff00ff>1;<FONT 
          color=#0000ff>AddColumn(O,<FONT 
          color=#ff00ff>"O",1.2);<FONT 
          color=#0000ff>AddColumn(H,<FONT 
          color=#ff00ff>"H",1.2);<FONT 
          color=#0000ff>AddColumn(L,<FONT 
          color=#ff00ff>"L",1.2);<FONT 
          color=#0000ff>AddColumn(C,<FONT 
          color=#ff00ff>"C",1.2);
          
          <FONT 
          size=2> <FONT face=Tahoma 
          size=2>-----Original Message-----From: Tomasz Janeczko 
          [mailto:amibroker@xxxxxx]Sent: Monday, March 15, 2004 4:45 
          PMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: 
          [amibroker] Does your eSignal data match your QP2 
          data???Importance: High
          
            Herman,
             
            Did you do what I suggested ? I.e. creating 
            eSignal database with base time interval set to "EOD (daily)" 
            ?
            Best regards,Tomasz Janeczkoamibroker.com
            <BLOCKQUOTE 
            >
              ----- Original Message ----- 
              <DIV 
              >From: 
              Herman van 
              den Bergen 
              To: <A 
              title=amibroker@xxxxxxxxxxxxxxx 
              href="">AmiBroker 
              Sent: Monday, March 15, 2004 
              6:09 PM
              Subject: [amibroker] Does 
              your eSignal data match your QP2 data???
              
              <SPAN 
              class=531415316-15032004>Hello,
              <SPAN 
              class=531415316-15032004> 
              I run 
              both eSignal and QP2 data and am porting some mature QP2 
              EOD code to eSignal to see if it can be enhanced with RT 
              data. Before changing any code I wanted to confirm 
              identical EOD performance in both data environments, I found huge 
              discrepancies. Comparing daily OHLC prices derived from eSignal RT 
              data with OHLC data from QuotePlus I found that taking a Random 
              20-day sample showed 38% disagreement between the two data 
              sources. Now the question arises as to which is the correct 
              one?
              <SPAN 
              class=531415316-15032004> 
              If you 
              have both data sources please let me know if you have noticed this 
              discrepancy. I used the following code snippets to illustrate this 
              problem. I used two separate AB instances; one configured for 
              eSignal and one for QuotePlus. Perhaps I am doing something 
              wrong....I hope so!
              <SPAN 
              class=531415316-15032004> 
              Many 
              thanks for any comments you can make,
              <SPAN 
              class=531415316-15032004>Herman.
              <SPAN 
              class=531415316-15032004> 
              // 
              Exploration Run on QP2Buy=Sell=Short=Cover=0;Filter = 
              1;AddColumn(O,"O",1.2);AddColumn(H,"H",1.2);AddColumn(L,"L",1.2);AddColumn(C,"C",1.2);
              <SPAN 
              class=531415316-15032004> 
              // 
              Real time Exploration Run on eSignalOt= TimeFrameGetPrice("O", 
              inDaily);Ht = TimeFrameGetPrice("H", inDaily);Lt = 
              TimeFrameGetPrice("L", inDaily);Ct = TimeFrameGetPrice("C", 
              inDaily);Vt = TimeFrameGetPrice("V", 
              inDaily);
              <SPAN 
              class=531415316-15032004>Buy=Sell=Short=Cover=0;Filter = 
              TimeNum() == 
              093000;AddColumn(Ot,"O",1.2);AddColumn(Ht,"H",1.2);AddColumn(Lt,"L",1.2);AddColumn(Ct,"C",1.2);Send 
              BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
              suggest@xxxxxxxxxxxxx-----------------------------------------Post 
              AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
              (Web page: <A 
              href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
              group FAQ at: <A 
              href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
              Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend 
              SUGGESTIONS to 
              suggest@xxxxxxxxxxxxx-----------------------------------------Post 
              AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
              (Web page: <A 
              href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
              group FAQ at: <A 
              href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
              Send BUG REPORTS to 
          bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
          suggest@xxxxxxxxxxxxx-----------------------------------------Post 
          AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web 
          page: <A 
          href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
          group FAQ at: <A 
          href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
          Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend 
          SUGGESTIONS to 
          suggest@xxxxxxxxxxxxx-----------------------------------------Post 
          AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web 
          page: <A 
          href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
          group FAQ at: <A 
          href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
          Send BUG REPORTS to 
      bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
      suggest@xxxxxxxxxxxxx-----------------------------------------Post 
      AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: 
      <A 
      href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
      group FAQ at: <A 
      href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
      Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend 
      SUGGESTIONS to 
      suggest@xxxxxxxxxxxxx-----------------------------------------Post 
      AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: 
      <A 
      href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
      group FAQ at: <A 
      href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
      Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend 
      SUGGESTIONS to 
      suggest@xxxxxxxxxxxxx-----------------------------------------Post 
      AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: 
      <A 
      href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
      group FAQ at: <A 
      href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
      Send BUG REPORTS to 
  bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
  suggest@xxxxxxxxxxxxx-----------------------------------------Post 
  AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A 
  href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
  group FAQ at: <A 
  href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
  


Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html








Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/ 
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.