Real time Quotes in Excel

I

InTheZone

Hello,

Can any recommend any software tools that will insert real time quotes into a user specified cell of an Excel spreadsheet?

Quote.com has such a product called Qlink. Unfortunately, it is no long supported and the quotes that are retrieved by Qlink sometimes are cross-linked with other quotes on the spreadsheet. Not good!

I've looked at QuoteCat's product, which comes close. Unfortunately, it uses quotes from Yahoo's websites with may not be true best real-time quotes (since it's coming from ECN's).

Thanks.

-- ITZ
 
You can take 40 different stock, options or futures with multiple fields, bid, ask trade size etc into excel with Interactive brokers trader workstation. Works very well.
 
With RealTick you can pull real-time quotes into Excel. For general information purposes for the RealTick Users on Elite Trader here is how you can use Excel.

Just follow the below steps:

1. Open RealTick
2. Click on ‘Start’ then ‘Programs’ then ‘Tal Trading Tools’ and finally ‘TalNet’
3. Leave the TalNet screen open, but minimize it.
4. Click on ‘Start’ then ‘Programs’ then ‘Tal Trading Tools’ and finally ‘Quotes97’
5. Click on ‘Enable Macros’
6. Open new Excel sheet
7. Select line 3 in column 2. Click on the lower left hand corner of the cell and drag across to column 8.
8. In the upper left hand corner, click on the ‘Live Quote Array’ icon/button.
9. Change the network server to $quotes$. Click ‘OK’
10. Enter the symbol in UPPER CASE letters in the column next to the ‘price’ field but 2 rows below (row 3). Click on the lower right hand corner of the cell and drag across to row to column 6 (under time)
11. Click once again on ‘Live Quote Array’. Click ‘OK’
12. Wait a moment and the quotes will appear on the spreadsheet.
13. To enter additional symbols, repeat steps 10 – 12. Enter the subsequent symbols in the row under the previous symbol.

If you have any questions please let us know.
 
Quicken Quotes Live offers a link that works well. The after hours and pre-market quotes are questionable especially for QQQ.
 
You must log in or register to reply here.
Back
Top