|
PureBytes Links
Trading Reference Links
|
Hi Ara,
Ah, okay. That seems very clear. I'll give it a try and let you
know.
Thanks,
Yuki
AK> Yuki,
AK> You need to do the following:
AK> 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.
AK> 2. Import each file into Excel using the get External Data function in Excel. (Data - Get External Data menu).
AK> 3. Place the two sets of data next to each other. Make sure they start on the same date.
AK> 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.
AK> Any results other than zero is an error in one or the other data set, which can cause differing test results.
AK> Frequently you'll find problems of data integrity such as bad ticks. High are VERY high or Lows are VERY Low.
AK> Ara
AK> ----- Original Message -----
AK> From: Yuki Taga
AK> To: Ara Kaloustian
AK> Sent: Monday, March 10, 2003 8:43 PM
AK> Subject: Re: [amibroker] conflicting database data
AK> Hi Ara,
AK> Tuesday, March 11, 2003, 9:34:17 AM, you wrote:
AK> AK> You might consider bringing both sets to Excel and compare with a
AK> AK> simple subtraction...
AK> Can you explain exactly how you would do that? I'm afraid I don't
AK> get it right off the bat.
AK> Yuki
AK> AK> I am getting different results from a
AK> AK> composite scan of an identical set of stocks that reside in two
AK> AK> different databases. Visually, I can see that fairly recent
AK> AK> indicator values that go into the composite scan have different
AK> AK> values in the different databases, so that is not surprising.
AK> AK> What is surprising is that the indicator values themselves do
AK> AK> not match perfectly.
AK> AK> One database is very small, maintained by me by hand. The other
AK> AK> database is updated daily via Downloadquotes.com. (I can report that
AK> AK> their data is not always reliable, sadly.) All of the stocks in the
AK> AK> small database are duplicated in the larger one, and there would be
AK> AK> absolutely no reason for any indicator or scan difference on
AK> AK> identical issues unless there are differences in the prices or volume
AK> AK> between the two databases. This has to be it, doesn't it?
AK> AK> So, is there a way I can easily compare to Metastock-format data
AK> AK> files to see if there are any differences between them?
AK> AK> Yuki ^_^
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 http://docs.yahoo.com/info/terms/
|