Does anyone know how i can get one cell to record the number which is in another cell at various time intervals throughout the day? The number i am trying to record is PNL i have the sheet linked through esignal, so the PNL number would be moving around. Any help would be appreciated. thx! -Dan
VBA Windows Timer Event ... It can be set to go off every X seconds or X minutes or whatever you set...and put a value from cell whatever into cell whatever... etc.. If you don't write VBA you may have a friend who can or local colledge student...
Thx for the response! So then i take it there is no formula to do this right out of excel? I just googled VBA windows timer event, is there any extremely userfriendly VBA timers i could just buy keeping in mind i dont know any programming?
ok the formula is as follows =IF(NOW()-TODAY()<=A99,$R$96,B99) A99=Time you want to record at R96=PNL B99=the cell you want to record the data in This will give you a circular reference error, but you can just click X on the box and it will work A99 is set to time format B99through B110 did not update because it was already past that, time but you can see how B111 through B115 record the pnl number at the given time here is what it looks like:
I posted a VBA solution to this exact problem in this thread: http://www.elitetrader.com/vb/showthread.php?s=&postid=2406284#post2406284