|
PureBytes Links
Trading Reference Links
|
Tomasz
Thank you
you have saved me a lot of time
As with many other users of Amibroker I am very impressed with the support
from you and the group members.
I know I will learn a lot simply by following you all.
The Amibroker Program is also very impressive.
It is a very flexible and powerfull application limited only by my skill but
not my imagination.
Best Regards
Don
----- Original Message -----
From: "Tomasz Janeczko" <amibroker@xxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 03, 2003 8:52 PM
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/
|