|
PureBytes Links
Trading Reference Links
|
Craig,
thanks a lot for this helpful information.
It clears up things for me and I am going to try this now.
Danke,
Werner
--- In equismetastock@xxxxxxxxxxxxxxx, "zenzen" <zenzen@xxxx> wrote:
> > Subject: Re: Outside Indicators
> >
> > Good day,
> > thanks for the info and the help (Craig).
> > I had the following idea for importing an "outside indicator"
(from
> > Excel), which may be much simpler. My indicator file looks like
this:
> > 12-10-03 50
> > 12-11-03 52
> > 12-12-03 52.5
> > and so forth.
> > There is a 5 year history of the indicator.
> > Now, (I think) I could create a security, called "MyIndicator" in
MS
> > and import the data from Excel to the Downloader. Then MS could
read
> > and display "My Indicator" and I could manipulate "My Indicator"
in
> > any way I want with MS.
> > Does this work? If yes, HOW am I going to do this?
> > Thanks.
> > Werner
>
> Werner,
> Depending on how many fields of data you want to transfer in, that
is quite
> easy - you are on the right track.
>
> 1. Open Metastock and the downloader
> 2. In the downloader copy one of your metastock data files to
another
> directory
> 3. Use the downloader to open that data file. This will give you a
> spreadsheet. Rename it to something like 'Fundamental Data' with a
symbol of
> 'FD'
> 4. Paste in from Excel your values. If it's just the one column
paste it
> into the close. Take care that the date ranges allign otherwise you
can set
> the cell format in Excel for the date and just paste over the
existing data.
> 5. Copy the new security back to the original source directory
> 6. In Metastock create a new indicator and type in (Some old
versions of MS
> might not support this).
> Security("FD", C)
> This means get the close data from the security called FD. You can
also open
> FD as a normal stock and use moving averages etc.
>
> * You could transer data in the OHLCV columns, i.e. 5 fields. Take
care when
> doing any file repairs with sort or test in the downloader because
it might
> detect errors like H<L (obviously an error in a stock price).
> * You can create a new file directly. Copying an existing file is
only a
> quick way to test the idea. (NB these probably have to be in the
same
> directory as other data files).
> * Having a fundamental data set for each individual stock would be
more
> complicated
>
> Hope that helps,
> Craig.
>
> PS thanks for asking this question, I have often wondered if using
some
> external fundamental data would be useful in a trading system.
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|