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))
'Google Finance' 카테고리의 다른 글
How to get the stock price of Tesla from Google Spreadsheet (0) | 2021.09.02 |
---|---|
JYP Ent. 주가 확인하기 - 구글스프레드시트 (0) | 2020.07.30 |
[구글스프레드시트] 현대자동차 주가 얻어오기 (0) | 2020.07.17 |
[구글스프레드시트] SK바이오팜(에스케이바이오팜) 주가 얻어오기 (0) | 2020.07.02 |
[구글스프레드시트] 애플(APPLE) 주가 얻어오기 (0) | 2020.06.24 |
[구글스프레드시트] 니콜라(Nikola) 주가 얻어오기 (0) | 2020.06.18 |
[구글스프레드시트] 디즈니(Disney) 주가 얻어오기 (0) | 2020.06.18 |
[구글스프레드시트] 스티치 픽스(Stitch Fix) 주가 얻어오기 (0) | 2020.06.06 |