Hello,

I need to get a database from a platform I am a subscriber to and need a username and password to access the database. I am looking for historical data on investment funds in Brazil.


I was able to extract the data from the web using the normal excel process, going to "data" and "web". It worked for the fund in the link

As indicated in the images below:

Screenshot_4.png
Screenshot_3.png

However, the same does not work when I search for any other fund.

As indicated in the image below:

Screenshot_5.png

I've already tried changing the table's permission settings and entering the username and password in the settings, but nothing worked.

When I try to do other searches, as indicated in example 2, it is as if Excel cannot access the username and password and does not return the table that is on the website, only the table that appears in the free version (without username and password).

This process of pulling data from this platform via Excel only worked for my first search, which was in the first example I gave. It no longer worked for the other searches.


Does anyone know how to fix this? I would like to automatically retrieve historical data from several funds on this platform, without having to go through them one by one. I would not like to use VBA or Python. Since the process worked for the first search, I understand that it should be possible to continue.

Thanks!