I am trying to make a sparkline graph in Google Sheets that tracks the stock price of TODAY using google finance as time progresses. For example, at 8am it would show the opening price, and by close there would be a graph of that days rise/fall progress. I'm wondering if this is possible, as I've tried many variations of the following formula (which I am using for 3, 7, 14, 30, and 1 year graphs), but I cannot seem to integrate the TIME(), TODAY(), or NOW() at all and don't know how to move forward from here.
Here is the formula for my other sparklines:
...where F6 is the stock ticker, K12 is "line", and the -1 is changed to the timeline I want for the graph (ie. -7 is a week.) Anyone have any ideas to make this work?