I am trying to pull in options market data for a number of different products. Based on the number of strikes I'm pulling in, if I open the sheet at the beginning of the day, I blow through IB's 50 subscriptions per second limit, and break my market data. I've tried using VBA code to "turn-on" each strike one by one, but the problem is it doesn't actually update the quote until the macros exits, hitting the same issue. How are people handling more than 50 RTD links in their Excel code? Thanks
Try www.deriscope.com or www.marketxls.com https://www.interactivebrokers.com/en/index.php?f=1062 the link to quote boost is broken ask IB.
Thanks for the reply, I'll check out both of those systems. IB seems to be giving conflicting information. Your link says live links are limited to a total of 100, but this linke: https://interactivebrokers.github.io/tws-api/tws_rtd_server.html#rtd_message_limit says "...a spreadsheet can have hundreds of streaming tickers, but the subscriptions must be spread out over time..."
I fear that you are mixing up two different limitations. Limit one: you can send up to 50 messages per second to IB. Suppose you want to subscribe to streaming market data of 65 tickers. This means that in the first second you can subscribe to 50 of those tickers, and add the remaining 15 subscriptions during the next second. This results in you having a subscription to 65 tickers after the second second. Limit two: you can have up to 100 market data subscriptions active at any one time. Unless your account value is (very) large or if you buy additional quota. In case you need streaming market data for more than 100 tickers you would need to poll them. First subscribe to 100 tickers and get their data. Then unsubscribe from these and subscribe to the next 100 tickers on your list. And so on.