跳至主要內容
前往資訊主頁
不確定該從哪裡著手嗎?歡迎進行簡短測驗,以便取得個人化建議。
課程 2 共 4 堂
Access Google Finance data in Sheets
Business Reporting
Google Finance: Research company performance
Google Sheets: Visualizing data
Visualizing Data: Flourish templates.
課程
0% 已完成
5 分鐘 以完成

Access Google Finance data in Sheets

Google_Finance_Research_company_performance_access_the_data_in_google_sheets_step_84GSOoo.jpg

Access Google Finance data in Google Sheets. Examine closing prices, percentage change or market movement over any timeframe.

Google_Finance_Research_company_performance_access_the_data_in_google_sheets_step_84GSOoo.jpg

Access the data in Google Sheets

You can access all of the Google Finance data in Google Sheets. This is helpful if you want to download, analyze, and visualize the data. 


Create a new sheet in Google Sheets ‘sheets.new’.


To access the finance data, click on a cell and start your query by entering:=GOOGLEFINANCE(“The full query requires the following:=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])


Add the ticker to the query:=GOOGLEFINANCE(“GOOG”“GOOG” is the ticker and can be replaced with any of the stock tickers from the 53 stock exchanges listed in Google Finance.


Add the attribute that you want the details of:=GOOGLEFINANCE("GOOG","price",This example shows that we’re interested in “price” for the stock GOOG. Other attributes you can examine are: "priceopen", "high", "low", "volume", "marketcap", “tradetime", “datadelay", “volumeavg", "pe", "eps", “high52", "low52".


Add the date period that you are interested in:=GOOGLEFINANCE("GOOG","price", DATE(2018,1,1), DATE(2018,12,31),


Now, add the timing interval:=GOOGLEFINANCE("GOOG","price", DATE(2018,1,1), DATE(2018,12,31),"DAILY")In this example, we’ve chosen DAILY but you can also look at WEEKLY prices.


To complete the query, click enter. The sheet will pull in the data we have requested. In this example, it will be the daily closing price for Alphabet’s (GOOG) stock price every day in the year 2018.

Congratulations!

Google_Finance_Research_company_performance_access_the_data_in_google_sheets_step_eHchLA9.jpg

You completed “Access Google Finance data in Sheets."

To continue building your digital journalism skills and work toward Google News Initiative certification, go to our Training Center website and take another lesson.

Google_Finance_Research_company_performance_access_the_data_in_google_sheets_step_eHchLA9.jpg
恭喜!您已完成 Access Google Finance data in Sheets 是,正在進行中
為你推薦
你對這個課程的評價為何?
你的意見可協助我們持續改進我們的課程!
要離開並失去進度嗎?
如果離開這個頁面,你將失去當前所完成的所有課程進度。確定要繼續並失去已完成的課程進度嗎?