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

[amibroker] Re: How to download multiple tickers



PureBytes Links

Trading Reference Links

O.K

You did it the hard way but you did it!

You can pay extra to DTN to access 1800 at a time but you have to 
consider the download.

1 minute bars are equal to 60 * 6 EOD bars - this is a huge drag on 
your computer.

Anyway, it is clear now that you want help with the DTN IQ feed on 
how to select 500 symbols for download and how to force backfill?

There must be some IQ users around.

brian_z



--- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine" 
<rockprog80@xxx> wrote:
>
> 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@xxx>:
> >
> >   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 <amibroker%
40yahoogroups.com>, "Louis
> > Préfontaine"
> > <rockprog80@> 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@>:
> >
> > > >
> > > > 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><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><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><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><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><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><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
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/