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

[amibroker] How to build a database with all NYSE and Nasdaq stocks with MyTrack datafeed?



PureBytes Links

Trading Reference Links

Hi Jason,

Thanks for your help. As you suggested I will try to establish a 
historical DB with Yahoo/MSN and then simply switch this EOD DB to 
MyTrack to see the day progress in RT.

At the moment my database is empty. How can I build a database with 
all NYSE and Nasdaq stocks? I believe there is a simpler way than 
adding stocks one by one but could not find any usefull information 
about the way to process. Can you help on that?

Thanks,
Olivier





--- In amibroker@xxxxxxxxxxxxxxx, "Jayson" <jcasavant@xxxx> wrote:
> Oliver,
> FWIW the way I do it is with 2 databases. One retrieves RT day 
bars and the
> second retrieves 1 minute bars. The EOD database can have 10 years 
of data
> but the last bar is "Live". You may wish to establish a historical 
DB with
> Yahoo/MSN or the data vendor of your choice (I use QP2) then 
simply switch
> your EOD DB to esignal to see the day progress in RT
> 
> Regards,
> Jayson
> -----Original Message-----
> From: olivier_molongo [mailto:olivier_molongo@x...]
> Sent: Wednesday, July 30, 2003 8:30 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: (unknown) : MyTrack / Esignal datafeed
> 
> 
> Hello,
> 
> Thanks for the answer regarding the ref function.
> 
> For the datafeed I understand that if I use MyTrack I will have to
> handle 2 seperate databases as suggested on the website. But for
> Esignal feed it is not stated on the website that 2 seperate
> databases are necessary. Will I have only one database including
> realtime and EOD data if I use Esignal?
> 
> Thanks,
> Olivier
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" 
<amibroker@xxxx>
> wrote:
> > Hello,
> >
> > For short daily history it is enough just to use time-compressed
> intraday
> > bars. Just select View->Daily in your intraday database and you 
will
> > see daily bars on your intraday database (since mytrack supplies
> only 15 days
> > backfill initially it will be 15 days but this will grow day 
after
> day as
> > AmiBroker stores the data in its own database).
> >
> > For long EOD histories you have to use separate database.
> > This is so because EOD and Intraday data are supplied by myTrack
> (and also other data vendors)
> > separately (intraday histories are very long, to save the 
resources
> most
> > data vendors only store 1-120 days of intraday, the remaining 
data
> are stored
> > as daily records only on separate servers)
> >
> > To reference past bars use Ref() function.
> > Ref( Close, -1 ) - close 1 bar ago (on EOD database this is
> yesterday).
> > Ref( MA( Close, 5 ), -1 ) - 5 bar MA as of bar before
> >
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message -----
> > From: "olivier_molongo" <olivier_molongo@xxxx>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Wednesday, July 30, 2003 12:30 PM
> > Subject: [amibroker] (unknown)
> >
> >
> > > Hi all,
> > >
> > > I just bought the software and I need some help to set it up. I
> use
> > > it with Mytrack and I am quite suprise because it seems I have 
to
> set
> > > up 2 databases: one for realtime and another one for EOD data.
> That
> > > is strange, is there a workaround for this? I want a single
> database
> > > with EOD and realtime data.
> > >
> > > I need to write some basic scans, do you know how to get in the
> > > language for instance, the close of yesterday or 4 bars ago, 
the
> 5
> > > days ma as of yesterday...
> > >
> > > I would appreciate your help and tips regarding Amibroker.
> > >
> > > Thanks
> > > Olivier
> > >
> > >
> > >
> > >
> > >
> > >
> > > Send BUG REPORTS to bugs@xxxx
> > > Send SUGGESTIONS to suggest@xxxx
> > > -----------------------------------------
> > > Post AmiQuote-related messages ONLY to: 
amiquote@xxxxxxxxxxxxxxx
> > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > --------------------------------------------
> > > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> 
> 
> 
>       Yahoo! Groups Sponsor
>             ADVERTISEMENT
> 
> 
> 
> 
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> 
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service.



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/sO0ANB/LIdGAA/ySSFAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

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