using winhttprequest, get table data from webpage and perform calculation in excel sheet

hi! i am a new member out here. my friend suggested i can seek some help on my excel vba question

i have an excel file with 50 addresses in column A. I want to fetch their quantity from this webpage bscscan dot com /token/0x4338665cbb7b2485a8855a139b75d5e34ab0db94#balances and put it in column B. Thereafter, revsit the page at an interval of 1 minute and record the % change in the quantity. If the initial fetched quantity of a particular address is 100 and after 1 minute if it becomes 110 then corresponding cell in column C should hold 10%. Continue this loop for 10 minutes and record change % at an interval of every 1 minute and do it till 10 minutes and then end the sub.

sorry for the broken url as i was not allowed to enter url

I started with this piece of code but the response I get is an error page and another difficulty is that I dont know how to go to second page if any address is not found on page 1

Please Login or Register  to view this content.

I request someone to help me with this code. I am attaching the excel file. Thank you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you today.)