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

Importing symbols using ASCII



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.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Good afternoon everyone:</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; At 
the risk of revealling my stupidity I am turning to the list for help after 
trying everything else.</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; My 
dilemma&nbsp; is this:&nbsp;&nbsp; I would like to import a list of symbols 
compiled in EXCEL into a Metasock data folder. As I understand it if the symbol 
does not exist already MS  will ask me if I want to create one. This is assuming 
the convert utility can read my import file.</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I 
tried to dummy up the data file as follows and save it in comma delimited text 
(which I assume to be *.prn.)</FONT></DIV>
<DIV><FONT face=Arial 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
(ticker,per,date,close,vol)</FONT></DIV>
<DIV><FONT face=Arial 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
ABGX,D,2/12/00,135.00,10000&nbsp;</FONT><FONT face=Arial 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I 
have about 300 symbols to which i assigned the same data(just so the symbol is 
read). No matter what format I save the Excel file in the convert can't see the 
file.</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If 
anyone has any input  I'd appreciated it. Any answers privately or to the list 
are welcome.</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks a bunch,</FONT></DIV>
<DIV><FONT face=Arial size=2>Paula Petersen</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Sun Feb 13 08:27:19 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 HAA23694
	for <neal@xxxxxxxxxxxxx>; Sun, 13 Feb 2000 07:29:19 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id GAA15037
	for metastock-outgoing; Sun, 13 Feb 2000 06:42:39 -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 GAA15034
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sun, 13 Feb 2000 06:42:36 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id GAA23754
	for <metastock@xxxxxxxxxxxxx>; Sun, 13 Feb 2000 06:55:54 -0700 (MST)
Received: from escom ([195.121.222.237]) by smtp02.wxs.nl
          (Netscape Messaging Server 3.61)  with SMTP id AAA31BF;
          Sun, 13 Feb 2000 14:39:39 +0100
Message-ID: <008701bf7628$336fd640$LocalHost@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Manoj P Abraham" <manopab@xxxxxxxxxxxxxxx>
Cc: "Metastock-List" <metastock@xxxxxxxxxxxxx>
References: <06ac01bf74f9$7200d880$2edb79c3@xxxxx> <004601bf7530$942cb0a0$11e1d4d2@xxxxxxxxxxx>
Subject: Re: Software for retrieving data from yahoo.com
Date: Sun, 13 Feb 2000 14:23:48 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: multipart/related;
	type="multipart/alternative";
	boundary="----=_NextPart_000_006E_01BF762D.F1A6A760"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
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=utf-8" http-equiv=Content-Type>
<META content="MSHTML 5.00.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>I haven't got around to put the program on my Homepage yet. 
So, I h</FONT><FONT size=2>ave printed part of an older</FONT></DIV>
<DIV><FONT size=2>mail on this subject, eg see down below.</FONT></DIV>
<DIV><BR><FONT size=2>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&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT>
<DIV><FONT size=2>From: Manoj P Abraham</FONT></DIV>
<DIV><FONT size=2>To: &lt;<A 
href="mailto:ms-irb@xxxxxxxxx";>ms-irb@xxxxxxxxx</A>&gt;</FONT></DIV>
<DIV><FONT size=2>Sent: zaterdag 12 februari 2000 9:09</FONT></DIV>
<DIV><FONT size=2>Subject: Ref: Software for retrieving data from 
yahoo.com</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>&gt; U once mentioned a software which can retrieve quote data 
from<BR>&gt; quote.yahoo.com.<BR>&gt; Can u give me the link once again<BR>&gt; 
<BR>&gt; Manoj P Abraham<BR>&gt; <BR>&gt; <BR>&gt;</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>
<DIV><FONT size=2><A 
href="http://www.beurs.nl/fibbs/help.shtml";>http://www.beurs.nl/fibbs/help.shtml</A></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>Click the&nbsp;</FONT><FONT size=2><A 
href="http://www.beurs.nl/fibbs/help.shtml#QuoteManager";><STRONG>QuoteManager</STRONG></A>&nbsp; 
<FONT size=2><STRONG>(26/04/99) </STRONG></FONT></FONT><FONT size=2><FONT 
size=2>link </FONT></FONT><FONT size=2>and it will get you to the 
QM-section.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Security names can 
be searched for at: <STRONG><A 
href="http://quote.yahoo.com/l";>http://quote.yahoo.com/l</A></STRONG></FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Do you 
have&nbsp;ideas&nbsp;to improve this&nbsp;program or questions&nbsp;email: <A 
href="mailto:info@xxxxxxxxx";><STRONG>info@xxxxxxxxx</STRONG></A></FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Program 
will work under Win98 (and WinNT4.0, I believe...) </DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>The Download link (see <STRONG>Download</STRONG>!&nbsp;below) 
doesn't work anymore, so best is to send them an email.</FONT></DIV>
<DIV><FONT size=2>If they haven't got the program available anymore, than I can 
always send you one from&nbsp;my disk-zips.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>It works by providing the tickers "separated by spaces", and 
it will store data to an ASCII-file(PRN)</FONT></DIV>
<DIV>in MetaStock format<FONT size=2>. I think you will have to put a ASCII 
header&nbsp;on the 1st line, to let the Downloader</FONT></DIV>
<DIV><FONT size=2>know what the files contents are.</DIV>
<P><STRONG>Download</STRONG>!</P>
<P align=center><IMG align=baseline alt="" border=0 hspace=0 
src="cid:006d01bf7625$8fda9e40$LocalHost@xxxxx";></P></FONT>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>Also there is&nbsp;the StockBrowser-program (by Ivo van 
Thiel)</FONT></DIV>
<DIV><FONT size=2><A 
href="http://www.xs4all.nl/~ithiel/download/stockv1_99d.exe";>http://www.xs4all.nl/~ithiel/download/stockv1_99d.exe</A></FONT></DIV>
<DIV><FONT size=2>(note that the link might be a bit outdated, eg do an AV 
(AltaVista)-search). </FONT></DIV>
<DIV></FONT>&nbsp;</DIV></DIV></BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\qmanager.gif"