|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>Yes indeed. Thankyou Ton, Guy, and Walter
for discussion providing many of us readers a jump-start in Excel.</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT size=2>Chuck</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Johan Labuschagne <<A
href="mailto:johan@xxxxxxxxxxx";>johan@xxxxxxxxxxx</A>><BR><B>To: </B><A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Cc:
</B>anthmaas@xxxxxx <<A
href="mailto:anthmaas@xxxxxx";>anthmaas@xxxxxx</A>><BR><B>Date:
</B>Saturday, February 27, 1999 3:17 PM<BR><B>Subject: </B>Re: Excel and DDE
link -- Help!<BR><BR></DIV></FONT>Hey guys<BR><BR>Is't this list wonderful
with so much expertise and people willing to help each other??<BR><BR><?paraindent><?param out,out>Thanks Ton -- You are busy
helping me to shortcut my learning curve with Excel + DDE links<BR><?/paraindent>Johan<BR><BR>At 05:13 PM 2/27/99 +0100, you
wrote:<BR>>You can do this as a workaround:<BR>><BR>>Like myself,
keep a single folder containing the MS's dat/dop/master/emaster
<BR>>files for the especially for this occassion created OLE Charts, eg I
have this as<BR>>addresses map build-up, and it also being part of my MS
database folder setup:<BR>><BR>>C:<BR>> - /Ms<BR>> - / -
/AexOptie<BR>> - / - / - /OLE<BR>> - / - /Index<BR>> - / -
/Local-A<BR>> - / - /Local-N<BR>><BR>>The OLE folder
holds:<BR>>- all the MS database files mentioned above(dat/dop etc.
files) of the most<BR>> frequently used Stock and Indexes(my hottest
'stocks')<BR>>- holds any of the specialy especially for this created OLE
Charts (Close Only)<BR>>- holds the OLE-template (Close Only) should I
wish to create more<BR>> of the Close Only Charts).<BR>><BR>>As the
OLE Link's first cell in Excel always start of with the very first
date<BR>>(=record 1) found in a Metastock database(dat/dop etc. files)
and for this then<BR>>you are also stuck with and in using this first
Record(=Row). So for the data<BR>>base files find yourselves a proper
-manualy- Date maintenance schedule, eg<BR>>like myself deleting once a
month the then older then 2 months -but now not<BR>>required anymore-
records' rows in the Downloader.<BR>><BR>>This latter is a bit tricky,
tho, as when you use a sequence like I have mentioned<BR>>in the previous
mail, eg taking each 20min data out of a 5min continuous data
feed,<BR>>and also upose to like how I am using this OLE linking myself,
eg having Excel doing<BR>>some calculations only on the last 2 months of
data.<BR>>I can sometimes then get caught when there has been an Exchange
working<BR>>holiday, and will then either have to Add+Copy the previous
day's values in<BR>>the Downloader (eg change the previous day's txt
files and change all of the<BR>>dates before starting a Convert-session)
or re-arrange the Excel sheet accordingly<BR>>eg manipulate some of the
cells places in the sheet or tweak the cells formula a
bit.<BR>><BR>>So the first date in the database will be presented as
the OLE linked first cell, and<BR>>as long as you can keep controll over
this "first display", eg the right data being used<BR>>for the
right first date/time, and also Selecting the right (greater then is
required) amount<BR>>or length of Rows down the column before you Paste
Link, then any other problems are<BR>>"naturaly caused by
yourselve".<BR>>The length of Selected cells down the column, prior
to esthablishing the Paste Link,<BR>>determines if you will have problems
for displaying the last dates in the database, eg<BR>>2 months of data is
roughly 50 Rows of cells that needs to be Selected in a single<BR>>column
only, and best then is to Select 100+.<BR>><BR>>Now by splitting the
and reference linking to the OLE Linked cells, then the sky is the
limit,<BR>>tho I should say that not all calculations can be performed in
Excel, it is also a computer<BR>>program, like many others, and does have
its limitations as well.<BR>> <BR>>regards,<BR>>Ton Maas
<BR>><BR>> <BR>>----- Original Message ----- <BR>>From: Lionel
and Gail Issen <lissen@xxxxxxxxxxxxxxxx><BR>>To:
<metastock@xxxxxxxxxxxxx><BR>>Sent: zaterdag 27 februari 1999
5:45<BR>>Subject: Re: Excel and DDE link --
Help!<BR>><BR>><BR>>>Ton:<BR>>><BR>>>Thanks for this
important and useful information.<BR>>><BR>>>In a spreadsheet,
is there a way for me to update, from metastock, only the<BR>>>recent
data (latest day, or the days since the last
update).<BR>>><BR>>>Lionel<BR>>>-----Original
Message-----<BR>>>From: A.J. Maas
<anthmaas@xxxxxx><BR>>>To: metastock@xxxxxxxxxxxxx
<metastock@xxxxxxxxxxxxx><BR>>>Date: Friday, February 26, 1999
5:58 PM<BR>>>Subject: Re: Excel and DDE link --
Help!<BR>>><BR>>><BR>>>>You can split a cell's
contents, containing OLE linked data, to other<BR>>>cells in the
sheet.<BR>>>><BR>>>snip<BR>>><BR>>><BR>><BR>><BR>>
</BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sun Feb 28 17:51:05 1999
Received: from listserv.equis.com (204.246.137.2)
by mail02.rapidsite.net (RS ver 1.0.2) with SMTP id 22042
for <neal@xxxxxxxxxxxxx>; Sun, 28 Feb 1999 03:46:06 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id QAA15970
for metastock-outgoing; Sun, 28 Feb 1999 16:22:02 -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 QAA15967
for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 28 Feb 1999 16:22:00 -0700
Received: from colin.muc.de (root@xxxxxxxxxxxx [193.149.48.1])
by freeze.metastock.com (8.8.5/8.8.5) with SMTP id BAA19787
for <metastock-list@xxxxxxxxxxxxx>; Sun, 28 Feb 1999 01:19:02 -0700 (MST)
Received: from tbus.muc.de ([193.149.49.181]) by colin.muc.de with SMTP id <140549-1>; Sun, 28 Feb 1999 09:07:23 +0100
Received: by tbus.muc.de from localhost
(router,SLmail95 V1.2,beta 1); Sun, 28 Feb 1999 09:05:49 cet
Received: by tbus.muc.de from tbus.muc.de
(193.149.49.181::mail daemon,SLmail95 V1.2,beta 1); Sun, 28 Feb 1999 09:05:47 cet
From: "rudolf stricker" <rst@xxxxxxxxxxx>
To: metastock-list@xxxxxxxxxxxxx
Subject: MS: permanent DDE links: How?
Date: Sun, 28 Feb 1999 09:05:41 +0100
Organization: tbus tech-consult & simulation, 80538 munich, germany
Message-ID: <36d91175.768661996@xxxxxxxxxxx>
X-Mailer: Forte Agent 1.0/32.390
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by listserv.equis.com id QAA15968
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-Loop-Detect: 1
X-UIDL: 302f9f4aef81a78f2995fe8e44323d7f.97
In several charts I need informations from more than one security. So
it is convenient in MetaStock to do some DDE linking, i.e. use COPY
and PASTE SPECIAL.
But seemingly, the DDE links established this way are not very stable.
In many cases the links are broken, when I open such a chart the next
time.
So my question is:
What can I do to set-up _permanent_ DDE links in MetaStock?
Or is MetaStock not able to support such permanent DDE links?
Any hint is welcome
mfg rudolf stricker
| Disclaimer: The views of this user are strictly his own.
|