[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Is it possible to transfer the daily value of an Indicator to Excel ?



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.)&nbsp; 
-&nbsp;&nbsp;FAQ's</STRONG></FONT></DIV>
<DIV><FONT 
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV>&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </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>&nbsp;</DIV>
<DIV><FONT size=2><STRONG>All are <U>indicators</U></STRONG> 
<STRONG>(price+MACD)&nbsp;and thus are Objects and&nbsp;thus can&nbsp;be 
OLE-ed.</STRONG></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT 
size=2>MSK-Indicator&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Contents</FONT></DIV>
<DIV><FONT 
size=2>----------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-------------</FONT></DIV>
<DIV><FONT 
size=2>BASESecurity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
(</FONT><FONT size=2>O+H+L+C+V+I/0)</FONT></DIV>
<DIV><FONT 
size=2>PRICE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;({just 
create a custom}&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
(RSIclose)</FONT></DIV>
<DIV><FONT 
size=2>MACD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(MACDclose)</FONT></DIV>
<DIV><FONT size=2>"myCUSTOM"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (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>&nbsp;</DIV>
<DIV><FONT size=2>-the Dates will automaticaly come with your OLE-link (when 
OLE-ing from MSK to Excel)&nbsp;</FONT></DIV>
<DIV><FONT size=2>-depending on your (in Excel) pre-upfront&nbsp;Columns 
selection, eg in Excel&nbsp;select Col A+B+C+D+F+G,</FONT></DIV>
<DIV><FONT size=2>&nbsp;than when&nbsp;(from MSK) to Paste Special to 
(Excel),&nbsp;</FONT><FONT size=2>the 'other' BASEsecurity's&nbsp;Values (for 
example</FONT></DIV>
<DIV><FONT size=2>&nbsp;the O+H+L+V+O/I) will&nbsp;come&nbsp;with the link 
too</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</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&nbsp;and Excel (part 1):</DIV></STRONG></FONT>
<DIV><FONT face="Times New Roman" 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
{note: Part 1 = MetaStock --&gt;&nbsp;Excel</FONT></DIV>
<DIV><FONT 
face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Part 2 = Excel&nbsp; --&gt; 
MetaStock)</FONT></DIV>
<DIV><FONT face="Times New Roman" size=3><STRONG>-FAQ</STRONG></FONT><FONT 
face="Times New Roman" size=3><STRONG>'s&nbsp;1 to 13&nbsp;on the OLE (between 
MSK/EXCEL) subject.</DIV></STRONG></FONT>
<DIV><FONT 
face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</DIV></A>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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