You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Getting data from IB
- Thread starter Bluegar3
- Start date
Note you can't get the data on the weekends....they shut off midnight NY time on Friday night and they're back on midday Sunday (I think noon NY time but I'm not sure).
Quote from Bluegar3:
I would have called IB, but they are not open and I would love if someone could help me out.
Is there a way I could transfer the data from IB to excel. I want the data from YM or ES.
Thank you
http://www.interactivebrokers.com/en/software/systemStatus.php?ib_entity=llc
System Availability North American Servers European Servers Asian Servers
Monday-Friday 24 hours, Mon 00:20 â Fri 23:45 EST
Saturday Not available
Sunday Starting 12:00 EST
Reset times 23:50 â 03:00 EST* 03:59 â 05:00 HKT*
It's part of the API download.Quote from Bearbelly:
Check out their website/software/fix-api. They have a sample spreadsheet you can download.
Install the API... and then search for TwsDde.xls
Actually, it should be in the "c:\Jts\Excel" directory.
It's a fairly well designed and coded Excel workbook...
That connects to your TWS and displays IB quotes...
Plus has a lot of additional functionality.
on IB's Excel API could I get RTD instead of DDE? and could it handle more then 40 fields with over 100 data lines?
could some let me know which is the best route for and real time data calculations and database combo?
MYSQL or others
what I wanted to do is have hundreds of cells calcutate and update real time data of stocks and futures with alerts and sound colors etc.
could some let me know which is the best route for and real time data calculations and database combo?
MYSQL or others
what I wanted to do is have hundreds of cells calcutate and update real time data of stocks and futures with alerts and sound colors etc.
Quote from Moreagr:
on IB's Excel API could I get RTD instead of DDE? and could it handle more then 40 fields with over 100 data lines?
...
100 data line limit remains:
http://www.interactivebrokers.com/en/accounts/fees/marketData.php
"""
All customers receive 100 concurrent lines of real-time market data (which can be displayed in TWS or via the API). After the first month of trading, high-volume traders may receive additional lines of market data, calculated as follows:
Maximum ((Monthly Commissions/8), 100)
For example, if you generate USD 16.00 in monthly commissions, you will receive 100 lines of market data. If you generate USD 400.00 in commissions, you will receive 100 lines of market data. But if you generate USD 840.00 in commissions, you will receive 105 lines of market data.
"""
My recollection also is that API data take priority over TWS data in getting to the 100 limit.