As a GuruFocus Premium Member, you can now use GuruFocus API and Excel Add-in. These features make it very easy to do fully customized research, charting and calculation in Excel and other applications.
GuruFocus API and Excel Add-in are now available to both Premium Members and PremiumPLUS members. You can pull these data from GuruFocus API and Excel Add-in:
- Company Financials up to 20 years of annual data and 80 quarters of quarterly data.
- Historical price data - split adjusted.
- Stock summary data including latest price changes and ratios
- Guru trades for specific companies
- Insider trades for specific companies
- Guru list
- Guru stock picks
- Aggregated portfolio
Additionally with Excel Add-in, you can easily construct new portfolios, track your real portfolios in Excel, get price updates, the valuation ratios and fundamental data.
Update (Aug. 20, 2015):
- The number of queries allowed per month is 2,000 for Premium Members, and 20,000 for PremiumPLUS members.
- Samples are now available for PHP, JAVA, C#m Python, and Google Spreadsheet
Premium Members and PremiumPLUS members have different limits of queries allowed for the applications. If you are not a Premium Member, we invite you for a 7-day Free Trial. If you consider yourself a heavy user of API and Excel Add-in, PremiumPLUS will be a better option for you.