Hello everyone,
I tried to scrap the share price from Money Control website
Link : https://www.moneycontrol.com/india/stockpricequote/cigarettes/itc/ITC
And with Web.Page, i am able to reach the value in power query editor, but when i load , it does not load in excel. Sometime error on load includes expression error and sometime load time error
Please suggest the solution
M Code that you can test
let
Source = Web.Page(Web.Contents("https://www.moneycontrol.com/india/stockpricequote/cigarettes/itc/ITC")),
Data8 = Source{8}[Data],
Children0 = Data8{0}[Children],
Children1 = Children0{1}[Children],
Children41 = Children1{41}[Children],
Children4 = Children41{4}[Children],
Children2 = Children4{0}[Children],
Children = Children2{25}[Children],
Children3 = Children{1}[Children],
Children5 = Children3{12}[Children],
Children6 = Children5{1}[Children],
Children7 = Children6{0}[Children],
Children8 = Children7{1}[Children],
Children9 = Children8{0}[Children],
Children10 = Children9{0}[Children],
Text = Children10{0}[Text],
#"Converted to Table" = #table(1, {{Text}})
in
#"Converted to Table"
Please suggest