SKILL.md
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","IQTOTALREV",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("AAPLUS","MORIS_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:
PXLAST,PXVOLUME,CURMKTCAP - Fundamentals:
SALESREVTURN,EBITDA,NETINCOME,ISEPS - Ratios:
PERATIO,EVTOT12MEBITDA,RETURNCOMEQY
FactSet
- Pricing:
FGPRICE,FGMKT_VAL - Fundamentals:
FFSALES,FFEBITDA,FFNETINCOME,FF_EPS - Estimates:
FE_ESTIMATE(EPS,MEAN,ANN,+1)
Capital IQ
- Core:
IQTOTALREV,IQEBITDA,IQNI,IQDILUTEPS_INCL - Market:
IQMARKETCAP,IQTEV - Periods:
IQFY,IQLTM, or numeric codes (1000=FY, 999=prior FY)
Refinitiv
- Real-time:
CFLAST,CFBID,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:
MORISREV,MORISEBITDA,MORISNET_INC - Balance:
MORBSTOTALASSETS,MORBSTOTALDEBT - Cash Flow:
MORCFCFO,MORCFFCF
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