|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content='"MSHTML 4.72.3616.1301"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>Hi,</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT size=2>This may not be a solution but you can highlight an indicator
in Metastock and Copy/Paste values into Excel (the drawback is that is copies
the indicator over all dates shown in Metastock. An easy fix is to use the
method just described in a remote portion of the spreadsheet and have another
column reference just the data needed) - Brian</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Kornberg Family <<A
href="mailto:kornberg@xxxxxxxxxxxxxxx";>kornberg@xxxxxxxxxxxxxxx</A>><BR><B>To:
</B>Metastock List <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Date:
</B>Saturday, January 29, 2000 4:49 PM<BR><B>Subject: </B>Excel &
Metastock - Using Calcs From Metastock<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=430234222-29012000>Is anyone aware
of a way to be able to use a calculated value from Metastock in an Excel
spreadsheet? By this I mean a method where a field in Excel may get,
for example, an ATR value directly from Metastock on a particular stock
etc. Currently for me to calculate an ATR in Excel, I use a
spreadsheet, I need to bring in dates from Metastock.
Otherwise, I open both programs, and then insert the value from
Metastock. This can be fiddly.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=430234222-29012000>If this is not
able to be done in 6.52EOD, is it possible in 7.0?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=430234222-29012000>Otherwise, does
anyone have a suggestion as to calculate an ATR in Excel using Metastock
data files?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000>Thanks,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=430234222-29012000>Andrew</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Jan 29 17:02:58 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id RAA06235
for <neal@xxxxxxxxxxxxx>; Sat, 29 Jan 2000 17:46:31 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA11622
for metastock-outgoing; Sat, 29 Jan 2000 17:16:12 -0700
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id RAA11619
for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 29 Jan 2000 17:16:09 -0700
Received: from elch.de.uu.net (elch.de.uu.net [192.76.144.55])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA12472
for <metastock@xxxxxxxxxxxxx>; Sat, 29 Jan 2000 17:28:16 -0700 (MST)
Received: from primus (pec-5-111.tnt1.m2.uunet.de [149.225.5.111])
by elch.de.uu.net (5.5.5/5.5.5) with SMTP id BAA10204
for <metastock@xxxxxxxxxxxxx>; Sun, 30 Jan 2000 01:10:15 +0100 (MET)
From: "Andreas Grau" <agrau@xxxxxxxxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Perfect Profit
Date: Sun, 30 Jan 2000 01:10:33 +0100
Message-ID: <000701bf6ab6$6d3141c0$3905e195@xxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
The following is an extract from the book "Design, Testing and Optimitaion
of Trading Systems" by Robert Pardo:
<snip>
Perfect profit is a theoretical measure of market potential. It is the
total dollar profit resulting from buying every valley and selling every
peak that occurs in price movement. Obviously, this is an impossible task,
hence the name perfect profit. Mathematically, it is the sum of the
absolute price differences.
</snip>
Pardo uses this "Perfect Profit" to compare it to the actual equity curve
of the trading system, thus measuring the system performance in comparision
to the profit opportunities of the market: The higher the correlation
coefficient, the better the system.
Now for my question: Would it be better to add up ABS(HIGH - LOW) or better
ABS(OPEN-CLOSE) ? Or even some other calculation?
Any input/help would be highly appreciated!
Thanks,
Andreas
---
Andreas Grau aka agrau@xxxxxxxxx
Telefon 089-27349990
Reality is an illusion -- perception is what counts
|