|
PureBytes Links
Trading Reference Links
|
Louis,
this is a very simple way that might overcome your problem. Jim
Swindle periodically provides the US Stocks database for Amibroker
users. It contains the symbols for about 8,000 stocks broken down by
market, sector and Industries. His web address for downloading is:
www.icc-az.com/icc%2Daz/default.html?http%3A//www.icc-az.com/icc%252Daz/
and go to the Amibroker link, or look up JSwindle in AB Yahoo Group
(this group). Once you have the template you should be able to
download data from any source. I use a combination of EODdata.com and
Yahoo they work fine. On any databse you need to update the database
from any source to correct errors that occur on even the best.
Dick H
--- 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/
|