2

Can any one help how to get maximum high of given days excluding weekly off days (sat/sunday) from google finance.

I am using formula like: =query(GOOGLEFINANCE("NSE:"&Y3,"high",(TODAY()-55),TODAY()),"Select Max(Col2) label Max(Col2)''")

However, it doesn't exclude weekly off days. I have tried to use WORKDAY / workday.intl functions but unable to fetch the correct day. Pls help me.

Improve this question
2
  • What about holidays? What exactly are you trying to receive from that GoogleFinance function?
    – CodeCamper
    Commented Dec 8, 2019 at 18:13
  • I think you should rephrase your question to "How to get the high of a given number of valid trading days with the GoogleFinance function"
    – CodeCamper
    Commented Dec 8, 2019 at 18:35

1 Answer 1

Reset to default
0

I am grabbing the last 365 valid trading days as reported by GoogleFinance then with array_constrain we are basically saying grab the last 55 trading days to get the highest.

=query(array_constrain(GOOGLEFINANCE("F","high",(TODAY()-365),TODAY()),55,2),"Select Max(Col2) label Max(Col2)''")

You do not have to use Query so you can do something like this:

=max(index(array_constrain(GOOGLEFINANCE("F","high",(TODAY()-365),TODAY()),55,2),,2))
Improve this answer

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.