Build a small stock screener in Google Sheet

I want to do a stock screener which does a daily scan of the following markets: All major US stocks, from the indices SP500, NYSE, Nasdaq composite and Rusell 3000 All major Canadian stocks. Large and mid cap European stocks, from these markets: UK, Germany, Spain, Italy, France, Netherlands, Portugal, Sweden, Norway and Denmark This scan is based on data from the API at t [login to view URL] from which I have an API Key. No stocks should be below 0,5 billion USD in market cap. The output should be as follows: One sheet for each country. Sheet 1: US, Sheet 2: Canada etc. The data should be as follows, with the following values gathered from the API: These are the columns that should be in the Google sheet. Stock name Ticker code Price/Book Price/earnings Market Cap Value* All these data values need to be captured for all stocks from the API. The Value mentioned above should be 0,1 or 2, depending on the following: If Price/Book is below 1, then add +1. If Price/earnings is below 10, then add +1. This means that stocks that meet both conditions will have the value 2, while stocks that meet one of the conditions have the value 1, and if none of the conditions are met then the value is 0. I believe I can make 100.000 requests a day with the current API key. If what I have mentioned above is too much for one day, we can spread the requests over two days.