|
PureBytes Links
Trading Reference Links
|
>From the few people I know who use industry groups, they do what you are
doing, i.e., copying to Excel the results of the explorer.
Harley
Aongus Flood wrote:
> Currently I do the following:
>
> >From and interesting stock-chart being watched, I select the price
> and copy
> it to the clipboard. I then paste this into Excel and dump it to a
> flat
> file after some trivial format changes. I then run some custom coded
> programs on the price data file and output an indicator to another
> file.
> (My current inventory of custom coded stuff has been strongly
> influenced by
> Box-Jenkins, Masters and Press, especially the code examples from the
> later
> two. I have developed some hybrid methods based on filtering,
> statistics
> and neurals that show some promise.) The indicator output file is
> then
> imported back into Excel and copied to the clipboard. Then from
> within
> MetaStock I paste the indicator back into the chart.
>
> Now, after all this pointing and clicking I can get visual feedback,
> It may
> be possible even to use the indicator in a system to see any profits
> generated but I have not got that far yet.
>
> My question is this: How can this process be automated or made more
> efficient. Ideally I would like to create an Explorer that could
> scan and
> report on a variety of securities from within MS. Have any of you
> used OLE
> to achieve similar functionality or extend the macro language of MS.
>
> My apologies to the group, if this is considered off the core subject.
>
> However, if this only serves to bring interested parties in touch with
> one
> another, I would highly appreciate it.
>
> Thanks
> Aongus
> aflood@xxxxxxxx
|