|
PureBytes Links
Trading Reference Links
|
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/
>
>
>
------------------------ 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/
|