| name | integrations |
| description | Use when user requests data from financial data providers (Bloomberg, FactSet, Capital IQ, Refinitiv, Morningstar, PitchBook, Preqin, AlphaSense). Each provider has specific Excel formula syntax. |
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 formulasfactset.md - FDS formulas with FF_, FG_, FE_ prefixescapiq.md - CIQ formulas with IQ_ variablesrefinitiv.md - RDP.Data, TR, DSGRID formulasmorningstar.md - MSDP, MSTS, MSHOLDING formulaspitchbook.md - PB, PBMATCH formulas for private marketspreqin.md - Alternative assets data (PE, VC, Real Estate)alphasense.md - TEGUS formulas and AI-powered researchearnings_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:
P price, MV market value, WC01001 revenue
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
