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