Financial Data Provider Integrations
Overview
This skill provides Excel formula syntax for major financial data providers. Only pull data when the user explicitly requests a specific provider.
Each provider has its own markdown file with complete documentation:
- •
bloomberg.md- BDP, BDH, BDS formulas - •
factset.md- FDS formulas with FF_, FG_, FE_ prefixes - •
capiq.md- CIQ formulas with IQ_ variables - •
refinitiv.md- RDP.Data, TR, DSGRID formulas - •
morningstar.md- MSDP, MSTS, MSHOLDING formulas - •
pitchbook.md- PB, PBMATCH formulas for private markets - •
preqin.md- Alternative assets data (PE, VC, Real Estate) - •
alphasense.md- TEGUS formulas and AI-powered research - •
earnings_transcripts.md- Transcript access across providers
Quick Reference
| Provider | Formula | Ticker Format | Example |
|---|---|---|---|
| Bloomberg | =BDP(), =BDH(), =BDS() | AAPL US Equity | =BDP("AAPL US Equity","PX_LAST") |
| FactSet | =FDS() | AAPL-US | =FDS("AAPL-US","FF_SALES(ANN,0Y)") |
| Capital IQ | =CIQ() | AAPL | =CIQ("AAPL","IQ_TOTAL_REV",IQ_FY) |
| Refinitiv | =RDP.Data(), =TR() | AAPL.O | =TR("AAPL.O","CF_LAST") |
| Morningstar | =MSDP(), =MSTS() | VFIAX or NAS:AAPL | =MSDP("VFIAX","MorningstarRating") |
| PitchBook | =PB() | Name or PBID | =PB("SpaceX","PostMoneyValuation") |
| AlphaSense | =TEGUS.CD() | AAPL_US | =TEGUS.CD("AAPL_US","MO_RIS_REV","FY-2023") |
Workflow
- •Identify provider - User must explicitly mention which provider to use
- •Read the provider's markdown file - Each has complete syntax reference
- •Write formulas - Use cell references for tickers when possible
- •Verify outputs - Gut check values make intuitive sense
- •Handle errors - Check syntax if formulas return errors
Common Data Points by Provider
Bloomberg
- •Price:
PX_LAST,PX_VOLUME,CUR_MKT_CAP - •Fundamentals:
SALES_REV_TURN,EBITDA,NET_INCOME,IS_EPS - •Ratios:
PE_RATIO,EV_TO_T12M_EBITDA,RETURN_COM_EQY
FactSet
- •Pricing:
FG_PRICE,FG_MKT_VAL - •Fundamentals:
FF_SALES,FF_EBITDA,FF_NET_INCOME,FF_EPS - •Estimates:
FE_ESTIMATE(EPS,MEAN,ANN,+1)
Capital IQ
- •Core:
IQ_TOTAL_REV,IQ_EBITDA,IQ_NI,IQ_DILUT_EPS_INCL - •Market:
IQ_MARKETCAP,IQ_TEV - •Periods:
IQ_FY,IQ_LTM, or numeric codes (1000=FY, 999=prior FY)
Refinitiv
- •Real-time:
CF_LAST,CF_BID,CF_ASK - •Historical:
TR.Revenue,TR.EBITDA,TR.NetIncome - •Datastream:
Pprice,MVmarket value,WC01001revenue
Morningstar
- •Fund:
MorningstarRating,ExpenseRatio,NAV_daily - •Returns:
ReturnY1,ReturnY3,ReturnY5 - •Stock:
FairValue,EconomicMoat
PitchBook
- •Valuation:
PostMoneyValuation,PreMoneyValuation - •Funding:
TotalFundingRaised,LastFundingAmount,LastFundingType
AlphaSense (Tegus)
- •Income:
MO_RIS_REV,MO_RIS_EBITDA,MO_RIS_NET_INC - •Balance:
MO_RBS_TOTAL_ASSETS,MO_RBS_TOTAL_DEBT - •Cash Flow:
MO_RCF_CFO,MO_RCF_FCF
Best Practices
- •Always verify - Formulas should not return errors
- •Gut check values - Numbers should make intuitive sense
- •Use cell references - For tickers and periods, not hardcoded values
- •Be aware of limits - Bloomberg and others have monthly download caps
- •Check units - Know if values are in thousands, millions, or actual
Period Notation Summary
| Provider | Current FY | Prior FY | LTM | Quarter |
|---|---|---|---|---|
| Bloomberg | [FY0] | [FY-1] | [TTM] | [FQ0] |
| FactSet | ANN,0Y | ANN,-1Y | LTM | QTR,0Q |
| Capital IQ | IQ_FY or 1000 | 999 | IQ_LTM | IQ_FQ or 500 |
| Refinitiv | Period=FY0 | Period=FY-1 | Period=LTM | Period=FQ0 |
| AlphaSense | FY-2023 | FY-2022 | LTM | Q1-2024 |
Error Handling
If formulas return errors:
- •Check ticker format matches provider's expected format
- •Verify field/variable name spelling
- •Check period syntax
- •Try refreshing the add-in
- •Confirm data coverage for that security