contador web Saltar al contenido

How to use Google Finance data in an Excel spreadsheet | Productivity

Google allows you to easily import financial data into a spreadsheet and generate an Excel file. The procedure takes place through the command that triggers Google Finance, an extension of Chrome that provides the user with information about the financial market. Using some shortcuts, it is possible to create comparative tables and consult public databases to search the history of stock quotes, exchange rates and other assets.

It is also possible to visualize the evolution of the dollar and make the most varied calculations, including depreciation, deadline for settlement, among others. Next, see how to create the document and download it to your computer.

#FiqueEmCasa: tips and news help you stop the coronavirus

1 of 10
See how to use Google Finance data in a spreadsheet Photo: Paulo Alves / TechTudo

See how to use Google Finance data in a spreadsheet Photo: Paulo Alves / TechTudo

Want to buy cell phones, TV and other discounted products? Meet Compare TechTudo

See also: How to customize an Excel spreadsheet

How to customize an Excel spreadsheet

How to customize an Excel spreadsheet

Step 1. Go to Google Sheets (sheets.google.com) and open a new spreadsheet online;

2 of 10
Create a spreadsheet on Google Photo: Reproduo / Paulo Alves

Create a spreadsheet on Google Photo: Reproduo / Paulo Alves

Step 2. Enter a title for the spreadsheet and reserve the second row for the desired data. It is possible, for example, to obtain the price variation of a given steel. To do this, type = in a cell and paste the formula "GOOGLEFINANCE (ticker; (attribute); (start_date); (end_date | num_days); (interval))" (without quotes);

3 of 10
Use the Google Finance command to import stock and exchange data Photo: Reproduo / Paulo Alves

Use the Google Finance command to import stock and exchange data Photo: Reproduo / Paulo Alves

Step 3. Replace ticker with the name of the desired stock and the exchange on which it is traded. Shares in Silicon Valley technology companies are traded on Nasdaq. To search for Google shares, I need to type NASDAQ: GOOG. Bovespa BVMF ticker;

4 of 10
Start by pointing out the bag and the action to be analyzed Photo: Reproduo / Paulo Alves

Start by pointing out the bag and the action to be analyzed Photo: Reproduo / Paulo Alves

Step 4. As the search will be on price, replace attribute with the term price. Other attributes include high or low on the day, trading volume, market value, variation since the previous price and several others. The commands are available on the Google support page (support.google.com/docs/answer/3093281);

5 out of 10
Select the attribute to be analyzed, such as price Photo: Reproduo / Paulo Alves

Select the attribute to be analyzed, such as price Photo: Reproduo / Paulo Alves

Step 5. Replace start date and end date with the start and end dates of the analysis in the date format (year; month; day). To search from January 1, 2000 to December 31, 2019, type: date (2000; 1; 1); date (2019; 12; 31);

6 out of 10
Enter the start and end dates of the analysis Photo: Reproduo / Paulo Alves

Enter the start and end dates of the analysis Photo: Reproduo / Paulo Alves

Step 6. In Interval, add the periodicity when the spreadsheet will show the quotes. To show daily values, type daily;

7 out of 10
Set the data collection interval Photo: Reproduo / Paulo Alves

Set the data collection interval Photo: Reproduo / Paulo Alves

Step 7. When pressing Enter, the spreadsheet will import the data from Google Finance and create a table with all the closing prices of the stocks surveyed every day within the stipulated period;

8 out of 10
Spreadsheet shows values ??according to Google Finance Photo: Reproduo / Paulo Alves

Spreadsheet shows values ??according to Google Finance Photo: Reproduo / Paulo Alves

Step 8. To create a graph with this information, just select the columns and go to the Insert> Graph menu;

9 out of 10
Add a chart with the imported data Photo: Reproduo / Paulo Alves

Add a chart with the imported data Photo: Reproduo / Paulo Alves

Step 9. Finally, I just need to download the material in Excel format. To do this, tap File and select the option Download> Microsoft Excel.

10 of 10
Download the spreadsheet in Excel format Photo: Reproduo / Paulo Alves

Download the spreadsheet in Excel format Photo: Reproduo / Paulo Alves