|
PureBytes Links
Trading Reference Links
|
Hello,
> I think I'm making progress with yahoo actually. The reason I was
> getting meaningless data is that you have to add the suffix .AX to the
> ticker codes in the TLS file for AmiQuote (e.g. CBA.AX etc.). Otherwise
> you presumably get data for American companies that have those ticker
> codes on the NYSE.
Yes .AX suffix is necessary for ASX quotes.
> In fairness, it does mention this in the AmiBroker
> helpfile somewhere, but it just took a long time to find. Anyway, using
> this, it seems to produce yesterday's data OK, i.e. today gets Friday's
> quotes.
In fact the suffix issue is mentioned in the guide. In the "Tutorial: How to download quotes manually using AmiQuote" there is a
following paragraph (Downloading data):
"Note that Yahoo uses suffix encoding so all tickers without suffixes are US-stocks. On the other hand if you have tickers with, for
example, .L suffix it means that tickers are from London Stock Exchange. "
The list of all suffixes used by Yahoo is listed in the help section of Yahoo finance.
But.. you are right it would be nicer to have it in AmiBroker docs.
> However...
>
> When the quotes get automatically imported into Amibroker, they all come
> in with the .AX suffix. If you also import some historical data from
> ComSec, it comes in without the .AX suffix and goes down in the list as
> a different stock altogether. Does anybody know a way of getting that
> AmiQuote auto-import thing to knock off the .AX when it squirts the data
> into AmiBroker?
Well, there are several solutions to this problem.
One is to use "Alias" field in the Stock information window. You may enter main
ticker in the "Ticker" field and the suffixed version in the "Alias" field.
Then AmiBroker will recognize both versions when importing the data.
To avoid manual work you may use the following Scan script that will setup aliases
by adding ".AX" suffix to every stock in your database:
EnableScript("jscript");
ticker= name();
<%
ticker = AFL("ticker");
oAB = new ActiveXObject("Broker.Application");
oAB.Stocks( ticker ).Alias = ticker + ".AX";
%>
buy = 0;
(to be used in Automatic analysis/Scan)
There is one caveat: Using Aliases may slow down import significantly.
In the future I will think about a feature to remove suffixes in AmiQuote.
> Secondly, I've spent today trying to work out the whole sectors,
> industries and company names thing. In the yahoogroups archive, there
> are a lot of messages and files about setting up AmiBroker with
> appropriate industries, sectors and also matching company names to the
> ticker codes. I can't get any of them to work! I know it's a big ask,
> but for the sake of myself and any other newcomers, can anybody post a
> concise, up-to-date, idiot-proof summary of how to make AmiBroker speak
> Australian? Or, better still, post whatever files need replacing so I
> can just copy them into the directory and get going. For myself, I don't
> mind loosing all my data at this stage, because I can reimport it from
> CSV fairly easily.
Please read first the "Tutorial: Working with sectors and industries" section
of the User's guide. After that things should be clearer.
> I know Tomasz is compiling wishlists for future versions of the
> software, so perhaps I could suggest that a useful idea might be some
> kind of localisation module for users outside of the US. So we could
> download the main software and then download a separate Australia pack,
> for example, which would automatically set up the industries, sectors,
> TLS files for AmiQuote and whatnot and perhaps also include a brief
> text-file containing the latest wisdom on where to get data from.
Good idea for the future.
FYI: you might try to ask people at www.cooltrader.net for ASX&AmiBroker-related issues.
Best regards,
Tomasz Janeczko
===============
AmiBroker - the comprehensive share manager.
http://www.amibroker.com
|