I want to find high and low values of A1 field which is updating every second (importing values from a trading platform). Is it possible to make a line chart with this updaing values.
I want to find high and low values of A1 field which is updating every second (importing values from a trading platform). Is it possible to make a line chart with this updaing values.
Based on your question, you need to have a macro that runs every second (which is not great by the way because it can "freeze" the rest of Excel if you want to use it).
Use this macro as the template for running every second:
Sub timer_copy_data()
interval = Now + TimeValue("00:00:01")
'Code to run every second
Cells(Range("A" & Rows.Count).End(xlUp).Row + 1, 1).Value = Cells(1, 1).Value
Application.OnTime interval, "timer_copy_data"
End Sub
This should copy the data into the next empty row in column A every second once you start the macro.
For the chart, follow this tutorial (one of ours) to make a dynamic chart.
Thank you Mr. Don, This iis exactly what I want. I changed the time to every 20 seconds and plotting a line chart.Thanks a lot.
Das
Kerala
India