|
daily trade blotter
While day trading I'm required to keep a time log when each trade has been
executed. |
daily trade blotter
How nice. Do you have a question?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" <Day wrote in message ... While day trading I'm required to keep a time log when each trade has been executed. |
daily trade blotter
"Don Guillett" wrote: How nice. Do you have a question? -- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" <Day wrote in message ... While day trading I'm required to keep a time log when each trade has been executed. 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. |
daily trade blotter
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];). On May 29, 10:22 am, Day Trader wrote: "Don Guillett" wrote: How nice. Do you have a question? -- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" <Day wrote in message ... While day trading I'm required to keep a time log when each trade has been executed. 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. |
daily trade blotter
"Don Guillett" wrote: right click sheet tabview codeinsert thissave 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 "Day Trader" wrote in message ... "Don Guillett" wrote: How nice. Do you have a question? -- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" <Day wrote in message ... While day trading I'm required to keep a time log when each trade has been executed. 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. I right click on Sheet 1 Then click on view code Once in view code where do I type in save? |
daily trade blotter
Please TOP post for me
save the workbook.... -- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" wrote in message ... "Don Guillett" wrote: right click sheet tabview codeinsert thissave 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 "Day Trader" wrote in message ... "Don Guillett" wrote: How nice. Do you have a question? -- Don Guillett Microsoft MVP Excel SalesAid Software "Day Trader" <Day wrote in message ... While day trading I'm required to keep a time log when each trade has been executed. 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. I right click on Sheet 1 Then click on view code Once in view code where do I type in save? |
| All times are GMT +1. The time now is 09:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com