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 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 </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> </DIV>
<DIV><FONT face="Times New Roman" size=3></FONT> </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: <</FONT><A
href="mailto:metastock@xxxxxxxxxxxxx"><FONT face="Times New Roman"
size=3>metastock@xxxxxxxxxxxxx</FONT></A><FONT face="Times New Roman"
size=3>></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>> I know that this has been discussed before but ...<BR>> <BR>>
I have MS Pro 6.2 (have only used it for EOD analysis so far) and can<BR>>
receive real time data through MS Excel (via VBA app written to
translate<BR>> Datek Streamer feed through QuoteTracker - alot of work, but
it's free!).<BR>> <BR>> How can I get the data from Excel into
Metastock?<BR>> <BR>> Thanks in advance,<BR>> Peter
Gialames<BR></FONT></DIV>
<DIV style="FONT: 10pt arial"> </DIV>
<DIV style="FONT: 10pt arial"> </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 & Metastock - Using Calcs From
Metastock</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>
<DIV><FONT size=3><STRONG>OLE-ing between Excel 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 --> Excel</FONT></DIV>
<DIV> Part 2 =
Excel --> MetaStock}</DIV>
<DIV><FONT
size=2>-----------------------------------------------------------</FONT></DIV>
<DIV> </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> -RightClick for Small Context
Menu</FONT></DIV>
<DIV><FONT size=2> -Click Stack Windows
Horizontaly</FONT></DIV>
<DIV><FONT size=2>-In Excel window </FONT></DIV>
<DIV> -Give your moulded data in column D a proper
heading, eg for the now to be Linked object's Indicator Name</DIV>
<DIV> -In cell D1
type: "MyIndicator" {without the quotations}</DIV>
<DIV> -Down the rest of Column D, have all the
corresponding Closes {read: your indicator's moulded values}</DIV>
<DIV> -Select 1000 cells/column in column D,
eg down Select this amount of Cells in 1 single move, starting with
Cell D1.</DIV>
<DIV> (Note here that the
DATA in column D should also match up with your original DATA, eg
especialy exactly</DIV>
<DIV> match
the 'corresponding' DATEvalues in column A, eg see the Cells and
Columns build up in the previous</DIV>
<DIV> "OLE-ing
between MetaStock and Excel (part 1)"-mail.</DIV>
<DIV> {Since that you want a
reliable indicator Linked, than any mismatch in the
DATEvalues present between</DIV>
<DIV> your BASE-security(see
MSK-manual) and your own
-now Linked- "MyIndicator" will, at its
worst, give</DIV>
<DIV> a mutulated
"non-corresponding" representation of all of the indicators
in your Charts/Smart Charts/Layouts,</DIV>
<DIV> and thus also
giving incorrect values for any
of your "Analysis"}</DIV></DIV>
<DIV> -<FONT size=2>Move mouse pointer over your (black)
selection</FONT></DIV>
<DIV> -<FONT size=2>RightClick for Small Context
Menu</FONT></DIV>
<DIV><FONT size=2> -Click Copy</FONT></DIV>
<DIV><FONT size=2>-In MSK window</FONT></DIV>
<DIV> -Open a Security, as a Chart/Smart
Chart/Layout</DIV>
<DIV> -On the WorkMenu</DIV>
<DIV> -Click
Window</DIV>
<DIV>
-Click New Inner Window</DIV>
<DIV> -In the New
Inner Window</DIV>
<DIV>
-<FONT size=2>RightClick for Small Context Menu</FONT></DIV>
<DIV>
-Click Paste Special
<DIV><FONT size=2>
-In Paste Special Dialog Window</FONT></DIV></DIV>
<DIV>
-Check the Link radio button</DIV>
<DIV>
-Select Csv for security or indicator as the Clipboards contents</DIV>
<DIV>
-Click OK</DIV>
<DIV>-Save As your MSK results as a Chart/Smart Chart/Layout</DIV>
<DIV> </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 <A
href="http://home.planet.nl/~anthmaas">http://home.planet.nl/~anthmaas</A></FONT></DIV></DIV>
<DIV> </DIV>
<DIV> </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 & 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> </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 ???@??? 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.
|