question about data grabbing.

Question1
How to know the URL is insert in which column?
http://i.imgur.com/tuXLU.jpg

Question2
How this excel get the stock code? Entering different 4 digit in B1 will change the data.
I know it can check the url in edit query, but how it set get different data?
http://i.imgur.com/HQOMo.jpg

AttachmentSize
RevenueGrowth.xlsx71.21 KB