|
PureBytes Links
Trading Reference Links
|
<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.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2><STRONG>OLE between MSK+Excel (+v.v.)
- FAQ's</STRONG></FONT></DIV>
<DIV><FONT
size=2>-----------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><STRONG>Q3. </STRONG></FONT>How d<FONT
face=Arial size=2>o I dynamicaly link a full database (in MSK format)
directly into an Excel spreadsheet, so that when updating</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial size=2> the database
automaticaly also the XL spreadsheet will get updated?</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>-I refer here also to what is written on the OLE subject in
the MetaStock program, on the Microsoft and Equis web-sites</FONT></DIV>
<DIV><FONT size=2> and in both programs manuals and build-in Help
files.</FONT></DIV>
<DIV><FONT size=2>
<DIV><FONT size=2><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><STRONG>To link an entire full database (in MSK
format) to an Excel spreadsheet</STRONG></FONT></FONT></DIV>
<DIV><FONT size=2>{read for workbook also
spreadsheets}</FONT></DIV></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-See also FAQ</FONT> <FONT size=2>- Q1+Q2 for Link
maintnance</FONT></DIV>
<DIV><FONT size=2>-See also Part 1 - <STRONG>OLE-ing between MetaStock and
Excel</STRONG></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>3a. -For each Security in your DL DataBase, create a new Chart
(mysecurity.mwc)</FONT></DIV>
<DIV><FONT size=2> {see the Steps set out below and
in Part 1 - OLE-ing between MetaStock and Excel}</FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT size=2>3b. -Repeat below Steps for
each Security in your DL DataBase</FONT></FONT></FONT></DIV>
<DIV><FONT size=2>3c. -Link each Chart's CLOSE ONLY indicator to your
Excel workbook</FONT></DIV>
<DIV><FONT size=2> {see Steps set out in Part
1 - OLE-ing between MetaStock and Excel}</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT size=2>In MSK window</FONT></FONT></DIV>
<DIV><FONT size=2>On the WorkMenuBar</FONT></DIV>
<DIV><FONT size=2><FONT size=2> -Open any
Security</FONT></FONT></DIV>
<DIV><FONT size=2> -Create the OLE-Template that consists
of each of the following Indicators:</FONT></DIV>
<DIV><FONT size=2> -PRICE Indicator
(O,H,L,C,V,O/I), eg the program's standard Base
Security indicator(see MSK-manual)</FONT></DIV>
<DIV><FONT size=2> -CLOSE Indicator
(C), eg a custom created CLOSE ONLY indicator</FONT></DIV>
<DIV><FONT size=2><FONT size=2>On the WorkMenuBar</FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2> -Click the New|Template button
(white page)</FONT></FONT></DIV>
<DIV><FONT size=2>On the WorkMenu</FONT></DIV>
<DIV><FONT size=2> -Click File|Save AS</FONT></DIV>
<DIV><FONT size=2> -Save As the new Template (OLE.mwt) to
a sub-folder named OLE (eg C:\Equis\Data\OLE)</FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT size=2>On the
WorkMenuBar</FONT></FONT></FONT></DIV>
<DIV><FONT size=2> -Click the Open button</FONT></DIV>
<DIV><FONT size=2>In the Open window</FONT></DIV>
<DIV><FONT size=2> -Click Options</FONT></DIV>
<DIV><FONT size=2>
In the Options window</FONT></DIV>
<DIV><FONT size=2>
</FONT><FONT size=2>-Type 750 for maximum
periods used</FONT></DIV>
<DIV><FONT size=2>
-Click OK</FONT></DIV>
<DIV><FONT size=2> -Click Template</FONT></DIV>
<DIV><FONT
size=2>
In the Open window</FONT></DIV>
<DIV><FONT
size=2>
-Browse for the OLE Template (eg C:\Equis\Data\OLE\OLE.mwt)</FONT></DIV>
<DIV><FONT
size=2>
-Blue Select the OLE Template</FONT></DIV>
<DIV><FONT
size=2>
-Click Open</FONT></DIV>
<DIV><FONT size=2>Once Security is Open-ed and displayed</FONT></DIV>
<DIV><FONT size=2>On the WorkMenu</FONT></DIV>
<DIV><FONT size=2> -Click File</FONT></DIV>
<DIV><FONT size=2> -Click Save As</FONT></DIV>
<DIV><FONT size=2> -Save As this Security as a Chart (eg
C:\Equis\Data\OLE\MySecurity.mwc)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT size=2><FONT
color=#0000ff><STRONG>Q4. </STRONG><FONT color=#000000>Why Link, in a
workbook or to MSK, 1000 Cells for maximum
only?</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT color=#000000>Use of
system resources (Memory, Processor) play a big role in smooth computing
when</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT color=#000000>using the
OLE feature.</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000> -in Excel: each linked
Cell singly will have to be maintained</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000>
-will be re-calculated (on Opening/MANUAL
Updating)</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000>
-will remain in system MEM for the rest of the workbook's Open
session</FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000> -in MSK: each linked Cell
singly will have to be maintained</DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT
color=#000000> -will
be re-calculated (on Opening/MANUAL
Updating)</FONT></FONT></FONT></FONT></DIV>
<DIV>
-will remain Updated for the rest of the Charts/Smart Charts/Layouts Open
session</DIV>
<DIV> <FONT
size=2><FONT size=2><FONT color=#0000ff><FONT color=#000000>-will remain in
system MEM for the rest of the Charts/Smart Charts/Layouts Open
session</FONT></FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV> -in both programs:</DIV>
<DIV>
-too many historical (History) Periods/Cells used would put another -now
extra-</DIV>
<DIV> heavy
workload burden on the -already heavy (over)loaded- and above
described</DIV>
<DIV> OLE-tasks for the
PC's system resources</DIV>
<DIV> </DIV>
<DIV> -in Windows:</DIV>
<DIV>
-do not have any other programs Running or Open whilst OLE-ing, eg give as
much</DIV>
<DIV>
resources room (back) to the System.</DIV>
<DIV> </FONT></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT size=2><FONT
color=#0000ff><STRONG>Q5. </STRONG></FONT><FONT color=#000000>Can I
recover from having made a mistake in choosing the wrong Security/Indicator
to be Link-ed?</FONT></FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>Indicator</FONT></DIV>
<DIV>-------------</DIV>
<DIV><FONT size=2>In MSK window</FONT></DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>Undo the Link</FONT></DIV>
<DIV><FONT size=2> -RightClick the
object(indicator,column) for Small Context Menu</FONT></DIV>
<DIV><FONT size=2> -Click Delete <FONT size=2>{or on
WorkMenu Click Edit|Delete}</FONT></FONT></DIV>
<DIV>
<DIV><FONT size=2>Create new Link
<DIV><FONT size=2> -S</FONT><FONT size=2>ee Part 1,
Part 2 and the FAQ's for more info How to Create OLE-Links in
MSK</FONT></DIV>
<DIV></FONT><FONT size=2><FONT size=2>Change the Link-ed
source</FONT></FONT></DIV></DIV></DIV>
<DIV> -Undo the Link (see above)</DIV>
<DIV><FONT size=2> -Create a new Link (see
above)</FONT></DIV>
<DIV></FONT> </DIV></DIV>
<DIV><FONT size=2>Column</FONT></DIV>
<DIV>-----------</DIV>
<DIV><FONT size=2>In Excel window</FONT></DIV>
<DIV>Undo the Link</DIV>
<DIV>
<DIV><FONT size=2> -RightClick the
object(indicator,column) for Small Context Menu</FONT></DIV>
<DIV><FONT size=2> </FONT><FONT size=2> -Click
Delete {or on WorkMenu Click Edit|Delete}</FONT></DIV>
<DIV><FONT size=2>Create new Link</FONT></DIV>
<DIV><FONT size=2> -see Part 1, Part 2 and the FAQ's for
more info How to Create OLE-Links in Excel</FONT>
</DIV></DIV>
<DIV><FONT size=2>Change the Link-ed source</FONT></DIV>
<DIV><FONT size=2> -Click Edit|Link</FONT></DIV>
<DIV><FONT size=2> -Blue Select the WRONG source
object(chart indicator)</FONT></DIV>
<DIV> -Click Change Source {naturaly this is a devious
task not knowing which chart/indicator number to</DIV>
<DIV> type
here, but can help trained users to quickly change source objects}
</DIV></FONT></DIV>
<DIV><FONT size=2> -Undo the Link (see
above)</FONT></DIV>
<DIV><FONT size=2> -Create a new Link (see
above)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Security</FONT></DIV>
<DIV><FONT size=2>------------</FONT></DIV>
<DIV><FONT size=2>In Excel window</FONT></DIV>
<DIV><FONT size=2> -see above Undo and Create
Steps</FONT></DIV>
<DIV><FONT size=2>In MSK window</FONT></DIV>
<DIV><FONT size=2> -Delete OLE Chart</FONT></DIV>
<DIV><FONT size=2> -Create new OLE Chart (using
the in FAQ-Q3 step/by/step explained OLE-template Steps)</FONT></DIV>
<DIV> </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 <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><STRONG>From:
</STRONG><FONT face=Arial size=2>Tommaso Galanti</FONT> </DIV>
<DIV style="FONT: 10pt arial"><STRONG>To: </STRONG>A.J. Maas </DIV>
<DIV style="FONT: 10pt arial"><STRONG>Sent:</STRONG> zondag 30 januari 2000
22:57</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Excel & Metastock -
Using Calcs From Metastock</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Ton,</FONT></DIV>
<DIV><FONT face=Arial size=2>I am very grateful to you for the truly helpful
message.</FONT></DIV>
<DIV><FONT face=Arial size=2>Do you know if it's possible to dinamically link
my quote database (in MSK format) directly to an Excel spreadsheet, so that
updating the database also the content of the XL spreadsheet will be
automatically updated?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Many thanks in advance and best
regards</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Tommaso Galanti</FONT></DIV>
<DIV><FONT face=Arial size=2>ITALY</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>------snip----------</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Wed Feb 02 17:21:02 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id SAA07513
for <neal@xxxxxxxxxxxxx>; Wed, 2 Feb 2000 18:20:42 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA09324
for metastock-outgoing; Wed, 2 Feb 2000 17:31:29 -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 RAA09312
for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 2 Feb 2000 17:31:24 -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 RAA15475
for <metastock@xxxxxxxxxxxxx>; Wed, 2 Feb 2000 17:43:52 -0700 (MST)
Received: from escom ([195.121.223.52]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAB4AC8
for <metastock@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 01:28:04 +0100
Message-ID: <008501bf6ddd$f41cee80$34df79c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Metastock-List" <metastock@xxxxxxxxxxxxx>
Subject: Re: MSNBC's new financial portal
Date: Thu, 3 Feb 2000 00:41:08 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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
Status:
made typos
should be
http://www.dbc.com/cgi-bin/htx.exe/dbcfiles/indext.html?source=blq/schwab
above is 1 full webste-link
(but OE sometimes automaticaly splits the address when it finds a ? question mark)
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Original Message -----
From: A.J. Maas <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: dinsdag 1 februari 2000 22:18
Subject: Re: MSNBC's new financial portal
> Download EOD values
> http://msnbc.com/news/357771.asp?cp1=1
>
> Nice, he?
>
> Regards,
> Ton Maas
> ms-irb@xxxxxxxxxxxxxxxx
> Dismiss the ".nospam" bit (including the dot) when replying.
> Homepage http://home.planet.nl/~anthmaas
>
>
> ----- Original Message -----
> From: Frans Derksen <derksenf@xxxxxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: maandag 31 januari 2000 7:24
> Subject: Re: MSNBC's new financial portal
>
>
> > Hallo Anton,
> >
> > Bedankt.
> > Heb hier de 30-year Treasury(long)Bond gevonden en zo te zien REAL TIME !!!.
> >
> > Groetend,
> > Frans
> >
> > At 17:39 29-1-2000 +0100, you wrote:
> > >http://msnbc.com/modules/commerce/personalfinance/investment_portal.asp
> > >
> > >Regards,
> > >Ton Maas
> > >ms-irb@xxxxxxxxxxxxxxxx
> > >Dismiss the ".nospam" bit (including the dot) when replying.
> > >Homepage http://home.planet.nl/~anthmaas
> > >
> > >
> > >
> > >
> > >
> >
> >
>
|