|
PureBytes Links
Trading Reference Links
|
<FONT face=Arial color=#0000ff
size=2>InteractiveBroker offers an Excel sheet on their website that will read
the real time prices from your trader work station - if you have an account with
them of course.
<FONT face=Arial color=#0000ff
size=2>
If you
are skilled in Excel, as you appear to be , this may be a free way to get your
real time data as well as a great way to implement your formulas. But you will
not get 5000 symbols imported :-) I do not know the limit... The advantage is
that you can even place your orders from Excel and monitor all executions and
account data.
<FONT face=Arial color=#0000ff
size=2>
In
terms of real time scanning of 5000 stocks during the day, this is probably too
much for most programs (but i wouldn't be surprised if AB RT can do this). You
may do better to use some commercial service that offers this, I remember using
them some years back, when they just came out. They should be much better today.
Some will take simple formulas to scan by and give you real time result as fast
as your ISP can deliver them.
<FONT face=Arial color=#0000ff
size=2>
good
luck,
<FONT face=Arial color=#0000ff
size=2>Herman.
<FONT face=Tahoma
size=2>-----Original Message-----From: CedarCreekTrading
[mailto:kernish@xxxxxxxxxxx]Sent: Thursday, October 02, 2003 3:39
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker]
Off Topic: Suggestions for a RT data interfaces for Excel
wanted
E-signal?
Take care,
Steve
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=downhillspeedster@xxxxxxxxx
href="">downhillspeedster
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Thursday, October 02, 2003 1:08
PM
Subject: [amibroker] Off Topic:
Suggestions for a RT data interfaces for Excel wanted
Hello august body of computer literate
traders,This is a bit off topic, but I find my daily trading
opportunities using Excel as a market scanner; In the evening, I use
Amibroker to calculate several price targets for tomorrow; when a stock
crosses those price targets, that is a trigger to consider a trade. My
goal is to get real time or 20 minute delayed price and volume data for
5000 stocks in Excel in 5 minutes.I think you can see the power
of this technique. I am looking at what is moving in market today
instead of preselecting a watchlist of stocks based on yesterday's price
movement. Another benefit of having the market in a spreadsheet is
that market breadth indicator are very easy to calculate.My
question revolves around getting 20 minute delayed or RT price into
Excel from a data service.I've tried several products I found using
google on the web. The fastest product I've found to get data into
Excel is from www.esquotes.com; it drawback is that it only uses Yahoo
quotes. Also, emails to the developer bounced. But it is fast enough for
my purposes and it works for now. It will populate a spreadsheet of 5000
stocks with price and volume data in about 5 minutes. (You have to
write a loop to fetch 300 symbols at a time to get this
performance.)A second product I tried is from www.quotein.com. It
works with a variety of servers, free and fee based RT, but it is SLOW.
(As with esquotes, I used a looping technique to fetch 100-500 tickers
at a time).Another product is www.analyzerxl.com. I did
not investigate this product very thoroughly because inputing a large
watchlist is clumbersome.So does anyone know of other fast stock
interfaces for Excel? I don't want to cut and paste a .csv file in to
Excel. I want the price data in an Excel spreadsheet cell. I think the
MSFT buzzwords for this type of software function are DDE and RTD; the
only thing I know about DDE and RTD right now is how to spell
them.Regards,downhillspeedsterSend
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
ADVERTISEMENT<img
src="" width=300 height=250 border=0>
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 the Yahoo! Terms of Service.
|