Macro help

Hi all,

I need help and need a macro . I have list of the parameter in a column .I need help for a macro which run till black came and also append the output for all the parameter.   

lets list is like below. just for example..

TCS

WIPRO

HCL

---

Marco will open below url and edit "symbol=TCS"  based on the list

https://www.nseindia.com/marketinfo/sym_map/symbolMapping.jsp?symbol=TCS&instrument=OPTSTK&date=-&segmentLink=17

Please help be for a marco.