excel vba - Incoming market feed to save in different cell using VBA -

I have inbound market feed for a particular stock from 9.30 -3.30. Tick ​​will change every tick by the price. I have to change the value in the cell every time and it changes to a different cell. I am just starting to use VBA, so any help would be appreciated.

Announcement variables:

  Range Dim Dims in the form of R-dimensioned R Y, the integer set Y = worksheet ("Equity"). Range ("F158")   
 Selecting cells where the value varies in each other:  
  X = Set the worksheet ("Equity"). Category ("F152"). Run the loop: Not sure that this is correct:  
  F = 0 to 10000 step 1 y = x next y = y + 1 termination For sub   
 If this is wrong then correct. Thank you in advance   
 
 
 You  Worksheet_Change  event Below the code code section of code Keep in Once the range is in F158 and between 3.3 and 9.3 and it is different from the previous value, then this range will paste the value in G158  
  Dim Oldval Double Private Sub Worksheets (range of Byline target)) Restart the error Next application. Enabled avent = wrong (if there is no target, then the range ("F158") is not the goal. Target = value; = 3.3 and goal. Value & lt; = 9.3 If Old Old & lt; & Gt; Target then target Offset (0, 1). Price = Goal End if End If Oldval = Range ("F158") Value Applications Competent estimate = true and all