How can I get a table from an url?

Hi all,

I need to get in matlab the table from this url:

https://www.cambriafunds.com/tail-holdings

I tried with webread and urlreadtable functions but it doesn't work. Someone can help me? Many thanks!

Answer 1

[Meet]

Hi Adriano,

I have successfully replicated the issue you encountered while attempting to fetch the table. Unfortunately, the "webread" function in MATLAB is not equipped to execute JavaScript; it can only retrieve the raw HTML content from a URL.

To address the issue, I recommend using the following API endpoint:

https://www.cambriafunds.com/assets/data/FilepointCambria.40C1.C1_ETF_Holdings.csv

which I found it from the Web Inspect and this directly provides the table in CSV format. You can then utilize the "readtable" function in MATLAB to read the table. Here is an example:

csvUrl = 'https://www.cambriafunds.com/assets/data/FilepointCambria.40C1.C1_ETF_Holdings.csv';
dataTable = readtable(csvUrl);

The above workaround will only work as long as the URL for the csv file is not changed by the website host.

For more information, you can refer to the following documentation links:

webread: https://www.mathworks.com/help/matlab/ref/webread.html

readtable: https://www.mathworks.com/help/matlab/ref/readtable.html