Hello friends.

There is a crypto exchange which provides vital data via api calls but the most important parameter is not included in their api endpoints. It is the change in price from yesterday's close (% day change).

I had posted a question to retrieve info via api and and I thank @Marc L who had given me a solution to that without a json parser which was a beautiful answer but my requirement remains incomplete without the %change parameter. Since the %change parameter is not available, there is no other way but to scrape that information from webpage. I do not want to use power query or new features availble in excel as I am using Excel 2007 version. I do not want to use .navigate option of internet explorer either because the version of IE installed on my computer is very old and misbehaves. After doing a google search, I tried my best to get a solution to this via MS HTML Object, Internet Control, XMLHTTP libraries and web services but could not get it work. I request for help here on this forum which will give me a desired output.

Requirement:
Assuming cell A1 has coin name WRX-INR, B1 should get the price using example formula =scrapeudf(A1,price) and C1 should get the %change using example formula =scrapeudf(A1,change). Given below is the screenshot of what I am looking for from the webpage. I tried it with some class names and XPATH given below but I am unable to scrape the values.
class="sc-bwzfXH jsJuLQ"
class="sc-bwzfXH jaArUU"
class="price-box "
/html/body/div/div/div[2]/div[2]/div[1]/div/div[2]/a[6]/div[2]/div[2]/span/text()[2]
//*[@id="root"]/div/div[2]/div[2]/div[1]/div/div[2]/a[6]/div[2]/div[2]/span/text()[2]

Kindly assist. Thank you

WX.png