PureBytes Links
Trading Reference Links
|
I am
trying to imagine what you are doing in excel that could not be accomplished
using an AB exploration. Perhaps you could expand upon exactly what it is you
are trying to do in excel....
Regards,
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: downhillspeedster
[mailto:downhillspeedster@xxxxxxxxx]Sent: Thursday, October 02, 2003
3:09 PMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker]
Off Topic: Suggestions for a RT data interfaces for Excel
wantedHello 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.
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.
|