I have here a picture of What I have. I want the previous 5 days closing prices in a column including todays price. The problem is that I only get 4 date prices (cell range F6:F9) excluding todays date price (cell F3).

I understand that the date is not in the correct format in cell range E6:E9, but I don't care for this, as I only care for the close prices in column F (cell range F6:F9)

Below is the code that I have in the cell E5: =index(GOOGLEFINANCE($A5,"price",workday(today(),-5),TODAY()))

Here is a picture of What I want. I want code for cell E12.

Below is the code in cell F3: =GOOGLEFINANCE(A3,"price")

Thanks.

CodePudding user response：

try:

={INDEX(GOOGLEFINANCE(A5, "price", WORKDAY(TODAY(), -5), TODAY()),,2); 
 GOOGLEFINANCE(A5, "price")}