FMP
Google Sheet Add-on
https://workspace.google.com/marketplace/app/financial_modeling_prep/262992176931Via this Google Sheets Add-on you will be able to query 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. As a reminder when entering a symbol don't forgot to add the quotation "" like for this function =fmpIncomeStatement("AAPL")
Get 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, enterprise value, financial growth, rating, company information and much more! We update our financial statements in real time, every statement is audited, standardized, and up to date. we cover the fundamental data part of the stocks via providing income statement, balance sheet statement and cash flow statement quarterly and annually. We have 1 minute, 15 minutes, 30 minutes, 1 hour and daily historical stock prices. list of functions:
STOCK FUNDAMENTALS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
=fmpFinancialStatementSymbolLists()
=fmpIncomeStatement("AAPL",1,"annual")
=fmpBalanceSheetStatement("AAPL",1,"quarterly")
=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 CALENDARS
1
2
3
4
5
6
7
8
9
10
=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
1
2
3
4
5
6
=fmpSearch("AAPL",1)
=fmpSearchTicker("AAPL",1)
=fmpStockScreener(1)
=fmpGetAllCountries()
COMPANY INFORMATION
1
2
3
4
5
6
7
8
9
10
11
=fmpProfile("AAPL",1)
=fmpKeyExecutives("AAPL")
=fmpMarketCapitalization("AAPL")
=fmpHistoricalMarketCapitalization("AAPL",1)
=TRANSPOSE(fmpCompanyOutlook("AAPL"))
=fmpStockPeers("AAPL")
=fmpIsTheMarketOpen()
=fmpGetMarketHolidays()
=fmpDelistedCompanies(1)
=fmpEnterpriseValue("AAPL")STOCK NEWS
1
2
3
4
5
=fmpArticlesInfo(1,1)
=fmpArticles(1,1)
=fmpStockNews("AAPL",1)
=fmpPressReleases("AAPL",1)MARKET PERFORMANCE
1
2
3
4
5
6
7
8
=fmpSectorPriceEarningRatio("2021-09-27","NYSE")
=fmpIndustryPriceEarningRatio("2021-09-27","NYSE")
=fmpStockSectorsPerformance()
=fmpHistoricalSectorsPerformance(1)
=fmpGainers()
=fmpLosers()
=fmpActives()ADVANCED DATA
1
2
3
4
5
6
7
=fmpStandardIndustrialClassification("AAPL")
=fmpStandardIndustrialClassificationList(3571)
=fmpStandardIndustrialClassificationList(3571)
=fmpCommitmentOfTradersReportList()
=fmpCommitmentOfTradersReport(,"2021-09-14","2021-09-15")
=fmpCommitmentOfTradersReportAnalysis(,"2021-09-14","2021-09-15")STOCK STATISTICS
1
2
3
4
5
=fmpSocialSentiment("AAPL",1)
=fmpGrade("AAPL",1)
=fmpEarningsSurprises("AAPL",1)
=fmpAnalystEstimates("AAPL",1)INSIDER TRADING
1
2
3
4
5
6
=fmpInsiderTrading(,,"0001214156",1)
=fmpMapperCikName("1118 ltd")
=fmpMapperCikCompany("AAPL")
=fmpInsiderTradingRssFeed(1)
=fmpFailToDeliver("AAPL")STOCK PRICE
1
2
3
4
5
6
7
8
9
10
=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
1
2
3
4
5
6
7
8
9
10
11
12
13
=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
1
2
3
4
=fmpStockList()
=fmpAvailableTradedList()
=fmpEtfList()BULK AND BATCH
1
2
3
4
5
6
7
8
9
=fmpBatchRequestEndOfDayPrices()
=fmpIncomeStatementBulk()
=fmpBalanceSheetStatementBulk()
=fmpCashFlowStatementBulk()
=fmpRatiosBulk()
=fmpKeyMetricsBulk()
=fmpEarningsSurprisesBulk()
=fmpProfileAll()MARKET INDEXES
1
2
3
4
5
6
7
8
=fmpSp500Constituent()
=fmpHistoricalSp500Constituent()
=fmpNasdaqConstituent()
=fmpDowjonesConstituent()
=fmpHistoricalDowjonesConstituent()
=fmpSymbol("available-indexes")
CRYPTO & FOREX & COMMODITIES
1
2
3
=fmpFx("EURUSD")
