Real‐time Data (RTD) Server
Daniel J. Duffy, Andrea Germani · 2013
This chapter discusses how to interface Excel with external real-time data (RTD) feeds. A major concern when handling real-time data in Excel is to ensure that newly arrived real-time data can be processed as quickly as possible while at the same time ensuring that there are no conflicts with other applications. Without some form of coordination, there will be conflicts between real-time data sources and Excel. The design of the RTD server ensures that Excel is the coordinator that regulates all data traffic and updates to worksheets. The chapter describes the steps to create an RTD server, generate data from it and then constantly update certain cells on the Excel worksheet.