Hi Josh,
Have been using your utility for quite a while now, very good work. One issue though i find consistently is that during volatile session some of the quotes are missed. Many times these are the high or low made for the candle and since we missed those quotes they are not captured. We can get them by backfill but that wont be practical.
So my question is can "Application.OnTime Now() + RP" run the code after every
1 ms if i put 0.001 in RP( i.e 0.001 in excel for refresh interval) or Now() can only accept till seconds only ?
Can you modify the code to run timer routine every millisec ?
Regards,
Naveen