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

RE: Real Time Data from Excel



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>
<DIV><FONT color=#0000ff><SPAN class=609560516-20042000>
<DIV><FONT size=2><FONT color=#008080><FONT face=Arial><STRONG><EM><SPAN 
class=609560516-20042000></SPAN>&gt;Free for listmembers Peter 
?</EM></STRONG></FONT></FONT></FONT></DIV></SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000>QuoteTracker is free (<A 
href="http://www.quotetracker.com";>www.quotetracker.com</A>) and the Datek 
Streamer is free (www.datek.com) ... so I 
guess the answer is yes!</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000>QuoteTracker has a feature where you can request data 
via http protocol on port 16239 (This is customizable).&nbsp; I have been able 
to get the information into Excel, now I will try to get it into 
MS.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=609560516-20042000>Peter 
Gialames</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=609560516-20042000></SPAN></FONT>&nbsp;</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> 
  owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]<B>On 
  Behalf Of </B>Theo E.M. Lockefeer<BR><B>Sent:</B> Thursday, April 20, 2000 
  5:10 AM<BR><B>To:</B> metastock@xxxxxxxxxxxxx<BR><B>Subject:</B> Re: Real Time 
  Data from Excel<BR><BR></DIV></FONT>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
  <DIV><FONT face=Arial size=2>From: Peter E. Gialames &lt;<A 
  href="mailto:investor@xxxxxxxxxxxxx";>investor@xxxxxxxxxxxxx</A>&gt;</FONT></DIV>
  <DIV><FONT face=Arial size=2>To: &lt;<A 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</FONT></DIV>
  <DIV><FONT face=Arial size=2>Sent: April 19, 2000 11:10 PM</FONT></DIV>
  <DIV><FONT face=Arial size=2>Subject: Real Time Data from 
  Excel</FONT></DIV></DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=Arial size=2>&gt; I know that this has been discussed before 
  but ...<BR>&gt; <BR>&gt; I have MS Pro 6.2 (have only used it for EOD analysis 
  so far) and can<BR>&gt; receive real time data through MS Excel (via VBA app 
  written to translate<BR>&gt; Datek Streamer feed through QuoteTracker - alot 
  of work, but it's free!).</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>Free for listmembers Peter 
  ?</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>Thanks in 
  advance</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 
  face=Arial><STRONG><EM>TheoL</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><BR><FONT face=Arial size=2>&gt; <BR>&gt; How can I get the data from 
  Excel into Metastock?<BR>&gt; <BR>&gt; Thanks in advance,<BR>&gt; Peter 
  Gialames<BR>&gt; <BR>&gt; </FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Apr 20 11:46:47 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 KAA13224
	for <neal@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 10:49:39 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id LAA13675
	for metastock-outgoing; Thu, 20 Apr 2000 11:09:20 -0600
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 LAA13672
	for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 20 Apr 2000 11:09:17 -0600
Received: from apoq.skynet.be (apoq.skynet.be [195.238.2.35])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id LAA10935
	for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 11:21:45 -0600 (MDT)
Received: from SKY40912 (dialup978.antwerpen.skynet.be [194.78.224.210])
	by apoq.skynet.be (Postfix) with SMTP id 7CF081F203
	for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 19:05:26 +0200 (MET DST)
Message-ID: <005801bfaae9$e51c4400$6be24ec2@xxxxxxxxx>
From: "Theo E.M. Lockefeer" <sky40912@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <852568C7.004FC1CD.00@xxxxxxxxxxxxx>
Subject: Re: Real Time Data from Excel
Date: Thu, 20 Apr 2000 19:00:04 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0053_01BFAAFA.A3AAF820"
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 bgColor=#ffffff>
<DIV><FONT color=#008080 face=Arial><STRONG><EM>Thx for the info and let me know 
ok Don ?</EM></STRONG></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#008080 
face=Arial><STRONG><EM>TheoL.</EM></STRONG></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 href="mailto:dllabarre@xxxxxxxxx"; 
  title=dllabarre@xxxxxxxxx>dllabarre@xxxxxxxxx</A> </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> April 20, 2000 4:27 PM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Real Time Data from 
  Excel</DIV>
  <DIV><BR></DIV><BR><BR>List<BR><BR>I'm working on a Visual Basic program to 
  download data from quote.com and/or<BR>yahoo.<BR>The data will be stored as 
  text.&nbsp; You will have to convert it to metastock using<BR>the 
  downloader.<BR>It works very smooth in my testing so far.<BR><BR>Don<BR>Web 
  Developer<BR>Visual Basic Programmer<BR><A 
  href="http://www.u2ecom.com";>www.u2ecom.com</A><BR><A 
  href="http://www.cedarcreektrading.com";>www.cedarcreektrading.com</A><BR><BR><BR><BR><BR><BR><BR><BR>"Theo 
  E.M. Lockefeer" &lt;sky40912@xxxxxxxxx&gt; on 04/20/2000 05:09:51 
  AM<BR><BR>Please respond to metastock@xxxxxxxxxxxxx<BR><BR>To:&nbsp;&nbsp; 
  metastock@xxxxxxxxxxxxx<BR>cc:&nbsp;&nbsp;&nbsp; (bcc: Donald L. 
  LaBarre)<BR>Subject:&nbsp; Re: Real Time Data from 
  Excel<BR><BR><BR><BR><BR><BR>----- Original Message -----<BR>From: Peter E. 
  Gialames &lt;investor@xxxxxxxxxxxxx&gt;<BR>To: 
  &lt;metastock@xxxxxxxxxxxxx&gt;<BR>Sent: April 19, 2000 11:10 PM<BR>Subject: 
  Real Time Data from Excel<BR><BR><BR>&gt; I know that this has been discussed 
  before but ...<BR>&gt;<BR>&gt; I have MS Pro 6.2 (have only used it for EOD 
  analysis so far) and can<BR>&gt; receive real time data through MS Excel (via 
  VBA app written to translate<BR>&gt; Datek Streamer feed through QuoteTracker 
  - alot of work, but it's free!).<BR><BR>Free for listmembers Peter 
  ?<BR><BR>Thanks in advance<BR><BR>TheoL<BR><BR><BR>&gt;<BR>&gt; How can I get 
  the data from Excel into Metastock?<BR>&gt;<BR>&gt; Thanks in advance,<BR>&gt; 
  Peter Gialames<BR>&gt;<BR>&gt;<BR></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Apr 20 11:46:43 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 KAA12841
	for <neal@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 10:43:47 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id LAA13693
	for metastock-outgoing; Thu, 20 Apr 2000 11:11:54 -0600
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 LAA13689
	for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 20 Apr 2000 11:11:51 -0600
Received: from cypher.turbonet.com (cypher.turbonet.com [204.188.48.1])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id LAA10939
	for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 11:24:21 -0600 (MDT)
Received: from [204.188.49.180] by cypher.turbonet.com (NTMail 5.00.0010/NT0409.00.9cd4ce09) with ESMTP id vbtqfaaa for <metastock@xxxxxxxxxxxxx>; Thu, 20 Apr 2000 10:16:25 -0700
Message-ID: <004a01bfaaeb$27adc7c0$b431bccc@xxxxxxx>
From: "Steve Karnish" <kernish@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <001601bfaa4f$da950200$786fa8c0@xxxxx> <000e01bfaa67$8b26ea40$c931bccc@xxxxxxx> <001e01bfaacc$9c3da840$d92467d1@xxxxxxx>
Subject: Re: KW0K/KW0N
Date: Thu, 20 Apr 2000 10:09:13 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

Walter,

I way too much of an idiot to figure out the internal goals of the
commercials.  I could guess about what "flat price volume" is, but quite
frankly it would be pure, dare I say: "speculation".  "Fun-DAH-mental-ly" I
have the knowledge of a third grader (and some 8 year olds, born into farm
families, probably have a better understanding).  I guess this is all easy
to rationalize by saying that all fundamentals end up in the price.  I've
traded stocks for years by the "symbols" and couldn't even tell you what
many of the companies do to create revenue.  Give me the price history and
I'll render an opinion.  Over the years, "thinking"
has gotten me into a lot of trouble.  So, sorry I can't answer your
question.  You still haven't told me:  what do you think of long wheat,
short corn.  I currently have my largest spread position in twenty five
years.  Am I going to have to slap Dick Gephardt around to make sure that
China gets favored trade status.  I understand that the largest wheat
growing area in China is currently at 9% of normal measurable precipitation.
Any thoughts are welcome.

Take care,

Steve Karnish
Cedar Creek Trading
http://www.cedarcreektrading.com
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, April 20, 2000 6:30 AM
Subject: KW0K/KW0N


> Hi Steve
>
> In the KC wheat markets, I know that most of the spread activity is in
> rolling May positions into July.
>
> But, why would FIMAT put on 500 K/N bull spreads and then turn right
around
> and put on 600 bear spreads N/K all in the same day?
>
> Also ... do you know what "flat price volume" is?
>
> Thanks for your help.
>
> Best regards
>
> Walter
>
> ----- Original Message -----
> From: Steve Karnish
> To: metastock@xxxxxxxxxxxxx
> Sent: Wednesday, April 19, 2000 9:27 PM
> Subject: Re: (Market) Jul Corn
>
>
> Adam,
>
> Although all the "troops" are in May, I would be a seller of July on a
close
> above 287.75.  Also, take a hard look at the wheat/corn spread (basis
July)
> under 30 cents.  It has a bunch of potential.  I put a bunch on at 27.25
> today.  Could be a big "wiener".
>
> Take care,
>
> Steve Karnish
> Cedar Creek Trading
> http://www.cedarcreektrading.com
>
>
> ----- Original Message -----
> From: Adam Hefner
> To: metastock@xxxxxxxxxxxxx
> Sent: Wednesday, April 19, 2000 3:34 PM
> Subject: (Market) Jul Corn
>
>
>
> Since corn has reversed back up and remaining in the congestion area I
will
> exit the corn sell signal tomorrow with a MIT
> at 235.1 (provided that is hit before my buy stop at 239.5). Not sure this
> is the best way to handle it but if my MIT is hit
> I will take a little .05 cent loss, if my stop is hit..a 5 cent loss.
> Comments anyone?
>     Adam
>
>