|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial
size=2>Adam!</FONT></SPAN></DIV>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial size=2>I have
been tracking this contract for a long time using @:SPc1 using Reuters Datalink.
It is also SPc1 on the Reuters RT platform.</FONT></SPAN></DIV>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial size=2>Best
regards,</FONT></SPAN></DIV>
<DIV><SPAN class=550095912-18031999><FONT color=#0000ff face=Arial
size=2></FONT></SPAN><SPAN class=550095912-18031999><FONT color=#0000ff
face=Arial size=2>Yngvi</FONT></SPAN></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B>
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]<B>On
Behalf Of</B> Adam Hefner<BR><B>Sent:</B> 18. mars 1999 03:00<BR><B>To:</B>
MetaStock<BR><B>Subject:</B> Symbol question:<BR><BR></FONT></DIV>
<DIV><FONT size=2>This may be a stupid question.......but I need some
enlightenment.</FONT></DIV>
<DIV><FONT size=2>I have been tracking the S&P 500 with the symbol :
<STRONG>@:SPC1#1 </STRONG></FONT></DIV>
<DIV><STRONG><FONT size=2></STRONG>This is a continuous contract downloaded
with futures data. Since the</FONT></DIV>
<DIV><FONT color=#000000 size=2>5th of the month this symbol has not been
valid, but the individual (monthly) </FONT></DIV>
<DIV><FONT color=#000000 size=2>contracts created from this symbol are still
valid. I have been waiting for an updated</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT><FONT size=2>symbols file from
MetaStock. My question is, has this symbol been renamed or do I</FONT></DIV>
<DIV><FONT size=2>have a different problem?</FONT></DIV>
<DIV><BR> Best wishes,<BR> Adam
Hefner.<BR>VonHef@xxxxxxxxxxxxx
</DIV>
<DIV> </DIV>
<DIV>---------------------------------------</DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Mar 18 06:37:59 1999
Received: from listserv.equis.com (204.246.137.2)
by mail05.rapidsite.net (RS ver 1.0.2) with SMTP id 22712
for <neal@xxxxxxxxxxxxx>; Thu, 18 Mar 1999 09:26:46 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id VAA29008
for metastock-outgoing; Thu, 18 Mar 1999 21:50:18 -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 VAA29004
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 18 Mar 1999 21:50:15 -0700
Received: from alpha.hhe.adelphia.net (alpha.hhe.adelphia.net [24.48.27.2])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id GAA08145;
Thu, 18 Mar 1999 06:48:47 -0700 (MST)
Received: from dingo (surf129.hhe.adelphia.net [24.48.27.129])
by alpha.hhe.adelphia.net (8.9.0.Beta5/8.9.0.Beta5) with SMTP id IAA17649;
Thu, 18 Mar 1999 08:37:24 -0500 (EST)
From: "Dale Wingo" <dingo@xxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>, <metastock-list@xxxxxxxxxxxxx>
Subject: RE: Additional Question (was Launching Excel from Netscape)
Date: Thu, 18 Mar 1999 08:37:11 -0500
Message-ID: <000c01be7144$6d24ddc0$811b3018@xxxxxxxxxxxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
In-Reply-To: <01J8Z7MQFKD800G566@xxxxxxxxxxxx>
Importance: Normal
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-Loop-Detect: 1
X-UIDL: c55a754c8c4de4c166b23c833044ec6c.01
Try this one:
http://quote.yahoo.com/d/ALL.csv?s=^xcd+^dji+^spx+CHV+GM+IP+&f=sl1dd1&;
e=.csv
I added the d1
Per a message I posted yesterday:
Below is a string and the code definitions I've solved so far:
Historical quotes + ask if save to disk.
http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d
&q=q&y=0&z=ge&x=.csv
Historical quotes + Don't Ask
http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d
&q=q&y
Multiple Quotes + ask if save to disk.
http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sl1d1t1c1ohgv&e=.cs
v
Multiple Quotes + Don't Ask
http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sl1d1t1c1ohgv
/d = download
?s = symbol list follows
&f = format codes follow
format codes:
s = symbol
l = last trade time and price
l1 = last price only
d = dividend
d1 = date
t1 = time of last trade
c = price change in points & percent
c1 = price change points only
o = open price
h = high
g = low
v = volume
v1 = value
&e=.csv apparently means to as if save to disk
Multiple Quotes: Symbol, Date, Open, Hi, Low, Close, Volume
http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v
Now what I'm trying to solve is how to incorporate the above http
strings into a web query that formats the results into the appropriate
columns. If you just take one of the above and make it into a web
query thusly:
WEB
1
http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v
and then load the sheet thru the data/get external data/web query
menu selections the result is a csv all treated as an alfa string in
one column.
Anyone got the magic code to solve this?
Dale
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of
> alberto.villarroel@xxxxxxxxxxxx
> Sent: Thursday, March 18, 1999 7:50 AM
> To: metastock-list@xxxxxxxxxxxxx
> Subject: Additional Question (was Launching Excel from Netscape)
>
>
> I tried how it works to download data with that URL and it
> worked fine.
>
> But what I wonder is, is it possible to get the "date"
> included also from
> Yahoo? This looked like an very easy way to download data
> but I would like
> the "date" included also. Does anyone know that or if there
> is any kind of
> documentation at Yahoo which might adress how the format
> of the "url" is?
>
>
> Thanks
>
> Alberto Villarroel
>
>
> >To all,
> >
> >I have been using Internet Explorer to download the following
> >information from Yahoo:
> >
> >http://quote.yahoo.com/d/ALL.csv?s=^xcd+^dji+^spx+CHV+GM+IP
> +EK+AOL+DELL+WLA+GPS
> +T+BBY+JBHT+LADF+PTX+GTW+LOW+EGG+GGUY+&f=sl1d&e=.csv
> >
> >Using IE it launches an Excel window inside of IE from
> which I can copy
> >and paste into my Excel spreadsheet in Excel.
> >
> >Is there anyway to do this in Netscape. I have version
> 4.05. When I
> >click on the bookmark above it asks me to save it. Then I
> have to open
> >the file in Excel and cut and paste into my spreadsheet.
> >
> >Any suggestions would be welcome.
> >
> >thanks in advance,
> >
> >Ed Middleton
>
|