PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2><FONT size=2>
<DIV><FONT size=2><STRONG>OLE between MSK+Excel (+v.v.)
- FAQ's</STRONG></FONT></DIV>
<DIV><FONT
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><STRONG>Q14. </STRONG><FONT
color=#000000>Is it possible to transfer the daily value of an Indicator to
Excel ? </FONT><FONT face=Arial color=#000000 size=2>We know that it's possible
to transfer</FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial color=#000000
size=2> the daily <STRONG>price
</STRONG>value (O,H,L,C) </FONT><FONT face=Arial color=#000000 size=2>to
Excel.</FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT
color=#000000> </FONT><FONT face=Arial
color=#000000 size=2>Is it also possible to transfer the daily value of an
<STRONG>indicator </STRONG>(like MACD etc) </FONT><FONT face=Arial color=#000000
size=2>to Excel ?</DIV></FONT></FONT></FONT></FONT></FONT><FONT
size=2></DIV></FONT>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><STRONG>All are <U>indicators</U></STRONG>
<STRONG>(price+MACD) and thus are Objects and thus can be
OLE-ed.</STRONG></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT
size=2>MSK-Indicator
Contents</FONT></DIV>
<DIV><FONT
size=2>----------------------
-------------</FONT></DIV>
<DIV><FONT
size=2>BASESecurity
(</FONT><FONT size=2>O+H+L+C+V+I/0)</FONT></DIV>
<DIV><FONT
size=2>PRICE ({just
create a custom} </FONT><FONT size=2>O or H or L or C or V or O/I {eg C for
CLOSE Only})</FONT></DIV>
<DIV><FONT
size=2>RSI
(RSIclose)</FONT></DIV>
<DIV><FONT
size=2>MACD (MACDclose)</FONT></DIV>
<DIV><FONT size=2>"myCUSTOM"
(yourCUSTOMformulaclose)</FONT></DIV>
<DIV><FONT size=2>thus the works...........</FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-the Dates will automaticaly come with your OLE-link (when
OLE-ing from MSK to Excel) </FONT></DIV>
<DIV><FONT size=2>-depending on your (in Excel) pre-upfront Columns
selection, eg in Excel select Col A+B+C+D+F+G,</FONT></DIV>
<DIV><FONT size=2> than when (from MSK) to Paste Special to
(Excel), </FONT><FONT size=2>the 'other' BASEsecurity's Values (for
example</FONT></DIV>
<DIV><FONT size=2> the O+H+L+V+O/I) will come with the link
too</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><FONT face="Times New Roman"><STRONG><FONT
size=3>For more info, see:</FONT></STRONG></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><STRONG><FONT face="Times New Roman" size=3>-Part
1+2 : </FONT></STRONG><FONT face="Times New Roman" size=3><STRONG>OLE-ing
between MetaStock and Excel (part 1):</DIV></STRONG></FONT>
<DIV><FONT face="Times New Roman"
size=2>
{note: Part 1 = MetaStock --> Excel</FONT></DIV>
<DIV><FONT
face="Times New Roman">
Part 2 = Excel -->
MetaStock)</FONT></DIV>
<DIV><FONT face="Times New Roman" size=3><STRONG>-FAQ</STRONG></FONT><FONT
face="Times New Roman" size=3><STRONG>'s 1 to 13 on the OLE (between
MSK/EXCEL) subject.</DIV></STRONG></FONT>
<DIV><FONT
face="Times New Roman"> </FONT></FONT></FONT><FONT
size=2></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> </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>
Theo E.M. Lockefeer </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx">Metastock User Group</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> vrijdag 21 april 2000 19:53</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Is it possible to transfer the
daily value of an Indicator to Excel ?</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Ton and List :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>We know it's possible to transfer the daily price
value (O,H,L,C)</FONT></DIV>
<DIV><FONT face=Arial size=2>to Excel. (Thx Ton).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Is it also possible to transfer the daily value
of an indicator (like MACD etc)</FONT></DIV>
<DIV><FONT face=Arial size=2>to Excel ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>This would be very usefull for me since i want to
know the difference</FONT></DIV>
<DIV><FONT face=Arial size=2>of the daily indicator values to measure the
strenght of the signal.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TheoL.</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Apr 22 06:08:38 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 FAA04677
for <neal@xxxxxxxxxxxxx>; Sat, 22 Apr 2000 05:21:51 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id FAA32217
for metastock-outgoing; Sat, 22 Apr 2000 05:58:43 -0600
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 FAA32214
for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 22 Apr 2000 05:58:40 -0600
Received: from hotmail.com (f283.law3.hotmail.com [209.185.240.62])
by freeze.metastock.com (8.8.5/8.8.5) with SMTP id GAA12366
for <metastock@xxxxxxxxxxxxx>; Sat, 22 Apr 2000 06:11:23 -0600 (MDT)
Received: (qmail 49580 invoked by uid 0); 22 Apr 2000 11:54:38 -0000
Message-ID: <20000422115438.49579.qmail@xxxxxxxxxxx>
Received: from 208.51.121.3 by www.hotmail.com with HTTP;
Sat, 22 Apr 2000 04:54:38 PDT
X-Originating-IP: [208.51.121.3]
From: "d jameson" <magnatizer@xxxxxxxxxxx>
To: metastock@xxxxxxxxxxxxx
Subject: COT
Date: Sat, 22 Apr 2000 11:54:38 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
First I must say I did not follow the entire discussion on COT before I
removed the emails from my directory. This site may have already come up
but I just ran across it and thought it may aid in the discussion.
http://www.fyii.net/cgi-local/chartgen.pl?cp.m
ht
Mag
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
|