|
PureBytes Links
Trading Reference Links
|
Don,
Do you have JScript available/working on your machine ?
(Internet Explorer 5 or higher required)
Do you have one or more AmiBroker instances running ?
If more: Please run only one instance.
I have also prepared a different version. This time for
"EXPLORE". It should list changed ticker names immediatelly in the result list.
EnableScript("jscript");
ticker = Name();
<%
ticker = AFL("ticker");
AB = AFL.CreateObject("Broker.Application");
AB.Stocks( ticker ).Ticker = ticker + ".AX";
%>
Filter=BarIndex()==0;
AddTextColumn( Name(), "After change" );
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "don" <donmac63@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Thursday, September 04, 2003 12:32 AM
Subject: Re: [amibroker] Batch Ticker conversion
> Hi Tomasz,
>
> I used the first script as below in "Automatic Analysis"
>
> EnableScript("jscript");
>
> ticker = Name();
>
> <%
>
> ticker = AFL("ticker");
>
> AB = AFL.CreateObject("Broker.Application");
>
> AB.Stocks( ticker ).Ticker = ticker + ".AX";
>
> %>
>
> Buy=0;
>
> Apply to "all stocks " selected "scan" and then "refresh all"
> but for some reason did not work.
> The progress bar indicates that AA is scanning but the symbols in the
> workspace symbols tree remains unchanged after applying "refresh all".
>
> ??
> Regards
>
> Don
>
> ----- Original Message -----
> From: "Tomasz Janeczko" <amibroker@xxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Thursday, September 04, 2003 12:05 AM
> Subject: Re: [amibroker] Batch Ticker conversion
>
>
> > Don,
> >
> > Script works. I DO check scripts that I sent out.
> >
> > Which script did you use (first or second)?
> > Did you select "Apply to: ALL STOCKS" ?
> > Did you use "SCAN".
> > Did you select View->Refresh ALL ***AFTER*** scan ?
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message -----
> > From: "don" <donmac63@xxxxxxxxxxxx>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Wednesday, September 03, 2003 4:41 PM
> > Subject: Re: [amibroker] Batch Ticker conversion
> >
> >
> > > Tomasz
> > >
> > > Sorry to have to say but the script did not work.
> > >
> > > Followed instructions to the letter
> > > AA went thru the motions but no change to the tickers after Refresh All
> or
> > > exit AB and restart.
> > > I must be missing something.
> > > regards
> > >
> > > Don
> > >
> > >
> > > ----- Original Message -----
> > > From: "don" <donmac63@xxxxxxxxxxxx>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Wednesday, September 03, 2003 9:27 PM
> > > Subject: Re: [amibroker] Batch Ticker conversion
> > >
> > >
> > > > 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/
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > 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/
> >
> >
> >
>
>
>
> 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/
|