Fully customizable investing research and analysis tools
应用详情更新日期:2024年11月27日
适用于:
2462+
概览
GuruFocus Add-on for Google Sheets provides a fully-customizable investing research and analysis add-on that allows users to pull up to 30 years of historical financial data on over 90,000 stocks from regions around the globe.

Users can also access several pre-built templates that output fundamental data and a wide range of metrics measuring financial strength, profitability, valuation, growth and momentum.

Download the templates below:
https://drive.google.com/drive/folders/1f-uK_5VJvLffk1fXJqE7oxeDulMVkOAY

Powerful GURUF function

The GURUF function works with common Google Sheets functions like SUM, AVERAGE and COUNT that allow for deeper analysis on the data. One click refreshes the data, allowing users to retrieve GuruFocus data without leaving the Google Sheets.

Examples:

=GURUF(“AAPL”,”Price”) gives Apple’s current price.

=GURUF(“AAPL”,”Revenue”,”-15”,”A”) gives Apple’s revenue over the past 15 years.

=GURUF(“AAPL”,”Net Income”,”2021”,”Q”) gives Apple’s net income for each quarter in 2021.

=GURUF(“AAPL”,”Total Assets”,”2010:2020”,”A”) gives Apple’s total assets for each year from 2010 to 2020.

Stock Summary Template

GuruFocus Tools Stock Summary Template retrieves a snapshot of a company’s fundamental data, including the GF Score and its five ranking components: financial strength, profitability, growth, valuation and momentum.

30-year Historical Financials Data Template

GuruFocus Tools Historical Financial Data Template retrieves up to 30 years of historical per share data, ratios, income statement, balance sheet, cash flow statement, valuation ratios and quality metrics.

DCF Calculator Template

GuruFocus DCF Calculator Template gives a company’s intrinsic value based on a two-stage discount free cash flow or discount earnings model.

Keywords:
Invest, Investment, Investor, Stocks, Financials
其他信息
定价免费试用
开发者
GuruFocus Add-on for Sheets”将请求获得以下权限。了解详情
GuruFocus Add-on for Sheets”将需要访问您的 Google 账号
这样可让GuruFocus Add-on for Sheets
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
将您与您在 Google 上的个人信息关联起来
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
Profile Picture
陈涛(网遐)
2022年4月10日
Very useful for my investment.
此评价对您有帮助吗?
1-1 / 1
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单