I have a sparkline for the daily price for the last 30 days for a share in google sheets using the following formula (F1):

F1 =SPARKLINE(GOOGLEFINANCE("GOOG","price",Today()-30,Today()))

I can also get the current share price using a second formula (F2):


I was just wondering if there is a way to append this value (F2 output) onto the end of the sparkline returned from F1, to get a hybrid sparkline with the current SP shown.

Note: I could put the output of the table of historic data provided in F1 (just this bit: GOOGLEFINANCE("GOOG","price",Today()-30,Today()) into another sheet, and then append the current SP on the bottom of the output... but I wanted to be able to vary the number of historic days and the share in question, and have this for a large number of shares, so a formula solution would be preferred.

Thanks in advance.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.