Google sheet formula for previous 7 day high

Ask Question

Asked 4 years, 4 months ago

Modified 1 year, 11 months ago

Viewed 1k times

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.

user0

26.2k8 gold badges49 silver badges78 bronze badges

asked Jul 24, 2019 at 14:27

Arun kumar

11 gold badge1 silver badge2 bronze badges

Add a comment |

1 Answer 1

Sorted by:

=GOOGLEFINANCE("nse:"&A2, "high", TODAY()-9, TODAY())

answered Jul 24, 2019 at 18:33

user0

26.2k8 gold badges49 silver badges78 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.