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

Re: [amibroker] Re: How to download multiple tickers



PureBytes Links

Trading Reference Links

Hi Brian,

If I understand what you mean, there is no simple way to get all the data for the 6000+ tickers in my database, except clicking on each one, one by one, and waiting for Amibroker to download the data from my provider?  That will take months!  

Anyone has any idea how to make that process faster?
Thanks,

Louis

2008/3/14, brian_z111 <brian_z111@xxxxxxxxx>:

Louis,

> It is not exactly what I mean... What I would like to know is if
>it is
> possible to use Amiquote to download quotes directly from DTN and
>not from
> Yahoo.

No, AQ is configured for a limited number of providers (free and or
cheap with some different instruments) for training and for those of
us who need/want cheap data.

Look in the AQ dropdown box for the available servers.

> As for using the .tls files from Amiquote, I will try this and will
>consult
> the UKB to see if I can do it, but I would prefer DTN (or another
provider)
> rather than Yahoo.

That is fine.
AB is about choice.

In that case the UKB is only helpful for finding and importing ticker
lists and setting up categories (if your provider doesn't do that for
you).

If you do want to import .tls ticker lists the ASCII import wizard
can read them directly.

DTN is completely separate from AmiQuote.

I can't help with methods for commercial providers.
There are too many and I don't want to mess up the commercial
relationship with their clients anyway.

brian_z

--- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine"
<rockprog80@xxx> wrote:
>
> Hi Brian,
>
> It is not exactly what I mean... What I would like to know is if
it is
> possible to use Amiquote to download quotes directly from DTN and
not from
> Yahoo. That way, I would have all my quotes from the same source,
which is
> surely more reliable than Yahoo. Do you think it can be done?
>
> As for using the .tls files from Amiquote, I will try this and will
consult
> the UKB to see if I can do it, but I would prefer DTN (or another
provider)
> rather than Yahoo.
>
> Thanks,
>
> Louis
>
> 2008/3/14, brian_z111 <brian_z111@xxx>:


> >
> > Louis,
> >
> > > Now... Do you know is there is a way to set Amiquote to download
> > >all the
> > > data from my DTN IQ-Feed plugin ....... or do I have to manually
> > click each of the
> > > tickers?
> >
> > I think you mean: "How can I use a ticker list, from AmiQuote,
with a
> > DTN database?".
> >
> > After you download data from Yahoo, into your EOD database, save
the
> > ticker list from within AmiQuote, while it is still open.
> >
> > You can then import this list into a DTN database (use ASCII
import
> > or watchlist import).
> >
> > Between the Help Manual, Tomasz's videos and my UKB posts I think
we
> > have covered examples of 80% of anything anyone could want to do,
> > regarding databases, at least for all basic tasks.
> >
> > I don't think Tomasz and I can possibly do anymore to make it
> > simpler, in that area.
> >
> > The only thing left to do is perhaps a couple of more advanced
> > examples (importing using script/OLE etc) - after that we are on
our
> > own.
> >
> > It looks like you used the US-Stocks database - we have Jim to
thank
> > for that.
> >
> > brian_z
> >
> > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com>, "Louis
> > Préfontaine"
> > <rockprog80@> wrote:
> > >
> > > Hi Brian,
> > >
> > > Thanks a lot. I see that you wrote some of the page in the UKB
and
> > I really
> > > appreciate the step-by-step feature for downloading multiple
> > tickers.
> > > Thanks to you, I now have over 6000 tickers in my datase!
> > >
> > > Now... Do you know is there is a way to set Amiquote to download
> > all the
> > > data from my DTN IQ-Feed plugin (which works with Amibroker, but
> > does not
> > > seem to work with Amiquote) or do I have to manually click each
of
> > the
> > > tickers? (Which can be time-consuming...)
> > >
> > > Thanks,
> > >
> > > Louis
> > >
> > > 2008/3/13, brian_z111 <brian_z111@>:
> >
> > > >
> > > > The posts at the UKB >> Database Management are designed to
> > give new
> > > > users an education into the one of the core skills of using AB
> > (data
> > > > + formulas + backtesting == the core skills).
> > > >
> > > > Don't underestimate the importance of understanding the data
we
> > use.
> > > >
> > > > If you want that education start with the first post in DM
and use
> > > > them as a workbook i.e. start with a newly installed AB
directory
> > and
> > > > walkthrough (the earlier posts are a pre-requisite for Setup A
> > Custom
> > > > Database).
> > > >
> > > > (they do work - at least the last time I was there).
> > > >
> > > > If you don't want that education go straight to the next step
(a
> > lot
> > > > of people use providers who organize their data for them and
they
> > > > don't have to 'waste' time on manual intervention and/or don't
> > want
> > > > to learn that stuff).
> > > >
> > > > Yahoo data is a marvellous tool for free stockmarket training.
> > > >
> > > > When I started trading I had no prior experience, no
programming
> > > > experience and no trading friends - I could have saved myself
the
> > > > $2000 dollars that I paid in data over the first two years
> > because I
> > > > wasn't good enough to trade anyway (for me there was so much
to
> > > > learn).
> > > >
> > > > Others can and do learn at a different pace to me though.
> > > >
> > > > brian_z
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com><amibroker%

