Without VBA, just go directly to the data-get the data-and select the data table you want from the website. The obtained data can be updated in real time by right-clicking refresh, which meets the use requirements. I tried Tian Tian Fund Network, and there was no problem. Futures are generally Cai Dong's data and can also be manipulated.

It is very long and difficult for vba to write this function code, because net catching is not VBA's strong point, and python may be more convenient.