|
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>Q1. </STRONG></FONT>How d<FONT
face=Arial size=2>o I dynamicaly link a 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></FONT> </DIV>
<DIV><FONT size=2><STRONG>The Excel spreadsheet will only get updated in the
following 3-ways:</STRONG></FONT></DIV>
<DIV><FONT size=2>{read for workbook also spreadsheets}</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>-Standard the Excel program (on Open) will
<STRONG><EM>AUTOMATICALY </EM></STRONG>update any Links to information held in
any other sources</FONT></DIV>
<DIV><FONT size=2> like workbooks and docs.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>-In your Excel program, the Tools|Options|Calculations and
Tools|Options|Edit settings can be set in such a way, that</FONT></DIV>
<DIV><FONT size=2> when Open-ing a workbook, the program
</FONT><FONT size=2>to automatically display a protective friendly dialog
window UPDATE MESSAGE,</FONT></DIV>
<DIV><FONT size=2> eg </FONT><FONT size=2>thus this is in a
(self-set) <STRONG><EM>SEMI-AUTOMATICAL </EM></STRONG>way:</FONT></DIV>
<DIV><FONT
size=2> ------------------------------------------<FONT
size=2> </FONT></FONT></DIV>
<DIV><FONT size=2> "This document contains automatical links to
information in another workbook. Do you want to update this
workbook</FONT></DIV>
<DIV><FONT size=2> with the changes that were made in the
other workbook?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> | If you want to update all the linked
information, click Yes.</FONT></DIV>
<DIV><FONT size=2> | If you want to keep the existing
information, click No."</FONT></DIV>
<DIV><FONT size=2>
------------------------------------------</FONT></DIV>
<DIV><FONT size=2> The Calculations and Edit settings are than as
follows:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<STRONG>Calculations:</STRONG></FONT></DIV>
<DIV><FONT size=2>
"Calculations" - check
Automaticaly</FONT></DIV>
<DIV><FONT size=2>
"Iterations"
- uncheck</FONT></DIV>
<DIV><FONT size=2> "Workbookoptions"
- check Update external links</FONT></DIV>
<DIV><FONT size=2>
- check Save external linksvalues</FONT></DIV>
<DIV><FONT size=2>
-
check Accept labels in formulas
</FONT></DIV>
<DIV><FONT size=2>
<STRONG>Edit: </STRONG></FONT></DIV>
<DIV><FONT size=2>
"Settings" -
check Objects with cells cut, copy and sort</FONT></DIV>
<DIV><FONT size=2>
- check Confirm updating automatic links</FONT></DIV>
<DIV><FONT size=2>
{see manual or click "?" for more info on the other settings}</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>-And <STRONG><EM>MANUAL </EM></STRONG>if in your Excel
program an already Open-ed workbook contains any Links to sources,
that you want updated</FONT></DIV>
<DIV><FONT size=2> or that have changed, eg that now needs to be
MANUALY updated:</FONT></DIV>
<DIV><FONT size=2> -On the WorkMenu</FONT></DIV>
<DIV><FONT size=2> -Click
Edit</FONT></DIV>
<DIV><FONT size=2> -Click
Links</FONT></DIV>
<DIV><FONT size=2> -In the Links window</FONT></DIV>
<DIV><FONT size=2> -Blue Select the
linked source (indicator/object) that you want to update your workbook
with</FONT></DIV>
<DIV><FONT size=2> -Optionaly check
the radio button for (future) Automatic updating or Manual
updating</FONT></DIV>
<DIV><FONT
size=2>
{click "?" for more info on the window/settings/options/commands)</FONT></DIV>
<DIV><FONT size=2> -Click Update
now</FONT></DIV>
<DIV><FONT size=2> -Click Ok to keep the changes</FONT></DIV>
<DIV><FONT size=2> or</FONT></DIV>
<DIV><FONT size=2> -Click Close to keep your original
workbook's values</FONT></DIV>
<DIV><FONT size=2> </FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><STRONG>Q2.
</STRONG></FONT>How does the MetaStock program handle source changes in Excel,
that are Linked to a Chart/Smart Chart/Layout?</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><STRONG>MANUAL or AUTOMATICAL settings in
MetaStock are not available</STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>-Standard on Open-ing, Metastock will always
<STRONG>AUTOMATICALY </STRONG>update the Links</FONT></DIV>
<DIV><FONT size=2>-Once a Security is opened + displayed, any changes made in
the source workbook, will also be<STRONG>
AUTOMATICALY </STRONG>updated</FONT></DIV>
<DIV><FONT size=2> and reflected in the displayed Link-ed object (your
indicator) </FONT></DIV>
<DIV><FONT size=2>-Once a Security is opened, you can also RightClick for the
Small Context Menu, to have a Link <STRONG>MANUALY </STRONG>be Updated,
eg</FONT></DIV>
<DIV><FONT size=2> click Update Link. </FONT> </DIV>
<DIV><BR> </DIV>
<DIV><FONT size=2>Ciao,</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 ???@??? Tue Feb 01 17:49:20 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 SAA19862
for <neal@xxxxxxxxxxxxx>; Tue, 1 Feb 2000 18:45:41 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA01413
for metastock-outgoing; Tue, 1 Feb 2000 17:50:05 -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 RAA01406
for <metastock@xxxxxxxxxxxxxxxxxx>; Tue, 1 Feb 2000 17:50:01 -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 SAA14768
for <metastock@xxxxxxxxxxxxx>; Tue, 1 Feb 2000 18:02:21 -0700 (MST)
Received: from escom ([195.121.223.65]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAA5940
for <metastock@xxxxxxxxxxxxx>; Wed, 2 Feb 2000 01:46:28 +0100
Message-ID: <00ef01bf6d17$5c1022e0$b2dd79c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <389717CF.3D85AAF6@xxxxxxxxx>
Subject: Re: ASCII to Metastock file data transfer
Date: Wed, 2 Feb 2000 01:46:04 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-7"
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:
On this do not listen to what Equis tells you to use in the manual, eg use the
correct Millenium proof ASCII file header {without any quotation marks}
<ticker>,<per>,<ddyyyymmdd>,<open>,<high>,<low>,<close>,<volume>,<o/i>
BNTI,D,990129,0.230,0.260,0.220,0.240,20250,0
BNTI,D,990201,0.240,0.240,0.220,0.220,23300,0
BNTI,D,990202,0.250,0.260,0.240,0.240,48500,0
Change is in the <date> column header, which latter style, I believe, stems from the
ancient DL1.x version and that never got (properly) adjusted in the DL-manual,
manual that needs a good overhaul............
Also for Destination File path, either use
-the Browse button to MANUALY select the folder(file)
or
-put the "long path+file name" in between the in Windows often required quotation marks
so the "Long filename"-format translation for DOS file names is used, eg remeber that
the Downloader is basicaly still a 'covered' DOS program,
program that needs a good overhaul..........
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Original Message -----
From: Zarifis Dimitroulis <zarifis@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: dinsdag 1 februari 2000 18:28
Subject: ASCII to Metastock file data transfer
> Hello all
>
> I have been trying to convert an ASCII file to Metastock format and I
> have been having a very hard time, though this may sound a bit strange.
> I am using Metastock 6.51. Please bear with me and if there's a good
> Samaritan I would appreciate a hand.
>
> This is how it is: There is a file named BNTI.TXT
>
> <ticker>,<per>,<date>,<open>,<high>,<low>,<close>,<volume>,<o/i>
> BNTI,D,990129,0.230,0.260,0.220,0.240,20250,0
> BNTI,D,990201,0.240,0.240,0.220,0.220,23300,0
> BNTI,D,990202,0.250,0.260,0.240,0.240,48500,0
>
> I go to The DownLoader->Tools->Convert->
> File Type: ASCII, Text File Name BNTI.TXT
> Destination File Type: Metastock, Folder C:\EQUIS\METASTOCK DATA\TEMP
> --> OK
>
> Then I get: Status conversion Errors occured
>
> Error: #2053 Unable to start new destination file
> Error: #2999 (-367) Unrecognized Error
>
> I played a little with date formats, headers, symbol....Nada...
>
> Any ideas?
>
> Email me privately. Thanks a lot
> Zarifis Dimitroulis
> zarifis@xxxxxxxxx
>
>
>
>
|