PLEASE EXPLAIN THE FOLLOWING FORMULA FOR GOOGLE FINANCE EXCEL SHEET. IT IS ACTUALLY FOR EVALUATING “MINIMUM” PRICE OF A STOCK IN LAST SIX MONTHS. WILL BE THANKFULL IF YOU CAN PLEASE ;
(1) : CAN U EXPLAIN THE FORMULA IN PLAIN EGNLISH.
(2) : ALSO, WHEN I PUT THIS IT SHOWS ERROR AND NOT WORKING.
=MIN(INDEX(GOOGLEFINANCE(A2,”ALL”,TODAY()-180,TODAY(),0,5))*1.20
A2=CONTAINS PRICE OF A STOCK