Spreadsheet / Data recording help needed

J

Jtrader342

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.
 
You must log in or register to reply here.
Back
Top