The Formula: =SPARKLINE(INDEX(GOOGLEFINANCE(A2, “price”, EDATE(today(), - 12), today()),,2), {“charttype”, “column”; “color”, “green”}) Note: The "12" in the formula is the number of months. You can change it to any number you want to get a chart for a 24, 36, 48 month period or more.
The Formula:
=SPARKLINE(INDEX(GOOGLEFINANCE(A2, “price”, EDATE(today(), - 12), today()),,2), {“charttype”, “column”; “color”, “green”})
Note:
The "12" in the formula is the number of months. You can change it to any number you want to get a chart for a 24, 36, 48 month period or more.