Action Japonaise :

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTXML("https://www.google.com/finance/quote/6758:TYO";"//div[@class='YMlKec fxKbKc']");1);CHAR(165);"");",";"");".";",");",00";"")


Obligation Boursorama :

=substitute(TRIM(index(importxml("https://www.boursorama.com/bourse/obligations/cours/1rARABO/";"//div[@class='c-ticker__item c-ticker__item--value']");1;1));".";",")

Bourse Direct
=value(SUBSTITUTE(IMPORTXML("https://www.boursedirect.fr/fr/marche/euronext-paris/amundi-index-msci-world-ucits-LU1437016972-MWRD-EUR-XPAR/seance";"//span[@class='quotation-last bd-streaming-select-value-last']"); "."; ","))


Morning Star :

=REGEXREPLACE(INDEX(IMPORTXML("https://www.morningstar.fr/fr/funds/snapshot/snapshot.aspx?id=F000010PEE";"//td[@class='line text']";2);1;1);"[a-zA-Z]";"")


=REGEXREPLACE(INDEX(IMPORTXML("https://www.morningstar.fr/fr/funds/snapshot/snapshot.aspx?id=F000000R1N";"//td[@class='line text']";2);1;1);"[a-zA-Z]";"")


=REGEXREPLACE(INDEX(IMPORTXML("https://www.morningstar.fr/fr/funds/snapshot/snapshot.aspx?id=F000010PEE";"//td[@class='line text']";2);1;1);"[a-zA-Z]";"")

Boursorama Action historique

=QUERY(IMPORTHTML("https://www.boursorama.com/bourse/opcvm/cours/historique/0P00001UFS";"table";0);"SELECT Col1, Col2")


Boursorama

=index(importxml("https://www.boursorama.com/bourse/opcvm/cours/0P00001UFS/";"//div[@class='c-ticker__item c-ticker__item--value']");1;1)