Excel sheet web scrapping

Ok I have this nasty huge excel sheet here [login to view URL] ====================================== Task1: Make a new column in between B and C. B contains company names right ? In the new column I need their stock ticker name There are many ways to do it - Way 1 : Let's say the company name is - "Exide Industries Ltd" ; search "Exide Industries Ltd Share Price" in google and scrap the data from there as you can see from this image [login to view URL] Run a python, node js or java program. That's it. Way 2: Yahoo Excel Macros ; read here [login to view URL] There are tons of other ways like If then Else statement of excel works too More reference : [login to view URL](exchange%20%3D%3D%20"NASDAQ")%20%26%20(last_price%20>%200.1)%20%26%20(last_price%20<%201500)%5D&restype=company&noIL=1 ============================================ Task 2: Add two more columns. Col A: will show the price of the stock in the time stamp mentioned @ time stamp column. Col B: If current G column in "Intraday" , it will show the price of the stock price of the stock of closing price that day. Otherwise it stays blank Col C: If current G column in "1-3 Days" , it will show the price of the stock price of the stock of closing price after 3 days of the mentioned date in the timestamp. Suppose the timestamp says "02-02-2016" then it will take closing price of the stock at "05-02-2016". Otherwise it stays blank Col D: will show the live price of the stock. Reference - [login to view URL] Budget 20$. I can allot you a day maximum. New work will follow by. If you want this work, Bid 4$/hour for 5 hours. Ask for a 20$ milestone. Write the value of H16262 from the excel sheet so that I know you had opened it atleast reading this :) and write "I will do this using _______ " (your preferred way) in the bid ...and you're hired.