For example, the thinkorswim (aka "tos") platform uses Excel's RTD functionality to stream real-time quote and position data to Excel for over 100 defined data fields. In Excel, a cell formula to stream the real-time BID data field is =RTD("tos.rtd",,"BID",A10), where A10 is the example cell containing the instrument symbol. A cell formula to stream the average price of a position is =RTD("tos.rtd",,"AV_TRADE_PRICE",A10). For open profit/loss: =RTD("tos.rtd",,"P_L_OPEN",A10). For open profit/loss percent: =RTD("tos.rtd",,"P_L_PERCENT",A10). And so on, for over 100 defined data fields.
More info on how this works:
https://www.lockeinyoursuccess.com/c...l-part-1-of-4/
https://www.stock-data-solutions.com...es-tos-rtd.htm
Video: https://www.youtube.com/watch?v=TWdOYvN9eIs
Comment