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

Re: Metastock OLE



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><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>1) Print out&nbsp;the OLE FAQ's(Part 1+Part2 and Q1 to 
Q15).</FONT></DIV>
<DIV><FONT size=2>2)&nbsp;D</FONT><FONT size=2>o&nbsp;a Test on Q1.</DIV></FONT>
<DIV><FONT size=2>3)&nbsp;W</FONT><FONT size=2>hat you are trying to acomplish 
here below is to OLE link the Base Security to Excel.</FONT><FONT 
size=2>&nbsp;Why since it contains (so) many fields (O,H,L,C,V,O/I) 
?</FONT></DIV>
<DIV><FONT size=2><FONT size=2>4)&nbsp;This Q3 above&nbsp;is your current 
choise, but is this also what you want ?{see Q1}</FONT></FONT></DIV>
<DIV><FONT size=2>5) Does the OLE linked Data, after applying 
Q1+2+3,&nbsp;also&nbsp;looks OK in Excel ?</FONT></DIV>
<DIV><FONT size=2>6)&nbsp;And after, you&nbsp;try to OLE link (new) data from 
Excel back to MSK.&nbsp;</FONT><FONT size=2>All very well possible, but "what 
type of data" ?</FONT></DIV>
<DIV><FONT size=2>7)&nbsp;After applying Q1+2+3+4+5+6, i</FONT><FONT size=2>s 
the arrangement of the Excel fields+columns+cells&nbsp;also properly setup to 
establish that OLE link ?</FONT></DIV>
<DIV><FONT size=2>8)&nbsp;</FONT><FONT size=2>Does the OLE linked Data, after 
applying Q7,&nbsp;also looks OK in MSK ?</FONT></DIV>
<DIV><FONT size=2>9) Compare notes: your previous accomplishments below 
versus&nbsp;the Q's 1 to 8 above.</DIV></FONT>
<DIV><FONT size=2></FONT>&nbsp;</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&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
  <A title=mpspencer@xxxxxxxxxxxxxx 
  href="mailto:mpspencer@xxxxxxxxxxxxxx";>Michael Spencer</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> woensdag 10 mei 2000 2:24</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Metastock OLE</DIV>
  <DIV><BR></DIV>
  <DIV><FONT color=#000000 size=2>Thanks, Ton.&nbsp; It seems to me as if I 
  tried solution multiple times without success.&nbsp; If you think it's a good 
  solution, I'll try it again, and let you know.&nbsp; The example below is for 
  creating a new <EM>return </EM>link from Excel back to Metastock.&nbsp; What 
  do you think is the proper approach when you need to create a new link from 
  Metastock to Excel, if the information you're linking is from the window that 
  contains the underlying security.&nbsp; Deleting that window obviously kills 
  the chart.&nbsp; Any thoughts?&nbsp; Many thanks for your 
  assistance.</FONT></DIV>
  <DIV><FONT color=#000000 size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2>Best regards,</FONT></DIV>
  <DIV><FONT size=2>Michael Spencer</FONT></DIV>
  <BLOCKQUOTE 
  style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid">
    <DIV><FONT size=2><B>-----Original Message-----</B><BR><B>From: </B>A.J. 
    Maas &lt;<A 
    href="mailto:anthmaas@xxxxxxxxx";>anthmaas@xxxxxxxxx</A>&gt;<BR><B>To: 
    </B>Metastock-List &lt;<A 
    href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;<BR><B>Date: 
    </B>Tuesday, May 09, 2000 3:45 PM<BR><B>Subject: </B>Re: Metastock 
    OLE<BR><BR></DIV></FONT>
    <DIV><FONT size=2>1) Delete the old link from the Chart.</FONT></DIV>
    <DIV><FONT size=2>2) Create a new OLE link.</FONT></DIV>
    <DIV><FONT size=2></FONT>&nbsp;</DIV>
    <DIV><FONT size=2>Charts can be re-used over and over again and again, just 
    delete the old</FONT></DIV>
    <DIV><FONT size=2>Inner Window that </FONT><FONT size=2>contained the bad 
    OLE link.</DIV></FONT>
    <DIV><FONT size=2>Then Pulldown a New (blanc) Inner Window from the Window 
    Menu, </FONT><FONT size=2>right click</FONT></DIV>
    <DIV><FONT size=2>in it for the Small Context Menu 
    and&nbsp;click</FONT><FONT size=2> Paste Special.</FONT></DIV>
    <DIV><FONT size=2>If Chart is to your likings hit the Save 
    button.&nbsp;</FONT></DIV>
    <DIV><FONT size=2></FONT>&nbsp;</DIV>
    <DIV><FONT size=2></FONT>&nbsp;</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&nbsp; <A 
    href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
    <DIV>&nbsp;</DIV>
    <DIV>&nbsp;</DIV>
    <BLOCKQUOTE dir=ltr 
    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
      <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
      <DIV 
      style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
      <A title=mpspencer@xxxxxxxxxxxxxx 
      href="mailto:mpspencer@xxxxxxxxxxxxxx";>Michael Spencer</A> </DIV>
      <DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
      href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> </DIV>
      <DIV style="FONT: 10pt arial"><B>Sent:</B> dinsdag 9 mei 2000 19:59</DIV>
      <DIV style="FONT: 10pt arial"><B>Subject:</B> Metastock OLE</DIV>
      <DIV><BR></DIV>
      <DIV>
      <DIV><FONT color=#000000 size=2>Has anyone done much messing around with 
      linking Metastock with Excel, exchanging data back and forth, watching 
      things update as changes are made?&nbsp; I'm trying it for the first time 
      and, although it seems to work better than I expected, there seem to be 
      some gotchas.&nbsp; Specifically, when an OLE link is broken (i.e., I 
      goofed and need to try something different), the chart is, forever after, 
      rendered useless for further OLE linking.&nbsp; There seems to be some 
      memory of the link which is retained by the chart, and which fowls up all 
      sorts of stuff.&nbsp; Anybody been down this road?&nbsp; Many 
      thanks.&nbsp; </FONT></DIV>
      <DIV><FONT color=#000000 size=2></FONT>&nbsp;</DIV>
      <DIV><FONT color=#000000 size=2>Michael 
    Spencer</FONT></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Wed May 10 16:43:55 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.9.3/8.9.3) with ESMTP id QAA19787
	for <neal@xxxxxxxxxxxxx>; Wed, 10 May 2000 16:43:27 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id RAA32665
	for metastock-outgoing; Wed, 10 May 2000 17:03:44 -0600
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 RAA32661
	for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 10 May 2000 17:03:40 -0600
