How to parse a value in Google Sheet?

Question

Parsing

It is necessary to get two bybit values ​​from the site https://www.coinglass.com/FundingRate

in the table. Through the desktop application, the attempt was unsuccessful, because. Power Query is not reading the table.

I tried in Google Sheets via IMPORTXML, but I don’t quite understand how to take specific two cells from there, and not the entire column under the tag. Tell me, please, how to be here?

Answer 1

You cannot "parse" this data with IMPORTXML, because it's not static html data.
You need a dynamic web scraping tool.