|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML><HEAD>
<META content=text/html;charset=Windows-1252 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<STYLE></STYLE>
<META content='"MSHTML 5.00.0910.1309"' name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV>
<P><FONT size=2><EM><STRONG>Dynamic Data Exchange -
DDE</STRONG></EM></P></DIV></DIV>
<DIV>
<DIV>A way of communication between processes, implimented in the Operating
Systems of Microsoft Windows.</DIV>
<DIV>Two or more programs that support DDE, can exchange information and
commands. Most of the DDE</DIV>
<DIV>functions have been replaced by the new versions of OLE, eg v1.0 and
v2.0.</DIV>
<DIV> </DIV>
<DIV><EM><STRONG>Object Linking and Embedding - OLE</STRONG></EM></DIV>
<DIV> </DIV>
<DIV>The technology and interface for inter-action at object level; a way of
information exchanging between programs</DIV>
<DIV>and to use information combined.</DIV>
<DIV> </DIV>
<DIV><EM><STRONG>Object - OLE</STRONG></EM></DIV>
<DIV> </DIV>
<DIV>A component that is recoqnisable for the operating system and user and can
only be made distinguasable by</DIV>
<DIV>its properties, operations and relations. Also every piece of information
that is created by a Windows Application</DIV>
<DIV>with OLE-facilities and that can be inserted or linked into another
document.</DIV>
<DIV> </DIV>
<DIV>---------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT size=2><FONT size=2>See the Equis' web-page further below, for an
explaination of MetaStockv6.x NONE-</FONT><FONT
size=2>relation</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2>with DDE (=up to Win3.11) </FONT></FONT><FONT
size=2><FONT size=2>and MetaStock program's FULL relation </FONT><FONT
size=2>with OLE 2.0 (=since Win95).</FONT></FONT></DIV>
<DIV> </DIV></DIV>
<DIV>Data exchange as it was used previously, was only exchanging selections of
data-bits between programs and</DIV>
<DIV>are now - since OLEv1.0 - Objects and this in the widest sence.</DIV>
<DIV>Objects are virtual files(VFiles) having their own properties, operations
and relations etc.</DIV>
<DIV>Messing about with (like replacing, renaming, deleting) any of these
Objects(eg the underlaying subject: the VFile)</DIV>
<DIV>can then also have (bad) implimentations on the Objects' Link, eg the OLE
links from the VFile to your file.</DIV>
<DIV>They might still seem to be present (or not), but the results might be in
not returning the right values, have mutulated</DIV>
<DIV>links without any values given, or simply breached links, eg the above made
faults are then the #1 possibillity.</DIV>
<DIV> </DIV>
<DIV>Seen in that respect, any problems arisen are then due to and from and on
the users end (from not enough</DIV>
<DIV>knowledge and experience in and how to maintain the OLE links or in how to
perform other required links systematic</DIV>
<DIV>maintenance while using programs or other operating commands).</DIV>
<DIV>Usualy it involves for the user to become more adequatly acquainted with
the copying, pasting and linking routines</DIV>
<DIV>in general, and OLE in particular.</DIV>
<DIV> </DIV>
<DIV>So for linking info, I would suggest to read the OLE support articles found
in the Microsoft's Knowledge Base and</DIV>
<DIV>the few webpages dedicated to OLE and its usage and handles on the Equis
website (however, they are a bit old</DIV>
<DIV>and dated, eg the Excel v8.0, the Office97Pro version, handles 65,500 OLE
linked record cells(=262 years) easely</DIV>
<DIV>in a single(1) column only !!).</DIV>
<DIV> </DIV>
<DIV>For the Profesional TechNet site
www.microsoft.com/Technet</DIV>
<DIV>or the Personal Support
site <A
href="http://www.support.microsoft.com/";>www.support.microsoft.com/</A></DIV>
<DIV>and the Equis Customer Support site <A
href="http://www.equis.com";>www.equis.com</A></DIV>
<DIV>
<DIV> </DIV>
<DIV>OLE usage has got its own limitations, like other programs, but in general
is very stable.</DIV></DIV>
<DIV>Above is therefore only printed here as a help in solving possible misuse
of links generaly and OLE-links particulary.</DIV>
<DIV>Only when applying the faulty Patches early in Jan99, the OLE links here
got messed up. This was then due</DIV>
<DIV>to the Patch(es) not completing properly(no messages) and leaving user with
some patched, some halve patched</DIV>
<DIV>and some unpatched files eg enough for total disrubtioning of the MS system
files, and so this had nothing to do</DIV>
<DIV>with an unstable OLE, but more with the unstable faulty Patch(es).</DIV>
<DIV>Otherwise the OLE used here behaves and operates very normal, sometimes
slow (depending on a clean RAM</DIV>
<DIV>memory, but soon fixed by a re-boot) and is as described on the Equis site:
the cutting edge technology</DIV>
<DIV>(if you realy must leave the MS program to do calculations it cannot
perform).</DIV>
<DIV> </DIV>
<DIV>Tho, Equis has done so well in explaining some parts of the Copy + Paste
and Copy + Paste Special as Paste +</DIV>
<DIV>Copy + Paste Special as Link routines in their Manual and build-in Help,
their exact usage and also their exact</DIV>
<DIV>OLE usage and setup routine(s) could be better, more in detail be described
in the Manual, the Help as well as</DIV>
<DIV>in the pages on the Web.</DIV>
<DIV> </DIV>
<DIV></FONT><FONT size=2>Some examples of confusion:</FONT></DIV>
<DIV><FONT size=2>- CSV should be read as SCSV-Semi Colon or plain Comma
Seperated Values eg as it is standard set as</FONT></DIV>
<DIV><FONT size=2> (try "Save As")
semi-colon seperated values(SCSV), only in some programs to be </FONT><FONT
size=2>used as comma</FONT></DIV>
<DIV><FONT size=2> seperated </FONT><FONT
size=2>values.</FONT></DIV>
<DIV><FONT size=2>- For the Quattro program mentioned below, one can read other
Win95 programs as well</FONT></DIV>
<DIV><FONT size=2>-</FONT><FONT size=2> Missing one single list that describes a
standard set-up routine for OLE or plain copying to and using or
linking</FONT></DIV>
<DIV><FONT size=2> MS data to MS Excel and
</FONT><FONT size=2>v-v (visa versa), </FONT><FONT size=2>eg how setting up a
full OLE link and compared to plain Copy+Paste</FONT></DIV>
<DIV><FONT size=2> and the other options given in
the Dialog Window(s) also better explained :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT
size=2> like:
<STRONG>from MS to MS</STRONG> </FONT></DIV>
<DIV><FONT
size=2> Copy
(standard use, copying the selection to Clipboard)</FONT></DIV>
<DIV><FONT
size=2> Paste
(standard paste use, Clipboard contents (copied selection) now pasted to the new
selection)</FONT></DIV>
<DIV><FONT
size=2> Paste
Special as Paste (standard use, pasting of Clipboard contents now as
Object)</FONT></DIV>
<DIV><FONT
size=2> <FONT
size=2>Paste Special as Link (paste Clipboard contents as Object Link and as for
Type, eg charts, pictures</FONT>
<DIV><FONT
size=2>
or </FONT><FONT size=2>databases or text files, with file</FONT><FONT size=2>
types extension, eg BMP,TXT,CSV etc.</FONT></FONT></DIV></DIV>
<DIV><FONT size=2> and:
<STRONG>from MS to Excel</STRONG></FONT><FONT size=2> <FONT
size=2> <FONT
size=2></DIV>
<DIV>
<DIV>
<DIV><FONT size=2><FONT
size=2> </FONT>Copy
(standard use, copying the selection to Clipboard)</FONT></DIV>
<DIV><FONT
size=2> Paste
(standard paste use, Clipboard contents (copied selection) now pasted to the new
selection)</FONT></DIV>
<DIV><FONT
size=2> Paste
Special as Paste (standard use, pasting of Clipboard contents now as
Object)</FONT></DIV>
<DIV><FONT
size=2> <FONT
size=2>Paste Special as Link (paste Clipboard contents as Object Link and as for
Type, eg charts, pictures</FONT>
<DIV><FONT
size=2>
or </FONT><FONT size=2>databases or text files, with file</FONT><FONT size=2>
types extension, eg BMP,TXT,CSV etc.</FONT></DIV>
<DIV></FONT><FONT size=2></FONT></FONT><FONT size=2></FONT></FONT></FONT><FONT
size=2> Update
in Excel (both options Manual(Edit|Link|Update|Update Link)
and</FONT></DIV></DIV></DIV></DIV>
<DIV><FONT
size=2>
Automatical(=settings are in Excel (Tools|Options|(TAB Calculate
&</FONT><FONT size=2>TAB Edit)</FONT></DIV>
<DIV><FONT
size=2> which
2 TABS alone have some 6 or 7 options that must/can be applied</FONT></DIV>
<DIV><FONT size=2><FONT
size=2> and: <STRONG>from
Excel to MS</STRONG></FONT></FONT><FONT size=2><FONT size=2><FONT
size=2> <FONT
size=2></DIV>
<DIV>
<DIV><FONT size=2><FONT
size=2> </FONT>Copy
(standard use, copying the selection to Clipboard)</FONT></DIV>
<DIV><FONT
size=2> Paste
(standard paste use, Clipboard contents (copied selection) now pasted to the new
selection)</FONT></DIV>
<DIV><FONT
size=2> Paste
Special as Paste (standard use, pasting of Clipboard contents now as
Object)</FONT></DIV>
<DIV><FONT
size=2> Paste
Special as Link (paste Clipboard contents as Object Link and as for Type, eg
charts, pictures</FONT></DIV>
<DIV><FONT
size=2>
or </FONT><FONT size=2>databases or text files, with file</FONT><FONT size=2>
types extension, eg BMP,TXT,CSV etc.</FONT></FONT><FONT
size=2></FONT></FONT></FONT><FONT size=2> </FONT></DIV>
<DIV></FONT><FONT
size=2>
Update in MS (usualy this gets done Automaticaly and can be done Manualy
by</FONT></DIV>
<DIV><FONT
size=2> right-click
a Link and click on Update or on Open Link</FONT><FONT size=2>)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>As you can see this summing up can go on and on, and actualy
that is what user will have to do himself also, eg</FONT></DIV>
<DIV><FONT size=2>collect </FONT><FONT size=2>as much OLE (and related) info and
make/create a private manual.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>As to your burning question, suggest to create single seperate
Charts only(OLE use) and/or use the Smart Charts for</FONT></DIV>
<DIV><FONT size=2>Layouts(Internal use).</FONT></DIV>
<DIV><FONT size=2>Both ways, the links are then definitly stored in the
consequtive Chart or Layouts files </FONT><FONT size=2>(MWC+MWL) </FONT><FONT
size=2>on disk.</FONT></DIV>
<DIV><FONT size=2>Then, and upose to using plain Charts or Smart Charts, the
Charts "naturaly" by program standard stored in the</FONT></DIV>
<DIV><FONT size=2>MS Smart folder </FONT><FONT size=2>will not </FONT><FONT
size=2>intervene with your daily -Linked Up- </FONT><FONT
size=2>work.</FONT></DIV>
<DIV> </DIV></DIV>
<DIV><FONT size=2>Regards,</FONT></DIV>
<DIV><FONT size=2>Ton Maas</FONT></DIV>
<DIV><FONT size=2>ms-irb@xxxxxx</FONT></DIV>
<DIV><FONT
size=2>
</FONT></DIV>
<DIV><FONT size=2> </FONT></DIV></DIV>
<DIV><FONT face="Times New Roman" size=5></FONT> </DIV>
<DIV><FONT face="Times New Roman" size=5>Why can't I paste a link, from
MetaStock, into Quattro Pro, as CSV (comma separated value) format?</FONT>
<P></P>
<P><FONT size=1></FONT> </P>
<P>Quattro Pro (including the latest version 7.0) uses DDE (dynamic data
exchange) links to exchange data. It does not support OLE (object linking and
embedding) links. MetaStock for Windows uses OLE Links and not DDE links.
Therefore it is not possible to paste data from MetaStock into Quattro Pro or
Quattro Pro into MetaStock. </P>
<P>Note: You can work around this by using Microsoft Excel also. Since Excel
supports both types of links, you can create a link from MetaStock to Excel, by
pasting data from MetaStock into Excel, then create a link from Excel to Quattro
Pro, by pasting the data from Excel into Quattro Pro. This will work in reverse
also.</P>
<DIV><FONT size=2>
<DIV>
<P> </P>
<P>----- Original Message ----- </P></DIV>
<DIV>
<DIV>From: rudolf stricker <<A
href="mailto:rst@xxxxxxxxxxx";>rst@xxxxxxxxxxx</A>></DIV>
<DIV>To: <<A
href="mailto:metastock-list@xxxxxxxxxxxxx";>metastock-list@xxxxxxxxxxxxx</A>></DIV>
<DIV>Sent: zondag 28 februari 1999 9:05</DIV>
<DIV>Subject: MS: permanent DDE links: How?</DIV></DIV>
<DIV><BR></DIV>><BR>>In several charts I need informations from more than
one security. So<BR>>it is convenient in MetaStock to do some DDE linking,
i.e. use COPY<BR>>and PASTE SPECIAL. <BR>><BR>>But seemingly, the DDE
links established this way are not very stable.<BR>>In many cases the links
are broken, when I open such a chart the next<BR>>time.</FONT></DIV>
<DIV><FONT size=2>></FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=2>>So my question is:<BR>><BR>>What
can I do to set-up _permanent_ DDE links in MetaStock?<BR>>Or is MetaStock
not able to support such permanent DDE links?<BR>><BR>>Any hint is
welcome<BR>><BR>>mfg rudolf stricker<BR>>| Disclaimer: The views of
this user are strictly his own.<BR>></FONT></DIV></DIV></BODY></HTML>
</x-html>From ???@??? Sun Feb 28 19:40:14 1999
Received: from listserv.equis.com (204.246.137.2)
by mail05.rapidsite.net (RS ver 1.0.2) with SMTP id 16251
for <neal@xxxxxxxxxxxxx>; Sun, 28 Feb 1999 22:20:48 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id KAA17786
for metastock-outgoing; Mon, 1 Mar 1999 10:51:51 -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 KAA17782
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 1 Mar 1999 10:51:49 -0700
Received: from smtp.email.msn.com (cpimssmtpu03.email.msn.com [207.46.181.19])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id TAA20264
for <metastock@xxxxxxxxxxxxx>; Sun, 28 Feb 1999 19:48:56 -0700 (MST)
Received: from VonHef - 208.250.172.213 by email.msn.com with Microsoft SMTPSVC;
Sun, 28 Feb 1999 18:36:53 -0800
Message-ID: <001f01be638c$68a57e00$d5acfad0@xxxxxxxxxxxxxxxxx>
From: "Adam Hefner" <VonHef@xxxxxxxxxxxxx>
To: "MetaStock" <metastock@xxxxxxxxxxxxx>
Subject: Programming Question.....
Date: Sun, 28 Feb 1999 20:37:08 -0600
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-Loop-Detect: 1
X-UIDL: 450c7250e9865b33c12becaae5a7c928.03
I am writing a formula, lets call it "Code B" which will use the result (or
a value of a variable)
from lets call it "Code A" multiple times.....now, is it more / less
efficient to "call" the value
from "A" each time I need it, or would it be better to assign this value to
a variable in "B" and
use this "B variable" for all the calculations?
Best wishes,
Adam Hefner.
VonHef@xxxxxxxxxxxxx
---------------------------------------
|