|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Ton,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> Thanks for the reply. I had sent a
message to MetaStock Customer service..and informed them of this problem and
wanted</FONT></DIV>
<DIV><FONT face=Arial size=2>to post the jpeg here on the list for there
viewing. I will try the OLE-Linked method you have suggested. Does anyone know
whether</FONT></DIV>
<DIV><FONT face=Arial size=2>this problem also exist in MetaStock Ver
7.0?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> Adam</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
A.J. Maas
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>Metastock-List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A href="mailto:support@xxxxxxxxx";
title=support@xxxxxxxxx>support@xxxxxxxxx</A> ; <A
href="mailto:suggestions@xxxxxxxxx";
title=suggestions@xxxxxxxxx>suggestions@xxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, February 20, 2000 7:00
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Inserting Excel charts into
MetaStock problem......</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>-ehh the Subject should have read:</FONT></DIV>
<DIV><FONT size=2> Inserting MetaStock charts into Excel being a
MetaStock problem...........</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-below is for adding to the Instructions+FAQ collection
</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><FONT size=2>
<DIV><FONT size=2><STRONG>OLE between MSK+Excel (+v.v.)
- FAQ's </STRONG>{where MetaStock has other programs
returning errors}</FONT></DIV>
<DIV><FONT
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><STRONG>Q9. </STRONG></FONT><FONT
color=#000000>Why, in Excel, do I get errors when using Excel's "Insert an
Object" function, eg </FONT></FONT><FONT size=2>on the
Excel WorkMenu</FONT></DIV>
<DIV><FONT size=2> when I
click Insert|Object and appropiately select MetaStock Chart
?</FONT></DIV></FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>For the moment in Excel, until Equis comes up with a fix, do
not use this error-ing option since it is n.a.</FONT></DIV>
<DIV><FONT size=2>(not available), </FONT><FONT size=2>eg</FONT></DIV>
<DIV><FONT size=2>On disk there is either:</FONT></DIV>
<DIV>-the to be inserted Chart missing (the illigal operation)</DIV>
<DIV><FONT size=2>-a standard "</FONT><FONT size=2>MetaStock Chart"
template missing, or in the </FONT><FONT size=2>Windows Registry proper
</FONT><FONT size=2>Registry Keys/DWord/Values</FONT></DIV>
<DIV><FONT size=2> entries </FONT><FONT size=2>are plain
missing</FONT></DIV>
<DIV><FONT size=2>-instructions for the Operating System on how to handle this
call request are plain missing</FONT></DIV>
<DIV><FONT size=2>Since the other "Insert an Object" function's
options do succefully work, a fix for the MetaStock Installation
Cd</FONT></DIV>
<DIV><FONT size=2>will have to be awaited, before you can use this easy
+ marvelous option in Excel.</FONT></DIV>
<DIV><FONT size=2>Thus for the moment and i</FONT><FONT size=2>nstead use
{like is common in other Windows compatible programs} the </FONT><FONT
size=2>below mentioned</FONT></DIV>
<DIV><FONT size=2>"Paste from Clipboard Contents" </FONT><FONT
size=2>workaround.</DIV></FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Fastest workaround:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><STRONG>9a.- </STRONG>For getting a one time Picture of
Chart inserted only: {Paste Clipboard Contents}</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>In MSK</FONT></DIV>
<DIV><FONT size=2>-Hold Down the Alt key while 1x pressing the
PRINTSCREEN key</FONT></DIV>
<DIV><FONT size=2>switch to Excel</FONT></DIV>
<DIV><FONT size=2>In Excel</FONT></DIV>
<DIV><FONT size=2>-select the Cell</FONT></DIV>
<DIV><FONT size=2>-click Paste </FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT><FONT size=2><STRONG>9b.- </STRONG>For getting the
object's Chart dynamicaly OLE-linked</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>In MSK</FONT></DIV>
<DIV><FONT size=2>-right click the Base Security</FONT></DIV>
<DIV><FONT size=2>-click Copy (in the small Context Menu)</FONT></DIV>
<DIV><FONT size=2>switch to Excel</FONT></DIV>
<DIV><FONT size=2>In Excel</FONT></DIV>
<DIV><FONT size=2>-select column A</FONT></DIV>
<DIV><FONT size=2>-click Paste Special (in WorkMenu's Edit menu or right click
selected Column)</FONT></DIV>
<DIV><FONT size=2> In Paste Special Dialog
Window</FONT></DIV>
<DIV><FONT
size=2> -Check
the Paste Link radio button</DIV>
<DIV> -Select
CSV for Clipboard's contents type</DIV>
<DIV>
-click OK</DIV>
<DIV> </DIV>
<DIV><STRONG>9c.- </STRONG>For getting full OLE instructions</DIV>
<DIV> </DIV>
<DIV>See the previous OLE (part 1+2) and ASCII (Converting from MetaStock
to ASCII) instructions +</DIV>
<DIV>all other FAQ's (Q1 - Q8) on the "OLE-linking between MSK
and Excel" subject.</DIV>
<DIV> </DIV>
<DIV><FONT size=3> </FONT></FONT><BR>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss
the ".nospam" bit (including the dot) when replying.<BR>Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</DIV></A>
<DIV> </DIV>
<DIV><FONT size=2>cc <A
href="mailto:support@xxxxxxxxx";>support@xxxxxxxxx</A></FONT></DIV>
<DIV><FONT size=2> <A
href="mailto:suggestions@xxxxxxxxx";>suggestions@xxxxxxxxx</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><STRONG>From:
</STRONG>Adam Hefner </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> zondag 20 februari 2000
6:28</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Inserting Excel charts into
MetaStock problem......</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Below is a picture of the error I receive when
attempting to insert a metastock chart as an object.</FONT></DIV>
<DIV><FONT size=2>I am posting this for the Customer Support personal. It
would be nice to have this feature work.</FONT></DIV>
<DIV><FONT size=2>This problem happens every time I try the
"Insert/object/metastock chart" option.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Thanks, Adam Hefner</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sun Feb 20 14:50:37 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id PAA22523
for <neal@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:59:33 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id PAA07334
for metastock-outgoing; Sun, 20 Feb 2000 15:00:10 -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 PAA07326
for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:00:04 -0700
Received: from morpheus.skynet.be (morpheus.skynet.be [195.238.2.39])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id PAA29623
for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:14:12 -0700 (MST)
Received: from SKY40912 (dialup1462.antwerpen.skynet.be [194.78.226.182])
by morpheus.skynet.be (Postfix) with SMTP id D645FCDF1
for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 22:58:32 +0100 (MET)
Message-ID: <003301bf7bed$4fb08fa0$b6e24ec2@xxxxxxxxx>
From: "Theo E.M. Lockefeer" <sky40912@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <003a01bf7b69$9fcdf240$df0164cb@xxxxxxx>
Subject: Re: Modified Moving Average
Date: Sun, 20 Feb 2000 22:53:18 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0028_01BF7BF5.47B65980"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT color=#008080
face=Arial><STRONG><EM></EM></STRONG></FONT> </DIV>
<DIV><FONT color=#008080
face=Arial><STRONG><EM></EM></STRONG></FONT> </DIV>
<DIV><FONT color=#008080
face=Arial><STRONG><EM></EM></STRONG></FONT> </DIV>
<DIV><FONT color=#008080
face=Arial><STRONG><EM></EM></STRONG></FONT> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Jeff ; Ton; other interested
members (lionel?).</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: Jeff Ledermann <<A
href="mailto:j.ledermann@xxxxxxxxx";>j.ledermann@xxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: February 20, 2000 7:13 AM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: Modified Moving Average</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>> For those around here wondering what that
awful formula<BR>> was, </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Don't count me in on those
Jeff :) (I knew beforehand).</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>If you did read my mail
"sophisticated" you would</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>have read between the lines that
i wasnot that</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>happy about this horrible
monster i did create in</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>analogy to Linda R and
Co.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>but i still believe that i just
tried to implement this</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>concept in a
rational way on the multiple moving</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>averages from an article of
Linda R. and Co some time ago.</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>(one or the best i ever did read
on TASC).</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>so don't blame a formula newbie
on trying to accomplish</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>something
beyond...........</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>it's from the Jan 2000 TASC describing a form
of<BR>> weighted moving average.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> Here's a 20 period version I
like.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>And as far as my knowledge
reaches now</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>it's probably the ultimate
version too (Ton </EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>you should in here by now
too...:)..).</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>RTFM (sorry boys) page 217
:</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>A maximum of 20 (coincidence or
not Jeff ?or</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>don't i get it right again)
different numeric</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>constants (see pag 216) maybe
used in </EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>each
formula..........</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>so 50 looks impossible
(Metastock here</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>we go again) or is there some
enlighted wizard</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>out there who can work this
monster formula</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>out in a another
selfreferencing way :</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM> i am willing to pay
something for that.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>(BTW : look at page 216 for what
Metastock</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM> defines as a NUMERIC
CONSTANT.).</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>So Ton ( unbelievable what
this man is doing</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>for this group) : i did
run your version and</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>the message i got
was (should be no surprise by now)</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>........... Too many
constants</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>defined in formula
................ and that LOOKS Metastock-logical</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080
face=Arial><STRONG><EM>now..........</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Anyway
:</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Ton : thanks a lot as
always</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Jeff : also gratefull for
your contribution.</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Free (=no pay) Third party
solutions : welcome :)</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Regards
.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Theo
Lockefeer.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><BR>> ------------------<BR>> MMA-20<BR>>
{Modified Moving Average - TASC Jan 2000 by Joe Sharp} <BR>> n:=20;<BR>>
tn:=Mov(C,n,S);<BR>> s1:=((n-1)/2)*C + ((n-3)/2)*Ref(C,-1) +
((n-5)/2)*Ref(C,-2)<BR>> + ((n-7)/2)*Ref(C,-3) +
((n-9)/2)*Ref(C,-4)<BR>> + ((n-11)/2)*Ref(C,-5) +
((n-13)/2)*Ref(C,-6)<BR>> + ((n-15)/2)*Ref(C,-7) +
((n-17)/2)*Ref(C,-8)<BR>> + ((n-19)/2)*Ref(C,-9) +
((n-21)/2)*Ref(C,-10)<BR>> + ((n-23)/2)*Ref(C,-11) +
((n-25)/2)*Ref(C,-12)<BR>> + ((n-27)/2)*Ref(C,-13) +
((n-29)/2)*Ref(C,-14)<BR>> + ((n-31)/2)*Ref(C,-15) +
((n-33)/2)*Ref(C,-16)<BR>> + ((n-35)/2)*Ref(C,-17) +
((n-37)/2)*Ref(C,-18)<BR>> + ((n-39)/2)*Ref(C,-19);<BR>>
tn+(6*s1)/((n+1)*n);<BR>> --------------------<BR>> <BR>> Plotted
against a 20 EMA it's immediately obvious that it has<BR>> much the same
characteristics as its namesake, Guppy MMA.<BR>> Maybe this isn't so
surprising since in both cases we're<BR>> effectively comparing longer
against shorter term MAs.<BR>> <BR>> Have a look at the attached March
Soybeans and check out the<BR>> inflection points in the Guppy MMA with the
MMA-20 separation<BR>> from the EMA. I think it's giving a clearer
signal. You may have<BR>> been tempted to go long in late Sep based on
the Guppy MMA<BR>> but the MMA-20 was still pointing hard down and didn't
turn up<BR>> until the second (higher) low in early Oct. <BR>>
<BR>> I think current action resembles late August - triangle
measurement<BR>> gives target near 541.<BR>> <BR>> Cheers<BR>>
Jeff.</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Sun Feb 20 14:50:35 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id PAA22450
for <neal@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:57:20 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id PAA07337
for metastock-outgoing; Sun, 20 Feb 2000 15:00:11 -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 PAA07330
for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:00:05 -0700
Received: from morpheus.skynet.be (morpheus.skynet.be [195.238.2.39])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id PAA29624
for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 15:14:12 -0700 (MST)
Received: from SKY40912 (dialup1462.antwerpen.skynet.be [194.78.226.182])
by morpheus.skynet.be (Postfix) with SMTP id 0DA05CE32
for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 22:58:39 +0100 (MET)
Message-ID: <003401bf7bed$5175bf40$b6e24ec2@xxxxxxxxx>
From: "Theo E.M. Lockefeer" <sky40912@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <NDBBJOIGGPNPKGOJDLLPEEDCCAAA.smcdonal2@xxxxxxxxxxx>
Subject: Re: rsi in excel
Date: Sun, 20 Feb 2000 22:55:15 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0030_01BF7BF5.8D486880"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Just copy the data in the
downloader and</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>paste in
excel..............</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Theo
Lockefeer</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: Stephen McDonald <<A
href="mailto:smcdonal2@xxxxxxxxxxx";>smcdonal2@xxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: February 20, 2000 9:14 AM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: RE: rsi in excel</FONT></DIV></DIV>
<DIV><BR></DIV><FONT face=Arial size=2>> If you get a reply please forward to
me. I am also trying to import<BR>> metastock data into Execl.<BR>>
<BR>> Thanks<BR>> <BR>> Steve<BR>> <BR>> -----Original
Message-----<BR>> From: <A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx</A><BR>>
[<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>mailto:owner-metastock@xxxxxxxxxxxxx</A>]On
Behalf Of Michael Gilbert<BR>> Sent: Sunday, 20 February 2000 12:48
PM<BR>> To: <A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A><BR>>
Subject: rsi in excel<BR>> <BR>> <BR>> Anyone care to show me how to
set up an excel spread sheet that can import<BR>> metastock data and
calculate<BR>> rsi with varying periods. I am attempting to create a what-if?
spread sheet<BR>> where I can calculate what close<BR>> would be needed to
equal a certain rsi value.<BR>> thank you<BR>> <BR>>
</FONT></BODY></HTML>
</x-html>From ???@??? Sun Feb 20 18:29:15 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id TAA00945
for <neal@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 19:44:10 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA09394
for metastock-outgoing; Sun, 20 Feb 2000 17:34:02 -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 RAA09384
for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 20 Feb 2000 17:33:56 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA29734
for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 17:48:03 -0700 (MST)
Received: from escom ([195.121.220.47]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAA6191;
Mon, 21 Feb 2000 01:31:56 +0100
Message-ID: <051901bf7c03$7d7f3ce0$56da79c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Metastock-List" <metastock@xxxxxxxxxxxxx>, <vonhef@xxxxxxxxxxxx>
Cc: <support@xxxxxxxxx>, <suggestions@xxxxxxxxx>
Subject: Re: Inserting Excel charts into MetaStock problem......
Date: Mon, 21 Feb 2000 00:27:16 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_NextPart_000_01E1_01BF7C02.6804FF40";
type="multipart/alternative"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.3825.400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.3825.400
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>The previous send mail had an error in section <STRONG>9b.
</STRONG>and as such DELETE the old mail.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Below have printed the corrected parts in RED.</FONT></DIV>
<DIV> </DIV>
<DIV>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the
".nospam" bit (including the dot) when replying.<BR>Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
A.J. Maas
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>Metastock-List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=support@xxxxxxxxx
href="mailto:support@xxxxxxxxx";>support@xxxxxxxxx</A> ; <A
title=suggestions@xxxxxxxxx
href="mailto:suggestions@xxxxxxxxx";>suggestions@xxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> zondag 20 februari 2000 14:00</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Inserting Excel charts into
MetaStock problem......</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>-ehh the Subject should have read:</FONT></DIV>
<DIV><FONT size=2> Inserting MetaStock charts into Excel being a
MetaStock problem...........</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-below is for adding to the Instructions+FAQ collection
</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><FONT size=2>
<DIV><FONT size=2><STRONG>OLE between MSK+Excel (+v.v.)
- FAQ's </STRONG>{where MetaStock has other programs
returning errors}</FONT></DIV>
<DIV><FONT
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><STRONG>Q9. </STRONG></FONT><FONT
color=#000000>Why, in Excel, do I get errors when using Excel's "Insert an
Object" function, eg </FONT></FONT><FONT size=2>on the
Excel WorkMenu</FONT></DIV>
<DIV><FONT size=2> when I
click Insert|Object and appropiately select MetaStock Chart
?</FONT></DIV></FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>For the moment in Excel, until Equis comes up with a fix, do
not use this error-ing option since it is n.a.</FONT></DIV>
<DIV><FONT size=2>(not available), </FONT><FONT size=2>eg</FONT></DIV>
<DIV><FONT size=2>On disk there is either:</FONT></DIV>
<DIV>-the to be inserted Chart missing (the illigal operation)</DIV>
<DIV><FONT size=2>-a standard "</FONT><FONT size=2>MetaStock Chart"
template missing, or in the </FONT><FONT size=2>Windows Registry proper
</FONT><FONT size=2>Registry Keys/DWord/Values</FONT></DIV>
<DIV><FONT size=2> entries </FONT><FONT size=2>are plain
missing</FONT></DIV>
<DIV><FONT size=2>-instructions for the Operating System on how to handle this
call request are plain missing</FONT></DIV>
<DIV><FONT size=2>Since the other "Insert an Object" function's
options do succefully work, a fix for the MetaStock Installation
Cd</FONT></DIV>
<DIV><FONT size=2>will have to be awaited, before you can use this easy
+ marvelous option in Excel.</FONT></DIV>
<DIV><FONT size=2>Thus for the moment and i</FONT><FONT size=2>nstead use
{like is common in other Windows compatible programs} the </FONT><FONT
size=2>below mentioned</FONT></DIV>
<DIV><FONT size=2>"Paste from Clipboard Contents" </FONT><FONT
size=2>workaround.</DIV></FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Fastest workaround:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><STRONG>9a.- </STRONG>For getting a one time Picture of
Chart inserted only: {Paste Clipboard Contents}</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>In MSK</FONT></DIV>
<DIV><FONT size=2>-Hold Down the Alt key while 1x pressing the
PRINTSCREEN key</FONT></DIV>
<DIV><FONT size=2>switch to Excel</FONT></DIV>
<DIV><FONT size=2>In Excel</FONT></DIV>
<DIV><FONT size=2>-select the Cell</FONT></DIV>
<DIV><FONT size=2>-click Paste </FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT><FONT size=2><STRONG>9b.- </STRONG>For getting the
object's Chart dynamicaly OLE-linked</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>In MSK</FONT></DIV>
<DIV><FONT size=2>-right click the Base Security</FONT></DIV>
<DIV><FONT size=2>-click Copy (in the small Context Menu)</FONT></DIV>
<DIV><FONT size=2>switch to Excel</FONT></DIV>
<DIV><FONT size=2>In Excel</FONT></DIV>
<DIV><FONT size=2>-select column A <FONT color=#ff0000>or Cell
A1</FONT></FONT></DIV>
<DIV><FONT size=2>-click Paste Special (in WorkMenu's Edit menu or right click
selected Column <FONT color=#ff0000>or Cell A1</FONT>)</FONT></DIV>
<DIV><FONT size=2> In Paste Special Dialog
Window</FONT></DIV>
<DIV><FONT
size=2> -Check
the Paste Link radio button</DIV>
<DIV> -Select
<FONT color=#ff0000>MetaStock Chart-Object </FONT>for Clipboard's contents
type</DIV>
<DIV>
-click OK</DIV>
<DIV><FONT color=#ff0000>-see 9.c for further
Steps (Saving,Updating,Maintnance)
</FONT></DIV>
<DIV> </DIV>
<DIV><STRONG>9c.- </STRONG>For getting full OLE instructions</DIV>
<DIV> </DIV>
<DIV>See the previous OLE (part 1+2) and ASCII (Converting from MetaStock
to ASCII) instructions +</DIV>
<DIV>all other FAQ's (Q1 - Q<FONT color=#ff0000>10</FONT>) on
the "OLE-linking between MSK and Excel" subject.</DIV>
<DIV> </DIV>
<DIV><FONT size=3> </FONT></FONT><BR>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss
the ".nospam" bit (including the dot) when replying.<BR>Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</DIV></A>
<DIV> </DIV>
<DIV><FONT size=2>cc <A
href="mailto:support@xxxxxxxxx";>support@xxxxxxxxx</A></FONT></DIV>
<DIV><FONT size=2> <A
href="mailto:suggestions@xxxxxxxxx";>suggestions@xxxxxxxxx</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><STRONG>From:
</STRONG>Adam Hefner </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> zondag 20 februari 2000
6:28</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Inserting Excel charts into
MetaStock problem......</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Below is a picture of the error I receive when
attempting to insert a metastock chart as an object.</FONT></DIV>
<DIV><FONT size=2>I am posting this for the Customer Support personal. It
would be nice to have this feature work.</FONT></DIV>
<DIV><FONT size=2>This problem happens every time I try the
"Insert/object/metastock chart" option.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Thanks, Adam Hefner</FONT></DIV>
<DIV> </DIV>
<DIV><IMG alt="" hspace=0 src="cid:01e001bf7bfa$060fc340$56da79c3@xxxxx";
align=baseline border=0></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\fault2.gif"
|