hi all,
I would to extract the value in market cap(市值) from this link: NTES-S (9999.HK) 股價、新聞、報價和過往記錄 - Yahoo 財經 by VBA to a worksheet
However I have no idea to do it.
The html code is this
<td class="Ta(end) Fw(600) Lh(14px)" data-test="MARKET_CAP-value" data-reactid="81"><span class="Trsdu(0.3s) " data-reactid="82">484.112B</span></td>
I have tried to use the method of getElementsByClassName by it seems that there is no class name to let me extract it.
Could anyone help me on this? thank you very much.
I would to extract the value in market cap(市值) from this link: NTES-S (9999.HK) 股價、新聞、報價和過往記錄 - Yahoo 財經 by VBA to a worksheet
However I have no idea to do it.
The html code is this
<td class="Ta(end) Fw(600) Lh(14px)" data-test="MARKET_CAP-value" data-reactid="81"><span class="Trsdu(0.3s) " data-reactid="82">484.112B</span></td>
I have tried to use the method of getElementsByClassName by it seems that there is no class name to let me extract it.
Could anyone help me on this? thank you very much.