Access Real-time stock price, fundamentals data and also historical data such as income statement, balance sheet statement and cashflow statement quarterly and annually.
Listing updated:March 23, 2024
Works with:
3K+
Overview
Via this Google Sheets Add-on you will be able to querying Financial Modeling Prep market data. 


GETTING STARTED

Get started in a few easy steps after installing the Financial Modeling Prep Add-on:

1. Get the API key by signing up to the Financial Modeling Prep ➤ https://financialmodelingprep.com/developer/docs.
2. Paste your API key in the Add-ons ➤ Financial Modeling Prep ➤ Settings.
3. Start exploring our Add on!
4. Ad a reminder when entering a symbol don't forgot to add the quotation "" like for this function =fmpIncomeStatement("AAPL")

Get are accurate financial data information in no time.To make it simple you will be able to access stocks price and historical data, stock fundamentals, Annual report 10-K and 10-Q, all SEC filings, financial ratios, enteprise value, financial growth, rating, company information and much more!

We update our financial statements in real time, every statements is audited, standardized, and up to date.

we cover the fundamental data part of the stocks via providing income statement, balance sheet statement and cashflow statement quarterly and annually.

We have 1 minute, 15 minutes, 30 minutes, 1 hour and daily historical stock prices.

list of functions:

STOCK FUNDAMENTALS

=fmpFinancialStatementSymbolLists()

=fmpIncomeStatement("AAPL",1)

=fmpBalanceSheetStatement("AAPL",1)

=fmpCashFlowStatement("AAPL",1)

=fmpIncomeStatementAsReported("AAPL",1)

=fmpIncomeStatementAsReported("AAPL",1)

=fmpBalanceSheetStatementAsReported("AAPL",1)

=fmpCashFlowStatementAsReported("AAPL",1)

=TRANSPOSE(fmpFinancialStatementFullAsReported("AAPL",1))

=fmpFinancialStatements("AAPL","zip")

=fmpFinancialReportsDates("AAPL",1)

=fmpFinancialReportsJson("AAPL","2020","Q1")

=fmpFinancialReportsXlsx("AAPL","2020","Q1")

=fmpSharesFloat("AAPL")

=fmpRssFeeds(1)

=fmpRssFeedsV4(1)

=fmpEarningCallTranscript("AAPL",2020,3)

=fmpSecFilings("AAPL",1,"10-K")

STOCK FUNDAMENTALS ANALYSIS

=fmpRatiosTtm("AAPL")

=fmpRatios("AAPL",1,2020)

=fmpEnterpriseValues("AAPL",1)

=fmpIncomeStatementGrowth("AAPL",1)

=fmpKeyMetricsTtm("AAPL",1)

=fmpKeyMetrics("AAPL",1)

=fmpFinancialGrowth("AAPL",1)

=fmpRating("AAPL",1)

=fmpHistoricalRating("AAPL",1)

=fmpCompanyDiscountedCashFlow("AAPL",1)

=fmpHistoricalDiscountedCashFlowStatement("AAPL",1)

=fmpHistoricalDailyDiscountedCashFlow("AAPL",1)

STOCK CALENDARS

=fmpEarningCalendar("2021-09-01","2021-09-01")

=fmpHistoricalEarningCalendar("AAPL",1)

=fmpIpoCalendar("2021-08-30","2021-09-01")
29/09/2021
=fmpStockSplitCalendar(A67,B67)

=fmpStockDividendCalendar(TODAY(),TODAY())

=fmpEconomicCalendar(TODAY()-2,TODAY())

=fmpEconomicCalendar(TODAY()-2,TODAY())


STOCK LOOK UP TOOL

=fmpSearch("AAPL",1)

=fmpSearchTicker("AAPL",1)

=fmpStockScreener(1)

=fmpGetAllCountries()

COMPANY INFORMATION

=fmpProfile("AAPL",1)

=fmpKeyExecutives("AAPL")

=fmpMarketCapitalization("AAPL")

=fmpHistoricalMarketCapitalization("AAPL",1)

=TRANSPOSE(fmpCompanyOutlook("AAPL"))

=fmpStockPeers("AAPL")

=fmpIsTheMarketOpen()

=fmpGetMarketHolidays()

=fmpDelistedCompanies(1)

STOCK NEWS

=fmpArticlesInfo(1,1)

=fmpArticles(1,1)

=fmpStockNews("AAPL",1)

=fmpPressReleases("AAPL",1)

MARKET PERFORMANCE

=fmpSectorPriceEarningRatio("2021-09-27","NYSE")

=fmpIndustryPriceEarningRatio("2021-09-27","NYSE")

=fmpStockSectorsPerformance()

=fmpHistoricalSectorsPerformance(1)

=fmpGainers()

=fmpLosers()

=fmpActives()

ADVANCED DATA

