URL I am using
https://www.moneycontrol.com/technical-analysis/maharashtraseamless/MS02/daily
Xpath
//*[@id="techratingsumd"]/div[1]/div[2]
It give following
.ara { fill: none; stroke: #fff; stroke-width: 2px; } .arb { fill: #fff; } -- Bullish
After using formulas i am getting Bullish
Approx 100 Website i have used give correct answer
These are Bullish, Neutral and others
Today also the formula is giving same value but the value at web site is changed to Neutral.
formula I am using is
=XPathOnUrl(D809,$F$1)
Please hep me to get correct values.
And second -
What is refresh rate - by what frequency excel going to check web page again