[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: rsi in excel



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT size=2><FONT 
size=2><FONT size=2>
<DIV><FONT size=2><FONT color=#000000><STRONG>OLE between MSK+Excel 
(+v.v.)&nbsp; -&nbsp;&nbsp;FAQ's&nbsp; </STRONG>{where linking a plotted 
indicator(object) meets (=same as) linking the Base 
security}</FONT></FONT></DIV>
<DIV><FONT color=#000000 
size=2>-----------------------------------------------------------------</FONT></FONT></FONT></FONT></FONT></FONT></FONT><FONT 
size=2><FONT size=2><FONT 
color=#0000ff><STRONG></DIV></DIV></STRONG></FONT></FONT></FONT>
<DIV><FONT size=2><FONT size=2><FONT 
color=#0000ff><STRONG></STRONG></FONT></FONT></FONT>&nbsp;</DIV>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><STRONG>Q10. 
</STRONG></FONT><FONT color=#000000>H</FONT><FONT size=2>ow to set up an Excel 
spreadsheet that can import&nbsp;MetaStock data and calculate&nbsp;the 
RSI&nbsp;(with varying periods)?</FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2>&nbsp;</DIV>
<DIV><FONT size=2>-for preceeding OLE info refer to: 
<DIV>&nbsp;"The&nbsp;OLE (part 1+2) and ASCII (Converting from MetaStock to 
ASCII) instructions&nbsp;+&nbsp;all&nbsp;other&nbsp;FAQ's (Q1 - Q9)&nbsp;on 
the</DIV>
<DIV>&nbsp;&nbsp;****OLE-linking between MSK and Excel (and vice versa)**** 
subject".</FONT><BR><FONT size=2>-once OLE-linked data has been (see 
Part1)&nbsp;split out over several columns, its ready for further molding 
(manipulating&amp;adjusting).</DIV></FONT>
<DIV>-find below a few&nbsp;weblinks for&nbsp;(among other indicators) the RSI 
and Stochastics for Excel.</DIV>
<DIV>&nbsp;</DIV></FONT></FONT><FONT size=2><FONT size=2></DIV></FONT></FONT>
<DIV><FONT size=2><FONT face="Times New Roman" 
size=2>-------------------------------------------------</FONT></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2><A href="http://www.xltrade.net/articles/a101999.html"; ?><FONT 
size=3><STRONG>Oscillators Revisited: The Stochastics 
Function</STRONG></FONT></A></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2><I><FONT size=-1>Demonstrates how to write 
XLTrade(TM)-compatible functions for the raw K, fast K and slow K 
values</FONT></I></FONT></DIV>
<DIV><FONT size=2><I><FONT size=-1>and demonstrates their use in an example 
trading system. Oct. 19, 1999.</FONT></I></FONT></DIV><FONT size=2><B>
<P><A href="http://www.xltrade.net/articles/a92999.html";><FONT size=3>Coding 
Oscillators: The Relative Strength Index</FONT></A></B><I><FONT 
size=-1></FONT></I></P>
<P><FONT size=-1><EM>Explains the basics of oscillators as analysis tools and 
shows how to program the RSI in VBA for<BR>use </EM></FONT><FONT 
size=-1><EM>with XLTrade(TM). Sept. 29, 1999.</EM></FONT></FONT><BR><FONT 
size=2></FONT></P>
<P><FONT 
size=2>-------------------------------------------------</FONT></P><FONT 
size=2><FONT color=#000000 size=3>
<P><A href="http://www.winsite.com/win95/excel/index.html";><STRONG>WinSite 
Windows 95 Archive - Microsoft Excel Files</STRONG></A></P></FONT></FONT><FONT 
size=2><FONT color=#000000 size=2>
<P align=left>For&nbsp;a full list of available AddIns, 
eg&nbsp;below&nbsp;TANLY32.zip and TECHANLY.zip are available.</P>
<P align=left><A 
href="http://www.winsite.com/info/pc/win95/excel/tanly32.zip";><STRONG><FONT 
size=3>TANLY32 Excel Addin (tanly32.zip - v7.0) by FIS 
Ltd.&nbsp;</FONT></STRONG></A></P>
<P align=left>A comprehensive suite of technical analysis models. Models 
include:<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Regular Moving 
Average<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Exponential Moving 
Average<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Weighted Moving 
Average<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Relative Strength 
Index<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Percentage Range<BR>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-Momentum<BR>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-Oscillators<BR>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-Stochastics<BR>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-Ratios<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Standard 
Deviation<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;-Correlation<BR>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;-On Balance Volume</P>
<P align=left>The TANLY32 AddIn costs: $&nbsp;49.50 (US Dollars)&nbsp;or&nbsp;£ 
30.00 (English Pounds Sterling).</P>
<P align=left></FONT></FONT><FONT size=2>Regards,<BR>Ton Maas<BR></FONT><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT 
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>Dismiss the ".nospam" 
bit (including the dot) when replying.<BR>Homepage&nbsp; </FONT><A 
href="http://home.planet.nl/~anthmaas";><FONT 
size=2>http://home.planet.nl/~anthmaas</P></FONT></A>
<DIV><FONT size=2>===============================================</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT></DIV>
<DIV><FONT size=2>From: "Michael Gilbert" &lt;</FONT><A 
href="mailto:tradermike@xxxxxxxxxxxxxxxx";><FONT 
size=2>tradermike@xxxxxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;</FONT></DIV>
<DIV><FONT size=2>To: &lt;</FONT><A href="mailto:metastock@xxxxxxxxxxxxx";><FONT 
size=2>metastock@xxxxxxxxxxxxx</FONT></A><FONT size=2>&gt;</FONT></DIV>
<DIV><FONT size=2>Sent: zondag 20 februari 2000 2:48</FONT></DIV>
<DIV><FONT size=2>Subject: rsi in excel</FONT></DIV>
<DIV><FONT size=2><BR></FONT></DIV>
<P><FONT size=2>&gt; Anyone care to show me how to set up an excel spread sheet 
that can import<BR>&gt; metastock data and calculate<BR>&gt; rsi with varying 
periods. I am attempting to create a what-if? spread sheet<BR>&gt; where I can 
calculate what close<BR>&gt; would be needed to equal a certain rsi 
value.<BR>&gt; thank you<BR>&gt; <BR>&gt; </FONT></P></BODY></HTML>
</x-html>From ???@??? Sun Feb 20 11:40:34 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.9.3/8.9.3) with ESMTP id MAA12805
	for <neal@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 12:54:38 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id LAA05552
	for metastock-outgoing; Sun, 20 Feb 2000 11:56:20 -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 LAA05549
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 20 Feb 2000 11:56:17 -0700
Received: from mail.rdc2.bc.home.com (ha2.rdc2.bc.wave.home.com [24.2.10.69])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id MAA29497
	for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 12:10:26 -0700 (MST)
