|
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.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG>OLE-ing between MetaStock and Excel :</STRONG></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>-----------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-Open DL</FONT></DIV>
<DIV><FONT size=2> -Create a duplicate file of your
stock</FONT></DIV>
<DIV><FONT size=2> -(always) Delete data older than say
3 years (eg use max 750 periods)</FONT></DIV>
<DIV><FONT size=2>-Open MSK</FONT></DIV>
<DIV><FONT size=2> -Create a Chart for that stock (thus not a
Smart Chart/Layout), eg </FONT></DIV>
<DIV><FONT size=2> -Open
a Chart loading max 750 periods</FONT></DIV>
<DIV><FONT size=2>
-Create the ATR for that stock</FONT></DIV>
<DIV><FONT size=2> -Save (not Close) the Chart, eg using the
.mwc extension</FONT></DIV>
<DIV><FONT size=2>-Open Excel</FONT></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 MSK window</FONT></DIV>
<DIV><FONT size=2> -Select the ATR</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 Excel window</FONT></DIV>
<DIV><FONT size=2> </FONT><FONT size=2>-In column A
only, down Select in 1 single move say 1000 cells/column</FONT></DIV>
<DIV><FONT
size=2> {750
history+250future=the above mentioned 1000periods, eg you can use it
for</FONT></DIV>
<DIV><FONT size=2>
another </FONT><FONT size=2>1 full year</FONT><FONT
size=2> before you MUST </FONT><FONT size=2>Delete the oldest 250 periods
in your DL file}</FONT></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 Paste Special</FONT></DIV>
<DIV><FONT size=2>
-In Paste Special Dialog Window</FONT></DIV>
<DIV><FONT
size=2> -Check
the Paste Link radio button</FONT></DIV>
<DIV><FONT
size=2> -Select
CSV for Clipboard's contents type</FONT> </DIV>
<DIV><FONT size=2> -In column B and C "unfold" the
OLE-ed data into usable data, eg</FONT></DIV>
<DIV><FONT
size=2> -Type
in Cell B2</FONT></DIV>
<DIV><FONT
size=2>
=DIVIDE(T(A2);1;8)</FONT></DIV>
<DIV><FONT
size=2> -Type
in Cell C2</FONT></DIV>
<DIV><FONT
size=2>
=DIVIDE(T(A2);10;24)</FONT></DIV>
<DIV><FONT
size=2>
{Depending on language, this DIVIDE can also be SPLIT or DEEL or.....etc.
etc.}</FONT></DIV>
<DIV><FONT size=2>-F<FONT size=2>or filling the rest of the date B and data C
columns</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2> -In the rectangled
selected B2 cell, click the small black handle at bottom
right</FONT></FONT></DIV>
<DIV><FONT
size=2> -Make
it a solid click, and it will fill out the rest of the column {if cells on
the left contain any content}</FONT></DIV>
<DIV><FONT
size=2> -Click+Hold
Down left mouse button + drag down, and it will fill out untill you release
mouse-button</FONT></DIV>
<DIV> </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
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 href="mailto:kornberg@xxxxxxxxxxxxxxx";
title=kornberg@xxxxxxxxxxxxxxx>Kornberg Family</A> </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>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 ???@??? Sat Jan 29 20:59:16 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id VAA12523
for <neal@xxxxxxxxxxxxx>; Sat, 29 Jan 2000 21:32:47 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id UAA13411
for metastock-outgoing; Sat, 29 Jan 2000 20:50:28 -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 UAA13408
for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 29 Jan 2000 20:50:26 -0700
From: Wooglinx@xxxxxxx
Received: from imo19.mx.aol.com (imo19.mx.aol.com [152.163.225.9])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id VAA12591
for <metastock@xxxxxxxxxxxxx>; Sat, 29 Jan 2000 21:02:34 -0700 (MST)
Received: from Wooglinx@xxxxxxx
by imo19.mx.aol.com (mail_out_v24.8.) id u.c9.829910 (7543)
for <metastock@xxxxxxxxxxxxx>; Sat, 29 Jan 2000 22:46:46 -0500 (EST)
Message-ID: <c9.829910.25c50e26@xxxxxxx>
Date: Sat, 29 Jan 2000 22:46:46 EST
Subject: Re: Excel & Metastock - Using Calcs From Metastock
To: metastock@xxxxxxxxxxxxx
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: AOL 4.0 for Windows 95 sub 14
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
A.J.:
This is another example of your excellent contributions to this list. You've
taken a procedure which is difficult to understand and made it simple for all
to understand.
Could you take it one step further? That is, take data elements from the
price chart (O, H, L, or C), OLE into Excel, massage the data in Excel and
then OLE the resulting data back into MetaStock for display as a chart.
Any help would be appreciated.
Thanks,
Jim Barone
|