You can get the stock price of Samsung Electronics by using Google Finance function in Google Spreadsheet.
AI(Artificial Intelligence), Cloud and 5G are keywords that represent the 4th industrial revolution, and one of the essential materials in the 4th industry is semiconductor. And Samsung Electronics is a representative memory semiconductor company.
As the 4th industrial revolution predicted that demand for semiconductors would rise, and recently the stock price fell due to the influence of COVID-19, people's interest increased.
1. Real-time (real-time price information may be delayed up to 20 minutes)
=GOOGLEFINANCE("KRX:005935", "price")
2. Closing price on a specific day
=GOOGLEFINANCE("KRX:005935", "close", DATE(2020,4,28))
반응형
'Google Finance' 카테고리의 다른 글
| 구글스프레드시트 코스닥(KOSDAQ) 그래프 그리기 (0) | 2020.05.13 |
|---|---|
| 구글스프레드시트 코스피(KOSPI) 그래프 그리기 (0) | 2020.05.12 |
| 구글스프레드시트 코스피(KOSPI), 코스닥(KOSDAQ) 지표 얻어오기 (0) | 2020.05.07 |
| 구글스프레드시트 WTI 원유선물 ETF 그래프 그리기 (0) | 2020.05.04 |
| How to get S&P500 and NASDAQ index from Google Spreadsheet (0) | 2020.05.02 |
| 구글스프레드시트 S&P500, NASDAQ 지수 얻어오기 (0) | 2020.05.01 |
| 구글스프레드시트 삼성전자 주가 얻어오기 (0) | 2020.04.28 |
| 구글스프레드시트 WTI 원유선물 ETF 가격 얻어오기 (0) | 2020.04.27 |