|
PureBytes Links
Trading Reference Links
|
Greg,
This is the same technique I used in developing our Clipper based system.
We calculate all of the indicators daily and post them in the database,
thereby eliminating the requirement to recalculate them every day. In those
cases where I need intermediate results, I store those as well. The
database is larger than what you would normally maintain, but the speed
advantage is remarkable. We update approximately 30 futures in about 30
seconds.
Guy
Politicians and diapers have one thing in common. They should both be
changed regularly and for the same reason.
-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Gregoire Tardy
Sent: Wednesday, October 11, 2000 1:47 AM
To: metastock@xxxxxxxxxxxxx
Subject: RE: Txt -> Access -> MetaStock - DB to share.
Hi everyone,
In fact my goal is to build specific indicators in the
Access table, as a new column for each indicator. I
haven't invested much time into the MStock language
and it is easier for me to program using variables in
Visual Basic. After, in Excel, I build reports which
get automatically updated everytime I open the
workbook (use the OLAP cube feature in Excel 2000). I
have set of reports showing the top 10 of the day,
month, year with visual indicators (i.e. blinking if
cross over of oving average). All of this is still
under development. The first component, relatively
stable, is the Access DB.
Greg.
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
|