live feed from stock exchange recording change every 15mins

Hi all

Just had a quick question. In my excel I have a live feed from a stock exchange. I want to record the value of the stock exchange every 15minutes. I have searched on here and I am currently using a macro that records every time the live feed changes. Only problem, is that within a couple of minutes I have about 180 cells with data. I just need data points for say, every 15minutes. Does anyone have any suggestions?

Currently I am just right clicking on the excel tab and going view code and entering my code there.

I'm new to macro's so would appreciate it if you could walk me through with baby steps.

Thank you very much for your time!

cheers, jono

Hi Buran

Thanks for your reply.

I am currently using the following macro. I just copied it from another thread on this forum.

Private Sub Worksheet_Calculate()
Worksheet_Change Range("B1")
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B1")) Is Nothing Then
Application.EnableEvents = False
Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
Application.EnableEvents = True
Application.EnableEvents = False
Range("B" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("B1").Value
Application.EnableEvents = True
End If
End Sub