URGENT - taking data from the web

[GustavoR]

I want the macro to navigate to:
Tesouro Direto - Consulta Ttulos

and retrieve the second "Compra" row value of the:

NTNB Principal 150824
NTNB Principal 150535
LTN 010118

For example, for a instance, it should get: R$ 1.386,49; R$ 713,74; R$ 692,93.

Notice that those prices change continously.

I would really appreciate if you guys could do that for me,

Thank you very much!

 

[Matt Allington]

You should look at Power Query.

Watch this to see how it works. https://m.youtube.com/watch?v=l3ZkLUmzJE4