|
PureBytes Links
Trading Reference Links
|
Hello Dave,
I can't really comment on TradeSim as I only have a passing acquaintance
with it.
On the lowest level, you can simply copy and paste your price series from
Metastock into a blank worksheet. This will give you your OHLCV for however
many days you were displaying on your chart. You can then enter your
formulas (formulae!!) and your test conditions into subsequent Excel
columns. Excel formulas for most indicators can be found on the web. S&C
magazine has provided them for years with relevant articles.
You can also do bar/candlestick charting in Excel. You may well be able to
plot entry/exit indicators; I don't know. If you really want to get fancy,
you can also read equities into Excel in batch mode.
I regret that I am not much of an expert so I can't advise on the finer
points but I hope that it may give you food for thought.
Regards,
Kevin
At 15:25 22/03/2004 +0000, you wrote:
>
>Hello Kevin,
>
>How can you use Excel to backtest? Is the backtesting capability
>similar to TradeSim?
>
>Thanks in advance.
>
>Dave
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Metastockusers/
<*> To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|