Precios Es posible que se requiera una compra adicional

Access Real-time stock price, fundamentals data and also historical data of all US public companies.
Via this Excel Add-in 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. In the Excel sheet ➤ click on FMP then ➤ click on FMP show taskpane under api key please enter your apikey that you get on https://financialmodelingprep.com/developer/docs/dashboard
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 =FMP.IncomeStatement("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
=FMP.FinancialStatementSymbolLists()
=FMP.IncomeStatement("AAPL",1)
=FMP.BalanceSheetStatement("AAPL",1)
=FMP.CashFlowStatement("AAPL",1)
=FMP.IncomeStatementAsReported("AAPL",1)
=FMP.IncomeStatementAsReported("AAPL",1)
=FMP.BalanceSheetStatementAsReported("AAPL",1)
=FMP.CashFlowStatementAsReported("AAPL",1)
=TRANSPOSE(fmpFinancialStatementFullAsReported("AAPL",1))
=FMP.FinancialStatements("AAPL","zip")
=FMP.FinancialReportsDates("AAPL",1)
=FMP.FinancialReportsJson("AAPL","2020","Q1")
=FMP.FinancialReportsXlsx("AAPL","2020","Q1")
=FMP.SharesFloat("AAPL")
=FMP.RssFeeds(1)
=FMP.RssFeedsV4(1)
=FMP.EarningCallTranscript("AAPL",2020,3)
=FMP.SecFilings("AAPL",1,"10-K")
STOCK FUNDAMENTALS ANALYSIS
=FMP.RatiosTtm("AAPL")
=FMP.Ratios("AAPL",1,2020)
=FMP.EnterpriseValues("AAPL",1)
=FMP.IncomeStatementGrowth("AAPL",1)
=FMP.KeyMetricsTtm("AAPL",1)
=FMP.KeyMetrics("AAPL",1)
=FMP.FinancialGrowth("AAPL",1)
=FMP.Rating("AAPL",1)
=FMP.HistoricalRating("AAPL",1)
=FMP.CompanyDiscountedCashFlow("AAPL",1)
=FMP.HistoricalDiscountedCashFlowStatement("AAPL",1)
=FMP.HistoricalDailyDiscountedCashFlow("AAPL",1)
STOCK CALENDARS
=FMP.EarningCalendar("2021-09-01","2021-09-01")
=FMP.HistoricalEarningCalendar("AAPL",1)
=FMP.IpoCalendar("2021-08-30","2021-09-01")
29/09/2021
=FMP.StockSplitCalendar(A67,B67)
=FMP.StockDividendCalendar(TODAY(),TODAY())
=FMP.EconomicCalendar(TODAY()-2,TODAY())
=FMP.EconomicCalendar(TODAY()-2,TODAY())
STOCK LOOK UP TOOL
=FMP.Search("AAPL",1)
=FMP.SearchTicker("AAPL",1)
=FMP.StockScreener(1)
=FMP.GetAllCountries()
COMPANY INFORMATION
=FMP.Profile("AAPL",1)
=FMP.KeyExecutives("AAPL")
=FMP.MarketCapitalization("AAPL")
=FMP.HistoricalMarketCapitalization("AAPL",1)
=TRANSPOSE(fmpCompanyOutlook("AAPL"))
=FMP.StockPeers("AAPL")
=FMP.IsTheMarketOpen()
=FMP.GetMarketHolidays()
=FMP.DelistedCompanies(1)
STOCK NEWS
=FMP.ArticlesInfo(1,1)
=FMP.Articles(1,1)
=FMP.StockNews("AAPL",1)
=FMP.PressReleases("AAPL",1)
MARKET PERFORMANCE
=FMP.SectorPriceEarningRatio("2021-09-27","NYSE")
=FMP.IndustryPriceEarningRatio("2021-09-27","NYSE")
=FMP.StockSectorsPerformance()
=FMP.HistoricalSectorsPerformance(1)
=FMP.Gainers()
=FMP.Losers()
=FMP.Actives()
ADVANCED DATA
=FMP.StandardIndustrialClassification("AAPL")
=FMP.StandardIndustrialClassificationList(3571)
=FMP.StandardIndustrialClassificationList(3571)
=FMP.CommitmentOfTradersReportList()
=FMP.CommitmentOfTradersReport(,"2021-09-14","2021-09-15")
=FMP.CommitmentOfTradersReportAnalysis(,"2021-09-14","2021-09-15")
STOCK STATISTICS
=FMP.SocialSentiment("AAPL",1)
=FMP.Grade("AAPL",1)
=FMP.EarningsSurprises("AAPL",1)
=FMP.AnalystEstimates("AAPL",1)
INSIDER TRADING
=FMP.InsiderTrading(,,"0001214156",1)
=FMP.MapperCikName("1118 ltd")
=FMP.MapperCikCompany("AAPL")
=FMP.InsiderTradingRssFeed(1)
=FMP.FailToDeliver("AAPL")
STOCK PRICE
=FMP.Quote("AAPL")
=FMP.QuoteShort("AAPL")
=FMP.Quotes("NYSE")
=FMP.HistoricalChart("AAPL","4hour", TODAY()-1)
=FMP.HistoricalPriceFull("AAPL",TODAY()-1)
=FMP.HistoricalPriceFullStockDividend("AAPL","2021-08-06","2021-08-06")
=FMP.HistoricalPriceFullStockSplit("AAPL","2020-08-31","2020-08-31")
=FMP.HistoricalPriceFullV4("AAPL","2020-08-31")
=FMP.TechnicalIndicator("AAPL","daily",TODAY())
FUND HOLDINGS
=FMP.EtfHolder("SPY")
=FMP.InstitutionalHolder("AAPL")
=FMP.MutualFundHolder("AAPL")
=FMP.EtfSectorWeightings("SPY")
=FMP.EtfCountryWeightings("SPY")
=FMP.CikList()
=FMP.CikSearch("apple")
=FMP.Cik("0001694461")
=FMP.FormThirteen("0001067983")
=FMP.FormThirteenDate("0001067983")
=FMP.Cusip("000360206")
=FMP.Cusip("000360206")
STOCK LIST
=FMP.StockList()
=FMP.AvailableTradedList()
=FMP.EtfList()
BULK AND BATCH
=FMP.BatchRequestEndOfDayPrices()
=FMP.IncomeStatementBulk()
=FMP.BalanceSheetStatementBulk()
=FMP.CashFlowStatementBulk()
=FMP.RatiosBulk()
=FMP.KeyMetricsBulk()
=FMP.EarningsSurprisesBulk()
=FMP.ProfileAll()
MARKET INDEXES
=FMP.Sp500Constituent()
=FMP.HistoricalSp500Constituent()
=FMP.NasdaqConstituent()
=FMP.DowjonesConstituent()
=FMP.HistoricalDowjonesConstituent()
=FMP.Symbol("available-indexes")
CRYPTO & FOREX & COMMODITIES
=FMP.Fx("EURUSD")
Funcionalidades de la aplicación
Cuando se usa esta aplicación,
- Puede leer el documento y hacer cambios
- Puede enviar datos por Internet
De un vistazo



By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's términos de uso and directiva de privacidad and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of términos is governed by separate privacidad and {4}.