|
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.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Ton,</FONT></DIV>
<DIV><FONT face=Arial size=2> Thank you for all of the
good explanations. I now desire to create an Excel spreadsheet </FONT></DIV>
<DIV><FONT face=Arial size=2>to calculate future numbers. I will sort thru all
of your e-mails and decide If I need to OLE link for my</FONT></DIV>
<DIV><FONT face=Arial size=2>data or create new ASCII data files. I don't need
to plot these numbers on a chart....just calculate </FONT></DIV>
<DIV><FONT face=Arial size=2>them from the 4 most recent
bars. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks again!</FONT></DIV>
<DIV><FONT face=Arial size=2> Adam</FONT> </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"><B>From:</B>
A.J. Maas
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A href="mailto:galantit@xxxxxx";
title=galantit@xxxxxx>Tommaso Galanti</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>Metastock-List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, February 02, 2000 5:02
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Excel & Metastock -
Using Calcs From Metastock</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Feb 03 08:17:08 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 BAA21430
for <neal@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 01:58:56 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id BAA11239
for metastock-outgoing; Thu, 3 Feb 2000 01:03:39 -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 BAA11236
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 3 Feb 2000 01:03:37 -0700
Received: from mercury.shreve.net (root@xxxxxxxxxxxxxxxxxx [208.206.76.23])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id BAA15718
for <metastock@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 01:16:07 -0700 (MST)
Received: from al-tag (shv6-163.shreve.net [208.249.213.163])
by mercury.shreve.net (8.9.3/8.9.3) with ESMTP id CAA28949
for <metastock@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 02:00:48 -0600
Message-Id: <200002030800.CAA28949@xxxxxxxxxxxxxxxxxx>
From: "Al Taglavore" <altag@xxxxxxxxxx>
To: "MetaStock List Group" <metastock@xxxxxxxxxxxxx>
Subject: QP2 data problem
Date: Thu, 3 Feb 2000 02:02:01 -0600
X-MSMail-Priority: Normal
X-Priority: 3
X-Mailer: Microsoft Internet Mail 4.70.1155
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
I am still plagued with data conversion problems. A new one arose tonight.
I downloaded as usual the Quotes Plus 2 data, the file was unzipped and
the data converted and entered into my MetaStock Downloader (ver 6.52).
However, when I attempted to view a chart, there was no 2/2/00 data. The
data is in correct order in the Quotes Plus charts. I opened my Downloader
datapane, and the data for different issues shows different (mostly
5/30/96) dates after the 2/1/00 date. Is anyone else having these problems
with Quotes Plus? I do have the qp_Meta.exe ver 1/10/2000.
Al Taglavore
|