FMP
Enter
API Tools
Excel Add-on
For Excel 365 and more recent Excel versions:
https://appsource.microsoft.com/en-us/product/office/WA200003535?src=officeFor 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
List of functions:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
=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")
