daily trade blotter

[Day Trader]

While day trading I'm required to keep a time log when each trade has been
executed.

 

[Don Guillett]

How nice. Do you have a question?

 

[Day Trader]

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.

 

[Reitanos]

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].

 

[Don Guillett]

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

 

[Day Trader]

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

Then click on view code

Once in view code where do I type in save?

 

[Don Guillett]

Please TOP post for me
save the workbook....