Hello, I have the same challenge for two websites, wich I want to import automaticly the data to excel. First is:
http://www.b3.com.br/pt_br/market-data-e-indices/servicos-de-dados/market-data/consultas/mercado-de-derivativos/contratos-em-aberto/por-tipo-de-participante/
Second is:
https://ptax.bcb.gov.br/ptax_internet/consultaBoletim.do?method=consultarBoletim
Both I have to enter some "configurarion" before I get the table. Date is one of them, but I have other options and I need to press a buttom to have the data I want to integrate to uptadate in an excel table.
Can you help me to understand how can I do that? The simple table integration I can do already, but with these options on the site and a standar URL (don´t change according with the input data) I can´t.
Thank you very much.