yogi_High Value Of A Stock In A Specified Period Of Time

Google Spreadsheet   Post  #2527

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-26-2018

question by: study1245
https://productforums.google.com/forum/#!topic/docs/OzoXDvWGL00;context-place=forum/docs

Regarding help for spreadsheet formul
Hello,

I have a formula below which works perfectly but need some modifications in the formula below:

=query({googlefinance(A1,"high",today()-180,today())},"Select Max(Col2) Label Max(Col2) ''",0)

I want 180 days back to start from specific date and not from today. So the 180 days should start from suppose 1st August.

Kindly Help.