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

Re: [amibroker] importing xls into watch groups



PureBytes Links

Trading Reference Links

Steve



----- Original Message ----- 
From: David Holzgrefe 
To: amibroker@xxxxxxxxxxxxxxx 
Sent: Thursday, 7 June 2001 10:39 AM
Subject: [amibroker] importing xls into watch groups


Hi All is there a way to import an xls file into a watch list ?

a script file i would suspect ... all i need is to import the code from the xls into the watch list 

For asx user here's an excellent list of indices

http://www.spglobal.com/indexmainasx.html



------=_NextPart_001_01FC_01C0F2B4.1C809DC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!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.4611.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#00ffff>
<DIV><FONT face="Comic Sans MS">Hi David</FONT></DIV>
<DIV><FONT face="Comic Sans MS">I've recently done what you want to 
do:</FONT></DIV>
<DIV><FONT face="Comic Sans MS">I made a text file as follows:</FONT></DIV>
<DIV><FONT face="Comic Sans MS">-----</FONT></DIV>
<DIV><FONT face="Comic Sans MS">$GROUP 255</FONT></DIV>
<DIV><FONT face="Comic Sans MS">AAT</FONT></DIV>
<DIV><FONT face="Comic Sans MS">ADT</FONT></DIV>
<DIV><FONT face="Comic Sans MS">AMC</FONT></DIV>
<DIV><FONT face="Comic Sans MS">ARP</FONT></DIV>
<DIV><FONT face="Comic Sans MS">.... etc etc</FONT></DIV>
<DIV><FONT face="Comic Sans MS">--------</FONT></DIV>
<DIV><FONT face="Comic Sans MS">and imported this using Amibroker's&nbsp;import 
wizard ... see image below - note option selected. This <U>moves</U> 
the&nbsp;tickers from wherever they are, into Group 255 and you can then easily 
add them into a watchlist. (do an explore with filter set to group 255 and then 
in the afl code, set filter=vol&gt;=0; - then you can right click and move to a 
watchlist)</FONT></DIV>
<DIV><FONT face="Comic Sans MS">Hope this helps......</FONT></DIV>
<DIV><FONT face="Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face="Comic Sans MS">Steve</FONT></DIV>
<DIV><FONT face="Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face="Comic Sans MS"><IMG alt="" hspace=0 
src="cid:01fa01c0f271$0e236200$0100007f@xxxx"; align=baseline 
border=0></FONT></DIV>
<DIV><FONT face="Comic Sans MS"></FONT>&nbsp;</DIV>
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV 
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
<A title=dtholz@xxxx href="mailto:dtholz@xxxx";>David 
Holzgrefe</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=amibroker@xxxxxxxxxx 
href="mailto:amibroker@xxxxxxxxxxxxxxx";>amibroker@xxxxxxxxxxxxxxx</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, 7 June 2001 10:39 
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [amibroker] importing xlsinto 
watch groups</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi All is there a way to import an xls file into 
a watch list ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>a script file i would suspect ... all i need is 
to import the code from the xls into the watch list </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>For asx user here's an excellent list of 
indices</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2><A 
href="http://www.spglobal.com/indexmainasx.html";>http://www.spglobal.com/indexmainasx.html</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_01FC_01C0F2B4.1C809DC0--

Attachment: Description: ""