|
PureBytes Links
Trading Reference Links
|
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>
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,
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>
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>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>
<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>
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
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> -----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@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 Sponsor
ADVERTISEMENT
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.
|