1

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.

player0
  • 124,011
  • 12
  • 67
  • 124
Jimtim59
  • 13
  • 3
  • it takes time to appear under closed – player0 Dec 15 '21 at 02:52
  • could you do it for mid/average/median? anything to get the average of todays date (instead of just seeing only yesterdays) would be appreciated so I can look at it as a column in a cell visually with the "Sparkline" function. Thanks. – Jimtim59 Dec 15 '21 at 11:56

1 Answers1

0

try:

={INDEX(GOOGLEFINANCE(A5, "price", WORKDAY(TODAY(), -5), TODAY()),,2); 
 GOOGLEFINANCE(A5, "price")}
player0
  • 124,011
  • 12
  • 67
  • 124
  • 1
    Thank You. This is exactly what I need. I can see it visually when I look up my watchlists during the day without going to each individual detail chart. – Jimtim59 Dec 15 '21 at 18:25