Scrape quotes from website CSV

Dear PP’s,

I’m trying to get the quotes for a fund but there is no ISIN. I need to scrap it from a website or csv.

I was trying to inspect the page for JSON but I couldn’t figure it out.

The page is: PPR SGF Stoik - Resultados — Soluções Stoik

The CSV file, I was able to find it under: | Created with Datawrapper

More specfic here:

Any hint how to update the quotes automatically?

There might exist a kind of Workaround by Utilities Google Sheets to convert CSV to JSON


Quick info: Google have changed the API.

New API: Method: spreadsheets.values.get  |  Sheets API  |  Google Developers

I needed also to create a API Key under Google Cloud Platform