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

Re: [amibroker] importing xls into watch groups



PureBytes Links

Trading Reference Links

Does this method only change the Group ?


Thanks David

guess i cant try it and not save data if it doesnt :)

----- Original Message ----- 
From: Steve and Bee Grobler 
To: amibroker@xxxxxxxxxxxxxxx 
Sent: Monday, June 11, 2001 10:21 PM
Subject: Re: [amibroker] importing xls into watch groups


Hi David
I've recently done what you want to do:
I made a text file as follows:
-----
$GROUP 255
AAT
ADT
AMC
ARP
.... etc etc
--------
and imported this using Amibroker's import wizard ... see image below - note option selected. This moves the 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>=0; - then you can right click and move to a watchlist)
Hope this helps......

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 fromthe xls into the watch list 

For asx user here's an excellent list of indices

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



Yahoo! Groups Sponsor 
       
       

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


------=_NextPart_001_000F_01C0F2FA.6CA878E0
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 6.00.2462.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#00ffff>
<DIV><FONT face=Arial size=2>Thanks Steve </FONT></DIV>
<DIV><FONT face=Arial size=2>I was hoping not to change the integrity of my data 
base I wanted to maintain the sector industry relationship ..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Does this method only change the Group 
?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Thanks David</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>guess i cant try it and not save data if it doesnt 
:)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV 
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
<A title=bgrobler@xxxx href="mailto:bgrobler@xxxx";>Steve and Bee 
Grobler</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> Monday, June 11, 2001 10:21 
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [amibroker] importingxls 
into watch groups</DIV>
<DIV><BR></DIV>
<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 255and 
you can then easily add them into a watchlist. (do an explore with filterset 
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:000d01c0f2a6$9aca0e40$92aafea9@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@xxxxxxxxxxxx 
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 xls into 
watch groups</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi All is there a way to import an xlsfile 
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><BR><BR><TT>Your 
use of Yahoo! Groups is subject to the <A 
href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of Service</A>.</TT> 
<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_000F_01C0F2FA.6CA878E0--

Attachment: Description: ""