In the computer world there are a large number of applications that allow us to track our money, one of them is Google finance developed by the technology giant, it will allow us to know the movement of our investments. Let’s take a deeper look at the following lines.
How to Use Google Finance and Create a Portfolio Easily? – Simple Guide
Index( )
- How many modalities does Google Finance have for evaluating my finances?
- summary mode
- fundamental mode
- performance mode
- What procedure should I follow to create my own portfolio on this platform?
- What are the best tools to analyze your portfolio?
- compare stocks
- Check coin performance
- View annual or quarterly reports
- Download information in a spreadsheet
- What programming languages can I use to get better results?
- Using Python
- with R language
How many modalities does Google Finance have for evaluating my finances?
The first thing you need to know is that Google Finance has three modalities available to observe how the market performs in the assets in which you have decided to invest, these are:
summary mode
As its name indicates, this option collects the most important aspects of the tool , in which you can view the basic information and performance of the actions in which we have invested, extreme values, as well as their value. So that we can make a decision to buy or sell our investment.
fundamental mode
The fundamental mode is a much more detailed look at our portfolio , in it you can see the extreme values in a given period of time (from 5 days to 1 lustrum), the value of each action (with an approximate delay of 30 min) , as well as the total capitalization and its variation.
performance mode
In this modality you can obtain a vision of the profits or losses of our investments , the value of the assets, as well as extend the analysis of the same to other periods of study.
What procedure should I follow to create my own portfolio on this platform?
Creating your own portfolio is very simple, on the google finance home page look for the section called ‘watchlists’, click on ‘My list’ and it will take you to the screen where you will have to add the actions you want to do Follow up by selecting the ‘+ Add Investments’ button.
In the search box that appears automatically you must place the name of the company, appearing the markets in which it is listed, select the market in which you have invested. Repeat this procedure until you complete all the available assets in your portfolio.
You can also follow currencies, cryptocurrencies and indices of the main markets worldwide, such as NASDAQ, LSEG, BOVESPA, IBEX 35, etc. You can create more than one portfolio by clicking on the ‘+New Watchlist’ button and customize it according to your investments.
What are the best tools to analyze your portfolio?
Having a portfolio and the values in which the shares oscillate is useless without proper analysis and tools that allow it to be done , such as:
compare stocks
You can compare the behavior of multiple actions, for this select one of which you want to compare, it will take you to the fundamental mode of the action where we observe a graph with the behavior over time.
Below which you will find a button with a magnifying glass icon that says ‘Compare with’ and select the indicator you want to compare with, it can be stocks, indices, currencies, etc. You can repeat this process as many times as values you want to compare.
Check coin performance
In the summary mode in the upper central part there is a ribbon , select ‘Currencies’ and the main currencies with which they are traded worldwide will automatically appear, select the one of your interest.
View annual or quarterly reports
Go to your portfolio and click on the asset for which you want the report and the fundamental mode of the same will appear. Look at the bottom for a section called ‘Financial performance’ there you can have a performance report, together with other indicators that will allow you to know the status of the asset under study.
Download information in a spreadsheet
In the case of google finance it is necessary to use google sheets and have basic knowledge in handling functions. In a cell we place the code that the program has established for the asset and the market in which it is listed, if you do not know how to obtain it in the search box in the fundamental way you can find it.
In the spreadsheet, place an asset code in a cell, in order to download any type of information it is necessary to use the ‘GoogleFinance’ function followed and between parentheses the name of the cell in which you have placed the asset identification.
If you want any particular data, either specific or in a period of time, there is a list of attributes that you can consult in the Google Sheet help when searching for the word ‘GoogleFinance’ and that will help you collect the desired information.
What programming languages can I use to get better results?
You can complement google finance by working with other programming languages that maximize analysis and optimize performance, these are:
Using Python
This computer program has become very famous in recent years for its use in high-level activities such as neural networks and the banking sector, its simple syntax, great computing power allow it to anticipate trends in financial markets, calculate patterns of risk, among other activities.
These actions will help you make better decisions when investing your money. The mass of its use is such that libraries are constantly being published on the web that will allow you to adjust the processing of your financial assets and customize them according to your needs.
with R language
The R language enjoys popularity in big data applications, for processing large volumes of statistical data at high speed, which in the case of financial operations is usually very helpful.
It is an open source language that allows access to the source code and that the community is continuously generating blocks and improvements every day, much more precise than excel sheets and that can present high-quality graphics in both 2D and 3D.
