[Google Spreadsheet] How to get the stock price of Starbucks

You can get the stock price of Starbucks by using Google Finance function in Google Spreadsheet

You can take the Starbucks coffee stock from Google Spreadsheet and manage stock returns and various indicators.

 

You can also take an index of NASDAQ on which Starbucks is listed and use it as a benchmark indicator of how much money you earned compared to the returns on your portfolio.

 

You can see how to get the NASDAQ index in the following post.

 

2020.05.02 - [Google Finance] - How to get S&P500 and NASDAQ index from Google Spreadsheet

 

반응형

 

Starbucks coffee, which started as the first store in Seattle, is now the most famous coffee shop in the world.

 

Howard Schultz, CEO of Starbucks, is the driving force behind Starbucks' growth to become a global coffee shop. China's Luckin's coffee may have been ambitious, dreaming of China's Starbucks, but has recently been notified of the abolition of listing on the NASDAQ due to accounting irregularities.

 

Starbucks is a coffee shop, but it is also attracting attention as a Techfin company. Currently, Starbucks siren orders have higher payment rate than Apple Pay of Google Pay. That's because Starbucks has may loyal customers.

 

If you use the Google Finance function in the cell of the Google Spreadsheet, you can see the real-time price information of Starbucks and the stock price of the past.

 

1. Real-time (real-time price information may be delayed up to 20 minutes)
=GOOGLEFINANCE("NASDAQ:SBUX", "price")

2. Closing price on a specific day
=GOOGLEFINANCE("NASDAQ:SBUX", "close", DATE(2020,5,15))