Import historical quotes from Google spreadsheet

Hi guys,

I’m trying to import historical quotes thanks to a published google spreadsheets that I’ve done :

But it’s not working on portfolio performance. Below what “print server response” returns with HTML. What could I do to make this working please ? I also tried to use english names but it’s not working neither. Local html files can’t be loaded on portfolio performance, so I have to publish it.

Suivi - Google Drive

Suivi : Feuille 1
Plus haut (jour)
Plus bas (jour)
Cotation Volume
10 janv. 2021 0 0 145 0
11 janv. 2021 0 0 146 0
Published by Google SheetsSignaler un cas d'utilisation abusive Mise à jour automatique effectuée toutes les 5 minutes

I suspect the Date format is not recognized by PP
I am confused by your reference to Google drive. Usually you import a csv file located on your PC.

Google Sheets is not PP compliant as it is not a static website. The table is dynamically created via Javascript.

Ok then, thanks for your answer.
I wanted to do this because some funds where not available on Yahoo Finance, so I needed a dynamic way to import prices every day (Google sheets could do that with the function GoogleFinance).
But I found another solution with the data available on the website of Financial Times : missing funds where available on it.
Thanks for your help.
We can close the subject :slight_smile: