[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Import Quotes To Excel/Quatro Pro



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>&nbsp;</DIV>
<DIV><FONT size=2>Below is a repost from last Jan00 that is (-in short&nbsp;and 
sort of -) only summerising the "MSK --&gt; 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&nbsp; </FONT><A 
href="http://home.planet.nl/~anthmaas";><FONT 
size=2>http://home.planet.nl/~anthmaas</FONT></A></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT size=2>-Open DL</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Create a duplicate file of your 
stock</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -(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>&nbsp;&nbsp;&nbsp; -Create a Chart for that stock (thus not a 
Smart Chart/Layout), eg </FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; -Open 
a Chart loading max 750 periods</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 
-Create the ATR for that stock</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; -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>&nbsp;&nbsp;&nbsp;&nbsp; -RightClick&nbsp;for Small Context 
Menu</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Click Stack Windows 
Horizontaly</FONT></DIV>
<DIV><FONT size=2>-In MSK window</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Select the ATR</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-RightClick for Small Context 
Menu</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Click Copy</FONT></DIV>
<DIV><FONT size=2>-In Excel window</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT size=2>-In column A 
only, down Select in 1 single move say&nbsp;1000 cells/column</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{750 
history+250future=the above mentioned 1000periods, eg you can use it 
for</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;another&nbsp;</FONT><FONT size=2>1 full year</FONT><FONT 
size=2>&nbsp;before you MUST </FONT><FONT size=2>Delete the oldest 250 periods 
in your DL file}</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Move mouse pointer over your (black) 
selection</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -RightClick for Small Context 
Menu</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -Click Paste Special</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 
-In Paste Special Dialog Window</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Check 
the Paste Link&nbsp;radio button</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Select 
CSV for Clipboard's contents type</FONT><FONT size=3>&nbsp;&nbsp;</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; -In column B and C "unfold" the 
OLE-ed data&nbsp;into&nbsp;usable data, eg</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Type 
in Cell B2</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;=DIVIDE(T(A2);1;8)</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Type 
in Cell C2</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;=DIVIDE(T(A2);10;24)</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
{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>&nbsp;&nbsp;&nbsp;&nbsp; -In the rectangled 
selected B2 cell, click the small black handle at bottom 
right</FONT></FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Make 
it a&nbsp;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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-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>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT></DIV>
<DIV><FONT size=2>From: "Chris Hengeveld"</FONT></DIV>
<DIV><FONT size=2>To: &lt;</FONT><A href="mailto:metastock@xxxxxxxxxxxxx";><FONT 
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;</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>