{"id":2630,"date":"2020-10-08T11:38:48","date_gmt":"2020-10-08T09:38:48","guid":{"rendered":"https:\/\/importsheet.com\/?p=2630"},"modified":"2025-12-17T23:38:29","modified_gmt":"2025-12-17T22:38:29","slug":"formula-do-googlefinance-planilhas-do-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/googlefinance-formula-google-sheets\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o GOOGLEFINANCE no Planilhas Google"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The <\/span>GOOGLEFINANCE function<\/span><\/a> allows you to import real-time financial and currency market data straight into Google Sheets. It also enables you to track current and historical data for various financial instruments, such as stocks and shares.<\/span><\/p>\n

This function imports data from the <\/span>Google Finance<\/span><\/a> web application. This Google tool provides daily stock prices, financial markets news, and analysis of market trends. Google Finance can be accessed from the Google menu like all other Google applications. Alternatively, if you search for a stock on Google, the first result will show you information from Google Finance.<\/span><\/p>\n

If analysts wanted to gather information on a stock, they would have to visit a financial website or database to access a range of information. After carrying out research, the next step was to compile all that relevant stock information into a spreadsheet for further analysis.<\/span><\/p>\n

This involved the analyst copying the stock information from the website and pasting it into a spreadsheet. An alternative was to use customized scripts to scrape this information from the web. The first approach is cumbersome, unreliable, and definitely not recommended. And the second method is faster, but it also has drawbacks. Getting a coder to write a script is expensive, time consuming, and not very flexible.<\/span><\/p>\n

A more reliable and economic alternative to both options is the GOOGLEFINANCE spreadsheet function. If you work with financial market data, this function can automate data retrieval to save you serious time.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”syntax” _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Syntax<\/h2>\n

[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

=GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])<\/span><\/strong><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n