Need a formula for previous 7 working day high for a share
=INDEX(GOOGLEFINANCE("nse:"&A2, "high", TODAY()-3.3), 2, 2)
Used the above formula but I need only workday formula.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community