auto-refresh data in excel from finance.yahooo with more than 100 rows

hello together

i cannot find a solution for this problem, not in any forum and not with google... so maybe you can help me out.

i'd like do get historical data for example from finance.yahooo.com into excel. it would be nice when the data auto-refresh when in excel i go to "data / refresh all" as you can see in excel in affix.

i imported the data from finance.yahoo with the following link:

https://finance.yahoo.com/quote/1773...tory?p=1773.HK

then i got the data with "from the web"

sadly, it only loads the first 100 rows... do you think there's a possible way to get more rows than the first 100 rows? would be nice to have at least 250 rows or more..?

it doesn't matter from which site the data comes from, if there's no possibility to download and auto-refresh the excel with finance.yahoo.com, there's maybe a way with another site like https://ng.investing.com/equities/ti...istorical-data ?

thank you very much & happy day

Kevin