Auto - create a time and sales list from stock quotes with RTD (REAL TIME DATA) in a work sheet

[virgonet888khr]

Hello everyone, I am pleased to find this forum. One question which might not be so difficult to answer for You :
Assuming I have a small cap with aprx. 1000 trades a day, I have a work sheet with a RTD feed of 3 columns
a.) date and time
b.) price
c.) traded Volume
How can I program Excel what it writes a new line for every new trade occures. At the end of the trading day the result would be a simple T&S list which I intend to analyse and further calculate with it. Thanxxx

 

[severynm]

Where is your data coming from? Have you tried looking into using Power Query to pull the data into the sheet? You cannot get "true" real-time data in excel - Power Query can be set up to automatically refresh the data, but I believe the minimum refresh is every 60 sec.

 

[virgonet888khr]

Where is your data coming from? Have you tried looking into using Power Query to pull the data into the sheet? You cannot get "true" real-time data in excel - Power Query can be set up to automatically refresh the data, but I believe the minimum refresh is every 60 sec.

My data comes from a broker via API /RTD and they are "true" real-time and thats not my problem ,...I want that a makro or VB -App writes the previous data into a table of aprx. 3 colums everytime a new data comes in. New data comes in for every new T&S in smallcaps aprx. 1000 trades / day. Thank you