Hello. I need some help making a stock screener. In the A column I want to be able to put in any stock symbol and then in column B it automatically show the daily % change. The % change formula is: =RTD("quote.server", , "Symbol", "*", "fPercentChange"). Can anyone help me with the macro? I have only this much code: Selection.End(xlDown).Select....It goes to the end of the list what ever size it may be. Then I need to select from that point all the way up to A2 selecting the entire range. Then somehow say paste in the next column the %change using the formula: =RTD("quote.server", , "Symbol", "*", "fPercentChange").

Regards,