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

RE: [amibroker] Off Topic: Suggestions for a RT data interfaces for Excel wanted



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.