Recent content by TonyW

Another person in other forum helped me out, it's basically same as you said. Thank you.

I have a different formula that uses RTD values which doesn't change that often in the day. It would just be more visible to me since I am tracking like 10 different screens.

I am using excel RTD exported from thinkorswim. I like to get a simple pop up box whenever an RTD value changes. I looked online and found an example: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$4" Then MsgBox Target.Value & " " & Target.Offset(0...

Please take a following attachment, mainly I just have 2 columns, strike price and OI. I used insert recommended chart, the clustered column chart is the one that looks best for me. I just wanted to dynamically add a vertical line to the chart with whatever the current price is (430.5). I tried...