finviz | Stock quotes and company data from Finviz | Business library

I hacked together the code below.

This is my code without concurrent.futures:

https://finviz.com/screener.ashx?v=152&f=cap_midover&c=1,16,17,18,65

I want to scrape the data from the website above using VBA so that I can obtain 5 columns that I want (Ticker, EPS, EPS this Y, EPS next Y, Price). There are 99 pages need to loop through and each pages have 20 tickers, which means I need to scrape almost 2000 rows of data. I'm able to do this by using PowerQuery but seems like it takes around 3min to refresh the data if I'm using powerquery.

I'm not sure if I use VBA to scrape the data would be able to speed up the time taken for the data to refresh or not so would like to get some help. I'm new to VBA and below is my code which give me an output of whole websites pages (not what I want) and the code doesn't loop through different pages from 1-99.

Most websites when you load ask you to accept cookies and privacy, I think it's mainly in the EU. I'm struggling on how to reuse the cookies so, I don't have to keep clicking "accept all", every time I load up chrome.

The way I'm thinking is that if I click on "accept all" the first time and save the cookie, I can write a code that fetches the cookie file and it knows I accepted the website cookie and so, it doesn't pop up again.

The website I'm using for this example is https://finviz.com/

I've been trying to get the information below, using the formula below, but it shows as loading indefinitely:

So finviz changed their website making it more difficult to extract data from their site. I am trying to get the date from the analyst ratings table but I get a series of numbers.

I am having Date column like this

I have a function that scrapes data from Finviz, and part of the function compiles a list of metrics. If the website address does not exist as it iterates through a list of stocks, it will still create a row in the Dataframe that includes the name of the stock, but does not include any of the metrics. I would like it so that if it cannot find the website, the row is either deleted at the end of the loop, or isn't included at all. Any insight into how I can adjust this function would be very appreciated.

I am scraping several financial metrics from Finviz using a for loop that iterates through a list of stock symbols. I am faced with an issue with the empty values ('-') on Finviz causing issues with subsetting the data down the line, as it is recognized as a string rather than a float, like the values I am trying to subset. I would like to nullify these values and have been trying to use the replace function from the Pandas module, but haven't had any luck. Ideally it nullifies as it iterations the second for loop so that it iterates as it goes rather than having to do it to the entire list after. Code is shown below: