The Inside Day is a technical chart pattern indicating a period of market consolidation. This pattern occurs when the trading range of a given day, including its high and low prices, is entirely contained within the high and low prices of the previous day. It signifies that the market is experiencing a contraction, as participants are indecisive or cautious, leading to a narrowing of the trading range.
GOOGLE SHEETS FORMULA
“B1” = Stock Code
=(GOOGLEFINANCE(B1,"price")/QUERY(GOOGLEFINANCE(B1,"close",(TODAY()-WEEKDAY(TODAY()))-5,(TODAY()-WEEKDAY(TODAY()))),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1 LABEL Col2 ''"))-1