[FONT="]I'm requesting stock quote data via RTD from my brokerage's server, but they have a limit of 50 quote-requests / second, and the server disconnects you if you exceed that. The worksheet is currently set to execute 500 rows of formulas at once (each requesting 1 symbol quote), which I need to change so that no more than 50 get requested each second.[/FONT]
[FONT="]I could probably change my VBA to incorporate all sorts of pausing and incremental copy/pasting to copy over 49 formulas at a time, then pause for 1.5 seconds, then request the next batch of 49 (and repeat that 10 times), but that seems clunky -- I thought perhaps that maybe there was a global setting in Excel somewhere I could set so that no matter how many formulas I copy over at once, I can tell Excel to "queue" all 500 requests, but only send 49 to the server each 1.5 seconds...is it possible to regulate the speed of RTD requests that get transmitted so that I don't exceed the server's max and get booted?[/FONT]
[FONT="]I could probably change my VBA to incorporate all sorts of pausing and incremental copy/pasting to copy over 49 formulas at a time, then pause for 1.5 seconds, then request the next batch of 49 (and repeat that 10 times), but that seems clunky -- I thought perhaps that maybe there was a global setting in Excel somewhere I could set so that no matter how many formulas I copy over at once, I can tell Excel to "queue" all 500 requests, but only send 49 to the server each 1.5 seconds...is it possible to regulate the speed of RTD requests that get transmitted so that I don't exceed the server's max and get booted?[/FONT]