+ Reply to Thread
Results 1 to 5 of 5

TimeStamp

  1. #1
    Registered User
    Join Date
    03-10-2019
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    10

    TimeStamp

    I have a stock trading work sheet, and there are two things I am trying to accomplish and stuggling a lot :
    (1) In my trading sheet, I have Buy and Sell in a certain column which is based on certain conditions (strategy). So these Buys and Sells appear whenever the conditions are met, in Real Time (Trading sheet takes data from the internet and continues to update every 1 minute, so there are many Buys and Sells spawning from time to time). What I am looking for is the exact time stamp (data not so required as I know the sheet is being updated today). Strangely upon scouring the net, every body talks about the same formulae viz. IF(A2"",IF(B2"",B2,NOW()),"") and this does'nt serve my purpose at all. If this is all confusing, let me give a clear example here :
    Columns A-E has data like High, Low, Close, Open etc etc
    Column F has a signal : Buy or Sell
    So all I want is some column after Column F which updates the time as and when a signal appears in the Column F. The reason is I want to see which are the new signals that appeared as I am handling 200 rows of scrips.
    OR
    (2) Can Column F which contains the signal, Buy or Sell be colored in such a manner it accomplishes the following :
    (a) New signal BUY as and when it appears should carry a different color, let us say DARK GREEN
    (b) Likewise New Signal SELL as and when it appears should carry a different color, let us say DARK RED
    (c) All signals after a time decay, say 1 minute (which if configurable would be awesome), should change color. So in the case of Buy (Dark Green), color can change to Light Green and in case of Sell (Dark Red), color can change to say Orange

    Just to add to the above, the formulae IF(A2"",IF(B2"",B2,NOW()),"") seem to accomplish, but my excel sheet refreshes every 1 minute, and the moment it refreshes, the time stamp changes to the local computer time (which is current and not the time when the signal came actually).
    I even tried my own like =IF(F2="Buy",IF(F2="Sell",NOW(),"")), getting the time stamp, again when the excel refreshes, the time stamp changes to the current time. For e.g. if Buy or Sell came at say 10:15 hrs, after refreshing (let us say 2 minute refresh interval), the time reflected is 10:17 hrs.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello JediTrader,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-10-2019
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: TimeStamp

    Thank you Arlu1201. Really glad to be part of this community.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: TimeStamp

    Hi,

    As you may be read description of this sub-forum - this one is solely to introduce yourself.

    So here I'd say: welcome to the forum. And that's it.

    With your merit question, please go to appropriate sub-forum. Look what sub-forums we have: http://www.excelforum.com/microsoft-...el-help-forum/ and post a new thread in one of them (the most appropriate one).
    Best Regards,

    Kaper

  5. #5
    Registered User
    Join Date
    03-10-2019
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: TimeStamp

    Thank you Kaper. Appreciate your clarification and response. I shall strictly adhere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-09-2016, 02:23 PM
  2. [SOLVED] VBA - Convert Date/Timestamp into American Date and Military Timestamp
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-01-2015, 03:43 PM
  3. Replies: 18
    Last Post: 02-24-2014, 06:13 PM
  4. TimeStamp
    By AAKASH JAIN in forum Excel General
    Replies: 7
    Last Post: 12-29-2011, 03:19 AM
  5. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  6. Timestamp
    By ctasich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2010, 11:33 AM
  7. [SOLVED] timestamp
    By Peri in forum Excel General
    Replies: 6
    Last Post: 06-24-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1