|
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>
<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>Q6. </STRONG></FONT>I now desire
to create an Excel spreadsheet <FONT face=Arial size=2>to calculate future
numbers. I should decide if</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial size=2> I need
to OLE link for my </FONT><FONT face=Arial size=2>data or create new ASCII data
files. I don't need to plot these</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Arial size=2> numbers
on a chart....just calculate </FONT><FONT face=Arial size=2>them from the 4 most
recent bars.</FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </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</FONT></DIV>
<DIV><FONT size=2>and Equis web-sites </FONT><FONT size=2>and in both
programs manuals and build-in Help files.</FONT></DIV>
<DIV><FONT size=2>
<DIV><FONT size=2>{read for workbook also spreadsheets</FONT></FONT><FONT
size=2>}</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>For any Linked spreadsheet you can always obtain to choose to
Save (As), for instance to</FONT></DIV>
<DIV><FONT size=2>a now other Linked </FONT><FONT size=2>or non-Linked
spreadsheet or to an </FONT><FONT size=2>ASCII-TXT or </FONT><FONT
size=2>ASCII-PRN file.</FONT></DIV>
<DIV>{use VBA macro's (scripts) in Excel to automate this daily work for
you}.</DIV>
<DIV> </DIV>
<DIV><FONT size=2>For instance for publishing reasons, display the Saved As
ASCII file in Word and/or </FONT><FONT size=2>Paste contents</FONT></DIV>
<DIV><FONT size=2>to the </FONT><FONT size=2>OE-mail program </FONT><FONT
size=2>(or alike programs).</FONT></DIV>
<DIV>{use VB, VBScript or ScriptIt or AutoIt scripts in Windows to automate this
daily work for you}.</DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Whatever you decide, remember that OLE-ing "your future
</FONT><FONT size=2>numbers" will have them </FONT><FONT
size=2>ALWAYS</FONT></DIV>
<DIV><FONT size=2>"automaticaly being updated" (see Part1+2 and the other FAQs).
This "automaticaly" here is upose</FONT></DIV>
<DIV><FONT size=2>to </FONT><FONT size=2>your creating </FONT><FONT size=2>new
ASCII data files "every workday and manualy" using the MSK's Convert
Tool.</FONT></DIV>
<DIV> </DIV></DIV></DIV>
<DIV><FONT size=2> </DIV>
<DIV></FONT></FONT>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> </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>
Adam Hefner
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> donderdag 3 februari 2000
4:18</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> 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></BODY></HTML>
</x-html>From ???@??? Thu Feb 03 17:15:23 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 RAA22494
for <neal@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 17:57:14 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id QAA17376
for metastock-outgoing; Thu, 3 Feb 2000 16:17:10 -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 QAA17373
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 3 Feb 2000 16:17:06 -0700
Received: from hme0.mailrouter02.sprint.ca (hme0.mailrouter02.sprint.ca [207.107.250.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id QAA16202
for <metastock@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 16:29:38 -0700 (MST)
Received: from default (spc-isp-ott-uas-23-4.sprint.ca [209.148.160.105])
by hme0.mailrouter02.sprint.ca (8.8.8/8.8.8) with SMTP id SAA07323
for <metastock@xxxxxxxxxxxxx>; Thu, 3 Feb 2000 18:14:10 -0500 (EST)
Message-ID: <006001bf6e9c$deca0bc0$69a094d1@xxxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
References: <LMBBKJCLKIJIBBJLAEIJMENLCNAA.nkormanik@xxxxxxxxxx>
Subject: Re: Stuff and scaling
Date: Thu, 3 Feb 2000 18:16:33 -0500
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_0059_01BF6E72.CD4BFEA0"
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: O
Hi Nick
No problem.
To others that wrote ... here's a shortened version of a seasonality chart
produced with Demetra and charted in Excel.
The vertical scale is ordinal. A number with no seasonality will have a
divisor of 1.00 = 100%. Seasonally-weak values have divisors of less than
1.00, and seasonally-strong numbers have values greater than 1.00.
This chart uses monthly data but weekly and daily data can be used, i.e, for
inter-week seasonality.
Best regards
Walter
----- Original Message -----
From: "Nicholas Kormanik" <nkormanik@xxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, February 03, 2000 3:12 PM
Subject: RE: Stuff and scaling
| Walter,
|
| Thanks for the www.olsen.ch url. Lot of interesting stuff there!
|
| Nicholas
|
|
|
Attachment Converted: "f:\eudora\attach\SeasonalFactors.gif"
|