|
PureBytes Links
Trading Reference Links
|
Hi Mark
Nobody uses Winscript that I know of. One or two use EZ Macro. Most have the
web queries etc built into Excel and it's all automated up to the actual
conversion using Downloader. I think that most do the actual daily
conversion by hand (i.e., press the "OK" button <G>).
Others only do specialized system testing on historical data in Metastock
where once the data is imported into Metastock, it is usually not updated.
Only the results are exported to Excel.
With the Bohl data that you mentioned. They will not let you automatically
download using web queries, some problem with re-sellers etc. So you have to
download the daily data web page. Save as ".txt" to file. Open in Excel
using the sub that I posted.
The contracts (or stock) names are kept in one sheet and subs loop through
the data stripping out the correct contracts and putting it onto the end of
the daily file(s). (This is proprietary to another trader so I can't release
it.)
The worksheets is cleaned up, put into Metastock format and saved using
another sub. The saved XL file is converted to ASCII text and converted by
hand (i.e., changing the Downloader folders and convert settings/options).
All the subs are run from a master sub.
Pretty kludgy ... I'm sure that it could be cleaned up or Winscript could be
used. I haven't had time to learn it yet.
As I mentioned, everybody is still new to the Metastock/Excel integration
package and Metastock hasn't really make it very easy. But .. we'll get
there.
Most of the traders have their own personal daily trading, system testing
and reporting built right into their various workbooks. For example, I've
seen a Linda B-R Street Smarts workbook, a Meyers Turbo workbook, plus many
other hybrids ... they are complete in themselves, including the statistical
analysis, trade/money management, etc.
If you know how to Winscript any of this I like to hear about it.
Best regards
Walter
----- Original Message -----
From: "scheier" <scheier@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, June 06, 2000 10:19 AM
Subject: Re: automating Metastock
| Walter, in the world of XL programmers that you frequent, has anybody
automated
| the process of downloading an internet EOD ascii data file into XL, order
the
| columns to fit requirements, and merge it into current metastock
directories so
| that the whole thing is reduced to a couple of WinScript actions?
|
| Mark Scheier
|
| The early availability of eod stock data from this site stockhistory.com
| (updated every hour) makes the possibility of running system scans that
much
| earlier in the afternoon all the more attractive.
|
| Walter Lake wrote:
|
| > Hi Moshe and others who wrote.
| >
| > Sorry ... I don't know much about automating Metastock actions and
| > procedures.
| >
| > Metastock has recently released access to their program for users and
| > outside programmers, I'm sure that Ton or others can tell you more about
| > that. I don't know of anything that has been written that is available
as an
| > add-on.
| >
| > Most of the work that I see is in Excel and VBA. Some VB stuff is
available.
| > We are still in the very early stages of Metastock/Excel integration.
| >
| > There seems to be several groups of users: occasional users, stock
scanners
| > and futures/index traders, etc. Each have their own trading system
| > development / testing needs.
| >
| > Now that the Y2K problem is over, most of the users that I hear from
expect
| > Metastock to be a stable end-of-the line product that is just fine the
way
| > it is. Very little effort is going into new indicator development and
| > traditional indicator systems. Other areas are being integrated.
| >
| > Best regards
| >
| > Walter
|
|