Received: from mail1.brightok.net (mail1.brightok.net [206.30.106.70])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA07424
	for <metastock@xxxxxxxxxxxxx>; Wed, 10 May 2000 17:20:00 -0600 (MDT)
Received: from lurch (sulphur8p137.cld.brightok.net [204.249.195.137])
	by mail1.brightok.net (8.9.3/8.9.3) with SMTP id SAA23736
	for <metastock@xxxxxxxxxxxxx>; Wed, 10 May 2000 18:03:06 -0500 (CDT)
Message-ID: <007101bfbad3$7b782380$786fa8c0@xxxxx>
From: "Adam Hefner" <vonhef@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Subject: Revised S&P Target
Date: Wed, 10 May 2000 18:00:04 -0500
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_NextPart_000_006D_01BFBAA9.91C04700"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

<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.3013.2600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial>Well, we have hit&nbsp;the Monthly low target of 1390 
today! If tomorrow's action in the S&amp;P 500 continues to fall, the new 
Monthly low target would be around 1357-1362 (see attached file for charts), If 
on the other hand the next day or two show signs of support...then we have 
probably hit the</FONT></DIV>
<DIV><FONT face=Arial>monthly low and should expect prices to rise from here. Of 
course this is only analysis....and could be VERY wrong.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial>Adam</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\S&P 500.doc"