|
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.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: Samerski, Michael (Australia) <<A
href="mailto:msamerski@xxxxxxxxxxxxxxxxxx";>msamerski@xxxxxxxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: December 14, 1999 10:32 PM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: RE: Volatility</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>> Volatility is the most valuable thing I look
at. I recall that some Market<BR>> Wizards speak very highly of it
also.<BR>> For a simple example, Let's say you beleive that markets swing
from low to<BR>> high vol (not to difficult),<BR>> then placing entry stop
orders either side of vol bands, should get you set<BR>> for a big move
either way.<BR>> But as always, entry is only the tip of the
icecream.<BR>> <BR>> IMHO - The best indicators are Stdev and
ATR.<BR></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Michael and all other repliers
:</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>1) Thanks a
lot.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>2) Michael : Can you
give examples HOW you use Stdev and Average True
Range</EM></STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2> <FONT
color=#008080 size=3><STRONG><EM>of course i know how to plot them but i am
interested in the way you (and others ?)</EM></STRONG></FONT></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>
use them together with other indicators.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>3) In advance : thanks
again.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Theo.</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>
</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>> <BR>> Michael Samerski <BR>>
Metronome Trading Systems Pty Limited <BR>> email : <A
href="mailto:michael@xxxxxxxxxxxxxxxxxxxxxxxx";>michael@xxxxxxxxxxxxxxxxxxxxxxxx</A>
<BR>> www : <A
href="http://www.metronome-trading.com.au";>http://www.metronome-trading.com.au</A><BR>>
<<A
href="http://www.metronome-trading.com.au/";>http://www.metronome-trading.com.au/</A>>
<BR>> <BR>> <BR>> <BR>> <BR>> -----Original
Message-----<BR>> From: Theo E.M. Lockefeer [<A
href="mailto:sky40912@xxxxxxxxx";>mailto:sky40912@xxxxxxxxx</A>]<BR>> Sent:
Tuesday, 14 December 1999 21:09<BR>> To: Metastock User Group<BR>>
Subject: Volatility<BR>> <BR>> <BR>> Can someone give his views on
Volatility :<BR>> <BR>> Succesfull systems implemented ?
Which are good Volatility indicators ? <BR>> <BR>>
<BR>> <BR>> Thx<BR>> <BR>> Theo<BR>>
</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Wed Dec 15 06:24:50 1999
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 FAA24683
for <neal@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 05:05:35 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id TAA03180
for metastock-outgoing; Wed, 15 Dec 1999 19:57:08 -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 TAA03176
for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 15 Dec 1999 19:57:04 -0700
Received: from tank.skynet.be (tank.skynet.be [195.238.2.35])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id EAA08873
for <metastock@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 04:35:33 -0700 (MST)
Received: from SKY40912 (dialup1281.antwerpen.skynet.be [194.78.226.1])
by tank.skynet.be (8.9.3/odie-relay-v1.0) with SMTP id MAA22511
for <metastock@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 12:20:41 +0100 (MET)
Message-ID: <006a01bf46ed$20e78320$01e24ec2@xxxxxxxxx>
From: "Theo E.M. Lockefeer" <sky40912@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <000601bf45fe$585d9140$0200a8c0@xxxxxxx>
Subject: Re: bull/bear fear-retested
Date: Wed, 15 Dec 1999 09:50:05 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0035_01BF46E1.C38AC260"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
<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.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: mikelu <<A
href="mailto:mikelu@xxxxxxxxxxxxxxx";>mikelu@xxxxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: December 14, 1999 7:42 AM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: RE: bull/bear
fear-retested</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>> I'll repost for you with a question.<BR>>
<BR>> Why is BullFear defined as<BR>> <BR>> BullFear := (HHV(HIGH,n) -
LLV(HIGH,n))/2 + LLV(HIGH,n);<BR>> <BR>> instead of just <BR>> <BR>>
BullFear := (HHV(HIGH,n) + LLV(HIGH,n))/2;<BR>> <BR>> as it is in the
magazine?<BR>> <BR>> Mike</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Mike
:</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>sorry but in the magazine i have
it's :</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 +
LLV(HIGH,n);<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Maybe you lost +
LLV(HIGH,n); by accident ?? </EM></STRONG></FONT></DIV>
<DIV><STRONG><EM><FONT color=#008080 face=Arial>( you copied the formula
?)<BR></FONT></DIV></EM></STRONG>
<DIV> </DIV>
<DIV><FONT color=#008080
face=Arial><STRONG><EM>Thanks</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Theo
Lockefeer</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><BR> </DIV></FONT>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><FONT face=Arial size=2>> -----Original Message-----<BR>> From:
<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx</A><BR>>
[<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>mailto:owner-metastock@xxxxxxxxxxxxx</A>]On
Behalf Of michael arnoldi<BR>> Sent: Sunday, November 28, 1999 3:29
AM<BR>> To: A METASTOCK GROUP<BR>> Subject: bull/bear
fear-retested<BR>> <BR>> <BR>> enter long:<BR>> n :=opt2{Time
periods};<BR>> BullFear := (HHV(HIGH,n) - LLV(HIGH,n))/2 +
LLV(HIGH,n);<BR>> Cross(CLOSE,bullfear) AND<BR>> DX(10) > opt1<BR>>
<BR>> close long:<BR>> n :=opt2{Time periods};<BR>> BearFear :=
(HHV(LOW,n) - LLV(LOW,n))/2 + LLV(LOW,n);<BR>> CLOSE < bearfear<BR>>
---------------------------<BR>> i played with the opt1 opt2 on various
indexes & the results were much<BR>> improved. this formula included the
DX portion & mine did not.<BR>> here are some of the results:<BR>>
opt1 opt2 profit
% ttl trades win lose
avg <BR>> djia: 21 4
606.33 60.63
45 28 17
1.399<BR>> xau: 19 6 493.54
49.35 26
12 14 2.55<BR>>
21 4 -68.7
-6.87 40
12 28 2.14<BR>> s&p: 18
4 470.5 47.05
45 25 20
1.6<BR>> 21 4
285.20 28.52
41 24 19
1.23<BR>> i tried the test without the DX & results were real poor, so
the DX is<BR>> an important factor.<BR>> <BR>> mike
arnoldi<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Very interesting Mike :
</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Where and how do you define the
opt1 and 2 ?</EM></STRONG></FONT></DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Can you give an example
?</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Thx</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Theo</EM></STRONG></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT></BODY></HTML>
</x-html>From ???@??? Wed Dec 15 06:24:34 1999
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 DAA22323
for <neal@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 03:03:56 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA02768
for metastock-outgoing; Wed, 15 Dec 1999 17:56:25 -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 RAA02765
for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 15 Dec 1999 17:56:23 -0700
Received: from clayman.opalen.com (clayman.opalen.com [194.16.192.10])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id CAA08816
for <metastock@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 02:34:51 -0700 (MST)
Received: from BASengineering.se
(d212-151-236-145.swipnet.se [212.151.236.145])
by clayman.opalen.com (Post.Office MTA v3.1.2
release (PO205-101c) ID# 0-39853U2500L250S0) with ESMTP id AAA272
for <metastock@xxxxxxxxxxxxx>; Wed, 15 Dec 1999 10:23:18 +0000
Message-ID: <38575D61.D7AAF25B@xxxxxxxxxxxxxxxxx>
Date: Wed, 15 Dec 1999 10:20:34 +0100
From: Lars Andersson <Lars.Andersson@xxxxxxxxxxxxxxxxx>
X-Mailer: Mozilla 4.5 [sv] (WinNT; I)
X-Accept-Language: sv,en
MIME-Version: 1.0
To: metastock@xxxxxxxxxxxxx
Subject: An Excelquestion
References: <199812130220.UAA03291@xxxxxxxxxxxxxxxxxx> <00a001bf464e$aab75c00$6694f5d0@xxxxxx> <009201bf466d$69df88a0$5f1c4118@xxxxxxxxxxxxxxxxxxxxxx>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Hi.
I have a problem when I want to import quotes from Etradeīs website into Excel via an webquery. I must send my Username and
Password but I donīt know how to write the code in VBA for Excel does anyone know how to do that. Here is the code for
importing the website.
URL1="URL;
https://trading.etrade.se:443/cgi-bin/gx.cgi/AppLogic+quoteresearch?EAGetDomesticList1=GO&EAGetDomesticList2=A1
p"
Set tempo = ThisWorkbook.Sheets("MO")
With tempo.QueryTables.Add(Connection:=URL1,
Destination:=tempo.Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
Best regards.
Lars Andersson
|