daily trade blotter

  • Thread starter Thread starter Day Trader
  • Start date Start date
Don Guillett said:
How nice. Do you have a question?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


In column E, I will be inputing trades that are executed throughout the day. For each trade I need to time stamp what time such trade was executed in column F.
Click to expand...
 
It sounds like you want an automatic time stamp, but you said you
wanted to track the time the trade was executed, so I don't see how
Excel would get that info.
If you want to have the current time go into a cell you can type
[Ctrl]: (that is [Ctrl][Shift];).
 
right click sheet tab>view code>insert this>save
Now when you enter something in col F the time will show in col G

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f200")) Is Nothing Then Exit Sub
Target.Offset(, 1) = Time
End Sub
 
Don Guillett said:
right click sheet tab>view code>insert this>save
Now when you enter something in col F the time will show in col G

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f200")) Is Nothing Then Exit Sub
Target.Offset(, 1) = Time
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


I right click on Sheet 1
Click to expand...
Then click on view code

Once in view code where do I type in save?
 
Back
Top