Stock Data

There are many ways to demonstrate and track stock data. Here is a few examples I used:

you may use the following function in google sheet (use your my drive in google)

GOOGLEFINANCE("ticker-symbol", "attribute", "start-date", "end-date", "interval")

Using the following will give you the apple stock price:

=GOOGLEFINANCE("AMZN")

and you can change the stock symbol. In case you would like to follow multiple stocks, you can utilize the following with typing the stock symbol in cell B6 and then following command

=GOOGLEFINANCE(B6)

To build a one week chart (sparkline) you may use the following code:

=SPARKLINE(GOOGLEFINANCE(B6,"price",TODAY()-7,TODAY(),"daily"),{"charttype","line";"linewidth",1;"color","#5f88cc"})

You may change this to larger sparkline with changing the 7 to 365 days or different numbers.

and also if you need to see the company name, you may utilize following code:

=GOOGLEFINANCE(B6, "NAME")

You can also modify your sparkline using the following:

=sparkline(query(GOOGLEFINANCE($B2,"price",TODAY()-60,TODAY(),"DAILY"),"select Col2",-1),{"charttype","column";"highcolor","red"})

More details in the following link:

https://support.google.com/docs/answer/3093281?hl=en

All contents of this website are for demonstration only (as is) and should not be used for any commercial application(s) or any way that can create liability; there is no warranty of any kind. Use at your own risk.