GuruFocus is proud to announce that users can access a few premade templates for the new Google Sheets add-on, including the stock summary template that gives a snapshot of fundamental information about a company.
The stock summary template provides key information about the company, including its name, market sector, business predictability rank and a five-year historical price chart. The template also displays the company’s GF Score and its five component rankings: profitability rank, GF Value rank, momentum rank, financial strength rank and growth rank.
You can also access the templates directly within the add-on by clicking the “Templates” button in the GuruFocus Tools dashboard, as Figure 2 illustrates.
Make sure you save a local copy of the template before using the template. Click on the “File” menu and select “Make a copy,” as Figure 3 illustrates.
Enter the desired name of your copy and click the green “Make a copy” button to save a copy into your Google Drive. Figure 4 illustrates the “make a copy” wizard.
As Figure 5 illustrates, enter the stock ticker in Cell B9. Do not change the formulas in the other cells.