Received: from home.com ([24.65.16.176]) by mail.rdc2.bc.home.com
          (InterMail v4.01.01.00 201-229-111) with ESMTP
          id <20000220185448.KPH6486.mail.rdc2.bc.home.com@xxxxxxxx>
          for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 10:54:48 -0800
Message-ID: <38B03855.C82B0F54@xxxxxxxx>
Date: Sun, 20 Feb 2000 10:54:13 -0800
From: HHP <hhp@xxxxxxxx>
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: metastock@xxxxxxxxxxxxx
Subject: [Fwd: Metastock CD Check]
Content-Type: multipart/mixed;
 boundary="------------E5A57DEBBD3E0C714B351C8E"
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

Second attempt.  First one didn't get through.  Wonder why?

HHPX-Mozilla-Status2: 00000000
Message-ID: <38AF99CF.7B9E8956@xxxxxxxx>
Date: Sat, 19 Feb 2000 23:37:51 -0800
From: HHP <hhp@xxxxxxxx>
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: metastock@xxxxxxxxxxxxx
Subject: Re: Metastock CD Check
References: <002a01bf7af7$f68056e0$0101010a@xxxxxxxxxxxxx> <38AEFB86.24343215@xxxxxxxxxxxxx> <20000219220437.46983.qmail@xxxxxxxxxxx>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I've had the same thing.  It is probably a form of piracy prevention and
if so will keep recurring.  It is really annoying.  Big Brother is
watching you.  Any prospective purchasers of ver. 7 should expect this. 
It gives you a week to comply before the program becomes inoperative. 
What happens to someone travelling with a lap-top?

HHP
========================

> Eric Duchesne wrote:
> 
> I am sorry to ask you this again, but i just try to open Metastock and
> it ask me to put the cd for a check up. Unfortunatly, i can not find
> it again. I try with an older version of it, but no luck.
> 
> If my memory still ok there were someone asking the same question few
> days ago. COuld you send me the email again.
> 
> Thank you
> 
> 
> eric
> ericduchesne@xxxxxxxxxxx