|
PureBytes Links
Trading Reference Links
|
Yuki,
You need to do the following:
1. Export the data set from both databases, each to
an ASCII (text) file. One issue per file. They can be comma or tab
separated.
2. Import each file into Excel using the get
External Data function in Excel. (Data - Get External Data menu).
3. Place the two sets of data next to each other.
Make sure they start on the same date.
4. Create a new column of data as the difference
between the two. The difference should always be zero since theoretically the
are the same.
Any results other than zero is an error in one or
the other data set, which can cause differing test results.
Frequently you'll find problems of data integrity
such as bad ticks. High are VERY high or Lows are VERY Low.
Ara
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Yuki
Taga
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">Ara Kaloustian
Sent: Monday, March 10, 2003 8:43
PM
Subject: Re: [amibroker] conflicting
database data
Hi Ara,Tuesday, March 11, 2003, 9:34:17 AM, you
wrote:AK> You might consider bringing both sets to Excel and
compare with aAK> simple subtraction...Can you explain exactly
how you would do that? I'm afraid I don'tget it right off the
bat.YukiAK> I am getting different
results from aAK> composite scan of an identical set of
stocks that reside in twoAK> different databases. Visually,
I can see that fairly recentAK> indicator values that go
into the composite scan have differentAK> values in the
different databases, so that is not surprising.AK> What is
surprising is that the indicator values themselves doAK>
not match perfectly.AK> One database is very small,
maintained by me by hand. The otherAK> database is
updated daily via Downloadquotes.com. (I can report
thatAK> their data is not always reliable, sadly.)
All of the stocks in theAK> small database are duplicated
in the larger one, and there would beAK> absolutely no
reason for any indicator or scan difference onAK> identical
issues unless there are differences in the prices or
volumeAK> between the two databases. This has to be
it, doesn't it?AK> So, is there a way I can easily
compare to Metastock-format dataAK> files to see if there
are any differences between them?AK> Yuki
^_^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
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|