[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,

Yes I have DTN real-time.
I have over 6000 tickers; got the NASDAQ ones thanks to the UKB files and then I looked over the internet to get .csv and .xls files to get all NYSE, TSX, etc.

And now what I want is to be able to get the data to each and every ticker in the list.  So far I was able to do it for letter "A" by clicking on each and every ticker, but it took me like half an hour for that.  I was looking for a faster way.

Also, I think there is a limit of 500 for real-time; is it possible to get more real-time; else, or to actually choose the one that will be real-time?

Thank you a lot for your help.  I really appreciated your help files in the UKB as well; it helped me to set the database.

Thanks,

Louis

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

Louis,

Not sure if I can help but let's sort out your question to give you a
better chance of getting an answer.

You are subscribed to DTN IQ Real Time ?
You have set up a database as per Tomasz's DTN IQ video?
You have 6000 tickers in that database (that you imported from
somewhere) - where and how?

brian_z

--- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine"
<rockprog80@xxx> wrote:
>
> 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@xxx>:


> >
> > 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 <amibroker%
40yahoogroups.com>, "Louis
> > Préfontaine"
> > <rockprog80@> 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@>:
> >
> > > >
> > > > 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><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><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><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><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><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

__,_._,___