|
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>
<STYLE></STYLE>
<META content='"MSHTML 5.00.0910.1309"' name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>can't seem to get metastock to buy on open and sell at close
on the same day. i'm sure it's some nifty little trick. any help
appreciated.</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Mon Mar 22 13:18:26 1999
Received: from listserv.equis.com (204.246.137.2)
by mail05.rapidsite.net (RS ver 1.0.2) with SMTP id 4831
for <neal@xxxxxxxxxxxxx>; Mon, 22 Mar 1999 16:09:24 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id EAA04467
for metastock-outgoing; Tue, 23 Mar 1999 04:23:59 -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 EAA04460
for <metastock@xxxxxxxxxxxxxxxxxx>; Tue, 23 Mar 1999 04:23:55 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id NAA00590
for <metastock@xxxxxxxxxxxxx>; Mon, 22 Mar 1999 13:16:52 -0700 (MST)
Received: from escom ([195.121.39.55]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAA404C
for <metastock@xxxxxxxxxxxxx>; Mon, 22 Mar 1999 02:09:11 +0100
Message-ID: <001501be7400$1d6da6e0$372779c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <002d01be686b$1d21db20$4a6d75ce@xxxxxxxxxxxxxxxxx>
Subject: Re: permanent DDE links: How?
Date: Mon, 22 Mar 1999 02:05:32 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-MIME-Autoconverted: from 8bit to quoted-printable by listserv.equis.com id EAB04467
X-Loop-Detect: 1
X-UIDL: aaa00d825a2e394c9ad288d663bb8aea.02
Guy, there are a few workarounds:
The Excel Cell Editor (formulas+references etc.) displays a Link as follows:
{=MetaStock.Chart|'D:\Ms\AexOptie\OLE\AEX-index.mwc'!'\AEX-index»Ind/Sec«254»¶'}
where :
{ } = Comment start+end (indicating that what is placed
between characters is a comment, not a formula etc.)
=MetaStock.Chart = Source Object Type
| = Separator (Pipe)
'D:\Ms\AexOptie\OLE\AEX-index.mwc' = Path+FileName+Extension between Inverted Commas
! = Separator (Exclamation)
'\AEX-index»Ind/Sec«254»¶' = Object Item and is made up of the \slashFileName,
the »Object Type and «ObjectNo.#» (=unique #) and
followed by the ¶ character (CR), all placed between
Inverted Commas.
Workarounds:
1. In Excel you can change the source for an OLE-link :
-On the WorkMenu click Edit|Link|Change Source
-Rename the Sources' FileName and also the Object Items' FileName,
so as the double(2x) changes are then always made.
No need to change this in the Cells' Editor as that won't work(=formulas only)
or
2. In the Downloader delete the old records, but keep the security and chart
(eg do not use a "time or series" reference in their name, suppose you
are able to only make such a change to the Tickersymbol only)
-Select a sheets total Data Records by 1x clicking on the empty grey
square corner right above row #1-figure 1
-On the WorkMenu click Tools|Delete|Data (and it will have either the first
or the last day pre-selected for you) and apply the appropiate option for
deleting all Data Records "before" or "after" the date that is presented
(note that you can use a fixious date like 19590101 and do a Data
Records-deletion session for multiple secs in one GO by selecting the
more secs)
-Check that the security's Tickersymbol(s) are in agreement with the Tickers
received in data files from your Data Vendors(eg the "equivelant" security)
-Start the Convert-Tool to update the Data Records for and to the above
(previously deleted data records) security(s)
Regards,
Ton Maas
ms-irb@xxxxxx
----- Original Message -----
From: Guy Tann <grt@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: zondag 7 maart 1999 8:21
Subject: RE: permanent DDE links: How?
> Ton
>
> I saved all of your posts so that I can play with them this week.
>
> The problem I have with the OLE link between MS and Excel is that MS is
> using the security name as well as the chart name in the link.
>
> Since I create my own modified continuous securities, whenever I change
> months 9like from Mar T-Bonds to Jun T-Bonds0, the link breaks. It would be
> so much easier if all I had to worry about was the chart name.
>
> Regards
>
> Guy
>
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of A.J. Maas
> Sent: Saturday, March 06, 1999 3:00 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: permanent DDE links: How?
>
>
> For any of the persistant MS to MS OLE problems, I can only suggest not to
> use the SAVE AS as Smart Charts file type Option that is given, but to
> create
> fresh new standard Charts and then to SAVE AS as Charts. It will then
> automatically also be saved as Smart Charts(if this option is applied in the
> Programs' Options), but since this is also a special Metastock feature
> (the "Smart" part), I cannot oversee what influence or effects this has/will
> have on programs' own "real" Smart Charts.
> They (the Smart Charts) are also used as being a different file type,
> obviously
> then more extended loaded with the smart "luxuries" features, and files get
> written to with these extra luxurious "smart" contents for the compilers to
> interpret.
> One thing to know also is, that Smart Charts(like Templates and standard
> Charts)
> are also already linked(as some kind of Smart layout) to the securities held
> in
> the MS Data Files.
>
> So, suggest to create and put the to be OLE linked Chart(standard version
> but
> having the Programs Option "Use Smart Charts" applied), into their own
> working
> folder, then to link these Charts to their consequtive Smart Charts(usualy
> have a
> number "in their name", but that is here irrelevant, unlike in Excel), or to
> link the
> Smart Charts to their consequetive Charts, and then to test these method(s).
>
> As to the Excel to Ms question:
> Note that the to be linked indicator dates will have to match the base
> security's
> dates, at least to guarantee proper OLE link outcome results.
> Suggest to Link the base security's dates to Excel first, have the Excel
> indicator
> streamlined with these dates, and then to Link the Excel indicator to MS.
> This
> way, tho, requires for both the files to be Opened, eg to get updated
> simultaniously.
> Also a CSV layout(comma's in seperate columns or used in the cells
> properties)
> being used in Excel might be preferable and keeping it down to one or two
> columns as well (see further MS-Manual p. 11+13).
> Otherwise in Excel Selecting, Copying and in Metastock Pasting Special
> as CSV in a freshly new created Inner Window(from the WorkMenu's Window)
> and later to SAVE AS as Chart, will not give major problems.
> Updating will then be automatically done when you Open the Chart(or both the
> Chart and Excel files should you choose to use the base security link
> above).
>
> Regards,
> Ton Maas
> ms-irb@xxxxxx
>
> ----- Original Message -----
> From: rudolf stricker <rst@xxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: zaterdag 6 maart 1999 13:45
> Subject: Re: permanent DDE links: How?
>
>
> >On Sun, 28 Feb 1999 21:46:12 +0100, you wrote:
> >
> >>Dynamic Data Exchange - DDE
> >>
> >>A way of communication between processes, implimented in the Operating
> >
> >[...]
> >
> >>Object - OLE
> >>
> >>A component that is recoqnisable for the operating system and user and can
> >>only be made distinguasable by
> >
> >[...]
> >
> >>As to your burning question, suggest to create single seperate Charts
> >>only(OLE use) and/or use the Smart Charts for
> >>Layouts(Internal use).
> >>Both ways, the links are then definitly stored in the consequtive Chart or
> >>Layouts files (MWC+MWL) on disk.
> >
> >Thank you for your extended material on DDE & OLE. (Unfortunately,
> >because I'm a WIN user since V1, I used the "ancient" shortcut "DDE"
> >instead of the correct "OLE").
> >
> >But the problem is still there (c.f. my original posting): Even if I
> >follow the correct CUT&PASTE SPECIAL procedure and store my charts as
> >SMART CHARTS (as usual), the links are often broken, when I open the
> >chart again the next day. Sometimes it works for some days, but then
> >the links have crashed again: they are no longer updated or may even
> >show erratic behavior for the data transferred up to then.
> >
> >This behavior shows up only for OLE-connections from Metastock to
> >Metastock. Links from Metastock to Excel are very reliable.
> > (BTW: Can I also set-up links from Excel to Metastock for e.g.
> >single indicators calculated in Excel? Up to now I have to use this
> >inconvenient import procedure via DOWNLOADER CONVERT several times per
> >day.)
> >
> >mfg rudolf stricker
> >| Disclaimer: The views of this user are strictly his own.
>
>
>
>
>
|