=fmpStandardIndustrialClassification("AAPL")

=fmpStandardIndustrialClassificationList(3571)

=fmpStandardIndustrialClassificationList(3571)

=fmpCommitmentOfTradersReportList()

=fmpCommitmentOfTradersReport(,"2021-09-14","2021-09-15")

=fmpCommitmentOfTradersReportAnalysis(,"2021-09-14","2021-09-15")

STOCK STATISTICS

=fmpSocialSentiment("AAPL",1)

=fmpGrade("AAPL",1)

=fmpEarningsSurprises("AAPL",1)

=fmpAnalystEstimates("AAPL",1)

INSIDER TRADING

=fmpInsiderTrading(,,"0001214156",1)

=fmpMapperCikName("1118 ltd")

=fmpMapperCikCompany("AAPL")

=fmpInsiderTradingRssFeed(1)

=fmpFailToDeliver("AAPL")

STOCK PRICE

=fmpQuote("AAPL")

=fmpQuoteShort("AAPL")

=fmpQuotes("NYSE")

=fmpHistoricalChart("AAPL","4hour", TODAY()-1)

=fmpHistoricalPriceFull("AAPL",TODAY()-1)

=fmpHistoricalPriceFullStockDividend("AAPL","2021-08-06","2021-08-06")

=fmpHistoricalPriceFullStockSplit("AAPL","2020-08-31","2020-08-31")

=fmpHistoricalPriceFullV4("AAPL","2020-08-31")

=fmpTechnicalIndicator("AAPL","daily",TODAY())

FUND HOLDINGS

=fmpEtfHolder("SPY")

=fmpInstitutionalHolder("AAPL")

=fmpMutualFundHolder("AAPL")

=fmpEtfSectorWeightings("SPY")

=fmpEtfCountryWeightings("SPY")

=fmpCikList()

=fmpCikSearch("apple")

=fmpCik("0001694461")

=fmpFormThirteen("0001067983")

=fmpFormThirteenDate("0001067983")

=fmpCusip("000360206")

=fmpCusip("000360206")

STOCK LIST

=fmpStockList()

=fmpAvailableTradedList()

=fmpEtfList()

BULK AND BATCH

=fmpBatchRequestEndOfDayPrices()

=fmpIncomeStatementBulk()

=fmpBalanceSheetStatementBulk()

=fmpCashFlowStatementBulk()

=fmpRatiosBulk()

=fmpKeyMetricsBulk()

=fmpEarningsSurprisesBulk()

=fmpProfileAll()

MARKET INDEXES

=fmpSp500Constituent()

=fmpHistoricalSp500Constituent()

=fmpNasdaqConstituent()

=fmpDowjonesConstituent()

=fmpHistoricalDowjonesConstituent()

=fmpSymbol("available-indexes")

CRYPTO & FOREX & COMMODITIES

=fmpFx("EURUSD")




Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Financial Modeling Prep will ask for the permissions shown below. Learn more
Financial Modeling Prep will need access to your Google account
This will allow Financial Modeling Prep to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Ahamed Azry
April 8, 2024
Great app to manage our stock related matters at the same time global exchange. This app can be used by any of the investor who wishes to use it with any of the knowledge about using this.
Is this review helpful?
Yes
No
Profile Picture
Abdulfatai Adeiza Jimoh
December 7, 2022
I have identified features and services that customers have been asking for, creating a roadmap to introduce those features, and keeping customers updated about future feature releases to make sure they don’t cancel their subscriptions. I loved working with my teammates. Adjusting to new work environments can sometimes be a challenge, but I soon found myself settling in. I discovered immense value in collaborating with my teammates, getting their feedback on my work, and getting exposed to new insights and viewpoints. Working on this project has allowed me to rediscover my passion and life goals. I’ve thoroughly enjoyed working in an environment that conforms to my ideals and where I feel comfortable expressing myself and becoming the best version of myself.
Is this review helpful?
Yes
No
Profile Picture
samuel fahmy
August 30, 2023
Great coverage for many stocks and global exchanges. They have a great depth of data with high quality and easy to use API
Is this review helpful?
Yes
No
Profile Picture
Marcio Maia
September 30, 2022
Google Sheet documentation is outdated and nothing worked. I touched base with the chat support and they never replied. Waste of time, uninstalled...
Is this review helpful?
Yes
No
Profile Picture
Sydney Griffin
August 20, 2022
stupid addon, API key invalid doesn't work, and there are no directions to use this addon??????????
Is this review helpful?
Yes
No
Profile Picture
SIEGFRED REDOBLE
October 13, 2021
I am not very good with API but this add-on has been perfect for me and helped me access the data I needed. Keep up the great work!
Is this review helpful?
Yes
No
1-6 of 6
Search
Clear search
Close search
Google apps
Main menu