Does anyone know how to record live data into a spreadsheet as it streams in? I have the DDE link setup and also a clock macro, but have yet to figure out how to have the sheet record the price, drop down and then record the next price so on and so forth creating a list of historical prices down a column. Basically this would be like a live chart within the sheet that automatically updates the data based on a time increment. Same thing as the live charts you get with your broker, but in a spreadsheet. Have everything working and can manually update the price to see the system work, but need it update and record the data automatically if possible. example: Starting with a DDE link streaming "Last" price the sheet would record the price at say, 1 minute time intervals. As the first minute passes the price at that time is recorded in cell "A1". As the second minute passes, the price at that time is recorded in cell "A2". The next minute price in cell "A3" creating a live updating list down the column as time moves forward. Seems there would be a way to do this, but might be something that has to done programatically, in which case I would have to find someone to do so as I am ignorant when it comes to programming. Any help would be greatly appreciated, J.
JTrader, You would need to do at least a little programming in order to do this. Basically you could create a sub routine that records the value and then calls Application.OnTime to have it callback at a given interval after you initially called it. Sub record() With Sheets("data") rowRange = .cells(.rows.count, 1).end(xlup).row + 1 .Cells(rowRange, 1).Value = Sheets("livefeed").Cells(1, 1).Value End With Application.OnTime Now + TimeSerial(0, 1, 0), "record" End Sub So then you can just call record whenever you want to start recording. This should read the value from a sheet called "livefeed" in the first row/column and put that value in the first column and last row where there is no data in the "Data" sheet.
I just figured out how to data log in Excel thru the DDE feed. PM me if you want to know how it did it easily.