> > 40yahoogroups.com>, "Louis
> > > > Préfontaine"
> > > > <rockprog80@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I fear I may ask a dumb question, but I don't really
understand
> > how
> > > > to get
> > > > > the historical quotes from Yahoo for all the quotes on NYSE
and
> > > > NASDAQ... I
> > > > > looked at
> > > > > http://www.amibroker.org/userkb/2007/11/09/setup-a-custom-
> > database-
> > > > nasdaq/
> > > > > but it is still not too clear for me...
> > > > >
> > > > > To Howard: at long term I will use DTN, but DTN is 100
$+/month
> > with
> > > > > canadian quotes, so it is somewhow expensive for now... And
I
> > > > think that
> > > > > the EOD data should be quite the same... I'm still figuring
how
> > > > I can
> > > > > integrate intraday-EOD data in the same interface, so right
now
> > I
> > > > have an
> > > > > EOD database with DTN and an intraday database with DTN. I
would
> > > > only add a
> > > > > Yahoo EOD database to the whole thing.
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Louis
> > > > >
> > > > > 2008/3/13, brian_z111 <brian_z111@>:
> > > > > >
> > > > > > > Are the yahoo history quotes free and reliable for
> > > > backtesting?
> > > > > >
> > > > > > Yes, it is free, and deep histories too.
> > > > > >
> > > > > > This is a contentious subject (AB users disagree on this
> > point).
> > > > > >
> > > > > > Some of use it for backtesting and some do use it for
trading.
> > > > > >
> > > > > > Personal choice.
> > > > > >
> > > > > > I have posted on the pros and cons at the UKB >> data >>
Yahoo
> > > > > >
> > > > > > The best thing is to be informed from there and make your
own
> > > > > > decision.
> > > > > >
> > > > > > It is definitely good enough to start out (for EOD
trading) -
> > when
> > > > > > you start to get a couple of good systems then you can
repeat
> > the
> > > > > > tests on other data (purchased?) and see if you get any
> > > > difference.
> > > > > >
> > > > > > The main point is that Yahoo can be raw or dividend
adjusted
> > (it
> > > > > > makes a difference) - I also have tried to discuss this at
> > the UKB
> > > > > > (not finished yet).
> > > > > >
> > > > > > brian_z
> > > > > >
> > > > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com><amibroker%
> > 40yahoogroups.com><amibroker%
> > > > 40yahoogroups.com>, "Louis
> > > > > > Préfontaine"
> > > > > > <rockprog80@> wrote:
> > > > > > >
> > > > > > > Hi Brian,
> > > > > > >
> > > > > > > Are the yahoo history quotes free and reliable for
> > backtesting?
> > > > > > >
> > > > > > > You are right: for NASDAQ and NYSE the tickers are the
same
> > for
> > > > > > DTN. So I
> > > > > > > guess your way could work?
> > > > > > >
> > > > > > > I will try to work with this tomorrow or this week-end
and
> > will
> > > > get
> > > > > > back to
> > > > > > > you with this.
> > > > > > >
> > > > > > > Thanks!
> > > > > > >
> > > > > > > Louis
> > > > > > >
> > > > > > > 2008/3/13, brian_z111 <brian_z111@>:
> > > > > > > >
> > > > > > > > Sorry,
> > > > > > > >
> > > > > > > > An incorrect assumption on my part.
> > > > > > > > I don't know anything about DTN.
> > > > > > > > Usually the tickers are the same except for indices.
> > > > > > > >
> > > > > > > > Someone else can probably help with DTN - apologies
for
> > > > wasting
> > > > > > your
> > > > > > > > time.
> > > > > > > >
> > > > > > > > Yes, Yahoo definitely works - simple import and also
with
> > the
> > > > > > setup
> > > > > > > > methods I use there.
> > > > > > > >
> > > > > > > > A lot of people don't like Yahoo data though.
> > > > > > > > I use it for backtesting but not live.
> > > > > > > >
> > > > > > > > brian_z
> > > > > > > >
> > > > > > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
40yahoogroups.com><amibroker%
> > 40yahoogroups.com><amibroker%
> > > > 40yahoogroups.com><amibroker%
> > > > > > 40yahoogroups.com>, "Louis
> > > > > > > > Préfontaine"
> > > > > > > > <rockprog80@> wrote:
> > > > > > > > >
> > > > > > > > > Hi Brian,
> > > > > > > > >
> > > > > > > > > Thanks for your reply.
> > > > > > > > >
> > > > > > > > > I see that the quotes used come from yahoo...
However I
> > use
> > > > data
> > > > > > > > from DTN,
> > > > > > > > > so the ticker name should be different. So even if
I can
> > > > > > download
> > > > > > > > every
> > > > > > > > > tickers from yahoo, I would have to manually change
the
> > > > ticker
> > > > > > name
> > > > > > > > so it
> > > > > > > > > can upload automatically. Is there a way to avoid
this?
> > > > > > > > >
> > > > > > > > > Also, are you sure it is possible to get the quotes
from
> > > > yahoo?
> > > > > > I
> > > > > > > > remember
> > > > > > > > > I tried some times ago and wasn't able to do it.
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > >
> > > > > > > > > Louis
> > > > > > > > >
> > > > > > > > > 2008/3/13, brian_z111 <brian_z111@>:
> > > > > > > > > >
> > > > > > > > > > Hello Louis,
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > Is there a way to download a LOT of tickers,e.g.
> > every
> > > > > > tickers
> > > > > > > > on
> > > > > > > > > > >the
> > > > > > > > > > > NASDAQ, or DJI? Do I have to manually enter each
> > tickers
> > > > > > after
> > > > > > > > the
> > > > > > > > > > >other or
> > > > > > > > > >
> > > > > > > > > > > is there a faster and simplier way?
> > > > > > > > > >
> > > > > > > > > > Yes, there is.
> > > > > > > > > >
> > > > > > > > > > There are some posts at the UKB that walk you
through
> > the
> > > > > > basics.
> > > > > > > > > >
> > > > > > > > > > Setup A Custom Database is the main one.
> > > > > > > > > >
> > > > > > > > > > It shows you how to get ticker lists and how to
use
> > them
> > > > in
> > > > > > AB.
> > > > > > > > > >
> > > > > > > > > > http://www.amibroker.org/userkb/
> > > > > > > > > >
> > > > > > > > > > Look under DataBase Management.
> > > > > > > > > >
> > > > > > > > > > brian_z
> > > > > > > > > >
> > > > > > > > > > --- In amibroker@xxxxxxxxxxxxxxx<amibroker%
40yahoogroups.com><amibroker%
> > 40yahoogroups.com><amibroker%
> > > > 40yahoogroups.com><amibroker%
> > > > > > 40yahoogroups.com><amibroker%
> > > > > > > > 40yahoogroups.com>, "Louis
> > > > > > > > > > Préfontaine"
> > > > > > > > > > <rockprog80@> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > Is there a way to download a LOT of tickers,e.g.
> > every
> > > > > > tickers
> > > > > > > > on
> > > > > > > > > > the
> > > > > > > > > > > NASDAQ, or DJI? Do I have to manually enter each
> > tickers
> > > > > > after
> > > > > > > > the
> > > > > > > > > > other or
> > > > > > > > > > > is there a faster and simplier way?
> > > > > > > > > > >
> > > > > > > > > > > Thanks,
> > > > > > > > > > >
> > > > > > > > > > > Louis
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>


__._,_.___

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___