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>
<DIV><FONT size=2></FONT><FONT size=2>I have written some 15+ FAQ's (incl Part 1
and Part 2) on the OLE link subject</FONT></DIV>
<DIV><FONT size=2>between MSK and XLS and vice versa.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Below is a repost from last Jan00 that is (-in short and
sort of -) only summerising the "MSK --> XLS" -traject.</FONT></DIV>
<DIV><BR><FONT size=2>Regards,<BR>Ton Maas<BR></FONT><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx"><FONT
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>Dismiss the ".nospam"
bit (including the dot) when replying.<BR>Homepage </FONT><A
href="http://home.planet.nl/~anthmaas"><FONT
size=2>http://home.planet.nl/~anthmaas</FONT></A></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>
<DIV><STRONG><FONT size=3>OLE-ing between MetaStock and Excel
:</FONT></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><FONT size=3> </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></FONT><FONT size=2></DIV></DIV></FONT>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT></DIV>
<DIV><FONT size=2>From: "Chris Hengeveld"</FONT></DIV>
<DIV><FONT size=2>To: <</FONT><A href="mailto:metastock@xxxxxxxxxxxxx"><FONT
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>></FONT></DIV>
<DIV><FONT size=2>Sent: maandag 4 september 2000 21:52</FONT></DIV>
<DIV><FONT size=2>Subject: Import Quotes To Excel/Quatro Pro</FONT></DIV>
<DIV><FONT size=2><BR></FONT></DIV><FONT size=2>sorry about the incorrect
topic.<BR>I'm sure this topic has come up but how bout one more time? Can
someone give me<BR>an idea of how to add current quotes through OLE into a
Quatro Pro database? I<BR>can get these numbers from metastock or the web or
even quicken. I'm sure the<BR>Excel instructions would be similar so either
would suffice. Thanks in advance.<BR><BR><BR><BR></FONT></BODY></HTML>
</x-html>
|