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

RE: [amibroker] Batch Ticker conversion



PureBytes Links

Trading Reference Links

Tomasz:

This is a very elegant solution.

Is there any way that I can select the members of a mutual fund family
and put them in a list?

Regards

Lionel

 

-----Original Message-----
From: Tomasz Janeczko [mailto:amibroker@xxxxxx] 
Sent: Wednesday, September 03, 2003 7:52 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Batch Ticker conversion


Don,

You can easily and completely automatically append ".AX" extension to
all symbols in your database in a few seconds using this very simple
SCAN script:

EnableScript("jscript");

ticker = Name();

<%

ticker = AFL("ticker");

AB = AFL.CreateObject("Broker.Application");

AB.Stocks( ticker ).Ticker = ticker + ".AX";

%>

Buy=0; 

Use: Automatic Analysis, Scan, apply to all stocks.

Reverse process is also possible:

EnableScript("jscript");

ticker = Name();

noext = StrLeft( ticker, StrLen( ticker ) - 3 );

<%

ticker = AFL("ticker");

AB = AFL.CreateObject("Broker.Application");

AB.Stocks( ticker ).Ticker = AFL("noext");

%>

Buy=0; 


Make sure to use View->Refresh ALL
to refresh ticker list after processing.

Hope this helps.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "don" <donmac63@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 03, 2003 2:06 PM
Subject: Re: [amibroker] Batch Ticker conversion


> Thanks Graham,
> 
> I have tried that and ended up with double the number of tickers, one 
> with and one without the extension. I would then have to re-map the 
> industries and sector information and then delete the redundant 
> tickers (the ones without the extension) from the database.
> 
> Yes Amibroker does have facilities to edit stock information and 
> mapping but not in a batch mode, not that I'm aware of anyway. It 
> would be less time consuming to edit each ticker manually although it 
> would take a few + a few hours.
> 
> If I can find a way to change the tickers already in the database then

> the mapped information will be retained and save a lot of time.
> 
> again thanks for your reply
> 
> Best regards
> 
> Don
> 
> 
> ----- Original Message -----
> From: "Graham" <gkavanagh@xxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, September 03, 2003 7:34 PM
> Subject: RE: [amibroker] Batch Ticker conversion
> 
> 
> > I use excel for that, although I believe there is capability in AB 
> > to
> change
> > the ticker name and I think was recently discussed.
> > I exported all the tickers and using excel added the extension Say 
> > column A has the ticker, then column B would have this formula
> =A1&".AX"
> > The new column can then be copy and pasted into text editor like 
> > Notepad
> and
> > saved as text file, then imported into AB database
> >
> >
> >
> > Cheers,
> > Graham
> > http://groups.msn.com/ASXShareTrading
> > http://groups.msn.com/FMSAustralia
> > -----Original Message-----
> > From: don [mailto:donmac63@xxxxxxxxxxxx]
> > Sent: Wednesday, 3 September 2003 7:22 PM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Batch Ticker conversion
> >
> >
> > New Amibroker User
> >
> >
> > I am interested to know if anyone has created a script to change 
> > multiple ticker symbols in a native Amibroker Database?
> >
> > I need to add  ".AX " to all the ticker symbols in the ASX Setup 
> > Database
> to
> > allow the collection of Yahoo data thru amiquote.
> >
> > eg:    TLS  ---->  TLS.AX
> >           LLC ----->  LLC.AX
> > I don't mind having to manually edit index symbols back to  their 
> > correct format , ( ^AXJO  ^AORD etc), but 1000's of stock symbols
will take a
> > lllllloooonnggg   time.
> >
> > Or, is it possable to setup Amiquote to append .AX to the ticker 
> > symbols?
> >
> > any help or ideas will be greatly appreciated.
> >
> > Thankyou in advance for any help.
> >
> > Best Regards
> >
> > Don
> >
> > Yahoo! Groups Sponsor
> >
> >
> >
> > Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> > Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> > -----------------------------------------
> > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > --------------------------------------------
> > Check group FAQ at: 
> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> >
> >
> >
> > Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> > Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> > -----------------------------------------
> > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > --------------------------------------------
> > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> >
> > Your use of Yahoo! Groups is subject to 
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> 
> 
> 
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
> 
> Your use of Yahoo! Groups is subject to 
> http://docs.yahoo.com/info/terms/
> 
> 
>


Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ 


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/