New answers tagged interactive-brokers
In VBA Application.RTD.ThrottleInterval controls the refresh rate of RTD functions in Excel. Note that a value that is too small may take away too much CPU resource and makes Excel slow to respond. A nicer solution is have some in memory object/process to handle data update and print it out to Excel.
Don't use either DDE or ActiveX, go with the excel RTD server api. It's the basis behind the Bloomberg BDP plugin and we use it at work to push real time data to many spreadsheets.. It's now the recommended way to push data into a spreadsheet and it has a built in refresh rate parameter which can be any millisecond interval, or immediate if you want data ...
Top 50 recent answers are included