Counting # of times a stock reaches a certain price in a session/Probabilities

[nickee]

How can I record # of times a stock reaches a certain number throughout the day? Currently I only have a function for when it is at that number it returns 1 and if not a 0. i need a running count.

Basically I am looking to record the success of a tick fade play.

When the $TICK reaches +1000 I want to short the /YM with a 20 point target and 30 point stop.

Can someone steer me in the right direction please?

 

[offthelip]

If you put this code in the worksheet change event it will do it for you.
I have assumed the price is in A2, the target in B2 and the count in C2.

Dim Above As Boolean
Private Sub Worksheet_Change(ByVal Target As Range)
If Not (Intersect(Target, Range("a2:a2")) Is Nothing) Then
 If Target.Value > Range("b2").Value And Not (Above) Then
   Application.EnableEvents = False
   Range("c2") = Range("c2") + 1
   Application.EnableEvents = True
   Above = True
  End If
 If Target.Value < Range("b2").Value Then
   Above = False
 End If
End If
 
End Sub

 

[LMacD]

Nickee - how are you capturing the ticker and where are you storing it?
It sounds like you are working with a live feed and day trading.
I am sure you would find a brokerage sofwtare would have all of the logic you are looking for and more.

 

[nickee]

Hi good morning,

I'm capturing it through thinkorswim. =RTD("TOS.RTD",,"LAST","$TICK")

 

[nickee]

Thank you for your message. I am still having a bit of trouble with it. Do you trade regularly? i'd love to share some of my notes and gain some more insight if you're up for it. I appreciate anything you can offer.

 

[nickee]

Thank you for your message. I am still having a bit of trouble with it. Do you trade regularly? i'd love to share some of my notes and gain some more insight if you're up for it. I appreciate anything you can offer.