Extract data from a chart on website

The Historical Data tab should be friendlier to work with:

It has a download option that exports CSV but you could also connect to the web page via Power Query with a query like this:

let
    Source = Web.BrowserContents("https://finance.yahoo.com/quote/WPLCX/history?p=WPLCX"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".Pend\(10px\)"}, {"Column2", ".Pend\(10px\) + *"}, {"Column3", ".Pstart\(10px\):nth-child(3)"}, {"Column4", ".Pstart\(10px\):nth-child(4)"}, {"Column5", ".Pstart\(10px\):nth-child(5)"}, {"Column6", ".Pstart\(10px\):nth-child(6)"}}, [RowSelector=".Pend\(10px\)"]),
    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type date}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Date"}, {"Column2", "Open"}, {"Column3", "High"}, {"Column4", "Low"}, {"Column5", "Close"}, {"Column6", "Adj Close"}})
in
    #"Renamed Columns"

Thank you AlexisOlson, 

But this is just example. I have many different websites, which I need to extract data from. 

Usually there is only chart without any download option or historical data table..

That's why I am looking for an option how to extract data from the chart.

Here is another case

Conseq - UNIQA CEE Akciový fond (CZK)

Hi JanD ,

Agree with AlexisOlson .such a difficult requirement could not be realized currently.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback - Ideas

Best Regards,
Eyelyn Qin

Hi JanD 

Did you figured how to solve this? I'm trying to build somoething similar as well i can´t find a solution

I had this problem too and found a few online tools out there that do this well. I thought DataFromChart was the simplest to use as it also had some free AI credits I could use and was also more geared towards finance. I initially tried WebPlotDigitizer but it was too clunky (imo)