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

Fw: Excel & Metastock - Using Calcs From Metastock



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=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>
<DIV>Some later send FAQ's were also&nbsp;related to subject</DIV>
<DIV><BR><FONT size=3>Regards,<BR>Ton Maas<BR></FONT><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT 
size=3>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=3>Dismiss the ".nospam" 
bit (including the dot) when replying.<BR>Homepage&nbsp; </FONT><A 
href="http://home.planet.nl/~anthmaas";><FONT 
size=3>http://home.planet.nl/~anthmaas</FONT></A></DIV>
<DIV><FONT face="Times New Roman" size=3></FONT>&nbsp;</DIV>
<DIV><FONT face="Times New Roman" size=3></FONT>&nbsp;</DIV>
<DIV><FONT face="Times New Roman" size=3>----- Original Message ----- </FONT>
<DIV><FONT face="Times New Roman" size=3>From: "Peter E. Gialames" </FONT></DIV>
<DIV><FONT face="Times New Roman" size=3>To: &lt;</FONT><A 
href="mailto:metastock@xxxxxxxxxxxxx";><FONT face="Times New Roman" 
size=3>metastock@xxxxxxxxxxxxx</FONT></A><FONT face="Times New Roman" 
size=3>&gt;</FONT></DIV>
<DIV><FONT face="Times New Roman" size=3>Sent: woensdag 19 april 2000 
23:10</FONT></DIV>
<DIV><FONT face="Times New Roman" size=3>Subject: Real Time Data from 
Excel</FONT></DIV></DIV>
<DIV><FONT size=3><BR><FONT 
face="Times New Roman"></FONT></FONT></DIV></FONT><FONT face="Times New Roman" 
size=3>&gt; I know that this has been discussed before but ...<BR>&gt; <BR>&gt; 
I have MS Pro 6.2 (have only used it for EOD analysis so far) and can<BR>&gt; 
receive real time data through MS Excel (via VBA app written to 
translate<BR>&gt; Datek Streamer feed through QuoteTracker - alot of work, but 
it's free!).<BR>&gt; <BR>&gt; How can I get the data from Excel into 
Metastock?<BR>&gt; <BR>&gt; Thanks in advance,<BR>&gt; Peter 
Gialames<BR></FONT></DIV>
<DIV style="FONT: 10pt arial">&nbsp;</DIV>
<DIV style="FONT: 10pt arial">&nbsp;</DIV>
<DIV style="FONT: 10pt arial">----- Original Message ----- 
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> A.J. Maas 
</DIV>
<DIV><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
href="mailto:metastock@xxxxxxxxxxxxx";>Metastock-List</A> </DIV>
<DIV><B>Sent:</B> dinsdag 1 februari 2000 2:13</DIV>
<DIV><B>Subject:</B> Re: Excel &amp; Metastock - Using Calcs From 
Metastock</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>
<DIV><FONT size=3><STRONG>OLE-ing between Excel&nbsp;and MetaStock (part 
2):</STRONG></FONT></DIV>
<DIV><FONT size=2>{am still supprised Equis hasn't given these proper 
OLE-instructions to users via their website}</FONT></DIV>
<DIV><FONT size=2>{note: Part 1 = MetaStock --&gt;&nbsp;Excel</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Part 2 = 
Excel&nbsp;--&gt;&nbsp;MetaStock}</DIV>
<DIV><FONT 
size=2>-----------------------------------------------------------</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2></FONT><FONT size=2>-Open Excel+MSK</FONT></DIV>
<DIV>
<DIV><FONT size=2>-Move mouse pointer over the Windows TaskBar's 
Clock</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -RightClick&nbsp;for Small Context 
Menu</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Click Stack Windows 
Horizontaly</FONT></DIV>
<DIV><FONT size=2>-In Excel window </FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -Give your moulded data&nbsp;in column D a proper 
heading, eg for the now to be Linked object's&nbsp;Indicator Name</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -In cell D1 
type:&nbsp;"MyIndicator" {without the quotations}</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -Down&nbsp;the rest of Column D, have all the 
corresponding Closes {read:&nbsp;your indicator's moulded values}</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -Select&nbsp;1000 cells/column in&nbsp;column D, 
eg down Select this&nbsp;amount of Cells&nbsp;in 1 single move, starting with 
Cell D1.</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;(Note here that&nbsp;the 
DATA in column D&nbsp;should&nbsp;also&nbsp;match up with your original DATA, eg 
especialy exactly</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;match 
the&nbsp;'corresponding' DATEvalues in column A, eg&nbsp;see the&nbsp;Cells and 
Columns build up&nbsp;in the previous</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"OLE-ing 
between&nbsp;MetaStock and Excel (part 1)"-mail.</DIV>
<DIV>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{Since that you want a 
reliable&nbsp;indicator Linked, than any mismatch in&nbsp;the 
DATEvalues&nbsp;present between</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;your BASE-security(see 
MSK-manual) and&nbsp;your&nbsp;own&nbsp; 
-now&nbsp;Linked-&nbsp;&nbsp;&nbsp;"MyIndicator"&nbsp; will, at its 
worst,&nbsp;give</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a mutulated 
"non-corresponding" representation of&nbsp;all of the&nbsp;indicators 
in&nbsp;your Charts/Smart Charts/Layouts,</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;and&nbsp;thus also 
giving&nbsp;incorrect values&nbsp;for&nbsp;any 
of&nbsp;your&nbsp;"Analysis"}</DIV></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -<FONT size=2>Move mouse pointer over your (black) 
selection</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -<FONT size=2>RightClick for Small Context 
Menu</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Click Copy</FONT></DIV>
<DIV><FONT size=2>-In MSK window</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -Open a Security, as a Chart/Smart 
Chart/Layout</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; -On the WorkMenu</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Click 
Window</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Click New Inner Window</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; -In&nbsp;the New 
Inner Window</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; 
-<FONT size=2>RightClick for Small Context Menu</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Click Paste Special 
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-In Paste Special Dialog Window</FONT></DIV></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Check the&nbsp;Link&nbsp;radio button</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Select Csv for security or indicator as the Clipboards contents</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Click OK</DIV>
<DIV>-Save As&nbsp;your MSK results as a Chart/Smart Chart/Layout</DIV>
<DIV>&nbsp;</DIV></FONT></DIV>
<DIV>
<DIV><FONT size=3>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</A></FONT></DIV></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE 
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> 
  Kornberg Family </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>Sent:</B> zaterdag 29 januari 2000 
23:49</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Excel &amp; Metastock - Using 
  Calcs From Metastock</DIV>
  <DIV><BR></DIV>
  <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>&nbsp;</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?&nbsp; 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.&nbsp; 
  Currently for me to calculate an ATR in Excel, I use a spreadsheet, I need to 
  bring in dates from Metastock.&nbsp; Otherwise,&nbsp;I open both programs, and 
  then insert the value from Metastock.&nbsp;&nbsp;This can be 
  fiddly.</SPAN></FONT></DIV>
  <DIV><FONT face=Arial size=2><SPAN 
  class=430234222-29012000></SPAN></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2><SPAN 
  class=430234222-29012000>Andrew</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Apr 20 13:36:41 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 NAA32601
	for <neal@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 13:34:50 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id NAA18206
	for metastock-outgoing; Thu, 20 Apr 2000 13:58:37 -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 NAA18203
	for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 20 Apr 2000 13:58:34 -0600
Received: from hme0.mailrouter03.sprint.ca ([207.107.250.37])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id OAA11094
	for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 14:11:06 -0600 (MDT)
Received: from default (spc-isp-ott-uas-31-33.sprint.ca [209.148.163.184])
	by hme0.mailrouter03.sprint.ca (8.8.8/8.8.8) with SMTP id PAA00355
	for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 15:53:02 -0400 (EDT)
Message-ID: <000c01bfab02$1285b4e0$b8a394d1@xxxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <001601bfaa4f$da950200$786fa8c0@xxxxx> <000e01bfaa67$8b26ea40$c931bccc@xxxxxxx> <001e01bfaacc$9c3da840$d92467d1@xxxxxxx> <004a01bfaaeb$27adc7c0$b431bccc@xxxxxxx>
Subject: Re: KW0K/KW0N
Date: Thu, 20 Apr 2000 15:53:15 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

Hi Steve

WxH/CxH comes later on into August and September, etc.

You like the early part of the spread?

Best regards

Walter

----- Original Message -----
From: "Steve Karnish" <kernish@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, April 20, 2000 1:09 PM
Subject: Re: KW0K/KW0N


| Walter,
|
| I way too much of an idiot to figure out the internal goals of the
| commercials.  I could guess about what "flat price volume" is, but quite
| frankly it would be pure, dare I say: "speculation".  "Fun-DAH-mental-ly"
I
| have the knowledge of a third grader (and some 8 year olds, born into farm
| families, probably have a better understanding).  I guess this is all easy
| to rationalize by saying that all fundamentals end up in the price.  I've
| traded stocks for years by the "symbols" and couldn't even tell you what
| many of the companies do to create revenue.  Give me the price history and
| I'll render an opinion.  Over the years, "thinking"
| has gotten me into a lot of trouble.  So, sorry I can't answer your
| question.  You still haven't told me:  what do you think of long wheat,
| short corn.  I currently have my largest spread position in twenty five
| years.  Am I going to have to slap Dick Gephardt around to make sure that
| China gets favored trade status.  I understand that the largest wheat
| growing area in China is currently at 9% of normal measurable
precipitation.
| Any thoughts are welcome.
|
| Take care,
|
| Steve Karnish
| Cedar Creek Trading
| http://www.cedarcreektrading.com
| ----- Original Message -----
| From: Walter Lake <wlake@xxxxxxxxx>
| To: <metastock@xxxxxxxxxxxxx>
| Sent: Thursday, April 20, 2000 6:30 AM
| Subject: KW0K/KW0N
|
|
| > Hi Steve
| >
| > In the KC wheat markets, I know that most of the spread activity is in
| > rolling May positions into July.