We have now an excel add on on the microsoft store:
https://appsource.microsoft.com/en-us/product/office/WA200003535?src=office

For Excel 360 and more recent Excel versions:


1. save the attached "manifest.xml" to your local drive

2. open the file below in the Excel Online (you should be signed in) or desktop Excel 365

3. call menu Insert, select Office Add-ins in the toolbar, upload My Add-in, press Browse, select downloaded "manifest.xml", press Upload

4. call menu Home, select FMP Show Taskpane in the toolbar

5. enter your FMP API key

6. enter 3 in the input below

7. press Save

8. find the formula =FMP.FX(B1) refreshed every 3 second


The manifest file to download: manifest.xml


Open an Excel workbook and Go to Developer –> Add-ins –> Excel Add-ins.


In the Add-ins dialogue box, browse and locate the file that you saved, and click OK.

Now the add-in has been activated.


The file to download is: FMP_v1.0.1


And some visual explanation for the installation: Click here


List of functions:


=FMP.FINANCIALSTATEMENTSYMBOLLISTS()
=FMP.INCOMESTATEMENT(A$1,1)
=FMP.BALANCESHEETSTATEMENT(A$1,1)
=FMP.CASHFLOWSTATEMENT(A$1,1)
=FMP.INCOMESTATEMENT(A$1,1)
=FMP.INCOMESTATEMENTASREPORTED(A$1,1)
=FMP.BALANCESHEETSTATEMENTASREPORTED(A$1,1)
=FMP.CASHFLOWSTATEMENTASREPORTED(A$1,1)
=TRANSPOSE( FMP.FINANCIALSTATEMENTFULLASREPORTED(A$1,1))
=FMP.FINANCIALSTATEMENTS(A$1,"zip")
=FMP.FINANCIALREPORTSDATES(A$1)
=FMP.FINANCIALREPORTSJSON(A$1,"2020","Q1")
=FMP.FINANCIALREPORTSXLSX(A$1,"2020","Q1")
=FMP.SHARESFLOAT(A$1)
=FMP.RSSFEEDS(1)
=FMP.RSSFEEDSV4(1)
=FMP.EARNINGCALLTRANSCRIPT(A$1,2020,3)
=FMP.SECFILINGS(A$1,1,"10-K")
=FMP.RATIOSTTM(A$1)
=FMP.RATIOS(A$1,1,2020)
=FMP.ENTERPRISEVALUES(A$1,1)
=FMP.INCOMESTATEMENTGROWTH(A$1,1)
=FMP.KEYMETRICSTTM(A$1,1)
=FMP.KEYMETRICS(A$1,1)
=FMP.FINANCIALGROWTH(A$1,1)
=FMP.RATING(A$1)
=FMP.HISTORICALRATING(A$1,1)
=FMP.COMPANYDISCOUNTEDCASHFLOW(A$1)
=FMP.HISTORICALDISCOUNTEDCASHFLOWSTATEMENT(A$1,1)
=FMP.HISTORICALDAILYDISCOUNTEDCASHFLOW(A$1,1)
=FMP.EARNINGCALENDAR("2021-09-01","2021-11-01")
=FMP.HISTORICALEARNINGCALENDAR(A$1,1)
=FMP.IPOCALENDAR("2021-08-30","2021-09-01")
12/10/2021
=FMP.STOCKSPLITCALENDAR(B67,B67)
=FMP.STOCKDIVIDENDCALENDAR(TODAY(),TODAY())
=FMP.ECONOMICCALENDAR(TODAY()-2,TODAY())
=FMP.ECONOMICCALENDAR(TODAY()-2,TODAY())
=FMP.SEARCH(A$1,1)
=FMP.SEARCHTICKER(A$1,1)
=FMP.STOCKSCREENER(1)
=FMP.GETALLCOUNTRIES()
=FMP.PROFILE(A$1)
=FMP.KEYEXECUTIVES(A$1)
=FMP.MARKETCAPITALIZATION(A$1)
=FMP.HISTORICALMARKETCAPITALIZATION(A$1,1)
=TRANSPOSE(FMP.COMPANYOUTLOOK(A$1))
=FMP.STOCKPEERS(A$1)
=FMP.ISTHEMARKETOPEN()
=FMP.GETMARKETHOLIDAYS()
=FMP.DELISTEDCOMPANIES(1)
=FMP.ARTICLESINFO(1,1)
=FMP.ARTICLES(1,1)
=FMP.STOCKNEWS(A$1,1)
=FMP.PRESSRELEASES(A$1,1)
=FMP.SECTORPRICEEARNINGRATIO("2021-09-27","NYSE")
=FMP.INDUSTRYPRICEEARNINGRATIO("2021-09-27","NYSE")
=FMP.STOCKSECTORSPERFORMANCE()
=FMP.HISTORICALSECTORSPERFORMANCE(1)
=FMP.GAINERS()
=FMP.LOSERS()
=FMP.ACTIVES()
=FMP.STANDARDINDUSTRIALCLASSIFICATION(A$1)
=FMP.STANDARDINDUSTRIALCLASSIFICATIONLIST(3571)
=FMP.COMMITMENTOFTRADERSREPORTLIST()
=FMP.COMMITMENTOFTRADERSREPORT("","2021-09-14","2021-09-15")
=FMP.COMMITMENTOFTRADERSREPORTANALYSIS(,"2021-09-14","2021-09-15")
=FMP.SOCIALSENTIMENT(A$1,1)
=FMP.GRADE(A$1,1)
=FMP.EARNINGSSURPRISES(A$1,1)
=FMP.ANALYSTESTIMATES(A$1,1)
AAPL
=FMP.INSIDERTRADING(B141,,D141,E141,F141)
=FMP.INSIDERTRADINGTRANSACTIONTYPE()
=FMP.MAPPERCIKNAME("1118 ltd")
=FMP.MAPPERCIKCOMPANY(A$1)
=FMP.INSIDERTRADINGRSSFEED(1)
=FMP.FAILTODELIVER(A$1)
=FMP.QUOTE(A$1)
=FMP.QUOTESHORT(A$1)
=FMP.QUOTES("NYSE")
=FMP.HISTORICALCHART(A$1,"4hour", TODAY()-1)
=FMP.HISTORICALPRICEFULL(A$1,TODAY()-1)
=FMP.HISTORICALPRICEFULLSTOCKDIVIDEND(A$1,"2021-08-06","2021-08-06")
=FMP.HISTORICALPRICEFULLSTOCKSPLIT(A$1,"2020-08-31","2020-08-31")
=FMP.HISTORICALPRICEFULLV4(A$1,"2020-08-31")
=FMP.TECHNICALINDICATOR(A$1,"daily",TODAY()-3)
=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.STOCKLIST()
=FMP.AVAILABLETRADEDLIST()
=FMP.ETFLIST()
=FMP.BATCHREQUESTENDOFDAYPRICES()
=FMP.INCOMESTATEMENTBULK()
=FMP.BALANCESHEETSTATEMENTBULK()
=FMP.CASHFLOWSTATEMENTBULK()
=FMP.RATIOSBULK()
=FMP.KEYMETRICSBULK()
=FMP.EARNINGSSURPRISESBULK()
=FMP.PROFILEALL()
=FMP.SP500CONSTITUENT()
=FMP.HISTORICALSP500CONSTITUENT()
=FMP.NASDAQCONSTITUENT()
=FMP.DOWJONESCONSTITUENT()
=FMP.HISTORICALDOWJONESCONSTITUENT()
=FMP.SYMBOL("available-indexes")
=FMP.FX("EURUSD")