Record Details

Finsheet - Stock Price in Excel and Google Sheet

Harvard Dataverse (Africa Rice Center, Bioversity International, CCAFS, CIAT, IFPRI, IRRI and WorldFish)

View Archive Info
 
 
Field Value
 
Title Finsheet - Stock Price in Excel and Google Sheet
 
Identifier https://doi.org/10.7910/DVN/ZD9XVF
 
Creator Do, Tuan
 
Publisher Harvard Dataverse
 
Description This dataset contains the valuation template the researcher can use to retrieve real-time Excel stock price and stock price in Google Sheets. The dataset is provided by Finsheet, the leading financial data provider for spreadsheet users.

To get more financial data, visit the website and explore their function. For instance, if a researcher would like to get the last 30 years of income statement for Meta Platform Inc, the syntax would be

=FS_EquityFullFinancials("FB", "ic", "FY", 30)

In addition, this syntax will return the latest stock price for Caterpillar Inc right in your spreadsheet.

=FS_Latest("CAT")

If you need assistance with any of the function, feel free to reach out to their customer support team. To get starter, install their Excel and Google Sheets add-on.
 
Subject Business and Management
excel stock price
stock price google sheets
 
Contributor Do, Tuan