|
PureBytes Links
Trading Reference Links
|
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
|